upgrade/account/20_naming_convention.sql

   1 # forums
   2   ALTER TABLE  forums
   3 CHANGE COLUMN  nom name VARCHAR(64) NOT NULL;
   4
   5   ALTER TABLE  forum_profiles
   6 CHANGE COLUMN  nom name VARCHAR(64) NOT NULL,
   7    ADD COLUMN  last_seen TIMESTAMP NOT NULL DEFAULT '0000-00-00';
   8
   9 # payment
  10   ALTER TABLE  payments
  11 CHANGE COLUMN  montant_def amount_def DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  12 CHANGE COLUMN  montant_min amount_min DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  13 CHANGE COLUMN  montant_max amount_max DECIMAL(10,2) NOT NULL DEFAULT 0.00;
  14
  15   ALTER TABLE  payment_transactions
  16 CHANGE COLUMN  montant amount VARCHAR(15) NOT NULL DEFAULT '0.00',
  17 CHANGE COLUMN  cle pkey VARCHAR(5) NOT NULL;
  18
  19 # emails
  20   ALTER TABLE  aliases
  21 CHANGE COLUMN  id uid INT(11) not null;
  22   ALTER TABLE  newsletter_ins
  23 CHANGE COLUMN  user_id uid INT(11) not null;
  24   ALTER TABLE  axletter_ins
  25 CHANGE COLUMN  user_id uid INT(11) not null;
  26   ALTER TABLE  axletter_rights
  27 CHANGE COLUMN  user_id uid INT(11) not null;
  28   ALTER TABLE  homonyms
  29 CHANGE COLUMN  user_id uid INT(11) not null;
  30
  31 # announces
  32   ALTER TABLE  announces
  33 CHANGE COLUMN  user_id uid INT(11) not null,
  34 CHANGE COLUMN  peremption expiration DATE NOT NULL;
  35
  36   ALTER TABLE  announce_read
  37 CHANGE COLUMN  user_id uid INT(11) not null;
  38
  39   ALTER TABLE  reminder_tips
  40 CHANGE COLUMN  peremption expiration DATE NOT NULL,
  41 CHANGE COLUMN  titre title VARCHAR(64) NOT NULL,
  42 CHANGE COLUMN  priorite priority TINYINT(2) UNSIGNED NOT NULL DEFAULT 127;
  43
  44 # profile
  45   ALTER TABLE  profile_photos
  46 CHANGE COLUMN  uid pid INT(11) not null;
  47   ALTER TABLE  profile_skills
  48 CHANGE COLUMN  uid pid INT(11) not null;
  49   ALTER TABLE  profile_langskills
  50 CHANGE COLUMN  uid pid INT(11) not null;
  51   ALTER TABLE  profile_binets
  52 CHANGE COLUMN  user_id pid INT(11) not null;
  53   ALTER TABLE  profile_medals
  54 CHANGE COLUMN  uid pid INT(11) not null;
  55
  56 # account
  57   ALTER TABLE  account_auth_openid
  58 CHANGE COLUMN  user_id uid INT(11) not null;
  59
  60 # request
  61   ALTER TABLE  requests
  62 CHANGE COLUMN  user_id uid INT(11) NOT NULL;
  63   ALTER TABLE  requests_hidden
  64 CHANGE COLUMN  user_id uid INT(11) NOT NULL;
  65
  66 # watch
  67   ALTER TABLE  watch_profile
  68 CHANGE COLUMN  uid pid INT(11) NOT NULL;
  69
  70 # search_name
  71   ALTER TABLE  search_name
  72 CHANGE COLUMN  uid pid INT(11) NOT NULL;
  73
  74 # group
  75   ALTER TABLE  group_announces
  76 CHANGE COLUMN  user_id uid INT(11) NOT NULL,
  77 CHANGE COLUMN  peremption expiration DATE NOT NULL;
  78   ALTER TABLE  group_announces_read
  79 CHANGE COLUMN  user_id uid INT(11) NOT NULL;
  80
  81 # vim:set ft=mysql: