ywcms.sql

web的CMS管理系统

INSERT INTO `yw_cms_param` VALUES (16, 1, 16, '资源同步时间', '300', '1', '1', '1000', NULL);
INSERT INTO `yw_cms_param` VALUES (1, 2, 11, 'Records Per Page List in Console', '18', '1', '1', '20', 'qq');
INSERT INTO `yw_cms_param` VALUES (2, 2, 10, 'headline number', '8', '1', '1', '99', 'headline number');
INSERT INTO `yw_cms_param` VALUES (3, 2, 3, 'Banner Image URL', 'http://localhost:8080/ywcms/en/resources/site/ywcms_banner.gif', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (4, 2, 4, 'Webmaster Email', '[e-mail]', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (5, 2, 5, 'Homepage Title', 'Yuanwang Tech. Studio--Just Demo', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (8, 2, 9, 'list number', '8', '1', '1', '10', 'list number');
INSERT INTO `yw_cms_param` VALUES (11, 2, 1, 'site name', 'Yuanwang Tech. Studio', '2', '1', '255', 'site name');
INSERT INTO `yw_cms_param` VALUES (15, 2, 15, 'Resource Sync. Delay', '10', '1', '1', '100', NULL);
INSERT INTO `yw_cms_param` VALUES (16, 2, 16, 'Resource Sync. Period', '180', '1', '1', '1000', 'Resource Sync. Period');
INSERT INTO `yw_cms_param` VALUES (1, 3, 11, '管理臺每頁記錄數', '18', '1', '1', '20', 'qq');
INSERT INTO `yw_cms_param` VALUES (2, 3, 10, '前臺大字標題數', '8', '1', '1', '99', NULL);
INSERT INTO `yw_cms_param` VALUES (3, 3, 3, '網站Banner圖片URL', 'http://localhost:8080/ywcms/big5/resources/site/ywcms_banner.gif', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (4, 3, 4, '網站管理員郵箱', '[e-mail]', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (5, 3, 5, '網站首頁標題', '遠望技術工作室--僅供縯示', '2', '1', '255', NULL);
INSERT INTO `yw_cms_param` VALUES (8, 3, 9, '網站列錶每頁記錄數', '8', '1', '1', '10', NULL);
INSERT INTO `yw_cms_param` VALUES (11, 3, 1, '網站名稱', '遠望技術工作室', '2', '1', '255', '遠望技術工作室');
INSERT INTO `yw_cms_param` VALUES (15, 3, 15, '資源同步延遲時間', '3', '1', '1', '100', NULL);
INSERT INTO `yw_cms_param` VALUES (16, 3, 16, '資源同步時間', '130', '1', '1', '1000', NULL);
INSERT INTO `yw_cms_param` VALUES (6, 1, 6, '网站Logo的URL', 'http://localhost:8080/ywcms/resources/site/ywcms_logo.gif', '2', '1', '255', '͸վLogo?ĕRL');
INSERT INTO `yw_cms_param` VALUES (6, 2, 6, 'Site Logo URL', 'http://localhost:8080/ywcms/en/resources/site/ywcms_logo.gif', '2', '1', '255', 'Site Logo URL');
INSERT INTO `yw_cms_param` VALUES (6, 3, 3, '網站Logo的URL', 'http://localhost:8080/ywcms/big5/resources/site/ywcms_logo.gif', '2', '1', '255', '?WվLogo?ĕRL');

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

-- 
-- 表的结构 `yw_cms_resource`
-- 

CREATE TABLE `yw_cms_resource` (
  `resource_id` bigint(20) NOT NULL auto_increment,
  `resource_lang_id` int(11) NOT NULL default '1',
  `resource_name` varchar(255) default NULL,
  `apply_to` int(11) default '1',
  `resource_url` varchar(255) default NULL,
  `remark` varchar(255) default NULL,
  `last_updated_time` timestamp(14) NOT NULL,
  `last_updator` int(11) default '1',
  PRIMARY KEY  (`resource_id`)
) TYPE=MyISAM AUTO_INCREMENT=184 ;

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

INSERT INTO `yw_cms_resource` VALUES (1, 3, 'about_us.gif', 21, '/big5/resources/app/categoryicon/about_us.gif', 'about_us.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (2, 3, 'business.gif', 21, '/big5/resources/app/categoryicon/business.gif', 'business.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (3, 3, 'download.gif', 21, '/big5/resources/app/categoryicon/download.gif', 'download.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (4, 3, 'parnter.gif', 21, '/big5/resources/app/categoryicon/parnter.gif', 'parnter.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (5, 3, 'products_info.gif', 21, '/big5/resources/app/categoryicon/products_info.gif', 'products_info.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (6, 3, 'sucess_case.gif', 21, '/big5/resources/app/categoryicon/sucess_case.gif', 'sucess_case.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (7, 3, 'support.gif', 21, '/big5/resources/app/categoryicon/support.gif', 'support.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (8, 3, 'announce1.gif', 22, '/big5/resources/app/pagecontent/announce1.gif', 'announce1.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (9, 3, 'announce2.gif', 22, '/big5/resources/app/pagecontent/announce2.gif', 'announce2.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (10, 3, 'announce3.gif', 22, '/big5/resources/app/pagecontent/announce3.gif', 'announce3.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (11, 3, 'announce4.gif', 22, '/big5/resources/app/pagecontent/announce4.gif', 'announce4.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (12, 3, 'bea_logo.gif', 22, '/big5/resources/app/pagecontent/bea_logo.gif', 'bea_logo.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (13, 3, 'choice_thing.gif', 22, '/big5/resources/app/pagecontent/choice_thing.gif', 'choice_thing.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (14, 3, 'freemarker.png', 22, '/big5/resources/app/pagecontent/freemarker.png', 'freemarker.png', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (15, 3, 'ges.jpg', 22, '/big5/resources/app/pagecontent/ges.jpg', 'ges.jpg', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (16, 3, 'ibatis.gif', 22, '/big5/resources/app/pagecontent/ibatis.gif', 'ibatis.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (17, 3, 'jboss_logo.gif', 22, '/big5/resources/app/pagecontent/jboss_logo.gif', 'jboss_logo.gif', '20050527220509', 1);
INSERT INTO `yw_cms_resource` VALUES (18, 3, 'lindex_sinotechmart.gif', 22, '/big5/resources/app/pagecontent/lindex_sinotechmart.gif', 'lindex_sinotechmart.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (19, 3, 'logo_java.gif', 22, '/big5/resources/app/pagecontent/logo_java.gif', 'logo_java.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (20, 3, 'logo_rh_home.png', 22, '/big5/resources/app/pagecontent/logo_rh_home.png', 'logo_rh_home.png', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (21, 3, 'main_pic.jpg', 22, '/big5/resources/app/pagecontent/main_pic.jpg', 'main_pic.jpg', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (22, 3, 'mysql.png', 22, '/big5/resources/app/pagecontent/mysql.png', 'mysql.png', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (23, 3, 'oa1.jpg', 22, '/big5/resources/app/pagecontent/oa1.jpg', 'oa1.jpg', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (24, 3, 'oralogo_small.gif', 22, '/big5/resources/app/pagecontent/oralogo_small.gif', 'oralogo_small.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (25, 3, 'purchaseflow.gif', 22, '/big5/resources/app/pagecontent/purchaseflow.gif', 'purchaseflow.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (26, 3, 'spring.gif', 22, '/big5/resources/app/pagecontent/spring.gif', 'spring.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (27, 3, 'struts.gif', 22, '/big5/resources/app/pagecontent/struts.gif', 'struts.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (28, 3, 'sun_logo.gif', 22, '/big5/resources/app/pagecontent/sun_logo.gif', 'sun_logo.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (29, 3, 'taglibs.gif', 22, '/big5/resources/app/pagecontent/taglibs.gif', 'taglibs.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (30, 3, 'tomcat.gif', 22, '/big5/resources/app/pagecontent/tomcat.gif', 'tomcat.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (31, 3, 'vpn.gif', 22, '/big5/resources/app/pagecontent/vpn.gif', 'vpn.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (32, 3, '1.gif', 23, '/big5/resources/app/pageicon/1.gif', '1.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (33, 3, '10.gif', 23, '/big5/resources/app/pageicon/10.gif', '10.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (34, 3, '11.gif', 23, '/big5/resources/app/pageicon/11.gif', '11.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (35, 3, '12.gif', 23, '/big5/resources/app/pageicon/12.gif', '12.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (36, 3, '13.gif', 23, '/big5/resources/app/pageicon/13.gif', '13.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (37, 3, '14.gif', 23, '/big5/resources/app/pageicon/14.gif', '14.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (38, 3, '15.gif', 23, '/big5/resources/app/pageicon/15.gif', '15.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (39, 3, '16.gif', 23, '/big5/resources/app/pageicon/16.gif', '16.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (40, 3, '17.gif', 23, '/big5/resources/app/pageicon/17.gif', '17.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (41, 3, '18.gif', 23, '/big5/resources/app/pageicon/18.gif', '18.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (42, 3, '19.gif', 23, '/big5/resources/app/pageicon/19.gif', '19.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (43, 3, '2.gif', 23, '/big5/resources/app/pageicon/2.gif', '2.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (44, 3, '20.gif', 23, '/big5/resources/app/pageicon/20.gif', '20.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (45, 3, '21.gif', 23, '/big5/resources/app/pageicon/21.gif', '21.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (46, 3, '22.gif', 23, '/big5/resources/app/pageicon/22.gif', '22.gif', '20050527220510', 1);
INSERT INTO `yw_cms_resource` VALUES (47, 3, '23.gif', 23, '/big5/resourc