CREATE TABLE `Categories` (
`CategoryID` INTEGER NOT NULL AUTO_INCREMENT,
`CategoryName` VARCHAR(15) NOT NULL,
`Description` MEDIUMTEXT,
`Picture` LONGBLOB,
CONSTRAINT `PK_Categories` PRIMARY KEY (`CategoryID`)
);
CREATE INDEX `CategoryName` ON `Categories` (`CategoryName`);
CREATE TABLE `CustomerCustomerDemo` (
`CustomerID` VARCHAR(5) NOT NULL,
`CustomerTypeID` VARCHAR(10) NOT NULL,
CONSTRAINT `PK_CustomerCustomerDemo` PRIMARY KEY (`CustomerID`, `CustomerTypeID`)
);
CREATE TABLE `CustomerDemographics` (
`CustomerTypeID` VARCHAR(10) NOT NULL,
`CustomerDesc` MEDIUMTEXT,
CONSTRAINT `PK_CustomerDemographics` PRIMARY KEY (`CustomerTypeID`)
);
CREATE TABLE `Customers` (
`CustomerID` VARCHAR(5) NOT NULL,
`CompanyName` VARCHAR(40) NOT NULL,
`ContactName` VARCHAR(30),
`ContactTitle` VARCHAR(30),
`Address` VARCHAR(60),
`City` VARCHAR(15),
`Region` VARCHAR(15),
`PostalCode` VARCHAR(10),
`Country` VARCHAR(15),
`Phone` VARCHAR(24),
`Fax` VARCHAR(24),
CONSTRAINT `PK_Customers` PRIMARY KEY (`CustomerID`)
);
CREATE INDEX `City` ON `Customers` (`City`);
CREATE INDEX `CompanyName` ON `Customers` (`CompanyName`);
CREATE INDEX `PostalCode` ON `Customers` (`PostalCode`);
CREATE INDEX `Region` ON `Customers` (`Region`);
CREATE TABLE `Employees` (
`EmployeeID` INTEGER NOT NULL AUTO_INCREMENT,
`LastName` VARCHAR(20) NOT NULL,
`FirstName` VARCHAR(10) NOT NULL,
`Title` VARCHAR(30),
`TitleOfCourtesy` VARCHAR(25),
`BirthDate` DATETIME,
`HireDate` DATETIME,
`Address` VARCHAR(60),
`City` VARCHAR(15),
`Region` VARCHAR(15),
`PostalCode` VARCHAR(10),
`Country` VARCHAR(15),
`HomePhone` VARCHAR(24),
`Extension` VARCHAR(4),
`Photo` LONGBLOB,
`Notes` MEDIUMTEXT NOT NULL,
`ReportsTo` INTEGER,
`PhotoPath` VARCHAR(255),
`Salary` FLOAT,
CONSTRAINT `PK_Employees` PRIMARY KEY (`EmployeeID`)
);
CREATE INDEX `LastName` ON `Employees` (`LastName`);
CREATE INDEX `PostalCode` ON `Employees` (`PostalCode`);
CREATE TABLE `EmployeeTerritories` (
`EmployeeID` INTEGER NOT NULL,
`TerritoryID` VARCHAR(20) NOT NULL,
CONSTRAINT `PK_EmployeeTerritories` PRIMARY KEY (`EmployeeID`, `TerritoryID`)
);
CREATE TABLE `Order Details` (
`OrderID` INTEGER NOT NULL,
`ProductID` INTEGER NOT NULL,
`UnitPrice` DECIMAL(10,4) NOT NULL DEFAULT 0,
`Quantity` SMALLINT(2) NOT NULL DEFAULT 1,
`Discount` REAL(8,0) NOT NULL DEFAULT 0,
CONSTRAINT `PK_Order Details` PRIMARY KEY (`OrderID`, `ProductID`)
);
CREATE TABLE `Orders` (
`OrderID` INTEGER NOT NULL AUTO_INCREMENT,
`CustomerID` VARCHAR(5),
`EmployeeID` INTEGER,
`OrderDate` DATETIME,
`RequiredDate` DATETIME,
`ShippedDate` DATETIME,
`ShipVia` INTEGER,
`Freight` DECIMAL(10,4) DEFAULT 0,
`ShipName` VARCHAR(40),
`ShipAddress` VARCHAR(60),
`ShipCity` VARCHAR(15),
`ShipRegion` VARCHAR(15),
`ShipPostalCode` VARCHAR(10),
`ShipCountry` VARCHAR(15),
CONSTRAINT `PK_Orders` PRIMARY KEY (`OrderID`)
);
CREATE INDEX `OrderDate` ON `Orders` (`OrderDate`);
CREATE INDEX `ShippedDate` ON `Orders` (`ShippedDate`);
CREATE INDEX `ShipPostalCode` ON `Orders` (`ShipPostalCode`);
CREATE TABLE `Products` (
`ProductID` INTEGER NOT NULL AUTO_INCREMENT,
`ProductName` VARCHAR(40) NOT NULL,
`SupplierID` INTEGER,
`CategoryID` INTEGER,
`QuantityPerUnit` VARCHAR(20),
`UnitPrice` DECIMAL(10,4) DEFAULT 0,
`UnitsInStock` SMALLINT(2) DEFAULT 0,
`UnitsOnOrder` SMALLINT(2) DEFAULT 0,
`ReorderLevel` SMALLINT(2) DEFAULT 0,
`Discontinued` BIT NOT NULL DEFAULT 0,
CONSTRAINT `PK_Products` PRIMARY KEY (`ProductID`)
);
CREATE INDEX `ProductName` ON `Products` (`ProductName`);
CREATE TABLE `Region` (
`RegionID` INTEGER NOT NULL,
`RegionDescription` VARCHAR(50) NOT NULL,
CONSTRAINT `PK_Region` PRIMARY KEY (`RegionID`)
);
CREATE TABLE `Shippers` (
`ShipperID` INTEGER NOT NULL AUTO_INCREMENT,
`CompanyName` VARCHAR(40) NOT NULL,
`Phone` VARCHAR(24),
CONSTRAINT `PK_Shippers` PRIMARY KEY (`ShipperID`)
);
CREATE TABLE `Suppliers` (
`SupplierID` INTEGER NOT NULL AUTO_INCREMENT,
`CompanyName` VARCHAR(40) NOT NULL,
`ContactName` VARCHAR(30),
`ContactTitle` VARCHAR(30),
`Address` VARCHAR(60),
`City` VARCHAR(15),
`Region` VARCHAR(15),
`PostalCode` VARCHAR(10),
`Country` VARCHAR(15),
`Phone` VARCHAR(24),
`Fax` VARCHAR(24),
`HomePage` MEDIUMTEXT,
CONSTRAINT `PK_Suppliers` PRIMARY KEY (`SupplierID`)
);
CREATE INDEX `CompanyName` ON `Suppliers` (`CompanyName`);
CREATE INDEX `PostalCode` ON `Suppliers` (`PostalCode`);
CREATE TABLE `Territories` (
`TerritoryID` VARCHAR(20) NOT NULL,
`TerritoryDescription` VARCHAR(50) NOT NULL,
`RegionID` INTEGER NOT NULL,
CONSTRAINT `PK_Territories` PRIMARY KEY (`TerritoryID`)
);
TRUNCATE TABLE Categories;
INSERT INTO Categories VALUES(null,'Beverages','Soft drinks, coffees, teas, beers, and ales',X'FFD8FFE000104A46494600010200006400640000FFEC00114475636B7900010004000000500000FFEE002641646F62650064C0000000010300150403060A0D00000A63000010E8000019F4000027A4FFDB0084000202020202020202020203020202030403020203040504040404040506050505050505060607070807070609090A0A09090C0C0C0C0C0C0C0C0C0C0C0C0C0C0C01030303050405090606090D0B090B0D0F0E0E0E0E0F0F0C0C0C0C0C0F0F0C0C0C0C0C0C0F0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0CFFC2001108006E00AF03011100021101031101FFC400E800000104030101000000000000000000000503040607000208010901000203010101000000000000000000000203000104050607100001040103030401030403000000000001000203041110120520211331221406303223154133250724341611000200030505040704080701000000000102001103213141120451712232131061810591A1425262231420C1723330F0B1E18292B234D1F1A2C2D24393241200000503040301000000000000000000003001112120403110501222410232611301000202020103030501010000000000010011213141516110718191A1B120F0C1D1E130F1FFDA000C03010002110311000001EC3E66DE66CE0DDB4FD476C69EAF0BA3DC4DAF2FD20EB7CCD681E948BADB53974AC46A2178F553DE7280A568326F76E124494661F4B40EB6F59C9135685C38755FABA9C89CDF6B267E0ED1DDE21CDAF2E46C4A38FD872EE16AD54279AB85E414CAC7B2DC09375DAB54B507D17F65C6C9324F6E654C9324C93C93DB952D3646DD3E4A6F194871F455FCB3D2AC5558049B308B10BE88FA3BEC39046EB24C9324C9324C93248E2DF5BD6C96E958D160807263548F1DB5CE178851B796A9D081E615C19FE86FB4875A87760A90FB2649A0DB51646336BA8B27509EFC8C0CA5ED134684408625B0CCCF10323C12A5C7511C182D6E6F57A4BDAF375022D624AC5C4A6C251D53E148D7071D0B38263D0E72F6E91C3E77F3DEBA0187A8396FF4E1C359C66784EBF1B30E4A0C73D9D1FEFF00931A1B182D6744344C7D10D13640C771920808ED45A4EAE69F29EE2969DE1AF3B08B14753A0711CA495B1F93B0F8DC4268BE90F79C58C8D85AB130C551B084D166929C621CA1D9E37A6F6E2FA2E6DE6FB001A9C91510B5D9ECC751AB6958B611135C7E1EC0E5BFAAFE85E5A309B0B0C44B154C428DB81E0B0D18DC5D0E7560BD7CEFE57DFD757DE62DAF60EB77BDAF7259334AE6A885653290FA7FEB3E62090C4C24696D4288229A285A9D11221B177E11EBDB42E0F4143F27D88CBD09332129180B5A1A3094848909BB067D5AF5DF1C6EB81E16956DA44EAE038F43923936851460AD2A87E57AA129D754A3A8C036B24696A7684192B33F869416134D3C6EDCF45E14C02E1C6C36228541F4CF60C629E56A3D91894E6AE5FA5439FDAD964BB89D184685CEAE8F9E71CB60CCDA0DE9E6F64FA4F9F0C85BDD28337AA670811316A882DAE2E87DDD358BA94EE0EFADCCEDA39DCAB45D315E4A484DB2D8E4D72DEEF98ED4EBF8B1D716905AD8B4ACB85EC01939094981B2BAE47E37A28F67DC217D68A61EE3B30D2EBCBA56EB6926FB3892EDDC3FFFDA0008010100010502E4EBBA4AF3C4D134A3626F1B7AD55FB3F3527D6380E4677D2ADF58E767FADDE8E46CACD398693C7F2BF5BE339F15DB38ADCB1CC1363717273C806D809B36147C86145CC4DB9DCBE64C052D0A9391C5D04D63183ECDF5D83EC9C73FFD65F63649C7FF00ABB90F99144D863D39899B5B89E3237C3C6FA2BB039E2CE4344B95238BDAF39779D4927664CF0BCCD7B3F173C7F92B01F95929F1EF
northwind的Mysql版本
5星 · 超过95%的资源 需积分: 50 201 浏览量
2017-12-09
23:25:27
上传
评论 3
收藏 265KB RAR 举报
xu_Melon
- 粉丝: 47
- 资源: 14