[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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5407 - phpcompta/trunk/sql,
phpcompta-dev <=