CREATE TABLE `stations` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`cid` tinytext NOT NULL,
`url` text NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=565 ;
INSERT INTO `stations` VALUES (1, '20', 'http://www.abcnews.go.com', 'ABC', 'None');
INSERT INTO `stations` VALUES (2, '20', 'http://www.abc.net.au', 'ABC.net.au', 'None');
INSERT INTO `stations` VALUES (3, '20', 'http://www.afp.com/english/home/', 'AFP ', 'None');
|