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;
20 ALTER TABLE profile_photos
21 CHANGE
COLUMN uid pid
INT(6) not null;
22 ALTER TABLE profile_skills
23 CHANGE
COLUMN uid pid
INT(11) not null;
24 ALTER TABLE profile_langskills
25 CHANGE
COLUMN uid pid
INT(11) not null;
26 ALTER TABLE profile_binets
27 CHANGE
COLUMN user_id pid
INT(11) not null;
28 ALTER TABLE profile_medals
29 CHANGE
COLUMN uid pid
INT(11) not null;