· 7 years ago · Oct 13, 2018, 08:48 PM
1DROP TABLE IF EXISTS `tbl_posts_bike`;
2CREATE TABLE `tbl_posts_bike` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `email` varchar(255) NOT NULL,
5 `bbrandname` varchar(255) NOT NULL,
6 `bmodel` varchar(255) NOT NULL,
7 `bcolor` varchar(255) NOT NULL,
8 `bbikenumber` varchar(255) NOT NULL,
9 `location` varchar(255) NOT NULL,
10 `option` varchar(255) NOT NULL,
11 `pname` varchar(255) NOT NULL,
12 PRIMARY KEY (`id`)
13) ENGINE=MyISAM DEFAULT CHARSET=latin1;
14
15
16DROP TABLE IF EXISTS `tbl_posts_mobile`;
17CREATE TABLE `tbl_posts_mobile` (
18 `id` int(11) NOT NULL AUTO_INCREMENT,
19 `email` varchar(255) NOT NULL,
20 `color` varchar(255) NOT NULL,
21 `model_no` varchar(255) NOT NULL,
22 `phone` varchar(255) NOT NULL,
23 `model_name` varchar(255) NOT NULL,
24 `size` varchar(255) NOT NULL,
25 `location` varchar(255) NOT NULL,
26 `option` varchar(255) NOT NULL,
27 `pname` varchar(255) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1;
30
31
32DROP TABLE IF EXISTS `tbl_posts_nid`;
33CREATE TABLE `tbl_posts_nid` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `name` varchar(255) NOT NULL,
36 `age` varchar(255) NOT NULL,
37 `nid` varchar(255) NOT NULL,
38 `gender` varchar(255) NOT NULL,
39 `email` varchar(255) NOT NULL,
40 `location` varchar(255) NOT NULL,
41 `option` varchar(255) NOT NULL,
42 `pname` varchar(255) NOT NULL,
43 PRIMARY KEY (`id`)
44) ENGINE=MyISAM DEFAULT CHARSET=latin1;
45
46
47DROP TABLE IF EXISTS `tbl_posts_others`;
48CREATE TABLE `tbl_posts_others` (
49 `id` int(11) NOT NULL AUTO_INCREMENT,
50 `email` varchar(255) NOT NULL,
51 `type` varchar(255) NOT NULL,
52 `name` varchar(255) NOT NULL,
53 `color` varchar(255) NOT NULL,
54 `location` varchar(255) NOT NULL,
55 `option` varchar(255) NOT NULL,
56 `pname` varchar(255) NOT NULL,
57 PRIMARY KEY (`id`)
58) ENGINE=MyISAM DEFAULT CHARSET=latin1;
59
60
61DROP TABLE IF EXISTS `tbl_posts_passport`;
62CREATE TABLE `tbl_posts_passport` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `email` varchar(255) NOT NULL,
65 `age` varchar(255) NOT NULL,
66 `name` varchar(255) NOT NULL,
67 `passport_id` varchar(255) NOT NULL,
68 `gender` varchar(255) NOT NULL,
69 `location` varchar(255) NOT NULL,
70 `option` varchar(255) NOT NULL,
71 `pname` varchar(255) NOT NULL,
72 PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=latin1;
74
75
76DROP TABLE IF EXISTS `tbl_posts_wallet`;
77CREATE TABLE `tbl_posts_wallet` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `email` varchar(255) NOT NULL,
80 `amount` varchar(255) NOT NULL,
81 `color` varchar(255) NOT NULL,
82 `phone` varchar(255) NOT NULL,
83 `location` varchar(255) NOT NULL,
84 `option` varchar(255) NOT NULL,
85 `pname` varchar(255) NOT NULL,
86 PRIMARY KEY (`id`)
87) ENGINE=MyISAM DEFAULT CHARSET=latin1;