CREATE TABLE "action" ( ac_id integer NOT NULL, ac_description text NOT NULL ); CREATE TABLE attr_def ( ad_id integer DEFAULT nextval('s_attr_def'::text) NOT NULL, ad_text text ); CREATE TABLE attr_min ( frd_id integer, ad_id integer ); CREATE TABLE attr_value ( jft_id integer, av_text text ); CREATE TABLE centralized ( c_id integer DEFAULT nextval('s_centralized'::text) NOT NULL, c_j_id integer, c_date date NOT NULL, c_internal text NOT NULL, c_montant double precision NOT NULL, c_debit boolean DEFAULT true, c_jrn_def integer NOT NULL, c_poste integer, c_description text, c_grp integer NOT NULL, c_comment text, c_rapt text, c_periode integer, c_order integer ); CREATE TABLE fiche ( f_id integer DEFAULT nextval('s_fiche'::text) NOT NULL, fd_id integer ); CREATE TABLE fiche_def ( fd_id integer DEFAULT nextval('s_fdef'::text) NOT NULL, fd_class_base integer, fd_label text NOT NULL, fd_create_account boolean DEFAULT false, frd_id integer NOT NULL ); CREATE TABLE fiche_def_ref ( frd_id integer DEFAULT nextval('s_fiche_def_ref'::text) NOT NULL, frd_text text, frd_class_base integer ); CREATE TABLE form ( fo_id integer DEFAULT nextval('s_form'::text) NOT NULL, fo_fr_id integer, fo_pos integer, fo_label text, fo_formula text ); CREATE TABLE formdef ( fr_id integer DEFAULT nextval('s_formdef'::text) NOT NULL, fr_label text ); CREATE TABLE jnt_fic_att_value ( jft_id integer DEFAULT nextval('s_jnt_fic_att_value'::text) NOT NULL, f_id integer, ad_id integer ); CREATE TABLE jnt_fic_attr ( fd_id integer, ad_id integer ); CREATE TABLE jrn ( jr_id integer DEFAULT nextval('s_jrn'::text) NOT NULL, jr_def_id integer NOT NULL, jr_montant numeric(8,4) NOT NULL, jr_comment text, jr_date date, jr_grpt_id integer NOT NULL, jr_internal text, jr_tech_date timestamp without time zone DEFAULT now() NOT NULL, jr_tech_per integer NOT NULL, jrn_ech date, jr_ech date, jr_rapt text, jr_valid boolean DEFAULT true, jr_opid integer, jr_c_opid integer, jr_pj oid, jr_pj_name text, jr_pj_type text ); CREATE TABLE jrn_action ( ja_id integer DEFAULT nextval('s_jrnaction'::text) NOT NULL, ja_name text NOT NULL, ja_desc text, ja_url text NOT NULL, ja_action text NOT NULL, ja_lang text DEFAULT 'FR'::text, ja_jrn_type character(3) ); CREATE TABLE jrn_def ( jrn_def_id integer DEFAULT nextval('s_jrn_def'::text) NOT NULL, jrn_def_name text NOT NULL, jrn_def_class_deb text, jrn_def_class_cred text, jrn_def_fiche_deb text, jrn_def_fiche_cred text, jrn_deb_max_line integer DEFAULT 1, jrn_cred_max_line integer DEFAULT 1, jrn_def_ech boolean DEFAULT false, jrn_def_ech_lib text, jrn_def_type character(3) NOT NULL, jrn_def_code text NOT NULL ); CREATE TABLE jrn_rapt ( jra_id integer DEFAULT nextval('s_jrn_rapt'::text) NOT NULL, jr_id integer NOT NULL, jra_concerned integer NOT NULL ); CREATE TABLE jrn_type ( jrn_type_id character(3) NOT NULL, jrn_desc text ); CREATE TABLE jrnx ( j_id integer DEFAULT nextval('s_jrn_op'::text) NOT NULL, j_date date DEFAULT now(), j_montant numeric(8,4) DEFAULT 0, j_poste integer NOT NULL, j_grpt integer NOT NULL, j_rapt text, j_jrn_def integer NOT NULL, j_debit boolean DEFAULT true, j_text text, j_centralized boolean DEFAULT false, j_internal text, j_tech_user text NOT NULL, j_tech_date timestamp without time zone DEFAULT now() NOT NULL, j_tech_per integer NOT NULL ); CREATE TABLE parameter ( pr_id text NOT NULL, pr_value text ); CREATE TABLE parm_money ( pm_id integer DEFAULT nextval('s_currency'::text), pm_code character(3) NOT NULL, pm_rate double precision ); CREATE TABLE parm_periode ( p_id integer DEFAULT nextval('s_periode'::text) NOT NULL, p_start date NOT NULL, p_end date, p_exercice text DEFAULT to_char(now(), 'YYYY'::text) NOT NULL, p_closed boolean DEFAULT false, p_central boolean DEFAULT false, CONSTRAINT parm_periode_check CHECK ((p_end >= p_start)) ); CREATE TABLE stock_goods ( sg_id integer DEFAULT nextval('s_stock_goods'::text) NOT NULL, j_id integer, f_id integer NOT NULL, sg_code text, sg_quantity integer DEFAULT 0, sg_type character(1) DEFAULT 'c'::bpchar NOT NULL, sg_date date, sg_tech_date date DEFAULT now(), sg_tech_user text, CONSTRAINT stock_goods_sg_type CHECK (((sg_type = 'c'::bpchar) OR (sg_type = 'd'::bpchar))) ); CREATE TABLE tmp_pcmn ( pcm_val integer NOT NULL, pcm_lib text, pcm_val_parent integer DEFAULT 0, pcm_country character(2) DEFAULT 'BE'::bpchar NOT NULL ); CREATE TABLE tva_rate ( tva_id integer NOT NULL, tva_label text NOT NULL, tva_rate double precision DEFAULT 0.0 NOT NULL, tva_comment text, tva_poste text ); CREATE TABLE user_local_pref ( user_id text NOT NULL, parameter_type text NOT NULL, parameter_value text ); CREATE TABLE user_pref ( pref_user text NOT NULL, pref_periode integer NOT NULL ); CREATE TABLE user_sec_act ( ua_id integer DEFAULT nextval('s_user_act'::text) NOT NULL, ua_login text, ua_act_id integer ); CREATE TABLE user_sec_jrn ( uj_id integer DEFAULT nextval('s_user_jrn'::text) NOT NULL, uj_login text, uj_jrn_id integer, uj_priv text ); CREATE TABLE version ( val integer );