3 CHANGE
COLUMN nom
name VARCHAR(64) NOT NULL;
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';
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;
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;
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;
29 CHANGE
COLUMN user_id uid
INT(11) not null;
33 CHANGE
COLUMN user_id uid
INT(11) not null;
34 CHANGE
COLUMN peremption expiration
DATE NOT NULL;
35 ALTER TABLE announce_read
36 CHANGE
COLUMN user_id uid
INT(11) not null;
39 ALTER TABLE profile_photos
40 CHANGE
COLUMN uid pid
INT(11) not null;
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;
51 ALTER TABLE account_auth_openid
52 CHANGE
COLUMN user_id uid
INT(11) not null;
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;
61 ALTER TABLE watch_profile
62 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
65 ALTER TABLE search_name
66 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
69 ALTER TABLE group_announces
70 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;
71 CHANGE
COLUMN peremption expiration
DATE NOT NULL;
72 ALTER TABLE group_announces_read
73 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;