upgrade/0.9.17/01_smallint_to_int.sql

   1 ALTER TABLE adresses           MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
   2 ALTER TABLE aliases            MODIFY COLUMN id             INT NOT NULL DEFAULT 0;
   3 ALTER TABLE applis_ins         MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
   4 ALTER TABLE auth_user_md5      MODIFY COLUMN user_id        INT NOT NULL AUTO_INCREMENT;
   5 ALTER TABLE auth_user_quick    MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
   6 ALTER TABLE axletter_ins       MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
   7 ALTER TABLE axletter_rights    MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
   8 ALTER TABLE binets_ins         MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
   9 ALTER TABLE competences_ins    MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  10 ALTER TABLE contacts           MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  11 ALTER TABLE email_send_save    MODIFY COLUMN uid            INT NOT NULL;
  12 ALTER TABLE emails_watch       MODIFY COLUMN uid            INT DEFAULT NULL;
  13 ALTER TABLE entreprises        MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  14 ALTER TABLE evenements         MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
  15 ALTER TABLE evenements_vus     MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
  16 ALTER TABLE gapps_accounts     MODIFY COLUMN l_userid       INT DEFAULT NULL;
  17 ALTER TABLE gapps_queue        MODIFY COLUMN q_owner_id     INT DEFAULT NULL;
  18 ALTER TABLE gapps_queue        MODIFY COLUMN q_recipient_id INT DEFAULT NULL;
  19 ALTER TABLE groupesx_ins       MODIFY COLUMN guid           INT NOT NULL DEFAULT 0;
  20 ALTER TABLE homonymes          MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
  21 ALTER TABLE ip_watch           MODIFY COLUMN uid            INT DEFAULT NULL;
  22 ALTER TABLE langues_ins        MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  23 ALTER TABLE mentor             MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  24 ALTER TABLE mentor_pays        MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  25 ALTER TABLE mentor_secteurs    MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  26 ALTER TABLE ml_moderate        MODIFY COLUMN mid            INT NOT NULL;
  27 ALTER TABLE ml_moderate        MODIFY COLUMN uid            INT NOT NULL;
  28 ALTER TABLE newsletter_ins     MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
  29 ALTER TABLE perte_pass         MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  30 ALTER TABLE photo              MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  31 ALTER TABLE profile_medals_sub MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  32 ALTER TABLE register_subs      MODIFY COLUMN uid            INT NOT NULL;
  33 ALTER TABLE survey_surveys     MODIFY COLUMN author_id      INT NOT NULL;
  34 ALTER TABLE survey_votes       MODIFY COLUMN user_id        INT NOT NULL;
  35 ALTER TABLE tels               MODIFY COLUMN uid            INT NOT NULL DEFAULT 0;
  36 ALTER TABLE user_changes       MODIFY COLUMN user_id        INT NOT NULL DEFAULT 0;
  37 ALTER TABLE watch_profile      MODIFY COLUMN uid            INT NOT NULL;
  38
  39 # vim:set syntax=sql: