2 -- Table structure for table `url`
\r
5 CREATE TABLE IF NOT EXISTS `url` (
\r
6 `id` mediumint(8) unsigned NOT NULL auto_increment,
\r
7 `url` varchar(200) NOT NULL,
\r
8 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
\r
9 `ip` varchar(15) NOT NULL,
\r
10 `clicks` int(10) unsigned NOT NULL,
\r
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
\r
15 **************************************************************************
\r
19 ALTER TABLE `url` CHANGE `ip` `ip` VARCHAR( 41 );
\r
20 ALTER TABLE `url` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL;
\r
22 CREATE TABLE `next_id` (
\r
23 `next_id` BIGINT NOT NULL ,
\r
24 PRIMARY KEY ( `next_id` )
\r
26 INSERT INTO next_id VALUES ( 1 )