-
Notifications
You must be signed in to change notification settings - Fork 14
/
03.05.05.SqlDataProvider
52 lines (33 loc) · 2.15 KB
/
03.05.05.SqlDataProvider
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
/* =====================================================================*/
/***** Initialization Script 03.05.05 *****/
/* =====================================================================*/
/* grmRepositoryCategories */
if exists (select * from dbo.sysindexes
where name = 'IX_{objectQualifier}grmRepositoryCategories')
DROP INDEX {databaseOwner}[{objectQualifier}grmRepositoryCategories].[IX_{objectQualifier}grmRepositoryCategories]
CREATE INDEX [IX_{objectQualifier}grmRepositoryCategories]
ON {databaseOwner}[{objectQualifier}grmRepositoryCategories]([ModuleID])
/* grmRepositoryCategories_1 */
if exists (select * from dbo.sysindexes
where name = 'IX_{objectQualifier}grmRepositoryCategories_1')
DROP INDEX {databaseOwner}[{objectQualifier}grmRepositoryCategories].[IX_{objectQualifier}grmRepositoryCategories_1]
CREATE INDEX [IX_{objectQualifier}grmRepositoryCategories_1]
ON {databaseOwner}[{objectQualifier}grmRepositoryCategories]([Parent])
/* grmRepositoryObjectCategories */
if exists (select * from dbo.sysindexes
where name = 'IX_{objectQualifier}grmRepositoryObjectCategories')
DROP INDEX {databaseOwner}[{objectQualifier}grmRepositoryObjectCategories].[IX_{objectQualifier}grmRepositoryObjectCategories]
CREATE INDEX [IX_{objectQualifier}grmRepositoryObjectCategories]
ON {databaseOwner}[{objectQualifier}grmRepositoryObjectCategories]([CategoryID])
/* grmRepositoryCategories_1 */
if exists (select * from dbo.sysindexes
where name = 'IX_{objectQualifier}grmRepositoryObjectCategories_1')
DROP INDEX {databaseOwner}[{objectQualifier}grmRepositoryObjectCategories].[IX_{objectQualifier}grmRepositoryObjectCategories_1]
CREATE INDEX [IX_{objectQualifier}grmRepositoryObjectCategories_1]
ON {databaseOwner}[{objectQualifier}grmRepositoryObjectCategories]([ObjectID])
/* grmRepositoryObjects_1 */
if exists (select * from dbo.sysindexes
where name = 'IX_{objectQualifier}grmRepositoryObjects_1')
DROP INDEX {databaseOwner}[{objectQualifier}grmRepositoryObjects].[IX_{objectQualifier}grmRepositoryObjects_1]
CREATE INDEX [IX_{objectQualifier}grmRepositoryObjects_1]
ON {databaseOwner}[{objectQualifier}grmRepositoryObjects]([Approved])