ywcms.sql

web的CMS管理系统

-- phpMyAdmin SQL Dump
-- version 2.6.0-rc2
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost:3306
-- 生成日期: 2005 年 06 月 04 日 03:33
-- 服务器版本: 4.0.24
-- PHP 版本: 5.0.1
-- 
-- 数据库: `ywcms`
-- 

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

-- 
-- 表的结构 `yw_cms_category`
-- 

CREATE TABLE `yw_cms_category` (
  `category_id` bigint(20) NOT NULL auto_increment,
  `category_lang_id` int(11) NOT NULL default '1',
  `parent_id` bigint(20) default '1',
  `sort_num` int(11) default '1',
  `category_name` varchar(30) default NULL,
  `category_level` int(11) default '1',
  `category_type` int(11) default '4',
  `is_hide` int(11) default '2',
  `display_only` int(11) default '2',
  `for_navigation` int(11) default '1',
  `member_access_type` int(11) default '1',
  `category_summary` varchar(255) default NULL,
  `click_num` bigint(20) default '0',
  `resource_id` bigint(20) default '1',
  `template_id` bigint(20) default '1',
  `last_updated_time` timestamp(14) NOT NULL,
  `last_updator` int(11) default '1',
  PRIMARY KEY  (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=27 ;

-- 
-- 导出表中的数据 `yw_cms_category`
-- 

INSERT INTO `yw_cms_category` VALUES (1, 1, 0, 1, '产品信息', 1, 4, 2, 2, 1, 1, '产品信息', 0, 125, 182, '20050604014531', 1);
INSERT INTO `yw_cms_category` VALUES (3, 1, 0, 2, '我要购买', 1, 4, 2, 2, 1, 1, '我要购买', 0, 122, 182, '20050604014538', 1);
INSERT INTO `yw_cms_category` VALUES (15, 1, 11, 2, '为什么选择远望', 2, 4, 2, 2, 2, 1, '为什么选择远望', 0, 0, 202, '20050604014652', 1);
INSERT INTO `yw_cms_category` VALUES (5, 1, 0, 4, '管理中心', 1, 6, 2, 2, 1, 2, '管理中心', 0, 0, 202, '20050604014549', 1);
INSERT INTO `yw_cms_category` VALUES (6, 1, 0, 5, '远望论坛', 1, 6, 2, 2, 1, 2, '远望论坛', 0, 0, 203, '20050604014554', 1);
INSERT INTO `yw_cms_category` VALUES (7, 1, 0, 6, '关于我们', 1, 4, 2, 2, 1, 1, '关于我们', 0, 121, 182, '20050604014616', 1);
INSERT INTO `yw_cms_category` VALUES (12, 1, 11, 1, '最近更新', 2, 1, 2, 1, 2, 1, '最近更新', 0, 0, 202, '20050604014643', 1);
INSERT INTO `yw_cms_category` VALUES (11, 1, 0, 7, '首页', 1, 4, 2, 1, 2, 1, '首页', 0, 0, 202, '20050604014624', 1);
INSERT INTO `yw_cms_category` VALUES (14, 1, 0, 3, '下载专区', 1, 5, 2, 2, 1, 2, '下载专区', 0, 123, 180, '20050604014544', 1);
INSERT INTO `yw_cms_category` VALUES (16, 3, 0, 1, '測試1', 1, 1, 2, 2, 1, 1, '測試1', 0, 0, 10, '20050423204348', 2);
INSERT INTO `yw_cms_category` VALUES (17, 2, 0, 1, 'test1', 1, 1, 2, 2, 1, 1, 'test', 0, 0, 84, '20050423204511', 2);
INSERT INTO `yw_cms_category` VALUES (18, 1, 0, 8, '演示1', 1, 2, 2, 2, 1, 1, '演示1', 0, 123, 178, '20050604014658', 2);
INSERT INTO `yw_cms_category` VALUES (19, 1, 18, 1, '演示1.1', 2, 2, 2, 2, 1, 1, '演示1.1', 0, 123, 178, '20050604014707', 2);
INSERT INTO `yw_cms_category` VALUES (20, 1, 19, 1, '演示1.1.1', 3, 2, 2, 2, 1, 1, '演示1.1.1', 0, 123, 178, '20050604014713', 2);
INSERT INTO `yw_cms_category` VALUES (22, 1, 18, 2, '演示1.2', 2, 2, 2, 2, 1, 1, '演示1.2', 0, 124, 178, '20050604014717', 2);
INSERT INTO `yw_cms_category` VALUES (23, 1, 0, 9, '演示2', 1, 2, 2, 2, 1, 1, '演示2', 0, 123, 179, '20050604014722', 2);
INSERT INTO `yw_cms_category` VALUES (24, 1, 23, 1, '演示2.1', 2, 2, 2, 2, 1, 1, '演示2.1', 0, 123, 179, '20050604014728', 2);
INSERT INTO `yw_cms_category` VALUES (25, 1, 23, 2, '演示2.2', 2, 2, 2, 2, 1, 1, '演示2.2', 0, 122, 179, '20050604014738', 2);
INSERT INTO `yw_cms_category` VALUES (26, 1, 24, 1, '演示2.1.1', 3, 2, 2, 2, 1, 1, '演示2.1.1', 0, 126, 179, '20050604014733', 2);

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

-- 
-- 表的结构 `yw_cms_category_type`
-- 

CREATE TABLE `yw_cms_category_type` (
  `type_id` int(11) NOT NULL default '0',
  `type_lang_id` int(11) NOT NULL default '0',
  `type_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`type_id`,`type_lang_id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `yw_cms_category_type`
-- 

INSERT INTO `yw_cms_category_type` VALUES (1, 1, '文字新闻发布');
INSERT INTO `yw_cms_category_type` VALUES (2, 1, '图文新闻发布');
INSERT INTO `yw_cms_category_type` VALUES (3, 1, '文字信息发布');
INSERT INTO `yw_cms_category_type` VALUES (4, 1, '图文信息发布');
INSERT INTO `yw_cms_category_type` VALUES (5, 1, '下载（多媒体）文件发布');
INSERT INTO `yw_cms_category_type` VALUES (6, 1, '外部系统链接');
INSERT INTO `yw_cms_category_type` VALUES (1, 2, 'Text News');
INSERT INTO `yw_cms_category_type` VALUES (2, 2, 'Img. News');
INSERT INTO `yw_cms_category_type` VALUES (3, 2, 'Text Msg.');
INSERT INTO `yw_cms_category_type` VALUES (4, 2, 'Img. Msg.');
INSERT INTO `yw_cms_category_type` VALUES (5, 2, 'Download(MultiMedia) Files.');
INSERT INTO `yw_cms_category_type` VALUES (6, 2, 'External System');