phpcompta-dev
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpcompta-dev] r5407 - phpcompta/trunk/sql


From: phpcompta-dev
Subject: [Phpcompta-dev] r5407 - phpcompta/trunk/sql
Date: Thu, 19 Sep 2013 16:44:44 +0200 (CEST)

Author: danydb
Date: 2013-09-19 16:44:44 +0200 (Thu, 19 Sep 2013)
New Revision: 5407

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
upgrade : add tags

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2013-09-19 14:24:39 UTC (rev 5406)
+++ phpcompta/trunk/sql/upgrade.sql     2013-09-19 14:44:44 UTC (rev 5407)
@@ -170,4 +170,26 @@
 comment on table bookmark is 'Bookmark of the connected user';
 /*
  * Missing update for preference !!!
- */
\ No newline at end of file
+ */
+
+create table tags (
+    t_id serial primary key, 
+    t_tag text not null, 
+    t_description text
+);
+
+create table action_tags
+(
+    at_id serial primary key,
+    t_id integer references tags(t_id) on delete cascade on update cascade,
+    ag_id integer references action_gestion(ag_id) on delete cascade on update 
cascade
+);
+/* Config tag */
+insert into menu_ref(me_code,me_menu,me_file, 
me_url,me_description,me_parameter,me_javascript,me_type,me_description_etendue)
+values
+('CFGTAG','Configuration dossier','cfgtags.inc.php',null,'Configuration des 
dossiers',null,null,'ME','Configuration des tags ou dossiers, on l''appele tag 
ou dossier suivant la façon dont vous utilisez 
+cette fonctionnalité. Vous pouvez en ajouter, en supprimer ou les modifier');
+
+insert into profile_menu (me_code,me_code_dep,p_id,p_order, 
p_type_display,pm_default) 
+values
+('CFGTAG','PARAM',1,390,'E',0);
\ No newline at end of file



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu



reply via email to

[Prev in Thread] Current Thread [Next in Thread]