35a98dc753073d6473517665988951bae164c24a
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;
36 ALTER TABLE announce_read
37 CHANGE
COLUMN user_id uid
INT(11) not null;
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;
45 ALTER TABLE profile_photos
46 CHANGE
COLUMN uid pid
INT(11) not null;
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;
57 ALTER TABLE account_auth_openid
58 CHANGE
COLUMN user_id uid
INT(11) not null;
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;
67 ALTER TABLE watch_profile
68 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
71 ALTER TABLE search_name
72 CHANGE
COLUMN uid pid
INT(11) NOT NULL;
75 ALTER TABLE group_announces
76 CHANGE
COLUMN user_id uid
INT(11) NOT NULL,
77 CHANGE
COLUMN peremption expiration
DATE NOT NULL;
78 ALTER TABLE group_announces_read
79 CHANGE
COLUMN user_id uid
INT(11) NOT NULL;