-- --------------------------------------------------------
--
-- Table structure for table `urls`
--
CREATE TABLE `urls` (
`url_id` smallint(4) unsigned NOT NULL auto_increment,
`title_id` smallint(4) unsigned NOT NULL default '0',
`type_id` tinyint(3) unsigned NOT NULL default '0',
`approved` char(1) default 'N',
`date_submitted` timestamp(14) NOT NULL,
PRIMARY KEY (`url_id`),
KEY `title_id` (`title_id`),
KEY `type_id` (`type_id`),
KEY `date_submitted` (`date_submitted`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
--
-- Dumping data for table `urls`
--