stu.sql

LOVESTUdio多校园交易系统 VER 4.0基于3.0开发

INSERT INTO `stu_goods` (`goodsid`, `goodsname`, `goodsimg`, `goodsowershop`, `goodsprice`, `goodsstar`, `goodstime`, `goodsmaosu`, `goodsyijia`, `goodsmode`, `goodsshopmode`, `goodsnum`, `goodshit`) VALUES (45, '九成新手机', '{6A46DD4C-68D4-4E74-A814-454CCB29CDB3}0.jpg', '7', 600, 0, '2007-03-31 15:35:19', '感到翻跟斗 ', 0, 0, 0, 1, 2);
INSERT INTO `stu_goods` (`goodsid`, `goodsname`, `goodsimg`, `goodsowershop`, `goodsprice`, `goodsstar`, `goodstime`, `goodsmaosu`, `goodsyijia`, `goodsmode`, `goodsshopmode`, `goodsnum`, `goodshit`) VALUES (39, '立体声耳机', '{4821DD00-609D-4899-B422-B6F7DE3D9121}0.jpg', '7', 1695, 0, '2007-01-06 20:14:53', '????瑰?灏??娉', 1, 0, 0, 2, 13);
INSERT INTO `stu_goods` (`goodsid`, `goodsname`, `goodsimg`, `goodsowershop`, `goodsprice`, `goodsstar`, `goodstime`, `goodsmaosu`, `goodsyijia`, `goodsmode`, `goodsshopmode`, `goodsnum`, `goodshit`) VALUES (42, '情侣巧克力', '{78ECE821-9FE3-4A5A-AE40-BBF8F6B4946F}0.jpg', '7', 1356, 0, '2007-01-07 11:20:33', '<P>个是的发个是的发是发个是的发</P>\r\n<P>个是的发是个</P>\r\n<P>个是的发个是的发</P>\r\n<P>个是的发是个是的发</P>', 0, 1, 0, 24, 11);
INSERT INTO `stu_goods` (`goodsid`, `goodsname`, `goodsimg`, `goodsowershop`, `goodsprice`, `goodsstar`, `goodstime`, `goodsmaosu`, `goodsyijia`, `goodsmode`, `goodsshopmode`, `goodsnum`, `goodshit`) VALUES (43, '组合音响', '{78ECE821-9FE3-4A5A-AE40-BBF8F6B4946F}0.jpg', '7', 12, 0, '2007-01-07 11:21:12', '<P>个是的发个是的发个是的发个</P>', 1, 1, 0, 99, 11);
INSERT INTO `stu_goods` (`goodsid`, `goodsname`, `goodsimg`, `goodsowershop`, `goodsprice`, `goodsstar`, `goodstime`, `goodsmaosu`, `goodsyijia`, `goodsmode`, `goodsshopmode`, `goodsnum`, `goodshit`) VALUES (44, '充电器', '{4D77B601-B5C0-4017-9A7E-2A449C6AE32F}.jpg', '7', 12, 0, '2007-01-09 17:28:53', '<P><STRONG><FONT color=#3d11ee size=5>?㈡????</FONT></STRONG></P>\r\n<P><STRONG><FONT color=#3d11ee size=5></FONT></STRONG>&nbsp;</P>\r\n<P><IMG src="/lovetrade/upload/image/200701/1727464.jpg" border=0></P>', 1, 0, 1, 3, 36);



CREATE TABLE IF NOT EXISTS `stu_link` (
  `siteid` int(6) NOT NULL auto_increment,
  `sitename` varchar(100) NOT NULL,
  `siteurl` varchar(50) NOT NULL,
  `sitelogo` varchar(50) NOT NULL,
  `siteowner` varchar(30) NOT NULL,
  `siteemail` varchar(100) NOT NULL,
  `sitemaosu` longtext NOT NULL,
  `sitemode` int(1) NOT NULL default '0',
  `sitelei` int(1) NOT NULL default '0',
  PRIMARY KEY  (`siteid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=14 ;



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