stu.sql

LOVESTUdio多校园交易系统 VER 4.0基于3.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=2 ;



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,
  `mstime` varchar(50) NOT NULL,
  PRIMARY KEY  (`msid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=11 ;



INSERT INTO `stu_msword` (`msid`, `msname`, `mssex`, `mshead`, `msface`, `mstext`, `msshop`, `msowner`, `mstime`) VALUES (2, '涓?槸鐨勭殑', 1, '8.gif', 16, '鏁㈡?闃熸硶涓', 6, 'vistor', '2007骞');
INSERT INTO `stu_msword` (`msid`, `msname`, `mssex`, `mshead`, `msface`, `mstext`, `msshop`, `msowner`, `mstime`) VALUES (3, 'zzzzzz', 0, 'img4.gif', 14, '鏁㈡?闃熸硶涓婄數椋庢墖鍦版柟', 6, 'zzzzzz', '2007骞');
INSERT INTO `stu_msword` (`msid`, `msname`, `mssex`, `mshead`, `msface`, `mstext`, `msshop`, `msowner`, `mstime`) VALUES (4, 'zzzzzz', 0, 'img4.gif', 18, '鏁㈡?闃熸硶涓婄殑', 6, 'zzzzzz', '2007骞');