[Sommaire] [Imprimer]

   1  ALTER TABLE blocks MODIFY COLUMN bid smallint unsigned DEFAULT '0' NOT NULL auto_increment;
   2  ALTER TABLE blocks MODIFY COLUMN tid varchar(20) DEFAULT 'All' NOT NULL;
   3  
   4  ALTER TABLE comments MODIFY COLUMN cid int unsigned DEFAULT '0' NOT NULL auto_increment;
   5  ALTER TABLE comments ADD COLUMN pid int unsigned;
   6  
   7  ALTER TABLE calendar RENAME AS events;
   8  
   9  ALTER TABLE pollanswers MODIFY COLUMN qid varchar(20) DEFAULT '' NOT NULL;
  10  ALTER TABLE pollanswers MODIFY COLUMN aid tinyint unsigned DEFAULT '0' NOT NULL;
  11  ALTER TABLE pollanswers MODIFY COLUMN answer varchar(255);
  12  ALTER TABLE pollanswers MODIFY COLUMN votes mediumint unsigned;
  13  
  14  ALTER TABLE pollquestions MODIFY COLUMN qid varchar(20) DEFAULT '' NOT NULL;
  15  ALTER TABLE pollquestions MODIFY COLUMN question varchar(255);
  16  ALTER TABLE pollquestions MODIFY COLUMN voters mediumint unsigned;
  17  
  18  CREATE TABLE pollvoters (
  19    id int unsigned DEFAULT '0' NOT NULL auto_increment,
  20    qid varchar(20) DEFAULT '' NOT NULL,
  21    ipaddress char(15) DEFAULT '' NOT NULL,
  22    date int unsigned,
  23    PRIMARY KEY (id)
  24  );
  25  
  26  ALTER TABLE stories MODIFY COLUMN uid mediumint unsigned DEFAULT '0' NOT NULL;
  27  ALTER TABLE stories CHANGE COLUMN content introtext text;
  28  ALTER TABLE stories ADD COLUMN bodytext text;
  29  ALTER TABLE stories MODIFY COLUMN hits mediumint unsigned DEFAULT '0' NOT NULL;
  30  ALTER TABLE stories ADD COLUMN comments mediumint unsigned DEFAULT '0' NOT NULL;
  31  
  32  ALTER TABLE users MODIFY COLUMN uid mediumint unsigned DEFAULT '0' NOT NULL auto_increment;