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
53 lines (44 loc) · 3.99 KB
/
Copy pathreg_tests.sql
File metadata and controls
53 lines (44 loc) · 3.99 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
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