[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}authors ADD userlevel INT(4) UNSIGNED DEFAULT '0';
   2  UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
   3  UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
   4  
   5  ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED NOT NULL DEFAULT '0';
   6  CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
   7  
   8  ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;
   9  ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
  10  
  11  ALTER TABLE {PREFIX}plugins  ADD authorid  INT UNSIGNED DEFAULT '0';
  12  CREATE INDEX pluginauthorid_idx ON {PREFIX}plugins (authorid);
  13  
  14  ALTER TABLE {PREFIX}images  ADD authorid  INT UNSIGNED DEFAULT '0';
  15  CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);