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 | |
33 | CHANGE COLUMN user_id uid INT(11) not null; | |
b58e5ac2 | 34 | CHANGE COLUMN peremption expiration DATE NOT NULL; |
f280f651 FB |
35 | ALTER TABLE announce_read |
36 | CHANGE COLUMN user_id uid INT(11) not null; | |
37 | ||
bdd977d7 | 38 | # profile |
100e66fc | 39 | ALTER TABLE profile_photos |
fe13bc1d | 40 | CHANGE COLUMN uid pid INT(11) not null; |
bdd977d7 FB |
41 | ALTER TABLE profile_skills |
42 | CHANGE COLUMN uid pid INT(11) not null; | |
43 | ALTER TABLE profile_langskills | |
44 | CHANGE COLUMN uid pid INT(11) not null; | |
45 | ALTER TABLE profile_binets | |
46 | CHANGE COLUMN user_id pid INT(11) not null; | |
47 | ALTER TABLE profile_medals | |
48 | CHANGE COLUMN uid pid INT(11) not null; | |
100e66fc | 49 | |
864957c1 FB |
50 | # account |
51 | ALTER TABLE account_auth_openid | |
52 | CHANGE COLUMN user_id uid INT(11) not null; | |
53 | ||
257ae408 SJ |
54 | # request |
55 | ALTER TABLE requests | |
56 | CHANGE COLUMN user_id uid INT(11) NOT NULL; | |
57 | ALTER TABLE requests_hidden | |
58 | CHANGE COLUMN user_id uid INT(11) NOT NULL; | |
59 | ||
bf0e2a48 SJ |
60 | # watch |
61 | ALTER TABLE watch_profile | |
62 | CHANGE COLUMN uid pid INT(11) NOT NULL; | |
63 | ||
6dbb167e SJ |
64 | # search_name |
65 | ALTER TABLE search_name | |
66 | CHANGE COLUMN uid pid INT(11) NOT NULL; | |
67 | ||
14bc135e SJ |
68 | # group |
69 | ALTER TABLE group_announces | |
70 | CHANGE COLUMN user_id uid INT(11) NOT NULL; | |
b58e5ac2 | 71 | CHANGE COLUMN peremption expiration DATE NOT NULL; |
14bc135e SJ |
72 | ALTER TABLE group_announces_read |
73 | CHANGE COLUMN user_id uid INT(11) NOT NULL; | |
74 | ||
100e66fc | 75 | # vim:set ft=mysql: |