-- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2008 年 09 月 17 日 02:30 -- 服务器版本: 5.0.27 -- PHP 版本: 5.1.6 -- -- 数据库: `sq_xh` -- -- -------------------------------------------------------- -- -- 表的结构 `business` -- CREATE TABLE `business` ( `id_business` int(50) NOT NULL auto_increment, `auther_business` varchar(50) NOT NULL COMMENT '作者\0s', `name_business` varchar(50) NOT NULL COMMENT '标题\0s', `subname_business` varchar(100) default NULL COMMENT '副标题\0e\0', `rank_business` int(11) NOT NULL default '1', `sort_business` varchar(100) NOT NULL, `item_business` varchar(50) NOT NULL, `short_business` varchar(100) NOT NULL COMMENT '简介\0s', `detail_business` varchar(500) NOT NULL COMMENT '详情\0s', `photo_business` varchar(50) NOT NULL, `click_business` int(11) NOT NULL default '0', `time_business` timestamp NOT NULL default CURRENT_TIMESTAMP, `uesr_business` int(11) default NULL COMMENT '发布者?e?', `contact_business` varchar(50) default NULL COMMENT '通讯员\0e\0', `editor_business` varchar(50) default NULL COMMENT '编辑者\0e\0', PRIMARY KEY (`id_business`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ; -- -- 导出表中的数据 `business` -- INSERT INTO `business` VALUES (34, 'luohao', 'www', 'ww', 4, '主类型', '3', 'wwwf''g', '1斯蒂芬斯蒂芬', '', 0, '2008-09-12 03:09:43', 1, '123', '321'); INSERT INTO `business` VALUES (35, 'f''s''d''f', 'sfdsf', 'asdfsd', 3, '行业新闻 ', '19', 'asdfsdf', 'www', 'a0a6fae1a8c5751877280ece5c9cbbad.jpg', 0, '2008-09-11 07:09:32', 1, '大法官 ', '地方 '); INSERT INTO `business` VALUES (36, '斯蒂芬 ', '123', '123', 3, '主类型', '23', '123123', 'www', 'a0a6fae1a8c5751877280ece5c9cbbad.jpg', 0, '2008-09-12 10:09:05', 1, '说的发送到 ', '速度 '); INSERT INTO `business` VALUES (37, 'qw', 'qw', 'qw', 2, '协会公告 ', '10', 'qwqw', 'www', '2382b2d88bfe5a8f2a26f638f009e3e0.jpg', 0, '2008-09-12 03:09:16', 1, '斯蒂芬', ' 沙地方 '); INSERT INTO `business` VALUES (38, '1', '123', '123', 3, '行业新闻 ', '22', '321', '123', 'a0a6fae1a8c5751877280ece5c9cbbad.jpg', 0, '2008-09-12 03:09:02', 1, '123', '321'); INSERT INTO `business` VALUES (39, '1', '说的发生地方 ', '斯蒂芬 ', 2, '行业新闻 ', '19', '阿四大幅s''d''f', '1斯蒂芬斯蒂芬', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-12 04:09:05', 1, '斯蒂芬阿四大幅', '沙地方s''d''f'); INSERT INTO `business` VALUES (41, '12', '12', '12', 2, '协会公告 ', '12', '1212', 'www', 'a0a6fae1a8c5751877280ece5c9cbbad.jpg', 0, '2008-09-12 04:09:19', 1, '速度f', 'f''sf''s''d发送到f''s''d''f'); INSERT INTO `business` VALUES (42, '231', '31', '2312', 1, '行业新闻 ', '22', '2312', '1212', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-12 04:09:42', 1, '2312', '31'); INSERT INTO `business` VALUES (43, '1231', '123', '123', 2, '行业新闻 ', '19', '23123', '123123', '84d9f4dc630784bec561e839af2bb5c5.jpg', 0, '2008-09-12 04:09:05', 1, '231', '123'); INSERT INTO `business` VALUES (44, '1111111111', '11111111', '111111111111', 2, '罗豪', '', '1111111', '111111111', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-16 05:09:30', NULL, '1', '111111111'); INSERT INTO `business` VALUES (45, '11', '1111', '1111111111111', 3, '会员风采', '37', '11111111111111', '11111111111', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-16 05:09:55', NULL, '1111111111111111111', '11111111111111111'); INSERT INTO `business` VALUES (46, '1', '11111111', '11111111111111', 3, '会员管理', '16', '1111111111', '11111111111', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-16 05:09:19', NULL, '12', '21'); INSERT INTO `business` VALUES (47, '123', '123', '123', 4, '协会管理', '8', '123', '123', '', 0, '2008-09-16 05:09:37', NULL, '123', '123'); INSERT INTO `business` VALUES (48, '321', '321', '321', 0, '协会简介', '', '321', '321', 'd7419661874e823d3223bc06981fbfb9.jpg', 0, '2008-09-16 05:09:45', NULL, '321', '321'); INSERT INTO `business` VALUES (49, 'qwe', 'qwe', 'qwe', 0, '协会管理', '8', 'qwe', 'qwe', '', 0, '2008-09-16 05:09:17', NULL, 'qwe', 'qwe'); INSERT INTO `business` VALUES (50, '1111', '11111111111', '1111111111111111111111111111111', 0, '协会风采', '34', '11111111111111111', '1111111111111111', '', 0, '2008-09-16 06:09:40', NULL, '111111111111111', '111111111111111111'); INSERT INTO `business` VALUES (51, '111111', '222', '22222222222222222', 0, '协会简介', '30', '2222222222222222', '222222222222222222', '84d9f4dc630784bec561e839af2bb5c5.jpg', 0, '2008-09-16 06:09:20', NULL, '22222222222222222222', '22222222222222222222'); INSERT INTO `business` VALUES (52, '222', '2222222', '222222222222', 0, '协会简介', '33', '2222222222222222222', '2222222222', '2382b2d88bfe5a8f2a26f638f009e3e0.jpg', 0, '2008-09-16 06:09:43', NULL, '2222222222222', '2222222222222222'); INSERT INTO `business` VALUES (53, '12', '12', '22222222', 0, '协会公告', '31', '12', '12', 'fc85af7389e66786f1437b2c9cb14cc0.jpg', 0, '2008-09-16 06:09:19', NULL, '12', '12'); INSERT INTO `business` VALUES (54, '123', '3213', '12312', 3, '协会风采', '34', '123', '123123', '75d1b29cfa1dd90237f64fd9ef1cb51d.jpg', 0, '2008-09-16 07:09:24', NULL, '123', '123'); INSERT INTO `business` VALUES (55, 'ww', 'ww', 'ww', 0, '协会动态', '39', 'ww', 'ww', '0e487e3fff41500712ca558512743e77.jpg', 0, '2008-09-16 07:09:28', NULL, 'ww', 'ww'); -- -------------------------------------------------------- -- -- 表的结构 `cases` -- CREATE TABLE `cases` ( `id_cases` int(50) NOT NULL auto_increment, `name_cases` varchar(50) NOT NULL, `company_cases` varchar(50) NOT NULL, `type_cases` int(5) NOT NULL, `rank_cases` int(5) NOT NULL, `link_cases` varchar(100) NOT NULL, `start_cases` date default NULL, `end_cases` date default NULL, `descrip_cases` text NOT NULL, `photo_cases` varchar(100) NOT NULL, PRIMARY KEY (`id_cases`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ; -- -- 导出表中的数据 `cases` -- INSERT INTO `cases` VALUES (1, '11', '中国石化', 3, 5, '11', '2008-08-22', '2008-08-02', '11', '4f26f67d5a56a4a3f7e61c51c66c67fd.jpg'); INSERT INTO `cases` VALUES (2, '22', '娃哈哈', 1, 5, '22', '2008-08-22', '2008-08-04', '22', 'b23eef44e0a6796f4ff83865d1c95d6f.jpg'); INSERT INTO `cases` VALUES (3, '11', '购联', 2, 5, '11', '2008-08-22', '2008-08-02', '11', 'd61681deec17043bacc7529b9abb3568.jpg'); INSERT INTO `cases` VALUES (13, 'erger', '天津重卡', 5, 5, 'erg', '1970-01-01', '1970-01-01', ' err', '4f26f67d5a56a4a3f7e61c51c66c67fd.jpg'); INSERT INTO `cases` VALUES (14, '认同和', '同仁堂', 5, 5, '', '1970-01-01', '1970-01-01', ' 他如火如荼和', '4c428dcdc5b232c21ced84a90f798586.jpg'); INSERT INTO `cases` VALUES (15, 'wer ', '中国移动', 3, 5, '', '2008-08-11', '2008-08-10', ' werwer
', '9ccffbf72df0f36ad45bfbf0dccd0686.jpg'); INSERT INTO `cases` VALUES (16, 'aaa', '请求权', 3, 2, 'aaaaa', '2008-07-28', '2008-07-28', ' aaaaaaaaaaaaaa', ''); INSERT INTO `cases` VALUES (17, '发给', '富贵花', 5, 5, '富贵花', '1970-01-01', '1970-01-01', ' 富贵花', '575e0854debf480cdbe72e46c1ed798e.gif'); INSERT INTO `cases` VALUES (18, 'gfhfgh', 'tfhft ', 3, 4, 'fghfgh', '2008-08-11', '2008-08-25', ' fghfghfghfgh', ''); INSERT INTO `cases` VALUES (19, '阿苏大', 'BMW', 2, 5, '阿苏大放速度', '2008-08-01', '2008-08-15', ' 对弹道弹道导弹
', '82b5806e4f0720774794f158b6c688ef.jpg'); INSERT INTO `cases` VALUES (20, '阿地方', '雪弗莱', 4, 5, '阿苏大', '2008-08-08', '2008-08-01', 's', '7e54f8b4fdcbfbd447b4328518f5f16f.jpg'); INSERT INTO `cases` VALUES (21, '阿苏大放', '堡世界', 2, 5, '三打法送颠覆', '2008-07-27', '2008-08-01', 'sadf', 'e4964226a88f4c80e393b4e989848be1.jpg'); -- -------------------------------------------------------- -- -- 表的结构 `download` -- CREATE TABLE `download` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ; -- -- 导出表中的数据 `download` -- INSERT INTO `download` VALUES (20, '111111111', 1, '

ghfghgfhfghfgh

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-08-25 06:08:21'); INSERT INTO `download` VALUES (78, '2312312', 1, '11111111111', '766d457dd2a2e05980d509d1c1406795.doc|39896108b4382d77d0e55a678c675433.xls|', 4, '2008-08-19 11:08:02'); INSERT INTO `download` VALUES (81, '12312', 1, '3123', '3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-19 10:08:29'); INSERT INTO `download` VALUES (86, '44422', 1, '44444', '3154506056c5fa056ed86f0965d40f31.htm|3154506056c5fa056ed86f0965d40f31.htm|', 45, '2008-08-19 04:08:49'); INSERT INTO `download` VALUES (87, '5121212', 1, '555555555555', '956f92ddc6f28ffb49090277e0b57cf7.txt|', 0, '2008-08-19 11:08:23'); INSERT INTO `download` VALUES (88, 'qqqqqqqqqq', 1, 'qqqqqqqqqqq', '651a1ceb67238f5f3bc2ad26b7962361.jpg|97c45a2ac34f14117321dcd1796bfefd.ini|3420d63b3e8d573c9abcfcdc6c521f91.db|', 5, '2008-08-19 04:08:58'); INSERT INTO `download` VALUES (91, '123123123', 1, '3123123', '956f92ddc6f28ffb49090277e0b57cf7.txt|5164bda67501e43db37ecaf3bc02863f.jpg|', 5, '2008-08-19 05:08:10'); INSERT INTO `download` VALUES (92, 'aaa', 1, 'aaa', '~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 09:08:54'); INSERT INTO `download` VALUES (93, 'bbb', 1, '

bbb

', '浩罗~3bbe031a2e119fe4c80817d2318ffa08.txt|罗浩 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-20 10:08:51'); INSERT INTO `download` VALUES (94, '得到的师傅是 ', 1, '玩儿让我而玩儿', '色法沃尔夫 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:40'); INSERT INTO `download` VALUES (96, '12312', 1, '3123123123', 'work.txt~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:59'); -- -------------------------------------------------------- -- -- 表的结构 `gongshi` -- CREATE TABLE `gongshi` ( `id` int(50) NOT NULL auto_increment, `auther` int(11) NOT NULL, `ip` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `subname` varchar(100) default NULL, `rank` int(11) NOT NULL default '1', `sort` varchar(100) default NULL, `item` varchar(50) default NULL, `short` varchar(100) default NULL, `detail` varchar(500) NOT NULL, `photo` varchar(50) default NULL, `click` int(11) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP, `del` enum('0','1') NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- 导出表中的数据 `gongshi` -- INSERT INTO `gongshi` VALUES (6, 1, '', '111', NULL, 2, '0', NULL, NULL, '111', NULL, 0, '2008-09-12 12:09:58', '1'); INSERT INTO `gongshi` VALUES (7, 1, '127.0.1.10', 'wer', NULL, 3, '1', NULL, NULL, ' we日 we
', NULL, 0, '2008-09-12 01:09:34', '1'); -- -------------------------------------------------------- -- -- 表的结构 `links` -- CREATE TABLE `links` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `url_news` varchar(100) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ; -- -- 导出表中的数据 `links` -- INSERT INTO `links` VALUES (78, '123', 1, '123', '40de7f7dc7a11c5673356a54f8baddec.jpg', 'hrt', 4, '2008-09-10 06:09:15'); INSERT INTO `links` VALUES (81, '12312', 1, '3123', '6a8b20f82d5b41cb1e36c2f6657ec431.jpg', '地地道道 ', 0, '2008-09-10 06:09:00'); INSERT INTO `links` VALUES (86, '44422', 1, '44444', '2382b2d88bfe5a8f2a26f638f009e3e0.jpg', '123123123123123', 45, '2008-09-10 06:09:05'); INSERT INTO `links` VALUES (96, '12312', 1, '3123123123', '123321~40de7f7dc7a11c5673356a54f8baddec.jpg|', 'Ext.BLANK_IMAGE_URL = ''js/ext/resources/images/default/s.gif'';', 5, '2008-09-10 02:09:11'); INSERT INTO `links` VALUES (97, '去weq', 1, ' 我俄', '2382b2d88bfe5a8f2a26f638f009e3e0.jpg', '去weqw ', 0, '2008-09-10 06:09:48'); -- -------------------------------------------------------- -- -- 表的结构 `mem_notice` -- CREATE TABLE `mem_notice` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ; -- -- 导出表中的数据 `mem_notice` -- INSERT INTO `mem_notice` VALUES (20, '111111111', 1, '

ghfghgfhfghfgh

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-08-25 06:08:21'); INSERT INTO `mem_notice` VALUES (78, '2312312', 1, '11111111111', '766d457dd2a2e05980d509d1c1406795.doc|39896108b4382d77d0e55a678c675433.xls|', 4, '2008-08-19 11:08:02'); INSERT INTO `mem_notice` VALUES (81, '12312', 1, '3123', '3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-19 10:08:29'); INSERT INTO `mem_notice` VALUES (86, '44422', 1, '44444', '3154506056c5fa056ed86f0965d40f31.htm|3154506056c5fa056ed86f0965d40f31.htm|', 45, '2008-08-19 04:08:49'); INSERT INTO `mem_notice` VALUES (87, '5121212', 1, '555555555555', '956f92ddc6f28ffb49090277e0b57cf7.txt|', 0, '2008-08-19 11:08:23'); INSERT INTO `mem_notice` VALUES (88, 'qqqqqqqqqq', 1, 'qqqqqqqqqqq', '651a1ceb67238f5f3bc2ad26b7962361.jpg|97c45a2ac34f14117321dcd1796bfefd.ini|3420d63b3e8d573c9abcfcdc6c521f91.db|', 5, '2008-08-19 04:08:58'); INSERT INTO `mem_notice` VALUES (91, '123123123', 1, '3123123', '956f92ddc6f28ffb49090277e0b57cf7.txt|5164bda67501e43db37ecaf3bc02863f.jpg|', 5, '2008-08-19 05:08:10'); INSERT INTO `mem_notice` VALUES (92, 'aaa', 1, 'aaa', '~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 09:08:54'); INSERT INTO `mem_notice` VALUES (93, 'bbb', 1, '

bbb

', '浩罗~3bbe031a2e119fe4c80817d2318ffa08.txt|罗浩 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-20 10:08:51'); INSERT INTO `mem_notice` VALUES (94, '得到的师傅是 ', 1, '玩儿让我而玩儿', '色法沃尔夫 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:40'); INSERT INTO `mem_notice` VALUES (96, '12312', 1, '3123123123', 'work.txt~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:59'); -- -------------------------------------------------------- -- -- 表的结构 `mem_photo` -- CREATE TABLE `mem_photo` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ; -- -- 导出表中的数据 `mem_photo` -- INSERT INTO `mem_photo` VALUES (20, '111111111', 1, '

ghfghgfhfghfgh

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-08-25 06:08:21'); INSERT INTO `mem_photo` VALUES (78, '2312312', 1, '11111111111', '766d457dd2a2e05980d509d1c1406795.doc|39896108b4382d77d0e55a678c675433.xls|', 4, '2008-08-19 11:08:02'); INSERT INTO `mem_photo` VALUES (81, '12312', 1, '3123', '3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-19 10:08:29'); INSERT INTO `mem_photo` VALUES (86, '44422', 1, '44444', '3154506056c5fa056ed86f0965d40f31.htm|3154506056c5fa056ed86f0965d40f31.htm|', 45, '2008-08-19 04:08:49'); INSERT INTO `mem_photo` VALUES (87, '5121212', 1, '555555555555', '956f92ddc6f28ffb49090277e0b57cf7.txt|', 0, '2008-08-19 11:08:23'); INSERT INTO `mem_photo` VALUES (88, 'qqqqqqqqqq', 1, 'qqqqqqqqqqq', '651a1ceb67238f5f3bc2ad26b7962361.jpg|97c45a2ac34f14117321dcd1796bfefd.ini|3420d63b3e8d573c9abcfcdc6c521f91.db|', 5, '2008-08-19 04:08:58'); INSERT INTO `mem_photo` VALUES (91, '123123123', 1, '3123123', '956f92ddc6f28ffb49090277e0b57cf7.txt|5164bda67501e43db37ecaf3bc02863f.jpg|', 5, '2008-08-19 05:08:10'); INSERT INTO `mem_photo` VALUES (92, 'aaa', 1, 'aaa', '~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 09:08:54'); INSERT INTO `mem_photo` VALUES (93, 'bbb', 1, '

bbb

', '浩罗~3bbe031a2e119fe4c80817d2318ffa08.txt|罗浩 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-20 10:08:51'); INSERT INTO `mem_photo` VALUES (94, '得到的师傅是 ', 1, '玩儿让我而玩儿', '色法沃尔夫 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:40'); INSERT INTO `mem_photo` VALUES (96, '12312', 1, '3123123123', 'work.txt~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:59'); -- -------------------------------------------------------- -- -- 表的结构 `mem_serv` -- CREATE TABLE `mem_serv` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ; -- -- 导出表中的数据 `mem_serv` -- INSERT INTO `mem_serv` VALUES (20, '111111111', 1, '

ghfghgfhfghfgh

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-08-25 06:08:21'); INSERT INTO `mem_serv` VALUES (78, '2312312', 1, '11111111111', '766d457dd2a2e05980d509d1c1406795.doc|39896108b4382d77d0e55a678c675433.xls|', 4, '2008-08-19 11:08:02'); INSERT INTO `mem_serv` VALUES (81, '12312', 1, '3123', '3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-19 10:08:29'); INSERT INTO `mem_serv` VALUES (86, '44422', 1, '44444', '3154506056c5fa056ed86f0965d40f31.htm|3154506056c5fa056ed86f0965d40f31.htm|', 45, '2008-08-19 04:08:49'); INSERT INTO `mem_serv` VALUES (87, '5121212', 1, '555555555555', '956f92ddc6f28ffb49090277e0b57cf7.txt|', 0, '2008-08-19 11:08:23'); INSERT INTO `mem_serv` VALUES (88, 'qqqqqqqqqq', 1, 'qqqqqqqqqqq', '651a1ceb67238f5f3bc2ad26b7962361.jpg|97c45a2ac34f14117321dcd1796bfefd.ini|3420d63b3e8d573c9abcfcdc6c521f91.db|', 5, '2008-08-19 04:08:58'); INSERT INTO `mem_serv` VALUES (91, '123123123', 1, '3123123', '956f92ddc6f28ffb49090277e0b57cf7.txt|5164bda67501e43db37ecaf3bc02863f.jpg|', 5, '2008-08-19 05:08:10'); INSERT INTO `mem_serv` VALUES (92, 'aaa', 1, 'aaa', '~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 09:08:54'); INSERT INTO `mem_serv` VALUES (93, 'bbb', 1, '

bbb

', '浩罗~3bbe031a2e119fe4c80817d2318ffa08.txt|罗浩 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-20 10:08:51'); INSERT INTO `mem_serv` VALUES (94, '得到的师傅是 ', 1, '玩儿让我而玩儿', '色法沃尔夫 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:40'); INSERT INTO `mem_serv` VALUES (96, '12312', 1, '3123123123', 'work.txt~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:59'); -- -------------------------------------------------------- -- -- 表的结构 `menu` -- CREATE TABLE `menu` ( `id_menuinfo` int(11) NOT NULL auto_increment, `code_menuinfo` varchar(255) NOT NULL, `name_menuinfo` varchar(255) NOT NULL, `url_menuinfo` varchar(255) NOT NULL, `icon_menuinfo` varchar(255) default NULL, `order_menuinfo` varchar(5) default NULL, PRIMARY KEY (`id_menuinfo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- 导出表中的数据 `menu` -- INSERT INTO `menu` VALUES (2, '2', '用户管理', 'index.php?controller=Admin_users&action=UsersPage', 'images/menu/user2.gif', '1'); INSERT INTO `menu` VALUES (3, '3', '新闻中心 ', 'index.php?controller=SystemSet&action=GoodsPage', 'images/menu/systemSet.gif', '2'); INSERT INTO `menu` VALUES (10, '4', '行业新闻 ', 'index.php?controller=news&action=index', 'images/menu/write.gif', '3'); INSERT INTO `menu` VALUES (12, '5', '协会通知 ', 'index.php?controller=Cases&action=index', 'images/menu/tongji.gif', '4'); INSERT INTO `menu` VALUES (13, '6', '业务介绍 ', 'index.php?controller=Business&action=index', 'images/menu/user3.gif', '5'); -- -------------------------------------------------------- -- -- 表的结构 `news` -- CREATE TABLE `news` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=99 ; -- -- 导出表中的数据 `news` -- INSERT INTO `news` VALUES (20, 'qq', 1, '

123124

sdgdfgdfg

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-09-09 05:09:29'); INSERT INTO `news` VALUES (78, 'dsf', 1, 'sdfg', '766d457dd2a2e05980d509d1c1406795.doc|39896108b4382d77d0e55a678c675433.xls|', 4, '2008-09-09 05:09:16'); INSERT INTO `news` VALUES (81, '12312', 1, '3123', '3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-19 10:08:29'); INSERT INTO `news` VALUES (86, '44422', 1, '44444', '3154506056c5fa056ed86f0965d40f31.htm|3154506056c5fa056ed86f0965d40f31.htm|', 45, '2008-08-19 04:08:49'); INSERT INTO `news` VALUES (87, '5121212', 1, '555555555555', '956f92ddc6f28ffb49090277e0b57cf7.txt|', 0, '2008-08-19 11:08:23'); INSERT INTO `news` VALUES (88, 'qqqqqqqqqq', 1, 'qqqqqqqqqqq', '651a1ceb67238f5f3bc2ad26b7962361.jpg|97c45a2ac34f14117321dcd1796bfefd.ini|3420d63b3e8d573c9abcfcdc6c521f91.db|', 5, '2008-08-19 04:08:58'); INSERT INTO `news` VALUES (91, '123123123', 1, '3123123', '956f92ddc6f28ffb49090277e0b57cf7.txt|5164bda67501e43db37ecaf3bc02863f.jpg|', 5, '2008-08-19 05:08:10'); INSERT INTO `news` VALUES (92, 'aaa', 1, 'aaa', '~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 09:08:54'); INSERT INTO `news` VALUES (93, 'bbb', 1, '

bbb

', '浩罗~3bbe031a2e119fe4c80817d2318ffa08.txt|罗浩 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 0, '2008-08-20 10:08:51'); INSERT INTO `news` VALUES (94, '得到的师傅是 ', 1, '玩儿让我而玩儿', '色法沃尔夫 ~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:40'); INSERT INTO `news` VALUES (96, '12312', 1, '3123123123', 'work.txt~3bbe031a2e119fe4c80817d2318ffa08.txt|', 5, '2008-08-20 10:08:59'); INSERT INTO `news` VALUES (97, '123', 1, ' 123', NULL, 0, '2008-09-09 04:09:19'); INSERT INTO `news` VALUES (98, 'gdfg', 1, ' dfgdfg', NULL, 0, '2008-09-09 04:09:53'); -- -------------------------------------------------------- -- -- 表的结构 `news_photo` -- CREATE TABLE `news_photo` ( `id_news` int(11) NOT NULL auto_increment, `name_news` varchar(50) NOT NULL, `author_news` int(11) NOT NULL, `content_news` text NOT NULL, `file_news` varchar(500) default NULL, `click_news` int(11) NOT NULL default '0', `time_news` datetime NOT NULL COMMENT ' ', PRIMARY KEY (`id_news`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ; -- -- 导出表中的数据 `news_photo` -- INSERT INTO `news_photo` VALUES (20, 'www', 1, '

www

', '4a7a9004c068615d2de5c30d0da635b5.jpg|', 7, '2008-09-09 05:09:29'); INSERT INTO `news_photo` VALUES (102, 'sadfsdf', 1, 'sdfsdaf', '7e54f8b4fdcbfbd447b4328518f5f16f.jpg~d7419661874e823d3223bc06981fbfb9.jpg|', 0, '2008-09-10 12:09:08'); -- -------------------------------------------------------- -- -- 表的结构 `t_menu_info` -- CREATE TABLE `t_menu_info` ( `id_menuinfo` int(11) NOT NULL auto_increment, `code_menuinfo` varchar(255) NOT NULL, `name_menuinfo` varchar(255) NOT NULL, `url_menuinfo` varchar(255) NOT NULL, `icon_menuinfo` varchar(255) default NULL, `order_menuinfo` varchar(5) default NULL, PRIMARY KEY (`id_menuinfo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ; -- -- 导出表中的数据 `t_menu_info` -- INSERT INTO `t_menu_info` VALUES (2, '1', '用户管理', 'admin.php?controller=Admin_users&action=UsersPage', 'images/menu/user2.gif', '1'); INSERT INTO `t_menu_info` VALUES (10, '2', '会员公示', 'admin.php?controller=gongshi', 'images/menu/write.gif', '2'); INSERT INTO `t_menu_info` VALUES (14, '5', '协会管理', 'admin.php?controller=xinwen&sort=3', 'images/menu/user3.gif', '5'); INSERT INTO `t_menu_info` VALUES (15, '6', '会员管理', 'admin.php?controller=xinwen&sort=4', 'images/menu/user3.gif', '6'); INSERT INTO `t_menu_info` VALUES (16, '7', '新闻中心', 'admin.php?controller=xinwen&sort=2', 'images/menu/user3.gif', '7'); INSERT INTO `t_menu_info` VALUES (17, '8', '照片', 'admin.php?controller=newsPhoto', 'images/menu/user3.gif', '8'); INSERT INTO `t_menu_info` VALUES (18, '9', '分类管理', '1', '', '9'); INSERT INTO `t_menu_info` VALUES (19, '4', '协会信息', '1', '', '4'); INSERT INTO `t_menu_info` VALUES (20, '41', '协会介绍', 'admin.php?controller=xinwen&sort=13', 'images/menu/tongji.gif', '1'); INSERT INTO `t_menu_info` VALUES (21, '42', '协会风采', 'admin.php?controller=xinwen&sort=10', 'images/menu/tongji.gif', '2'); INSERT INTO `t_menu_info` VALUES (22, '43', '协会动态', 'admin.php?controller=xinwen&sort=12', 'images/menu/tongji.gif', '3'); INSERT INTO `t_menu_info` VALUES (23, '3', '会员信息', '1', '', '3'); INSERT INTO `t_menu_info` VALUES (24, '31', '会员风采', 'admin.php?controller=xinwen', 'images/menu/tongji.gif', '1'); INSERT INTO `t_menu_info` VALUES (25, '32', '会员公示', 'admin.php?controller=xinwen', 'images/menu/tongji.gif', '2'); INSERT INTO `t_menu_info` VALUES (26, '33', '会员服务', 'admin.php?controller=xinwen', 'images/menu/tongji.gif', '3'); INSERT INTO `t_menu_info` VALUES (27, '91', '新闻分类', 'admin.php?controller=Admin_xinwenSort&sort=2', '', '1'); INSERT INTO `t_menu_info` VALUES (28, '92', '会员分类', 'admin.php?controller=Admin_xinwenSort&sort=4', '', '1'); INSERT INTO `t_menu_info` VALUES (29, '93', '协会分类', 'admin.php?controller=Admin_xinwenSort&sort=3', '', '1'); -- -------------------------------------------------------- -- -- 表的结构 `user` -- CREATE TABLE `user` ( `id_userinfo` int(11) NOT NULL auto_increment, `username_userinfo` varchar(20) default NULL, `userpass_userinfo` varchar(28) default NULL, `email_userinfo` varchar(100) default NULL, `userrealname_userinfo` varchar(10) default NULL, `type_userinfo` enum('1','2','3') NOT NULL default '3', `sexy_userinfo` tinyint(4) default '0', `birthday_userinfo` varchar(8) default NULL, `companytel_userinfo` varchar(25) default NULL, `companyfox_userinfo` varchar(25) default NULL, `homeaddress_userinfo` varchar(255) default NULL, `homepost_userinfo` varchar(8) default NULL, `hometel_userinfo` varchar(25) default NULL, `mobile_userinfo` varchar(25) default NULL, `qqcode_userinfo` varchar(25) default NULL, `msncode_userinfo` varchar(100) default NULL, `menu_codes_userinfo` varchar(255) default NULL, `departmentid_userinfo` int(11) default NULL, `usergroupid_userinfo` int(11) default NULL, PRIMARY KEY (`id_userinfo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; -- -- 导出表中的数据 `user` -- INSERT INTO `user` VALUES (1, 'admin', 'admin', 'luohao1211@yahoo.com', NULL, '3', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (2, '11122', '111', '12222@qq.com', '111', '2', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (6, 'lqqqww', '$1$gD2.pC..$1R57PoGGXryaiIIT', 'lu222ohao@qq.com', NULL, '1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (8, '121234', '$1$Pg..sG0.$Eqh0cKS50BnqWyyI', '11212@qq.com', NULL, '2', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (9, '121212', '$1$UT/.Ne/.$eQNzQLZpYhincwQi', '121212@qq.com', NULL, '1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (11, '7777', '$1$lW3.K44.$1K3eCAk9AbMvHmqV', 'luohao477@qq.com', NULL, '3', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (12, 'google', '$1$Dd2.QL4.$MIb0aATfVj.s6T8q', 'google@qq.com', NULL, '2', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (14, 'baidu', '$1$QN4.Zp2.$YnNJj6kRoYlGCqCX', 'baidu@qq.com', NULL, '3', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (15, '1', '$1$fg2.6i2.$ofJQKXUa4wX.hsO8', 'lu0hao@qq.com', NULL, '1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (16, '2', '$1$ul5.fk3.$krxfTvevsrczqt2t', '1111@yqhoo.com', NULL, '2', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (17, '3', '$1$6W..V62.$wFDvZfo2W5BYCN39', '333@qq.com', NULL, '2', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (18, '4', '$1$4N4.5./.$cixtzxhQQ6z52nrT', '4@qq.com', NULL, '1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (19, '4', '$1$9t5.c.3.$tLmOiojAVn56h1k8', '444@qq.com', NULL, '2', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `user` VALUES (20, '1', '$1$/3..aP..$KFecl6PGnEueyIS7', '1@qwqw.cn', NULL, '1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- 表的结构 `xinwen_sort` -- CREATE TABLE `xinwen_sort` ( `id_sort` int(11) NOT NULL auto_increment, `parent` int(11) NOT NULL default '1', `children` varchar(50) NOT NULL, PRIMARY KEY (`id_sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ; -- -- 导出表中的数据 `xinwen_sort` -- INSERT INTO `xinwen_sort` VALUES (1, 0, '主类型'); INSERT INTO `xinwen_sort` VALUES (2, 1, '新闻中心'); INSERT INTO `xinwen_sort` VALUES (3, 1, '协会管理'); INSERT INTO `xinwen_sort` VALUES (4, 1, '会员管理'); INSERT INTO `xinwen_sort` VALUES (5, 1, '专题报道'); INSERT INTO `xinwen_sort` VALUES (10, 3, '协会风采'); INSERT INTO `xinwen_sort` VALUES (12, 3, '协会动态'); INSERT INTO `xinwen_sort` VALUES (13, 3, '协会简介'); INSERT INTO `xinwen_sort` VALUES (14, 2, '重要新闻'); INSERT INTO `xinwen_sort` VALUES (15, 4, '会员风采'); INSERT INTO `xinwen_sort` VALUES (16, 4, '会员公示 '); INSERT INTO `xinwen_sort` VALUES (17, 4, '会员服务'); INSERT INTO `xinwen_sort` VALUES (19, 2, '图片新闻'); INSERT INTO `xinwen_sort` VALUES (22, 2, '协会公告'); INSERT INTO `xinwen_sort` VALUES (27, 23, '112233'); INSERT INTO `xinwen_sort` VALUES (28, 14, '445566'); INSERT INTO `xinwen_sort` VALUES (29, 14, '11.22'); INSERT INTO `xinwen_sort` VALUES (30, 13, '2211'); INSERT INTO `xinwen_sort` VALUES (31, 22, '123321'); INSERT INTO `xinwen_sort` VALUES (32, 19, '1111111'); INSERT INTO `xinwen_sort` VALUES (33, 13, '罗豪'); INSERT INTO `xinwen_sort` VALUES (34, 10, '号罗'); INSERT INTO `xinwen_sort` VALUES (35, 13, '肉可ie '); INSERT INTO `xinwen_sort` VALUES (36, 16, '123'); INSERT INTO `xinwen_sort` VALUES (37, 15, '321'); INSERT INTO `xinwen_sort` VALUES (38, 17, '213'); INSERT INTO `xinwen_sort` VALUES (39, 12, '总裁萨');