<?php
if (!defined('R_P')) die("access die");

$sql['add'][] = "
	CREATE TABLE IF NOT EXISTS `".TABLEPRE."article__channelid__` (
		  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
		  `cid` int(10) unsigned NOT NULL DEFAULT '0',
		  `channelid` int(10) unsigned NOT NULL DEFAULT '0',
		  `author` varchar(30) NOT NULL DEFAULT '',
		  `source` varchar(100) NOT NULL DEFAULT '',
		  `subject_pre` varchar(6) NOT NULL DEFAULT '',
		  `subject` varchar(100) NOT NULL DEFAULT '',
		  `keyword` varchar(64) NOT NULL,
		  `description` varchar(255) NOT NULL,
		  `message` int(10) unsigned NOT NULL DEFAULT '0',
		  `is_link` tinyint(1) NOT NULL DEFAULT '0',
		  `linkurl` varchar(255) DEFAULT NULL,
		  `subject_color` char(7) NOT NULL DEFAULT '0',
		  `page` smallint(3) unsigned NOT NULL DEFAULT '1',
		  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
		  `dview` mediumint(6) unsigned NOT NULL DEFAULT '0',
		  `wview` mediumint(6) unsigned NOT NULL DEFAULT '0',
		  `mview` mediumint(6) unsigned NOT NULL DEFAULT '0',
		  `views` mediumint(6) unsigned NOT NULL DEFAULT '0',
		  `viewtime` int(10) unsigned NOT NULL DEFAULT '0',
		  `filter` set('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32') NOT NULL,
		  `stars` tinyint(1) NOT NULL DEFAULT '0',
		  `postip` int(11) NOT NULL DEFAULT '0',
		  `is_comend` tinyint(1) NOT NULL DEFAULT '0',
		  `thumb` varchar(255) DEFAULT NULL,
		  `editor` varchar(30) NOT NULL DEFAULT '0',
		  `edit_time` int(10) NOT NULL DEFAULT '0',
		  `uid` int(10) unsigned NOT NULL DEFAULT '0',
		  `username` varchar(20) NOT NULL,
		  `nocoment` tinyint(1) NOT NULL DEFAULT '0',
		  `pay` tinyint(1) unsigned NOT NULL DEFAULT '0',
		  `filename` varchar(64) NOT NULL,
		  `showphp` varchar(30) DEFAULT NULL,
		  `ver` mediumint(8) unsigned NOT NULL,
		  `ordering` int(10) unsigned NOT NULL,
		  `tag_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
		  `extdata` text NOT NULL,
		  PRIMARY KEY (`id`),
		  KEY `views` (`views`),
		  KEY `cid` (`cid`)
	) ENGINE=MyISAM ;
";

$sql['drop'][] = " DROP TABLE `".TABLEPRE."article__channelid__`  ";
?>