[geeklog-cvs] Geeklog-1.x/sql mssql_tableanddata.php, 1.33, 1.34 mysql_tableanddata.php, 1.200, 1.201

[Michael Jervis]

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

Modified Files:
	mssql_tableanddata.php mysql_tableanddata.php 
Log Message:
Security changes.

Index: mssql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mssql_tableanddata.php,v
retrieving revision 1.33
retrieving revision 1.34
diff -C2 -d -r1.33 -r1.34
*** mssql_tableanddata.php	27 Jan 2008 15:23:32 -0000	1.33
--- mssql_tableanddata.php	21 Feb 2008 19:52:52 -0000	1.34
***************
*** 517,520 ****
--- 517,530 ----
  ";
  
+ $_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[] = "
***************
*** 910,913 ****
--- 920,930 ----
      (
          [fid]
+     )  ON [PRIMARY]
+ ";
+ 
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['tokens']}] ADD
+     CONSTRAINT [PK_gl_tokens] PRIMARY KEY  CLUSTERED
+     (
+         [toekn]
      )  ON [PRIMARY]
  ";

Index: mysql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mysql_tableanddata.php,v
retrieving revision 1.200
retrieving revision 1.201
diff -C2 -d -r1.200 -r1.201
*** mysql_tableanddata.php	3 Feb 2008 19:11:50 -0000	1.200
--- mysql_tableanddata.php	21 Feb 2008 19:52:53 -0000	1.201
***************
*** 724,727 ****
--- 724,738 ----
  ";
  
+ $_SQL[47] = "
+ 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
+ ";
+ 
  $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) ";
  $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (2,3) ";