geOrchestra 17.12 to 18.06 db changes

georchestra_17.12_to_18.06_db.diff

diff --git a/postgresql/04-ldapadmin.sql b/postgresql/04-console.sql
similarity index 81%
rename from postgresql/04-ldapadmin.sql
rename to postgresql/04-console.sql
index 3ae97a4ed..ed40a7eb0 100644
--- a/postgresql/04-ldapadmin.sql
+++ b/postgresql/04-console.sql
@@ -4,9 +4,9 @@
 
 BEGIN;
 
-CREATE SCHEMA ldapadmin;
+CREATE SCHEMA console;
 
-SET search_path TO ldapadmin,public,pg_catalog;
+SET search_path TO console,public,pg_catalog;
 
 
 CREATE TABLE user_token (
diff --git a/postgresql/05-ldapadmin-data.sql b/postgresql/05-console-data.sql
similarity index 72%
rename from postgresql/05-ldapadmin-data.sql
rename to postgresql/05-console-data.sql
index c1943920a..79347c7e3 100644
--- a/postgresql/05-ldapadmin-data.sql
+++ b/postgresql/05-console-data.sql
@@ -4,7 +4,7 @@
 
 BEGIN;
 
-SET search_path TO ldapadmin,public,pg_catalog;
+SET search_path TO console,public,pg_catalog;
 
 CREATE TABLE admin_attachments (
   id bigserial,
@@ -21,7 +21,7 @@ CREATE TABLE email_template (
   CONSTRAINT email_template_pkey PRIMARY KEY (id)
 );
 
-CREATE TABLE ldapadmin.admin_emails (
+CREATE TABLE admin_emails (
   id bigserial,
   body text,
   date timestamp without time zone,
@@ -31,6 +31,14 @@ CREATE TABLE ldapadmin.admin_emails (
   CONSTRAINT admin_emails_pkey PRIMARY KEY (id)
 );
 
+CREATE TABLE delegations
+(
+  uid character varying(255) NOT NULL,
+  orgs character varying[],
+  roles character varying[],
+  CONSTRAINT delegations_pkey PRIMARY KEY (uid)
+);
+
 INSERT INTO email_template (content, name) VALUES ('Bonjour et bienvenue', 'Hello');
 INSERT INTO email_template (content, name) VALUES ('Votre compte a été supprimé', 'Deleted');