[geeklog-cvs] geeklog: Fixed create tables in MSSQL Mode.

[geeklog-cvs at lists.geeklog.net]

details:   http://project.geeklog.net/cgi-bin/hgweb.cgi/rev/b01aaa1858c2
changeset: 6948:b01aaa1858c2
user:      Mike Jervis <mike at fuckingbrit.com>
date:      Thu Apr 16 19:37:23 2009 +0100
description:
Fixed create tables in MSSQL Mode.

diffstat:

1 file changed, 39 insertions(+), 32 deletions(-)
sql/mssql_tableanddata.php |   71 ++++++++++++++++++++++++--------------------

diffs (101 lines):

diff -r deca272b55c8 -r b01aaa1858c2 sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php	Wed Apr 15 20:24:04 2009 +0200
+++ b/sql/mssql_tableanddata.php	Thu Apr 16 19:37:23 2009 +0100
@@ -73,16 +73,18 @@
 ) ON [PRIMARY]
 ";
 
-/* FIXME - MySQL syntax
 $_SQL[] = "
-CREATE TABLE {$_TABLES['commentedits']} (
-  cid int(10) NOT NULL,
-  uid mediumint(8) NOT NULL,
-  time datetime NOT NULL,
-  PRIMARY KEY (cid)
-) TYPE=MyISAM
+CREATE TABLE [dbo].[{$_TABLES['commentedits']}] (
+  [cid] [int] NOT NULL,
+  [uid] [int] NOT NULL,
+  [time] [datetime] NOT NULL,
+) ON [PRIMARY]
 ";
-*/
+
+$_SQL[] = "
+ALTER TABLE [dbo].[{$_TABLES['commentedits']}] ADD CONSTRAINT
+[PK_{$_TABLES['commentedits']}] PRIMARY KEY CLUSTERED ([cid]) ON [PRIMARY]
+";
 
 $_SQL[] = "
 CREATE TABLE [dbo].[{$_TABLES['commentmodes']}] (
@@ -91,17 +93,20 @@
 ) ON [PRIMARY]
 ";
 
-/* FIXME - MySQL syntax
 $_SQL[] = "
-CREATE TABLE {$_TABLES['commentnotifications']} (
-  cid int(10) default NULL,
-  uid mediumint(8) NOT NULL,
-  deletehash varchar(32) NOT NULL,
-  mid int(10) default NULL,
-  PRIMARY KEY  (deletehash)
-) TYPE=MyISAM 
+CREATE TABLE [dbo].[{$_TABLES['commentnotifications']}](
+  [cid] [INT] NOT NULL,
+  [uid] [INT] NOT NULL,
+  [deletehash] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+  [mid] [INT] DEFAULT NULL
+) ON [PRIMARY]
 ";
-*/
+
+$_SQL[] = "
+ALTER TABLE [dbo].[{$_TABLES['commentnotifications']}] ADD CONSTRAINT
+[PK_{$_TABLES['commentnotifications']}] PRIMARY KEY CLUSTERED ([cid]) ON [PRIMARY]
+";
+
 
 $_SQL[] = "
 CREATE TABLE [dbo].[{$_TABLES['comments']}] (
@@ -123,23 +128,25 @@
 ) ON [PRIMARY]
 ";
 
-/* FIXME - MySQL syntax
 $_SQL[] = "
-CREATE TABLE {$_TABLES['commentsubmissions']} (
-  cid int(10) unsigned NOT NULL auto_increment,
-  type varchar(30) NOT NULL default 'article',
-  sid varchar(40) NOT NULL,
-  date datetime default NULL,
-  title varchar(128) default NULL,
-  comment text,
-  uid mediumint(8) NOT NULL default '1',
-  name varchar(32) default NULL,
-  pid int(10) NOT NULL default '0',
-  ipaddress varchar(15) NOT NULL,
-  PRIMARY KEY  (cid)
-) TYPE=MyISAM
+CREATE TABLE [dbo].[{$_TABLES['commentsubmissions']}] (
+  [cid] [int] IDENTITY (1,1) NOT NULL,
+  [type] [varchar] (30) NOT NULL default 'article',
+  [sid] [varchar](40) NOT NULL,
+  [date] [datetime] default NULL,
+  [title] [varchar] (128) default NULL,
+  [comment] [NTEXT],
+  [uid] [INT] NOT NULL default '1',
+  [name] [varchar] (32) default NULL,
+  [pid] [INT] NOT NULL default '0',
+  [ipaddress] [varchar](15) NOT NULL
+) ON [PRIMARY]
 ";
-*/
+
+$_SQL[] = "
+ALTER TABLE [dbo].[{$_TABLES['commentsubmissions']}] ADD CONSTRAINT
+[PK_{$_TABLES['commentsubmissions']}] PRIMARY KEY CLUSTERED ([cid]) ON [PRIMARY]
+";
 
 $_SQL[] = "
 CREATE TABLE [dbo].[{$_TABLES['conf_values']}] (