[geeklog-cvs] Geeklog-1.x/sql/updates mssql_1.5.0_to_1.5.1.php, 1.1, 1.2 mysql_1.5.0_to_1.5.1.php, 1.1, 1.2

[Dirk Haun]

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

Modified Files:
	mssql_1.5.0_to_1.5.1.php mysql_1.5.0_to_1.5.1.php 
Log Message:
Renamed the syndication feed type "geeklog" to "article" since that's what they are nowadays


Index: mssql_1.5.0_to_1.5.1.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mssql_1.5.0_to_1.5.1.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mssql_1.5.0_to_1.5.1.php	13 Jul 2008 12:03:59 -0000	1.1
--- mssql_1.5.0_to_1.5.1.php	27 Jul 2008 09:11:31 -0000	1.2
***************
*** 2,5 ****
--- 2,7 ----
  
  $_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('database_version', '0.0.0')";
+ $_SQL[] = "UPDATE {$_TABLES['syndication']} SET type = 'article' WHERE type = 'geeklog'";
+ $_SQL[] = "UPDATE {$_TABLES['syndication']} SET type = 'article' WHERE type = 'glfusion'";
  
  ?>

Index: mysql_1.5.0_to_1.5.1.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.5.0_to_1.5.1.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_1.5.0_to_1.5.1.php	13 Jul 2008 12:03:59 -0000	1.1
--- mysql_1.5.0_to_1.5.1.php	27 Jul 2008 09:11:31 -0000	1.2
***************
*** 2,5 ****
--- 2,8 ----
  
  $_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('database_version', '0.0.0')";
+ $_SQL[] = "ALTER TABLE {$_TABLES['syndication']} CHANGE type type varchar(30) NOT NULL default 'article'";
+ $_SQL[] = "UPDATE {$_TABLES['syndication']} SET type = 'article' WHERE type = 'geeklog'";
+ $_SQL[] = "UPDATE {$_TABLES['syndication']} SET type = 'article' WHERE type = 'glfusion'";
  
  ?>