summaryrefslogtreecommitdiff
path: root/tests/unit/Data/SqlMap/scripts/mssql/documents-init.sql
blob: b268c25837441a4b89de057db8ac399cbaf19b34 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
-- Creating Table

use [IBatisNet]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Documents]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_LineItems_Orders]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
	ALTER TABLE [dbo].[LineItems] DROP CONSTRAINT FK_LineItems_Orders

	drop table [dbo].[Documents]
END

CREATE TABLE [dbo].[Documents] (
	[Document_ID] [int] NOT NULL ,
	[Document_Title] [varchar] (32) NULL ,
	[Document_Type] [varchar] (32)  NULL ,
	[Document_PageNumber] [int] NULL  ,
	[Document_City] [varchar] (32)  NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[Documents] WITH NOCHECK ADD 
	CONSTRAINT [PK_Documents] PRIMARY KEY  CLUSTERED 
	(
		[Document_ID]
	)  ON [PRIMARY] 

-- Creating Test Data 

INSERT INTO [dbo].[Documents] VALUES (1, 'The World of Null-A', 'Book', 55, null);
INSERT INTO [dbo].[Documents] VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon');
INSERT INTO [dbo].[Documents] VALUES (3, 'Lord of the Rings', 'Book', 3587, null);
INSERT INTO [dbo].[Documents] VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris');
INSERT INTO [dbo].[Documents] VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris');
INSERT INTO [dbo].[Documents] VALUES (6, 'Foundation', 'Monograph', 557, null);