【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了mystore.sql相关资料,希望对各位网友有所帮助!
锘?- phpMyAdmin SQL Dump
-- version 2.9.1-rc2
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2006 骞?11 鏈?08 鏃?14:29
-- 鏈嶅姟鍣ㄧ増鏈? 4.1.21
--
PHP 鐗堟湰: 4.4.4
--
-- 鏁版嵁搴? `mystore`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `orderdetail`
--
CREATE TABLE `orderdetail` (
`OrderDetailID` int(11) unsigned NOT NULL auto_increment,
`OrderID` int(11) unsigned default NULL,
`ProductID` int(11) unsigned default NULL,
`ProductName` varchar(254) default NULL,
`UnitPrice` int(11) unsigned default NULL,
`Quantity` int(11) unsigned default NULL,
PRIMARY KEY (`OrderDetailID`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`orderdetail`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `orders`
--
CREATE TABLE `orders` (
`OrderID` int(11) unsigned NOT NULL auto_increment,
`SubTotal` int(11) unsigned default NULL,
`Shipping` int(11) unsigned default NULL,
`GrandTotal` int(11) unsigned default NULL,
`CustomerName` varchar(100) default NULL,
`CustomerEmail` varchar(100) default NULL,
`CustomerAddress` varchar(100) default NULL,
`CustomerPhone` varchar(100) default NULL,
`paytype` varchar(50) default NULL,
PRIMARY KEY (`OrderID`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`orders`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `product`
--
CREATE TABLE `product` (
`productid` int(11) unsigned NOT NULL auto_increment,
`productname` varchar(100) default NULL,
`productprice` int(11) unsigned default NULL,
`productimages` varchar(100) default NULL,
`description` text,
PRIMARY KEY (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=19 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`product`
--
INSERT INTO `product` (`productid`, `productname`, `productprice`, `productimages`, `description`) VALUES
(1, 'ASUS W5GT24DD', 15480, 'W5GT24DD.jpg', '鈼?1024MBDDRII鍙屼俊閬撳唴瀛榎r\n鈼?100GB瓒呭ぇ纭洏瀹归噺\r\n鈼?鍐呯疆130涓囧儚绱犵綉缁滄憚褰辨満\r\n鈼?12鑻卞闀滈潰瀹藉睆骞?),
(2, 'ASUS F3APT24DD', 15180, 'F3APT24DD.jpg', '鈼?Intel鍙屾牳T2400\r\n鈼?ATi鐙珛鏄剧ずTC256\r\n鈼?15.4鑻卞闀滈潰瀹藉睆骞昞r\n鈼?100G-SATA\r\n鈼?DVDSuperMulti(DL)'),
(3, 'ASUS W7J', 15880, 'W7J.jpg', '鈼?鍙屾牳IntelDualCoreT2400澶勭悊鍣?.83G\r\n鈼?Intel945PM楂樻晥鑺墖\r\n鈼?nV鐙珛鏄剧ず256MB\r\n鈼?13鑻卞闀滈潰灞忓箷'),
(4, 'ASUS S6F', 16880, 'S6F.jpg', '鈼?11.1鑻卞闀滈潰瀹藉睆骞昞r\n鈼?鍐呯疆1GBDDRII鍐呭瓨\r\n鈼?鍙屾牳蹇冧綆鐢靛帇瓒呯渷鐢礐PU\r\n鈼?澶у閲?20GB\r\n鈼?闄勮禒鐪熺毊淇濊瘉涔︿笌鐪熺毊鍏夊榧犳爣'),
(5, 'ASUS VX1', 10880, 'VX1.jpg', '鈼?甯堟硶钃濆疂鍧氬凹璺戣溅鍒╄惤绾挎潯缇庡\r\n鈼?15鑻卞楂樿В鏋愰暅闈㈠睆骞?400x1050\r\n鈼?椤剁骇鐙珛鏄剧ずNV7400VX-512MB\r\n鈼?Intel鍙屾牳蹇僒2500'),
(6, 'Acer 3628A', 12690, '3628A.jpg', '鈼?14.1鑻卞闀滈潰瀹藉睆骞昞r\n鈼?鍐呯疆DVD鍒诲綍鏈篠uperMuti\r\n鈼?瓒呰交宸?.35KG\r\n鈼?IntelPentium1.7G'),
(7, 'ACER TM2403', 12290, 'TM2403.jpg', '鈼?14.1鑻卞瀹藉睆骞昞r\n鈼?Intel鏂颁竴浠?10GML鑺墖,DDR2鍐呭瓨\r\n鈼?CeleronM鏈鏂拌秴鍊肩撼绫虫満\r\n鈼?鍒涙柊FOLIO閫犲瀷'),
(8, 'ACER 5562', 14890, '5562.jpg', '鈼?IntelCoreDuo鍙屾牳蹇僜r\n鈼?ATIX1400512MB3D鏄剧ず\r\n鈼?鏃嬭浆寮?30涓囪棰慭r\n鈼?鎶藉彇寮忚摑鐗欑綉缁滆瘽鏈?),
(9, 'ACER Ferrari 4002WLMi', 14880, '4002WLMi.jpg', '鈼?閲囩敤AMDTurion64鍏ㄦ柊64浣嶅鐞嗗櫒\r\n鈼?涓婄洊纰崇氦缁存潗璐╘r\n鈼?ATIX700鐙珛鏄剧ず\r\n鈼?鍐呯疆钃濈墮'),
(10, 'ACER 3022WTMi', 15290, '3022WTMi.jpg', '鈼?1.5kg杞诲阀鐏靛姩A4澶у皬\r\n鈼?瓒呮晥IntelCoreDuo鍙屾牳蹇僜r\n鈼?130涓囧儚绱?25搴︾綉缁滆棰慭r\n鈼?钃濈墮鏃犵嚎浼犺緭'),
(11, 'HP TC4200', 15790, 'TC4200.jpg', '鈼?鍙媶寮忔棆杞敭鐩樿璁r\n鈼?閲囩敤寮哄寲鐜荤拑\r\n鈼?鎬ц兘鍗撹秺銆佹惡甯︽柟渚縗r\n鈼?涓夊勾淇濆浐'),
(12, 'HP NC2400', 15590, 'NC2400.jpg', '鈼?瓒呰交12鑻卞WXGA\r\n鈼?闀佸悎閲戞満韬玕r\n鈼?鍐呯疆鎸囩汗璇嗗埆鍣╘r\n鈼?鍐呯疆鍏夌洏1.5KG'),
(13, 'HP V2632', 13990, 'V2632.jpg', '鈼?14鑻卞闀滈潰瀹藉睆骞昞r\n鈼?Intel鍙屾牳蹇僒2400\r\n鈼?80GB-SATA瓒呭ぇ纭洏\r\n鈼?钃濈墮鎶