Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2016-06-27-irap.sql 536 Bytes
Edit Raw Normal View History
fe672157   Alexandre   bugfixes 2 
1
2
 
use database;
7cc1b02e   Alexandre   bugfixes 
3
4
 
set foreign_key_checks=0;
a7a6c329   Alexandre   bugfixes 
5
 
ALTER TABLE `documents` DROP FOREIGN KEY `fk_documents_type_documents_id`;
7cc1b02e   Alexandre   bugfixes 
6
7
 
ALTER TABLE `documents` DROP `type_document_id`;
a7a6c329   Alexandre   bugfixes 
8
9
10
11
 
ALTER TABLE type_documents ENGINE=innoDB;
ALTER TABLE users ENGINE=innoDB;
ALTER TABLE configurations ENGINE=innoDB;
7cc1b02e   Alexandre   bugfixes 
12
 
ALTER TABLE `documents` ADD `type_document_id` int(11) DEFAULT NULL;
fe672157   Alexandre   bugfixes 2 
13
 
ALTER TABLE `documents` ADD CONSTRAINT `fk_documents_type_documents_id` FOREIGN KEY (`type_document_id`) REFERENCES `type_documents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;