# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2004 年 12 月 08 日 23:23
# 服务器版本: 4.0.14
# PHP 版本: 4.3.3
# 
# 数据库 : `okphp_en`
# 

# --------------------------------------------------------

#
# 表的结构 `{prefix}attachment`
#

DROP TABLE IF EXISTS `{prefix}attachment`;
CREATE TABLE `{prefix}attachment` (
  `id` int(11) NOT NULL auto_increment,
  `belong_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `location` text NOT NULL,
  `hits` int(11) NOT NULL default '0',
  `size` varchar(40) NOT NULL default '0',
  `type` varchar(40) NOT NULL default '',
  `poster` varchar(50) NOT NULL default '',
  `filedata` mediumtext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `belong_id` (`belong_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}attachment`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}basic`
#

DROP TABLE IF EXISTS `{prefix}basic`;
CREATE TABLE `{prefix}basic` (
  `id` varchar(12) NOT NULL default '',
  `web_name` varchar(255) NOT NULL default '',
  `web_url` varchar(255) NOT NULL default '',
  `web_email` varchar(255) NOT NULL default '',
  `web_header` text NOT NULL,
  `web_footer` text NOT NULL,
  `settings` text NOT NULL,
  `designated_ip` text NOT NULL,
  `attitude` tinyint(4) NOT NULL default '0',
  `last_update` int(11) NOT NULL default '0',
  `cache_date` int(11) NOT NULL default '0',
  `order_moderator` text NOT NULL
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}basic`
#

INSERT INTO `{prefix}basic` VALUES ('1', 'Okphp CMS', 'http://yourdomain', 'yourname@yourdomain', '', '<font size="1">Copyright 漏 2003-2004 by OKPHP Group, All rights reserved. </font><br>\r\n', '1&20&1&&30&&bbs_&12&12&downloads&utf-8&./lang/en&themes/default&themes/default/images/blue&themes/default/css/blue&m-d&8&500&0&200&1&25&3&4&10&1&100&20&6&6&0&Our site is on repair, please wait for a few hours, thank you!&100&100&0&100&20&0&0&0&0', '', 0, 1102518214, 1082649062, '');

# --------------------------------------------------------

#
# 表的结构 `{prefix}blocks`
#

DROP TABLE IF EXISTS `{prefix}blocks`;
CREATE TABLE `{prefix}blocks` (
  `id` int(11) NOT NULL auto_increment,
  `type_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `position` tinyint(4) NOT NULL default '0',
  `order_num` int(11) NOT NULL default '0',
  `home_page` tinyint(4) NOT NULL default '0',
  `type_page` tinyint(4) NOT NULL default '0',
  `detail_page` tinyint(4) NOT NULL default '0',
  `block_file` varchar(100) NOT NULL default '',
  `table_class` varchar(50) NOT NULL default '',
  `td1_class` varchar(50) NOT NULL default '',
  `td2_class` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=56 ;

#
# 导出表中的数据 `{prefix}blocks`
#

