[geeklog-cvs] Geeklog-1.x/plugins/polls/sql mssql_install.php, 1.5, 1.6

[Michael Jervis]

Update of /cvsroot/geeklog/Geeklog-1.x/plugins/polls/sql
In directory qs1489.pair.com:/tmp/cvs-serv42964/plugins/polls/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/polls/sql/mssql_install.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** mssql_install.php	13 May 2008 18:49:54 -0000	1.5
--- mssql_install.php	12 Aug 2008 18:13:34 -0000	1.6
***************
*** 84,88 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollanswers']}] ADD
!     CONSTRAINT [PK_gl_pollanswers] PRIMARY KEY  CLUSTERED
      (
          [qid],
--- 84,88 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollanswers']}] ADD
!     CONSTRAINT [PK_{$_TABLES['pollanswers']}] PRIMARY KEY  CLUSTERED
      (
          [qid],
***************
*** 92,96 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollquestions']}] ADD
!     CONSTRAINT [PK_gl_pollquestions] PRIMARY KEY  CLUSTERED
      (
          [qid]
--- 92,96 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollquestions']}] ADD
!     CONSTRAINT [PK_{$_TABLES['pollquestions']}] PRIMARY KEY  CLUSTERED
      (
          [qid]
***************
*** 99,103 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['polltopics']}] ADD
!     CONSTRAINT [PK_gl_polltopics] PRIMARY KEY  CLUSTERED
      (
          [pid]
--- 99,103 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['polltopics']}] ADD
!     CONSTRAINT [PK_{$_TABLES['polltopics']}] PRIMARY KEY  CLUSTERED
      (
          [pid]
***************
*** 106,110 ****
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollvoters']}] ADD
!     CONSTRAINT [PK_gl_pollvoters] PRIMARY KEY  CLUSTERED
      (
          [id]
--- 106,110 ----
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollvoters']}] ADD
!     CONSTRAINT [PK_{$_TABLES['pollvoters']}] PRIMARY KEY  CLUSTERED
      (
          [id]