forked from dalibo/sqlserver2pgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathreg_tests.sql
More file actions
131 lines (114 loc) · 9.33 KB
/
Copy pathreg_tests.sql
File metadata and controls
131 lines (114 loc) · 9.33 KB
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
CREATE TABLE [dbo].[TestTable](
[NUM_FOLIO] [int] NOT NULL,
[FOLIO_ID] [int] NOT NULL,
[DESCRIPTION] [char](50) NULL,
[EN_COURS] [char](1) NULL,
CONSTRAINT [PK_TEST_TABLE] PRIMARY KEY NONCLUSTERED
(
[NUM_FOLIO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[adjudicaciones](
[id_comunicado] [int] NOT NULL,
CONSTRAINT [pk_adjudicaciones] PRIMARY KEY NONCLUSTERED
(
[id_comunicado] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TestTable] WITH CHECK ADD CONSTRAINT [NUM_FOLIO] CHECK ((([NUM_FOLIO]>=(0) AND [NUM_FOLIO]<=(999999)) OR ([NUM_FOLIO]>=(2000000) AND [NUM_FOLIO]<=(3000000))))
GO
ALTER TABLE [dbo].[TestTable] WITH CHECK ADD CONSTRAINT [FOLIO_ID] CHECK ((([NUM_FOLIO]>=(0) AND [NUM_FOLIO]<=(999999)) OR ([NUM_FOLIO]>=(2000000) AND [NUM_FOLIO]<=(3000000)) OR ([NUM_FOLIO]>=(4000000) AND [NUM_FOLIO]<=(5000000))))
GO
ALTER TABLE [dbo].[TestTable] WITH NOCHECK ADD CONSTRAINT [FOLIO_range] CHECK NOT FOR REPLICATION (([FOLIO_ID]>(23580007) AND [FOLIO_ID]<=(23581007) OR [FOLIO_ID]>(23581007) AND [FOLIO_ID]<=(23582007)))
GO
ALTER TABLE [dbo].[TestTable] WITH CHECK ADD CONSTRAINT [FK_adjudicaciones] FOREIGN KEY([FOLIO_ID])
REFERENCES [dbo].[adjudicaciones] ([id_comunicado])
GO
CREATE NONCLUSTERED INDEX [idx_FOLIO_ID] ON [dbo].[TestTable]
(
[FOLIO_ID] ASC
)
WHERE ((ISNULL([FOLIO_ID], 0) > 1))
GO
CREATE TABLE [dbo].[TestPrimaryKey](
[ID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TestPrimaryKey] WITH NOCHECK ADD CONSTRAINT [PK_TestPrimaryKey] PRIMARY KEY CLUSTERED (
[ID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
ALTER TABLE [dbo].[TestPrimaryKey] WITH NOCHECK ADD CONSTRAINT [id_value] CHECK NOT FOR REPLICATION (([ID]>(23580007) AND [ID]<=(23581007)) OR ([ID]>(23581007) AND [ID]<=(23582007)))
GO
CREATE TABLE [dbo].[DefaultValue](
[ValueId] [int] NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=10000000),
[BooleanZeroValue] [bit] NOT NULL DEFAULT ((0)),
[BooleanOneValue] [bit] NOT NULL DEFAULT ((1)),
[TinyIntegerZeroValue] [tinyint] NOT NULL DEFAULT ((0)),
[SmallIntegerZeroValue] [smallint] NOT NULL DEFAULT ((0)),
[IntegerZeroValue] [int] NOT NULL DEFAULT ((0)),
[LargeIntegerZeroValue] [bigint] NOT NULL DEFAULT ((0)),
[TinyIntegerMaxValue] [tinyint] NOT NULL DEFAULT ((255)),
[SmallIntegerMaxValue] [smallint] NOT NULL DEFAULT ((32767)),
[IntegerMaxValue] [int] NOT NULL DEFAULT ((2147483647)),
[LargeIntegerMaxValue] [bigint] NOT NULL DEFAULT ((9223372036854775807)),
[FloatZeroValue] [float] NOT NULL DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[DEALER_PROFILE](
[DealerCode] [varchar](20) NOT NULL,
[DealerName] [varchar](30) NOT NULL,
[RegionCode] [char](2) NOT NULL,
[SalesDistrictCode] [char](2) NULL,
[ServiceDistrictCode] [char](2) NULL,
[Address1] [varchar](30) NULL,
[Address2] [varchar](30) NULL,
[Address3] [varchar](30) NULL,
[City] [varchar](25) NULL,
[Province] [char](3) NULL,
[PostalCode] [char](7) NULL,
[OperationsStartDate] [date] NULL,
[TerminationDate] [date] NULL,
[StatusCode] [char](1) NULL,
[FacilityTypeCode] [char](1) NULL,
[ShowroomCode] [bit] NULL CONSTRAINT [DF_DEALER_PROFILE_ShowroomCode] DEFAULT ((0)),
[LanguageCode] [char](2) NULL,
[Phone] [char](10) NULL,
[Fax] [char](10) NULL,
[IsActive] [bit] NULL,
[DealerPrefix] [varchar](20) NULL,
[RegionDescription] [nvarchar](50) NULL,
[ZoneCode] [char](2) NULL,
[ZoneDescription] [nvarchar](50) NULL,
[ModifiedBy] [varchar](50) NOT NULL CONSTRAINT [DF_DEALER_PROFILE_ModifiedBy] DEFAULT (user_name()),
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_DEALER_PROFILE_ModifiedDate] DEFAULT (getdate()),
[CreatedBy] [varchar](50) NOT NULL CONSTRAINT [DF_DEALER_PROFILE_CreatedBy] DEFAULT (user_name()),
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_DEALER_PROFILE_CreatedDate] DEFAULT (getdate()),
[DealerSalesGroupId] [int] NULL,
[DisplayDealerName] [varchar](100) NULL
CONSTRAINT [PK_DEALER_PROFILE] PRIMARY KEY CLUSTERED
(
[DealerCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [reflex].[HFMNLTP](
[ID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HFMNLTL2] ON [reflex].[HFMNLTP]
(
[ID] ASC
)
GO
ALTER INDEX [HFMNLTL2] ON [reflex].[HFMNLTP] DISABLE
GO
CREATE NONCLUSTERED INDEX [HFMNLTL2_COND] ON [reflex].[HFMNLTP]
(
[ID] ASC
)
WHERE ((ID) > 10))
GO
ALTER INDEX [HFMNLTL2_COND] ON [reflex].[HFMNLTP] DISABLE
GO