[geeklog-cvs] Geeklog-1.x/sql mssql_tableanddata.php,1.38,1.39

[Michael Jervis]

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

Modified Files:
	mssql_tableanddata.php 
Log Message:
More upgrade updates.

Index: mssql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mssql_tableanddata.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** mssql_tableanddata.php	13 May 2008 18:47:14 -0000	1.38
--- mssql_tableanddata.php	23 May 2008 17:25:29 -0000	1.39
***************
*** 836,839 ****
--- 836,843 ----
  ";
  
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollanswers']}] ADD
+     CONSTRAINT [DF_gl_pollanswers_qid] DEFAULT ('0') FOR [qid]
+ ";
+ 
  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollquestions']}] ADD
      CONSTRAINT [PK_gl_pollquestions] PRIMARY KEY  CLUSTERED
***************
*** 998,1001 ****
--- 1002,1006 ----
      CONSTRAINT [DF_gl_userprefs_emailfromuser] DEFAULT (0) FOR [emailfromuser],
      CONSTRAINT [DF_gl_userprefs_showonline] DEFAULT (0) FOR [showonline],
+     CONSTRAINT [DF_gl_userprefs_tzid] DEFAULT ('') FOR [tzid],
      CONSTRAINT [PK_gl_userprefs] PRIMARY KEY  CLUSTERED
      (