EF-Dynamic-Model/database.sql at master · sakowiczm/EF-Dynamic-Model · GitHub

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

CREATE TABLE [dbo].[lookup2](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[code] [nvarchar](10) NOT NULL,
	[description] [nvarchar](50) NULL,
 CONSTRAINT [PK_lookup2] PRIMARY KEY CLUSTERED
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[lookup1](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[code] [nvarchar](10) NOT NULL,
	[description] [nvarchar](50) NULL,
 CONSTRAINT [PK_lookup1] PRIMARY KEY CLUSTERED
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


INSERT INTO lookup1(code, [description]) VALUES('A1', 'a one');
INSERT INTO lookup1(code, [description]) VALUES('A2', 'a two');
INSERT INTO lookup1(code, [description]) VALUES('A3', 'a three');
INSERT INTO lookup1(code, [description]) VALUES('A4', 'a four');

INSERT INTO lookup2(code, [description]) VALUES('B1', 'b one');
INSERT INTO lookup2(code, [description]) VALUES('B2', 'b two');
GO