source: cpc/trunk/project/bin/updateDB2.2.sql @ 1316

Last change on this file since 1316 was 1134, checked in by roux, 11 years ago

gestion versionnement des amendements rectifiés

File size: 392 bytes
Line 
1
2ALTER TABLE `question_ecrite` ADD COLUMN `date_cloture` DATE AFTER `date`;
3ALTER TABLE `question_ecrite` ADD COLUMN `motif_retrait` TEXT AFTER `reponse`;
4ALTER TABLE `question_ecrite` ADD UNIQUE `uniq_num_idx` (`legislature`, `numero`);
5ALTER TABLE `amendement` ADD UNIQUE `uniq_loi_num_idx` (`legislature`, `texteloi_id`, `numero`, `rectif`);
6ALTER TABLE `amendement` DROP INDEX `source`;
7
Note: See TracBrowser for help on using the repository browser.