CREATE TABLE profile_corps (
pid INT(11) NOT NULL,
- original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
- current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
- rankid INT(4) UNSIGNED NOT NULL DEFAULT 0,
+ original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 1,
+ current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 1,
+ rankid INT(4) UNSIGNED NOT NULL DEFAULT 1,
corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
PRIMARY KEY(pid)
) ENGINE=InnoDB, CHARSET=utf8;
("INSEE", "Administrateurs de l'INSEE", 1),
("Off", "Officiers des Armées", 1);
-ALTER TABLE watch_profile MODIFY field ENUM('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2',
- 'nationalite3', 'nick', 'web', 'networking', 'edus', 'addresses',
- 'section', 'binets', 'medals', 'cv', 'jobs', 'photo', 'corps');
+ALTER TABLE watch_profile
+ MODIFY field ENUM('nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3',
+ 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals',
+ 'cv', 'jobs', 'photo', 'corps');
-- vim:set syntax=mysql: