PembsEDs.txt
1 |
/****** Object: Table [GovernmentAreas].[ElectoralDivisions] Script Date: 04/25/2014 09:15:16 ******/ |
---|---|
2 |
SET ANSI_NULLS ON |
3 |
GO |
4 |
|
5 |
SET QUOTED_IDENTIFIER ON |
6 |
GO |
7 |
|
8 |
SET ANSI_PADDING ON |
9 |
GO |
10 |
|
11 |
CREATE TABLE [GovernmentAreas].[ElectoralDivisions]( |
12 |
[ONS_ID] [varchar](10) NULL, |
13 |
[Name] [varchar](60) NULL, |
14 |
[Member_Name] [varchar](35) NULL, |
15 |
[Party] [varchar](30) NULL, |
16 |
[Information] [varchar](150) NULL, |
17 |
[Electorate] [int] NULL, |
18 |
[Enw] [varchar](60) NULL, |
19 |
[Plaid] [varchar](30) NULL, |
20 |
[MI_STYLE] [varchar](254) NULL, |
21 |
[MI_PRINX] [int] IDENTITY(1,1) NOT NULL, |
22 |
[SP_GEOMETRY] [geometry] NULL, |
23 |
PRIMARY KEY CLUSTERED |
24 |
( |
25 |
[MI_PRINX] ASC |
26 |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
27 |
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
28 |
|
29 |
GO |
30 |
|
31 |
SET ANSI_PADDING OFF |
32 |
GO |