奥运主题网站（DEDE4内核）

CREATE TABLE `#@__addonarticle` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `body` mediumtext, PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__addonflash` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `filesize` varchar(10) NOT NULL default '', `playtime` varchar(10) NOT NULL default '', `flashtype` varchar(10) NOT NULL default '', `flashrank` smallint(6) NOT NULL default '0', `width` smallint(6) NOT NULL default '0', `height` smallint(6) NOT NULL default '0', `flashurl` varchar(80) NOT NULL default '', PRIMARY KEY (`aid`), KEY `flashMain` (`typeid`,`filesize`,`flashrank`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__addonimages` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `pagestyle` smallint(6) NOT NULL default '1', `maxwidth` smallint(6) NOT NULL default '600', `imgurls` text, `row` smallint(6) NOT NULL default '0', `col` smallint(6) NOT NULL default '0', `isrm` smallint(6) NOT NULL default '0', `ddmaxwidth` smallint(6) NOT NULL default '200', PRIMARY KEY (`aid`), KEY `imagesMain` (`typeid`,`pagestyle`,`maxwidth`,`row`,`col`,`isrm`,`ddmaxwidth`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__addonsoft` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `filetype` varchar(10) NOT NULL default '', `language` varchar(10) NOT NULL default '', `softtype` varchar(10) NOT NULL default '', `accredit` varchar(10) NOT NULL default '', `os` varchar(30) NOT NULL default '', `softrank` int(11) NOT NULL default '0', `officialUrl` varchar(30) NOT NULL default '', `officialDemo` varchar(50) NOT NULL default '', `softsize` varchar(10) NOT NULL default '', `softlinks` text, `introduce` text, PRIMARY KEY (`aid`), KEY `softMain` (`typeid`,`filetype`,`language`,`os`,`softrank`,`softsize`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__addonspec` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `note` text, PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__admin` ( `ID` int(10) unsigned NOT NULL auto_increment, `usertype` int(10) unsigned NOT NULL default '0', `userid` varchar(30) NOT NULL default '', `pwd` varchar(50) NOT NULL default '', `uname` varchar(20) NOT NULL default '', `tname` varchar(30) NOT NULL default '', `email` varchar(30) NOT NULL default '', `typeid` int(11) NOT NULL default '0', `logintime` datetime NOT NULL default '0000-00-00 00:00:00', `loginip` varchar(20) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__admintype` ( `rank` smallint(6) NOT NULL default '1', `typename` varchar(30) NOT NULL default '', `system` smallint(6) NOT NULL default '0', `purviews` text ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; INSERT INTO `#@__admintype` (`rank`, `typename`, `system`, `purviews`) VALUES (1, '信息发布员', 1, 't_AccList a_AccNew a_AccList a_MyList a_MyEdit a_MyDel sys_MdPwd sys_Feedback sys_MyUpload plus_留言簿模块'); INSERT INTO `#@__admintype` (`rank`, `typename`, `system`, `purviews`) VALUES (5, '频道管理员', 1, 't_AccList t_AccNew t_AccEdit t_AccDel a_AccNew a_AccList a_AccEdit a_AccDel a_AccCheck a_MyList a_MyEdit a_MyDel a_MyCheck co_AddNote co_EditNote co_PlayNote co_ListNote co_ViewNote spec_New spec_List spec_Edit sys_MdPwd sys_Log sys_ArcTj sys_Source sys_Writer sys_Keyword sys_MakeHtml sys_Feedback sys_Upload sys_MyUpload member_List member_Edit plus_站内新闻发布 plus_友情链接模块 plus_留言簿模块 plus_投票模块 plus_广告管理'); INSERT INTO `#@__admintype` (`rank`, `typename`, `system`, `purviews`) VALUES (10, '超级管理员', 1, 'admin_AllowAll '); CREATE TABLE `#@__arcatt` ( `att` smallint(6) NOT NULL default '0', `attname` varchar(30) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; INSERT INTO `#@__arcatt` (`att`, `attname`) VALUES (1, '滚动显示'); INSERT INTO `#@__arcatt` (`att`, `attname`) VALUES (2, '头条推荐'); INSERT INTO `#@__arcatt` (`att`, `attname`) VALUES (3, '幻灯片显'); CREATE TABLE `#@__archives` ( `ID` int(11) unsigned NOT NULL auto_increment, `typeid` int(11) unsigned NOT NULL default '0', `typeid2` int(11) unsigned NOT NULL default '0', `sortrank` int(11) NOT NULL default '0', `iscommend` smallint(6) NOT NULL default '0', `ismake` smallint(6) NOT NULL default '0', `channel` int(11) NOT NULL default '1', `arcrank` smallint(6) NOT NULL default '0', `click` int(11) unsigned NOT NULL default '0', `money` smallint(6) NOT NULL default '0', `title` varchar(80) NOT NULL default '', `shorttitle` varchar(36) NOT NULL default '', `color` varchar(10) NOT NULL default '', `writer` varchar(30) NOT NULL default '', `source` varchar(50) NOT NULL default '', `litpic` varchar(100) NOT NULL default '', `pubdate` int(11) NOT NULL default '0', `senddate` int(11) NOT NULL default '0', `arcatt` smallint(6) NOT NULL default '0', `adminID` int(11) NOT NULL default '0', `memberID` int(11) unsigned NOT NULL default '0', `description` varchar(250) NOT NULL default '', `keywords` varchar(60) NOT NULL default '', `templet` varchar(60) NOT NULL default '', `lastpost` int(11) NOT NULL default '0', `postnum` int(11) NOT NULL default '0', `redirecturl` varchar(150) NOT NULL default '', `mtype` int(11) NOT NULL default '0', `userip` varchar(20) NOT NULL default '', `locklikeid` smallint(6) NOT NULL default '0', `likeid` varchar(240) default '', PRIMARY KEY (`ID`), KEY `click` (`click`), KEY `senddate` (`senddate`), KEY `typeid` (`typeid`), KEY `arcrank` (`arcrank`), KEY `sortrank` (`sortrank`), KEY `pubdate` (`pubdate`), KEY `litpic` (`litpic`), KEY `typeid2` (`typeid2`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; CREATE TABLE `#@__arcrank` ( `ID` int(10) unsigned NOT NULL auto_increment, `rank` smallint(10) NOT NULL default '0', `membername` varchar(20) NOT NULL default '', `adminrank` smallint(6) NOT NULL default '0', `money` int(11) NOT NULL default '500', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#; INSERT INTO `#@__arcrank` (`ID`, `rank`, `membername`, `adminrank`, `money`) VALUES (1, 0, '开放浏览', 5, 0); INSERT INTO `#@__arcrank` (`ID`, `rank`, `membername`, `adminrank`, `money`) VALUES (2, -1, '待审核稿件', 0, 0); INSERT INTO `#@__arcrank` (`ID`, `rank`, `membername`, `adminrank`, `money`) VALUES (3, 10, '注册会员', 5, 0); INSERT INTO `#@__arcrank` (`ID`, `rank`, `membername`, `adminrank`, `money`) VALUES (4, 50, '中级会员', 5, 200); INSERT INTO `#@__arcrank` (`ID`, `rank`, `membername`, `adminrank`, `money`) VALUES (5, 100, '高级会员', 5, 400); CREATE TABLE `#@__arctype` ( `ID` int(10) unsigned NOT NULL auto_increment, `reID` int(10) unsigned NOT NULL default '0', `topID` int(10) unsigned NOT NULL default '0', `sortrank` smallint(6) NOT NULL default '50', `typename` varchar(30) NOT NULL default '', `typedir` varchar(100) NOT NULL default '', `isdefault` smallint(6) NOT NULL default '0', `defaultname` varchar(20) NOT NULL default 'index.html', `issend` smallint(6) NOT NULL default '0', `channeltype` smallint(6) NOT NULL default '1', `maxpage` int(11) NOT NULL default '-1', `ispart` smallint(6) NOT NULL default '0', `corank` smallint(6) NOT NULL default '0', `tempindex` varchar(60) NOT NULL default '', `templist` varchar(60) NOT NULL default '', `temparticle` varchar(60) NOT NULL default '', `tempone` varchar(60) NOT NULL default '', `namerule` varchar(50) NOT NULL default '', `namerule2` varchar(50) NOT NULL default '', `modname` varc