diff options
Diffstat (limited to 'src/odbc/mssql2000.sql')
| -rw-r--r-- | src/odbc/mssql2000.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/src/odbc/mssql2000.sql b/src/odbc/mssql2000.sql index 1bb93d783..89429a210 100644 --- a/src/odbc/mssql2000.sql +++ b/src/odbc/mssql2000.sql @@ -209,6 +209,14 @@ CREATE TABLE [dbo].[privacy_list_data] ( ) ON [PRIMARY]
GO
+/* Not tested on mssql */
+CREATE TABLE [dbo].[roster_version] (
+ [username] [varchar] (250) NOT NULL ,
+ [version] [varchar] (64) NOT NULL
+) ON [PRIMARY]
+GO
+
+
/* Constraints to add:
- id in privacy_list is a SERIAL autogenerated number
- id in privacy_list_data must exist in the table privacy_list */
@@ -244,6 +252,13 @@ ALTER TABLE [dbo].[users] WITH NOCHECK ADD ) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
+ALTER TABLE [dbo].[roster_version] WITH NOCHECK ADD
+ CONSTRAINT [PK_roster_version] PRIMARY KEY CLUSTERED
+ (
+ [username]
+ ) WITH FILLFACTOR = 90 ON [PRIMARY]
+GO
+
ALTER TABLE [dbo].[vcard] WITH NOCHECK ADD
CONSTRAINT [PK_vcard] PRIMARY KEY CLUSTERED
(
@@ -275,6 +290,8 @@ ALTER TABLE [dbo].[privacy_default_list] WITH NOCHECK ADD ) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
+
+
CREATE INDEX [IX_rostergroups_jid] ON [dbo].[rostergroups]([jid]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
|