Patch software.sql for MySQL related Bug #52196
Patch version 2010-06-28 12:18 UTC
Return to Bug #52196 |
Download this patch
Patch Revisions:
Developer: lanpioneer@126.com
-- MySQL dump 10.13 Distrib 5.4.1-beta, for Win32 (ia32)
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.4.1-beta-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `categories` (
`CategoryID` int(11) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(100) DEFAULT NULL,
`Description` varchar(300) DEFAULT NULL,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `categories`
--
LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'CategoryName','Description'),(2,'Condiments','Sweet and savory sauces, relishes, spreads, and seasonings'),(3,'Confections','Desserts, candies, and sweet breads'),(4,'Dairy Products','Cheeses'),(5,'Grains/Cereals','Breads, crackers, pasta, and cereal'),(6,'Meat/Poultry','Prepared meats'),(7,'Produce','Dried fruit and bean curd'),(8,'Seafood','Seaweed and fish');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employees`
--
DROP TABLE IF EXISTS `employees`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `employees` (
`EmployeeID` int(11) NOT NULL AUTO_INCREMENT,
`LastName` varchar(20) DEFAULT NULL,
`FirstName` varchar(20) DEFAULT NULL,
`Title` varchar(100) DEFAULT NULL,
`TitleOfCourtesy` varchar(20) DEFAULT NULL,
`BirthDate` datetime DEFAULT NULL,
`HireDate` datetime DEFAULT NULL,
`Address` varchar(200) DEFAULT NULL,
`City` varchar(100) DEFAULT NULL,
`Region` varchar(20) DEFAULT NULL,
`Country` varchar(10) DEFAULT NULL,
`HomePhone` varchar(50) DEFAULT NULL,
`ReportTo` int(11) DEFAULT NULL,
PRIMARY KEY (`EmployeeID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `employees`
--
LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES (2,'Fuller','Andrew','Vice President, Sales','Dr.',NULL,NULL,'908 W. Capital Way','Tacoma','WA','USA','(206) 555-9482',2),(3,'Leverling','Janet','Sales Representative','Ms.',NULL,NULL,'722 Moss Bay Blvd.','Kirkland','WA','USA','(206) 555-3412',2),(4,'Peacock','Margaret','Sales Representative','Mrs.',NULL,NULL,'4110 Old Redmond Rd.','Redmond','WA','USA','(206) 555-8122',NULL),(5,'Buchanan','Steven','Sales Manager','Mr.',NULL,NULL,'14 Garrett Hill','London','','UK','(71) 555-4848',2),(6,'Suyama','Michael','Sales Representative','Mr.',NULL,NULL,'Coventry House\nMiner Rd.','London','','UK','(71) 555-7773',5),(7,'King','Robert','Sales Representative','Mr.',NULL,NULL,'Edgeham Hollow\nWinchester Way','London','','UK','(71) 555-5598',5),(8,'Callahan','Laura','Inside Sales Coordinator','Ms.',NULL,NULL,'4726 - 11th Ave. N.E.','Seattle','WA','USA','(206) 555-1189',2),(9,'Dodsworth','Anne','Sales Representative','Ms.',NULL,NULL,'7 Houndstooth Rd.','London','','UK','(71) 555-4444',5);
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `orders` (
`ORDERID` varchar(20) DEFAULT NULL,
`CustomerID` varchar(20) DEFAULT NULL,
`EmployeeID` int(11) DEFAULT NULL,
`OrderDate` datetime DEFAULT NULL,
`RequiredDate` datetime DEFAULT NULL,
`ShippedDate` datetime DEFAULT NULL,
`Freight` decimal(11,0) DEFAULT NULL,
`ShipName` varchar(50) DEFAULT NULL,
`ShipAddress` varchar(100) DEFAULT NULL,
`ShipCity` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES ('10248','VINET',5,NULL,NULL,NULL,'32','Vins et alcools Chevalier','59 rue de l\'Abbaye','10248'),('10249','TOMSP',6,NULL,NULL,NULL,'12','Toms Spezialitäten','Luisenstr. 48','10249'),('10250','HANAR',4,NULL,NULL,NULL,'66','Hanari Carnes','Rua do Paço, 67','10250'),('10251','VICTE',3,NULL,NULL,NULL,'41','Victuailles en stock','2, rue du Commerce','10251'),('10252','SUPRD',4,NULL,NULL,NULL,'51','Suprêmes délices','Boulevard Tirou, 255','10252'),('10253','HANAR',3,NULL,NULL,NULL,'58','Hanari Carnes','Rua do Paço, 67','10253'),('10254','CHOPS',5,NULL,NULL,NULL,'23','Chop-suey Chinese','Hauptstr. 31','10254'),('10255','RICSU',9,NULL,NULL,NULL,'148','Richter Supermarkt','Starenweg 5','10255'),('10256','WELLI',3,NULL,NULL,NULL,'14','Wellington Importadora','Rua do Mercado, 12','10256'),('10257','HILAA',4,NULL,NULL,NULL,'82','HILARION-Abastos','Carrera 22 con Ave. Carlos Soublette #8-35','10257'),('10258','ERNSH',1,NULL,NULL,NULL,'141','Ernst Handel','Kirchgasse 6','10258'),('10259','CENTC',4,NULL,NULL,NULL,'3','Centro comercial Moctezuma','Sierras de Granada 9993','10259'),('10260','OTTIK',4,NULL,NULL,NULL,'55','Ottilies Käseladen','Mehrheimerstr. 369','10260'),('10261','QUEDE',4,NULL,NULL,NULL,'3','Que Delícia','Rua da Panificadora, 12','10261'),('10262','RATTC',8,NULL,NULL,NULL,'48','Rattlesnake Canyon Grocery','2817 Milton Dr.','10262'),('10263','ERNSH',9,NULL,NULL,NULL,'146','Ernst Handel','Kirchgasse 6','10263'),('10264','FOLKO',6,NULL,NULL,NULL,'4','Folk och fä HB','Åkergatan 24','10264'),('10265','BLONP',2,NULL,NULL,NULL,'55','Blondel père et fils','24, place Kléber','10265'),('10266','WARTH',3,NULL,NULL,NULL,'26','Wartian Herkku','Torikatu 38','10266'),('10267','FRANK',4,NULL,NULL,NULL,'209','Frankenversand','Berliner Platz 43','10267'),('10268','GROSR',8,NULL,NULL,NULL,'66','GROSELLA-Restaurante','5ª Ave. Los Palos Grandes','10268'),('10269','WHITC',5,NULL,NULL,NULL,'5','White Clover Markets','1029 - 12th Ave. S.','10269'),('10270','WARTH',1,NULL,NULL,NULL,'137','Wartian Herkku','Torikatu 38','10270'),('10271','SPLIR',6,NULL,NULL,NULL,'5','Split Rail Beer & Ale','P.O. Box 555','10271'),('10272','RATTC',6,NULL,NULL,NULL,'98','Rattlesnake Canyon Grocery','2817 Milton Dr.','10272'),('10273','QUICK',3,NULL,NULL,NULL,'76','QUICK-Stop','Taucherstraße 10','10273'),('10274','VINET',6,NULL,NULL,NULL,'6','Vins et alcools Chevalier','59 rue de l\'Abbaye','10274'),('10275','MAGAA',1,NULL,NULL,NULL,'27','Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','10275'),('10276','TORTU',8,NULL,NULL,NULL,'14','Tortuga Restaurante','Avda. Azteca 123','10276'),('10277','MORGK',2,NULL,NULL,NULL,'126','Morgenstern Gesundkost','Heerstr. 22','10277'),('10278','BERGS',8,NULL,NULL,NULL,'93','Berglunds snabbköp','Berguvsvägen 8','10278'),('10279','LEHMS',8,NULL,NULL,NULL,'26','Lehmanns Marktstand','Magazinweg 7','10279'),('10280','BERGS',2,NULL,NULL,NULL,'9','Berglunds snabbköp','Berguvsvägen 8','10280'),('10281','ROMEY',4,NULL,NULL,NULL,'3','Romero y tomillo','Gran Vía, 1','10281'),('10282','ROMEY',4,NULL,NULL,NULL,'13','Romero y tomillo','Gran Vía, 1','10282'),('10283','LILAS',3,NULL,NULL,NULL,'85','LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','10283'),('10284','LEHMS',4,NULL,NULL,NULL,'77','Lehmanns Marktstand','Magazinweg 7','10284'),('10285','QUICK',1,NULL,NULL,NULL,'77','QUICK-Stop','Taucherstraße 10','10285'),('10286','QUICK',8,NULL,NULL,NULL,'229','QUICK-Stop','Taucherstraße 10','10286'),('10287','RICAR',8,NULL,NULL,NULL,'13','Ricardo Adocicados','Av. Copacabana, 267','10287'),('10288','REGGC',4,NULL,NULL,NULL,'7','Reggiani Caseifici','Strada Provinciale 124','10288'),('10289','BSBEV',7,NULL,NULL,NULL,'23','B\'s Beverages','Fauntleroy Circus','10289'),('10290','COMMI',8,NULL,NULL,NULL,'80','Comércio Mineiro','Av. dos Lusíadas, 23','10290'),('10291','QUEDE',6,NULL,NULL,NULL,'6','Que Delícia','Rua da Panificadora, 12','10291'),('10292','TRADH',1,NULL,NULL,NULL,'1','Tradiçao Hipermercados','Av. Inês de Castro, 414','10292'),('10293','TORTU',1,NULL,NULL,NULL,'21','Tortuga Restaurante','Avda. Azteca 123','10293'),('10294','RATTC',4,NULL,NULL,NULL,'147','Rattlesnake Canyon Grocery','2817 Milton Dr.','10294'),('10295','VINET',2,NULL,NULL,NULL,'1','Vins et alcools Chevalier','59 rue de l\'Abbaye','10295'),('10296','LILAS',6,NULL,NULL,NULL,'0','LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','10296'),('10297','BLONP',5,NULL,NULL,NULL,'6','Blondel père et fils','24, place Kléber','10297'),('10298','HUNGO',6,NULL,NULL,NULL,'168','Hungry Owl All-Night Grocers','8 Johnstown Road','10298'),('10299','RICAR',4,NULL,NULL,NULL,'30','Ricardo Adocicados','Av. Copacabana, 267','10299'),('10300','MAGAA',2,NULL,NULL,NULL,'18','Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','10300'),('10301','WANDK',8,NULL,NULL,NULL,'45','Die Wandernde Kuh','Adenauerallee 900','10301'),('10302','SUPRD',4,NULL,NULL,NULL,'6','Suprêmes délices','Boulevard Tirou, 255','10302'),('10303','GODOS',7,NULL,NULL,NULL,'108','Godos Cocina Típica','C/ Romero, 33','10303'),('10304','TORTU',1,NULL,NULL,NULL,'64','Tortuga Restaurante','Avda. Azteca 123','10304'),('10305','OLDWO',8,NULL,NULL,NULL,'258','Old World Delicatessen','2743 Bering St.','10305'),('10306','ROMEY',1,NULL,NULL,NULL,'8','Romero y tomillo','Gran Vía, 1','10306'),('10307','LONEP',2,NULL,NULL,NULL,'1','Lonesome Pine Restaurant','89 Chiaroscuro Rd.','10307'),('10308','ANATR',7,NULL,NULL,NULL,'2','Ana Trujillo Emparedados y helados','Avda. de la Constitución 2222','10308'),('10309','HUNGO',3,NULL,NULL,NULL,'47','Hungry Owl All-Night Grocers','8 Johnstown Road','10309'),('10310','THEBI',8,NULL,NULL,NULL,'18','The Big Cheese','89 Jefferson Way Suite 2','10310'),('10311','DUMON',1,NULL,NULL,NULL,'25','Du monde entier','67, rue des Cinquante Otages','10311'),('10312','WANDK',2,NULL,NULL,NULL,'40','Die Wandernde Kuh','Adenauerallee 900','10312'),('10313','QUICK',2,NULL,NULL,NULL,'2','QUICK-Stop','Taucherstraße 10','10313'),('10314','RATTC',1,NULL,NULL,NULL,'74','Rattlesnake Canyon Grocery','2817 Milton Dr.','10314'),('10315','ISLAT',4,NULL,NULL,NULL,'42','Island Trading','Garden House Crowther Way','10315'),('10316','RATTC',1,NULL,NULL,NULL,'150','Rattlesnake Canyon Grocery','2817 Milton Dr.','10316'),('10317','LONEP',6,NULL,NULL,NULL,'13','Lonesome Pine Restaurant','89 Chiaroscuro Rd.','10317'),('10318','ISLAT',8,NULL,NULL,NULL,'5','Island Trading','Garden House Crowther Way','10318'),('10319','TORTU',7,NULL,NULL,NULL,'65','Tortuga Restaurante','Avda. Azteca 123','10319'),('10320','WARTH',5,NULL,NULL,NULL,'35','Wartian Herkku','Torikatu 38','10320'),('10321','ISLAT',3,NULL,NULL,NULL,'3','Island Trading','Garden House Crowther Way','10321'),('10322','PERIC',7,NULL,NULL,NULL,'0','Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','10322'),('10323','KOENE',4,NULL,NULL,NULL,'5','Königlich Essen','Maubelstr. 90','10323'),('10324','SAVEA',9,NULL,NULL,NULL,'214','Save-a-lot Markets','187 Suffolk Ln.','10324'),('10325','KOENE',1,NULL,NULL,NULL,'65','Königlich Essen','Maubelstr. 90','10325'),('10326','BOLID',4,NULL,NULL,NULL,'78','Bólido Comidas preparadas','C/ Araquil, 67','10326'),('10327','FOLKO',2,NULL,NULL,NULL,'63','Folk och fä HB','Åkergatan 24','10327'),('10328','FURIB',4,NULL,NULL,NULL,'87','Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','10328'),('10329','SPLIR',4,NULL,NULL,NULL,'192','Split Rail Beer & Ale','P.O. Box 555','10329'),('10330','LILAS',3,NULL,NULL,NULL,'13','LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','10330'),('10331','BONAP',9,NULL,NULL,NULL,'10','Bon app\'','12, rue des Bouchers','10331'),('10332','MEREP',3,NULL,NULL,NULL,'53','Mère Paillarde','43 rue St. Laurent','10332'),('10333','WARTH',5,NULL,NULL,NULL,'1','Wartian Herkku','Torikatu 38','10333'),('10334','VICTE',8,NULL,NULL,NULL,'9','Victuailles en stock','2, rue du Commerce','10334'),('10335','HUNGO',7,NULL,NULL,NULL,'42','Hungry Owl All-Night Grocers','8 Johnstown Road','10335'),('10336','PRINI',7,NULL,NULL,NULL,'16','Princesa Isabel Vinhos','Estrada da saúde n. 58','10336'),('10337','FRANK',4,NULL,NULL,NULL,'108','Frankenversand','Berliner Platz 43','10337'),('10338','OLDWO',4,NULL,NULL,NULL,'84','Old World Delicatessen','2743 Bering St.','10338'),('10339','MEREP',2,NULL,NULL,NULL,'16','Mère Paillarde','43 rue St. Laurent','10339'),('10340','BONAP',1,NULL,NULL,NULL,'166','Bon app\'','12, rue des Bouchers','10340'),('10341','SIMOB',7,NULL,NULL,NULL,'27','Simons bistro','Vinbæltet 34','10341'),('10342','FRANK',4,NULL,NULL,NULL,'55','Frankenversand','Berliner Platz 43','10342'),('10343','LEHMS',4,NULL,NULL,NULL,'110','Lehmanns Marktstand','Magazinweg 7','10343'),('10344','WHITC',4,NULL,NULL,NULL,'23','White Clover Markets','1029 - 12th Ave. S.','10344'),('10345','QUICK',2,NULL,NULL,NULL,'249','QUICK-Stop','Taucherstraße 10','10345'),('10346','RATTC',3,NULL,NULL,NULL,'142','Rattlesnake Canyon Grocery','2817 Milton Dr.','10346');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `products` (
`ProductID` int(11) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(100) DEFAULT NULL,
`SupplierID` int(11) DEFAULT NULL,
`CategoryID` int(11) DEFAULT NULL,
`QuantityPerUnit` varchar(100) DEFAULT NULL,
`UnitPrice` decimal(11,4) DEFAULT NULL,
`UnitsInStock` int(11) DEFAULT NULL,
`UnitsOnOrder` int(11) DEFAULT NULL,
`ReorderLevel` int(11) DEFAULT NULL,
`Discontinued` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `products`
--
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'Chai',1,1,'10 boxes x 20 bags','18.0000',39,0,10,0),(2,'Chang',1,1,'24 - 12 oz bottles','19.0000',17,40,25,0),(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles','10.0000',13,70,25,0),(4,'Chef Anton\'s Cajun Seasoning',2,2,'48 - 6 oz jars','22.0000',53,0,0,0),(5,'Chef Anton\'s Gumbo Mix',2,2,'36 boxes','21.3500',0,0,0,1),(6,'Grandma\'s Boysenberry Spread',3,2,'12 - 8 oz jars','25.0000',120,0,25,0),(7,'Uncle Bob\'s Organic Dried Pears',3,7,'12 - 1 lb pkgs.','30.0000',15,0,10,0),(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars','40.0000',6,0,0,0),(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.','97.0000',29,0,0,1),(10,'Ikura',4,8,'12 - 200 ml jars','31.0000',31,0,0,0),(11,'Queso Cabrales',5,4,'1 kg pkg.','21.0000',22,30,30,0),(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.','38.0000',86,0,0,0),(13,'Konbu',6,8,'2 kg box','6.0000',24,0,5,0),(14,'Tofu',6,7,'40 - 100 g pkgs.','23.2500',35,0,0,0),(15,'Genen Shouyu',6,2,'24 - 250 ml bottles','15.5000',39,0,5,0),(16,'Pavlova',7,3,'32 - 500 g boxes','17.4500',29,0,10,0),(17,'Alice Mutton',7,6,'20 - 1 kg tins','39.0000',0,0,0,1),(18,'Carnarvon Tigers',7,8,'16 kg pkg.','62.5000',42,0,0,0),(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces','9.2000',25,0,5,0),(20,'Sir Rodney\'s Marmalade',8,3,'30 gift boxes','81.0000',40,0,0,0),(21,'Sir Rodney\'s Scones',8,3,'24 pkgs. x 4 pieces','10.0000',3,40,5,0),(22,'Gustaf\'s Knäckebröd',9,5,'24 - 500 g pkgs.','21.0000',104,0,25,0),(23,'Tunnbröd',9,5,'12 - 250 g pkgs.','9.0000',61,0,25,0),(24,'Guaraná Fantástica',10,1,'12 - 355 ml cans','4.5000',20,0,0,1),(25,'NuNuCa Nuß-Nougat-Creme',11,3,'20 - 450 g glasses','14.0000',76,0,30,0),(26,'Gumbär Gummibärchen',11,3,'100 - 250 g bags','31.2300',15,0,0,0),(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces','43.9000',49,0,30,0),(28,'Rössle Sauerkraut',12,7,'25 - 825 g cans','45.6000',26,0,0,1),(29,'Thüringer Rostbratwurst',12,6,'50 bags x 30 sausgs.','123.7900',0,0,0,1),(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses','25.8900',10,0,15,0),(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs','12.5000',0,70,20,0),(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.','32.0000',9,40,25,0),(33,'Geitost',15,4,'500 g','2.5000',112,0,20,0),(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles','14.0000',111,0,15,0),(35,'Steeleye Stout',16,1,'24 - 12 oz bottles','18.0000',20,0,15,0),(36,'Inlagd Sill',17,8,'24 - 250 g jars','19.0000',112,0,20,0),(37,'Gravad lax',17,8,'12 - 500 g pkgs.','26.0000',11,50,25,0),(38,'Côte de Blaye',18,1,'12 - 75 cl bottles','263.5000',17,0,15,0),(39,'Chartreuse verte',18,1,'750 cc per bottle','18.0000',69,0,5,0),(40,'Boston Crab Meat',19,8,'24 - 4 oz tins','18.4000',123,0,30,0),(41,'Jack\'s New England Clam Chowder',19,8,'12 - 12 oz cans','9.6500',85,0,10,0),(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.','14.0000',26,0,0,1),(43,'Ipoh Coffee',20,1,'16 - 500 g tins','46.0000',17,10,25,0),(44,'Gula Malacca',20,2,'20 - 2 kg bags','19.4500',27,0,15,0),(45,'Rogede sild',21,8,'1k pkg.','9.5000',5,70,15,0),(46,'Spegesild',21,8,'4 - 450 g glasses','12.0000',95,0,0,0),(47,'Zaanse koeken',22,3,'10 - 4 oz boxes','9.5000',36,0,0,0),(48,'Chocolade',22,3,'10 pkgs.','12.7500',15,70,25,0),(49,'Maxilaku',23,3,'24 - 50 g pkgs.','20.0000',10,60,15,0),(50,'Valkoinen suklaa',23,3,'12 - 100 g bars','16.2500',65,0,30,0),(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.','53.0000',20,0,10,0),(52,'Filo Mix',24,5,'16 - 2 kg boxes','7.0000',38,0,25,0),(53,'Perth Pasties',24,6,'48 pieces','32.8000',0,0,0,1),(54,'Tourtière',25,6,'16 pies','7.4500',21,0,10,0),(55,'Pâté chinois',25,6,'24 boxes x 2 pies','24.0000',115,0,20,0),(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.','38.0000',21,10,30,0),(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.','19.5000',36,0,20,0),(58,'Escargots de Bourgogne',27,8,'24 pieces','13.2500',62,0,20,0),(59,'Raclette Courdavault',28,4,'5 kg pkg.','55.0000',79,0,0,0),(60,'Camembert Pierrot',28,4,'15 - 300 g rounds','34.0000',19,0,0,0),(61,'Sirop d\'érable',29,2,'24 - 500 ml bottles','28.5000',113,0,25,0),(62,'Tarte au sucre',29,3,'48 pies','49.3000',17,0,0,0),(63,'Vegie-spread',7,2,'15 - 625 g jars','43.9000',24,0,5,0),(64,'Wimmers gute Semmelknödel',12,5,'20 bags x 4 pieces','33.2500',22,80,30,0),(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles','21.0500',76,0,0,0),(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars','17.0000',4,100,20,0),(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles','14.0000',52,0,10,0),(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces','12.5000',6,10,15,0),(69,'Gudbrandsdalsost',15,4,'10 kg pkg.','36.0000',26,0,15,0),(70,'Outback Lager',7,1,'24 - 355 ml bottles','15.0000',15,10,30,0),(71,'Flotemysost',15,4,'10 - 500 g pkgs.','21.5000',26,0,0,0),(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.','34.8000',14,0,0,0),(73,'Röd Kaviar',17,8,'24 - 150 g jars','15.0000',101,0,5,0),(74,'Longlife Tofu',4,7,'5 kg pkg.','10.0000',4,20,5,0),(75,'Rhönbräu Klosterbier',12,1,'24 - 0.5 l bottles','7.7500',125,0,25,0),(76,'Lakkalikööri',23,1,'500 ml','18.0000',57,0,20,0),(77,'Original Frankfurter grüne Soße',12,2,'12 boxes','13.0000',32,0,15,0);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `software`
--
DROP TABLE IF EXISTS `software`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `software` (
`ID` varchar(10) DEFAULT NULL,
`Name` varchar(100) DEFAULT NULL,
`Size` varchar(20) DEFAULT NULL,
`Desp` varchar(100) DEFAULT NULL,
`Version` varchar(20) DEFAULT NULL,
`Style` varchar(20) DEFAULT NULL,
`Price` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `software`
--
LOCK TABLES `software` WRITE;
/*!40000 ALTER TABLE `software` DISABLE KEYS */;
INSERT INTO `software` VALUES ('0001','BoostWEB','304KB','最佳化Cache,浏览网页速度快','2.5C2','网络应用','2'),('0002','Clever Terminal','655KB','非常好的TelNet软件','三个月版','网络应用','免费'),('0003','中文论坛','655KB','建立BBS的好软件','1.2','网络应用','3'),('0004','WinGate','2523KB','多台电脑共用一个MODEN上网的软件','3.0','网络应用','1'),('0005','Copernic 99','2404KB','Search工具','3.0','网络应用','2'),('0006','QNX Demo Disk','1400KB','不需系统，只要软盘就能上网的软件','1.4','网络应用','1'),('0007','AbsoluteFTP','1190KB','FTP传输工具','1.6 Beta 4','网络应用','免费'),('0008','方文网络伴侣','1149KB','网页管理工具','00','网络应用','2'),('0009','在线色彩精灵','4KB','生成主页文本等色彩的代码','00','网络应用','1'),('0010','主页制作百宝箱','549KB','非常好的主页特效制作软件','1.10','网络应用','3'),('0011','CoffeeCup Html Editor++ Pro','6857KB','全功能的HTML编辑软件','6.2','网络应用','5'),('0012','Sonique','1335KB','很棒的MP3播放软件','0.92b Beta','多媒体','2'),('0013','(Visual) Geiss','101KB','WinAMP的Plug-Ins','3.61','多媒体','2'),('0014','CD2WAV32','351KB','MP3制作软件','2.07','多媒体','3'),('0015','HyCD Play&Record','7MB','集各种多媒体功能于一体的软件','1.3.0226','多媒体','4'),('0016','AI Picture Explorer','1015KB','图片浏览，还可产生HTML文件','2.0.36','图形图像','2'),('0017','Capture Professional','685KB','超级抓图软件','4.11','图形图像','2'),('0018','GIF Construction Set Pro','3736KB','制作GIF等文件的好工具','2.0a','图形图像','3'),('0019','ICONimation','5.3MB','屏幕保护制作软件','1.2','图形图像','5'),('0020','更名王','522KB','修改文件名的好工具','2.0.0','系统软件','免费'),('0021','关机定时器','575KB','关机工具','1.3.23','系统软件','1'),('0022','Back Again','2821KB','功能很强的备份软件','2.0','系统软件','2'),('0023','Cachemanager','1748KB','利用硬盘产生Cache的工具','2.6','系统软件','4'),('0024','DlgXRsizer','1.13MB','非常好的管理文件工具','3.2.8','系统软件','5'),('0025','Microsoft Visual Basic','176MB','微软公司面向对象编程工具','5.0','计算机语言','10'),('0026','Microsoft Visual FoxPro','200MB','微软公司数据库编程工具','5.0','计算机语言','10'),('0027','Microsoft Visual Java','30MB','微软公司网络编程工具','1.0','计算机语言','10'),('0028','Microsoft Visual InetDev','25MB','网络编程,应用于多种文件','1.0','计算机语言','10'),('0029','Quick Basic','1.59MB','早期Basic语言编程工具','7.0','计算机语言','4'),('0030','FoxBase','1.67MB','早期数据库编程工具','1.12','计算机语言','3'),('0031','Microsfto SQL Server','15.4MB','数据库引擎','7.0','计算机语言','7'),('0032','Visual SourceSafe','12MB','软件开发控制系统','5.0','计算机语言','9'),('0033','Microsoft Personal Web Server','30MB','个人网站设立系统','for Win98','网络应用','10'),('0034','Exits win95/98','34KB','快速退出Windows的工具','7.4','系统软件','免费'),('0035','ProFILER 2000','4256KB','系统的设定软件,非常好','1.0','系统软件','5'),('0036','Reg2000','168KB','注册表修改,密码查看工具','1.2 Build 115','系统软件','3'),('0037','Eraser','1120KB','还原被删除文件的工具','1.0','系统软件','7'),('0038','File Protector','75KB','管理文件,加密文件工具','1.53','系统软件','6'),('0039','JpadPro','2.7MB','编辑Jave的专用编程工具','3.6 Build 280','网络应用','7'),('0040','Mapedit','277KB','简单,实用的HTML编辑工具','2.52','网络应用','3'),('0041','Pretty HTML','1112KB','HTML编程工具','3.5','网络应用','2'),('0042','DLExpert','291KB','多线程的下载工具','0.63 GB','网络应用','8'),('0043','1st Contact','1.28MB','邮件管理工具','2.00.0.1','网络应用','9'),('0044','3DMark 99 Max','18MB','电脑3D效果测试软件','1.0','系统测试','6'),('0045','HardInFo Pro','1.949MB','电脑硬件配备信息基准测试软件','1.05','系统测试','4'),('0046','HWINFO','0.405MB','电脑硬件测试软件','4.5.2','系统测试','1'),('0047','System Analyser','172KB','可测出电脑硬件配备信息的软件','5.1o','系统测试','1'),('0048','WCPUID','53KB','检测CPU的信息软件','2.4a','系统测试','1'),('0049','WinTune 98','1728KB','系统效能分析程序','1.0.37','系统测试','8'),('0050','Aladdin Expander','1391KB','可将.hqx和.bin解压缩的软件','5.0','压缩工具','4'),('0051','Apcak','66KB','Dos下的压缩软件','0.98b','压缩工具','2'),('0052','Archive Comparison','143KB','各种压缩软件的测试报告工具','Test 2 March 1999','压缩工具','2'),('0053','Archive Shell','1742KB','压缩文件管理器','6.0','压缩工具','7'),('0054','ArjFolder','714KB','专门处理Arj文件的压缩和解压缩工具','2.85a','压缩工具','5'),('0055','Apollo','1042KB','一个MP3播放程序','30','多媒体','4'),('0056','C-4','339KB','相当精致的MP3播放程序','1.1','多媒体','1'),('0057','Esprit','1537KB','支持全部Winamp Plunins的播放软件','1.5','多媒体','6'),('0058','Lyrics Euy','22KB','可以让Winamp显示歌词的外挂程序','0.52','多媒体','2');
/*!40000 ALTER TABLE `software` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tuser`
--
DROP TABLE IF EXISTS `tuser`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tuser` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(22) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tuser`
--
LOCK TABLES `tuser` WRITE;
/*!40000 ALTER TABLE `tuser` DISABLE KEYS */;
INSERT INTO `tuser` VALUES (1,'frankli','123456'),(2,'frankli','e10adc3949ba59abbe56e057f20f883e'),(3,'李翔','25f9e794323b453885f5181f1b624d0b');
/*!40000 ALTER TABLE `tuser` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2010-06-28 12:16:04
|
Copyright © 2001-2024 The PHP Group