stu.sql

校园二手信息类网站管理系统

  PRIMARY KEY  (`siteid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=13 ;

INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (3, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/lovetrade/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 0);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (4, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/lovetrade/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 0);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (5, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/lovetrade/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 0);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (6, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/lovetrade/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 0);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (7, '爱尚网络', 'http://www.lovestu.com', '文字链接', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 1);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (8, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/stu/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 1);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (9, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/stu/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 1);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (10, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/stu/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 1);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (11, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/stu/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 1, 1);
INSERT INTO `stu_link` (`siteid`, `sitename`, `siteurl`, `sitelogo`, `siteowner`, `siteemail`, `sitemaosu`, `sitemode`, `sitelei`) VALUES (12, '爱尚网络', 'http://www.lovestu.com', 'http://127.0.0.1/lovetrade/images/logo.gif', '爱尚', '[e-mail]', '程序开发|网站架设|数据处理', 0, 0);

CREATE TABLE IF NOT EXISTS `stu_message` (
  `mid` int(10) unsigned NOT NULL auto_increment,
  `mname` varchar(255) NOT NULL,
  `msex` int(1) NOT NULL,
  `mnr` longtext NOT NULL,
  `mperson` varchar(20) NOT NULL,
  `mhead` varchar(255) NOT NULL,
  `mface` int(6) unsigned NOT NULL,
  `mtime` varchar(40) NOT NULL,
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `stu_msword` (
  `msid` int(12) unsigned NOT NULL auto_increment,
  `msname` varchar(40) NOT NULL,
  `mssex` int(1) unsigned default NULL,
  `mshead` varchar(255) NOT NULL,
  `msface` int(4) NOT NULL,
  `mstext` longtext NOT NULL,
  `msshop` int(12) NOT NULL,
  `msowner` varchar(50) NOT NULL,