· 8 years ago · Nov 29, 2017, 07:42 AM
1mysqli_query($link, "CREATE TABLE IF NOT EXISTS `review` (
2 `clients_id` int(15) NOT NULL AUTO_INCREMENT,
3 `client_id` varchar(150) NOT NULL DEFAULT '',
4 `rating` tinyint(2) NOT NULL DEFAULT '0',
5 `proj_date` date NOT NULL DEFAULT '0000-00-00',
6 `proj_desc` text NOT NULL DEFAULT '',
7 `photoname` text NOT NULL,
8 `companyname` text NOT NULL,
9 `feedback` text NOT NULL,
10 `status` tinyint(1) NOT NULL DEFAULT '0',
11 `emailid` varchar(100) NOT NULL DEFAULT '',
12 `customratings` varchar(100) NOT NULL DEFAULT '',
13 `photo_option` varchar(100) NOT NULL DEFAULT '',
14 `title` varchar(100) NOT NULL DEFAULT '',
15 `citation` varchar(100) NOT NULL DEFAULT '',
16 `date_option` varchar(100) NOT NULL DEFAULT '',
17 `rating_option` varchar(100) NOT NULL DEFAULT '',
18 PRIMARY KEY (`clients_id`),
19 FULLTEXT KEY `feedback` (`feedback`)
20 ) ENGINE=MyISAM AUTO_INCREMENT=1") or mysqli_error($link);
21
22mysqli_query($link, "CREATE TABLE IF NOT EXISTS `review` (
23 `clients_id` int(15) NOT NULL AUTO_INCREMENT,
24 `client_id` varchar(150) NOT NULL,
25 `rating` tinyint(2) NOT NULL,
26 `proj_date` date NOT NULL,
27 `proj_desc` text NOT NULL,
28 `photoname` text NOT NULL,
29 `companyname` text NOT NULL,
30 `feedback` text NOT NULL,
31 `status` tinyint(1) NOT NULL,
32 `emailid` varchar(100) NOT NULL,
33 `customratings` varchar(100) NOT NULL,
34 `photo_option` varchar(100) NOT NULL,
35 `title` varchar(100) NOT NULL,
36 `citation` varchar(100) NOT NULL,
37 `date_option` varchar(100) NOT NULL,
38 `rating_option` varchar(100) NOT NULL,
39 PRIMARY KEY (`clients_id`),
40 FULLTEXT KEY `feedback` (`feedback`)
41 ) ENGINE=MyISAM AUTO_INCREMENT=1") or mysqli_error($link);