[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.55,1.56

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/sql
In directory geeklog_prod:/tmp/cvs-serv26144/sql

Modified Files:
	mysql_tableanddata.php 
Log Message:
Admin interface for Content Syndication; Extensions to the Plugin API to allow plugins to create feeds; Other feed formats can be implemented as classes.


Index: mysql_tableanddata.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.55
retrieving revision 1.56
diff -C2 -d -r1.55 -r1.56
*** mysql_tableanddata.php	5 Aug 2003 08:30:49 -0000	1.55
--- mysql_tableanddata.php	12 Aug 2003 21:10:06 -0000	1.56
***************
*** 413,416 ****
--- 413,439 ----
  
  $_SQL[30] = "
+ CREATE TABLE {$_TABLES['syndication']} (
+   fid int unsigned NOT NULL auto_increment,
+   type varchar(30) NOT NULL default 'geeklog',
+   topic varchar(48) NOT NULL default '::all',
+   format varchar(20) NOT NULL default 'rss',
+   limits varchar(5) NOT NULL default '10',
+   content_length smallint(5) unsigned NOT NULL default '0',
+   title varchar(40) NOT NULL default '',
+   description text,
+   filename varchar(40) NOT NULL default 'geeklog.rdf',
+   charset varchar(20) NOT NULL default 'UTF-8',
+   language varchar(20) NOT NULL default 'en-gb',
+   is_enabled tinyint(1) unsigned NOT NULL default '1',
+   updated datetime NOT NULL default '0000-00-00 00:00:00',
+   update_info text,
+   PRIMARY KEY (fid),
+   INDEX syndication_type(type),
+   INDEX syndication_is_enabled(is_enabled),
+   INDEX syndication_updated(updated)
+ ) TYPE=MyISAM
+ ";
+ 
+ $_SQL[31] = "
  CREATE TABLE {$_TABLES['topics']} (
    tid varchar(20) NOT NULL default '',
***************
*** 430,434 ****
  ";
  
! $_SQL[31] = "
  CREATE TABLE {$_TABLES['tzcodes']} (
    tz char(3) NOT NULL default '',
--- 453,457 ----
  ";
  
! $_SQL[32] = "
  CREATE TABLE {$_TABLES['tzcodes']} (
    tz char(3) NOT NULL default '',
***************
*** 439,443 ****
  ";
  
! $_SQL[32] = "
  CREATE TABLE {$_TABLES['usercomment']} (
    uid mediumint(8) NOT NULL default '1',
--- 462,466 ----
  ";
  
! $_SQL[33] = "
  CREATE TABLE {$_TABLES['usercomment']} (
    uid mediumint(8) NOT NULL default '1',
***************
*** 449,453 ****
  ";
  
! $_SQL[33] = "
  CREATE TABLE {$_TABLES['userindex']} (
    uid mediumint(8) NOT NULL default '1',
--- 472,476 ----
  ";
  
! $_SQL[34] = "
  CREATE TABLE {$_TABLES['userindex']} (
    uid mediumint(8) NOT NULL default '1',
***************
*** 464,468 ****
  ";
  
! $_SQL[34] = "
  CREATE TABLE {$_TABLES['userinfo']} (
    uid mediumint(8) NOT NULL default '1',
--- 487,491 ----
  ";
  
! $_SQL[35] = "
  CREATE TABLE {$_TABLES['userinfo']} (
    uid mediumint(8) NOT NULL default '1',
***************
*** 478,482 ****
  ";
  
! $_SQL[35] = "
  CREATE TABLE {$_TABLES['userprefs']} (
    uid mediumint(8) NOT NULL default '1',
--- 501,505 ----
  ";
  
! $_SQL[36] = "
  CREATE TABLE {$_TABLES['userprefs']} (
    uid mediumint(8) NOT NULL default '1',
***************
*** 493,497 ****
  ";
  
! $_SQL[36] = "
  CREATE TABLE {$_TABLES['users']} (
    uid mediumint(8) NOT NULL auto_increment,
--- 516,520 ----
  ";
  
! $_SQL[37] = "
  CREATE TABLE {$_TABLES['users']} (
    uid mediumint(8) NOT NULL auto_increment,
***************
*** 513,517 ****
  ";
  
! $_SQL[37] = "
  CREATE TABLE {$_TABLES['vars']} (
    name varchar(20) NOT NULL default '',
--- 536,540 ----
  ";
  
! $_SQL[38] = "
  CREATE TABLE {$_TABLES['vars']} (
    name varchar(20) NOT NULL default '',
***************
*** 521,525 ****
  ";
  
! $_SQL[38] = "
  CREATE TABLE {$_TABLES['article_images']} (
    ai_sid varchar(20) NOT NULL,
--- 544,548 ----
  ";
  
! $_SQL[39] = "
  CREATE TABLE {$_TABLES['article_images']} (
    ai_sid varchar(20) NOT NULL,
***************
*** 530,534 ****
  ";
  
! $_SQL[39] = "
  CREATE TABLE {$_TABLES['staticpage']} (
    sp_id varchar(20) NOT NULL default '',
--- 553,557 ----
  ";
  
! $_SQL[40] = "
  CREATE TABLE {$_TABLES['staticpage']} (
    sp_id varchar(20) NOT NULL default '',
***************
*** 750,753 ****
--- 773,778 ----
  
  $_DATA[] = "INSERT INTO {$_TABLES['storysubmission']} (sid, uid, tid, title, introtext, date, postmode) VALUES ('20030101120556538',2,'GeekLog','Are you secure?','<p>This is a reminder to secure your site once you have Geeklog up and running. What you should do:</p>\r\r<ol>\r<li>Change the default password for all Admin accounts.</li>\r<li>Remove the install directory (you won\'t need it any more).</li>\r</ol>','2003-01-01 12:05:56','html') ";
+ 
+ $_DATA[] = "INSERT INTO {$_TABLES['syndication']} (type, topic, format, limits, content_length, title, description, filename, charset, language, is_enabled, updated, update_info) VALUES ('geeklog', '::all', 'rss', 10, 0, 'Geeklog Site', 'Another Nifty Geeklog Site', 'geeklog.rdf', 'UTF-8', 'en-gb', 1, '0000-00-00 00:00:00', NULL)";
  
  $_DATA[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl, sortnum, limitnews, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('General','General News','/images/topics/topic_news.gif',1,10,6,2,3,2,2,2)";