[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.8_to_1.3.9.php,NONE,1.1

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

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

Added Files:
	mysql_1.3.8_to_1.3.9.php 
Log Message:
Update for Content Syndication


--- NEW FILE: mysql_1.3.8_to_1.3.9.php ---
<?php

$_SQL[] = "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[] = "DELETE FROM {$_TABLES['vars']} WHERE name = 'rdf_sids'";

?>