[geeklog-cvs] Geeklog-1.x/sql/updates mssql_1.4.1_to_1.5.0.php, 1.11, 1.12 mysql_1.4.1_to_1.5.0.php, 1.64, 1.65

[Michael Jervis]

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

Modified Files:
	mssql_1.4.1_to_1.5.0.php mysql_1.4.1_to_1.5.0.php 
Log Message:
Security changes.

Index: mssql_1.4.1_to_1.5.0.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mssql_1.4.1_to_1.5.0.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** mssql_1.4.1_to_1.5.0.php	27 Jan 2008 10:53:03 -0000	1.11
--- mssql_1.4.1_to_1.5.0.php	21 Feb 2008 19:52:53 -0000	1.12
***************
*** 30,33 ****
--- 30,50 ----
  
   */
+  
+  $_SQL[] = "
+ CREATE TABLE {$_TABLES['tokens']} (
+     [token] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+     [created] [datetime] NOT NULL,
+     [owner_id] [numeric] (8,0) NOT NULL,
+     [urlfor] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+     [ttl] numeric(8,0) NOT NULL DEFAULT 1
+ ) ON [PRIMARY]
+ ";
+  
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['tokens']}] ADD
+     CONSTRAINT [PK_gl_tokens] PRIMARY KEY  CLUSTERED
+     (
+         [toekn]
+     )  ON [PRIMARY]
+ ";
  
  

Index: mysql_1.4.1_to_1.5.0.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.4.1_to_1.5.0.php,v
retrieving revision 1.64
retrieving revision 1.65
diff -C2 -d -r1.64 -r1.65
*** mysql_1.4.1_to_1.5.0.php	10 Feb 2008 17:09:38 -0000	1.64
--- mysql_1.4.1_to_1.5.0.php	21 Feb 2008 19:52:53 -0000	1.65
***************
*** 27,30 ****
--- 27,42 ----
  $_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr, grp_gl_core) VALUES ('Webservices Users', 'Can use the Webservices API (if restricted)', 0)";
  
+ // add the security tokens table:
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['tokens']} (
+     token varchar(32) NOT NULL,
+     created datetime NOT NULL,
+     owner_id mediumint(8) unsigned NOT NULL,
+     urlfor varchar(2000) NOT NULL,
+     ttl mediumint(8) unsigned NOT NULL default '1',
+     PRIMARY KEY (token)
+ ) TYPE=MyISAM
+ ";
+ 
  
  function create_ConfValues()