DROP TABLE IF EXISTS `#@__addonarticle`;
CREATE TABLE `#@__addonarticle` (
  `aid` int(11) NOT NULL default '0',
  `typeid` int(11) NOT NULL default '0',
  `body` mediumtext NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `typeid` (`typeid`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__addonflash`;
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`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__addonimages`;
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 NOT NULL,
  `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`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__addonsoft`;
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 NOT NULL,
  `introduce` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `softMain` (`typeid`,`filetype`,`language`,`os`,`softrank`,`softsize`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__addonspec`;
CREATE TABLE `#@__addonspec` (
  `aid` int(11) NOT NULL default '0',
  `typeid` int(11) NOT NULL default '0',
  `note` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `typeid` (`typeid`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__admin`;
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`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__admintype`;
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 NOT NULL
) TYPE=MyISAM;

INSERT INTO `#@__admintype` 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` 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` VALUES (10, 'Ա', 1, 'admin_AllowAll ');

DROP TABLE IF EXISTS `#@__arcatt`;
CREATE TABLE `#@__arcatt` (
  `att` smallint(6) NOT NULL default '0',
  `attname` varchar(30) NOT NULL default ''
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__archives`;
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 '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__arcrank`;
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`)
) TYPE=MyISAM;


INSERT INTO `#@__arcrank` VALUES (1, 0, '', 5, 0);
INSERT INTO `#@__arcrank` VALUES (2, -1, '˸', 0, 0);
INSERT INTO `#@__arcrank` VALUES (3, 10, 'עԱ', 5, 0);
INSERT INTO `#@__arcrank` VALUES (4, 50, 'мԱ', 5, 2500);
INSERT INTO `#@__arcrank` VALUES (5, 100, '߼Ա', 5, 10000);


DROP TABLE IF EXISTS `#@__arctype`;
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` varchar(30) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  `keywords` varchar(100) NOT NULL default '',
  `moresite` smallint(6) NOT NULL default '0',
  `siterefer` smallint(6) NOT NULL default '0',
  `sitepath` varchar(60) NOT NULL default '',
  `siteurl` varchar(60) NOT NULL default '',
  `ishidden` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `moresite` (`moresite`,`sitepath`,`siteurl`),
  KEY `mainIndex` (`reID`,`sortrank`,`typename`,`typedir`,`isdefault`,`defaultname`,`channeltype`,`ispart`,`namerule`,`namerule2`,`corank`,`topID`,`ishidden`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `#@__area`;
CREATE TABLE `#@__area` (
  `eid` int(11) NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `rid` int(11) NOT NULL default '0'
) TYPE=MyISAM;


INSERT INTO `#@__area` VALUES (1, '', 0);
INSERT INTO `#@__area` VALUES (101, '', 1);
INSERT INTO `#@__area` VALUES (102, '', 1);
INSERT INTO `#@__area` VALUES (103, '', 1);
INSERT INTO `#@__area` VALUES (104, '', 1);
INSERT INTO `#@__area` VALUES (105, '', 1);
INSERT INTO `#@__area` VALUES (106, '', 1);
INSERT INTO `#@__area` VALUES (107, '̨', 1);
INSERT INTO `#@__area` VALUES (108, 'ʯɽ', 1);
INSERT INTO `#@__area` VALUES (109, 'ͷ', 1);
INSERT INTO `#@__area` VALUES (110, 'ɽ', 1);
INSERT INTO `#@__area` VALUES (111, 'ͨ', 1);
INSERT INTO `#@__area` VALUES (112, '˳', 1);
INSERT INTO `#@__area` VALUES (113, 'ƽ', 1);
INSERT INTO `#@__area` VALUES (114, '', 1);
INSERT INTO `#@__area` VALUES (115, 'ƽ', 1);
INSERT INTO `#@__area` VALUES (116, '', 1);
INSERT INTO `#@__area` VALUES (117, '', 1);
INSERT INTO `#@__area` VALUES (118, '', 1);
INSERT INTO `#@__area` VALUES (2, 'Ϻ', 0);
INSERT INTO `#@__area` VALUES (201, '', 2);
INSERT INTO `#@__area` VALUES (202, '¬', 2);
INSERT INTO `#@__area` VALUES (203, '', 2);
INSERT INTO `#@__area` VALUES (204, '', 2);
INSERT INTO `#@__area` VALUES (205, '', 2);
INSERT INTO `#@__area` VALUES (206, '', 2);
INSERT INTO `#@__area` VALUES (207, 'բ', 2);
INSERT INTO `#@__area` VALUES (208, '', 2);
INSERT INTO `#@__area` VALUES (209, '', 2);
INSERT INTO `#@__area` VALUES (210, 'ɽ', 2);
INSERT INTO `#@__area` VALUES (211, '', 2);
INSERT INTO `#@__area` VALUES (212, 'ζ', 2);
INSERT INTO `#@__area` VALUES (213, 'ֶ', 2);
INSERT INTO `#@__area` VALUES (214, 'ɽ', 2);
INSERT INTO `#@__area` VALUES (215, 'ɽ', 2);
INSERT INTO `#@__area` VALUES (216, '', 2);
INSERT INTO `#@__area` VALUES (217, 'ϻ', 2);
INSERT INTO `#@__area` VALUES (218, '', 2);
INSERT INTO `#@__area` VALUES (219, '', 2);
INSERT INTO `#@__area` VALUES (3, '', 0);
INSERT INTO `#@__area` VALUES (301, 'ƽ', 3);
INSERT INTO `#@__area` VALUES (302, 'Ӷ', 3);
INSERT INTO `#@__area` VALUES (303, '', 3);
INSERT INTO `#@__area` VALUES (304, 'Ͽ', 3);
INSERT INTO `#@__area` VALUES (305, 'ӱ', 3);
INSERT INTO `#@__area` VALUES (306, '', 3);
INSERT INTO `#@__area` VALUES (307, '', 3);
INSERT INTO `#@__area` VALUES (308, '', 3);
INSERT INTO `#@__area` VALUES (309, '', 3);
INSERT INTO `#@__area` VALUES (310, '', 3);
INSERT INTO `#@__area` VALUES (311, '', 3);
INSERT INTO `#@__area` VALUES (312, '', 3);
INSERT INTO `#@__area` VALUES (313, '', 3);
INSERT INTO `#@__area` VALUES (314, '', 3);
INSERT INTO `#@__area` VALUES (315, '', 3);
INSERT INTO `#@__area` VALUES (316, '', 3);
INSERT INTO `#@__area` VALUES (317, '', 3);
INSERT INTO `#@__area` VALUES (318, '', 3);
INSERT INTO `#@__area` VALUES (4, '', 0);
INSERT INTO `#@__area` VALUES (401, '', 4);
INSERT INTO `#@__area` VALUES (402, 'ɿ', 4);
INSERT INTO `#@__area` VALUES (403, '', 4);
INSERT INTO `#@__area` VALUES (404, 'ɳƺ', 4);
INSERT INTO `#@__area` VALUES (405, '', 4);
INSERT INTO `#@__area` VALUES (406, 'ϰ', 4);
INSERT INTO `#@__area` VALUES (407, '', 4);
INSERT INTO `#@__area` VALUES (408, 'ʢ', 4);
INSERT INTO `#@__area` VALUES (409, '˫', 4);
INSERT INTO `#@__area` VALUES (410, '山', 4);
INSERT INTO `#@__area` VALUES (411, '', 4);
INSERT INTO `#@__area` VALUES (412, '', 4);
INSERT INTO `#@__area` VALUES (413, '', 4);
INSERT INTO `#@__area` VALUES (414, 'ǭ', 4);
INSERT INTO `#@__area` VALUES (415, '', 4);
INSERT INTO `#@__area` VALUES (416, 'ϴ', 4);
INSERT INTO `#@__area` VALUES (417, '', 4);
INSERT INTO `#@__area` VALUES (418, 'ϴ', 4);
INSERT INTO `#@__area` VALUES (419, '', 4);
INSERT INTO `#@__area` VALUES (420, '뽭', 4);
INSERT INTO `#@__area` VALUES (421, '', 4);
INSERT INTO `#@__area` VALUES (422, 'ٲ', 4);
INSERT INTO `#@__area` VALUES (423, 'ɽ', 4);
INSERT INTO `#@__area` VALUES (424, '', 4);
INSERT INTO `#@__area` VALUES (425, 'ͭ', 4);
INSERT INTO `#@__area` VALUES (426, 'ƽ', 4);
INSERT INTO `#@__area` VALUES (427, 'ǿ', 4);
INSERT INTO `#@__area` VALUES (428, '潭', 4);
INSERT INTO `#@__area` VALUES (429, '¡', 4);
INSERT INTO `#@__area` VALUES (430, 'ᶼ', 4);
INSERT INTO `#@__area` VALUES (431, '', 4);
INSERT INTO `#@__area` VALUES (432, '', 4);
INSERT INTO `#@__area` VALUES (433, '', 4);
INSERT INTO `#@__area` VALUES (434, '', 4);
INSERT INTO `#@__area` VALUES (435, 'Ϫ', 4);
INSERT INTO `#@__area` VALUES (436, 'ɽ', 4);
INSERT INTO `#@__area` VALUES (437, 'ʯ', 4);
INSERT INTO `#@__area` VALUES (438, 'ɽ', 4);
INSERT INTO `#@__area` VALUES (439, '', 4);
INSERT INTO `#@__area` VALUES (440, 'ˮ', 4);
INSERT INTO `#@__area` VALUES (5, '㶫ʡ', 0);
INSERT INTO `#@__area` VALUES (501, '', 5);
INSERT INTO `#@__area` VALUES (502, '', 5);
INSERT INTO `#@__area` VALUES (503, '麣', 5);
INSERT INTO `#@__area` VALUES (504, 'ͷ', 5);
INSERT INTO `#@__area` VALUES (505, 'ع', 5);
INSERT INTO `#@__area` VALUES (506, 'Դ', 5);
INSERT INTO `#@__area` VALUES (507, '÷', 5);
INSERT INTO `#@__area` VALUES (508, '', 5);
INSERT INTO `#@__area` VALUES (509, 'β', 5);
INSERT INTO `#@__area` VALUES (510, 'ݸ', 5);
INSERT INTO `#@__area` VALUES (511, 'ɽ', 5);
INSERT INTO `#@__area` VALUES (512, '', 5);
INSERT INTO `#@__area` VALUES (513, 'ɽ', 5);
INSERT INTO `#@__area` VALUES (514, '', 5);
INSERT INTO `#@__area` VALUES (515, 'տ', 5);
INSERT INTO `#@__area` VALUES (516, 'ï', 5);
INSERT INTO `#@__area` VALUES (517, '', 5);
INSERT INTO `#@__area` VALUES (518, 'Զ', 5);
INSERT INTO `#@__area` VALUES (519, '', 5);
INSERT INTO `#@__area` VALUES (520, '', 5);
INSERT INTO `#@__area` VALUES (521, 'Ƹ', 5);
INSERT INTO `#@__area` VALUES (6, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (601, '', 6);
INSERT INTO `#@__area` VALUES (602, '', 6);
INSERT INTO `#@__area` VALUES (603, '', 6);
INSERT INTO `#@__area` VALUES (604, '', 6);
INSERT INTO `#@__area` VALUES (605, 'Ȫ', 6);
INSERT INTO `#@__area` VALUES (606, '', 6);
INSERT INTO `#@__area` VALUES (607, 'ƽ', 6);
INSERT INTO `#@__area` VALUES (608, '', 6);
INSERT INTO `#@__area` VALUES (609, '', 6);
INSERT INTO `#@__area` VALUES (7, '㽭ʡ', 0);
INSERT INTO `#@__area` VALUES (701, '', 7);
INSERT INTO `#@__area` VALUES (702, '', 7);
INSERT INTO `#@__area` VALUES (703, '', 7);
INSERT INTO `#@__area` VALUES (704, '', 7);
INSERT INTO `#@__area` VALUES (705, '', 7);
INSERT INTO `#@__area` VALUES (706, '', 7);
INSERT INTO `#@__area` VALUES (707, '', 7);
INSERT INTO `#@__area` VALUES (708, '', 7);
INSERT INTO `#@__area` VALUES (709, 'ɽ', 7);
INSERT INTO `#@__area` VALUES (710, '̨', 7);
INSERT INTO `#@__area` VALUES (711, 'ˮ', 7);
INSERT INTO `#@__area` VALUES (8, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (801, 'Ͼ', 8);
INSERT INTO `#@__area` VALUES (802, '', 8);
INSERT INTO `#@__area` VALUES (803, 'Ƹ', 8);
INSERT INTO `#@__area` VALUES (804, '', 8);
INSERT INTO `#@__area` VALUES (805, 'Ǩ', 8);
INSERT INTO `#@__area` VALUES (806, 'γ', 8);
INSERT INTO `#@__area` VALUES (807, '', 8);
INSERT INTO `#@__area` VALUES (808, '̩', 8);
INSERT INTO `#@__area` VALUES (809, 'ͨ', 8);
INSERT INTO `#@__area` VALUES (810, '', 8);
INSERT INTO `#@__area` VALUES (811, '', 8);
INSERT INTO `#@__area` VALUES (812, '', 8);
INSERT INTO `#@__area` VALUES (813, '', 8);
INSERT INTO `#@__area` VALUES (9, 'ɽʡ', 0);
INSERT INTO `#@__area` VALUES (901, '', 9);
INSERT INTO `#@__area` VALUES (902, 'ൺ', 9);
INSERT INTO `#@__area` VALUES (903, 'Ͳ', 9);
INSERT INTO `#@__area` VALUES (904, 'ׯ', 9);
INSERT INTO `#@__area` VALUES (905, 'Ӫ', 9);
INSERT INTO `#@__area` VALUES (906, 'Ϋ', 9);
INSERT INTO `#@__area` VALUES (907, '̨', 9);
INSERT INTO `#@__area` VALUES (908, '', 9);
INSERT INTO `#@__area` VALUES (909, '', 9);
INSERT INTO `#@__area` VALUES (910, '̩', 9);
INSERT INTO `#@__area` VALUES (911, '', 9);
INSERT INTO `#@__area` VALUES (912, '', 9);
INSERT INTO `#@__area` VALUES (913, '', 9);
INSERT INTO `#@__area` VALUES (914, '', 9);
INSERT INTO `#@__area` VALUES (915, 'ĳ', 9);
INSERT INTO `#@__area` VALUES (916, '', 9);
INSERT INTO `#@__area` VALUES (917, '', 9);
INSERT INTO `#@__area` VALUES (10, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1001, '', 10);
INSERT INTO `#@__area` VALUES (1002, '', 10);
INSERT INTO `#@__area` VALUES (1003, 'ɽ', 10);
INSERT INTO `#@__area` VALUES (1004, '˳', 10);
INSERT INTO `#@__area` VALUES (1005, 'Ϫ', 10);
INSERT INTO `#@__area` VALUES (1006, '', 10);
INSERT INTO `#@__area` VALUES (1007, '', 10);
INSERT INTO `#@__area` VALUES (1008, '«', 10);
INSERT INTO `#@__area` VALUES (1009, 'Ӫ', 10);
INSERT INTO `#@__area` VALUES (1010, '̽', 10);
INSERT INTO `#@__area` VALUES (1011, '', 10);
INSERT INTO `#@__area` VALUES (1012, '', 10);
INSERT INTO `#@__area` VALUES (1013, '', 10);
INSERT INTO `#@__area` VALUES (1014, '', 10);
INSERT INTO `#@__area` VALUES (11, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1101, 'ϲ', 11);
INSERT INTO `#@__area` VALUES (1102, '', 11);
INSERT INTO `#@__area` VALUES (1103, 'Ƽ', 11);
INSERT INTO `#@__area` VALUES (1104, '', 11);
INSERT INTO `#@__area` VALUES (1105, 'Ž', 11);
INSERT INTO `#@__area` VALUES (1106, 'ӥ̶', 11);
INSERT INTO `#@__area` VALUES (1107, '', 11);
INSERT INTO `#@__area` VALUES (1108, '', 11);
INSERT INTO `#@__area` VALUES (1109, '˴', 11);
INSERT INTO `#@__area` VALUES (1110, '', 11);
INSERT INTO `#@__area` VALUES (1111, '', 11);
INSERT INTO `#@__area` VALUES (12, 'Ĵʡ', 0);
INSERT INTO `#@__area` VALUES (1201, 'ɶ', 12);
INSERT INTO `#@__area` VALUES (1202, 'Թ', 12);
INSERT INTO `#@__area` VALUES (1203, '֦', 12);
INSERT INTO `#@__area` VALUES (1204, '', 12);
INSERT INTO `#@__area` VALUES (1205, '', 12);
INSERT INTO `#@__area` VALUES (1206, '', 12);
INSERT INTO `#@__area` VALUES (1207, 'Ԫ', 12);
INSERT INTO `#@__area` VALUES (1208, '', 12);
INSERT INTO `#@__area` VALUES (1209, 'ڽ', 12);
INSERT INTO `#@__area` VALUES (1210, 'ɽ', 12);
INSERT INTO `#@__area` VALUES (1211, 'ϳ', 12);
INSERT INTO `#@__area` VALUES (1212, '˱', 12);
INSERT INTO `#@__area` VALUES (1213, '㰲', 12);
INSERT INTO `#@__area` VALUES (1214, '', 12);
INSERT INTO `#@__area` VALUES (1215, '', 12);
INSERT INTO `#@__area` VALUES (1216, 'Ű', 12);
INSERT INTO `#@__area` VALUES (1217, 'üɽ', 12);
INSERT INTO `#@__area` VALUES (1218, '', 12);
INSERT INTO `#@__area` VALUES (1219, '', 12);
INSERT INTO `#@__area` VALUES (1220, '', 12);
INSERT INTO `#@__area` VALUES (1221, 'ɽ', 12);
INSERT INTO `#@__area` VALUES (13, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1301, '', 13);
INSERT INTO `#@__area` VALUES (1302, 'ͭ', 13);
INSERT INTO `#@__area` VALUES (1303, '', 13);
INSERT INTO `#@__area` VALUES (1304, '', 13);
INSERT INTO `#@__area` VALUES (1305, 'μ', 13);
INSERT INTO `#@__area` VALUES (1306, 'Ӱ', 13);
INSERT INTO `#@__area` VALUES (1307, '', 13);
INSERT INTO `#@__area` VALUES (1308, '', 13);
INSERT INTO `#@__area` VALUES (1309, '', 13);
INSERT INTO `#@__area` VALUES (1310, '', 13);
INSERT INTO `#@__area` VALUES (14, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1401, '人', 14);
INSERT INTO `#@__area` VALUES (1402, 'ʯ', 14);
INSERT INTO `#@__area` VALUES (1403, '差', 14);
INSERT INTO `#@__area` VALUES (1404, 'ʮ', 14);
INSERT INTO `#@__area` VALUES (1405, '', 14);
INSERT INTO `#@__area` VALUES (1406, '˲', 14);
INSERT INTO `#@__area` VALUES (1407, '', 14);
INSERT INTO `#@__area` VALUES (1408, '', 14);
INSERT INTO `#@__area` VALUES (1409, 'Т', 14);
INSERT INTO `#@__area` VALUES (1410, 'Ƹ', 14);
INSERT INTO `#@__area` VALUES (1411, '', 14);
INSERT INTO `#@__area` VALUES (1412, '', 14);
INSERT INTO `#@__area` VALUES (1413, '', 14);
INSERT INTO `#@__area` VALUES (1414, '', 14);
INSERT INTO `#@__area` VALUES (1415, 'Ǳ', 14);
INSERT INTO `#@__area` VALUES (1416, 'ũ', 14);
INSERT INTO `#@__area` VALUES (1417, 'ʩ', 14);
INSERT INTO `#@__area` VALUES (15, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1501, '֣', 15);
INSERT INTO `#@__area` VALUES (1502, '', 15);
INSERT INTO `#@__area` VALUES (1503, '', 15);
INSERT INTO `#@__area` VALUES (1504, 'ƽɽ', 15);
INSERT INTO `#@__area` VALUES (1505, '', 15);
INSERT INTO `#@__area` VALUES (1506, 'ױ', 15);
INSERT INTO `#@__area` VALUES (1507, '', 15);
INSERT INTO `#@__area` VALUES (1508, '', 15);
INSERT INTO `#@__area` VALUES (1509, '', 15);
INSERT INTO `#@__area` VALUES (1510, '', 15);
INSERT INTO `#@__area` VALUES (1511, '', 15);
INSERT INTO `#@__area` VALUES (1512, 'Ͽ', 15);
INSERT INTO `#@__area` VALUES (1513, '', 15);
INSERT INTO `#@__area` VALUES (1514, '', 15);
INSERT INTO `#@__area` VALUES (1515, '', 15);
INSERT INTO `#@__area` VALUES (1516, 'ܿ', 15);
INSERT INTO `#@__area` VALUES (1517, 'פ', 15);
INSERT INTO `#@__area` VALUES (1518, 'Դ', 15);
INSERT INTO `#@__area` VALUES (16, 'ӱʡ', 0);
INSERT INTO `#@__area` VALUES (1601, 'ʯׯ', 16);
INSERT INTO `#@__area` VALUES (1602, 'ɽ', 16);
INSERT INTO `#@__area` VALUES (1603, 'ػʵ', 16);
INSERT INTO `#@__area` VALUES (1604, '', 16);
INSERT INTO `#@__area` VALUES (1605, '̨', 16);
INSERT INTO `#@__area` VALUES (1606, '', 16);
INSERT INTO `#@__area` VALUES (1607, 'żҿ', 16);
INSERT INTO `#@__area` VALUES (1608, 'е', 16);
INSERT INTO `#@__area` VALUES (1609, '', 16);
INSERT INTO `#@__area` VALUES (1610, 'ȷ', 16);
INSERT INTO `#@__area` VALUES (1611, 'ˮ', 16);
INSERT INTO `#@__area` VALUES (17, 'ɽʡ', 0);
INSERT INTO `#@__area` VALUES (1701, '̫ԭ', 17);
INSERT INTO `#@__area` VALUES (1702, 'ͬ', 17);
INSERT INTO `#@__area` VALUES (1703, 'Ȫ', 17);
INSERT INTO `#@__area` VALUES (1704, '', 17);
INSERT INTO `#@__area` VALUES (1705, '', 17);
INSERT INTO `#@__area` VALUES (1706, '˷', 17);
INSERT INTO `#@__area` VALUES (1707, '', 17);
INSERT INTO `#@__area` VALUES (1708, '', 17);
INSERT INTO `#@__area` VALUES (1709, 'ٷ', 17);
INSERT INTO `#@__area` VALUES (1710, '˳', 17);
INSERT INTO `#@__area` VALUES (1711, '', 17);
INSERT INTO `#@__area` VALUES (18, 'ɹ', 0);
INSERT INTO `#@__area` VALUES (1801, 'ͺ', 18);
INSERT INTO `#@__area` VALUES (1802, 'ͷ', 18);
INSERT INTO `#@__area` VALUES (1803, 'ں', 18);
INSERT INTO `#@__area` VALUES (1804, '', 18);
INSERT INTO `#@__area` VALUES (1805, 'ͨ', 18);
INSERT INTO `#@__area` VALUES (1806, '˹', 18);
INSERT INTO `#@__area` VALUES (1807, '첼', 18);
INSERT INTO `#@__area` VALUES (1808, 'ֹ', 18);
INSERT INTO `#@__area` VALUES (1809, 'ױ', 18);
INSERT INTO `#@__area` VALUES (1810, '׶', 18);
INSERT INTO `#@__area` VALUES (1811, '', 18);
INSERT INTO `#@__area` VALUES (1812, '˰', 18);
INSERT INTO `#@__area` VALUES (19, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (1901, '', 19);
INSERT INTO `#@__area` VALUES (1902, '', 19);
INSERT INTO `#@__area` VALUES (1903, 'ƽ', 19);
INSERT INTO `#@__area` VALUES (1904, 'Դ', 19);
INSERT INTO `#@__area` VALUES (1905, 'ͨ', 19);
INSERT INTO `#@__area` VALUES (1906, 'ɽ', 19);
INSERT INTO `#@__area` VALUES (1907, 'ԭ', 19);
INSERT INTO `#@__area` VALUES (1908, '׳', 19);
INSERT INTO `#@__area` VALUES (1909, 'ӱ', 19);
INSERT INTO `#@__area` VALUES (20, '', 0);
INSERT INTO `#@__area` VALUES (2001, '', 20);
INSERT INTO `#@__area` VALUES (2002, '', 20);
INSERT INTO `#@__area` VALUES (2003, '׸', 20);
INSERT INTO `#@__area` VALUES (2004, '˫Ѽɽ', 20);
INSERT INTO `#@__area` VALUES (2005, '', 20);
INSERT INTO `#@__area` VALUES (2006, '', 20);
INSERT INTO `#@__area` VALUES (2007, '', 20);
INSERT INTO `#@__area` VALUES (2008, 'ĵ', 20);
INSERT INTO `#@__area` VALUES (2009, 'ľ˹', 20);
INSERT INTO `#@__area` VALUES (2010, '̨', 20);
INSERT INTO `#@__area` VALUES (2011, 'ں', 20);
INSERT INTO `#@__area` VALUES (2012, '绯', 20);
INSERT INTO `#@__area` VALUES (2013, '˰', 20);
INSERT INTO `#@__area` VALUES (21, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2101, 'Ϸ', 21);
INSERT INTO `#@__area` VALUES (2102, 'ߺ', 21);
INSERT INTO `#@__area` VALUES (2103, '', 21);
INSERT INTO `#@__area` VALUES (2104, '', 21);
INSERT INTO `#@__area` VALUES (2105, 'ɽ', 21);
INSERT INTO `#@__area` VALUES (2106, '', 21);
INSERT INTO `#@__area` VALUES (2107, 'ͭ', 21);
INSERT INTO `#@__area` VALUES (2108, '', 21);
INSERT INTO `#@__area` VALUES (2109, 'ɽ', 21);
INSERT INTO `#@__area` VALUES (2110, '', 21);
INSERT INTO `#@__area` VALUES (2111, '', 21);
INSERT INTO `#@__area` VALUES (2112, '', 21);
INSERT INTO `#@__area` VALUES (2113, '', 21);
INSERT INTO `#@__area` VALUES (2114, '', 21);
INSERT INTO `#@__area` VALUES (2115, '', 21);
INSERT INTO `#@__area` VALUES (2116, '', 21);
INSERT INTO `#@__area` VALUES (2117, '', 21);
INSERT INTO `#@__area` VALUES (22, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2201, 'ɳ', 22);
INSERT INTO `#@__area` VALUES (2202, '', 22);
INSERT INTO `#@__area` VALUES (2203, '̶', 22);
INSERT INTO `#@__area` VALUES (2204, '', 22);
INSERT INTO `#@__area` VALUES (2205, '', 22);
INSERT INTO `#@__area` VALUES (2206, '', 22);
INSERT INTO `#@__area` VALUES (2207, '', 22);
INSERT INTO `#@__area` VALUES (2208, 'żҽ', 22);
INSERT INTO `#@__area` VALUES (2209, '', 22);
INSERT INTO `#@__area` VALUES (2210, '', 22);
INSERT INTO `#@__area` VALUES (2211, '', 22);
INSERT INTO `#@__area` VALUES (2212, '', 22);
INSERT INTO `#@__area` VALUES (2213, '¦', 22);
INSERT INTO `#@__area` VALUES (2214, '', 22);
INSERT INTO `#@__area` VALUES (23, '', 0);
INSERT INTO `#@__area` VALUES (2301, '', 23);
INSERT INTO `#@__area` VALUES (2302, '', 23);
INSERT INTO `#@__area` VALUES (2303, '', 23);
INSERT INTO `#@__area` VALUES (2304, '', 23);
INSERT INTO `#@__area` VALUES (2305, '', 23);
INSERT INTO `#@__area` VALUES (2306, 'Ǹ', 23);
INSERT INTO `#@__area` VALUES (2307, '', 23);
INSERT INTO `#@__area` VALUES (2308, '', 23);
INSERT INTO `#@__area` VALUES (2309, '', 23);
INSERT INTO `#@__area` VALUES (2310, '', 23);
INSERT INTO `#@__area` VALUES (2311, 'ݵ', 23);
INSERT INTO `#@__area` VALUES (2312, 'ݵ', 23);
INSERT INTO `#@__area` VALUES (2313, 'ɫ', 23);
INSERT INTO `#@__area` VALUES (2314, 'ӳص', 23);
INSERT INTO `#@__area` VALUES (24, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2401, '', 24);
INSERT INTO `#@__area` VALUES (2402, '', 24);
INSERT INTO `#@__area` VALUES (2403, 'ָɽ', 24);
INSERT INTO `#@__area` VALUES (2404, '', 24);
INSERT INTO `#@__area` VALUES (2405, '', 24);
INSERT INTO `#@__area` VALUES (2406, 'ɽ', 24);
INSERT INTO `#@__area` VALUES (2407, 'Ĳ', 24);
INSERT INTO `#@__area` VALUES (2408, '', 24);
INSERT INTO `#@__area` VALUES (2409, '', 24);
INSERT INTO `#@__area` VALUES (2410, '', 24);
INSERT INTO `#@__area` VALUES (2411, '', 24);
INSERT INTO `#@__area` VALUES (2412, 'Ͳ', 24);
INSERT INTO `#@__area` VALUES (2413, 'ٸ', 24);
INSERT INTO `#@__area` VALUES (2414, 'ɳ', 24);
INSERT INTO `#@__area` VALUES (2415, '', 24);
INSERT INTO `#@__area` VALUES (2416, 'ֶ', 24);
INSERT INTO `#@__area` VALUES (2417, 'ˮ', 24);
INSERT INTO `#@__area` VALUES (2418, 'ͤ', 24);
INSERT INTO `#@__area` VALUES (2419, '', 24);
INSERT INTO `#@__area` VALUES (25, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2501, '', 25);
INSERT INTO `#@__area` VALUES (2502, '', 25);
INSERT INTO `#@__area` VALUES (2503, 'Ϫ', 25);
INSERT INTO `#@__area` VALUES (2504, 'ɽ', 25);
INSERT INTO `#@__area` VALUES (2505, 'ͨ', 25);
INSERT INTO `#@__area` VALUES (2506, '˼é', 25);
INSERT INTO `#@__area` VALUES (2507, 'ٲ׵', 25);
INSERT INTO `#@__area` VALUES (2508, '', 25);
INSERT INTO `#@__area` VALUES (2509, 'ɽ', 25);
INSERT INTO `#@__area` VALUES (2510, '', 25);
INSERT INTO `#@__area` VALUES (2511, '˫', 25);
INSERT INTO `#@__area` VALUES (2512, '', 25);
INSERT INTO `#@__area` VALUES (2513, '', 25);
INSERT INTO `#@__area` VALUES (2514, 'º', 25);
INSERT INTO `#@__area` VALUES (2515, 'ŭ', 25);
INSERT INTO `#@__area` VALUES (2516, '', 25);
INSERT INTO `#@__area` VALUES (26, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2601, '', 26);
INSERT INTO `#@__area` VALUES (2602, 'ˮ', 26);
INSERT INTO `#@__area` VALUES (2603, '', 26);
INSERT INTO `#@__area` VALUES (2604, '˳', 26);
INSERT INTO `#@__area` VALUES (2605, 'ͭʵ', 26);
INSERT INTO `#@__area` VALUES (2606, 'Ͻڵ', 26);
INSERT INTO `#@__area` VALUES (2607, 'ǭ', 26);
INSERT INTO `#@__area` VALUES (2608, 'ǭ', 26);
INSERT INTO `#@__area` VALUES (2609, 'ǭ', 26);
INSERT INTO `#@__area` VALUES (27, '', 0);
INSERT INTO `#@__area` VALUES (2701, '', 27);
INSERT INTO `#@__area` VALUES (2702, '', 27);
INSERT INTO `#@__area` VALUES (2703, '', 27);
INSERT INTO `#@__area` VALUES (2704, 'ɽϵ', 27);
INSERT INTO `#@__area` VALUES (2705, 'տ', 27);
INSERT INTO `#@__area` VALUES (2706, '', 27);
INSERT INTO `#@__area` VALUES (2707, '֥', 27);
INSERT INTO `#@__area` VALUES (28, 'ʡ', 0);
INSERT INTO `#@__area` VALUES (2801, '', 28);
INSERT INTO `#@__area` VALUES (2802, '', 28);
INSERT INTO `#@__area` VALUES (2803, '', 28);
INSERT INTO `#@__area` VALUES (2804, 'ˮ', 28);
INSERT INTO `#@__area` VALUES (2805, '', 28);
INSERT INTO `#@__area` VALUES (2806, '', 28);
INSERT INTO `#@__area` VALUES (2807, '', 28);
INSERT INTO `#@__area` VALUES (2808, 'ƽ', 28);
INSERT INTO `#@__area` VALUES (2809, '', 28);
INSERT INTO `#@__area` VALUES (2810, '¤ϵ', 28);
INSERT INTO `#@__area` VALUES (2811, 'Ҵ', 28);
INSERT INTO `#@__area` VALUES (2812, 'Ȫ', 28);
INSERT INTO `#@__area` VALUES (2813, '', 28);
INSERT INTO `#@__area` VALUES (2814, '', 28);
INSERT INTO `#@__area` VALUES (29, '', 0);
INSERT INTO `#@__area` VALUES (2901, '', 29);
INSERT INTO `#@__area` VALUES (2902, 'ʯɽ', 29);
INSERT INTO `#@__area` VALUES (2903, '', 29);
INSERT INTO `#@__area` VALUES (2904, 'ԭ', 29);
INSERT INTO `#@__area` VALUES (30, 'ຣʡ', 0);
INSERT INTO `#@__area` VALUES (3001, '', 30);
INSERT INTO `#@__area` VALUES (3002, '', 30);
INSERT INTO `#@__area` VALUES (3003, '', 30);
INSERT INTO `#@__area` VALUES (3004, '', 30);
INSERT INTO `#@__area` VALUES (3005, '', 30);
INSERT INTO `#@__area` VALUES (3006, '', 30);
INSERT INTO `#@__area` VALUES (3007, '', 30);
INSERT INTO `#@__area` VALUES (3008, '', 30);
INSERT INTO `#@__area` VALUES (31, '½', 0);
INSERT INTO `#@__area` VALUES (3101, '³ľ', 31);
INSERT INTO `#@__area` VALUES (3102, '', 31);
INSERT INTO `#@__area` VALUES (3103, 'ʯ', 31);
INSERT INTO `#@__area` VALUES (3104, '³', 31);
INSERT INTO `#@__area` VALUES (3105, 'ܵ', 31);
INSERT INTO `#@__area` VALUES (3106, '', 31);
INSERT INTO `#@__area` VALUES (3107, '', 31);
INSERT INTO `#@__area` VALUES (3108, 'ʲ', 31);
INSERT INTO `#@__area` VALUES (3109, '', 31);
INSERT INTO `#@__area` VALUES (3110, '', 31);
INSERT INTO `#@__area` VALUES (3111, '', 31);
INSERT INTO `#@__area` VALUES (3112, '', 31);
INSERT INTO `#@__area` VALUES (3113, '', 31);
INSERT INTO `#@__area` VALUES (32, '', 0);
INSERT INTO `#@__area` VALUES (33, '', 0);

DROP TABLE IF EXISTS `#@__channeltype`;
CREATE TABLE `#@__channeltype` (
  `ID` smallint(6) NOT NULL default '0',
  `nid` varchar(10) NOT NULL default '',
  `typename` varchar(30) NOT NULL default '',
  `addtable` varchar(30) NOT NULL default '',
  `addcon` varchar(30) NOT NULL default '',
  `mancon` varchar(30) NOT NULL default '',
  `editcon` varchar(30) NOT NULL default '',
  `fieldset` text NOT NULL,
  `listadd` varchar(250) NOT NULL default '',
  `issystem` smallint(6) NOT NULL default '0',
  `isshow` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`ID`),
  KEY `channelIndex` (`nid`,`typename`,`addcon`,`mancon`,`editcon`,`addtable`,`isshow`)
) TYPE=MyISAM;

INSERT INTO `#@__channeltype` VALUES (1, 'article', 'ͨ', '#@__addonarticle', 'article_add.php', 'content_list.php', 'article_edit.php', '<field:body type=''htmltext'' isnull=''true'' default='''' rename='''' page=''split''/>', '', 1, 1);
INSERT INTO `#@__channeltype` VALUES (2, 'image', 'ͼƬ', '#@__addonimages', 'album_add.php', 'content_i_list.php', 'album_edit.php', '<field:pagestyle type=''number'' isnull=''true'' default=''1'' rename='''' />\r\n\r\n<field:imgurls type=''img'' isnull=''true'' default='''' rename='''' page=''split''/>\r\n', '', 1, 1);
INSERT INTO `#@__channeltype` VALUES (3, 'soft', '', '#@__addonsoft', 'soft_add.php', 'content_i_list.php', 'soft_edit.php', '<field:filetype type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:language type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:softtype type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:accredit type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:os type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:softrank type=''int'' isnull=''true'' default=''3'' rename='''' function=''GetRankStar(@me)''/>\r\n\r\n<field:officialUrl type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:officialDemo type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:softsize type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:softlinks type=''softlinks'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:introduce type=''htmltext'' isnull=''tr\nu\ne'' default='''' rename='''' />\r\n\n', 'filetype,language,softtype,os,accredit,softrank', 1, 1);
INSERT INTO `#@__channeltype` VALUES (4, 'flash', 'Flash', '#@__addonflash', 'flash_add.php', 'content_i_list.php', 'flash_edit.php', '<field:filesize type=''text'' isnull=''true'' default=''1 MB'' rename='''' />\r\n\r\n<field:playtime type=''text'' isnull=''true'' default=''3 '' rename='''' />\r\n\r\n<field:flashtype type=''text'' isnull=''true'' default='''' rename='''' />\r\n\r\n<field:flashrank type=''int'' isnull=''true'' default=''3'' rename='''' function=''GetRankStar(@me)''/>\r\n\r\n<field:width type=''int'' isnull=''true'' default=''500'' rename='''' />\r\n\r\n<field:height type=''int'' isnull=''true'' default=''400'' rename='''' />\r\n\r\n<field:flashurl type=''text'' isnull=''true'' default='''' rename='''' />\r\n', 'filesize,playtime,flashtype,flashrank', 1, 1);
INSERT INTO `#@__channeltype` VALUES (-1, 'spec', 'ר', '#@__addonspec', 'spec_add.php', 'content_s_list.php', 'spec_edit.php', '<field:note type=''specialtopic'' isnull=''true'' default='''' rename=''''/>', '', 1, 1);


DROP TABLE IF EXISTS `#@__co_dataswitch`;
CREATE TABLE `#@__co_dataswitch` (
  `aid` int(11) NOT NULL auto_increment,
  `notename` varchar(100) NOT NULL default '',
  `channelid` int(11) NOT NULL default '0',
  `description` varchar(250) NOT NULL default '',
  `addtime` int(11) NOT NULL default '0',
  `notes` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `notename` (`notename`,`channelid`,`description`,`addtime`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__co_exrule`;
CREATE TABLE `#@__co_exrule` (
  `aid` int(11) NOT NULL auto_increment,
  `channelid` int(11) NOT NULL default '0',
  `rulename` varchar(100) NOT NULL default '',
  `etype` varchar(10) NOT NULL default '',
  `dtime` int(11) NOT NULL default '0',
  `ruleset` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `rulename` (`rulename`,`etype`,`dtime`,`channelid`)
) TYPE=MyISAM;


INSERT INTO `#@__co_exrule` VALUES (1, 1, 'Dedeģ', 'ǰϵͳ', 1159585450, '\r\n{dede:note \r\n  rulename=''Dedeģ''\r\n  etype=''ǰϵͳ''\r\n  tablename=''#@__archives,#@__addonarticle''\r\n  autofield=''ID''\r\n  synfield=''aid''\r\n  channelid=''1''\r\n/}\r\n	{dede:field name=''typeid'' comment=''ĿID'' intable=''#@__archives'' source=''value''}{tid}{/dede:field}\r\n{dede:field name=''title'' comment=''±'' intable=''#@__archives'' source=''export''}{/dede:field}\r\n{dede:field name=''sortrank'' comment=''򼶱'' intable=''#@__archives'' source=''function''}@me = time();{/dede:field}\r\n{dede:field name=''arcrank'' comment=''ĵȨ'' intable=''#@__archives'' source=''value''}{rank}{/dede:field}\r\n{dede:field name=''channel'' comment=''Ƶ'' intable=''#@__archives'' source=''value''}{cid}{/dede:field}\r\n{dede:field name=''writer'' comment='''' intable=''#@__archives'' source=''export''}{/dede:field}\r\n{dede:field name=''litpic'' comment=''ͼ'' intable=''#@__archives'' source=''function''}@me = @litpic;{/dede:field}\r\n{dede:field name=''pubdate'' comment=''ʱ'' intable=''#@__archives'' source=''function''}if(@me!="") @me = GetMkTime(@me);\r\nelse @me = time();{/dede:field}\r\n{dede:field name=''senddate'' comment=''¼ʱ'' intable=''#@__archives'' source=''function''}@me = time();{/dede:field}\r\n{dede:field name=''typeid'' comment=''ĿID'' intable=''#@__addonarticle'' source=''value''}{tid}{/dede:field}\r\n{dede:field name=''body'' comment='''' intable=''#@__addonarticle'' source=''export''}{/dede:field}\r\n{dede:field name=''adminID'' comment=''ԱID'' intable=''#@__archives'' source=''value''}{admin}{/dede:field}\r\n');


DROP TABLE IF EXISTS `#@__co_listenurl`;
CREATE TABLE `#@__co_listenurl` (
  `nid` int(11) NOT NULL default '0',
  `url` varchar(150) NOT NULL default ''
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__co_mediaurl`;
CREATE TABLE `#@__co_mediaurl` (
  `nid` int(11) NOT NULL default '0',
  `rurl` varchar(150) NOT NULL default '',
  `nurl` varchar(80) NOT NULL default '',
  KEY `nurl` (`nurl`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__conote`;
CREATE TABLE `#@__conote` (
  `nid` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL default '0',
  `gathername` varchar(50) NOT NULL default '',
  `language` varchar(10) NOT NULL default 'gb2312',
  `savetime` int(11) NOT NULL default '0',
  `lasttime` int(11) NOT NULL default '0',
  `noteinfo` text NOT NULL,
  PRIMARY KEY  (`nid`),
  KEY `conote` (`typeid`,`gathername`,`lasttime`,`savetime`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__courl`;
CREATE TABLE `#@__courl` (
  `aid` int(11) NOT NULL auto_increment,
  `nid` int(11) NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `url` varchar(150) NOT NULL default '',
  `dtime` int(11) NOT NULL default '0',
  `isdown` smallint(6) NOT NULL default '0',
  `isex` smallint(6) NOT NULL default '0',
  `result` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `title` (`title`,`url`,`dtime`,`nid`,`isdown`,`isex`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__error`;
CREATE TABLE `#@__error` (
  `aid` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `dtime` int(11) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  `info` mediumtext NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `errIndex` (`title`,`ip`,`dtime`,`url`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__feedback`;
CREATE TABLE `#@__feedback` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `aid` int(11) unsigned NOT NULL default '0',
  `typeid` int(11) NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `arctitle` varchar(60) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `msg` text NOT NULL,
  `ischeck` smallint(6) NOT NULL default '0',
  `dtime` int(11) NOT NULL default '0',
  `email` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `feedbackindex` (`aid`,`typeid`,`username`,`arctitle`,`ip`,`ischeck`,`dtime`,`email`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__flink`;
CREATE TABLE `#@__flink` (
  `ID` int(11) NOT NULL auto_increment,
  `sortrank` int(11) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  `webname` varchar(30) NOT NULL default '',
  `msg` varchar(250) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `logo` varchar(100) NOT NULL default '',
  `dtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `typeid` int(11) NOT NULL default '0',
  `ischeck` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__flinktype`;
CREATE TABLE `#@__flinktype` (
  `ID` int(11) NOT NULL auto_increment,
  `typename` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

INSERT INTO `#@__flinktype` VALUES (1, 'ۺվ');
INSERT INTO `#@__flinktype` VALUES (2, '');
INSERT INTO `#@__flinktype` VALUES (3, '');
INSERT INTO `#@__flinktype` VALUES (4, '');
INSERT INTO `#@__flinktype` VALUES (5, '');
INSERT INTO `#@__flinktype` VALUES (6, 'Ϣ');
INSERT INTO `#@__flinktype` VALUES (7, '̳');
INSERT INTO `#@__flinktype` VALUES (8, '');


DROP TABLE IF EXISTS `#@__guestbook`;
CREATE TABLE `#@__guestbook` (
  `ID` int(11) NOT NULL auto_increment,
  `uname` varchar(30) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `homepage` varchar(80) NOT NULL default '',
  `qq` varchar(20) NOT NULL default '',
  `face` varchar(10) NOT NULL default '',
  `msg` text NOT NULL,
  `ip` varchar(20) NOT NULL default '',
  `dtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ischeck` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__homepageset`;
CREATE TABLE `#@__homepageset` (
  `templet` varchar(100) NOT NULL default '',
  `position` varchar(50) NOT NULL default ''
) TYPE=MyISAM;


INSERT INTO `#@__homepageset` VALUES ('dedecmsv31/newhome.html', '../index.html');


DROP TABLE IF EXISTS `#@__keywords`;
CREATE TABLE `#@__keywords` (
  `aid` int(11) NOT NULL auto_increment,
  `keyword` varchar(20) NOT NULL default '',
  `rank` int(11) NOT NULL default '0',
  `sta` smallint(6) NOT NULL default '1',
  `rpurl` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`aid`),
  KEY `keyword` (`keyword`,`rank`,`sta`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__log`;
CREATE TABLE `#@__log` (
  `lid` int(11) NOT NULL auto_increment,
  `adminid` int(11) NOT NULL default '0',
  `filename` varchar(100) NOT NULL default '',
  `method` varchar(10) NOT NULL default '',
  `query` varchar(250) NOT NULL default '',
  `cip` varchar(20) NOT NULL default '',
  `dtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__member`;
CREATE TABLE `#@__member` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `userid` varchar(32) NOT NULL default '',
  `pwd` varchar(32) NOT NULL default '',
  `uname` varchar(20) NOT NULL default '',
  `sex` char(2) NOT NULL default '1',
  `birthday` date NOT NULL default '0000-00-00',
  `membertype` int(11) NOT NULL default '0',
  `uptype` int(11) NOT NULL default '0',
  `upmoney` smallint(6) NOT NULL default '0',
  `money` int(11) NOT NULL default '0',
  `weight` varchar(10) NOT NULL default '',
  `height` varchar(10) NOT NULL default '',
  `job` varchar(10) NOT NULL default '',
  `province` smallint(5) unsigned NOT NULL default '1',
  `city` varchar(20) NOT NULL default '',
  `myinfo` varchar(250) default NULL,
  `mybb` varchar(250) NOT NULL default '',
  `tel` varchar(30) default NULL,
  `oicq` varchar(15) default NULL,
  `email` varchar(50) NOT NULL default '',
  `homepage` varchar(50) default NULL,
  `jointime` int(11) NOT NULL default '0',
  `joinip` varchar(20) NOT NULL default '',
  `logintime` int(11) NOT NULL default '0',
  `loginip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `memberMain` (`userid`,`pwd`,`uname`,`sex`,`birthday`,`membertype`,`uptype`,`money`,`email`,`upmoney`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__memberstow`;
CREATE TABLE `#@__memberstow` (
  `aid` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `arcid` int(11) NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `addtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__moneyrecord`;
CREATE TABLE `#@__moneyrecord` (
  `ID` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `money` int(11) NOT NULL default '0',
  `dtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__myad`;
CREATE TABLE `#@__myad` (
  `aid` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL default '0',
  `tagname` varchar(30) NOT NULL default '',
  `adname` varchar(100) NOT NULL default '',
  `timeset` smallint(6) NOT NULL default '0',
  `starttime` int(11) NOT NULL default '0',
  `endtime` int(11) NOT NULL default '0',
  `normbody` text NOT NULL,
  `expbody` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `tagname` (`tagname`,`adname`,`typeid`,`timeset`,`endtime`,`starttime`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__mynews`;
CREATE TABLE `#@__mynews` (
  `aid` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `writer` varchar(50) NOT NULL default '',
  `senddate` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `mynewsindex` (`typeid`,`title`,`writer`,`senddate`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__mytag`;
CREATE TABLE `#@__mytag` (
  `aid` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL default '0',
  `tagname` varchar(30) NOT NULL default '',
  `timeset` smallint(6) NOT NULL default '0',
  `starttime` int(11) NOT NULL default '0',
  `endtime` int(11) NOT NULL default '0',
  `normbody` text NOT NULL,
  `expbody` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__plus`;
CREATE TABLE `#@__plus` (
  `aid` int(11) NOT NULL auto_increment,
  `plusname` varchar(30) NOT NULL default '',
  `menustring` varchar(150) NOT NULL default '',
  `writer` varchar(60) NOT NULL default '',
  `isshow` smallint(6) NOT NULL default '1',
  `filelist` text NOT NULL,
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;


INSERT INTO `#@__plus` VALUES (1, 'ļ', '<m:item name=''ļ'' link=''file_manage_main.php'' rank=''plus_ļ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (2, 'վŷ', '<m:item name=''վŷ'' link=''mynews_main.php'' rank=''plus_վŷ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (3, 'ģ', '<m:item name=''ģ'' link=''friendlink_main.php'' rank=''plus_ģ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (4, 'Բģ', '<m:item name=''Բģ'' link=''catalog_do.php?dopost=guestbook'' rank=''plus_Բģ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (5, 'ͶƱģ', '<m:item name=''ͶƱģ'' link=''vote_main.php'' rank=''plus_ͶƱģ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (6, '̳չ', '<m:item name=''̳չ'' link=''bbs_addons.php'' rank=''plus_̳չ'' target=''main'' />', 'ITͼ', 1, '');
INSERT INTO `#@__plus` VALUES (7, '', '<m:item name='''' link=''ad_main.php'' rank=''plus_'' target=''main'' />', 'ITͼ', 1, '');


DROP TABLE IF EXISTS `#@__sgpage`;
CREATE TABLE `#@__sgpage` (
  `aid` int(11) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `ismake` smallint(6) NOT NULL default '1',
  `filename` varchar(150) NOT NULL default '',
  `uptime` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `title` (`title`,`ismake`,`filename`,`uptime`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__softconfig`;
CREATE TABLE `#@__softconfig` (
  `downtype` smallint(6) NOT NULL default '0',
  `ismoresite` smallint(6) NOT NULL default '0',
  `gotojump` smallint(6) NOT NULL default '0',
  `sites` text NOT NULL,
  KEY `downtype` (`downtype`,`ismoresite`,`gotojump`)
) TYPE=MyISAM;


INSERT INTO `#@__softconfig` VALUES (1, 0, 1, '');


DROP TABLE IF EXISTS `#@__sysconfig`;
CREATE TABLE `#@__sysconfig` (
  `aid` int(11) NOT NULL auto_increment,
  `varname` varchar(20) NOT NULL default '',
  `info` varchar(100) NOT NULL default '',
  `value` varchar(250) NOT NULL default '',
  `type` varchar(10) NOT NULL default 'string',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;

INSERT INTO `#@__sysconfig` VALUES (1, 'cfg_basehost', 'վַ', '', 'string');
INSERT INTO `#@__sysconfig` VALUES (2, 'cfg_cmspath', 'DedeCmsװĿ¼', '', 'string');
INSERT INTO `#@__sysconfig` VALUES (3, 'cfg_cookie_encode', 'cookie', '', 'string');
INSERT INTO `#@__sysconfig` VALUES (4, 'cfg_indexurl', 'ҳҳ', '', 'string');
INSERT INTO `#@__sysconfig` VALUES (5, 'cfg_backup_dir', 'ݱĿ¼ڹĿ¼ڣ', 'backup_data', 'string');
INSERT INTO `#@__sysconfig` VALUES (6, 'cfg_indexname', 'ҳ', 'ҳ', 'string');
INSERT INTO `#@__sysconfig` VALUES (7, 'cfg_webname', 'վ', '֯ݹϵͳ', 'string');
INSERT INTO `#@__sysconfig` VALUES (8, 'cfg_adminemail', 'վEMAIL', 'admin@youremail.com', 'string');
INSERT INTO `#@__sysconfig` VALUES (9, 'cfg_html_editor', 'Html༭ѡ֧ dede  fck', 'dede', 'string');
INSERT INTO `#@__sysconfig` VALUES (10, 'cfg_arcdir', 'ĵHTMLĬϱ·', '/html', 'string');
INSERT INTO `#@__sysconfig` VALUES (11, 'cfg_medias_dir', 'ͼƬ/ϴļĬ·', '/upimg', 'string');
INSERT INTO `#@__sysconfig` VALUES (12, 'cfg_ddimg_width', 'ͼĬϿ', '200', 'string');
INSERT INTO `#@__sysconfig` VALUES (13, 'cfg_ddimg_height', 'ͼĬϸ߶', '150', 'string');
INSERT INTO `#@__sysconfig` VALUES (14, 'cfg_album_width', 'ͼĬʾͼƬĴС', '600', 'string');
INSERT INTO `#@__sysconfig` VALUES (15, 'cfg_imgtype', 'ͼƬļ', 'jpg|gif|png', 'string');
INSERT INTO `#@__sysconfig` VALUES (16, 'cfg_softtype', 'ļ', 'exe|zip|gz|rar|iso|doc|xsl|ppt|wps', 'string');
INSERT INTO `#@__sysconfig` VALUES (17, 'cfg_mediatype', 'ýļ', 'swf|mpg|dat|avi|mp3|rm|rmvb|wmv|asf|vob|wma|wav|mid|mov', 'string');
INSERT INTO `#@__sysconfig` VALUES (18, 'cfg_specnote', 'רڵ', '6', 'string');
INSERT INTO `#@__sysconfig` VALUES (19, 'cfg_list_symbol', 'Ŀλõļ', '>', 'string');
INSERT INTO `#@__sysconfig` VALUES (20, 'cfg_notallowstr', 'ۼԲôʻ', '||||||fuck|ȥ||߹|͵|ɫ||sex|B', 'string');
INSERT INTO `#@__sysconfig` VALUES (21, 'cfg_feedbackcheck', 'ۼ(/)', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (22, 'cfg_keyword_replace', 'ؼ滻(/)ʹñܻӰHTMLٶ', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (23, 'cfg_fck_xhtml', '༭(/)ʹXHTML', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (24, 'cfg_df_style', 'ģĬϷ', 'default', 'string');
INSERT INTO `#@__sysconfig` VALUES (25, 'cfg_multi_site', '(/)ֶ֧վ㣬󸽼Ŀӡarclistþַ', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (26, 'cfg_#@__cache', '(/)DedeģĻ湦', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (27, 'cfg_#@__log', '(/)־', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (28, 'cfg_powerby', 'վȨϢ', '<a href=''http://www.dedecms.com'' target=''_blank''>Power by DedeCms</a>', 'string');
INSERT INTO `#@__sysconfig` VALUES (29, 'cfg_arcsptitle', '(/)ҳ⣬ӰHTMLٶ', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (30, 'cfg_arcautosp', '(/)Զҳ', '', 'bool');
INSERT INTO `#@__sysconfig` VALUES (31, 'cfg_arcautosp_size', 'ԶҳСλ: K', '5', 'string');
INSERT INTO `#@__sysconfig` VALUES (32, 'cfg_auot_description', 'ԶժҪȣ0-2500ʾã', '250', 'string');


DROP TABLE IF EXISTS `#@__uploads`;
CREATE TABLE `#@__uploads` (
  `aid` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `mediatype` smallint(6) NOT NULL default '1',
  `width` varchar(10) NOT NULL default '',
  `height` varchar(10) NOT NULL default '',
  `playtime` varchar(10) NOT NULL default '',
  `filesize` varchar(10) NOT NULL default '',
  `uptime` int(11) NOT NULL default '0',
  `adminid` int(11) NOT NULL default '0',
  `memberid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;


DROP TABLE IF EXISTS `#@__vote`;
CREATE TABLE `#@__vote` (
  `aid` int(11) NOT NULL auto_increment,
  `votename` varchar(50) NOT NULL default '',
  `starttime` int(11) NOT NULL default '0',
  `endtime` int(11) NOT NULL default '0',
  `totalcount` int(11) NOT NULL default '0',
  `ismore` smallint(6) NOT NULL default '0',
  `votenote` text NOT NULL,
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;


INSERT INTO `#@__vote` VALUES (1, 'ǴĶ֪վģ', 1142784000, 1145376000, 1, 0, '<v:note id=''1'' count=''1''>ѽ</v:note>\r\n<v:note id=''2'' count=''0''>Żվ</v:note>\r\n<v:note id=''3'' count=''0''>Googleٶ</v:note>\r\n<v:note id=''4'' count=''0''>վϵ</v:note>\r\n<v:note id=''5'' count=''0''>;</v:note>\r\n');
