Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2016-06-28.sql 905 Bytes
Edit Raw Normal View History
4dae83a2   Alexandre   Version: 2.5.1.0 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
use database;

ALTER TABLE `materiels` ADD `photo_id` int(11) DEFAULT NULL;

ALTER TABLE `configurations` ADD `taille_max_doc` int (15) DEFAULT '8000000';

ALTER TABLE `documents` ADD `photo` tinyint(1)  DEFAULT NULL;

Insert into type_documents(nom) values ('Bon de commande');
Insert into type_documents(nom) values ('Bon de livraison');
Insert into type_documents(nom) values ('Photo');
Insert into type_documents(nom) values ('Documentation technique');
Insert into type_documents(nom) values ('Spécifications');
Insert into type_documents(nom) values ('CR de maintenance');
Insert into type_documents(nom) values ('CR d\'étalonnage');
Insert into type_documents(nom) values ('Suivi de panne');

Insert into type_documents(nom) values ('Certificat de garantie');
Insert into type_documents(nom) values ('Certificat de conformité');
Insert into type_documents(nom) values ('Manuel d\'utilisation');