-- phpMyAdmin SQL Dump
-- version 3.4.6
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2014 年 01 月 08 日 06:36
-- 服务器版本: 5.1.28
-- PHP 版本: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 数据库: `uwa`
--

-- --------------------------------------------------------

--
-- 表的结构 `prefix_ad`
--

DROP TABLE IF EXISTS `prefix_ad`;
CREATE TABLE IF NOT EXISTS `prefix_ad` (
  `ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ad ID',
  `a_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ad Name',
  `ad_space_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Space ID',
  `a_file` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ad File',
  `a_content` text NOT NULL COMMENT 'Ad Content',
  `a_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ad Link',
  `a_time_limit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Time Limit Switch(0:off, 1:on)',
  `a_start_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Start Time',
  `a_end_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad End Time',
  `a_display_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Display Order',
  PRIMARY KEY (`ad_id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Ad' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_ad`
--

INSERT INTO `prefix_ad` (`ad_id`, `a_name`, `ad_space_id`, `a_file`, `a_content`, `a_link`, `a_time_limit`, `a_start_time`, `a_end_time`, `a_display_order`) VALUES
(1, '240x200图片', 1, '{-site_url-}u/ad/ad240x200.gif', '', '#', 0, {-time-}, {-time-}, 50);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_admin`
--

DROP TABLE IF EXISTS `prefix_admin`;
CREATE TABLE IF NOT EXISTS `prefix_admin` (
  `admin_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Administrator ID',
  `a_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Administrator Login Time',
  `a_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Administrator Login IP',
  `a_ac_id` text NOT NULL COMMENT 'Archive Channel ID Witch Can Be Managed(divide with ‘,’ _all:All Channel)',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID',
  `admin_role_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Administrator Role ID',
  PRIMARY KEY (`admin_id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Administrator' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_admin`
--

INSERT INTO `prefix_admin` (`admin_id`, `a_login_time`, `a_login_ip`, `a_ac_id`, `member_id`, `admin_role_id`) VALUES
(1, {-time-}, '{-ip-}', '_all', 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_admin_log`
--

DROP TABLE IF EXISTS `prefix_admin_log`;
CREATE TABLE IF NOT EXISTS `prefix_admin_log` (
  `admin_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Administrator Log ID',
  `m_userid` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Userid',
  `al_operation` varchar(255) NOT NULL DEFAULT '' COMMENT 'Administrator Log Operation',
  `al_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Administrator Log Operation Status(0:failed, 1:succeed)',
  `al_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Administrator Log Time',
  `al_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Administrator Log IP',
  PRIMARY KEY (`admin_log_id`),
  KEY `admin_log_id` (`admin_log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Administrator Log' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_admin_permission`
--

DROP TABLE IF EXISTS `prefix_admin_permission`;
CREATE TABLE IF NOT EXISTS `prefix_admin_permission` (
  `admin_permission_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Administrator Permission ID',
  `ap_group` varchar(96) NOT NULL DEFAULT '' COMMENT 'Administrator Permission Group',
  `ap_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Administrator Permission Name(operation)',
  `ap_content` text NOT NULL COMMENT 'Administrator Permission Content(ctrlr:actn,ctrlr:actn1)',
  PRIMARY KEY (`admin_permission_id`),
  KEY `admin_permission_id` (`admin_permission_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Administrator Permission' AUTO_INCREMENT=32 ;

--
-- 转存表中的数据 `prefix_admin_permission`
--

INSERT INTO `prefix_admin_permission` (`admin_permission_id`, `ap_group`, `ap_name`, `ap_content`) VALUES
(1, '广告', '广告位管理', 'Ad:add_ad,Ad:add_ad_do,Ad:delete_ad_do,Ad:edit_ad,Ad:edit_ad_do,Ad:list_ad,Ad:update_ad_do'),
(2, '广告', '广告内容管理', 'AdSpace:add_space,AdSpace:add_space_do,AdSpace:delete_space_do,AdSpace:edit_space,AdSpace:edit_space_do,AdSpace:list_space,AdSpace:toggle_space_status_do,AdSpace:update_js_do'),
(3, '管理员', '管理员管理', 'Admin:add_admin,Admin:add_admin_do,Admin:assign_admin,Admin:assign_admin_do,Admin:delete_admin_do,Admin:edit_admin,Admin:edit_admin_do,Admin:list_admin'),
(4, '管理员', '管理员权限管理', 'AdminPermission:add_permission,AdminPermission:add_permission_do,AdminPermission:delete_permission_do,AdminPermission:edit_permission,AdminPermission:edit_permission_do,AdminPermission:get_actnList,AdminPermission:list_permission'),
(5, '管理员', '管理员角色管理', 'AdminRole:add_role,AdminRole:add_role_do,AdminRole:delete_role_do,AdminRole:edit_role,AdminRole:edit_role_do,AdminRole:list_role'),
(6, '管理员', '管理员日志管理', 'AdminLog:delete_old_log,AdminLog:download_log,AdminLog:list_log'),
(7, '档案', '档案频道管理', 'ArchiveChannel:add_channel,ArchiveChannel:add_channel_do,ArchiveChannel:add_batch_channel_do,ArchiveChannel:delete_channel_do,ArchiveChannel:edit_channel,ArchiveChannel:edit_channel_do,ArchiveChannel:list_channel,ArchiveChannel:update_channel_do,ArchiveChannel:update_html_index_do,ArchiveChannel:update_html_list_do'),
(8, '档案', '档案管理', 'Archive:add_archive,Archive:add_archive_do,Archive:add_flag_do,Archive:change_channel_do,Archive:delete_archive_do,Archive:delete_flag_do,Archive:edit_archive,Archive:edit_archive_do,Archive:list_archive,Archive:pass_archive_do,Archive:refund_archive_do,Archive:update_html_do'),
(9, '档案', '档案属性管理', 'ArchiveFlag:add_flag_do,ArchiveFlag:delete_flag_do,ArchiveFlag:list_flag,ArchiveFlag:update_flag_do'),
(10, '档案', '档案模型管理', 'ArchiveModel:add_model,ArchiveModel:add_model_do,ArchiveModel:add_model_field,ArchiveModel:add_model_field_do,ArchiveModel:delete_model_do,ArchiveModel:delete_model_field_do,ArchiveModel:edit_model,ArchiveModel:edit_model_do,ArchiveModel:edit_model_field,ArchiveModel:edit_model_field_do,ArchiveModel:export_model,ArchiveModel:import_model,ArchiveModel:import_model_do,ArchiveModel:list_model,ArchiveModel:toggle_model_status_do'),
(11, '档案', '档案评论管理', 'ArchiveReview:delete_review_do,ArchiveReview:delete_same_ip_do,ArchiveReview:edit_review,ArchiveReview:edit_review_do,ArchiveReview:list_review,ArchiveReview:pass_review_do,ArchiveReview:toggle_review_status_do'),
(12, '更新', '更新内容管理', 'Build:clear_cache,Build:clear_cache_do,Build:update_archive,Build:update_archive_do,Build:update_channel,Build:update_channel_do,Build:update_index_do'),
(13, '文件浏览', '文件浏览', 'FileExplore:delete_dir_do,FileExplore:delete_file_do,FileExplore:download_file_do,FileExplore:list_file,FileExplore:make_dir_do,FileExplore:upload_file_do'),
(14, '链接', '链接分类管理', 'FlinkCategory:add_category_do,FlinkCategory:list_category,FlinkCategory:update_category_do'),
(15, '链接', '链接管理', 'Flink:add_flink,Flink:add_flink_do,Flink:delete_flink_do,Flink:edit_flink,Flink:edit_flink_do,Flink:list_flink,Flink:toggle_flink_status_do,Flink:update_flink_do'),
(16, '留言', '留言管理', 'Guestbook:delete_guestbook_do,Guestbook:delete_same_ip_do,Guestbook:edit_guestbook,Guestbook:edit_guestbook_do,Guestbook:list_guestbook,Guestbook:pass_guestbook_do,Guestbook:toggle_guestbook_status_do'),
(17, '会员', '会员积分类型管理', 'MemberCreditType:add_credit_type_do,MemberCreditType:delete_credit_type_do,MemberCreditType:list_credit_type,MemberCreditType:update_credit_type_do'),
(18, '会员', '会员管理', 'Member:add_member,Member:add_member_do,Member:pass_member_do,Member:forbidden_member_do,Member:delete_member_do,Member:edit_member,Member:edit_member_do,Member:list_member'),
(19, '会员', '编辑个人资料', 'Member:edit_my_info,Member:edit_my_info_do'),
(20, '会员', '会员收藏管理', 'MemberFavorite:delete_favorite_do,MemberFavorite:list_favorite'),
(21, '会员', '会员等级管理', 'MemberLevel:add_level_do,MemberLevel:delete_level_do,MemberLevel:list_level,MemberLevel:update_level_do'),
(22, '会员', '会员模型管理', 'MemberModel:add_model,MemberModel:add_model_do,MemberModel:add_model_field,MemberModel:add_model_field_do,MemberModel:delete_model_do,MemberModel:delete_model_field_do,MemberModel:edit_model,MemberModel:edit_model_do,MemberModel:edit_model_field,MemberModel:edit_model_field_do,MemberModel:export_model,MemberModel:import_model,MemberModel:import_model_do,MemberModel:list_model,MemberModel:toggle_model_status_do'),
(23, '会员', '会员通知管理', 'MemberNotify:add_notify_do,MemberNotify:delete_notify_do,MemberNotify:list_notify'),
(24, '会员', '会员订单管理', 'MemberOrder:delete_order_do,MemberOrder:list_order,MemberOrder:pay_order_do'),
(25, '菜单', '菜单管理', 'Menu:add_menu,Menu:add_menu_do,Menu:delete_menu_do,Menu:edit_menu,Menu:edit_menu_do,Menu:get_actnList,Menu:get_menuList,Menu:list_menu,Menu:update_menu_do'),
(26, '菜单', '菜单展位管理', 'MenuSpace:add_space,MenuSpace:add_space_do,MenuSpace:delete_space_do,MenuSpace:edit_space,MenuSpace:edit_space_do,MenuSpace:list_space,MenuSpace:update_space_do'),
(27, '选项', '网站选项管理', 'Option:edit_option,Option:edit_option_do,Option:add_custom_option_do'),
(28, '报告', '报告管理', 'Report:deal_report_do,Report:delete_report_do,Report:list_report,Report:toggle_report_status_do'),
(29, '单页', '单页管理', 'SinglePage:add_single_page,SinglePage:add_single_page_do,SinglePage:delete_single_page_do,SinglePage:edit_single_page,SinglePage:edit_single_page_do,SinglePage:list_single_page,SinglePage:update_html_do,SinglePage:update_single_page_do,SinglePage:update_url_do'),
(30, '模板', '标签向导', 'Template:tag_wizard'),
(31, '上传', '上传管理', 'Upload:delete_upload_do,Upload:edit_upload,Upload:edit_upload_do,Upload:list_upload,Upload:upload_file');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_admin_role`
--

DROP TABLE IF EXISTS `prefix_admin_role`;
CREATE TABLE IF NOT EXISTS `prefix_admin_role` (
  `admin_role_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Administrator Role ID',
  `ar_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Administrator Role Name',
  `ar_rank` smallint(5) NOT NULL DEFAULT '0' COMMENT 'Administrator Role Rank(-1:Super Administrator)',
  `ar_permission` text NOT NULL COMMENT 'Administrator Role Permission(_all:all)',
  `ar_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Administrator Role Type(0:system, 1:custom)',
  PRIMARY KEY (`admin_role_id`),
  KEY `admin_role_id` (`admin_role_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Administrator Role' AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `prefix_admin_role`
--

INSERT INTO `prefix_admin_role` (`admin_role_id`, `ar_name`, `ar_rank`, `ar_permission`, `ar_type`) VALUES
(1, '超级管理员', -1, '_all', 0),
(2, '网站管理员', 10, '_all', 1),
(3, '网站编辑', 5, 'Archive:add_archive,Archive:add_archive_do,Archive:add_flag_do,Archive:change_channel_do,Archive:delete_archive_do,Archive:delete_flag_do,Archive:edit_archive,Archive:edit_archive_do,Archive:list_archive,Archive:pass_archive_do,Archive:refund_archive_do,Archive:update_html_do,ArchiveReview:delete_review_do,ArchiveReview:delete_same_ip_do,ArchiveReview:edit_review,ArchiveReview:edit_review_do,ArchiveReview:list_review,ArchiveReview:pass_review_do,ArchiveReview:toggle_review_status_do,Member:edit_my_info,Member:edit_my_info_do', 1);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_ad_space`
--

DROP TABLE IF EXISTS `prefix_ad_space`;
CREATE TABLE IF NOT EXISTS `prefix_ad_space` (
  `ad_space_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ad Space ID',
  `as_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ad Space Name',
  `as_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Ad Space Type(1:code, 2:text, 3:img, 4:flash, 5:slide)',
  `as_width` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Space Width',
  `as_height` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Space Height',
  `as_default` text NOT NULL COMMENT 'Ad Space Default Content',
  `as_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Ad Space Status(0:off, 1:on)',
  PRIMARY KEY (`ad_space_id`),
  KEY `ad_space_id` (`ad_space_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Ad Space' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_ad_space`
--

INSERT INTO `prefix_ad_space` (`ad_space_id`, `as_name`, `as_type`, `as_width`, `as_height`, `as_default`, `as_status`) VALUES
(1, '240x200 图片', 3, 240, 200, '240x200 图片广告', 1);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive`
--

DROP TABLE IF EXISTS `prefix_archive`;
CREATE TABLE IF NOT EXISTS `prefix_archive` (
  `archive_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Archive ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID(0:guest)',
  `m_username` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Username',
  `a_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Title',
  `a_short_title` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Short Title',
  `a_thumb` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Thumb',
  `a_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Keywords',
  `a_description` text NOT NULL COMMENT 'Archive Description',
  `a_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Add Time',
  `a_edit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Edit Time',
  `a_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Archive Add IP',
  `a_edit_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Archive Edit IP',
  `a_cost_points` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Cost Points',
  `a_view_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive View Count',
  `a_review_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Count',
  `a_support_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Support Count',
  `a_oppose_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Oppose Count',
  `a_rank` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Rank',
  `a_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Status(0:pending, 1:audited, 2:send back)',
  `a_review_switch` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Switch(0:off, 1:on)',
  `a_tpl` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Template',
  `a_is_html` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Build html File Switch(0:off, 1:on)',
  `a_html_path` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'html path(0:channel default, 1:custom)',
  `a_html_naming` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive html File Naming',
  `af_alias` set('h','a','c','s','p') NOT NULL DEFAULT '' COMMENT 'Archive Flag Alias',
  `archive_channel_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Channel ID',
  `a_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive URL',
  PRIMARY KEY (`archive_id`),
  KEY `archive_id` (`archive_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Archive' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_archive`
--

INSERT INTO `prefix_archive` (`archive_id`, `member_id`, `m_username`, `a_title`, `a_short_title`, `a_thumb`, `a_keywords`, `a_description`, `a_add_time`, `a_edit_time`, `a_add_ip`, `a_edit_ip`, `a_cost_points`, `a_view_count`, `a_review_count`, `a_support_count`, `a_oppose_count`, `a_rank`, `a_status`, `a_review_switch`, `a_tpl`, `a_is_html`, `a_html_path`, `a_html_naming`, `af_alias`, `archive_channel_id`, `a_url`) VALUES
(1, 1, '创始人', 'UWA(Universal Website AsThis)', '', '{-site_url-}u/article/thumb_01.jpg', '', ' + 软件介绍: UWA是基于PHP和MySQL开发的通用建站程序，程序简洁、灵活而具备强大的扩展性。 UWA功能特点: 1、自定义档案模型，便于内容扩展及二次开发 2、高效的动静态页面部署，运行效率极高 3、网站内容周期性自动更新，维护成本低 4、会员中心及可定制的会员模型，让您的网站火起来 5、多', {-time-}, {-time-}, '{-ip-}', '{-ip-}', 0, 39, 0, 10, 0, 50, 1, 1, '', 1, 0, '', 'h,a,p', 1, '{-site_url-}index.php?c=archive&a=show_archive&archive_id=1');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive_addon_article`
--

DROP TABLE IF EXISTS `prefix_archive_addon_article`;
CREATE TABLE IF NOT EXISTS `prefix_archive_addon_article` (
  `archive_id` int(10) unsigned NOT NULL COMMENT 'Archive ID',
  `a_a_source` varchar(96) NOT NULL DEFAULT '' COMMENT 'Article Source',
  `a_a_author` varchar(96) NOT NULL DEFAULT '' COMMENT 'Article Author',
  `a_a_content` mediumtext NOT NULL COMMENT 'Article Content',
  PRIMARY KEY (`archive_id`),
  KEY `archive_id` (`archive_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Article';

--
-- 转存表中的数据 `prefix_archive_addon_article`
--

INSERT INTO `prefix_archive_addon_article` (`archive_id`, `a_a_source`, `a_a_author`, `a_a_content`) VALUES
(1, '', '', '<p>\r\n	+ 软件介绍 ------------------------------------------------<br>&nbsp;&nbsp;&nbsp; UWA是基于PHP和MySQL开发的通用建站程序，程序简洁、灵<br>活而具备强大的扩展性。<br>&nbsp;&nbsp;&nbsp; UWA功能特点:<br>&nbsp;&nbsp;&nbsp; 1、自定义档案模型，便于内容扩展及二次开发<br>&nbsp;&nbsp;&nbsp; 2、高效的动静态页面部署，运行效率极高<br>&nbsp;&nbsp;&nbsp; 3、网站内容周期性自动更新，维护成本低<br>&nbsp;&nbsp;&nbsp; 4、会员中心及可定制的会员模型，让您的网站火起来<br>&nbsp;&nbsp;&nbsp; 5、多语言支持，方便开拓国际市场<br>&nbsp;&nbsp;&nbsp; 6、专业简洁的界面设计，良好的用户体验<br>&nbsp;&nbsp;&nbsp; 7、简单易用的模板引擎，界面设计方便快捷</p>\r\n');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive_channel`
--

DROP TABLE IF EXISTS `prefix_archive_channel`;
CREATE TABLE IF NOT EXISTS `prefix_archive_channel` (
  `archive_channel_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Archive Channel ID',
  `ac_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Channel Name',
  `ac_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Channel Keywords',
  `ac_description` text NOT NULL COMMENT 'Archive Channel Description',
  `ac_content` text NOT NULL COMMENT 'Archive Channel Content(Can Be Used As Single Page)',
  `ac_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Archive Channel Type(1:index, 2:list)',
  `ac_parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Channel Parent ID',
  `ac_display_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Channel Display Order',
  `ac_tpl_index` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Channel Index Template',
  `ac_tpl_list` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Channel List Template',
  `ac_tpl_archive` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Channel Archive Template',
  `ac_page_size` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT 'Archive Channel Page Size',
  `ac_view_ml_rank` int(11) NOT NULL DEFAULT '0' COMMENT 'Archive Channel View Member Level Rank(-1:off, 0:open, >0:normal)',
  `ac_add_ml_rank` int(11) NOT NULL DEFAULT '0' COMMENT 'Add Archive Member Level Rank(-1:off, 0:open, >0:normal)',
  `ac_pass_switch` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Pass Switch(0:off,auto pass, 1:on,need check)',
  `ac_review_switch` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Review Switch(0:off, 1:on)',
  `ac_is_html` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Html File Build Switch(0:off, 1:on)',
  `ac_html_dir` varchar(255) NOT NULL DEFAULT '' COMMENT 'html File Dir',
  `ac_html_index` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Channel Index File Name',
  `ac_html_naming_list` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive List html File Naming',
  `ac_html_naming_archive` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive html File Naming',
  `archive_model_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Model ID',
  `ac_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Channel URL',
  PRIMARY KEY (`archive_channel_id`),
  KEY `archive_channel_id` (`archive_channel_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Archive Channel' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_archive_channel`
--

INSERT INTO `prefix_archive_channel` (`archive_channel_id`, `ac_name`, `ac_keywords`, `ac_description`, `ac_content`, `ac_type`, `ac_parent_id`, `ac_display_order`, `ac_tpl_index`, `ac_tpl_list`, `ac_tpl_archive`, `ac_page_size`, `ac_view_ml_rank`, `ac_add_ml_rank`, `ac_pass_switch`, `ac_review_switch`, `ac_is_html`, `ac_html_dir`, `ac_html_index`, `ac_html_naming_list`, `ac_html_naming_archive`, `archive_model_id`, `ac_url`) VALUES
(1, '文章频道一', '', '', '', 2, 0, 10, 'index_channel_article', 'list_archive_article', 'show_archive_article', 20, 0, 0, 0, 1, 1, '{uwa_path}/01', 'index', 'list_{ac_id}_{page}', '{Y}{M}/{D}/{a_id}', 1, '{-site_url-}index.php?c=archive&a=show_channel&archive_channel_id=1');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive_flag`
--

DROP TABLE IF EXISTS `prefix_archive_flag`;
CREATE TABLE IF NOT EXISTS `prefix_archive_flag` (
  `af_alias` varchar(10) NOT NULL COMMENT 'Archive Flag Alias(English)',
  `af_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Flag Name',
  `af_display_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Flag Display Order',
  PRIMARY KEY (`af_alias`),
  KEY `af_alias` (`af_alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Archive Flag';

--
-- 转存表中的数据 `prefix_archive_flag`
--

INSERT INTO `prefix_archive_flag` (`af_alias`, `af_name`, `af_display_order`) VALUES
('h', '头条', 1),
('a', '特荐', 2),
('c', '推荐', 3),
('s', '幻灯', 4),
('p', '图片', 5);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive_model`
--

DROP TABLE IF EXISTS `prefix_archive_model`;
CREATE TABLE IF NOT EXISTS `prefix_archive_model` (
  `archive_model_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Archive Model ID',
  `am_alias` varchar(96) NOT NULL DEFAULT '' COMMENT 'Archive Model Alias(English)',
  `am_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Name',
  `am_addon_table` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Addon Table',
  `am_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Archive Model Type(0:system, 1:custom)',
  `am_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Archive Model Status(0:off, 1:on)',
  `am_tpl_list` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - List',
  `am_tpl_add` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - Add',
  `am_tpl_edit` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - Edit',
  `am_tpl_list_member` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - List for Member',
  `am_tpl_add_member` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - Add for Member',
  `am_tpl_edit_member` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Model Manage Template - Edit for Member',
  `ac_tpl_index_default` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Channel Index Default Template',
  `ac_tpl_list_default` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Channel List Default Template',
  `ac_tpl_archive_default` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Channel Archive Default Template',
  `am_fieldset` text NOT NULL COMMENT 'Archive Model Addon Table Fieldset',
  PRIMARY KEY (`archive_model_id`),
  KEY `archive_model_id` (`archive_model_id`),
  KEY `am_alias` (`am_alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Archive Model' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_archive_model`
--

INSERT INTO `prefix_archive_model` (`archive_model_id`, `am_alias`, `am_name`, `am_addon_table`, `am_type`, `am_status`, `am_tpl_list`, `am_tpl_add`, `am_tpl_edit`, `am_tpl_list_member`, `am_tpl_add_member`, `am_tpl_edit_member`, `ac_tpl_index_default`, `ac_tpl_list_default`, `ac_tpl_archive_default`, `am_fieldset`) VALUES
(1, 'article', '文章', 'archive_addon_article', 0, 1, 'archive/list_archive_article', 'archive/add_archive_article', 'archive/edit_archive_article', 'member/list_archive_article', 'member/add_archive_article', 'member/edit_archive_article', 'index_channel_article', 'list_archive_article', 'show_archive_article', '<field:a_a_source f_item_name="文章来源" f_type="text" f_length="" f_default="" f_is_auto="0" f_is_list="0" f_save_remote="0" f_watermark_remote="0" f_get_thumb="0" f_get_abstract="0" f_is_paging="0" >\r\n</field:a_a_source>\r\n<field:a_a_author f_item_name="文章作者" f_type="text" f_length="" f_default="" f_is_auto="0" f_is_list="0" f_save_remote="0" f_watermark_remote="0" f_get_thumb="0" f_get_abstract="0" f_is_paging="0" >\r\n</field:a_a_author>\r\n<field:a_a_content f_item_name="文章内容" f_is_auto="1" f_is_list="0" f_save_remote="1" f_watermark_remote="1" f_get_thumb="1" f_get_abstract="1" f_is_paging="1" f_type="htmltext" f_length="" f_default="" >\r\n</field:a_a_content>');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_archive_review`
--

DROP TABLE IF EXISTS `prefix_archive_review`;
CREATE TABLE IF NOT EXISTS `prefix_archive_review` (
  `archive_review_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Archive Review ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID(0:guest)',
  `ar_author` varchar(255) NOT NULL DEFAULT '' COMMENT 'Archive Review Author',
  `ar_content` text NOT NULL COMMENT 'Archive Review Content',
  `ar_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Status(0:not pass, 1:passed)',
  `ar_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Add Time',
  `ar_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Archive Review Add IP',
  `ar_support_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Support Count',
  `ar_oppose_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Review Oppose Count',
  `ar_reply` text NOT NULL COMMENT 'Archive Review Reply',
  `archive_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive ID',
  `archive_channel_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive Channel ID',
  PRIMARY KEY (`archive_review_id`),
  KEY `archive_review_id` (`archive_review_id`),
  KEY `archive_id` (`archive_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Archive Review' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_flink`
--

DROP TABLE IF EXISTS `prefix_flink`;
CREATE TABLE IF NOT EXISTS `prefix_flink` (
  `flink_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Friend Link ID',
  `f_site_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link Site Name',
  `f_site_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link Site URL',
  `f_site_logo` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link Site Logo',
  `f_site_description` text NOT NULL COMMENT 'Link Site Description',
  `f_webmaster_email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link Site Webmaster Email',
  `f_show_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Link Show Type(0:text, 1:logo)',
  `f_display_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Link Display Order',
  `f_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Link Status(0:not pass, 1:passed)',
  `flink_category_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Link Category ID',
  PRIMARY KEY (`flink_id`),
  KEY `flink_id` (`flink_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Firend Link' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_flink`
--

INSERT INTO `prefix_flink` (`flink_id`, `f_site_name`, `f_site_url`, `f_site_logo`, `f_site_description`, `f_webmaster_email`, `f_show_type`, `f_display_order`, `f_status`, `flink_category_id`) VALUES
(1, '如斯', 'http://asthis.net', '', '', '', 0, 0, 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_flink_category`
--

DROP TABLE IF EXISTS `prefix_flink_category`;
CREATE TABLE IF NOT EXISTS `prefix_flink_category` (
  `flink_category_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Friend Link Category ID',
  `fc_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Friend Link Category Name',
  `fc_display_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Link Category Display Order',
  PRIMARY KEY (`flink_category_id`),
  KEY `flink_category_id` (`flink_category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Friend Link Category' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_flink_category`
--

INSERT INTO `prefix_flink_category` (`flink_category_id`, `fc_name`, `fc_display_order`) VALUES
(1, '合作媒体', 0);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_guestbook`
--

DROP TABLE IF EXISTS `prefix_guestbook`;
CREATE TABLE IF NOT EXISTS `prefix_guestbook` (
  `guestbook_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Guestbook ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID(0:guest)',
  `g_author` varchar(255) NOT NULL DEFAULT '' COMMENT 'Guestbook Author',
  `g_content` text NOT NULL COMMENT 'Guestbook Content',
  `g_reply` text NOT NULL COMMENT 'Guestbook Reply',
  `g_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Guestbook Status(0:filter, 1:normal)',
  `g_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guestbook Add Time',
  `g_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Guestbook Add IP',
  PRIMARY KEY (`guestbook_id`),
  KEY `guestbook_id` (`guestbook_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Guestbook' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_guestbook`
--

INSERT INTO `prefix_guestbook` (`guestbook_id`, `member_id`, `g_author`, `g_content`, `g_reply`, `g_status`, `g_add_time`, `g_add_ip`) VALUES
(1, 1, 'UWA游客', 'UWA留言内容', '管理回复内容', 1, {-time-}, '{-ip-}');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member`
--

DROP TABLE IF EXISTS `prefix_member`;
CREATE TABLE IF NOT EXISTS `prefix_member` (
  `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member ID',
  `m_userid` varchar(32) NOT NULL DEFAULT '' COMMENT 'Member UserID(for login)',
  `m_password` varchar(32) NOT NULL DEFAULT '' COMMENT 'Member Password',
  `m_username` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Username(display)',
  `m_email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Email',
  `m_reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Register Time',
  `m_reg_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Member Register IP',
  `m_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Login Time',
  `m_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Member Login IP',
  `m_experience` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Experience(related with permission levels)',
  `m_points` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Points(related with spending)',
  `m_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Status(0:not pass, 1:passed, 2:forbidden)',
  `member_level_id` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Level ID',
  `member_model_id` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Model ID',
  PRIMARY KEY (`member_id`),
  UNIQUE KEY `m_userid` (`m_userid`),
  KEY `member_id` (`member_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_member`
--

INSERT INTO `prefix_member` (`member_id`, `m_userid`, `m_password`, `m_username`, `m_email`, `m_reg_time`, `m_reg_ip`, `m_login_time`, `m_login_ip`, `m_experience`, `m_points`, `m_status`, `member_level_id`, `member_model_id`) VALUES
(1, '{-ausr-}', '{-apwd-}', '创始人', '{-email-}', {-time-}, '{-ip-}', {-time-}, '{-ip-}', 7, 0, 1, 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_addon_person`
--

DROP TABLE IF EXISTS `prefix_member_addon_person`;
CREATE TABLE IF NOT EXISTS `prefix_member_addon_person` (
  `member_id` int(10) unsigned NOT NULL COMMENT 'Member ID',
  `m_p_gender` enum('m','f','s') NOT NULL DEFAULT 'm' COMMENT 'gender:m|male, f|female, s|secret',
  PRIMARY KEY (`member_id`),
  KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Person';

--
-- 转存表中的数据 `prefix_member_addon_person`
--

INSERT INTO `prefix_member_addon_person` (`member_id`, `m_p_gender`) VALUES
(1, 's');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_credit`
--

DROP TABLE IF EXISTS `prefix_member_credit`;
CREATE TABLE IF NOT EXISTS `prefix_member_credit` (
  `member_id` int(10) unsigned NOT NULL COMMENT 'Member ID',
  `mc_credit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Credit',
  `mc_copper` int(10) unsigned NOT NULL DEFAULT '10' COMMENT 'Copper',
  `mc_silver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Silver',
  PRIMARY KEY (`member_id`),
  KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Member Credit Data';

--
-- 转存表中的数据 `prefix_member_credit`
--

INSERT INTO `prefix_member_credit` (`member_id`, `mc_credit`, `mc_copper`, `mc_silver`) VALUES
(1, 0, 50, 0);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_credit_type`
--

DROP TABLE IF EXISTS `prefix_member_credit_type`;
CREATE TABLE IF NOT EXISTS `prefix_member_credit_type` (
  `member_credit_type_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Credit Type ID',
  `mct_alias` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Credit Type Alias(for field name)',
  `mct_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Credit Type Name',
  `mct_unit` varchar(96) NOT NULL COMMENT 'Member Credit Type Unit',
  `mct_default` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Credit Type Default Value',
  `mct_exchange` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Credit Type Exchange Switch(0:off, 1:on)',
  `mct_ratio` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Credit Type Exchange Ratio',
  PRIMARY KEY (`member_credit_type_id`),
  KEY `member_credit_type_id` (`member_credit_type_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member Credit Type' AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `prefix_member_credit_type`
--

INSERT INTO `prefix_member_credit_type` (`member_credit_type_id`, `mct_alias`, `mct_name`, `mct_unit`, `mct_default`, `mct_exchange`, `mct_ratio`) VALUES
(1, 'mc_credit', '积分', '分', 0, 0, 1),
(2, 'mc_copper', '铜钱', '钱', 10, 1, 1),
(3, 'mc_silver', '银子', '两', 0, 1, 1000);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_favorite`
--

DROP TABLE IF EXISTS `prefix_member_favorite`;
CREATE TABLE IF NOT EXISTS `prefix_member_favorite` (
  `member_favorite_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Favorite ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID',
  `archive_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive ID',
  `mf_title` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Favorite Title',
  `mf_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Favorite URL',
  `mf_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Favorite Add Time',
  PRIMARY KEY (`member_favorite_id`),
  KEY `member_favorite_id` (`member_favorite_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Member Favorite' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_level`
--

DROP TABLE IF EXISTS `prefix_member_level`;
CREATE TABLE IF NOT EXISTS `prefix_member_level` (
  `member_level_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Level ID',
  `ml_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Level Name',
  `ml_rank` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Member Level Rank',
  `ml_min_experience` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member Level Min Experience',
  `ml_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Level Type(0:system, 1:custom)',
  PRIMARY KEY (`member_level_id`),
  KEY `member_level_id` (`member_level_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member Level' AUTO_INCREMENT=5 ;

--
-- 转存表中的数据 `prefix_member_level`
--

INSERT INTO `prefix_member_level` (`member_level_id`, `ml_name`, `ml_rank`, `ml_min_experience`, `ml_type`) VALUES
(1, '注册会员', 1, 0, 1),
(2, '中级会员', 5, 500, 1),
(3, '高级会员', 10, 2000, 1),
(4, 'VIP 1', 50, 5, 0);

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_model`
--

DROP TABLE IF EXISTS `prefix_member_model`;
CREATE TABLE IF NOT EXISTS `prefix_member_model` (
  `member_model_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Model ID',
  `mm_alias` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Model Alias(English)',
  `mm_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Model Name',
  `mm_addon_table` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Model Addon Table',
  `mm_description` text NOT NULL COMMENT 'Member Model Description',
  `mm_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Model Status(0:off, 1:on)',
  `mm_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Member Model Type(0:system, 1:custom)',
  `mm_tpl_add` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Model Manage Template - Add',
  `mm_tpl_edit` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Model Manage Template - Edit',
  `mm_tpl_add_member` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Model Manage Template - Add for Member',
  `mm_tpl_edit_member` varchar(255) NOT NULL DEFAULT '' COMMENT 'Member Model Manage Template - Edit for Member',
  `mm_fieldset` text NOT NULL COMMENT 'Member Model Fieldset',
  PRIMARY KEY (`member_model_id`),
  KEY `member_model_id` (`member_model_id`),
  KEY `mm_alias` (`mm_alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member Model' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_member_model`
--

INSERT INTO `prefix_member_model` (`member_model_id`, `mm_alias`, `mm_name`, `mm_addon_table`, `mm_description`, `mm_status`, `mm_type`, `mm_tpl_add`, `mm_tpl_edit`, `mm_tpl_add_member`, `mm_tpl_edit_member`, `mm_fieldset`) VALUES
(1, 'person', '个人', 'member_addon_person', '系统个人会员模型', 1, 0, 'member/add_member_person', 'member/edit_member_person', 'member/register_person', 'member/edit_info_addon_person', '<field:m_p_gender f_item_name="性别" f_is_auto="1" f_is_list="0" f_type="radio" f_length="" f_default="s|保密,m|男,f|女" >\r\n</field:m_p_gender>');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_notify`
--

DROP TABLE IF EXISTS `prefix_member_notify`;
CREATE TABLE IF NOT EXISTS `prefix_member_notify` (
  `member_notify_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Notify ID',
  `mn_admin_userid` varchar(96) NOT NULL DEFAULT '' COMMENT 'Member Notify Administrator ID',
  `mn_m_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Notify Receive Member ID(-1:all member)',
  `mn_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Notify Status(0:unread, 1:have read)',
  `mn_send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Notify Send Time',
  `mn_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Notify Title',
  `mn_content` text NOT NULL COMMENT 'Notify Content',
  PRIMARY KEY (`member_notify_id`),
  KEY `member_notify_id` (`member_notify_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member Notify' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_member_notify`
--

INSERT INTO `prefix_member_notify` (`member_notify_id`, `mn_admin_userid`, `mn_m_id`, `mn_status`, `mn_send_time`, `mn_title`, `mn_content`) VALUES
(1, '{-ausr-}', -1, 0, {-time-}, '全部会员通知', '全部会员通知的内容');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_member_order`
--

DROP TABLE IF EXISTS `prefix_member_order`;
CREATE TABLE IF NOT EXISTS `prefix_member_order` (
  `member_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Member Order ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID',
  `mo_product_type` varchar(96) NOT NULL DEFAULT '' COMMENT 'Order Product Type',
  `mo_product_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Order Product Name',
  `mo_points` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Points',
  `mo_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Status',
  `mo_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Add Time',
  `mo_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Order Add IP',
  PRIMARY KEY (`member_order_id`),
  KEY `member_order_id` (`member_order_id`),
  KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Order' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_menu`
--

DROP TABLE IF EXISTS `prefix_menu`;
CREATE TABLE IF NOT EXISTS `prefix_menu` (
  `menu_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Menu ID',
  `m_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu Name',
  `m_parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Menu Parent ID',
  `m_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Menu Type(0:compose, 1:direct url)',
  `m_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu URL(ctrlr/actn?params or url)',
  `m_target` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Menu Target(0:current window, 1:new window)',
  `m_display_order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Menu Display Order',
  `ms_alias` varchar(96) NOT NULL DEFAULT '' COMMENT 'Menu Space Alias',
  PRIMARY KEY (`menu_id`),
  KEY `menu_id` (`menu_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Menu' AUTO_INCREMENT=5 ;

--
-- 转存表中的数据 `prefix_menu`
--

INSERT INTO `prefix_menu` (`menu_id`, `m_name`, `m_parent_id`, `m_type`, `m_url`, `m_target`, `m_display_order`, `ms_alias`) VALUES
(1, '首页', 0, 0, 'home@index/index', 0, 10, 'main'),
(2, '文章频道一', 0, 0, 'home@archive/show_channel?archive_channel_id=1', 0, 20, 'main'),
(3, '留言', 0, 0, 'home@guestbook/list_guestbook', 0, 30, 'main'),
(4, '关于我们', 0, 0, 'home@single_page/show_single_page?single_page_id=1', 0, 40, 'footer');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_menu_space`
--

DROP TABLE IF EXISTS `prefix_menu_space`;
CREATE TABLE IF NOT EXISTS `prefix_menu_space` (
  `menu_space_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Menu Space ID',
  `ms_alias` varchar(96) NOT NULL DEFAULT '' COMMENT 'Menu Space Alias',
  `ms_name` varchar(96) NOT NULL DEFAULT '' COMMENT 'Menu Space Name',
  `ms_description` text NOT NULL COMMENT 'Menu Space Description',
  PRIMARY KEY (`menu_space_id`),
  UNIQUE KEY `ms_alias` (`ms_alias`),
  KEY `menu_space_id` (`menu_space_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Menu Space' AUTO_INCREMENT=3 ;

--
-- 转存表中的数据 `prefix_menu_space`
--

INSERT INTO `prefix_menu_space` (`menu_space_id`, `ms_alias`, `ms_name`, `ms_description`) VALUES
(1, 'main', '主菜单', '网站顶部主导航菜单'),
(2, 'footer', '脚部菜单', '脚部菜单');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_option`
--

DROP TABLE IF EXISTS `prefix_option`;
CREATE TABLE IF NOT EXISTS `prefix_option` (
  `option_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `o_key` varchar(96) NOT NULL DEFAULT '' COMMENT 'Option Key',
  `o_value` text NOT NULL COMMENT 'Option Value',
  `o_value_type` varchar(10) NOT NULL DEFAULT 'string' COMMENT 'Option Value Type(array:serialize_array, string, number, bool, multi_text, html_text)',
  `o_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Option Type(0:system, 1:custom)',
  `o_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Option Title',
  `o_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'Option Description',
  PRIMARY KEY (`option_id`),
  KEY `option_id` (`option_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Option' AUTO_INCREMENT=8 ;

--
-- 转存表中的数据 `prefix_option`
--

INSERT INTO `prefix_option` (`option_id`, `o_key`, `o_value`, `o_value_type`, `o_type`, `o_title`, `o_description`) VALUES
(1, 'site', 'a:10:{s:4:"name";s:43:"UWA 通用建站 - Universal Website AsThis";s:4:"host";s:17:"http://asthis.net";s:4:"logo";s:15:"u/site/logo.png";s:8:"language";s:5:"zh-cn";s:5:"theme";s:7:"default";s:14:"tpl_protection";s:1:"0";s:8:"keywords";s:22:"uwa,通用建站如斯";s:11:"description";s:33:"uwa通用建站如斯官方网站";s:9:"copyright";s:102:"<p>\r\n	&copy;2013 <a href=\\"http://asthis.net\\" target=\\"_blank\\"><strong>asthis.net</strong></a></p>\r\n";s:9:"stat_code";s:0:"";}', 'array', 0, '', ''),
(2, 'core', 'a:12:{s:14:"rewrite_switch";s:1:"0";s:11:"html_switch";s:1:"0";s:17:"html_expire_index";s:4:"7200";s:16:"html_expire_list";s:5:"14400";s:19:"html_expire_archive";s:6:"604800";s:9:"html_path";s:2:"/a";s:13:"cookie_prefix";s:4:"uwa_";s:13:"cookie_expire";s:4:"3600";s:10:"cookie_key";s:8:"{-cookie_key-}";s:12:"debug_switch";s:1:"0";s:10:"debug_stat";s:1:"0";s:16:"debug_page_trace";s:1:"0";}', 'array', 0, '', ''),
(3, 'member', 'a:9:{s:6:"switch";s:1:"1";s:8:"register";s:1:"1";s:8:"name_ban";s:47:"www,bbs,ftp,mail,user,users,admin,administrator";s:17:"userid_min_length";s:1:"5";s:19:"password_min_length";s:1:"5";s:9:"pass_type";s:1:"1";s:12:"login_credit";a:5:{s:12:"m_experience";s:1:"2";s:8:"m_points";s:1:"0";s:9:"mc_credit";s:1:"0";s:9:"mc_copper";s:1:"2";s:9:"mc_silver";s:1:"0";}s:14:"publish_credit";a:5:{s:12:"m_experience";s:1:"2";s:8:"m_points";s:1:"0";s:9:"mc_credit";s:1:"0";s:9:"mc_copper";s:1:"2";s:9:"mc_silver";s:1:"0";}s:13:"review_credit";a:5:{s:12:"m_experience";s:1:"1";s:8:"m_points";s:1:"0";s:9:"mc_credit";s:1:"0";s:9:"mc_copper";s:1:"1";s:9:"mc_silver";s:1:"0";}}', 'array', 0, '', ''),
(4, 'upload', 'a:5:{s:6:"switch";s:1:"1";s:7:"imgtype";s:16:"jpg,jpeg,gif,png";s:8:"filetype";s:10:"zip,7z,rar";s:3:"dir";s:2:"/u";s:7:"maxsize";s:3:"200";}', 'array', 0, '', ''),
(5, 'image', 'a:7:{s:12:"thumb_prefix";s:6:"thumb_";s:11:"thumb_width";s:3:"160";s:12:"thumb_height";s:3:"100";s:18:"thumb_proportional";s:1:"1";s:9:"watermark";s:1:"1";s:15:"watermark_image";s:21:"/u/site/watermark.png";s:18:"watermark_position";s:1:"9";}', 'array', 0, '', ''),
(6, 'interaction', 'a:10:{s:13:"review_switch";s:1:"1";s:16:"guestbook_switch";s:1:"1";s:13:"search_switch";s:1:"1";s:14:"feedback_check";s:1:"0";s:17:"feedback_interval";s:2:"10";s:15:"search_interval";s:1:"3";s:7:"captcha";s:1:"1";s:11:"auto_report";s:1:"1";s:12:"filter_words";s:19:"胡锦涛|江泽民";s:14:"filter_replace";s:1:"*";}', 'array', 0, '', ''),
(7, 'contact_tel', '+86-888-88888888', 'string', 1, '联系电话', '网站联系电话');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_report`
--

DROP TABLE IF EXISTS `prefix_report`;
CREATE TABLE IF NOT EXISTS `prefix_report` (
  `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Report ID',
  `r_item_type` varchar(64) NOT NULL DEFAULT '' COMMENT 'Report Item Type(archive, archive_review ...)',
  `r_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Report Item ID',
  `r_info` text NOT NULL COMMENT 'Report Infomation',
  `r_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Report Add Time',
  `r_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Report Add IP',
  `r_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Report Status(0:not deal, 1:dealed)',
  PRIMARY KEY (`report_id`),
  KEY `report_id` (`report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Report' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_single_page`
--

DROP TABLE IF EXISTS `prefix_single_page`;
CREATE TABLE IF NOT EXISTS `prefix_single_page` (
  `single_page_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Single Page ID',
  `sp_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Single Page Title',
  `sp_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'Single Page Keywords',
  `sp_description` text NOT NULL COMMENT 'Single Page Description',
  `sp_content` mediumtext NOT NULL COMMENT 'Single Page Content',
  `sp_display_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Single Page Display Order',
  `sp_edit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Single Page Edit Time',
  `sp_is_html` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Html File Build Switch',
  `sp_tpl` varchar(255) NOT NULL DEFAULT '' COMMENT 'Single Page Template',
  `sp_html_naming` varchar(255) NOT NULL DEFAULT '' COMMENT 'Single Page Html File Naming',
  `sp_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Single Page URL',
  PRIMARY KEY (`single_page_id`),
  KEY `single_page_id` (`single_page_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Single Page' AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `prefix_single_page`
--

INSERT INTO `prefix_single_page` (`single_page_id`, `sp_title`, `sp_keywords`, `sp_description`, `sp_content`, `sp_display_order`, `sp_edit_time`, `sp_is_html`, `sp_tpl`, `sp_html_naming`, `sp_url`) VALUES
(1, '关于我们', '', '', '<p>\r\n	关于我们...</p>\r\n', 10, {-time-}, 0, 'show_single_page', 'about.html', 'index.php?c=single_page&a=show_single_page&single_page_id=1');

-- --------------------------------------------------------

--
-- 表的结构 `prefix_tag`
--

DROP TABLE IF EXISTS `prefix_tag`;
CREATE TABLE IF NOT EXISTS `prefix_tag` (
  `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tag Name',
  `t_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Tag Name',
  `t_archive_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tag Archive Count',
  `t_view_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tag View Count',
  `t_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tag Add Time',
  `t_add_ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'Tag Add IP',
  PRIMARY KEY (`tag_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tag' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `prefix_tag_archive_index`
--

DROP TABLE IF EXISTS `prefix_tag_archive_index`;
CREATE TABLE IF NOT EXISTS `prefix_tag_archive_index` (
  `tag_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tag ID',
  `archive_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Archive ID'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tag Archive Index';

-- --------------------------------------------------------

--
-- 表的结构 `prefix_upload`
--

DROP TABLE IF EXISTS `prefix_upload`;
CREATE TABLE IF NOT EXISTS `prefix_upload` (
  `upload_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Upload ID',
  `u_filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Upload File Name',
  `u_src` varchar(255) NOT NULL DEFAULT '' COMMENT 'Upload File Src',
  `u_type` varchar(32) NOT NULL DEFAULT '' COMMENT 'Upload File Type',
  `u_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Upload File Size',
  `u_add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Upload Add Time',
  `u_item_type` varchar(96) NOT NULL DEFAULT '' COMMENT 'Item Type(model alias)',
  `u_item_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Item ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member ID',
  PRIMARY KEY (`upload_id`),
  KEY `upload_id` (`upload_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Upload' AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
