[geeklog-cvs] Geeklog-1.x/plugins/links/sql mssql_install.php, 1.7, 1.8

[Michael Jervis]

Update of /cvsroot/geeklog/Geeklog-1.x/plugins/links/sql
In directory qs1489.pair.com:/tmp/cvs-serv42964/plugins/links/sql

Modified Files:
	mssql_install.php 
Log Message:
Fixed table prefix issues with constraints (bug #0000702)

Index: mssql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/mssql_install.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** mssql_install.php	2 May 2008 12:08:07 -0000	1.7
--- mssql_install.php	12 Aug 2008 18:13:33 -0000	1.8
***************
*** 101,105 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linkcategories']}] ADD
!     CONSTRAINT [PK_gl_linkcategories] PRIMARY KEY  CLUSTERED
      (
          [pid]
--- 101,105 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linkcategories']}] ADD
!     CONSTRAINT [PK_{$_TABLES['linkcategories']}] PRIMARY KEY  CLUSTERED
      (
          [pid]
***************
*** 108,117 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
!     CONSTRAINT [DF_gl_links_perm_group] DEFAULT (3) FOR [perm_group],
!     CONSTRAINT [DF_gl_links_perm_anon] DEFAULT (2) FOR [perm_anon],
!     CONSTRAINT [DF_gl_links_perm_members] DEFAULT (2) FOR [perm_members],
!     CONSTRAINT [DF_gl_links_perm_owner] DEFAULT (3) FOR [perm_owner],
!     CONSTRAINT [DF_gl_links_hits] DEFAULT (0) FOR [hits],
!     CONSTRAINT [PK_gl_links] PRIMARY KEY  CLUSTERED
      (
          [lid]
--- 108,117 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
!     CONSTRAINT [DF_{$_TABLES['links']}_perm_group] DEFAULT (3) FOR [perm_group],
!     CONSTRAINT [DF_{$_TABLES['links']}_perm_anon] DEFAULT (2) FOR [perm_anon],
!     CONSTRAINT [DF_{$_TABLES['links']}_perm_members] DEFAULT (2) FOR [perm_members],
!     CONSTRAINT [DF_{$_TABLES['links']}_perm_owner] DEFAULT (3) FOR [perm_owner],
!     CONSTRAINT [DF_{$_TABLES['links']}_hits] DEFAULT (0) FOR [hits],
!     CONSTRAINT [PK_{$_TABLES['links']}] PRIMARY KEY  CLUSTERED
      (
          [lid]
***************
*** 120,124 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linksubmission']}] ADD
!     CONSTRAINT [PK_gl_linksubmission] PRIMARY KEY  CLUSTERED
      (
          [lid]
--- 120,124 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linksubmission']}] ADD
!     CONSTRAINT [PK_{$_TABLES['linksubmission']}] PRIMARY KEY  CLUSTERED
      (
          [lid]