[Noalyss-commit] [noalyss] 187/323: SQL : account_repository

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 2bd51d285c039056e295369c52176f68f62e0fdb
Author: Dany De Bontridder <address@hidden>
Date:   Sat Feb 10 22:11:47 2018 +0100

    SQL : account_repository
---
 include/sql/account_repository/constraint.sql |  4 ++++
 include/sql/account_repository/data.sql       | 26 ++++++++++++++------------
 include/sql/account_repository/schema.sql     | 14 ++++++++++++++
 include/sql/account_repository/table.sql      |  5 +++++
 4 files changed, 37 insertions(+), 12 deletions(-)

diff --git a/include/sql/account_repository/constraint.sql 
b/include/sql/account_repository/constraint.sql
index 87dedde..d909222 100644
--- a/include/sql/account_repository/constraint.sql
+++ b/include/sql/account_repository/constraint.sql
@@ -24,8 +24,12 @@ ALTER TABLE ONLY modeledef
     ADD CONSTRAINT modeledef_pkey PRIMARY KEY (mod_id);
 ALTER TABLE ONLY user_global_pref
     ADD CONSTRAINT pk_user_global_pref PRIMARY KEY (user_id, parameter_type);
+ALTER TABLE ONLY progress
+    ADD CONSTRAINT progress_pkey PRIMARY KEY (p_id);
 ALTER TABLE ONLY recover_pass
     ADD CONSTRAINT recover_pass_pkey PRIMARY KEY (request);
+ALTER TABLE ONLY jnt_use_dos
+    ADD CONSTRAINT use_id_dos_id_uniq UNIQUE (use_id, dos_id);
 ALTER TABLE ONLY version
     ADD CONSTRAINT version_pkey PRIMARY KEY (val);
 ALTER TABLE ONLY recover_pass
diff --git a/include/sql/account_repository/data.sql 
b/include/sql/account_repository/data.sql
index 16093cf..c6d3363 100644
--- a/include/sql/account_repository/data.sql
+++ b/include/sql/account_repository/data.sql
@@ -8,24 +8,22 @@ SET client_min_messages = warning;
 
 
 
-INSERT INTO ac_dossier (dos_id, dos_name, dos_description, dos_email) VALUES 
(25, 'Création dossier 1', '', -1);
 
 
 
-INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (4, 'demo', 'demo', 'demo', 1, 
'fe01ce2a7fbac8fafaed7c982a04e229', 0, NULL);
 INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (1, NULL, NULL, 'admin', 1, 
'b1cc88e1907cde80cb2595fa793b3da9', 1, NULL);
+INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (4, 'demo', 'demo', 'demo', 0, 
'fe01ce2a7fbac8fafaed7c982a04e229', 0, NULL);
 
 
 
-INSERT INTO audit_connect (ac_id, ac_user, ac_date, ac_ip, ac_state, 
ac_module, ac_url) VALUES (1, 'admin', '2017-12-20 09:22:59.042664', 
'127.0.0.1', 'SUCCESS', 'LOGIN', 
'/developpement/phpcompta/accept/noalyss-6.9.1.9/html/login.php');
 
 
 
-SELECT pg_catalog.setval('audit_connect_ac_id_seq', 1, true);
+SELECT pg_catalog.setval('audit_connect_ac_id_seq', 3, true);
 
 
 
-SELECT pg_catalog.setval('dossier_id', 25, true);
+SELECT pg_catalog.setval('dossier_id', 24, true);
 
 
 
@@ -36,7 +34,6 @@ SELECT pg_catalog.setval('dossier_sent_email_id_seq', 1, 
false);
 
 
 
-INSERT INTO jnt_use_dos (jnt_id, use_id, dos_id) VALUES (29, 1, 25);
 
 
 
@@ -48,11 +45,14 @@ INSERT INTO modeledef (mod_id, mod_name, mod_desc) VALUES 
(2, '(FR) Basique', 'C
 
 
 
+
+
+
 SELECT pg_catalog.setval('s_modid', 8, true);
 
 
 
-SELECT pg_catalog.setval('seq_jnt_use_dos', 29, true);
+SELECT pg_catalog.setval('seq_jnt_use_dos', 28, true);
 
 
 
@@ -61,9 +61,8 @@ SELECT pg_catalog.setval('seq_priv_user', 12, true);
 
 
 INSERT INTO theme (the_name, the_filestyle, the_filebutton) VALUES ('Light', 
'style-light.css', NULL);
-INSERT INTO theme (the_name, the_filestyle, the_filebutton) VALUES 
('Mandarine', 'style-mandarine.css', NULL);
-INSERT INTO theme (the_name, the_filestyle, the_filebutton) VALUES ('Mobile', 
'style-mobile.css', NULL);
 INSERT INTO theme (the_name, the_filestyle, the_filebutton) VALUES 
('Classique', 'style-classic.css', NULL);
+INSERT INTO theme (the_name, the_filestyle, the_filebutton) VALUES 
('Classic7', 'style-classic7.css', NULL);
 
 
 
@@ -72,8 +71,11 @@ INSERT INTO user_global_pref (user_id, parameter_type, 
parameter_value) VALUES (
 INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'PAGESIZE', '50');
 INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'LANG', 'fr_FR.utf8');
 INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'TOPMENU', 'TEXT');
-INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('demo', 'THEME', 'Classique');
-INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'THEME', 'Classique');
+INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('demo', 'THEME', 'Classic7');
+INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'THEME', 'Classic7');
+INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'csv_fieldsep', '0');
+INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'csv_decimal', '0');
+INSERT INTO user_global_pref (user_id, parameter_type, parameter_value) VALUES 
('admin', 'csv_encoding', 'utf8');
 
 
 
@@ -81,7 +83,7 @@ SELECT pg_catalog.setval('users_id', 5, true);
 
 
 
-INSERT INTO version (val) VALUES (17);
+INSERT INTO version (val) VALUES (18);
 
 
 
diff --git a/include/sql/account_repository/schema.sql 
b/include/sql/account_repository/schema.sql
index 26b9d8c..00b59bd 100644
--- a/include/sql/account_repository/schema.sql
+++ b/include/sql/account_repository/schema.sql
@@ -172,6 +172,14 @@ CREATE TABLE modeledef (
 
 
 
+CREATE TABLE progress (
+    p_id character varying(16) NOT NULL,
+    p_value numeric(5,2) NOT NULL,
+    p_created timestamp without time zone DEFAULT now()
+);
+
+
+
 CREATE TABLE recover_pass (
     use_id bigint NOT NULL,
     request text NOT NULL,
@@ -300,6 +308,12 @@ CREATE TABLE version (
 
 
 
+
+
+
+
+
+
 CREATE INDEX audit_connect_ac_user ON audit_connect USING btree (ac_user);
 
 
diff --git a/include/sql/account_repository/table.sql 
b/include/sql/account_repository/table.sql
index 6f60124..59e0742 100644
--- a/include/sql/account_repository/table.sql
+++ b/include/sql/account_repository/table.sql
@@ -41,6 +41,11 @@ CREATE TABLE modeledef (
     mod_name text NOT NULL,
     mod_desc text
 );
+CREATE TABLE progress (
+    p_id character varying(16) NOT NULL,
+    p_value numeric(5,2) NOT NULL,
+    p_created timestamp without time zone DEFAULT now()
+);
 CREATE TABLE recover_pass (
     use_id bigint NOT NULL,
     request text NOT NULL,