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;
38 CHANGE
COLUMN peremption expiration
DATE NOT NULL;
41 ALTER TABLE profile_photos
42 CHANGE
COLUMN uid pid
INT(11) not null;
43 ALTER TABLE profile_skills
44 CHANGE
COLUMN uid pid
INT(11) not null;
45 ALTER TABLE profile_langskills
46 CHANGE
COLUMN uid pid
INT(11) not null;
47 ALTER TABLE profile_binets
48 CHANGE
COLUMN user_id pid
INT(11) not null;
49 ALTER TABLE profile_medals
50 CHANGE
COLUMN uid pid
INT(11) not null;
53 ALTER TABLE account_auth_openid
54 CHANGE
COLUMN user_id uid
INT(11) not null;
58 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;
59 ALTER TABLE requests_hidden
60 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;
63 ALTER TABLE watch_profile
64 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
67 ALTER TABLE search_name
68 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
71 ALTER TABLE group_announces
72 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;
73 CHANGE
COLUMN peremption expiration
DATE NOT NULL;
74 ALTER TABLE group_announces_read
75 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;