INSERT INTO `{prefix}blocks` VALUES (50, 0, 'Poll', '', 4, 55, 1, 0, 0, 'block_poll.php', 'table1', 'td1_3', 'td2_1');
INSERT INTO `{prefix}blocks` VALUES (13, 0, 'Friendly Links', '<a href=\'http://yahoo.com\'>Yahoo!</a>\r\n\r\n<a href=\'http://google.com\'>Google</a>\r\n\r\nYou can add your links \r\nhere..', 4, 14, 1, 1, 1, '0', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (36, 0, 'Test Block', 'This is a test Block.\r\n\r\nYou can Edit/Delete it in adminCP:\r\n<a href=\'admin/index.php\'>adminCP</a>', 1, 36, 1, 1, 0, '0', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (37, 0, 'Lastest Members', '', 1, 37, 1, 1, 0, 'lastest_members.php', '0', 'td1_2', '0');
INSERT INTO `{prefix}blocks` VALUES (53, 0, 'Welcome to Okphp\'s World!', 'Thank you for using Okphp CMS!\r\n\r\nThis is a test block, you can delete/edit it in <a href=\'admin/index.php\'>\r\nadminCP</a>.\r\n\r\nIf you want to get technic support, or report bugs, Please visit our web site:\r\n<a href=\'http://okphp.com\'>http://okphp.com</a>\r\n\r\nWe also provide Okphp BBS, which can bind with Okphp CMS perfectly.\r\n\r\nWish you like it.', 3, 48, 1, 0, 0, '0', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (54, 0, 'Whois Online', '', 4, 53, 1, 1, 0, 'whois_online.php', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (55, 0, 'Category', '', 4, 54, 1, 1, 0, 'category.php', '0', '0', '0');

# --------------------------------------------------------

#
# 表的结构 `{prefix}cache_file`
#

DROP TABLE IF EXISTS `{prefix}cache_file`;
CREATE TABLE `{prefix}cache_file` (
  `id` int(11) NOT NULL default '0',
  `timeline` int(11) NOT NULL default '0',
  `cachedata` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}cache_file`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}cache_special`
#

DROP TABLE IF EXISTS `{prefix}cache_special`;
CREATE TABLE `{prefix}cache_special` (
  `id` int(11) NOT NULL default '0',
  `timeline` int(11) NOT NULL default '0',
  `cachedata` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}cache_special`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}cache_type`
#

DROP TABLE IF EXISTS `{prefix}cache_type`;
CREATE TABLE `{prefix}cache_type` (
  `id` int(11) NOT NULL default '0',
  `timeline` int(11) NOT NULL default '0',
  `cachedata` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}cache_type`
#

INSERT INTO `{prefix}cache_type` VALUES (0, 1102518214, '<html>\r\n<head>\r\n<title>Okphp CMS - powered by okphp CMS</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n<link href="./css/default/css.css" rel="stylesheet" type="text/css">\r\n</head>\r\n<body>\r\n\r\n  <center>\r\n<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableline">\r\n  <tr> \r\n    <td width="34%" align="center"><img src="images/logo.gif" ></td>\r\n    <td width="66%" valign="bottom" align="right">\r\n<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="468" height="60">\r\n  <param name=movie value="images/banner1.swf">\r\n  <param name=quality value=high>\r\n  <embed src="images/banner1.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60">\r\n  </embed> \r\n</object> \r\n</td>\r\n  </tr>\r\n</table>\r\n</center>\r\n<table width="778" border="0" cellpadding="2" cellspacing="0" class="user_cp_table">\r\n    <tr> \r\n      <td align="right"> \r\n        <!--user_area-->\r\n        | <span style="CURSOR: hand" onClick="window.external.addFavorite(\'http://yourdomain\',\'Okphp CMS\')" ><font class="user_cp"></font></span> \r\n        | <a href="#" onclick="var strHref=window.location.href;this.style.behavior=\'url(#default#homepage)\';this.setHomePage(\'http://yourdomain\');" style="CURSOR: hand"><font class="user_cp"></font></a> \r\n        &nbsp; &nbsp;&nbsp;&nbsp;</td>\r\n    </tr>\r\n  </table>\r\n  <table width="778" border="0" cellspacing="0" cellpadding="0" class="topbar">\r\n    <tr> \r\n      <td align="right" background="./images/default/top_bg.gif"> \r\n        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n          <tr> \r\n            <td width="14%"><a href="http://yourdomain"><img src="./images/default/logo.gif" border="0" ></a></td>\r\n            <td align="right" valign="top">&nbsp;</td>\r\n          </tr>\r\n        </table></td>\r\n    </tr>\r\n  </table>\r\n  <table width="778" height="30" border="0" cellpadding="0" cellspacing="0" class="gate_way">\r\n    <tr> \r\n      <td  align="center" background="./images/default/gate_way_bg.gif" bgcolor="#0080C0"> \r\n        <a href=\'index.php\'><font class="topgategory">Home</a> | <a href=\'index.php?action=list_file&type_id=5\'><font class="topgategory">News</font></a> | <a href=\'index.php?action=list_file&type_id=2\'><font class="topgategory">Shop</font></a> | <a href=\'index.php?action=list_file&type_id=1\'><font class="topgategory">GuestBook</font></a> </td>\r\n    </tr>\r\n  </table>\r\n  <table width="778" border="0" cellpadding="0" cellspacing="0" class="category">\r\n    <tr> \r\n      <td>&nbsp;&nbsp;<img src="./images/default/folder_open.gif" > Home </td>\r\n    </tr>\r\n  </table>\r\n  <table width="778" border="0" cellpadding="3" cellspacing="0" class="tableline">\r\n    <tr> \r\n      \r\n    <td valign="top" rowspan="2"> \r\n      \r\n      <table border="0" cellspacing="1" cellpadding="2" class="table1">\r\n          <tr> \r\n            <td class="td1_3" align="center">投票</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_1"><form action=\'index.php\' method=\'post\' target=\'_blank\'>test poll<br><input type=\'radio\' name=\'sid\' value=\'2\'>s1<br><input type=\'radio\' name=\'sid\' value=\'3\'>s2<br><input type=\'radio\' name=\'sid\' value=\'4\'>s3<br><input type=\'radio\' name=\'sid\' value=\'5\'>s4<br><input type=\'radio\' name=\'sid\' value=\'6\'>s5<br> <center>\r\n			  <input type=\'hidden\' name=\'action\' value=\'poll\'>\r\n              <input type=\'submit\' name=\'Submit\' value=\' Poll \' class=\'catbutton\'>\r\n              <br>\r\n              [<a href=\'index.php?action=poll\' target=\'_blank\'>View</a>]\r\n			  </center></form></td>\r\n          </tr>\r\n        </table>\r\n        <p>\r\n          \r\n      <table border="0" cellspacing="1" cellpadding="2" class="block_left">\r\n          <tr> \r\n            <td class="td1_left" align="center">导航</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_left"><a href=\'index.php?action=list_file&type_id=5\'><img src=\'./images/default/folder.gif\' border=\'0\'> News</a><br><a href=\'index.php?action=list_file&type_id=2\'><img src=\'./images/default/folder.gif\' border=\'0\'> Shop</a><br><a href=\'index.php?action=list_file&type_id=1\'><img src=\'./images/default/folder.gif\' border=\'0\'> GuestBook</a><br></td>\r\n          </tr>\r\n        </table>\r\n        <p>\r\n          \r\n      <table border="0" cellspacing="1" cellpadding="2" class="block_left">\r\n          <tr> \r\n            <td class="td1_left" align="center">友情链接</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_left"><a href=\'http://yahoo.com\'>Yahoo!</a><br />\r\n<br />\r\n<a href=\'http://google.com\'>Google</a><br />\r\n<br />\r\nYou can add your links <br />\r\nhere..</td>\r\n          </tr>\r\n        </table>\r\n        <p>\r\n          \r\n        </p></td>\r\n      \r\n    <td align="center" width="100%" valign="top"> \r\n      \r\n      <table border="0" cellspacing="1" cellpadding="2" class="block_top">\r\n          <tr> \r\n            <td class="td1_top" align="center">欢迎来到OKPHP的世界!</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_top">感谢您使用Okphp CMS（Okphp 网站内容管理系统）！<br />\r\n<br />\r\n您目前看到的网站内容，是我们作为演示加上去的，您可以通过<a href=\'admin/index.php\'>后台管理</a>来修改或删除它们。<br />\r\n<br />\r\nOkphp CMS的各项管理功能很容易上手，您可以慢慢的了解。<br />\r\n如果使用中遇到问题，或者发现程序有错误，请与我们取得联系：<br />\r\n<a href=\'http://okphp.com\'>http://okphp.com</a><br />\r\n<br />\r\n我们同时还提供Okphp BBS（Okphp论坛系统），她能和Okphp CMS完美整合，希望您喜欢。</td>\r\n          </tr>\r\n        </table>\r\n        \r\n          \r\n      \r\n      <br>\r\n      \r\n      <table width="100%" border="0" cellpadding="2" cellspacing="1" class="table_border">\r\n          <tr> \r\n            <td colspan="2" align="center" class="td1">New Files</td>\r\n          </tr>\r\n          <tr> \r\n            <td valign="top"> \r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=8" target="_blank"><font class="stress">News4 (pic)</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=6">DemoNews1</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=7" target="_blank"><font class="topictitle">News3</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=6">DemoNews1</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=6" target="_blank"><font class="topictitle">News2</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=7">DemoNews2</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=5" target="_blank"><font class="topictitle">News1</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=7">DemoNews2</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=4" target="_blank"><font class="topictitle">Product4</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=4">DemoShop2</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n              <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                <tr> \r\n                  <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=3" target="_blank"><font class="topictitle">Product3</font><font color="#666666"> \r\n                    </font></a> |<a href="index.php?action=list_file&type_id=4">DemoShop2</a> \r\n                    <font color="#666666">(12-08)</font></td>\r\n                </tr>\r\n              </table>\r\n              \r\n            </td>\r\n            <td align="right" valign="top" bordercolor="#CCCCCC"><a href="index.php?action=file_detail&file_id=4" target="_blank"><img src="images/small/1102488935MNbw2" border="0"><br><font class="topictitle">Product4</font></a><br>\r\n              <a href="index.php?action=file_detail&all_comment=1&file_id=4" target="_blank">Comments</font></a><br></td>\r\n          </tr>\r\n        </table>\r\n        <br> \r\n        \r\n        \r\n        <br> </td>\r\n      \r\n    <td align="right" valign="top"> \r\n      \r\n      <table border="0" cellspacing="1" cellpadding="2" class="block_right">\r\n          <tr> \r\n            <td class="td1_2" align="center">最新成员</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_right"> <a href=\'index.php?action=view_user&user_id=6\' target=\'_blank\'>test</a>(04-25)<br> <a href=\'index.php?action=view_user&user_id=1\' target=\'_blank\'>admin</a>(10-29)<br></td>\r\n          </tr>\r\n        </table>\r\n        <br>\r\n      \r\n      <table border="0" cellspacing="1" cellpadding="2" class="block_right">\r\n          <tr> \r\n            <td class="td1_right" align="center">热门文章</td>\r\n          </tr>\r\n          <tr> \r\n            <td class="td2_right"> <a href=\'index.php?action=file_detail&file_id=8\' target=\'_blank\'><font class="stress">News4 (pic)</font></a>(2)<br> <a href=\'index.php?action=file_detail&file_id=3\' target=\'_blank\'><font class="topictitle">Product3</font></a>(1)<br> <a href=\'index.php?action=file_detail&file_id=1\' target=\'_blank\'><font class="topictitle">Product1</font></a>(0)<br> <a href=\'index.php?action=file_detail&file_id=2\' target=\'_blank\'><font class="topictitle">Product2</font></a>(0)<br> <a href=\'index.php?action=file_detail&file_id=4\' target=\'_blank\'><font class="topictitle">Product4</font></a>(0)<br> <a href=\'index.php?action=file_detail&file_id=5\' target=\'_blank\'><font class="topictitle">News1</font></a>(0)<br> <a href=\'index.php?action=file_detail&file_id=6\' target=\'_blank\'><font class="topictitle">News2</font></a>(0)<br> <a href=\'index.php?action=file_detail&file_id=7\' target=\'_blank\'><font class="topictitle">News3</font></a>(0)<br></td>\r\n          </tr>\r\n        </table>\r\n        <br>\r\n      \r\n    </td>\r\n    </tr>\r\n    <tr> \r\n      <td align="center" colspan="2" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="1">\r\n          \r\n          <tr> \r\n            \r\n            <td valign="top" width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1" class="table_border">\r\n                <tr bordercolor="#CCCCCC"> \r\n                  \r\n                <td class="td1_1"><img src="./images/default/folder_open.gif" border="0"> \r\n                  DemoNews2 (2)</td>\r\n                </tr>\r\n                <tr> \r\n                  <td align="center"> <table width="99%" border="0" cellspacing="0" cellpadding="0">\r\n                      <tr> \r\n                        <td bordercolor="#FFFFFF" valign="top"> \r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=6" target="_blank"><font class="{tstyle}"><font class="topictitle">News2</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=5" target="_blank"><font class="{tstyle}"><font class="topictitle">News1</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                        </td>\r\n                        <td valign="top" align="right">  </td>\r\n                      </tr>\r\n                    </table></td>\r\n                </tr>\r\n                <tr bordercolor="#FFFFFF"> \r\n                  <td align="right" bordercolor="#FFFFFF"><a href="index.php?action=list_file&type_id=7">&gt;&gt;more..</a></td>\r\n                </tr>\r\n              </table></td>\r\n            \r\n            <td valign="top" width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1" class="table_border">\r\n                <tr bordercolor="#CCCCCC"> \r\n                  \r\n                <td class="td1_1"><img src="./images/default/folder_open.gif" border="0"> \r\n                  DemoNews1 (2)</td>\r\n                </tr>\r\n                <tr> \r\n                  <td align="center"> <table width="99%" border="0" cellspacing="0" cellpadding="0">\r\n                      <tr> \r\n                        <td bordercolor="#FFFFFF" valign="top"> \r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=8" target="_blank"><font class="{tstyle}"><font class="stress">News4 (pic)</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=7" target="_blank"><font class="{tstyle}"><font class="topictitle">News3</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                        </td>\r\n                        <td valign="top" align="right">  </td>\r\n                      </tr>\r\n                    </table></td>\r\n                </tr>\r\n                <tr bordercolor="#FFFFFF"> \r\n                  <td align="right" bordercolor="#FFFFFF"><a href="index.php?action=list_file&type_id=6">&gt;&gt;more..</a></td>\r\n                </tr>\r\n              </table></td>\r\n            \r\n          </tr>\r\n          \r\n          <tr> \r\n            \r\n            <td valign="top" width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1" class="table_border">\r\n                <tr bordercolor="#CCCCCC"> \r\n                  \r\n                <td class="td1_1"><img src="./images/default/folder_open.gif" border="0"> \r\n                  DemoShop2 (2)</td>\r\n                </tr>\r\n                <tr> \r\n                  <td align="center"> <table width="99%" border="0" cellspacing="0" cellpadding="0">\r\n                      <tr> \r\n                        <td bordercolor="#FFFFFF" valign="top"> \r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=4" target="_blank"><font class="{tstyle}"><font class="topictitle">Product4</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=3" target="_blank"><font class="{tstyle}"><font class="topictitle">Product3</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                        </td>\r\n                        <td valign="top" align="right"> <a href="index.php?action=file_detail&file_id=3" target="_blank"><img src="images/small/1102488914u0w2o" border="0"><br><font class="topictitle">Product3</font></a> </td>\r\n                      </tr>\r\n                    </table></td>\r\n                </tr>\r\n                <tr bordercolor="#FFFFFF"> \r\n                  <td align="right" bordercolor="#FFFFFF"><a href="index.php?action=list_file&type_id=4">&gt;&gt;more..</a></td>\r\n                </tr>\r\n              </table></td>\r\n            \r\n            <td valign="top" width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1" class="table_border">\r\n                <tr bordercolor="#CCCCCC"> \r\n                  \r\n                <td class="td1_1"><img src="./images/default/folder_open.gif" border="0"> \r\n                  DemoShop1 (2)</td>\r\n                </tr>\r\n                <tr> \r\n                  <td align="center"> <table width="99%" border="0" cellspacing="0" cellpadding="0">\r\n                      <tr> \r\n                        <td bordercolor="#FFFFFF" valign="top"> \r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=2" target="_blank"><font class="{tstyle}"><font class="topictitle">Product2</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                          <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                            <tr> \r\n                              <td valign="top">&#149; <a href="index.php?action=file_detail&file_id=1" target="_blank"><font class="{tstyle}"><font class="topictitle">Product1</font></font> \r\n                                </a></td>\r\n                            </tr>\r\n                          </table>\r\n                          \r\n                        </td>\r\n                        <td valign="top" align="right"> <a href="index.php?action=file_detail&file_id=2" target="_blank"><img src="images/small/foqLhCsiDtj9jtj" border="0"><br><font class="topictitle">Product2</font></a> </td>\r\n                      </tr>\r\n                    </table></td>\r\n                </tr>\r\n                <tr bordercolor="#FFFFFF"> \r\n                  <td align="right" bordercolor="#FFFFFF"><a href="index.php?action=list_file&type_id=3">&gt;&gt;more..</a></td>\r\n                </tr>\r\n              </table></td>\r\n            \r\n          </tr>\r\n          \r\n        </table>\r\n        \r\n      </td>\r\n    </tr>\r\n  </table>\r\n  <table width="778" height="100" border="0" cellpadding="1" cellspacing="0" class="endbar">\r\n    <tr> \r\n      <td  align="center" valign="top"><br> <a href="?action=copyright" target="_blank"><img src="./images/default/powered.gif" border="0"></a><br>\r\n        <br>\r\n<a href="?action=copyright" target="_blank"><img src="images/powered.gif" border="0"></a><br>\r\n<font size="1">Copyright &copy; 2003-2004 by OKPHP Group, All rights reserved. </font><br>\r\n </td>\r\n    </tr>\r\n  </table>\r\n\r\n</body>\r\n</html>\r\n\r\n');

# --------------------------------------------------------

#
# 表的结构 `{prefix}comment`
#

DROP TABLE IF EXISTS `{prefix}comment`;
CREATE TABLE `{prefix}comment` (
  `id` int(11) NOT NULL auto_increment,
  `belong_id` int(11) NOT NULL default '0',
  `info` text NOT NULL,
  `poster` varchar(255) NOT NULL default '',
  `time_added` int(11) NOT NULL default '0',
  `author_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}comment`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}count`
#

DROP TABLE IF EXISTS `{prefix}count`;
CREATE TABLE `{prefix}count` (
  `id` int(11) NOT NULL auto_increment,
  `v_year` int(11) NOT NULL default '0',
  `v_month` int(11) NOT NULL default '0',
  `v_day` int(11) NOT NULL default '0',
  `v_week` int(10) NOT NULL default '0',
  `ip_list` text NOT NULL,
  `h00` int(11) NOT NULL default '0',
  `h01` int(11) NOT NULL default '0',
  `h02` int(11) NOT NULL default '0',
  `h03` int(11) NOT NULL default '0',
  `h04` int(11) NOT NULL default '0',
  `h05` int(11) NOT NULL default '0',
  `h06` int(11) NOT NULL default '0',
  `h07` int(11) NOT NULL default '0',
  `h08` int(11) NOT NULL default '0',
  `h09` int(11) NOT NULL default '0',
  `h10` int(11) NOT NULL default '0',
  `h11` int(11) NOT NULL default '0',
  `h12` int(11) NOT NULL default '0',
  `h13` int(11) NOT NULL default '0',
  `h14` int(11) NOT NULL default '0',
  `h15` int(11) NOT NULL default '0',
  `h16` int(11) NOT NULL default '0',
  `h17` int(11) NOT NULL default '0',
  `h18` int(11) NOT NULL default '0',
  `h19` int(11) NOT NULL default '0',
  `h20` int(11) NOT NULL default '0',
  `h21` int(11) NOT NULL default '0',
  `h22` int(11) NOT NULL default '0',
  `h23` int(11) NOT NULL default '0',
  `allday` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}count`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}expand_type`
#

DROP TABLE IF EXISTS `{prefix}expand_type`;
CREATE TABLE `{prefix}expand_type` (
  `name` varchar(30) NOT NULL default '',
  `attribute` varchar(10) NOT NULL default '',
  `flag` varchar(30) NOT NULL default '',
  `search_item` tinyint(4) NOT NULL default '0',
  `hold` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}expand_type`
#

INSERT INTO `{prefix}expand_type` VALUES ('publication', 'att1', 'Author', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('publication', 'att2', 'Publishing', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('publication', 'att3', 'Price', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('publication', 'att4', 'ISBS/ISSN', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('publication', 'att5', 'Issue date', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('download', 'att2', 'Version', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('download', 'att1', 'developer', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('download', 'att3', 'Size', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('download', 'att4', 'Platform', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('download', 'att5', 'Price', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('film', 'att1', 'Stars', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('film', 'att2', 'Director', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('film', 'att3', 'Company', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('film', 'att4', 'Length', 0, 1);

# --------------------------------------------------------

#
# 表的结构 `{prefix}expands`
#

DROP TABLE IF EXISTS `{prefix}expands`;
CREATE TABLE `{prefix}expands` (
  `id` int(11) NOT NULL auto_increment,
  `belong_id` int(11) NOT NULL default '0',
  `type` varchar(40) NOT NULL default '',
  `att1` varchar(120) NOT NULL default '',
  `att2` varchar(120) NOT NULL default '',
  `att3` varchar(120) NOT NULL default '',
  `att4` varchar(120) NOT NULL default '',
  `att5` varchar(120) NOT NULL default '',
  `att6` varchar(120) NOT NULL default '',
  `att7` varchar(120) NOT NULL default '',
  `att8` varchar(120) NOT NULL default '',
  `att9` varchar(120) NOT NULL default '',
  `att10` varchar(120) NOT NULL default '',
  `att11` varchar(120) NOT NULL default '',
  `att12` varchar(120) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `belong_id` (`belong_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}expands`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}files`
#

DROP TABLE IF EXISTS `{prefix}files`;
CREATE TABLE `{prefix}files` (
  `id` int(11) NOT NULL auto_increment,
  `belong_id` int(11) NOT NULL default '0',
  `belong_class` int(11) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `poster` varchar(255) NOT NULL default '',
  `hit_num` int(11) NOT NULL default '0',
  `reply_num` int(11) NOT NULL default '0',
  `time_added` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `score_num` int(11) NOT NULL default '0',
  `is_better` tinyint(4) NOT NULL default '0',
  `preview_id` varchar(255) NOT NULL default '',
  `picture` text NOT NULL,
  `down` tinyint(4) NOT NULL default '0',
  `fastview` varchar(255) NOT NULL default '',
  `now_price` int(11) NOT NULL default '0',
  `sales` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# 导出表中的数据 `{prefix}files`
#

INSERT INTO `{prefix}files` VALUES (1, 3, 0, 'Product1', 'This is a demo', 'admin', 0, 0, 1102488748, 0, 0, 0, 'gMaw2Hd34qLB7Mi', '', 0, 'This is a demo', 2342, 0);
INSERT INTO `{prefix}files` VALUES (2, 3, 0, 'Product2', 'This is a demo', 'admin', 0, 0, 1102488768, 0, 0, 0, 'foqLhCsiDtj9jtj', '', 0, 'This is a demo', 3423, 0);
INSERT INTO `{prefix}files` VALUES (3, 4, 0, 'Product3', 'This is a demo', 'admin', 1, 0, 1102488914, 0, 0, 0, '1102488914u0w2o', '', 0, 'This is a demo', 4354, 0);
INSERT INTO `{prefix}files` VALUES (4, 4, 0, 'Product4', 'This is a demo', 'admin', 0, 0, 1102488935, 0, 0, 0, '1102488935MNbw2', '', 0, 'This is a demo', 5435, 0);
INSERT INTO `{prefix}files` VALUES (5, 7, 0, 'News1', 'This is a demo.', 'admin', 0, 0, 1102489155, 0, 0, 0, '', '', 0, 'This is a demo.', 0, 0);
INSERT INTO `{prefix}files` VALUES (6, 7, 0, 'News2', 'This is a demo.', 'admin', 0, 0, 1102489164, 0, 0, 0, '', '', 0, 'This is a demo.', 0, 0);
INSERT INTO `{prefix}files` VALUES (7, 6, 0, 'News3', 'This is a demo.', 'admin', 0, 0, 1102489178, 0, 0, 0, '', '', 0, 'This is a demo.', 0, 0);
INSERT INTO `{prefix}files` VALUES (8, 6, 0, 'News4 (pic)', '<P>&nbsp;</P>\r\n<P>.<IMG alt="" src="./images/big/1102489284EAij9.gif" border=0></P>', 'admin', 3, 0, 1102489516, 0, 0, 1, '', '1102489284EAij9.gif', 0, 'Okphp CMS&BBS Working principle.', 0, 0);

# --------------------------------------------------------

#
# 表的结构 `{prefix}group`
#

DROP TABLE IF EXISTS `{prefix}group`;
CREATE TABLE `{prefix}group` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `intr` text NOT NULL,
  `is_reg` varchar(10) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

#
# 导出表中的数据 `{prefix}group`
#

INSERT INTO `{prefix}group` VALUES (1, 'Guest', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group` VALUES (2, 'Members', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group` VALUES (13, 'test group', 'adf', 'yes');
INSERT INTO `{prefix}group` VALUES (3, 'Super Moderator', 'don\'t delete this!', 'no');

# --------------------------------------------------------

#
# 表的结构 `{prefix}group_del`
#

DROP TABLE IF EXISTS `{prefix}group_del`;
CREATE TABLE `{prefix}group_del` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `intr` text NOT NULL,
  `is_reg` varchar(10) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# 导出表中的数据 `{prefix}group_del`
#

INSERT INTO `{prefix}group_del` VALUES (1, '游客', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group_del` VALUES (2, '管理员', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group_del` VALUES (7, 'VIP', 'afdfad45', 'no');
INSERT INTO `{prefix}group_del` VALUES (9, 'normal', 'adf', 'yes');

# --------------------------------------------------------

#
# 表的结构 `{prefix}guestbook`
#

DROP TABLE IF EXISTS `{prefix}guestbook`;
CREATE TABLE `{prefix}guestbook` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `poster` varchar(255) NOT NULL default '',
  `time_added` int(11) NOT NULL default '0',
  `reply` text NOT NULL,
  `reply_time` int(11) NOT NULL default '0',
  `reply_author` varchar(50) NOT NULL default '',
  `belong_id` int(11) NOT NULL default '0',
  `author_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `poster` (`poster`)
) TYPE=MyISAM AUTO_INCREMENT=69 ;

#
# 导出表中的数据 `{prefix}guestbook`
#

INSERT INTO `{prefix}guestbook` VALUES (68, 'test', 'test', 'test', 1082897514, 'reply', 1082897526, 'admin', 1, 6);

# --------------------------------------------------------

#
# 表的结构 `{prefix}log`
#

DROP TABLE IF EXISTS `{prefix}log`;
CREATE TABLE `{prefix}log` (
  `id` int(11) NOT NULL auto_increment,
  `time_added` int(11) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `ip` varchar(40) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `result` varchar(255) NOT NULL default '',
  `reason` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# 导出表中的数据 `{prefix}log`
#

INSERT INTO `{prefix}log` VALUES (1, 1082896263, 'admin', '127.0.0.1', 'System Settings', '1', '');

# --------------------------------------------------------

#
# 表的结构 `{prefix}online`
#

DROP TABLE IF EXISTS `{prefix}online`;
CREATE TABLE `{prefix}online` (
  `ip` varchar(30) NOT NULL default '',
  `username` varchar(50) NOT NULL default '',
  `last_view` int(11) NOT NULL default '0',
  `last_input` int(11) NOT NULL default '0',
  `view_crigger` tinyint(4) NOT NULL default '0',
  `input_crigger` tinyint(4) NOT NULL default '0',
  `action` varchar(20) NOT NULL default '',
  `type_id` int(11) NOT NULL default '0',
  `has_pm` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}online`
#

INSERT INTO `{prefix}online` VALUES ('127.0.0.1', '', 1102519272, 1082896765, 0, 0, 'home', 0, 0);

# --------------------------------------------------------

#
# 表的结构 `{prefix}orders`
#

DROP TABLE IF EXISTS `{prefix}orders`;
CREATE TABLE `{prefix}orders` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `city` varchar(60) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `tel` varchar(60) NOT NULL default '',
  `fax` varchar(60) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `okphp_id` int(11) NOT NULL default '0',
  `okphp_name` varchar(255) NOT NULL default '',
  `p_process` varchar(30) NOT NULL default 'pending',
  `p_info` text NOT NULL,
  `addon_info` text NOT NULL,
  `order_time` varchar(255) NOT NULL default '',
  `refer` varchar(255) NOT NULL default '',
  `stats` tinyint(4) NOT NULL default '0',
  `grand_cost` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}orders`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}plug_files`
#

DROP TABLE IF EXISTS `{prefix}plug_files`;
CREATE TABLE `{prefix}plug_files` (
  `name` varchar(60) NOT NULL default '',
  `flag` varchar(40) NOT NULL default ''
) TYPE=MyISAM;

#
# 导出表中的数据 `{prefix}plug_files`
#

INSERT INTO `{prefix}plug_files` VALUES ('category.php', 'Category');
INSERT INTO `{prefix}plug_files` VALUES ('lastest_threads.php', 'Lastest Threads');
INSERT INTO `{prefix}plug_files` VALUES ('block_poll.php', 'Poll');
INSERT INTO `{prefix}plug_files` VALUES ('lastest_members.php', 'Lastest Members');
INSERT INTO `{prefix}plug_files` VALUES ('top10_hits.php', 'Top10 Hits');
INSERT INTO `{prefix}plug_files` VALUES ('whois_online.php', 'Whois Online');

# --------------------------------------------------------

#
# 表的结构 `{prefix}pm`
#

DROP TABLE IF EXISTS `{prefix}pm`;
CREATE TABLE `{prefix}pm` (
  `id` int(11) NOT NULL auto_increment,
  `id_from` int(11) NOT NULL default '0',
  `id_to` int(11) NOT NULL default '0',
  `message` mediumtext NOT NULL,
  `send_time` int(11) NOT NULL default '0',
  `hasread` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `{prefix}pm`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}poll`
#

DROP TABLE IF EXISTS `{prefix}poll`;
CREATE TABLE `{prefix}poll` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `record` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '1',
  `ip_list` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# 导出表中的数据 `{prefix}poll`
#

INSERT INTO `{prefix}poll` VALUES (1, 'test poll', 1, 2, ',127.0.0.1');
INSERT INTO `{prefix}poll` VALUES (2, 's1', 243, 1, '');
INSERT INTO `{prefix}poll` VALUES (3, 's2', 333, 1, '');
INSERT INTO `{prefix}poll` VALUES (4, 's3', 23, 1, '');
INSERT INTO `{prefix}poll` VALUES (5, 's4', 55, 1, '');
INSERT INTO `{prefix}poll` VALUES (6, 's5', 344, 1, '');
INSERT INTO `{prefix}poll` VALUES (7, '', 0, 1, '');
INSERT INTO `{prefix}poll` VALUES (8, '', 0, 1, '');
INSERT INTO `{prefix}poll` VALUES (9, '', 0, 1, '');
INSERT INTO `{prefix}poll` VALUES (10, '', 6, 1, '');
INSERT INTO `{prefix}poll` VALUES (11, '', 3, 1, '');
INSERT INTO `{prefix}poll` VALUES (12, '', 0, 1, '');
INSERT INTO `{prefix}poll` VALUES (13, '', 0, 1, '');

# --------------------------------------------------------

#
# 表的结构 `{prefix}refer`
#

DROP TABLE IF EXISTS `{prefix}refer`;
CREATE TABLE `{prefix}refer` (
  `id` int(11) NOT NULL auto_increment,
  `refer` varchar(255) NOT NULL default '',
  `allnum` int(11) NOT NULL default '0',
  `first_url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# 导出表中的数据 `{prefix}refer`
#

INSERT INTO `{prefix}refer` VALUES (1, 'norefer', 1, 'http://about:blank');

# --------------------------------------------------------

#
# 表的结构 `{prefix}special`
#

DROP TABLE IF EXISTS `{prefix}special`;
CREATE TABLE `{prefix}special` (
  `id` int(11) NOT NULL auto_increment,
  `belong_id` int(11) NOT NULL default '0',
  `belong_class` int(11) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `poster` varchar(255) NOT NULL default '',
  `hit_num` int(11) NOT NULL default '0',
  `reply_num` int(11) NOT NULL default '0',
  `time_added` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `score_num` int(11) NOT NULL default '0',
  `is_better` tinyint(4) NOT NULL default '0',
  `preview_id` varchar(255) NOT NULL default '',
  `picture` text NOT NULL,
  `down` tinyint(4) NOT NULL default '0',
  `fastview` varchar(255) NOT NULL default '',
  `now_price` int(11) NOT NULL default '0',
  `sales` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# 导出表中的数据 `{prefix}special`
#


# --------------------------------------------------------

#
# 表的结构 `{prefix}themes`
#

DROP TABLE IF EXISTS `{prefix}themes`;
CREATE TABLE `{prefix}themes` (
  `id` int(11) NOT NULL auto_increment,
  `flag` varchar(100) NOT NULL default '',
  `theme` varchar(255) NOT NULL default '',
  `img` varchar(255) NOT NULL default '',
  `css` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

#
# 导出表中的数据 `{prefix}themes`
#

INSERT INTO `{prefix}themes` VALUES (15, 'DarkBlue', 'themes/default', 'themes/default/images/darkblue', 'themes/default/css/darkblue');
INSERT INTO `{prefix}themes` VALUES (14, 'Blue', 'themes/default', 'themes/default/images/blue', 'themes/default/css/blue');
INSERT INTO `{prefix}themes` VALUES (13, 'DarkRed', 'themes/default', 'themes/default/images/darkred', 'themes/default/css/darkred');

# --------------------------------------------------------

#
# 表的结构 `{prefix}type`
#

DROP TABLE IF EXISTS `{prefix}type`;
CREATE TABLE `{prefix}type` (
  `id` int(11) NOT NULL auto_increment,
  `order_num` int(11) NOT NULL default '0',
  `belong_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `head_info` text NOT NULL,
  `foot_info` text NOT NULL,
  `list_num` int(11) NOT NULL default '0',
  `intr` varchar(255) NOT NULL default '',
  `time_type` varchar(255) NOT NULL default '',
  `protect_view` varchar(255) NOT NULL default '',
  `protect_comment` varchar(255) NOT NULL default '',
  `theme_id` int(11) NOT NULL default '0',
  `list_order` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  `weight` int(11) NOT NULL default '0',
  `type_class` int(11) NOT NULL default '0',
  `top_files` int(11) NOT NULL default '0',
  `moderator` varchar(255) NOT NULL default '',
  `all_files_num` int(11) NOT NULL default '0',
  `cache_tpl` text NOT NULL,
  `expand_id` varchar(25) NOT NULL default '',
  `with_order` tinyint(4) NOT NULL default '0',
  `tpl_file` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `belong_id` (`belong_id`),
  KEY `order_num` (`order_num`),
  KEY `type_class` (`type_class`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# 导出表中的数据 `{prefix}type`
#

INSERT INTO `{prefix}type` VALUES (1, 1, 0, 'GuestBook', '', '', 0, '', '', '1&2&3&13', '1&2&3&13', 1, 0, '', 0, 5, 0, '', 0, '', '', 0, '');
INSERT INTO `{prefix}type` VALUES (2, 2, 0, 'Shop', '', '', 5, '', '', '', '', 1, 0, '', 0, 1, 15, '', 0, '', '', 0, '');
INSERT INTO `{prefix}type` VALUES (3, 3, 2, 'DemoShop1', '', '', 0, '', '', '1&2&3&13', '1&2&3&13', 2, 0, '', 0, 2, 0, '', 2, '', '0', 1, '');
INSERT INTO `{prefix}type` VALUES (4, 4, 2, 'DemoShop2', '', '', 0, '', '', '1&2&3&13', '1&2&3&13', 2, 0, '', 0, 2, 0, '', 2, '', '0', 1, '');
INSERT INTO `{prefix}type` VALUES (5, 5, 0, 'News', '', '', 0, '', '', '', '', 1, 0, '', 0, 1, 15, '', 0, '', '', 0, '');
INSERT INTO `{prefix}type` VALUES (6, 6, 5, 'DemoNews1', '', '', 0, '', '', '1&2&3&13', '1&2&3&13', 1, 0, '', 0, 2, 0, '', 2, '', '0', 0, '');
INSERT INTO `{prefix}type` VALUES (7, 7, 5, 'DemoNews2', '', '', 0, '', '', '1&2&3&13', '1&2&3&13', 1, 0, '', 0, 2, 0, '', 2, '', '0', 0, '');

# --------------------------------------------------------

#
# 表的结构 `{prefix}users`
#

DROP TABLE IF EXISTS `{prefix}users`;
CREATE TABLE `{prefix}users` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` varchar(255) NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `intr` text NOT NULL,
  `reg_time` int(11) NOT NULL default '0',
  `post_num` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `headpic` varchar(255) NOT NULL default '',
  `sig` tinytext NOT NULL,
  `hidden_info` text NOT NULL,
  `lastposttime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# 导出表中的数据 `{prefix}users`
#

INSERT INTO `{prefix}users` VALUES (1, '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'webmaster@yourdomain.com', '', 1099015085, 0, 5000, '', '', '', 1052460461);
INSERT INTO `{prefix}users` VALUES (6, '13', 'test', '098f6bcd4621d373cade4e832627b4f6', 'test@test.com', '', 1082886524, 0, 0, '', '', '', 0);
