drop table if exists attachment;
CREATE TABLE `attachment` (
  `id` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL,
  `attach` varchar(1000) collate utf8_unicode_ci NOT NULL,
  `uploadtime` datetime NOT NULL,
  `filetype` varchar(50) collate utf8_unicode_ci NOT NULL,
  `filesize` varchar(100) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
insert into attachment value (87,70,'/userfiles/fujian/bb6b40d353d23fe557dec4f9ce4f24ad.jpg','2011-02-26 16:28:02','image/pjpeg','441745');

insert into attachment value (99,79,'/userfiles/fujian/cfb7608abc6b230e2a73cc9b579c5076.jpg','2011-02-27 13:38:02','image/pjpeg','514403');

insert into attachment value (55,34,'/userfiles/fujian/f44c646a669e60955e936264e89e8d30.jpg','2011-02-26 11:38:30','image/pjpeg','677391');

insert into attachment value (54,33,'/userfiles/fujian/a5074577e82c4034bd21fc393214d365.jpg','2011-02-26 11:38:23','image/pjpeg','441745');

insert into attachment value (53,32,'/userfiles/fujian/da04f4c6257dbbe7c1e42bddccacef7d.jpg','2011-02-26 11:38:14','image/pjpeg','574724');

insert into attachment value (50,29,'/userfiles/fujian/10e8c0b6c14e8c563fbf702087f498ba.jpg','2011-02-26 11:37:36','image/pjpeg','441745');

insert into attachment value (49,28,'/userfiles/fujian/7e7e15092ffd07a9a6dfcd63173879a6.jpg','2011-02-26 11:37:25','image/pjpeg','441745');

insert into attachment value (48,27,'/userfiles/fujian/52af4726468a90cd90396d91459d8ecc.jpg','2011-02-26 11:37:16','image/pjpeg','677391');

insert into attachment value (47,26,'/userfiles/fujian/438da8d9b497336c1ce1868eada5645b.jpg','2011-02-26 11:37:04','image/pjpeg','370308');

insert into attachment value (46,25,'/userfiles/fujian/23c3a9e4d91baccbbf05f0232251fbf0.jpg','2011-02-26 11:36:43','image/pjpeg','574724');

insert into attachment value (44,21,'/userfiles/fujian/82cd5f47d4568eba86d04e86ce175d7b.jpg','2011-02-26 11:29:36','image/pjpeg','677391');

insert into attachment value (45,22,'/userfiles/fujian/3229ab90df6af96751f2aa3a18472ab9.jpg','2011-02-26 11:29:46','image/pjpeg','370308');

insert into attachment value (97,78,'/userfiles/fujian/cfd1cb25d51e361acc8afa1bfa2184dd.jpg','2011-02-27 10:25:09','text/plain','3938');

insert into attachment value (100,79,'/userfiles/fujian/fb8ac73f621ca44e3d56fd3e5b1912b1.jpg','2011-02-27 13:38:02','image/pjpeg','574724');

insert into attachment value (131,97,'/userfiles/fujian/9b00625ccece3d8f6ba9ba99b211d06b.jpg','2011-03-16 15:51:12','image/pjpeg','78104');

insert into attachment value (67,67,'/userfiles/fujian/89ab7809b6c532a53bacc4985f403dec.jpg','2011-02-26 15:11:07','image/pjpeg','380867');

insert into attachment value (68,68,'/userfiles/fujian/e8aee46868da98286b3267e30ccb68ce.jpg','2011-02-26 15:11:17','image/pjpeg','441745');

insert into attachment value (77,39,'/userfiles/fujian/942e1b232a1e19869de8aa9d59ad5734.jpg','2011-02-26 15:18:47','image/pjpeg','514403');

insert into attachment value (94,75,'/userfiles/fujian/0a7bcdfab7c5b393b97032fd47015f67.jpg','2011-02-27 10:16:43','text/plain','3938');

insert into attachment value (102,81,'/userfiles/fujian/744aa733e767f16856df64493e5cb872.jpg','2011-02-28 16:12:51','image/pjpeg','163863');

insert into attachment value (130,96,'/userfiles/fujian/3584edc4a0762d32b88958f7e728d952.jpg','2011-03-16 15:50:53','image/pjpeg','78104');

insert into attachment value (128,94,'/userfiles/fujian/b5857fe459dbb27af1c0b49494581ca9.jpg','2011-03-16 15:50:04','image/pjpeg','78104');

insert into attachment value (129,95,'/userfiles/fujian/654151cea788037815a2a4d7697fdbc1.jpg','2011-03-16 15:50:37','image/pjpeg','78104');

insert into attachment value (127,94,'/userfiles/fujian/a54c7398274f6439418c3676a75a9823.jpg','2011-03-16 15:50:04','image/pjpeg','78104');

insert into attachment value (132,98,'/userfiles/fujian/af9342991ec4143ef6e29ec0736b2076.jpg','2011-03-16 16:22:14','image/pjpeg','78104');

insert into attachment value (133,99,'/userfiles/fujian/3752075b3d8059975745968511ebbe67.jpg','2011-03-16 16:22:35','image/pjpeg','78104');

insert into attachment value (113,0,'/userfiles/fujian/3d37f30867a630e1f27111bc43675fb8.jpg','2011-03-16 13:59:11','image/pjpeg','6733');

insert into attachment value (114,0,'/userfiles/fujian/137186ed31c7ea166d2088ac1a13cff8.jpg','2011-03-16 13:59:11','image/pjpeg','905');

insert into attachment value (115,0,'/userfiles/fujian/515e1cfee473211aa702b95eb86ffbb7.jpg','2011-03-16 13:59:35','image/pjpeg','1912');

insert into attachment value (116,0,'/userfiles/fujian/56e8a6042a2db978a18fad62e46c6265.jpg','2011-03-16 13:59:35','image/pjpeg','4729');

insert into attachment value (118,0,'/userfiles/fujian/dc0a01db3a1970fda290c4271e809185.jpg','2011-03-16 14:01:51','image/pjpeg','357');

insert into attachment value (119,91,'/userfiles/fujian/62547e25c511e6cbe122d4d4b8a195af.jpg','2011-03-16 14:02:07','image/pjpeg','357');

insert into attachment value (149,100,'/userfiles/fujian/261f1e55ce78156df4d7204819d26198.jpg','2011-03-19 11:26:29','image/pjpeg','541639');

insert into attachment value (148,100,'/userfiles/fujian/c94e75d6e5278c85f2e9c975307b393e.jpg','2011-03-19 11:26:29','image/pjpeg','370308');

insert into attachment value (135,101,'/userfiles/fujian/ee1efe84c98d56cb3c7f43bf20061514.jpg','2011-03-18 16:20:41','image/pjpeg','541639');

insert into attachment value (147,100,'/userfiles/fujian/8b362739df48684e0511cff9c5de3616.jpg','2011-03-19 11:26:29','image/pjpeg','441745');

insert into attachment value (146,100,'/userfiles/fujian/d314cc2a36c53c80590acdf58da6c394.jpg','2011-03-19 11:26:29','image/pjpeg','452445');

insert into attachment value (150,100,'/userfiles/fujian/4458f2cdd8d9ac9c630b1787d4d9c1fd.jpg','2011-03-19 11:26:29','image/pjpeg','574724');

drop table if exists comment;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL,
  `content` varchar(300) collate utf8_unicode_ci NOT NULL,
  `time` time NOT NULL,
  `ip` varchar(40) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
drop table if exists feedback;
CREATE TABLE `feedback` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(40) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `time` varchar(200) NOT NULL,
  `feedback` varchar(2000) NOT NULL,
  `reply` varchar(2000) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=158 DEFAULT CHARSET=utf8;
insert into feedback value (148,'admin','127.0.0.1','1299979419','也支持Firefox了，真不错的呢','我们推出了支持各种浏览器的产品，谢谢您的关注。');

insert into feedback value (152,'lth','127.0.0.1','1300008307','ajax利用xmlhttpRequest函数实现了同步和异步无需刷新的功能。此功能给用户一个更好的体验效果。','是的，您说的很对。');

insert into feedback value (151,'游客11','127.0.0.1','1300005990','真的非常好用啊，我喜欢这个留言板，站长同志能不能给我这个的源代码啊。','谢谢您的支持,我们会继续努力的。打造最好的，最安全的网络产品，请继续关注。');

insert into feedback value (155,'lth','127.0.0.1','1300070853','hell,everyone,fine,thank you.oh yeah.','thank,you!!!');

insert into feedback value (156,'tgr','127.0.0.1','1300257328','hello,everyone','');

insert into feedback value (157,'lth','127.0.0.1','1300257372','my name is liutonghu','');

drop table if exists nclass;
CREATE TABLE `nclass` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
insert into nclass value (2,'公司新闻');

insert into nclass value (3,'行业新闻');

insert into nclass value (4,'公司大事记');

drop table if exists news;
CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `time` datetime NOT NULL,
  `ip` varchar(50) collate utf8_unicode_ci NOT NULL,
  `content` text collate utf8_unicode_ci NOT NULL,
  `iscomment` tinyint(1) NOT NULL,
  `bigclassid` int(11) NOT NULL,
  `editor` varchar(50) collate utf8_unicode_ci NOT NULL,
  `title` varchar(60) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
insert into news value (9,'0000-00-00 00:00:00','','<p>phpweb企业管理系统基于php+mysql+smarty+ajax技术,使用更加方便，用户体验更加良好。本系统包括产品管理系统，文章管理系统，附件管理系统，以及数据库的管理及维护，ajax留言系统，界面简洁大方，后台操作更加方便。对多项操作有特别好的支持，无论是多项删除以及多项分类。数据库管理更加简便，修复表，备份和还原表，采用分卷备份及还原更好的提高了速度。</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功');

insert into news value (10,'2011-03-15 15:14:48','','<p>热烈庆祝phpweb管理系统正式测试成功</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功1');

insert into news value (11,'2011-03-15 15:14:57','','<p>热烈庆祝phpweb管理系统正式测试成功</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功2');

insert into news value (12,'2011-03-15 15:15:07','','<p>热烈庆祝phpweb管理系统正式测试成功</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功3');

insert into news value (13,'2011-03-15 15:15:16','','<p>热烈庆祝phpweb管理系统正式测试成功</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功5');

insert into news value (14,'2011-03-15 15:15:25','','<p>热烈庆祝phpweb管理系统正式测试成功</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功6');

insert into news value (15,'2011-03-16 11:01:58','','<p>热烈庆祝phpweb管理系统正式测试成功6</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功7');

insert into news value (16,'2011-03-16 11:02:08','','<p>热烈庆祝phpweb管理系统正式测试成功6</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功8');

insert into news value (17,'2011-03-16 11:02:18','','<p>热烈庆祝phpweb管理系统正式测试成功6</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功9');

insert into news value (18,'2011-03-16 11:02:27','','<p>热烈庆祝phpweb管理系统正式测试成功10</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功10');

insert into news value (19,'2011-03-16 11:02:40','','<p>热烈庆祝phpweb管理系统正式测试成功11</p>',1,2,'管理员','热烈庆祝phpweb管理系统正式测试成功11');

insert into news value (20,'2011-03-16 11:34:56','','<p><strong>盐，在</strong><a href=\"http://baike.baidu.com/view/2507.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">化学</font></strong></a><strong>中，是指一类</strong><a href=\"http://baike.baidu.com/view/6314.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">金属</font></strong></a><a href=\"http://baike.baidu.com/view/63017.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">离子</font></strong></a><strong>或</strong><a href=\"http://baike.baidu.com/view/1882354.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">铵根离子</font></strong></a><strong>（NH4+）与</strong><a href=\"http://baike.baidu.com/view/781797.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">酸根离子</font></strong></a><strong>或非金属离子结合的</strong><a href=\"http://baike.baidu.com/view/63037.htm\" target=\"_blank\"><strong><font color=\"#136ec2\">化合物</font></strong></a>。如NaCl（食盐氯化钠），Ca(NO3)2（硝酸钙），FeSO4（硫酸亚铁）和CH3COONH4（乙酸铵）等</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　&ldquo;盐&rdquo;又多为&ldquo;食用盐</p>\r\n<div class=\"text_pic\" sizset=\"1\" sizcache=\"1\" style=\"position: relative; padding-bottom: 3px; width: 150px; float: right; visibility: visible\"><a class=\" pic-handle\" title=\"查看图片\" href=\"http://baike.baidu.com/image/3853ad1b6f07ee508618bf85\" target=\"_blank\">&nbsp;&nbsp;</a><a href=\"http://baike.baidu.com/image/3853ad1b6f07ee508618bf85\" target=\"_blank\" sizset=\"1\" sizcache=\"1\"><img class=\"editorImg nslog:1232\" title=\"盐\" src=\"http://imgsrc.baidu.com/baike/abpic/item/3853ad1b6f07ee508618bf85.jpg\" alt=\"\" /></a>\r\n<p class=\"pic-info\">盐<wbr></wbr></p>\r\n</div>\r\n<p>&rdquo;的简称、俗语；而实际的更宽泛，盐较食用盐意义更广博：，如<a href=\"http://baike.baidu.com/view/149219.htm\" target=\"_blank\"><font color=\"#136ec2\">硫酸钙</font></a>，<a href=\"http://baike.baidu.com/view/168809.htm\" target=\"_blank\"><font color=\"#136ec2\">氯化铜</font></a>，<a href=\"http://baike.baidu.com/view/180906.htm\" target=\"_blank\"><font color=\"#136ec2\">醋酸钠</font></a>，一般来说盐是<a href=\"http://baike.baidu.com/view/62469.htm\" target=\"_blank\"><font color=\"#136ec2\">复分解反应</font></a>的生成物，如<a href=\"http://baike.baidu.com/view/1730.htm\" target=\"_blank\"><font color=\"#136ec2\">硫酸</font></a>与<a href=\"http://baike.baidu.com/view/1731.htm\" target=\"_blank\"><font color=\"#136ec2\">氢氧化钠</font></a>生成<a href=\"http://baike.baidu.com/view/149299.htm\" target=\"_blank\"><font color=\"#136ec2\">硫酸钠</font></a>和<a href=\"http://baike.baidu.com/view/2630.htm\" target=\"_blank\"><font color=\"#136ec2\">水</font></a>，也有其他的反应可生成盐，例如<a href=\"http://baike.baidu.com/view/15483.htm\" target=\"_blank\"><font color=\"#136ec2\">置换反应</font></a>。 盐分为单盐和合盐，单盐分为<a href=\"http://baike.baidu.com/view/154808.htm\" target=\"_blank\"><font color=\"#136ec2\">正盐</font></a>、<a href=\"http://baike.baidu.com/view/154804.htm\" target=\"_blank\"><font color=\"#136ec2\">酸式盐</font></a>、<a href=\"http://baike.baidu.com/view/154796.htm\" target=\"_blank\"><font color=\"#136ec2\">碱式盐</font></a>，合盐分为<a href=\"http://baike.baidu.com/view/182856.htm\" target=\"_blank\"><font color=\"#136ec2\">复盐</font></a>和络盐。其中酸式盐除含有金属离子与酸根离子外还含有<a href=\"http://baike.baidu.com/view/2515542.htm\" target=\"_blank\"><font color=\"#136ec2\">氢离子</font></a>，碱式盐除含有金属离子与酸根离子外还含有<a href=\"http://baike.baidu.com/view/353463.htm\" target=\"_blank\"><font color=\"#136ec2\">氢氧根</font></a>离子，复盐溶于水时，可生成与原盐相同离子的合盐；了，络盐溶于水时，可生成与原盐不相同的复杂离子的合盐－<a href=\"http://baike.baidu.com/view/42694.htm\" target=\"_blank\"><font color=\"#136ec2\">络合物</font></a>。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　强碱弱酸盐是<a href=\"http://baike.baidu.com/view/507270.htm\" target=\"_blank\"><font color=\"#136ec2\">强碱</font></a>和<a href=\"http://baike.baidu.com/view/598803.htm\" target=\"_blank\"><font color=\"#136ec2\">弱酸</font></a>反应的盐，溶于水显碱性，如<a href=\"http://baike.baidu.com/view/121539.htm\" target=\"_blank\"><font color=\"#136ec2\">碳酸钠</font></a>。而强酸弱碱盐是<a href=\"http://baike.baidu.com/view/593385.htm\" target=\"_blank\"><font color=\"#136ec2\">强酸</font></a>和<a href=\"http://baike.baidu.com/view/1118699.htm\" target=\"_blank\"><font color=\"#136ec2\">弱碱</font></a>反应的盐，溶于水显酸性，如<a href=\"http://baike.baidu.com/view/149521.htm\" target=\"_blank\"><font color=\"#136ec2\">氯化铁</font></a>。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　可溶盐的<a href=\"http://baike.baidu.com/view/57905.htm\" target=\"_blank\"><font color=\"#136ec2\">溶液</font></a>有导电性，是因为溶液中有可自由游动的离子，故此可作为<a href=\"http://baike.baidu.com/view/154.htm\" target=\"_blank\"><font color=\"#136ec2\">电解质</font></a>。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　人们生活中常说的盐指<a href=\"http://baike.baidu.com/view/7349.htm\" target=\"_blank\"><font color=\"#136ec2\">食盐</font></a>，主要成分是<a href=\"http://baike.baidu.com/view/1728.htm\" target=\"_blank\"><font color=\"#136ec2\">氯化钠</font></a>、<a href=\"http://baike.baidu.com/view/313080.htm\" target=\"_blank\"><font color=\"#136ec2\">碘酸钾</font></a>。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　盐</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　拼音:y&aacute;n</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　【名词】</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　同本义〖salt〗</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　若作和羹,尔惟<a href=\"http://baike.baidu.com/view/685103.htm\" target=\"_blank\"><font color=\"#136ec2\">盐梅</font></a>。&mdash;&mdash;《书&middot;说命下》</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　鲁盐漆丝。&mdash;&mdash;《史记&middot;<a href=\"http://baike.baidu.com/view/1010958.htm\" target=\"_blank\"><font color=\"#136ec2\">货殖列传</font></a>》</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　又如:<a href=\"http://baike.baidu.com/view/2983097.htm\" target=\"_blank\"><font color=\"#136ec2\">盐酱口</font></a>(说不吉利的话,且得到应验);盐枭(私贩食盐的人);盐斤(<a href=\"http://baike.baidu.com/view/553902.htm\" target=\"_blank\"><font color=\"#136ec2\">宋代</font></a>官盐以百斤、千斤为计算单位,故称&ldquo;盐&rdquo;为&ldquo;盐斤&rdquo;);盐捕分府(知府下面专管盐务的<a href=\"http://baike.baidu.com/view/58095.htm\" target=\"_blank\"><font color=\"#136ec2\">同知</font></a>);<a href=\"http://baike.baidu.com/view/189261.htm\" target=\"_blank\"><font color=\"#136ec2\">盐钞</font></a>法(宋代实行的商人凭盐钞运销食盐的法规,即食盐专卖法);<a href=\"http://baike.baidu.com/view/3890118.htm\" target=\"_blank\"><font color=\"#136ec2\">盐呆子</font></a>(蔑称盐商);盐官(今<a href=\"http://baike.baidu.com/view/34562.htm\" target=\"_blank\"><font color=\"#136ec2\">浙江海宁</font></a>);盐院(盐政衙门。盐政是管理地区盐务的官员,清代由省的总督或巡抚兼任);盐丁(在<a href=\"http://baike.baidu.com/view/837356.htm\" target=\"_blank\"><font color=\"#136ec2\">盐田</font></a>工作的人);<a href=\"http://baike.baidu.com/view/189259.htm\" target=\"_blank\"><font color=\"#136ec2\">盐引</font></a>(政府授予商人运销官盐的凭证);<a href=\"http://baike.baidu.com/view/904856.htm\" target=\"_blank\"><font color=\"#136ec2\">盐车</font></a>(运盐的车) 。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　由<a href=\"http://baike.baidu.com/view/1927454.htm\" target=\"_blank\"><font color=\"#136ec2\">金属离子</font></a>(或铵根离子NH4+)和<a href=\"http://baike.baidu.com/view/548797.htm\" target=\"_blank\"><font color=\"#136ec2\">酸根</font></a>离子组成的化合物〖sali-;lalin-;salini-;salino-〗。</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　含有氢离子的盐叫酸式盐,如:<a href=\"http://baike.baidu.com/view/117884.htm\" target=\"_blank\"><font color=\"#136ec2\">碳酸氢铵</font></a>(NH4HCO3);<a href=\"http://baike.baidu.com/view/162806.htm\" target=\"_blank\"><font color=\"#136ec2\">硫酸氢钠</font></a>(NaHSO4);磷酸二氢钾(KH2PO4)</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　含有氢氧根离子的盐叫碱式盐,如:<a href=\"http://baike.baidu.com/view/55159.htm\" target=\"_blank\"><font color=\"#136ec2\">碱式碳酸铜</font></a>(Cu2〖OH〗2CO3)</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　不含氢氧根离子和氢离子的盐叫正盐,如:氯化钠(NaCl);碳酸钠(Na2CO3)。此外还有复盐(如明矾)等</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　<a href=\"http://baike.baidu.com/view/29387.htm\" target=\"_blank\"><font color=\"#136ec2\">盐巴</font></a></p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nbā</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖commonsalt〗[方言]∶食盐</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　盐槽，盐坑</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;ncāo,y&aacute;nkēng</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖saltpit〗一种容纳并蒸发<a href=\"http://baike.baidu.com/view/108288.htm\" target=\"_blank\"><font color=\"#136ec2\">海水</font></a>的槽或坑</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　盐场</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nchǎng</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖saltern;saltworks;saltfield〗出产盐或配销盐的场所</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　<a href=\"http://baike.baidu.com/view/809191.htm\" target=\"_blank\"><font color=\"#136ec2\">盐池</font></a></p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nch&iacute;</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖saltpond〗生产食盐的<a href=\"http://baike.baidu.com/view/111486.htm\" target=\"_blank\"><font color=\"#136ec2\">咸水湖</font></a></p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　盐分</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nf&egrave;n</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖saltcontentinsidethebodies〗物体内所含的盐量</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　<a href=\"http://baike.baidu.com/view/43934.htm\" target=\"_blank\"><font color=\"#136ec2\">盐肤木</font></a></p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nfūm&ugrave;</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖sumac〗漆树属(Rhus)的一种<a href=\"http://baike.baidu.com/view/84139.htm\" target=\"_blank\"><font color=\"#136ec2\">灌木</font></a>或乔木&mdash;&mdash;通常是此属的无毒的种类</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　<a href=\"http://baike.baidu.com/view/67900.htm\" target=\"_blank\"><font color=\"#136ec2\">盐湖</font></a></p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nh&uacute;</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖saltlake〗无<a href=\"http://baike.baidu.com/view/766578.htm\" target=\"_blank\"><font color=\"#136ec2\">通海</font></a>出口的内陆咸水水体</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　盐花</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　y&aacute;nhuā</p>\r\n<div class=\"spctrl\">&nbsp;</div>\r\n<p>　　〖alittlesalt〗∶极少量的盐</p>',1,3,'管理员','热烈庆祝PHPweb管理系统测试成功');

drop table if exists pclass;
CREATE TABLE `pclass` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
insert into pclass value (72,'php学校管理系统');

insert into pclass value (73,'php商城系统');

insert into pclass value (70,'php企业管理系统');

insert into pclass value (71,'php医院管理系统');

drop table if exists product;
CREATE TABLE `product` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) collate utf8_unicode_ci NOT NULL,
  `time` datetime NOT NULL,
  `bigclassid` int(11) NOT NULL,
  `content` text collate utf8_unicode_ci NOT NULL,
  `iscomment` tinyint(1) NOT NULL,
  `editor` varchar(50) collate utf8_unicode_ci NOT NULL,
  `attach` varchar(2000) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
