CREATE TABLE admin_users
(
	[id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[creation_timestamp] datetime not null,
	[created_by_id] int not null,
	[name] varchar(100) NOT NULL,
	[mobile] varchar(20) NULL,
	[email] varchar(50) NOT NULL,
	[password] varchar(50) NOT NULL,
	[role] varchar(10) NOT NULL,
	[deleted] bit NOT NULL,
	[deleted_timestamp] datetime NULL,
	[deleted_by_id] int NULL,
	[status] bit NOT NULL,
	CONSTRAINT [unique_admin_users_email] UNIQUE ([email]),
	CONSTRAINT [unique_admin_users_mobile] UNIQUE ([mobile]),
	CONSTRAINT [fk_admin_users_created_by] FOREIGN KEY ([created_by_id]) REFERENCES [admin_users] ([id]) 
)

CREATE TABLE gallary_albums
(
	[id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[creation_timestamp] datetime not null,
	[created_by_id] int not null,
	[name] varchar(100) NOT NULL,
	[deleted] bit NOT NULL,
	[deleted_timestamp] datetime NULL,
	[deleted_by_id] int NULL,
	[status] bit NOT NULL,
	CONSTRAINT [fk_gallary_albums_admin_users_created_by] FOREIGN KEY ([created_by_id]) REFERENCES [admin_users] ([id]) ,
	CONSTRAINT [fk_gallary_albums_admin_users_deleted_by] FOREIGN KEY ([deleted_by_id]) REFERENCES [admin_users] ([id]) ,
)

CREATE TABLE images
(
	[id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[creation_timestamp] datetime not null,
	[created_by_id] int not null,
	[album_id] int not null,
	[file] varchar(500) not null,
	[status] bit NOT NULL,
	CONSTRAINT [fk_images_admin_users_created_by] FOREIGN KEY ([created_by_id]) REFERENCES [admin_users] ([id]) ,
	CONSTRAINT [fk_images_gallary_albums] FOREIGN KEY ([album_id]) REFERENCES [gallary_albums] ([id]) 
)

CREATE TABLE news
(
	[id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[creation_timestamp] datetime not null,
	[created_by_id] int not null,
	[title] varchar(100) NOT NULL,
	[description] varchar(500) NOT NULL,
	[images] varchar(500) NOT NULL,
	[link] varchar(500) NOT NULL,
	[type] int not null,
	[deleted] bit NOT NULL,
	[deleted_timestamp] datetime NULL,
	[deleted_by_id] int NULL,
	[status] bit NOT NULL,
	CONSTRAINT [fk_news_admin_users_created_by] FOREIGN KEY ([created_by_id]) REFERENCES [admin_users] ([id]) ,
	CONSTRAINT [fk_news_admin_users_deleted_by] FOREIGN KEY ([deleted_by_id]) REFERENCES [admin_users] ([id]) ,
)

=======================================
Date:- 25-09-2021

1) ALTER TABLE gallary_albums
ADD cover_image varchar(500) null;


=======================================
Date:- 08-04-2022

CREATE TABLE members
(
	[id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[creation_timestamp] datetime not null,
	[created_by_id] int not null,
	[company_name] varchar(100) NOT NULL,
	[person_name] varchar(100) NOT NULL,
	[mobile] varchar(20) NULL,
	[email] varchar(50) NOT NULL,
	[website] varchar(100) NOT NULL,
	[address] varchar(1000) NOT NULL,
	[logo] varchar(1000) NOT NULL,
	[password] varchar(50) NOT NULL,
	[deleted] bit NOT NULL,
	[deleted_timestamp] datetime NULL,
	[deleted_by_id] int NULL,
	[status] bit NOT NULL,
	CONSTRAINT [unique_members_company_name] UNIQUE ([email]),
	CONSTRAINT [fk_members_created_by] FOREIGN KEY ([created_by_id]) REFERENCES [admin_users] ([id]) 
)