[Noalyss-commit] [noalyss] 20/219: Add new theme and modify tmp_pcmn

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 52849e775f915f47e3e19c1f003fa79fb6ed9cca
Author: Dany De Bontridder <address@hidden>
Date:   Sun Jul 23 13:24:35 2017 +0200

    Add new theme and  modify tmp_pcmn
---
 sql/upgrade.sql | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index e7e99f1..80cb811 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1 +1,12 @@
-alter table action_gestion drop ag_ref_ag_id;
\ No newline at end of file
+alter table action_gestion drop ag_ref_ag_id;
+--- repository insert into theme (the_name,the_filestyle) values ('Classic 
692','style-r692.css');
+
+ALTER TABLE tmp_pcmn   ADD CONSTRAINT id_ux UNIQUE(id);
+ALTER TABLE tmp_pcmn ADD COLUMN id bigint;
+ALTER TABLE tmp_pcmn ALTER COLUMN id SET NOT NULL;
+ALTER TABLE tmp_pcmn ALTER COLUMN id SET DEFAULT 
nextval('tmp_pcmn_id_seq'::regclass);
+COMMENT ON COLUMN tmp_pcmn.id IS 'allow to identify the row, it is unique and 
not null (pseudo pk)';
+
+
+
+