Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2016-05-09.sql 1.28 KB
Edit Raw Normal View History
9be43b8a   Alexandre   #3523 Implémentai... 
1
2
3
4
5
6
7
8
9
10
 

DROP TABLE IF EXISTS `configurations`;
CREATE TABLE IF NOT EXISTS `configurations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(45) NOT NULL COMMENT 'obligatoire (et unique)',
  `mode_install` tinyint(1)  DEFAULT NULL,
  `mode_debug` tinyint(1)  DEFAULT NULL,
  `use_ldap` tinyint(1)  DEFAULT NULL,
  `host_ldap` varchar(30)  DEFAULT NULL,
  `port_ldap` varchar(10)  DEFAULT NULL,
9fc6b8a2   Alexandre   Version: 2.4.2.6 
11
 
  `authentificationType_ldap` varchar(30)  DEFAULT 'xxx',
9be43b8a   Alexandre   #3523 Implémentai... 
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
  `baseDn_ldap` varchar(30)  DEFAULT NULL,
  `filter_ldap` varchar(30)  DEFAULT NULL,
  `labName` varchar(30)  DEFAULT NULL,
  `labNameShort` varchar(20)  DEFAULT NULL,
  `labPresent` varchar(10)  DEFAULT NULL,
  `labUmr` varchar(30)  DEFAULT NULL,
  `hasPrinter` tinyint(1)  DEFAULT NULL,
  `emailGuest1` varchar(45)  DEFAULT NULL,
  `emailGuest2` varchar(45)  DEFAULT NULL,
  `emailGuest3` varchar(45)  DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nom_UNIQUE` (`nom`)
);
86f26e86   Alexandre   Version: 2.4.2.5 
27
 
Insert into `configurations`(`nom`, `mode_install`, `mode_debug`, `use_ldap`, `host_ldap`, `port_ldap`, `authentificationType_ldap`, `baseDn_ldap`, `filter_ldap`, `labName`, `labNameShort`, `labPresent`, `labUmr`, `hasPrinter`, `emailGuest1`, `emailGuest2`, `emailGuest3`) values ('default', '1', '0', '0', '', '', 'xxx', '', '', 'LABONAME', 'LABO', 'du ', '', '0', '', '', '');