[geeklog-cvs] Geeklog-1.x/plugins/links/sql mysql_install.php, 1.3, 1.4 upgrade_1.0.1_2.mysql.php, 1.1, 1.2

[Oliver]

Update of /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/plugins/links/sql
In directory qs1489.pair.com:/tmp/cvs-serv65953/sql

Modified Files:
	mysql_install.php upgrade_1.0.1_2.mysql.php 
Log Message:
fix upgrade code

Index: upgrade_1.0.1_2.mysql.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/upgrade_1.0.1_2.mysql.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** upgrade_1.0.1_2.mysql.php	28 Aug 2007 07:33:30 -0000	1.1
--- upgrade_1.0.1_2.mysql.php	28 Aug 2007 07:52:26 -0000	1.2
***************
*** 26,30 ****
  $LINKS_SQL['getcategories'] = "SELECT DISTINCT category FROM {$_TABLES['links']}";
  
! $LINKS_SQL['linksubmission'] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE category cid varchar(20) NOT NULL";
  
  $LINKS_SQL['links'] = "ALTER TABLE {$_TABLES['links']} CHANGE category cid varchar(20) NOT NULL";
--- 26,32 ----
  $LINKS_SQL['getcategories'] = "SELECT DISTINCT category FROM {$_TABLES['links']}";
  
! // add owner-field to links-submission
! $LINKS_SQL['linksubmission1'] = "ALTER TABLE {$_TABLES['linksubmission']} ADD owner_id mediumint(8) unsigned NOT NULL default '1';";
! $LINKS_SQL['linksubmission2'] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE category cid varchar(20) NOT NULL";
  
  $LINKS_SQL['links'] = "ALTER TABLE {$_TABLES['links']} CHANGE category cid varchar(20) NOT NULL";

Index: mysql_install.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/mysql_install.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_install.php	28 Aug 2007 07:33:30 -0000	1.3
--- mysql_install.php	28 Aug 2007 07:52:26 -0000	1.4
***************
*** 83,86 ****
--- 83,87 ----
    hits int(11) default NULL,
    date datetime default NULL,
+   owner_id mediumint(8) NOT NULL default '1',
    PRIMARY KEY (lid)
  ) TYPE=MyISAM