[geeklog-cvs] geeklog: MSSQL Database Updates

[geeklog-cvs at lists.geeklog.net]

changeset 8493:9abf895deede
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/9abf895deede
user: vinny
date: Sun Feb 19 11:03:41 2012 -0700
description:
MSSQL Database Updates

diffstat:

 sql/mssql_tableanddata.php           |   6 ++++--
 sql/updates/mssql_1.8.1_to_1.9.0.php |  10 +++++-----
 2 files changed, 9 insertions(+), 7 deletions(-)

diffs (43 lines):

diff -r 3815f6dbcfc4 -r 9abf895deede sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php	Mon Feb 13 22:54:36 2012 -0700
+++ b/sql/mssql_tableanddata.php	Sun Feb 19 11:03:41 2012 -0700
@@ -474,7 +474,6 @@
 ) ON [PRIMARY]
 ";
 
-// *** FIXME *** password update
 $_SQL[] = "
 CREATE TABLE [dbo].[{$_TABLES['users']}] (
     [uid] [int] IDENTITY (1, 1) NOT NULL ,
@@ -482,7 +481,10 @@
     [remoteusername] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [remoteservice] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [fullname] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
-    [passwd] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+    [passwd] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+    [salt] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL default '' ,
+    [algorithm] [tinyint] NOT NULL default '0' ,
+    [stretch] [int] NOT NULL default '1' ,
     [email] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [homepage] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [sig] [varchar] (160) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
diff -r 3815f6dbcfc4 -r 9abf895deede sql/updates/mssql_1.8.1_to_1.9.0.php
--- a/sql/updates/mssql_1.8.1_to_1.9.0.php	Mon Feb 13 22:54:36 2012 -0700
+++ b/sql/updates/mssql_1.8.1_to_1.9.0.php	Sun Feb 19 11:03:41 2012 -0700
@@ -20,11 +20,11 @@
 $_SQL[] = "ALTER TABLE {$_TABLES['sessions']} ADD [whos_online] [tinyint] NOT NULL AFTER [md5_sess_id]";
 $_SQL[] = "ALTER TABLE {$_TABLES['sessions']} ADD [topic] [varchar] (20) NOT NULL AFTER [whos_online]";
 
-// Password Updates *** FIXME ***
-// $_SQL[] = "ALTER TABLE {$_TABLES['users']} MODIFY passwd varchar(128) NOT NULL default ''";
-// $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD salt varchar(64) NOT NULL default '' AFTER passwd";
-// $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD algorithm tinyint(3) NOT NULL default 0 AFTER salt";
-// $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD stretch int(8) unsigned NOT NULL default 1 AFTER algorithm";
+// Password Updates
+$_SQL[] = "ALTER TABLE {$_TABLES['users']} ALTER COLUMN [passwd] [varchar] (128) NOT NULL default ''";
+$_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD [salt] [varchar] (64) NOT NULL default '' AFTER [passwd]";
+$_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD [algorithm] [tinyint] NOT NULL default '0' AFTER [salt]";
+$_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD [stretch] [int] NOT NULL default '1' AFTER [algorithm]";
 
 /**
  * Create Story and Submission Topic assignments