[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r419 - trunk/rapport_avance/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r419 - trunk/rapport_avance/sql |
Date: |
Sun, 30 Sep 2012 01:27:47 +0200 (CEST) |
Author: danydb
Date: 2012-09-30 01:27:47 +0200 (Sun, 30 Sep 2012)
New Revision: 419
Added:
trunk/rapport_avance/sql/install.sql
Removed:
trunk/rapport_avance/sql/create.sql
Log:
rename file
Deleted: trunk/rapport_avance/sql/create.sql
===================================================================
--- trunk/rapport_avance/sql/create.sql 2012-09-29 23:13:07 UTC (rev 418)
+++ trunk/rapport_avance/sql/create.sql 2012-09-29 23:27:47 UTC (rev 419)
@@ -1,110 +0,0 @@
-create schema rapport_advanced;
-
-create table rapport_advanced.formulaire
-(f_id serial primary key,
-f_title text,
-f_description text);
-insert into rapport_advanced.formulaire values (1,'cerfa3310-ca3');
-
-create table rapport_advanced.type_row(
-p_type integer primary key,
-p_description text);
-
-insert into rapport_advanced.type_row values (1,'Titre'),
(2,'Sous-titre'),(3,'Formule');
-
-create table rapport_advanced.periode_type
-(
-t_id integer primary key,
-t_description text);
-
-insert into rapport_advanced.periode_type values (1,'D''après
date'),(2,'N'),(3,'N-1'),(4,'N-2'),(5,'N-3');
-
-create table rapport_advanced.type_row_detail
-(tr_id integer primary key,
- tr_description text);
-
- insert into rapport_advanced.type_row_detail(tr_id,tr_description) values
(1,'Formule'),(2,'Poste comptable et code'),(3,'Calcul sur formulaire');
-
-
-create table rapport_advanced.formulaire_param
-(
- p_id serial primary key,
- p_code text,
- p_libelle text,
- p_type integer references rapport_advanced.type_row(p_type) ,
- p_order integer not null,
- f_id integer references rapport_advanced.formulaire(f_id) on update
cascade,
- t_id integer references rapport_advanced.periode_type(t_id)
-);
-create table rapport_advanced.total_type(
- tt_id serial primary key,
- tt_label text);
-
-insert into rapport_advanced.total_type values (0,'Total code TVA+Poste
comptable'),(1,'Total code tva'),(2,'Total poste comptable');
-
-create table rapport_advanced.formulaire_param_detail
-(
- fp_id serial primary key,
- p_id integer references rapport_advanced.formulaire_param(p_id) on
update cascade on delete cascade,
- tmp_val account_type,
- tva_id integer references public.tva_rate(tva_id),
- fp_formula text,
- fp_signed integer,
- type_detail integer,
- jrn_def_type char(3),
- tt_id integer references rapport_advanced.total_type(tt_id)
-);
-ALTER TABLE rapport_advanced.formulaire_param ADD UNIQUE (f_id, p_code);
-
-ALTER TABLE rapport_advanced.formulaire_param
- ADD COLUMN p_info text;
-COMMENT ON COLUMN rapport_advanced.formulaire_param.p_info IS 'si non vide
affiche infobulle';
-
-ALTER TABLE rapport_advanced.formulaire_param_detail
- ADD CONSTRAINT fk_formulaire_param_detail_type_row_detail FOREIGN KEY
(type_detail)
- REFERENCES rapport_advanced.type_row_detail (tr_id) MATCH SIMPLE
- ON UPDATE SET NULL ON DELETE SET NULL;
-
-CREATE SEQUENCE rapport_advanced.declaration_param_seq;
-
-CREATE TABLE rapport_advanced.declaration
-(
- d_id bigserial NOT NULL,
- d_title text,
- d_start date,
- d_end date,
- to_keep character(1),
- d_generated timestamp with time zone NOT NULL DEFAULT now(),
- f_id bigint,
- CONSTRAINT declaration_pkey PRIMARY KEY (d_id ),
- CONSTRAINT declaration_f_id_fkey FOREIGN KEY (f_id)
- REFERENCES rapport_advanced.formulaire (f_id) MATCH SIMPLE
- ON UPDATE SET NULL ON DELETE SET NULL
-);
-
-CREATE TABLE rapport_advanced.declaration_row
-(
- dr_id bigint NOT NULL DEFAULT 0,
- d_id bigint,
- dr_libelle text,
- dr_order bigint,
- dr_code text,
- dr_amount numeric(25,4) NOT NULL,
- CONSTRAINT declaration_row_pkey PRIMARY KEY (dr_id ),
- CONSTRAINT declaration_row_d_id_fkey FOREIGN KEY (d_id)
- REFERENCES rapport_advanced.declaration (d_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE
-);
-CREATE TABLE rapport_advanced.declaration_row_detail
-(
- ddr_id bigserial NOT NULL,
- ddr_amount numeric(25,4) NOT NULL DEFAULT 0,
- dr_id bigint,
- CONSTRAINT declaration_row_detail_pkey PRIMARY KEY (ddr_id ),
- CONSTRAINT declaration_row_detail_dr_id_fkey FOREIGN KEY (dr_id)
- REFERENCES rapport_advanced.declaration_row (dr_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
-);
-ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_type integer;
-ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_info text;
-
Copied: trunk/rapport_avance/sql/install.sql (from rev 417,
trunk/rapport_avance/sql/create.sql)
===================================================================
--- trunk/rapport_avance/sql/install.sql (rev 0)
+++ trunk/rapport_avance/sql/install.sql 2012-09-29 23:27:47 UTC (rev
419)
@@ -0,0 +1,110 @@
+create schema rapport_advanced;
+
+create table rapport_advanced.formulaire
+(f_id serial primary key,
+f_title text,
+f_description text);
+insert into rapport_advanced.formulaire values (1,'cerfa3310-ca3');
+
+create table rapport_advanced.type_row(
+p_type integer primary key,
+p_description text);
+
+insert into rapport_advanced.type_row values (1,'Titre'),
(2,'Sous-titre'),(3,'Formule');
+
+create table rapport_advanced.periode_type
+(
+t_id integer primary key,
+t_description text);
+
+insert into rapport_advanced.periode_type values (1,'D''après
date'),(2,'N'),(3,'N-1'),(4,'N-2'),(5,'N-3');
+
+create table rapport_advanced.type_row_detail
+(tr_id integer primary key,
+ tr_description text);
+
+ insert into rapport_advanced.type_row_detail(tr_id,tr_description) values
(1,'Formule'),(2,'Poste comptable et code'),(3,'Calcul sur formulaire');
+
+
+create table rapport_advanced.formulaire_param
+(
+ p_id serial primary key,
+ p_code text,
+ p_libelle text,
+ p_type integer references rapport_advanced.type_row(p_type) ,
+ p_order integer not null,
+ f_id integer references rapport_advanced.formulaire(f_id) on update
cascade,
+ t_id integer references rapport_advanced.periode_type(t_id)
+);
+create table rapport_advanced.total_type(
+ tt_id serial primary key,
+ tt_label text);
+
+insert into rapport_advanced.total_type values (0,'Total code TVA+Poste
comptable'),(1,'Total code tva'),(2,'Total poste comptable');
+
+create table rapport_advanced.formulaire_param_detail
+(
+ fp_id serial primary key,
+ p_id integer references rapport_advanced.formulaire_param(p_id) on
update cascade on delete cascade,
+ tmp_val account_type,
+ tva_id integer references public.tva_rate(tva_id),
+ fp_formula text,
+ fp_signed integer,
+ type_detail integer,
+ jrn_def_type char(3),
+ tt_id integer references rapport_advanced.total_type(tt_id)
+);
+ALTER TABLE rapport_advanced.formulaire_param ADD UNIQUE (f_id, p_code);
+
+ALTER TABLE rapport_advanced.formulaire_param
+ ADD COLUMN p_info text;
+COMMENT ON COLUMN rapport_advanced.formulaire_param.p_info IS 'si non vide
affiche infobulle';
+
+ALTER TABLE rapport_advanced.formulaire_param_detail
+ ADD CONSTRAINT fk_formulaire_param_detail_type_row_detail FOREIGN KEY
(type_detail)
+ REFERENCES rapport_advanced.type_row_detail (tr_id) MATCH SIMPLE
+ ON UPDATE SET NULL ON DELETE SET NULL;
+
+CREATE SEQUENCE rapport_advanced.declaration_param_seq;
+
+CREATE TABLE rapport_advanced.declaration
+(
+ d_id bigserial NOT NULL,
+ d_title text,
+ d_start date,
+ d_end date,
+ to_keep character(1),
+ d_generated timestamp with time zone NOT NULL DEFAULT now(),
+ f_id bigint,
+ CONSTRAINT declaration_pkey PRIMARY KEY (d_id ),
+ CONSTRAINT declaration_f_id_fkey FOREIGN KEY (f_id)
+ REFERENCES rapport_advanced.formulaire (f_id) MATCH SIMPLE
+ ON UPDATE SET NULL ON DELETE SET NULL
+);
+
+CREATE TABLE rapport_advanced.declaration_row
+(
+ dr_id bigint NOT NULL DEFAULT 0,
+ d_id bigint,
+ dr_libelle text,
+ dr_order bigint,
+ dr_code text,
+ dr_amount numeric(25,4) NOT NULL,
+ CONSTRAINT declaration_row_pkey PRIMARY KEY (dr_id ),
+ CONSTRAINT declaration_row_d_id_fkey FOREIGN KEY (d_id)
+ REFERENCES rapport_advanced.declaration (d_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE
+);
+CREATE TABLE rapport_advanced.declaration_row_detail
+(
+ ddr_id bigserial NOT NULL,
+ ddr_amount numeric(25,4) NOT NULL DEFAULT 0,
+ dr_id bigint,
+ CONSTRAINT declaration_row_detail_pkey PRIMARY KEY (ddr_id ),
+ CONSTRAINT declaration_row_detail_dr_id_fkey FOREIGN KEY (dr_id)
+ REFERENCES rapport_advanced.declaration_row (dr_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
+);
+ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_type integer;
+ALTER TABLE rapport_advanced.declaration_row ADD COLUMN dr_info text;
+
---
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] r419 - trunk/rapport_avance/sql,
phpcompta-dev <=