ALTER TABLE `membres` ADD `session_id` VARCHAR( 32 ) NULL ; ALTER TABLE `membres` ADD INDEX ( `session_id` ) ; ALTER TABLE `restreint` DROP `log`; ALTER TABLE `restreint` DROP PRIMARY KEY; ALTER TABLE `restreint` DROP INDEX `journal`; ALTER TABLE restreint ADD id INT AUTO_INCREMENT PRIMARY KEY FIRST; ALTER TABLE `restreint` ADD `login` VARCHAR( 32 ) NULL ; ALTER TABLE `restreint` ADD `password` VARCHAR( 32 ) NULL ; ALTER TABLE `restreint` ADD INDEX ( `membre` , `journal` ); ALTER TABLE `restreint` ADD INDEX ( `journal` , `login` , `password` ); ALTER TABLE `restreint` CHANGE `membre` `membre` INT( 11 ) NULL; // MIAM 30 octobre ALTER TABLE `journaux` ADD `force_private` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `journaux` ADD INDEX ( `force_private` ) ; ALTER TABLE `membres` DROP `pseudo` ALTER TABLE `membres` ADD UNIQUE (`email`) CREATE TABLE `user_secret_keys` ( `key` VARCHAR( 40 ) NOT NULL , `action` VARCHAR( 40 ) NOT NULL , `user_id` INT UNSIGNED NOT NULL , `expires` DATETIME NOT NULL , `content` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `key` ) , INDEX ( `action` , `user_id` , `expires` ) ) ENGINE = MYISAM ### Version 1.4 ALTER DATABASE `jicom_lencrier` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; DROP TABLE `abonnements`, `checklist`, `contacts`, `jvotes`, `messages`, `sessions`, `votes`, `votes_membres`, `ecrits_textes`; ALTER TABLE `ecrits` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `forums` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `forums_textes` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `journaux` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `membres` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `ecrits_html` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `ecrits_html` CHANGE `texte` `texte` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL; ALTER TABLE `user_secret_keys` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `user_secret_keys` CHANGE `key` `key` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', CHANGE `content` `content` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ''; # Status écrits ALTER TABLE `ecrits` ADD `status` TINYINT NOT NULL DEFAULT '0'; ALTER TABLE `ecrits` ADD INDEX ( `status` ); UPDATE ecrits SET status = 1 WHERE statut != "prive" AND valide = "oui"; ALTER TABLE `ecrits` DROP `statut`, DROP `valide`, DROP `syntaxe`; # forum/abonnement ALTER TABLE `journaux` CHANGE `forum` `forum` TINYINT UNSIGNED NOT NULL DEFAULT '1', CHANGE `suivimail` `abonnement` TINYINT UNSIGNED NOT NULL DEFAULT '1'; UPDATE journaux SET forum = forum - 1; UPDATE journaux SET abonnement = abonnement - 1; ALTER TABLE `journaux` ADD `contact` TINYINT UNSIGNED NOT NULL DEFAULT '1' AFTER `abonnement`; UPDATE journaux SET contact = 0; # Status journaux # ex: enum('prive','public','interdit','restreint','collectif') ALTER TABLE `journaux` CHANGE `statut` `statut` TINYINT NOT NULL DEFAULT '0'; UPDATE journaux SET statut = statut - 1; ALTER TABLE `journaux` DROP `collectif`; RENAME TABLE `restreint` TO `acces_prives` ; ALTER TABLE `acces_prives` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; # Status forums UPDATE forums SET `status` = 1 WHERE `status` = "online"; UPDATE forums SET `status` = 0 WHERE `status` = "offline"; ALTER TABLE forums CHANGE `status` `status` TINYINT NOT NULL DEFAULT '1'; ALTER TABLE `forums` DROP `host`; ALTER TABLE `forums` CHANGE `contact` `contact` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; # trunk merge ALTER TABLE `membres` DROP `groupe`, DROP `host`, DROP `fuseau`, DROP `rappel`, DROP `invisible`, DROP `design`, DROP `msg_mail`, DROP `uniqid`, DROP `statut`; ALTER TABLE `membres` ADD `admin` TINYINT NOT NULL DEFAULT 0; UPDATE membres SET admin = 1 WHERE id = 288; # abonnements CREATE TABLE `abonnements` ( `journal` VARCHAR(30) NOT NULL , `email` VARCHAR( 255 ) NOT NULL , `last_check` DATE NULL DEFAULT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `abonnements` ADD UNIQUE ( `journal` , `email` ); CREATE TABLE `abonnements_queue` ( `journal` VARCHAR( 30 ) NOT NULL , `ecrit` INT UNSIGNED NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY ( `ecrit` ) ) ENGINE = MYISAM ; # notifs ALTER TABLE `journaux` ADD `notifications` TINYINT NOT NULL DEFAULT '0';