KfnTMGpp

1USE [VICODB]
2GO
3
4IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_SEQUENCEPROPERTYTITLE_IS_GROUP]') AND type = 'D')
5BEGIN
6ALTER TABLE [dbo].[SEQUENCEPROPERTYTITLE] DROP CONSTRAINT [DF_SEQUENCEPROPERTYTITLE_IS_GROUP]
7END
8
9GO
10
11IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_SEQUENCEPROPERTYTITLE_IS_ACTIVE]') AND type = 'D')
12BEGIN
13ALTER TABLE [dbo].[SEQUENCEPROPERTYTITLE] DROP CONSTRAINT [DF_SEQUENCEPROPERTYTITLE_IS_ACTIVE]
14END
15
16GO
17
18USE [VICODB]
19GO
20
21/****** Object:  Table [dbo].[SEQUENCEPROPERTYTITLE]    Script Date: 11/22/2011 11:37:11 ******/
22IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SEQUENCEPROPERTYTITLE]') AND type in (N'U'))
23DROP TABLE [dbo].[SEQUENCEPROPERTYTITLE]
24GO
25
26USE [VICODB]
27GO
28
29/****** Object:  Table [dbo].[SEQUENCEPROPERTYTITLE]    Script Date: 11/22/2011 11:37:11 ******/
30SET ANSI_NULLS ON
31GO
32
33SET QUOTED_IDENTIFIER ON
34GO
35
36CREATE TABLE [dbo].[SEQUENCEPROPERTYTITLE](
37	[TITLE_ID] [int] NOT NULL,
38	[NAME] [nvarchar](100) NOT NULL,
39	[IS_GROUP] [int] NOT NULL,
40	[IS_ACTIVE] [int] NOT NULL,
41 CONSTRAINT [PK_SEQUENCEPROPERTY] PRIMARY KEY CLUSTERED 
42(
43	[TITLE_ID] ASC
44)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
45) ON [PRIMARY]
46
47GO
48
49ALTER TABLE [dbo].[SEQUENCEPROPERTYTITLE] ADD  CONSTRAINT [DF_SEQUENCEPROPERTYTITLE_IS_GROUP]  DEFAULT ((0)) FOR [IS_GROUP]
50GO
51
52ALTER TABLE [dbo].[SEQUENCEPROPERTYTITLE] ADD  CONSTRAINT [DF_SEQUENCEPROPERTYTITLE_IS_ACTIVE]  DEFAULT ((1)) FOR [IS_ACTIVE]
53GO
54
55USE [VICODB]
56GO
57
58/****** Object:  Table [dbo].[SEQUENCEPROPERTY]    Script Date: 11/22/2011 11:36:42 ******/
59IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SEQUENCEPROPERTY]') AND type in (N'U'))
60DROP TABLE [dbo].[SEQUENCEPROPERTY]
61GO
62
63USE [VICODB]
64GO
65
66/****** Object:  Table [dbo].[SEQUENCEPROPERTY]    Script Date: 11/22/2011 11:36:42 ******/
67SET ANSI_NULLS ON
68GO
69
70SET QUOTED_IDENTIFIER ON
71GO
72
73CREATE TABLE [dbo].[SEQUENCEPROPERTY](
74	[SEQUENCE_ID] [int] NOT NULL,
75	[PROPERTY_HIERARCHY_CHILD_ID] [int] NOT NULL,
76 CONSTRAINT [PK_SEQUENCEPROPERTY_1] PRIMARY KEY CLUSTERED 
77(
78	[SEQUENCE_ID] ASC,
79	[PROPERTY_HIERARCHY_CHILD_ID] ASC
80)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
81) ON [PRIMARY]
82
83GO
84
85USE [VICODB]
86GO
87
88IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_SEQUENCEPROPERTYHIERARCHY_IS_ACTIVE]') AND type = 'D')
89BEGIN
90ALTER TABLE [dbo].[SEQUENCEPROPERTYHIERARCHY] DROP CONSTRAINT [DF_SEQUENCEPROPERTYHIERARCHY_IS_ACTIVE]
91END
92
93GO
94
95USE [VICODB]
96GO
97
98/****** Object:  Table [dbo].[SEQUENCEPROPERTYHIERARCHY]    Script Date: 11/22/2011 11:36:49 ******/
99IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SEQUENCEPROPERTYHIERARCHY]') AND type in (N'U'))
100DROP TABLE [dbo].[SEQUENCEPROPERTYHIERARCHY]
101GO
102
103USE [VICODB]
104GO
105
106/****** Object:  Table [dbo].[SEQUENCEPROPERTYHIERARCHY]    Script Date: 11/22/2011 11:36:49 ******/
107SET ANSI_NULLS ON
108GO
109
110SET QUOTED_IDENTIFIER ON
111GO
112
113CREATE TABLE [dbo].[SEQUENCEPROPERTYHIERARCHY](
114	[PARENT_ID] [int] NOT NULL,
115	[CHILD_ID] [int] NOT NULL,
116	[IS_ACTIVE] [int] NOT NULL,
117 CONSTRAINT [PK_SEQUENCEPROPERTYHIERARCHY_1] PRIMARY KEY CLUSTERED 
118(
119	[PARENT_ID] ASC,
120	[CHILD_ID] ASC
121)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
122) ON [PRIMARY]
123
124GO
125
126ALTER TABLE [dbo].[SEQUENCEPROPERTYHIERARCHY] ADD  CONSTRAINT [DF_SEQUENCEPROPERTYHIERARCHY_IS_ACTIVE]  DEFAULT ((1)) FOR [IS_ACTIVE]
127GO