ywcms.sql

web的CMS管理系统

-- 

CREATE TABLE `yw_cms_member` (
  `member_id` bigint(20) NOT NULL auto_increment,
  `full_name` varchar(40) default NULL,
  `nickname` varchar(40) default NULL,
  `member_passwd` varchar(40) default NULL,
  `password_question` varchar(40) default NULL,
  `password_answer` varchar(40) default NULL,
  `phone` varchar(40) default NULL,
  `email` varchar(40) default NULL,
  `status` int(11) default '1',
  `member_access_type` int(11) default '1',
  `created_time` date default NULL,
  `last_updated_time` timestamp(14) NOT NULL,
  `last_updator` int(11) default NULL,
  PRIMARY KEY  (`member_id`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

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

INSERT INTO `yw_cms_member` VALUES (1, 'guest', 'guest', '084E0343A0486FF05530DF6C705C8BB4', 'guest', 'guest', 'guest', 'guest', 1, 1, '2005-04-01', '20050523205905', NULL);
INSERT INTO `yw_cms_member` VALUES (2, 'junior', 'junior', 'B03E3FD2B3D22FF6DF2796C412B09311', 'junior', 'junior', 'junior', 'junior', 1, 2, '2005-03-31', '20050523205957', 0);
INSERT INTO `yw_cms_member` VALUES (3, 'senior', 'senior', 'C1A1738648ECDA410DC3A0DBBB3BE683', 'senior', 'senior', 'senior', 'senior', 1, 3, '2005-04-01', '20050523205947', NULL);
INSERT INTO `yw_cms_member` VALUES (4, 'vip', 'vip', '232059CB5361A9336CCF1B8C2BA7657A', 'vip', 'vip', 'vip', 'vip', 1, 4, '2005-04-01', '20050523205935', NULL);

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

-- 
-- 表的结构 `yw_cms_member_access_type`
-- 

CREATE TABLE `yw_cms_member_access_type` (
  `type_id` int(11) NOT NULL default '0',
  `type_lang_id` int(11) NOT NULL default '0',
  `parent_id` int(11) default '0',
  `type_level` int(11) default '1',
  `type_name` varchar(40) default NULL,
  PRIMARY KEY  (`type_id`,`type_lang_id`)
) TYPE=MyISAM;

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

INSERT INTO `yw_cms_member_access_type` VALUES (1, 1, 0, 1, '游客');
INSERT INTO `yw_cms_member_access_type` VALUES (2, 1, 0, 1, '普通会员');
INSERT INTO `yw_cms_member_access_type` VALUES (3, 1, 0, 1, '高级会员');
INSERT INTO `yw_cms_member_access_type` VALUES (4, 1, 0, 1, 'VIP会员');
INSERT INTO `yw_cms_member_access_type` VALUES (5, 1, 0, 1, '免费会员');
INSERT INTO `yw_cms_member_access_type` VALUES (1, 2, 0, 1, 'GUEST');
INSERT INTO `yw_cms_member_access_type` VALUES (2, 2, 0, 1, 'JUNIOR');
INSERT INTO `yw_cms_member_access_type` VALUES (3, 2, 0, 1, 'SENIOR');
INSERT INTO `yw_cms_member_access_type` VALUES (4, 2, 0, 1, 'VIP');
INSERT INTO `yw_cms_member_access_type` VALUES (5, 2, 0, 1, 'FREE');
INSERT INTO `yw_cms_member_access_type` VALUES (1, 3, 0, 1, '遊客');
INSERT INTO `yw_cms_member_access_type` VALUES (2, 3, 0, 1, '普通會員');
INSERT INTO `yw_cms_member_access_type` VALUES (3, 3, 0, 1, '高級會員');
INSERT INTO `yw_cms_member_access_type` VALUES (4, 3, 0, 1, 'VIP會員');
INSERT INTO `yw_cms_member_access_type` VALUES (5, 3, 0, 1, '免費會員');

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

-- 
-- 表的结构 `yw_cms_member_status`
-- 

CREATE TABLE `yw_cms_member_status` (
  `status_id` int(11) NOT NULL default '0',
  `status_lang_id` int(11) NOT NULL default '0',
  `status_name` varchar(40) default NULL,
  PRIMARY KEY  (`status_id`,`status_lang_id`)
) TYPE=MyISAM;

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

INSERT INTO `yw_cms_member_status` VALUES (1, 1, '正常');
INSERT INTO `yw_cms_member_status` VALUES (2, 1, '暂停');
INSERT INTO `yw_cms_member_status` VALUES (3, 1, '停止');
INSERT INTO `yw_cms_member_status` VALUES (1, 2, 'NORMAL');
INSERT INTO `yw_cms_member_status` VALUES (2, 2, 'SUPEND');
INSERT INTO `yw_cms_member_status` VALUES (3, 2, 'STOP');
INSERT INTO `yw_cms_member_status` VALUES (1, 3, '正常');
INSERT INTO `yw_cms_member_status` VALUES (3, 3, '停止');
INSERT INTO `yw_cms_member_status` VALUES (2, 3, '暫停');

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