[Sommaire] [Imprimer]

   1  
   2  ALTER TABLE {PREFIX}authors ADD COLUMN userlevel SMALLINT;
   3  ALTER TABLE {PREFIX}authors ALTER COLUMN userlevel SET DEFAULT '0';
   4  UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
   5  UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
   6  
   7  ALTER TABLE {PREFIX}config  ADD COLUMN authorid  INT;
   8  UPDATE {PREFIX}config SET authorid=0;
   9  ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET NOT NULL;
  10  ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET DEFAULT '0';
  11  CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
  12  
  13  ALTER TABLE {PREFIX}config  DROP CONSTRAINT {PREFIX}config_pkey;
  14  ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
  15  
  16  ALTER TABLE {PREFIX}plugins  ADD COLUMN authorid  INT;
  17  ALTER TABLE {PREFIX}plugins  ALTER COLUMN authorid SET DEFAULT '0';
  18  CREATE INDEX pluginsauthorid_idx ON {PREFIX}plugins (authorid);
  19  
  20  ALTER TABLE {PREFIX}images  ADD COLUMN authorid  INT;
  21  ALTER TABLE {PREFIX}images  ALTER COLUMN authorid SET DEFAULT '0';
  22  CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);