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

[Dirk Haun]

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

Modified Files:
	mssql_install.php 
Log Message:
An attempt to update the MS SQL for the plugin installs (and no, I don't know what I'm doing ...)


Index: mssql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/mssql_install.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** mssql_install.php	12 Apr 2008 13:21:34 -0000	1.6
--- mssql_install.php	2 May 2008 12:08:07 -0000	1.7
***************
*** 3,7 ****
  /* Reminder: always indent with 4 spaces (no tabs). */
  // +---------------------------------------------------------------------------+
! // | Links Plugin 1.0                                                          |
  // +---------------------------------------------------------------------------+
  // | Installation SQL                                                          |
--- 3,7 ----
  /* Reminder: always indent with 4 spaces (no tabs). */
  // +---------------------------------------------------------------------------+
! // | Links Plugin 2.0                                                          |
  // +---------------------------------------------------------------------------+
  // | Installation SQL                                                          |
***************
*** 51,59 ****
  
  
  
!  $_SQL[] = "
  CREATE TABLE [dbo].[{$_TABLES['links']}] (
      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
!     [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
--- 51,76 ----
  
  
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['linkcategories']}] (
+     [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+     [pid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+     [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+     [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+     [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+     [created] [datetime] NULL ,
+     [modified] [datetime] NULL ,
+     [owner_id] [numeric](8, 0) NOT NULL ,
+     [group_id] [numeric](8, 0) NOT NULL ,
+     [perm_owner] [tinyint] NOT NULL ,
+     [perm_group] [tinyint] NOT NULL ,
+     [perm_members] [tinyint] NOT NULL ,
+     [perm_anon] [tinyint] NOT NULL
+ ) ON [PRIMARY]
+ ";
  
! $_SQL[] = "
  CREATE TABLE [dbo].[{$_TABLES['links']}] (
      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
!     [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
***************
*** 67,86 ****
      [perm_members] [tinyint] NOT NULL ,
      [perm_anon] [tinyint] NOT NULL
! ) ON [PRIMARY] 
  ";
  
- 
  $_SQL[] = "
  CREATE TABLE [dbo].[{$_TABLES['linksubmission']}] (
      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
!     [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [hits] [int] NULL ,
!     [date] [datetime] NULL
! ) ON [PRIMARY] 
  ";
  
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
--- 84,109 ----
      [perm_members] [tinyint] NOT NULL ,
      [perm_anon] [tinyint] NOT NULL
! ) ON [PRIMARY]
  ";
  
  $_SQL[] = "
  CREATE TABLE [dbo].[{$_TABLES['linksubmission']}] (
      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
!     [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [hits] [int] NULL ,
!     [date] [datetime] NULL ,
!     [owner_id] [numeric](8, 0) NOT NULL
! ) ON [PRIMARY]
  ";
  
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linkcategories']}] ADD
+     CONSTRAINT [PK_gl_linkcategories] PRIMARY KEY  CLUSTERED
+     (
+         [pid]
+     )  ON [PRIMARY]
+ ";
  
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD