Jspxcms内容管理系统3.0.4

-- -- 转存表中的数据 `cms_ad` -- INSERT INTO `cms_ad` (`f_ad_id`, `f_site_id`, `f_adslot_id`, `f_name`, `f_begin_date`, `f_end_date`, `f_url`, `f_text`, `f_script`, `f_image`, `f_flash`, `f_seq`) VALUES (2, 1, 1, 'jspxcms演示广告', NULL, NULL, 'http://www.jspxcms.com', 'jspxcms演示广告', NULL, 'http://demo.jspxcms.com/uploads/1/image/public/201308/20130812090148_furree.jpg', NULL, 50); -- -- 转存表中的数据 `cms_ad_slot` -- INSERT INTO `cms_ad_slot` (`f_adslot_id`, `f_site_id`, `f_name`, `f_number`, `f_description`, `f_type`, `f_template`, `f_width`, `f_height`) VALUES (1, 1, '图片', 'picture', NULL, 2, '/sys_ad/ad_text.html', 700, 90); -- -- 转存表中的数据 `cms_attribute` -- INSERT INTO `cms_attribute` (`f_attribute_id`, `f_site_id`, `f_number`, `f_name`, `f_seq`, `f_is_with_image`, `f_image_width`, `f_image_height`) VALUES (1, 1, 'focus', '焦点', 0, '1', 424, 290), (2, 1, 'bignews', '头条', 1, '1', 50, 50), (3, 1, 'marquee', '滚动', 2, '1', 95, 70), (4, 1, 'recommend', '推荐', 3, '0', NULL, NULL); -- -- 转存表中的数据 `cms_comment` -- INSERT INTO `cms_comment` (`f_comment_id`, `f_site_id`, `f_creator_id`, `f_auditor_id`, `f_ftype`, `f_fid`, `f_creation_date`, `f_audit_date`, `f_score`, `f_status`, `f_text`, `f_ip`) VALUES (15, 1, 1, NULL, 'Info', 69, '2013-08-13 03:51:47', NULL, 0, 1, '只要人人献一片爱，世界将变成美好的人间！', '0:0:0:0:0:0:0:1'); -- -- 转存表中的数据 `cms_friendlink` -- INSERT INTO `cms_friendlink` (`f_friendlink_id`, `f_friendlinktype_id`, `f_site_id`, `f_name`, `f_url`, `f_seq`, `f_logo`, `f_is_with_logo`, `f_description`, `f_email`, `f_is_recommend`, `f_status`) VALUES (7, 1, 1, 'JSPXCMS官方', 'http://www.jspxcms.com', 2147483647, NULL, '0', NULL, NULL, '0', 0), (8, 3, 1, 'JAVA', 'http://www.java.com', 2147483647, NULL, '0', NULL, NULL, '0', 0), (9, 3, 1, 'TOMCAT', 'http://tomcat.apache.org', 2147483647, NULL, '0', NULL, NULL, '0', 0), (10, 3, 1, 'SPRINGSIDE', 'http://www.springside.org.cn', 2147483647, NULL, '0', NULL, NULL, '0', 0); -- -- 转存表中的数据 `cms_friendlink_type` -- INSERT INTO `cms_friendlink_type` (`f_friendlinktype_id`, `f_site_id`, `f_name`, `f_number`, `f_seq`) VALUES (1, 1, '综合类', 'zonghe', 0), (3, 1, '技术类', 'yule', 1); -- -- 转存表中的数据 `cms_global` -- INSERT INTO `cms_global` (`f_global_id`, `f_port`, `f_context_path`, `f_version`, `f_protocol`) VALUES (1, 8080, NULL, '3.0.3', 'http'); -- -- 转存表中的数据 `cms_global_custom` -- INSERT INTO `cms_global_custom` (`f_global_id`, `f_key`, `f_value`) VALUES (1, 'sys_flashAllowedExtensions', ''), (1, 'sys_videoAllowedExtensions', ''), (1, 'sys_videoDeniedExtensions', ''), (1, 'sys_imageAllowedExtensions', ''), (1, 'sys_linkDeniedExtensions', ''), (1, 'sys_imageDeniedExtensions', ''), (1, 'sys_linkAllowedExtensions', ''), (1, 'sys_flashDeniedExtensions', ''), (1, 'sys_mail_smtp_username', '89889'), (1, 'sys_mail_smtp_host', 'jkkjkj'), (1, 'sys_mail_smtp_auth', 'true'), (1, 'sys_mail_smtp_password', '556'), (1, 'sys_mail_from', 'fdfdfd'), (1, 'sys_mail_smtp_port', '77'), (1, 'register_mode', '1'), (1, 'register_passwordEmailText', '亲爱的${username}:\r\n 请复制以下链接到浏览器中打开，进入密码修改页面。\r\n ${url}\r\n\r\n${sitename}'), (1, 'register_maxLength', '20'), (1, 'register_minLength', '3'), (1, 'register_orgId', '1'), (1, 'register_validCharacter', '^[0-9a-zA-Z\\u4e00-\\u9fa5\\.\\-@_]+$'), (1, 'register_groupId', '1'), (1, 'register_passwordEmailSubject', '找回密码通知'), (1, 'register_verifyMode', '1'), (1, 'register_verifyEmailText', '亲爱的${username}:\r\n 请复制以下链接到浏览器中打开，以便激活您的帐号。\r\n ${url}\r\n\r\n${sitename}'), (1, 'register_userAgreement', '1、在本站注册的会员，必须遵守《互联网电子公告服务管理规定》，不得在本站发表诽谤他人，侵犯他人隐私，侵犯他人知识产权，传播病毒，政治言论，商业讯息等信息。\r\n2、在所有在本站发表的文章，本站都具有最终编辑权，并且保留用于印刷或向第三方发表的权利，如果你的资料不齐全，我们将有权不作任何通知使用你在本站发布的作品。\r\n3、在登记过程中，您将选择注册名和密码。注册名的选择应遵守法律法规及社会公德。您必须对您的密码保密，您将对您注册名和密码下发生的所有活动承担责任。'), (1, 'register_verifyEmailSubject', '帐号激活邮件'), (1, 'mail_smtpAuth', 'true'), (1, 'mail_smtpHost', 'smtp.163.com'), (1, 'mail_from', '15070042724@163.com'), (1, 'mail_smtpUsername', '15070042724@163.com'), (1, 'mail_smtpPassword', '1234567890a'); -- -- 转存表中的数据 `cms_guestbook` -- INSERT INTO `cms_guestbook` (`f_guestbook_id`, `f_site_id`, `f_guestbooktype_id`, `f_creator_id`, `f_replyer_id`, `f_title`, `f_text`, `f_creation_date`, `f_creation_ip`, `f_reply_text`, `f_reply_date`, `f_reply_ip`, `f_is_reply`, `f_is_recommend`, `f_status`, `f_username`, `f_gender`, `f_phone`, `f_mobile`, `f_qq`, `f_email`) VALUES (23, 1, 1, 1, 1, NULL, '终于等到jspxcms升级了，期待很久了。呵呵', '2013-08-12 08:54:43', '0:0:0:0:0:0:0:1', '非常感谢大家地长久以来的支持！', '2013-08-12 08:56:00', '0:0:0:0:0:0:0:1', '1', '0', 0, NULL, '1', NULL, NULL, NULL, NULL), (24, 1, 1, 7, NULL, NULL, '新版功能太强了，建站真的很方便', '2013-08-13 09:02:05', '0:0:0:0:0:0:0:1', NULL, NULL, NULL, '0', '0', 0, NULL, NULL, NULL, NULL, NULL, NULL); -- -- 转存表中的数据 `cms_guestbook_type` -- INSERT INTO `cms_guestbook_type` (`f_guestbooktype_id`, `f_site_id`, `f_name`, `f_number`, `f_description`, `f_seq`) VALUES (1, 1, '雁过留声', 'liusheng', '游客或会员留言', 0); -- -- 转存表中的数据 `cms_info` -- INSERT INTO `cms_info` (`f_info_id`, `f_creator_id`, `f_site_id`, `f_node_id`, `f_publish_date`, `f_priority`, `f_is_with_image`, `f_views`, `f_downloads`, `f_comments`, `f_status`, `f_p1`, `f_p2`, `f_p3`, `f_p4`, `f_p5`, `f_p6`, `f_org_id`, `f_score`, `f_diggs`) VALUES (24, 1, 1, 42, '2013-03-18 01:40:28', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (25, 1, 1, 42, '2013-03-18 01:43:00', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (26, 1, 1, 42, '2013-08-05 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (27, 1, 1, 39, '2013-03-18 01:46:31', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (28, 1, 1, 42, '2013-08-05 17:31:36', 0, '0', 40, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2), (30, 1, 1, 44, '2013-08-05 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (32, 1, 1, 44, '2013-08-05 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (33, 1, 1, 43, '2013-08-05 17:31:32', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (34, 1, 1, 43, '2013-08-05 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (35, 1, 1, 43, '2013-08-14 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (36, 1, 1, 43, '2013-08-06 17:31:32', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (37, 1, 1, 39, '2013-03-18 09:06:26', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (38, 1, 1, 39, '2013-03-18 09:07:16', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (39, 1, 1, 39, '2013-03-18 09:11:20', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (40, 1, 1, 45, '2013-03-18 13:09:08', 0, '0', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (43, 1, 1, 38, '2013-08-11 00:55:52', 0, '1', 0, 0, 0, 'A', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0), (44, 1, 1, 38, '2013