[Sommaire] [Imprimer]

   1  CREATE TABLE `{PREFIX}images` (
   2    `id` int(11) NOT NULL auto_increment,
   3    `name` varchar(255) NOT NULL default '',
   4    `extension` varchar(5) NOT NULL default '',
   5    `mime` varchar(15) NOT NULL default '',
   6    `size` int(11) NOT NULL default '0',
   7    `dimensions_width` int(11) NOT NULL default '0',
   8    `dimensions_height` int(11) NOT NULL default '0',
   9    `thumbnail_name` varchar(255) NOT NULL default '',
  10    `date` int(11) NOT NULL default '0',
  11    PRIMARY KEY  (`id`)
  12  ) TYPE=MyISAM;
  13  
  14  UPDATE {PREFIX}plugins
  15     SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
  16   WHERE name LIKE '%serendipity_plugin_content_rewrite%';
  17  
  18  UPDATE {PREFIX}config
  19     SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
  20   WHERE name LIKE '%serendipity_plugin_content_rewrite%';
  21  
  22  UPDATE {PREFIX}plugins
  23     SET placement = 'event'
  24   WHERE name LIKE '%serendipity_event_contentrewrite%';
  25  
  26  ALTER TABLE {PREFIX}entries ADD last_modified INT(10) UNSIGNED default null;
  27  CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
  28  CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
  29  UPDATE {PREFIX}entries SET last_modified = timestamp;
  30  
  31  INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10);
  32  INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11);
  33  INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12);
  34  INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13);