vsCL5Cjm

1$drop_table = mysql_query("DROP TABLE IF EXISTS `$t_ads`");
2$sqls[$t_ads] = "CREATE TABLE `$t_ads` (
3  `adid` int unsigned NOT NULL auto_increment,
4  `adtitle` varchar(100) NOT NULL default '',
5  `addesc` longtext NOT NULL,
6  `area` varchar(50) NOT NULL default '',
7  `email` varchar(50) NOT NULL default '',
8  `showemail` enum('0','1','2') NOT NULL default '0',
9  `password` varchar(50) NOT NULL default '',
10  `code` varchar(35) NOT NULL default '',
11  `cityid` smallint unsigned NOT NULL default '0',
12  `subcatid` smallint unsigned NOT NULL default '0',
13  `price` DECIMAL( 10, 2 ) NOT NULL default '0',
14  `othercontactok` enum('0','1') NOT NULL default '0',
15  `hits` int unsigned NOT NULL default '0',
16  `ip` varchar(15) NOT NULL default '',
17  `verified` enum('0','1') NOT NULL default '0',
18  `abused` int unsigned NOT NULL default '0',
19  `enabled` enum('0','1') NOT NULL default '0',
20  `createdon` datetime NOT NULL default '0000-00-00 00:00:00',
21  `expireson` datetime NOT NULL default '0000-00-00 00:00:00',
22  `timestamp` timestamp(14) NOT NULL,
23  `paid` enum('0','1','2') NOT NULL default '2',
24  PRIMARY KEY  (`adid`),
25  KEY `subcatid` (`subcatid`),
26  KEY `cityid` (`cityid`),
27  KEY `verified` (`verified`),
28  KEY `enabled` (`enabled`),
29  KEY `paid` (`paid`)
30) TYPE=MyISAM;";
31	
32`timestamp` timestamp(14) NOT NULL,
33	
34`<SOME OTHERNAME>` timestamp NOT NULL,