From 43233000543984eda49768edde65076fb9c2468c Mon Sep 17 00:00:00 2001 From: ctrlaltca <> Date: Sun, 18 Nov 2012 20:26:25 +0000 Subject: dropped old tests referring to unexisting components (NOTE: this includes what seems a test suite for an older version of SQLMap) --- tests/unit/SQLMap/scripts/mssql/line-item-init.sql | 53 ---------------------- 1 file changed, 53 deletions(-) delete mode 100644 tests/unit/SQLMap/scripts/mssql/line-item-init.sql (limited to 'tests/unit/SQLMap/scripts/mssql/line-item-init.sql') diff --git a/tests/unit/SQLMap/scripts/mssql/line-item-init.sql b/tests/unit/SQLMap/scripts/mssql/line-item-init.sql deleted file mode 100644 index c823667b..00000000 --- a/tests/unit/SQLMap/scripts/mssql/line-item-init.sql +++ /dev/null @@ -1,53 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LineItems]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[LineItems] - -CREATE TABLE [dbo].[LineItems] ( - [LineItem_ID] [int] NOT NULL , - [Order_ID] [int] NOT NULL , - [LineItem_Code] [varchar] (32) NOT NULL , - [LineItem_Quantity] [int] NOT NULL , - [LineItem_Price] [decimal](18, 2) NULL, - [LineItem_Picture] [image] null -) ON [PRIMARY] - -ALTER TABLE [dbo].[LineItems] WITH NOCHECK ADD - CONSTRAINT [PK_LinesItem] PRIMARY KEY CLUSTERED - ( - [LineItem_ID], - [Order_ID] - ) ON [PRIMARY] - -ALTER TABLE [dbo].[LineItems] ADD - CONSTRAINT [FK_LineItems_Orders] FOREIGN KEY - ( - [Order_ID] - ) REFERENCES [dbo].[Orders] ( - [Order_ID] - ) --- Creating Test Data - -INSERT INTO [dbo].[LineItems] VALUES (1, 10, 'ESM-34', 1, 45.43, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 10, 'QSM-98', 8, 8.40, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 9, 'DSM-78', 2, 45.40, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 9, 'TSM-12', 2, 32.12, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 8, 'DSM-16', 4, 41.30, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 8, 'GSM-65', 1, 2.20, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 7, 'WSM-27', 7, 52.10, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 7, 'ESM-23', 2, 123.34, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 6, 'QSM-39', 9, 12.12, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 6, 'ASM-45', 6, 78.77, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 5, 'ESM-48', 3, 43.87, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 5, 'WSM-98', 7, 5.40, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 4, 'RSM-57', 2, 78.90, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 4, 'XSM-78', 9, 2.34, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 3, 'DSM-59', 3, 5.70, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 3, 'DSM-53', 3, 98.78, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 2, 'DSM-37', 4, 7.80, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 2, 'FSM-12', 2, 55.78, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 1, 'ESM-48', 8, 87.60, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 1, 'ESM-23', 1, 55.40, null); - -- cgit v1.2.3