· 7 years ago · Oct 07, 2018, 07:20 PM
1CREATE TABLE IF NOT EXISTS "admin" (
2 "admin_id" int(20) NOT NULL,
3 "f_name" text NOT NULL,
4 "l_name" text NOT NULL,
5 "email" varchar(250) NOT NULL,
6 "c_email" varchar(250) NOT NULL,
7 "pass" varchar(250) NOT NULL,
8 "c_pass" varchar(250) NOT NULL,
9 "u_name" varchar(150) NOT NULL,
10 "address" text NOT NULL,
11 "date_of_birth" varchar(50) NOT NULL,
12 "city" text NOT NULL,
13 "state" text NOT NULL,
14 "country" text NOT NULL,
15 "gender" text NOT NULL,
16 "p_o" int(50) NOT NULL,
17 PRIMARY KEY ("admin_id")
18) AUTO_INCREMENT=1 ;