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

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

#
# 表的结构 `{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=2 ;

#
# 导出表中的数据 `{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 &copy; 2004 Okphp Group </font>', '1&20&1&&30&&bbs_&12&12&downloads&gb2312&./lang/gb&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&1&0&0', '', 0, 1102516560, 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, '投票', '', 4, 55, 1, 0, 0, 'block_poll.php', 'table1', 'td1_3', 'td2_1');
INSERT INTO `{prefix}blocks` VALUES (13, 0, '友情链接', '<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, '最新成员', '', 1, 37, 1, 1, 0, 'lastest_members.php', '0', 'td1_2', '0');
INSERT INTO `{prefix}blocks` VALUES (53, 0, '欢迎来到OKPHP的世界!', '感谢您使用Okphp CMS（Okphp 网站内容管理系统）！\r\n\r\n您目前看到的网站内容，是我们作为演示加上去的，您可以通过<a href=\'admin/index.php\'>后台管理</a>来修改或删除它们。\r\n\r\nOkphp CMS的各项管理功能很容易上手，您可以慢慢的了解。\r\n如果使用中遇到问题，或者发现程序有错误，请与我们取得联系：\r\n<a href=\'http://okphp.com\'>http://okphp.com</a>\r\n\r\n我们同时还提供Okphp BBS（Okphp论坛系统），她能和Okphp CMS完美整合。', 3, 48, 1, 0, 0, '0', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (54, 0, '谁在线上', '', 4, 53, 1, 1, 0, 'whois_online.php', '0', '0', '0');
INSERT INTO `{prefix}blocks` VALUES (55, 0, '导航', '', 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`
#

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

#
# 表的结构 `{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=7 ;

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

INSERT INTO `{prefix}comment` VALUES (1, 228, 'gdadf', '127.0.0.1', 1099556223, 0);
INSERT INTO `{prefix}comment` VALUES (2, 229, 'teadsfdasf', '127.0.0.1', 1102420856, 0);
INSERT INTO `{prefix}comment` VALUES (3, 229, 'gfdsgfdg', '127.0.0.1', 1102420874, 0);
INSERT INTO `{prefix}comment` VALUES (4, 229, 'adfdsf', '127.0.0.1', 1102421585, 0);
INSERT INTO `{prefix}comment` VALUES (5, 229, 'adfdsf', '127.0.0.1', 1102421659, 0);
INSERT INTO `{prefix}comment` VALUES (6, 229, 'tadsfdsfdsf', '127.0.0.1', 1102421784, 0);

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

#
# 表的结构 `{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=11 ;

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

INSERT INTO `{prefix}count` VALUES (1, 2004, 10, 29, 5, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (2, 2004, 11, 2, 2, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (3, 2004, 11, 4, 4, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (4, 2004, 11, 5, 5, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (5, 2004, 11, 8, 1, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (6, 2004, 11, 26, 5, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (7, 2004, 12, 3, 5, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (8, 2004, 12, 6, 1, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (9, 2004, 12, 7, 2, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `{prefix}count` VALUES (10, 2004, 12, 8, 3, '127.0.0.1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1);

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

#
# 表的结构 `{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 ('书籍·报刊', 'att1', '作者', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('书籍·报刊', 'att2', '出版社', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('书籍·报刊', 'att3', '定价', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('书籍·报刊', 'att4', '国际发行号', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('书籍·报刊', 'att5', '出版日期', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att2', '最新版本', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att1', '开发商', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att3', '大小', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att4', '运行平台', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att5', '价格', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('软件下载', 'att6', '演示地址', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('电影', 'att1', '主演', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('电影', 'att2', '导演', 1, 1);
INSERT INTO `{prefix}expand_type` VALUES ('电影', 'att3', '制片公司', 0, 1);
INSERT INTO `{prefix}expand_type` VALUES ('电影', 'att4', '片长', 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', 2, 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=14 ;

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

INSERT INTO `{prefix}group` VALUES (1, '游客', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group` VALUES (2, '普通会员', 'don\'t delete this!', 'no');
INSERT INTO `{prefix}group` VALUES (13, 'test group', 'adf', 'yes');
INSERT INTO `{prefix}group` VALUES (3, '超级管理员', 'don\'t delete this!', 'no');

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

#
# 表的结构 `{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=2 ;

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

INSERT INTO `{prefix}log` VALUES (1, 1102517421, 'admin', '127.0.0.1', 'Moderator login', '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', '', 1102516884, 1102425068, 0, 1, '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', '导航');
INSERT INTO `{prefix}plug_files` VALUES ('lastest_threads.php', 'OkphpBBS最新帖子');
INSERT INTO `{prefix}plug_files` VALUES ('block_poll.php', '投票');
INSERT INTO `{prefix}plug_files` VALUES ('lastest_members.php', '最新会员');
INSERT INTO `{prefix}plug_files` VALUES ('top10_hits.php', '热门文章');
INSERT INTO `{prefix}plug_files` VALUES ('whois_online.php', '在线列表');

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

#
# 表的结构 `{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=4 ;

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

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

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

#
# 表的结构 `{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=8 ;

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

INSERT INTO `{prefix}special` VALUES (5, 228, 0, 'news4-1', 'adfadsfadsfadf', 'admin', 0, 0, 1102323836, 0, 0, 0, '', '', 0, '', 0, 0);
INSERT INTO `{prefix}special` VALUES (6, 229, 0, 'dddddddddddddd', 'adfadfdaf', 'admin', 0, 0, 1102420311, 0, 0, 0, '', '', 0, '', 0, 0);
INSERT INTO `{prefix}special` VALUES (7, 229, 0, 'teatf22', 'dfadsfadf', 'admin', 0, 0, 1102420353, 0, 0, 0, '', '', 0, '', 0, 0);

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

#
# 表的结构 `{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);
