[Sommaire] [Imprimer]

   1  <?php
   2  
   3  $_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD emailfromadmin tinyint(1) NOT NULL DEFAULT '1'";
   4  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1'";
   5  $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD type varchar(30) NOT NULL DEFAULT 'article'";
   6  $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD photo varchar(128) DEFAULT NULL";
   7  $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD show_topic_icon tinyint(1) unsigned NOT NULL DEFAULT '1'";
   8  
   9  $_SQL[] ="
  10  CREATE TABLE {$_TABLES['article_images']} (
  11    ai_sid varchar(20) NOT NULL,
  12    ai_img_num tinyint(2) unsigned NOT NULL,
  13    ai_filename varchar(128) NOT NULL,
  14    PRIMARY KEY (ai_sid,ai_img_num)
  15  ) TYPE=MyISAM
  16  ";
  17  ?>