All pastes #80138 Raw Edit

Anonymous

public sql v1 · immutable
·published 2006-07-06 03:12 UTC
rendered paste body
CREATE TABLE `heads` (  `id` bigint(20) NOT NULL auto_increment,  `title` varchar(80) collate latin1_general_ci NOT NULL,  `link` varchar(255) collate latin1_general_ci NOT NULL,  `description` varchar(120) collate latin1_general_ci NOT NULL,  `pubDate` datetime NOT NULL,  `language` char(2) collate latin1_general_ci NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `heads`-- -- ---------------------------------------------------------- -- Table structure for table `items`-- CREATE TABLE `items` (  `id` bigint(20) NOT NULL auto_increment,  `head_id` bigint(20) NOT NULL,  `title` varchar(80) collate latin1_general_ci NOT NULL,  `link` varchar(255) collate latin1_general_ci NOT NULL,  `description` varchar(120) collate latin1_general_ci NOT NULL,  `pubDate` datetime NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;