Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2019-06-04.sql 421 Bytes
Edit Raw Normal View History
bc14f1eb   Etienne Pallier   LDAP CACHED v3 
1
2
3
 
use database;

CREATE TABLE `fakeldapusers` (
de49e3ca   Etienne Pallier   bugfix database 
4
 
  `id` int(11) AUTO_INCREMENT primary key NOT NULL,
bc14f1eb   Etienne Pallier   LDAP CACHED v3 
5
6
7
8
9
10
11
12
13
 
  `sn` varchar(45) DEFAULT NULL,
  `givenname` varchar(45) DEFAULT NULL,
  `uid` varchar(45) DEFAULT NULL,
  `mail` varchar(45) DEFAULT NULL,
  `userpassword` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ALTER TABLE `fakeldapusers`
-- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;