stu.sql

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

CREATE TABLE IF NOT EXISTS `stu_newslei` (
  `leiid` int(10) unsigned NOT NULL auto_increment,
  `leiname` varchar(20) NOT NULL,
  `leisx` int(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`leiid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=19 ;

INSERT INTO `stu_newslei` (`leiid`, `leiname`, `leisx`) VALUES (15, '娱乐八卦', 2);
INSERT INTO `stu_newslei` (`leiid`, `leiname`, `leisx`) VALUES (16, '地方新闻', 3);
INSERT INTO `stu_newslei` (`leiid`, `leiname`, `leisx`) VALUES (14, '校园新闻', 1);
INSERT INTO `stu_newslei` (`leiid`, `leiname`, `leisx`) VALUES (17, '产品信息', 4);
INSERT INTO `stu_newslei` (`leiid`, `leiname`, `leisx`) VALUES (18, '公司动态', 5);

CREATE TABLE IF NOT EXISTS `stu_school` (
  `schoolid` int(11) unsigned NOT NULL auto_increment,
  `schoolname` varchar(255) NOT NULL,
  `schoolpm` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`schoolid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=17 ;

INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (6, '重庆理工大学', 11);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (3, '重庆工商大学', 13);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (4, '四川外语学院', 15);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (5, '重庆科技大学', 17);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (7, '重庆地质大学', 10);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (8, '西南大学', 9);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (9, '重庆三峡学院', 18);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (10, '重庆大学', 7);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (11, '重庆工学院', 20);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (12, '重庆教育学院', 33);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (13, '重庆邮电大学', 13);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (14, '四川美术学院', 14);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (15, '重庆交通大学', 66);
INSERT INTO `stu_school` (`schoolid`, `schoolname`, `schoolpm`) VALUES (16, '西南政法大学', 15);