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

Oliver ospiess at qs1489.pair.com
Tue Aug 28 03:33:33 EDT 2007 

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

Modified Files:
	mssql_install.php mysql_install.php 
Added Files:
	upgrade_1.0.1_2.mysql.php 
Log Message:
install new links plugin with cateogory tree

Index: mssql_install.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/mssql_install.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** mssql_install.php	13 Feb 2007 03:18:34 -0000	1.4
--- mssql_install.php	28 Aug 2007 07:33:30 -0000	1.5
***************
*** 67,71 ****
      [perm_members] [tinyint] NOT NULL ,
      [perm_anon] [tinyint] NOT NULL
! ) ON [PRIMARY]
  ";
  
--- 67,71 ----
      [perm_members] [tinyint] NOT NULL ,
      [perm_anon] [tinyint] NOT NULL
! ) ON [PRIMARY] 
  ";
  
***************
*** 79,85 ****
      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [hits] [int] NULL ,
!     [date] [datetime] NULL,
!     [owner_id] [numeric](8, 0) NOT NULL
! ) ON [PRIMARY]
  ";
  
--- 79,84 ----
      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [hits] [int] NULL ,
!     [date] [datetime] NULL
! ) ON [PRIMARY] 
  ";
  

--- NEW FILE: upgrade_1.0.1_2.mysql.php ---
<?php

// SQL for updating the links plugin from version 1.0 and 1.0.1 to 2
//

$LINKS_SQL['linkcategories'] = "
CREATE TABLE {$_TABLES['linkcategories']} (
  cid varchar(20) NOT NULL,
  pid varchar(20) NOT NULL,
  category varchar(32) NOT NULL,
  description text DEFAULT NULL,
  tid varchar(20) DEFAULT NULL,
  created datetime DEFAULT NULL,
  modified datetime DEFAULT NULL,
  owner_id mediumint(8) unsigned NOT NULL default '1',
  group_id mediumint(8) unsigned NOT NULL default '1',
  perm_owner tinyint(1) unsigned NOT NULL default '3',
  perm_group tinyint(1) unsigned NOT NULL default '2',
  perm_members tinyint(1) unsigned NOT NULL default '2',
  perm_anon tinyint(1) unsigned NOT NULL default '2',
  PRIMARY KEY (cid),
  KEY links_pid (pid)
) TYPE=MyISAM
";

$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";

$LINKS_SQL['root'] = "INSERT INTO {$_TABLES['linkcategories']} (cid, pid, category, description, tid, created, modified, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('site', 'root', 'Root', 'Website root', '', NOW(), NOW(), 5, 2, 3, 3, 2, 2)";

$LINKS_SQL['linksblock'] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, allow_autotags, rdfurl, rdfupdated, rdflimit, onleft, phpblockfn, help, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (1, 'links_topic_links', 'phpblock', 'Topic Links', 'all', 0, '', 0, '', '0000-00-00 00:00:00', 0, 0, 'phpblock_topic_links', '', 2, {$blockadmin_id}, 3, 3, 2, 2)";

$LINKS_SQL['categoriesblock'] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, allow_autotags, rdfurl, rdfupdated, rdflimit, onleft, phpblockfn, help, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (1, 'links_topic_categories', 'phpblock', 'Topic Categories', 'all', 0, '', 0, '', '0000-00-00 00:00:00', 0, 0, 'phpblock_topic_categories', '', 2, {$blockadmin_id}, 3, 3, 2, 2)";


?>

Index: mysql_install.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/plugins/links/sql/mysql_install.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_install.php	13 Feb 2007 03:18:34 -0000	1.2
--- mysql_install.php	28 Aug 2007 07:33:30 -0000	1.3
***************
*** 56,60 ****
  CREATE TABLE {$_TABLES['links']} (
    lid varchar(20) NOT NULL default '',
!   category varchar(32) default NULL,
    url varchar(255) default NULL,
    description text,
--- 56,60 ----
  CREATE TABLE {$_TABLES['links']} (
    lid varchar(20) NOT NULL default '',
!   cid varchar(20) default NULL,
    url varchar(255) default NULL,
    description text,
***************
*** 68,75 ****
    perm_members tinyint(1) unsigned NOT NULL default '2',
    perm_anon tinyint(1) unsigned NOT NULL default '2',
!   INDEX links_lid(lid),
!   INDEX links_category(category),
!   INDEX links_date(date),
!   PRIMARY KEY  (lid)
  ) TYPE=MyISAM
  ";
--- 68,74 ----
    perm_members tinyint(1) unsigned NOT NULL default '2',
    perm_anon tinyint(1) unsigned NOT NULL default '2',
!   INDEX links_cid (cid),
!   INDEX links_date (date),
!   PRIMARY KEY (lid)
  ) TYPE=MyISAM
  ";
***************
*** 78,82 ****
  CREATE TABLE {$_TABLES['linksubmission']} (
    lid varchar(20) NOT NULL default '',
!   category varchar(32) default NULL,
    url varchar(255) default NULL,
    description text,
--- 77,81 ----
  CREATE TABLE {$_TABLES['linksubmission']} (
    lid varchar(20) NOT NULL default '',
!   cid varchar(20) default NULL,
    url varchar(255) default NULL,
    description text,
***************
*** 84,91 ****
    hits int(11) default NULL,
    date datetime default NULL,
    owner_id mediumint(8) unsigned NOT NULL default '1',
!   PRIMARY KEY  (lid)
  ) TYPE=MyISAM
  ";
  
  ?>
--- 83,114 ----
    hits int(11) default NULL,
    date datetime default NULL,
+   PRIMARY KEY (lid)
+ ) TYPE=MyISAM
+ ";
+ 
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['linkcategories']} (
+   cid varchar(20) NOT NULL,
+   pid varchar(20) NOT NULL,
+   category varchar(32) NOT NULL,
+   description text DEFAULT NULL,
+   tid varchar(20) DEFAULT NULL,
+   created datetime DEFAULT NULL,
+   modified datetime DEFAULT NULL,
    owner_id mediumint(8) unsigned NOT NULL default '1',
!   group_id mediumint(8) unsigned NOT NULL default '1',
!   perm_owner tinyint(1) unsigned NOT NULL default '3',
!   perm_group tinyint(1) unsigned NOT NULL default '2',
!   perm_members tinyint(1) unsigned NOT NULL default '2',
!   perm_anon tinyint(1) unsigned NOT NULL default '2',
!   PRIMARY KEY (cid),
!   KEY links_pid (pid)
  ) TYPE=MyISAM
  ";
+ 
+ $_SQL[] = "INSERT INTO {$_TABLES['links']} (lid, cid, url, description, title, hits, date, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('geeklog.net', '20070828065220743', 'http://www.geeklog.net/', 'Visit the Geeklog homepage for support, FAQs, updates, add-ons, and a great community.', 'Geeklog Project Homepage', 0, '2007-08-28 14:52:13', 1, 5, 3, 2, 2, 2);";
+ $_SQL[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, pid, category, description, tid, created, modified, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('20070828065220743', 'site', 'Geeklog Sites', NULL, NULL, '2007-08-28 14:52:20', '2007-08-28 14:52:20', 2, 5, 3, 2, 2, 2);";
+ $_SQL[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, pid, category, description, tid, created, modified, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('site', 'root', 'Root', 'Website root', '', '2007-08-28 14:52:21', '2007-08-28 14:52:21', 2, 5, 3, 3, 2, 2);";
+ 
  
  ?>

More information about the geeklog-cvs mailing list