[Sommaire] [Imprimer]

   1  <?php
   2  
   3  $_SQL[] = "CREATE TABLE {$_TABLES['syndication']} (
   4    fid int(10) unsigned NOT NULL auto_increment,
   5    type varchar(30) NOT NULL default 'geeklog',
   6    topic varchar(48) NOT NULL default '::all',
   7    format varchar(20) NOT NULL default 'rss',
   8    limits varchar(5) NOT NULL default '10',
   9    content_length smallint(5) unsigned NOT NULL default '0',
  10    title varchar(40) NOT NULL default '',
  11    description text,
  12    filename varchar(40) NOT NULL default 'geeklog.rdf',
  13    charset varchar(20) NOT NULL default 'UTF-8',
  14    language varchar(20) NOT NULL default 'en-gb',
  15    is_enabled tinyint(1) unsigned NOT NULL default '1',
  16    updated datetime NOT NULL default '0000-00-00 00:00:00',
  17    update_info text,
  18    PRIMARY KEY (fid),
  19    INDEX syndication_type(type),
  20    INDEX syndication_is_enabled(is_enabled),
  21    INDEX syndication_updated(updated)
  22  ) TYPE=MyISAM";
  23  
  24  // remove unused entry (moved to 'syndication' table)
  25  $_SQL[] = "DELETE FROM {$_TABLES['vars']} WHERE name = 'rdf_sids'";
  26  
  27  // extend max. length of static page IDs to 40 characters
  28  $_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} CHANGE sp_id sp_id varchar(40) NOT NULL";
  29  
  30  // change "remember me" option to 1 Month for those who had it at 1 Year
  31  $_SQL[] = "UPDATE {$_TABLES['users']} SET cookietimeout = 2678400 WHERE cookietimeout = 31536000";
  32  
  33  // remove '1 Year' option, add "(don't)" option, sort table
  34  $_SQL[] = "DELETE FROM {$_TABLES['cookiecodes']} WHERE cc_value = 31536000";
  35  $_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (0,'(don\'t)')";
  36  $_SQL[] = "ALTER TABLE {$_TABLES['cookiecodes']} ORDER BY cc_value";
  37  
  38  // extend max. length of all URL fields to 255 characters
  39  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} CHANGE rdfurl rdfurl varchar(255) default NULL";
  40  $_SQL[] = "ALTER TABLE {$_TABLES['events']} CHANGE url url varchar(255) default NULL";
  41  $_SQL[] = "ALTER TABLE {$_TABLES['eventsubmission']} CHANGE url url varchar(255) default NULL";
  42  $_SQL[] = "ALTER TABLE {$_TABLES['links']} CHANGE url url varchar(255) default NULL";
  43  $_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE url url varchar(255) default NULL";
  44  $_SQL[] = "ALTER TABLE {$_TABLES['personal_events']} CHANGE url url varchar(255) default NULL";
  45  $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE imageurl imageurl varchar(255) default NULL";
  46  
  47  // change 'blockorder' to accept values > 255 (added in 1.3.9rc2)
  48  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} CHANGE blockorder blockorder smallint(5) unsigned NOT NULL default '1'";
  49  
  50  ?>