[geeklog-devel] MS SQL Upgrade

[Randy Kolenko]

> 

> In the MySQL db schema, the primary key is

> 

>   PRIMARY KEY (qid, pid)

> 

> whereas in the MS SQL schema, only qid is the primary key. 

> That looks like the problem to me.

> 



True -- its one of the problems.  The other is that the qid column needs
a default value of '0' as shown here in the mysql install sql:

$_SQL[] = "
CREATE TABLE {$_TABLES['pollquestions']} (
  qid mediumint(9) NOT NULL DEFAULT '0',
  pid varchar(20) NOT NULL,
  question varchar(255) NOT NULL,
  PRIMARY KEY (qid, pid)
) TYPE=MyISAM
";


Which now means that we have to alter the mssql version to look like
this:



CREATE TABLE [dbo].[gl_pollquestions] (
	[qid] [int] NOT NULL ,
	[pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
	[question] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[gl_pollquestions] ADD 
	CONSTRAINT [DF_gl_pollquestions_qid] DEFAULT (0) FOR [qid],
	CONSTRAINT [PK_gl_pollquestions] PRIMARY KEY  CLUSTERED 
	(
		[qid],
		[pid]
	)  ON [PRIMARY] 
GO