projects / platal.git / blame
| Commit | Line | Data |
|---|---|---|
| 100e66fc FB |
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 | ||
| fe13bc1d FB |
19 | # emails |
| 20 | ALTER TABLE aliases | |
| 21 | CHANGE COLUMN id uid INT(11) not null; | |
| c0c4edb5 FB |
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; | |
| 05240425 FB |
28 | ALTER TABLE homonyms |
| 29 | CHANGE COLUMN user_id uid INT(11) not null; | |
| fe13bc1d | 30 | |
| f280f651 FB |
31 | # announces |
| 32 | ALTER TABLE announces | |
| da431170 | 33 | CHANGE COLUMN user_id uid INT(11) not null, |
| b58e5ac2 | 34 | CHANGE COLUMN peremption expiration DATE NOT NULL; |
| da431170 | 35 | |
| f280f651 FB |
36 | ALTER TABLE announce_read |
| 37 | CHANGE COLUMN user_id uid INT(11) not null; | |
| da431170 FB |
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; | |
| f280f651 | 43 | |
| bdd977d7 | 44 | # profile |
| 100e66fc | 45 | ALTER TABLE profile_photos |
| fe13bc1d | 46 | CHANGE COLUMN uid pid INT(11) not null; |
| bdd977d7 FB |
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; | |
| 100e66fc | 55 | |
| 864957c1 FB |
56 | # account |
| 57 | ALTER TABLE account_auth_openid | |
| 58 | CHANGE COLUMN user_id uid INT(11) not null; | |
| 59 | ||
| 257ae408 SJ |
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 | ||
| bf0e2a48 SJ |
66 | # watch |
| 67 | ALTER TABLE watch_profile | |
| 68 | CHANGE COLUMN uid pid INT(11) NOT NULL; | |
| 69 | ||
| 6dbb167e SJ |
70 | # search_name |
| 71 | ALTER TABLE search_name | |
| 72 | CHANGE COLUMN uid pid INT(11) NOT NULL; | |
| 73 | ||
| 14bc135e SJ |
74 | # group |
| 75 | ALTER TABLE group_announces | |
| ff900fde | 76 | CHANGE COLUMN user_id uid INT(11) NOT NULL, |
| b58e5ac2 | 77 | CHANGE COLUMN peremption expiration DATE NOT NULL; |
| 14bc135e SJ |
78 | ALTER TABLE group_announces_read |
| 79 | CHANGE COLUMN user_id uid INT(11) NOT NULL; | |
| 80 | ||
| 100e66fc | 81 | # vim:set ft=mysql: |