[Sommaire] [Imprimer]

   1  <?php
   2  
   3  $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD is_default tinyint(1) unsigned NOT NULL DEFAULT '0'";
   4  
   5  $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD pwrequestid varchar(16) DEFAULT NULL";
   6  
   7  $_SQL[] = "ALTER TABLE {$_TABLES['userinfo']} ADD lastlogin VARCHAR( 10 ) NOT NULL";
   8  
   9  $_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD emailfromuser tinyint(1) NOT NULL default '1'";
  10  $_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD showonline tinyint(1) NOT NULL default '1'";
  11  
  12  $_SQL[] = "CREATE TABLE {$_TABLES['speedlimit']} (
  13    id int(10) unsigned NOT NULL auto_increment,
  14    ipaddress varchar(15) NOT NULL default '',
  15    date int(10) unsigned default NULL,
  16    type varchar(30) NOT NULL default 'submit',
  17    PRIMARY KEY (id)
  18  ) TYPE = MyISAM";
  19  
  20  $_SQL[] = "DROP TABLE {$_TABLES['commentspeedlimit']}";
  21  $_SQL[] = "DROP TABLE {$_TABLES['submitspeedlimit']}";
  22  
  23  ?>