ywcms.sql

web的CMS管理系统

INSERT INTO `yw_cms_category_type` VALUES (1, 3, '文字新聞髮佈');
INSERT INTO `yw_cms_category_type` VALUES (2, 3, '圖文新聞髮佈');
INSERT INTO `yw_cms_category_type` VALUES (3, 3, '文字信息髮佈');
INSERT INTO `yw_cms_category_type` VALUES (4, 3, '圖文信息髮佈');
INSERT INTO `yw_cms_category_type` VALUES (5, 3, '下載（多媒體）文件髮佈');
INSERT INTO `yw_cms_category_type` VALUES (6, 3, '外部繫統鏈接');

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

-- 
-- 表的结构 `yw_cms_client_visit_log`
-- 

CREATE TABLE `yw_cms_client_visit_log` (
  `log_id` bigint(20) NOT NULL auto_increment,
  `log_time` varchar(60) default NULL,
  `remote_ip` varchar(40) default NULL,
  `member_name` varchar(30) default NULL,
  `action` varchar(40) default NULL,
  `action_object` varchar(40) default NULL,
  `object_name` varchar(255) default NULL,
  `is_formatted` int(11) NOT NULL default '1',
  `plain_text` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`log_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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


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

-- 
-- 表的结构 `yw_cms_homepage`
-- 

CREATE TABLE `yw_cms_homepage` (
  `homepage_id` int(11) NOT NULL auto_increment,
  `template_id` bigint(20) NOT NULL default '1',
  `homepage_lang_id` int(11) NOT NULL default '1',
  `category_id` bigint(20) default '1',
  `page_id` bigint(20) default '1',
  `last_updated_time` timestamp(14) NOT NULL,
  `last_updator` int(11) default '1',
  PRIMARY KEY  (`homepage_id`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;

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

INSERT INTO `yw_cms_homepage` VALUES (6, 37, 1, 14, 0, '20050325080900', 1);
INSERT INTO `yw_cms_homepage` VALUES (2, 38, 1, 12, 0, '20050325075807', 1);
INSERT INTO `yw_cms_homepage` VALUES (14, 39, 1, 14, 0, '20050408072111', 2);
INSERT INTO `yw_cms_homepage` VALUES (13, 40, 1, 12, 0, '20050408072048', 2);
INSERT INTO `yw_cms_homepage` VALUES (7, 9, 1, 3, 0, '20050401092437', 1);
INSERT INTO `yw_cms_homepage` VALUES (12, 7, 1, 14, 0, '20050402062613', 1);
INSERT INTO `yw_cms_homepage` VALUES (9, 8, 1, 12, 0, '20050401092555', 1);
INSERT INTO `yw_cms_homepage` VALUES (11, 10, 1, 15, 24, '20050401092642', 1);
INSERT INTO `yw_cms_homepage` VALUES (17, 41, 1, 3, 0, '20050423194224', 2);
INSERT INTO `yw_cms_homepage` VALUES (19, 42, 1, 15, 24, '20050423200857', 2);
INSERT INTO `yw_cms_homepage` VALUES (29, 123, 1, 3, 0, '20050604014538', 2);
INSERT INTO `yw_cms_homepage` VALUES (30, 121, 1, 14, 0, '20050604014544', 2);
INSERT INTO `yw_cms_homepage` VALUES (31, 122, 1, 12, 0, '20050604014643', 2);
INSERT INTO `yw_cms_homepage` VALUES (24, 124, 1, 15, 24, '20050527232718', 2);

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

-- 
-- 表的结构 `yw_cms_lang`
-- 

CREATE TABLE `yw_cms_lang` (
  `lang_id` int(11) NOT NULL auto_increment,
  `lang_name` varchar(30) default NULL,
  `lang_prefx_name` varchar(30) default NULL,
  PRIMARY KEY  (`lang_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

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

INSERT INTO `yw_cms_lang` VALUES (1, '简体', 'cn');
INSERT INTO `yw_cms_lang` VALUES (2, 'ENGLISH', 'en');
INSERT INTO `yw_cms_lang` VALUES (3, '繁體', 'big5');

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

-- 
-- 表的结构 `yw_cms_member`