loaddata.sql

电子商务入门套件是一个电子商务网络店面

-- Vertigo Software Data Script File
-- This file was auto-generated by Utilities.DataScripter Version 1.0.1152.18116 on 2/26/2003 at 1:02 PM.

-- point to proper DB 
use [~~##CMRCStarterKitDB##~~]
GO

SET DATEFORMAT mdy
GO

DELETE FROM [dbo].[CMRC_Categories]

GO

SET IDENTITY_INSERT [dbo].[CMRC_Categories] ON

GO

INSERT INTO [dbo].[CMRC_Categories]
([CategoryID],[CategoryName])
SELECT 14, 'Communications'
UNION ALL
SELECT 15, 'Deception'
UNION ALL
SELECT 16, 'Travel'
UNION ALL
SELECT 17, 'Protection'
UNION ALL
SELECT 18, 'Munitions'
UNION ALL
SELECT 19, 'Tools'
UNION ALL
SELECT 20, 'General'

GO

SET IDENTITY_INSERT [dbo].[CMRC_Categories] OFF

GO

-- Vertigo Software Data Script File
-- This file was auto-generated by Utilities.DataScripter Version 1.0.1152.18116 on 2/26/2003 at 1:02 PM.

DELETE FROM [dbo].[CMRC_Customers]

GO

SET IDENTITY_INSERT [dbo].[CMRC_Customers] ON

GO

INSERT INTO [dbo].[CMRC_Customers]
([CustomerID],[FullName],[EmailAddress],[Password])
SELECT 1, 'Big Guy', '[e-mail]', '123'
UNION ALL
SELECT 2, 'Sarah Goodpenny', '[e-mail]', '15-72-5B-0E-E7-A6-5E-A3-4A-BF-84-C8-58-93-18-FA'
UNION ALL
SELECT 3, 'Gordon Que', '[e-mail]', '15-72-5B-0E-E7-A6-5E-A3-4A-BF-84-C8-58-93-18-FA'
UNION ALL
SELECT 20, 'hash test', '[e-mail]', '5F-A2-85-E1-BE-BE-0A-66-23-E3-3A-FC-04-A1-FB-D5'
UNION ALL
SELECT 19, 'Guest Account', 'guest', 'D0-09-1A-0F-E2-B2-09-34-D8-8B-46-06-84-F5-97-89'
UNION ALL
SELECT 16, 'Test Account', 'd', '2B-9D-4F-A8-5C-8E-82-13-2B-DE-46-B1-43-04-01-42'

GO

SET IDENTITY_INSERT [dbo].[CMRC_Customers] OFF

GO

-- Vertigo Software Data Script File
-- This file was auto-generated by Utilities.DataScripter Version 1.0.1152.18116 on 2/26/2003 at 1:02 PM.

DELETE FROM [dbo].[CMRC_Orders]

GO

SET IDENTITY_INSERT [dbo].[CMRC_Orders] ON

GO

INSERT INTO [dbo].[CMRC_Orders]
([OrderID],[CustomerID],[OrderDate],[ShipDate])
SELECT 99, 19, '7/6/2000 1:01:00 AM', '7/7/2000 1:01:00 AM'
UNION ALL
SELECT 93, 16, '7/3/2000 1:01:00 AM', '7/4/2000 1:01:00 AM'
UNION ALL
SELECT 101, 16, '7/10/2000 1:01:00 AM', '7/11/2000 1:01:00 AM'
UNION ALL
SELECT 103, 16, '7/10/2000 1:01:00 AM', '7/10/2000 1:01:00 AM'
UNION ALL
SELECT 96, 19, '7/3/2000 1:01:00 AM', '7/3/2000 1:01:00 AM'
UNION ALL
SELECT 104, 19, '7/10/2000 1:01:00 AM', '7/11/2000 1:01:00 AM'
UNION ALL
SELECT 105, 16, '10/30/2000 1:01:00 AM', '10/31/2000 1:01:00 AM'
UNION ALL
SELECT 106, 16, '10/30/2000 1:01:00 AM', '10/30/2000 1:01:00 AM'
UNION ALL
SELECT 107, 16, '10/30/2000 1:01:00 AM', '10/31/2000 1:01:00 AM'
UNION ALL
SELECT 100, 19, '7/6/2000 1:01:00 AM', '7/8/2000 1:01:00 AM'
UNION ALL
SELECT 102, 16, '7/10/2000 1:01:00 AM', '7/12/2000 1:01:00 AM'
UNION ALL
SELECT 108, 1, '2/24/2003 11:32:07 AM', '2/24/2003 11:32:07 AM'

GO

SET IDENTITY_INSERT [dbo].[CMRC_Orders] OFF

GO

-- Vertigo Software Data Script File
-- This file was auto-generated by Utilities.DataScripter Version 1.0.1152.18116 on 2/26/2003 at 1:02 PM.

DELETE FROM [dbo].[CMRC_OrderDetails]

GO

INSERT INTO [dbo].[CMRC_OrderDetails]
([OrderID],[ProductID],[Quantity],[UnitCost])
SELECT 99, 404, 2, 459.99
UNION ALL
SELECT 93, 363, 1, 1.99
UNION ALL
SELECT 101, 378, 2, 14.99
UNION ALL
SELECT 102, 372, 1, 129.99
UNION ALL
SELECT 96, 378, 1, 14.99
UNION ALL
SELECT 103, 363, 1, 1.99
UNION ALL
SELECT 104, 355, 1, 1499.99
UNION ALL
SELECT 104, 378, 1, 14.99
UNION ALL
SELECT 104, 406, 1, 399.99
UNION ALL
SELECT 100, 404, 2, 459.99
UNION ALL
SELECT 101, 401, 1, 599.99
UNION ALL
SELECT 102, 401, 1, 599.99
UNION ALL