insert into product value (94,'php管理系统','2011-03-16 15:50:04',72,'<p>php管理系统</p>',1,'管理员','0,127,128');

insert into product value (95,'php企业管理系统','2011-03-16 15:50:37',70,'<p>php企业管理系统</p>',1,'管理员','0,129');

insert into product value (96,'php商城系统','2011-03-16 15:50:53',73,'<p>php商城系统</p>',1,'管理员','0,130');

insert into product value (97,'php医院管理系统','2011-03-16 15:51:12',71,'<p>php医院管理系统</p>',1,'管理员','0,131');

insert into product value (98,'php系统','2011-03-16 16:22:14',73,'<p>php系统</p>',1,'管理员','0,132');

insert into product value (99,'php系统23','2011-03-16 16:22:35',72,'<p>的十七大的撒</p>',1,'管理员','0,133');

insert into product value (100,'php系统123','2011-03-19 11:26:29',72,'<p>php系统</p>',1,'管理员','0,146,147,148,149,150');

insert into product value (101,'管理系统2','2011-03-18 16:20:41',72,'<p>撒打撒打死安德森打算师大</p>',1,'管理员','0,135');

drop table if exists userinfo;
CREATE TABLE `userinfo` (
  `id` int(11) NOT NULL auto_increment,
  `username` char(20) collate utf8_unicode_ci NOT NULL,
  `password` varchar(40) collate utf8_unicode_ci NOT NULL,
  `logintime` datetime NOT NULL,
  `loginip` varchar(40) collate utf8_unicode_ci NOT NULL,
  `logincount` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
insert into userinfo value (1,'admin','21232f297a57a5a743894a0e4a801fc3','2011-03-19 13:19:47','127.0.0.1',129);

