[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4832 - phpcompta/branches/rel601-ovh/contrib/mono-dossi
|
From: |
phpcompta-dev |
|
Subject: |
[Phpcompta-dev] r4832 - phpcompta/branches/rel601-ovh/contrib/mono-dossier |
|
Date: |
Tue, 15 May 2012 13:38:45 +0200 (CEST) |
Author: danydb
Date: 2012-05-15 13:38:45 +0200 (Tue, 15 May 2012)
New Revision: 4832
Modified:
phpcompta/branches/rel601-ovh/contrib/mono-dossier/mono-belge.sql
Log:
FIX BUG : extension TVA dans le mod?\195?\168le
Modified: phpcompta/branches/rel601-ovh/contrib/mono-dossier/mono-belge.sql
===================================================================
--- phpcompta/branches/rel601-ovh/contrib/mono-dossier/mono-belge.sql
2012-05-15 11:33:42 UTC (rev 4831)
+++ phpcompta/branches/rel601-ovh/contrib/mono-dossier/mono-belge.sql
2012-05-15 11:38:45 UTC (rev 4832)
@@ -419,7 +419,7 @@
AS $$
begin
insert into fiche_detail (f_id,ad_id, ad_value) values
(p_f_id,p_ad_id,p_value);
-
+
return;
end;
$$;
@@ -497,29 +497,29 @@
CREATE FUNCTION check_balance(p_grpt integer) RETURNS numeric
LANGUAGE plpgsql
AS $$
-declare
+declare
amount_jrnx_debit numeric;
amount_jrnx_credit numeric;
amount_jrn numeric;
begin
- select sum (j_montant) into amount_jrnx_credit
- from jrnx
- where
+ select sum (j_montant) into amount_jrnx_credit
+ from jrnx
+ where
j_grpt=p_grpt
and j_debit=false;
- select sum (j_montant) into amount_jrnx_debit
- from jrnx
- where
+ select sum (j_montant) into amount_jrnx_debit
+ from jrnx
+ where
j_grpt=p_grpt
and j_debit=true;
- select jr_montant into amount_jrn
+ select jr_montant into amount_jrn
from jrn
where
jr_grpt_id=p_grpt;
- if ( amount_jrnx_debit != amount_jrnx_credit )
+ if ( amount_jrnx_debit != amount_jrnx_credit )
then
return abs(amount_jrnx_debit-amount_jrnx_credit);
end if;
@@ -561,7 +561,7 @@
max_sequence := 0;
end if;
raise notice 'Max value of the sequence is %', max_sequence;
- max_sequence:= max_sequence +1;
+ max_sequence:= max_sequence +1;
execute 'alter sequence '||p_sequence||' restart with '||max_sequence;
return 0;
@@ -612,7 +612,7 @@
CREATE FUNCTION drop_index(p_constraint character varying) RETURNS void
LANGUAGE plpgsql
AS $$
-declare
+declare
nCount integer;
begin
select count(*) into nCount from pg_indexes where
indexname=p_constraint;
@@ -630,7 +630,7 @@
CREATE FUNCTION drop_it(p_constraint character varying) RETURNS void
LANGUAGE plpgsql
AS $$
-declare
+declare
nCount integer;
begin
select count(*) into nCount from pg_constraint where
conname=p_constraint;
@@ -707,17 +707,17 @@
begin
open list_missing;
loop
-
+
fetch list_missing into rec;
IF NOT FOUND then
exit;
end if;
-
+
-- now we insert into attr_value
insert into fiche_detail (f_id,ad_id,ad_value) values
(rec.f_id,rec.ad_id,null);
end loop;
close list_missing;
-end;
+end;
$$;
@@ -763,15 +763,15 @@
select p_value into sCassa from parm_code where p_code='CAISSE';
select p_value into sSupplier from parm_code where p_code='SUPPLIER';
select p_value into sCustomer from parm_code where p_code='CUSTOMER';
-
- for rec in select jr_id,jr_grpt_id from jrn
+
+ for rec in select jr_id,jr_grpt_id from jrn
where jr_def_id in (select jrn_def_id from jrn_def where
jrn_def_type='FIN')
and jr_id not in (select jr_id from quant_fin)
loop
-- there are only 2 lines for bank operations
-- first debit
select count(j_id) into nCount from jrnx where
j_grpt=rec.jr_grpt_id;
- if nCount > 2 then
+ if nCount > 2 then
raise notice 'Trop de valeur pour jr_grpt_id % count
%',rec.jr_grpt_id,nCount;
return;
end if;
@@ -783,7 +783,7 @@
select f_id into nBank from vw_poste_qcode where
j_qcode=recBank.j_qcode;
if recBank.j_debit = false then
nAmount=recBank.j_montant*(-1);
- else
+ else
nAmount=recBank.j_montant;
end if;
else
@@ -794,13 +794,13 @@
insert into quant_fin
(jr_id,qf_bank,qf_other,qf_amount) values (rec.jr_id,nBank,nOther,nAmount);
end if;
end loop;
- for rec in select jr_id,jr_grpt_id from jrn
+ for rec in select jr_id,jr_grpt_id from jrn
where jr_def_id in (select jrn_def_id from jrn_def where
jrn_def_type='FIN') and jr_id not in (select jr_id from quant_fin)
loop
-- there are only 2 lines for bank operations
-- first debit
select count(j_id) into nCount from jrnx where
j_grpt=rec.jr_grpt_id;
- if nCount > 2 then
+ if nCount > 2 then
raise notice 'Trop de valeur pour jr_grpt_id % count
%',rec.jr_grpt_id,nCount;
return;
end if;
@@ -812,7 +812,7 @@
select f_id into nBank from vw_poste_qcode where
j_qcode=recBank.j_qcode;
if recBank.j_debit = false then
nAmount=recBank.j_montant*(-1);
- else
+ else
nAmount=recBank.j_montant;
end if;
else
@@ -824,13 +824,13 @@
end if;
end loop;
- for rec in select jr_id,jr_grpt_id from jrn
+ for rec in select jr_id,jr_grpt_id from jrn
where jr_def_id in (select jrn_def_id from jrn_def where
jrn_def_type='FIN') and jr_id not in (select jr_id from quant_fin)
loop
-- there are only 2 lines for bank operations
-- first debit
select count(j_id) into nCount from jrnx where
j_grpt=rec.jr_grpt_id;
- if nCount > 2 then
+ if nCount > 2 then
raise notice 'Trop de valeur pour jr_grpt_id % count
%',rec.jr_grpt_id,nCount;
return;
end if;
@@ -842,19 +842,19 @@
select f_id into nSupp_Cust from vw_poste_qcode where
j_qcode=recSupp_Cust.j_qcode;
if recSupp_Cust.j_debit = true then
nAmount=recSupp_Cust.j_montant*(-1);
- else
+ else
nAmount=recSupp_Cust.j_montant;
end if;
else if recSupp_Cust.j_poste like sCustomer||'%' then
select f_id into nSupp_Cust from vw_poste_qcode where
j_qcode=recSupp_Cust.j_qcode;
if recSupp_Cust.j_debit = false then
nAmount=recSupp_Cust.j_montant*(-1);
- else
+ else
nAmount=recSupp_Cust.j_montant;
end if;
else
select f_id into nOther from vw_poste_qcode where
j_qcode=recSupp_Cust.j_qcode;
-
+
end if;
end if;
end loop;
@@ -862,13 +862,13 @@
insert into quant_fin
(jr_id,qf_bank,qf_other,qf_amount) values (rec.jr_id,nOther,nSupp_Cust,nAmount);
end if;
end loop;
- for rec in select jr_id,jr_grpt_id from jrn
+ for rec in select jr_id,jr_grpt_id from jrn
where jr_def_id in (select jrn_def_id from jrn_def where
jrn_def_type='FIN') and jr_id not in (select jr_id from quant_fin)
loop
-- there are only 2 lines for bank operations
-- first debit
select count(j_id) into nCount from jrnx where
j_grpt=rec.jr_grpt_id;
- if nCount > 2 then
+ if nCount > 2 then
raise notice 'Trop de valeur pour jr_grpt_id % count
%',rec.jr_grpt_id,nCount;
return;
end if;
@@ -880,13 +880,13 @@
select f_id into nSupp_Cust from vw_poste_qcode where
j_qcode=recSupp_Cust.j_qcode;
if recSupp_Cust.j_debit = false then
nAmount=recSupp_Cust.j_montant*(-1);
- else
+ else
nAmount=recSupp_Cust.j_montant;
end if;
else
select f_id into nOther from vw_poste_qcode where
j_qcode=recSupp_Cust.j_qcode;
-
-
+
+
end if;
end loop;
if nSupp_Cust != 0 and nOther != 0 then
@@ -1104,7 +1104,7 @@
CREATE FUNCTION group_analytic_ins_upd() RETURNS trigger
LANGUAGE plpgsql
AS $$
-declare
+declare
name text;
begin
name:=upper(NEW.ga_id);
@@ -1161,7 +1161,7 @@
CREATE FUNCTION info_def_ins_upd() RETURNS trigger
LANGUAGE plpgsql
AS $$
-declare
+declare
row_info_def info_def%ROWTYPE;
str_type text;
begin
@@ -1305,7 +1305,7 @@
begin
tText := upper(trim(tav_text));
tText := replace(tText,' ','');
-
+
loop
-- take the next sequence
select nextval('s_jnt_fic_att_value') into ns;
@@ -1313,9 +1313,9 @@
tText := 'FID'||ns;
end if;
-- av_text already used ?
- select count(*) into nExist
+ select count(*) into nExist
from fiche_detail
- where
+ where
ad_id=23 and ad_value=upper(tText);
if nExist = 0 then
@@ -1395,16 +1395,16 @@
delete from jrn_note where jr_id= p_jrid;
return;
end if;
-
+
select n_id into tmp from jrn_note where jr_id = p_jrid;
-
+
if FOUND then
update jrn_note set n_text=trim(p_note) where jr_id = p_jrid;
- else
+ else
insert into jrn_note (jr_id,n_text) values ( p_jrid, p_note);
end if;
-
+
return;
end;
$$;
@@ -1483,7 +1483,7 @@
CREATE FUNCTION jrn_def_delete() RETURNS trigger
LANGUAGE plpgsql
AS $$
-declare
+declare
nb numeric;
begin
select count(*) into nb from jrn where jr_def_id=OLD.jrn_def_id;
@@ -1525,7 +1525,7 @@
jr_pj_name,
jr_pj_type,
jr_pj_number,
- del_jrn_date)
+ del_jrn_date)
select jr_id,
jr_def_id,
jr_montant,
@@ -1565,10 +1565,10 @@
insert into del_jrnx(
- j_id, j_date, j_montant, j_poste, j_grpt, j_rapt, j_jrn_def,
- j_debit, j_text, j_centralized, j_internal, j_tech_user,
j_tech_date,
- j_tech_per, j_qcode, f_id) SELECT j_id, j_date, j_montant,
j_poste, j_grpt, j_rapt, j_jrn_def,
- j_debit, j_text, j_centralized, j_internal, j_tech_user, j_tech_date,
+ j_id, j_date, j_montant, j_poste, j_grpt, j_rapt, j_jrn_def,
+ j_debit, j_text, j_centralized, j_internal, j_tech_user,
j_tech_date,
+ j_tech_per, j_qcode, f_id) SELECT j_id, j_date, j_montant,
j_poste, j_grpt, j_rapt, j_jrn_def,
+ j_debit, j_text, j_centralized, j_internal, j_tech_user, j_tech_date,
j_tech_per, j_qcode, f_id from jrnx where j_id=row.j_id;
return row;
end;
@@ -1622,8 +1622,8 @@
row jrnx%ROWTYPE;
begin
row:=OLD;
-delete from jnt_letter
- where (jl_id in (select jl_id from letter_deb) and jl_id not in(select
jl_id from letter_cred ))
+delete from jnt_letter
+ where (jl_id in (select jl_id from letter_deb) and jl_id not in(select
jl_id from letter_cred ))
or (jl_id not in (select jl_id from letter_deb ) and jl_id
in(select jl_id from letter_cred ));
return row;
end;
@@ -1662,7 +1662,7 @@
begin
name:=upper(NEW.po_name);
name:=trim(name);
-name:=replace(name,' ','');
+name:=replace(name,' ','');
NEW.po_name:=name;
if NEW.ga_id is NULL then
@@ -1688,7 +1688,7 @@
CREATE FUNCTION proc_check_balance() RETURNS trigger
LANGUAGE plpgsql
AS $$
-declare
+declare
diff numeric;
tt integer;
begin
@@ -1745,7 +1745,7 @@
CREATE FUNCTION t_document_modele_validate() RETURNS trigger
LANGUAGE plpgsql
AS $$
-declare
+declare
lText text;
modified document_modele%ROWTYPE;
begin
@@ -1805,7 +1805,7 @@
nCounter integer;
BEGIN
- select count(*) into nCounter
+ select count(*) into nCounter
from pg_class where relname='s_jrn_'||NEW.jrn_def_id;
if nCounter = 0 then
execute 'create sequence s_jrn_'||NEW.jrn_def_id;
@@ -1849,7 +1849,7 @@
sResult := sWhere || sql_from || sAnd || sql_to;
for ret in EXECUTE 'SELECT po.po_id,
- po.pa_id, po.po_name,
+ po.pa_id, po.po_name,
po.po_description,sum(
CASE
WHEN operation_analytique.oa_debit = true THEN
operation_analytique.oa_amount * (-1)::numeric
@@ -2020,7 +2020,7 @@
CREATE FUNCTION tva_delete(integer) RETURNS void
LANGUAGE plpgsql
- AS $_$
+ AS $_$
declare
p_tva_id alias for $1;
nCount integer;
@@ -2029,12 +2029,12 @@
select count(*) into nCount from quant_sold where qs_vat_code=p_tva_id;
if nCount != 0 then
return;
-
+
end if;
select count(*) into nCount from quant_purchase where
qp_vat_code=p_tva_id;
if nCount != 0 then
return;
-
+
end if;
delete from tva_rate where tva_id=p_tva_id;
@@ -2141,39 +2141,39 @@
if tav_text = upper( trim(old_qcode)) then
return 0;
end if;
-
+
tText := trim(upper(tav_text));
tText := replace(tText,' ','');
if length ( tText) = 0 or tText is null then
return 0;
end if;
-
+
ns := njft_id;
loop
-- av_text already used ?
- select count(*) into nExist
+ select count(*) into nExist
from fiche_detail
- where
+ where
ad_id=23 and ad_value=tText;
if nExist = 0 then
exit;
- end if;
+ end if;
if tText = 'FID'||ns then
-- take the next sequence
select nextval('s_jnt_fic_att_value') into ns;
end if;
tText :='FID'||ns;
-
+
end loop;
update fiche_detail set ad_value = tText where jft_id=njft_id;
-- update also the contact
- update fiche_detail set ad_value = tText
- where jft_id in
- ( select jft_id
- from fiche_detail
+ update fiche_detail set ad_value = tText
+ where jft_id in
+ ( select jft_id
+ from fiche_detail
where ad_id=25 and ad_value=old_qcode);
@@ -2251,7 +2251,7 @@
select jr_internal,j_id,j_montant into r_new
from jrnx join jrn on (j_grpt=jr_grpt_id)
- where
+ where
j_jrn_def=r_jrnx.j_jrn_def
and j_id not in (select j_id from quant_purchase)
and j_qcode=s_QuickCode
@@ -2261,7 +2261,7 @@
if NOT FOUND then
raise notice 'error not found %', r_invalid.j_id;
update quant_purchase set qp_valid='Y' where qp_id=r_invalid.qp_id;
- continue;
+ continue;
end if;
raise notice 'j_id % found amount %',r_new.j_id,r_new.j_montant;
@@ -2306,7 +2306,7 @@
select jr_internal,j_id,j_montant into r_new
from jrnx join jrn on (j_grpt=jr_grpt_id)
- where
+ where
j_jrn_def=r_jrnx.j_jrn_def
and j_id not in (select j_id from quant_sold)
and j_qcode=s_QuickCode
@@ -2335,7 +2335,7 @@
SET default_with_oids = true;
--
--- Name: action; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: action; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE action (
@@ -2363,7 +2363,7 @@
SET default_with_oids = false;
--
--- Name: action_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: action_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE action_detail (
@@ -2483,7 +2483,7 @@
SET default_with_oids = true;
--
--- Name: action_gestion; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: action_gestion; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE action_gestion (
@@ -2604,7 +2604,7 @@
--
--- Name: attr_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: attr_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE attr_def (
@@ -2623,7 +2623,7 @@
--
--- Name: attr_min; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: attr_min; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE attr_min (
@@ -2661,7 +2661,7 @@
SET default_with_oids = false;
--
--- Name: bilan; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: bilan; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE bilan (
@@ -2775,7 +2775,7 @@
SET default_with_oids = true;
--
--- Name: centralized; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: centralized; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE centralized (
@@ -2806,7 +2806,7 @@
SET default_with_oids = false;
--
--- Name: del_action; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: del_action; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE del_action (
@@ -2843,7 +2843,7 @@
--
--- Name: del_jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: del_jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE del_jrn (
@@ -2898,7 +2898,7 @@
--
--- Name: del_jrnx; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: del_jrnx; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE del_jrnx (
@@ -2970,7 +2970,7 @@
SET default_with_oids = true;
--
--- Name: document; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: document; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE document (
@@ -3010,7 +3010,7 @@
--
--- Name: document_modele; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: document_modele; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE document_modele (
@@ -3077,7 +3077,7 @@
--
--- Name: document_state; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: document_state; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE document_state (
@@ -3113,7 +3113,7 @@
--
--- Name: document_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: document_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE document_type (
@@ -3132,7 +3132,7 @@
SET default_with_oids = false;
--
--- Name: extension; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: extension; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE extension (
@@ -3223,7 +3223,7 @@
SET default_with_oids = true;
--
--- Name: fiche; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: fiche; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE fiche (
@@ -3240,7 +3240,7 @@
--
--- Name: fiche_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: fiche_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE fiche_def (
@@ -3260,7 +3260,7 @@
--
--- Name: fiche_def_ref; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: fiche_def_ref; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE fiche_def_ref (
@@ -3278,7 +3278,7 @@
--
--- Name: fiche_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: fiche_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE fiche_detail (
@@ -3299,7 +3299,7 @@
SET default_with_oids = false;
--
--- Name: forecast; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: forecast; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE forecast (
@@ -3318,7 +3318,7 @@
--
--- Name: forecast_cat; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: forecast_cat; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE forecast_cat (
@@ -3410,7 +3410,7 @@
--
--- Name: forecast_item; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: forecast_item; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE forecast_item (
@@ -3511,7 +3511,7 @@
SET default_with_oids = true;
--
--- Name: form; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: form; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE form (
@@ -3531,7 +3531,7 @@
--
--- Name: formdef; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: formdef; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE formdef (
@@ -3543,7 +3543,7 @@
SET default_with_oids = false;
--
--- Name: groupe_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: groupe_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE groupe_analytique (
@@ -3573,7 +3573,7 @@
--
--- Name: info_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: info_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE info_def (
@@ -3611,7 +3611,7 @@
SET default_with_oids = true;
--
--- Name: jnt_fic_attr; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jnt_fic_attr; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jnt_fic_attr (
@@ -3632,7 +3632,7 @@
SET default_with_oids = false;
--
--- Name: jnt_letter; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jnt_letter; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jnt_letter (
@@ -3670,7 +3670,7 @@
SET default_with_oids = true;
--
--- Name: jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn (
@@ -3705,7 +3705,7 @@
--
--- Name: jrn_action; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_action; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_action (
@@ -3727,7 +3727,7 @@
--
--- Name: jrn_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_def; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_def (
@@ -3759,7 +3759,7 @@
SET default_with_oids = false;
--
--- Name: jrn_info; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_info; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_info (
@@ -3797,7 +3797,7 @@
--
--- Name: jrn_note; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_note; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_note (
@@ -3841,7 +3841,7 @@
--
--- Name: jrn_periode; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_periode; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_periode (
@@ -3854,7 +3854,7 @@
SET default_with_oids = true;
--
--- Name: jrn_rapt; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_rapt; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_rapt (
@@ -3872,7 +3872,7 @@
--
--- Name: jrn_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrn_type (
@@ -3889,7 +3889,7 @@
--
--- Name: jrnx; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: jrnx; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE jrnx (
@@ -3922,7 +3922,7 @@
SET default_with_oids = false;
--
--- Name: letter_cred; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: letter_cred; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE letter_cred (
@@ -3959,7 +3959,7 @@
--
--- Name: letter_deb; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: letter_deb; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE letter_deb (
@@ -3996,7 +3996,7 @@
--
--- Name: menu_ref; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: menu_ref; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE menu_ref (
@@ -4050,7 +4050,7 @@
--
--- Name: mod_payment; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: mod_payment; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE mod_payment (
@@ -4123,7 +4123,7 @@
--
--- Name: op_predef; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: op_predef; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE op_predef (
@@ -4177,7 +4177,7 @@
--
--- Name: op_predef_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: op_predef_detail; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE op_predef_detail (
@@ -4221,7 +4221,7 @@
--
--- Name: operation_analytique; Type: TABLE; Schema: public; Owner: -;
Tablespace:
+-- Name: operation_analytique; Type: TABLE; Schema: public; Owner: -;
Tablespace:
--
CREATE TABLE operation_analytique (
@@ -4248,7 +4248,7 @@
SET default_with_oids = true;
--
--- Name: parameter; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: parameter; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE parameter (
@@ -4265,7 +4265,7 @@
--
--- Name: parm_code; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: parm_code; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE parm_code (
@@ -4276,7 +4276,7 @@
--
--- Name: parm_money; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: parm_money; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE parm_money (
@@ -4294,7 +4294,7 @@
--
--- Name: parm_periode; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: parm_periode; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE parm_periode (
@@ -4318,7 +4318,7 @@
SET default_with_oids = false;
--
--- Name: parm_poste; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: parm_poste; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE parm_poste (
@@ -4354,7 +4354,7 @@
--
--- Name: plan_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: plan_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE plan_analytique (
@@ -4391,7 +4391,7 @@
--
--- Name: poste_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: poste_analytique; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE poste_analytique (
@@ -4412,7 +4412,7 @@
--
--- Name: profile; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: profile; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE profile (
@@ -4460,7 +4460,7 @@
--
--- Name: profile_menu; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: profile_menu; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE profile_menu (
@@ -4545,7 +4545,7 @@
--
--- Name: profile_menu_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: profile_menu_type; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE profile_menu_type (
@@ -4581,7 +4581,7 @@
--
--- Name: profile_user; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: profile_user; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE profile_user (
@@ -4639,7 +4639,7 @@
--
--- Name: quant_fin; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: quant_fin; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE quant_fin (
@@ -4685,7 +4685,7 @@
--
--- Name: quant_purchase; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: quant_purchase; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE quant_purchase (
@@ -4717,7 +4717,7 @@
SET default_with_oids = true;
--
--- Name: quant_sold; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: quant_sold; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE quant_sold (
@@ -5712,7 +5712,7 @@
--
--- Name: stock_goods; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: stock_goods; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE stock_goods (
@@ -5739,7 +5739,7 @@
--
--- Name: tmp_pcmn; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: tmp_pcmn; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE tmp_pcmn (
@@ -5779,7 +5779,7 @@
SET default_with_oids = false;
--
--- Name: todo_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: todo_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE todo_list (
@@ -5801,7 +5801,7 @@
SET default_with_oids = true;
--
--- Name: tva_rate; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: tva_rate; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE tva_rate (
@@ -5822,7 +5822,7 @@
--
--- Name: user_local_pref; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_local_pref; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE user_local_pref (
@@ -5861,7 +5861,7 @@
--
--- Name: user_sec_act; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_sec_act; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE user_sec_act (
@@ -5874,7 +5874,7 @@
SET default_with_oids = false;
--
--- Name: user_sec_extension; Type: TABLE; Schema: public; Owner: -;
Tablespace:
+-- Name: user_sec_extension; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE user_sec_extension (
@@ -5921,7 +5921,7 @@
SET default_with_oids = true;
--
--- Name: user_sec_jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_sec_jrn; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE user_sec_jrn (
@@ -5941,7 +5941,7 @@
--
--- Name: version; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: version; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE version (
@@ -6414,15 +6414,7 @@
\.
---
--- Data for Name: extension; Type: TABLE DATA; Schema: public; Owner: -
---
-COPY extension (ex_id, ex_name, ex_code, ex_desc, ex_file, ex_enable) FROM
stdin;
-1 Module de TVA TVA Cette extension permet de faire les listings et
declarations TVA tva/index.php Y
-\.
-
-
--
-- Data for Name: fiche; Type: TABLE DATA; Schema: public; Owner: -
--
@@ -7942,7 +7934,7 @@
--
--- Name: action_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: action_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY action_detail
@@ -7950,7 +7942,7 @@
--
--- Name: action_gestion_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: action_gestion_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY action_gestion
@@ -7958,7 +7950,7 @@
--
--- Name: action_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: action_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY action
@@ -7966,7 +7958,7 @@
--
--- Name: attr_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: attr_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY attr_def
@@ -7974,7 +7966,7 @@
--
--- Name: bilan_b_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: bilan_b_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY bilan
@@ -7982,7 +7974,7 @@
--
--- Name: bilan_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: bilan_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY bilan
@@ -7990,7 +7982,7 @@
--
--- Name: centralized_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: centralized_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY centralized
@@ -7998,7 +7990,7 @@
--
--- Name: del_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: del_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY del_action
@@ -8006,7 +7998,7 @@
--
--- Name: dj_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: dj_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY del_jrn
@@ -8014,7 +8006,7 @@
--
--- Name: djx_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: djx_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY del_jrnx
@@ -8022,7 +8014,7 @@
--
--- Name: document_modele_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: document_modele_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY document_modele
@@ -8030,7 +8022,7 @@
--
--- Name: document_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: document_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY document
@@ -8038,7 +8030,7 @@
--
--- Name: document_state_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: document_state_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY document_state
@@ -8046,7 +8038,7 @@
--
--- Name: document_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: document_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY document_type
@@ -8054,7 +8046,7 @@
--
--- Name: fiche_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: fiche_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY fiche_def
@@ -8062,7 +8054,7 @@
--
--- Name: fiche_def_ref_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: fiche_def_ref_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY fiche_def_ref
@@ -8070,7 +8062,7 @@
--
--- Name: fiche_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: fiche_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY fiche
@@ -8078,7 +8070,7 @@
--
--- Name: forecast_cat_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: forecast_cat_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY forecast_cat
@@ -8086,7 +8078,7 @@
--
--- Name: forecast_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: forecast_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY forecast_item
@@ -8094,7 +8086,7 @@
--
--- Name: forecast_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: forecast_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY forecast
@@ -8102,7 +8094,7 @@
--
--- Name: form_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: form_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY form
@@ -8110,7 +8102,7 @@
--
--- Name: formdef_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: formdef_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY formdef
@@ -8118,7 +8110,7 @@
--
--- Name: frd_ad_attr_min_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: frd_ad_attr_min_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY attr_min
@@ -8126,7 +8118,7 @@
--
--- Name: historique_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
+-- Name: historique_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
--
ALTER TABLE ONLY operation_analytique
@@ -8134,7 +8126,7 @@
--
--- Name: idx_ex_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: idx_ex_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY extension
@@ -8142,7 +8134,7 @@
--
--- Name: info_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: info_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY info_def
@@ -8150,7 +8142,7 @@
--
--- Name: jnt_fic_att_value_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jnt_fic_att_value_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY fiche_detail
@@ -8158,7 +8150,7 @@
--
--- Name: jnt_letter_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jnt_letter_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jnt_letter
@@ -8166,7 +8158,7 @@
--
--- Name: jrn_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY jrn_action
@@ -8174,7 +8166,7 @@
--
--- Name: jrn_def_jrn_def_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_def_jrn_def_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY jrn_def
@@ -8182,7 +8174,7 @@
--
--- Name: jrn_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn_def
@@ -8190,7 +8182,7 @@
--
--- Name: jrn_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn_info
@@ -8198,7 +8190,7 @@
--
--- Name: jrn_periode_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_periode_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY jrn_periode
@@ -8206,7 +8198,7 @@
--
--- Name: jrn_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: jrn_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn
@@ -8214,7 +8206,7 @@
--
--- Name: jrn_rapt_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_rapt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn_rapt
@@ -8222,7 +8214,7 @@
--
--- Name: jrn_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrn_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn_type
@@ -8230,7 +8222,7 @@
--
--- Name: jrnx_note_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: jrnx_note_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY jrn_note
@@ -8238,7 +8230,7 @@
--
--- Name: jrnx_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: jrnx_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrnx
@@ -8246,7 +8238,7 @@
--
--- Name: letter_cred_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: letter_cred_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY letter_cred
@@ -8254,7 +8246,7 @@
--
--- Name: letter_deb_pk; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: letter_deb_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY letter_deb
@@ -8262,7 +8254,7 @@
--
--- Name: menu_ref_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: menu_ref_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY menu_ref
@@ -8270,7 +8262,7 @@
--
--- Name: mod_payment_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: mod_payment_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY mod_payment
@@ -8278,7 +8270,7 @@
--
--- Name: op_def_op_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: op_def_op_name_key; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY op_predef
@@ -8286,7 +8278,7 @@
--
--- Name: op_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: op_def_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY op_predef
@@ -8294,7 +8286,7 @@
--
--- Name: op_predef_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: op_predef_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY op_predef_detail
@@ -8302,7 +8294,7 @@
--
--- Name: parameter_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: parameter_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY parameter
@@ -8310,7 +8302,7 @@
--
--- Name: parm_code_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: parm_code_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY parm_code
@@ -8318,7 +8310,7 @@
--
--- Name: parm_money_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: parm_money_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY parm_money
@@ -8326,7 +8318,7 @@
--
--- Name: parm_periode_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: parm_periode_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY parm_periode
@@ -8334,7 +8326,7 @@
--
--- Name: parm_poste_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: parm_poste_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY parm_poste
@@ -8342,7 +8334,7 @@
--
--- Name: pk_extension; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: pk_extension; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY extension
@@ -8350,7 +8342,7 @@
--
--- Name: pk_ga_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: pk_ga_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY groupe_analytique
@@ -8358,7 +8350,7 @@
--
--- Name: pk_jnt_fic_attr; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: pk_jnt_fic_attr; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY jnt_fic_attr
@@ -8366,7 +8358,7 @@
--
--- Name: pk_user_local_pref; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: pk_user_local_pref; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY user_local_pref
@@ -8374,7 +8366,7 @@
--
--- Name: plan_analytique_pa_name_key; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
+-- Name: plan_analytique_pa_name_key; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
--
ALTER TABLE ONLY plan_analytique
@@ -8382,7 +8374,7 @@
--
--- Name: plan_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: plan_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY plan_analytique
@@ -8390,7 +8382,7 @@
--
--- Name: poste_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: poste_analytique_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY poste_analytique
@@ -8398,7 +8390,7 @@
--
--- Name: profile_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: profile_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY profile_menu
@@ -8406,7 +8398,7 @@
--
--- Name: profile_menu_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: profile_menu_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY profile_menu_type
@@ -8414,7 +8406,7 @@
--
--- Name: profile_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: profile_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY profile
@@ -8422,7 +8414,7 @@
--
--- Name: profile_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: profile_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY profile_user
@@ -8430,7 +8422,7 @@
--
--- Name: profile_user_user_name_key; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
+-- Name: profile_user_user_name_key; Type: CONSTRAINT; Schema: public; Owner:
-; Tablespace:
--
ALTER TABLE ONLY profile_user
@@ -8438,7 +8430,7 @@
--
--- Name: qp_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: qp_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY quant_purchase
@@ -8446,7 +8438,7 @@
--
--- Name: qs_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: qs_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY quant_sold
@@ -8454,7 +8446,7 @@
--
--- Name: quant_fin_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: quant_fin_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY quant_fin
@@ -8462,7 +8454,7 @@
--
--- Name: stock_goods_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: stock_goods_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY stock_goods
@@ -8470,7 +8462,7 @@
--
--- Name: tmp_pcmn_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: tmp_pcmn_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY tmp_pcmn
@@ -8478,7 +8470,7 @@
--
--- Name: todo_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: todo_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY todo_list
@@ -8486,7 +8478,7 @@
--
--- Name: tva_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: tva_id_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY tva_rate
@@ -8494,7 +8486,7 @@
--
--- Name: user_sec_act_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: user_sec_act_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY user_sec_act
@@ -8502,7 +8494,7 @@
--
--- Name: user_sec_extension_ex_id_key; Type: CONSTRAINT; Schema: public;
Owner: -; Tablespace:
+-- Name: user_sec_extension_ex_id_key; Type: CONSTRAINT; Schema: public;
Owner: -; Tablespace:
--
ALTER TABLE ONLY user_sec_extension
@@ -8510,7 +8502,7 @@
--
--- Name: user_sec_extension_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: user_sec_extension_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY user_sec_extension
@@ -8518,7 +8510,7 @@
--
--- Name: user_sec_jrn_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
+-- Name: user_sec_jrn_pkey; Type: CONSTRAINT; Schema: public; Owner: -;
Tablespace:
--
ALTER TABLE ONLY user_sec_jrn
@@ -8526,7 +8518,7 @@
--
--- Name: ux_internal; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: ux_internal; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY jrn
@@ -8534,168 +8526,168 @@
--
--- Name: fd_id_ad_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: fd_id_ad_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX fd_id_ad_id_x ON jnt_fic_attr USING btree (fd_id, ad_id);
--
--- Name: fiche_detail_f_id_ad_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fiche_detail_f_id_ad_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE UNIQUE INDEX fiche_detail_f_id_ad_id ON fiche_detail USING btree (f_id,
ad_id);
--
--- Name: fk_stock_goods_f_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fk_stock_goods_f_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX fk_stock_goods_f_id ON stock_goods USING btree (f_id);
--
--- Name: fk_stock_goods_j_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fk_stock_goods_j_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX fk_stock_goods_j_id ON stock_goods USING btree (j_id);
--
--- Name: fki_f_end_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: fki_f_end_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_f_end_date ON forecast USING btree (f_end_date);
--
--- Name: fki_f_start_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: fki_f_start_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_f_start_date ON forecast USING btree (f_start_date);
--
--- Name: fki_jrnx_f_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: fki_jrnx_f_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_jrnx_f_id ON jrnx USING btree (f_id);
--
--- Name: fki_profile_menu_me_code; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fki_profile_menu_me_code; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX fki_profile_menu_me_code ON profile_menu USING btree (me_code);
--
--- Name: fki_profile_menu_profile; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fki_profile_menu_profile; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX fki_profile_menu_profile ON profile_menu USING btree (p_id);
--
--- Name: fki_profile_menu_type_fkey; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: fki_profile_menu_type_fkey; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX fki_profile_menu_type_fkey ON profile_menu USING btree
(p_type_display);
--
--- Name: idx_qs_internal; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: idx_qs_internal; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX idx_qs_internal ON quant_sold USING btree (qs_internal);
--
--- Name: jnt_fic_att_value_fd_id_idx; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: jnt_fic_att_value_fd_id_idx; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX jnt_fic_att_value_fd_id_idx ON fiche_detail USING btree (f_id);
--
--- Name: jnt_fic_attr_fd_id_idx; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: jnt_fic_attr_fd_id_idx; Type: INDEX; Schema: public; Owner: -;
Tablespace:
--
CREATE INDEX jnt_fic_attr_fd_id_idx ON jnt_fic_attr USING btree (fd_id);
--
--- Name: k_ag_ref; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: k_ag_ref; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX k_ag_ref ON action_gestion USING btree (ag_ref);
--
--- Name: qcode_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: qcode_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX qcode_idx ON fiche_detail USING btree (ad_value) WHERE
(ad_id = 23);
--
--- Name: qf_jr_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: qf_jr_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX qf_jr_id ON quant_fin USING btree (jr_id);
--
--- Name: qp_j_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: qp_j_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX qp_j_id ON quant_purchase USING btree (j_id);
--
--- Name: qs_j_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: qs_j_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX qs_j_id ON quant_sold USING btree (j_id);
--
--- Name: uj_login_uj_jrn_id; Type: INDEX; Schema: public; Owner: -;
Tablespace:
+-- Name: uj_login_uj_jrn_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX uj_login_uj_jrn_id ON user_sec_jrn USING btree (uj_login,
uj_jrn_id);
--
--- Name: ux_po_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: ux_po_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX ux_po_name ON poste_analytique USING btree (po_name);
--
--- Name: x_jrn_jr_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: x_jrn_jr_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX x_jrn_jr_id ON jrn USING btree (jr_id);
--
--- Name: x_mt; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: x_mt; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX x_mt ON jrn USING btree (jr_mt);
--
--- Name: x_periode; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: x_periode; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE UNIQUE INDEX x_periode ON parm_periode USING btree (p_start, p_end);
--
--- Name: x_poste; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: x_poste; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX x_poste ON jrnx USING btree (j_poste);
---
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] r4832 - phpcompta/branches/rel601-ovh/contrib/mono-dossier,
phpcompta-dev <=