[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 15/19: MOD2 : remove schema
|
From: |
dwm |
|
Subject: |
[Noalyss-commit] [noalyss] 15/19: MOD2 : remove schema |
|
Date: |
Wed, 25 Sep 2024 06:45:05 -0400 (EDT) |
sparkyx pushed a commit to branch unstable
in repository noalyss.
commit 333b36372a550925dc28935409f355a8952f97b1
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Sun Sep 22 17:14:50 2024 +0200
MOD2 : remove schema
---
include/sql/mod2/constraint.sql | 75 --------
include/sql/mod2/data.sql | 80 --------
include/sql/mod2/schema.sql | 404 ----------------------------------------
3 files changed, 559 deletions(-)
diff --git a/include/sql/mod2/constraint.sql b/include/sql/mod2/constraint.sql
index 3ba039beb..10271342d 100644
--- a/include/sql/mod2/constraint.sql
+++ b/include/sql/mod2/constraint.sql
@@ -685,66 +685,6 @@ ALTER TABLE ONLY public.widget_dashboard
-ALTER TABLE ONLY tva_belge.assujetti_chld
- ADD CONSTRAINT assujetti_chld_pk PRIMARY KEY (ac_id);
-
-
-
-ALTER TABLE ONLY tva_belge.assujetti
- ADD CONSTRAINT assujetti_pk PRIMARY KEY (a_id);
-
-
-
-ALTER TABLE ONLY tva_belge.declarant
- ADD CONSTRAINT declarant_pkey PRIMARY KEY (d_id);
-
-
-
-ALTER TABLE ONLY tva_belge.declaration_amount
- ADD CONSTRAINT declaration_amount_pkey PRIMARY KEY (da_id);
-
-
-
-ALTER TABLE ONLY tva_belge.form_detail
- ADD CONSTRAINT form_detail_pkey PRIMARY KEY (id);
-
-
-
-ALTER TABLE ONLY tva_belge.form
- ADD CONSTRAINT form_pkey PRIMARY KEY (id);
-
-
-
-ALTER TABLE ONLY tva_belge.intracomm_chld
- ADD CONSTRAINT intracom_chld_pk PRIMARY KEY (ic_id);
-
-
-
-ALTER TABLE ONLY tva_belge.intracomm
- ADD CONSTRAINT intracom_pk PRIMARY KEY (i_id);
-
-
-
-ALTER TABLE ONLY tva_belge.parameter_chld
- ADD CONSTRAINT parameter_chld_pkey PRIMARY KEY (pi_id);
-
-
-
-ALTER TABLE ONLY tva_belge.parameter
- ADD CONSTRAINT parameter_pkey PRIMARY KEY (pcode);
-
-
-
-ALTER TABLE ONLY tva_belge.representative
- ADD CONSTRAINT representative_pkey PRIMARY KEY (rp_id);
-
-
-
-ALTER TABLE ONLY tva_belge.version
- ADD CONSTRAINT version_pkey PRIMARY KEY (id);
-
-
-
CREATE UNIQUE INDEX fd_id_ad_id_x ON public.jnt_fic_attr USING btree (fd_id,
ad_id);
@@ -1640,18 +1580,3 @@ ALTER TABLE ONLY public.user_widget
-ALTER TABLE ONLY tva_belge.assujetti_chld
- ADD CONSTRAINT assujetti_fk FOREIGN KEY (a_id) REFERENCES
tva_belge.assujetti(a_id) ON DELETE CASCADE;
-
-
-
-ALTER TABLE ONLY tva_belge.intracomm_chld
- ADD CONSTRAINT intracom_fk FOREIGN KEY (i_id) REFERENCES
tva_belge.intracomm(i_id) ON DELETE CASCADE;
-
-
-
-ALTER TABLE ONLY tva_belge.parameter_chld
- ADD CONSTRAINT parameter_chld_tva_id_fkey FOREIGN KEY (tva_id) REFERENCES
public.tva_rate(tva_id) ON UPDATE CASCADE ON DELETE CASCADE;
-
-
-
diff --git a/include/sql/mod2/data.sql b/include/sql/mod2/data.sql
index b3f4ea2e3..806144100 100644
--- a/include/sql/mod2/data.sql
+++ b/include/sql/mod2/data.sql
@@ -1690,42 +1690,6 @@ INSERT INTO public.version (val, v_description, v_date)
VALUES (202, 'Bug with r
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
SELECT pg_catalog.setval('public.acc_other_tax_ac_id_seq', 1, false);
@@ -2266,50 +2230,6 @@ SELECT
pg_catalog.setval('public.widget_dashboard_wd_id_seq', 1, false);
-SELECT pg_catalog.setval('tva_belge.assujetti_a_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.assujetti_chld_ac_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.declarant_d_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.declaration_amount_da_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.form_detail_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.form_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.intracomm_chld_ic_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.intracomm_i_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.parameter_chld_pi_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.representative_rp_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('tva_belge.version_id_seq', 1, false);
-
-
-
BEGIN;
SELECT pg_catalog.lo_open('2351550', 131072);
diff --git a/include/sql/mod2/schema.sql b/include/sql/mod2/schema.sql
index fdabc9401..b47e34817 100644
--- a/include/sql/mod2/schema.sql
+++ b/include/sql/mod2/schema.sql
@@ -16,10 +16,6 @@ CREATE SCHEMA comptaproc;
-CREATE SCHEMA tva_belge;
-
-
-
CREATE DOMAIN public.account_type AS character varying(40);
@@ -7293,362 +7289,6 @@ ALTER TABLE public.widget_dashboard ALTER COLUMN wd_id
ADD GENERATED BY DEFAULT
-CREATE TABLE tva_belge.assujetti (
- a_id integer NOT NULL,
- start_date date NOT NULL,
- end_date date NOT NULL,
- xml_oid oid,
- periodicity character(1) NOT NULL,
- tva_name text,
- num_tva text,
- adress text,
- country text,
- date_decl date DEFAULT now(),
- periode_dec integer,
- exercice text
-);
-
-
-
-CREATE SEQUENCE tva_belge.assujetti_a_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.assujetti_a_id_seq OWNED BY tva_belge.assujetti.a_id;
-
-
-
-CREATE TABLE tva_belge.assujetti_chld (
- ac_id integer NOT NULL,
- a_id bigint,
- ac_tvanum text NOT NULL,
- ac_amount numeric(20,4) NOT NULL,
- ac_vat numeric(20,4) NOT NULL,
- ac_qcode text NOT NULL,
- ac_name text NOT NULL,
- ac_periode text,
- exercice text
-);
-
-
-
-CREATE SEQUENCE tva_belge.assujetti_chld_ac_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.assujetti_chld_ac_id_seq OWNED BY
tva_belge.assujetti_chld.ac_id;
-
-
-
-CREATE TABLE tva_belge.declarant (
- d_id bigint NOT NULL,
- d_name text NOT NULL,
- d_street text NOT NULL,
- d_postcode text NOT NULL,
- d_city text NOT NULL,
- d_email text NOT NULL,
- d_phone text NOT NULL,
- d_vat_number text NOT NULL,
- d_countrycode character(2) NOT NULL
-);
-
-
-
-CREATE SEQUENCE tva_belge.declarant_d_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.declarant_d_id_seq OWNED BY tva_belge.declarant.d_id;
-
-
-
-CREATE TABLE tva_belge.declaration_amount (
- da_id integer NOT NULL,
- d00 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d01 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d02 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d03 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d44 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d45 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d46 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d47 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d48 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d49 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d81 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d82 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d83 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d84 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d85 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d86 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d87 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d88 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d54 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d55 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d56 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d57 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d61 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d63 numeric(20,4) DEFAULT 0.0 NOT NULL,
- dxx numeric(20,4) DEFAULT 0.0 NOT NULL,
- d59 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d62 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d64 numeric(20,4) DEFAULT 0.0 NOT NULL,
- dyy numeric(20,4) DEFAULT 0.0 NOT NULL,
- d71 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d72 numeric(20,4) DEFAULT 0.0 NOT NULL,
- d91 numeric(20,4) DEFAULT 0.0 NOT NULL,
- start_date date NOT NULL,
- end_date date NOT NULL,
- xml_oid oid,
- periodicity character(1) NOT NULL,
- tva_name text,
- num_tva text,
- adress text,
- country text,
- date_decl date DEFAULT now(),
- periode_dec integer,
- exercice text,
- form_id integer,
- ask_restitution smallint DEFAULT 0,
- client_listing smallint DEFAULT 0
-);
-
-
-
-CREATE SEQUENCE tva_belge.declaration_amount_da_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.declaration_amount_da_id_seq OWNED BY
tva_belge.declaration_amount.da_id;
-
-
-
-CREATE TABLE tva_belge.form (
- id integer NOT NULL,
- f_name text NOT NULL,
- f_language character(2)
-);
-
-
-
-CREATE TABLE tva_belge.form_detail (
- id integer NOT NULL,
- fd_code text NOT NULL,
- fd_label text NOT NULL,
- fd_type text NOT NULL,
- fd_tva_code text,
- form_id integer NOT NULL,
- fd_order integer NOT NULL
-);
-
-
-
-CREATE SEQUENCE tva_belge.form_detail_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.form_detail_id_seq OWNED BY tva_belge.form_detail.id;
-
-
-
-CREATE SEQUENCE tva_belge.form_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.form_id_seq OWNED BY tva_belge.form.id;
-
-
-
-CREATE TABLE tva_belge.intracomm (
- i_id integer NOT NULL,
- start_date date NOT NULL,
- end_date date NOT NULL,
- xml_oid oid,
- periodicity character(1) NOT NULL,
- tva_name text,
- num_tva text,
- adress text,
- country text,
- date_decl date DEFAULT now(),
- periode_dec integer,
- exercice text
-);
-
-
-
-CREATE TABLE tva_belge.intracomm_chld (
- ic_id integer NOT NULL,
- i_id bigint,
- ic_tvanum text NOT NULL,
- ic_amount numeric(20,4) NOT NULL,
- ic_code character varying(1) NOT NULL,
- ic_periode character varying(6) NOT NULL,
- ic_qcode text NOT NULL,
- ic_name text NOT NULL
-);
-
-
-
-CREATE SEQUENCE tva_belge.intracomm_chld_ic_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.intracomm_chld_ic_id_seq OWNED BY
tva_belge.intracomm_chld.ic_id;
-
-
-
-CREATE SEQUENCE tva_belge.intracomm_i_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.intracomm_i_id_seq OWNED BY tva_belge.intracomm.i_id;
-
-
-
-CREATE TABLE tva_belge.parameter (
- pcode text NOT NULL
-);
-
-
-
-CREATE TABLE tva_belge.parameter_chld (
- pi_id bigint NOT NULL,
- pcode text,
- tva_id bigint,
- pcm_val public.account_type
-);
-
-
-
-COMMENT ON TABLE tva_belge.parameter_chld IS 'Child table for parameters (TVA
Plugin)';
-
-
-
-COMMENT ON COLUMN tva_belge.parameter_chld.pi_id IS 'PK';
-
-
-
-COMMENT ON COLUMN tva_belge.parameter_chld.pcode IS 'FK to parameter';
-
-
-
-COMMENT ON COLUMN tva_belge.parameter_chld.tva_id IS 'FK to public.tva_rate';
-
-
-
-COMMENT ON COLUMN tva_belge.parameter_chld.pcm_val IS 'FK to tmp_pcmn';
-
-
-
-CREATE SEQUENCE tva_belge.parameter_chld_pi_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.parameter_chld_pi_id_seq OWNED BY
tva_belge.parameter_chld.pi_id;
-
-
-
-CREATE TABLE tva_belge.representative (
- rp_id bigint NOT NULL,
- rp_issued text,
- rp_type text,
- rp_name text,
- rp_street text,
- rp_postcode text,
- rp_city text,
- rp_email text,
- rp_phone text,
- rp_countrycode character(2) DEFAULT NULL::bpchar
-);
-
-
-
-CREATE SEQUENCE tva_belge.representative_rp_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.representative_rp_id_seq OWNED BY
tva_belge.representative.rp_id;
-
-
-
-CREATE TABLE tva_belge.version (
- id integer NOT NULL,
- vdate timestamp without time zone DEFAULT now(),
- vdesc text
-);
-
-
-
-CREATE SEQUENCE tva_belge.version_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
-
-ALTER SEQUENCE tva_belge.version_id_seq OWNED BY tva_belge.version.id;
-
-
-
ALTER TABLE ONLY public.acc_other_tax ALTER COLUMN ac_id SET DEFAULT
nextval('public.acc_other_tax_ac_id_seq'::regclass);
@@ -7861,49 +7501,5 @@ ALTER TABLE ONLY public.user_sec_action_profile ALTER
COLUMN ua_id SET DEFAULT n
-ALTER TABLE ONLY tva_belge.assujetti ALTER COLUMN a_id SET DEFAULT
nextval('tva_belge.assujetti_a_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.assujetti_chld ALTER COLUMN ac_id SET DEFAULT
nextval('tva_belge.assujetti_chld_ac_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.declarant ALTER COLUMN d_id SET DEFAULT
nextval('tva_belge.declarant_d_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.declaration_amount ALTER COLUMN da_id SET DEFAULT
nextval('tva_belge.declaration_amount_da_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.form ALTER COLUMN id SET DEFAULT
nextval('tva_belge.form_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.form_detail ALTER COLUMN id SET DEFAULT
nextval('tva_belge.form_detail_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.intracomm ALTER COLUMN i_id SET DEFAULT
nextval('tva_belge.intracomm_i_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.intracomm_chld ALTER COLUMN ic_id SET DEFAULT
nextval('tva_belge.intracomm_chld_ic_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.parameter_chld ALTER COLUMN pi_id SET DEFAULT
nextval('tva_belge.parameter_chld_pi_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.representative ALTER COLUMN rp_id SET DEFAULT
nextval('tva_belge.representative_rp_id_seq'::regclass);
-
-
-
-ALTER TABLE ONLY tva_belge.version ALTER COLUMN id SET DEFAULT
nextval('tva_belge.version_id_seq'::regclass);
-
-
-
ALTER TABLE ONLY public.acc_other_tax
ADD CONSTRAINT acc_other_tax_pk PRIMARY KEY (ac_id);
- [Noalyss-commit] [noalyss] 08/19: MOD2 : update, (continued)
- [Noalyss-commit] [noalyss] 08/19: MOD2 : update, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 18/19: nav-level2.active and nav-level3 active: border color, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 19/19: REVERT 9bc780c62 SALE : by default invoice not checked, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 04/19: Cosmetic, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 06/19: Update MOD1, Belgian template add VAT, document, ..., dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 16/19: Synchro with stable DO NOT INTEGRATE to pre-stable nor stable, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 02/19: Fix : France saldo until end of exercice in Gestion, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 10/19: SALE : by default invoice not checked, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 13/19: INSTALL: template must always use its own db structure, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 11/19: TVA show up , sorted by ID, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 15/19: MOD2 : remove schema,
dwm <=