]>
git.agnieray.net Git - galette.git/blob - tests/pgsql_06.sql
1 DROP SEQUENCE adherents_id_seq
;
2 CREATE SEQUENCE adherents_id_seq
9 DROP SEQUENCE cotisations_id_seq
;
10 CREATE SEQUENCE cotisations_id_seq
18 CREATE TABLE adherents (
19 id_adh
integer DEFAULT nextval('adherents_id_seq'::text) NOT NULL,
20 id_statut
integer DEFAULT '4' NOT NULL,
21 nom_adh
character varying(20) DEFAULT '' NOT NULL,
22 prenom_adh
character varying(20) DEFAULT NULL,
23 pseudo_adh
character varying(20) DEFAULT NULL,
24 titre_adh
smallint DEFAULT '0' NOT NULL,
26 adresse_adh
character varying(150) DEFAULT '' NOT NULL,
27 adresse2_adh
character varying(150) DEFAULT NULL,
28 cp_adh
character varying(10) DEFAULT '' NOT NULL,
29 ville_adh
character varying(50) DEFAULT '' NOT NULL,
30 pays_adh
character varying(50) DEFAULT NULL,
31 tel_adh
character varying(20),
32 gsm_adh
character varying(20),
33 email_adh
character varying(150),
34 url_adh
character varying(200),
35 icq_adh
character varying(20),
36 msn_adh
character varying(150),
37 jabber_adh
character varying(150),
40 prof_adh
character varying(150),
41 login_adh
character varying(20) DEFAULT '' NOT NULL,
42 mdp_adh
character varying(20) DEFAULT '' NOT NULL,
43 date_crea_adh
date NOT NULL,
44 activite_adh
character(1) DEFAULT '0' NOT NULL,
45 bool_admin_adh
character(1) DEFAULT NULL,
46 bool_exempt_adh
character(1) DEFAULT NULL,
47 bool_display_info
character(1) DEFAULT NULL,
51 DROP TABLE cotisations
;
52 CREATE TABLE cotisations (
53 id_cotis
integer DEFAULT nextval('cotisations_id_seq'::text) NOT NULL,
54 id_adh
integer DEFAULT '0' NOT NULL,
55 id_type_cotis
integer DEFAULT '0' NOT NULL,
56 montant_cotis
real DEFAULT '0',
58 duree_mois_cotis
smallint DEFAULT '12' NOT NULL,
59 date_cotis
date NOT NULL
63 CREATE TABLE statuts (
64 id_statut
integer NOT NULL,
65 libelle_statut
character varying(20) DEFAULT '' NOT NULL,
66 priorite_statut
smallint DEFAULT '0' NOT NULL
69 INSERT INTO statuts
VALUES (1,'Président',0);
70 INSERT INTO statuts
VALUES (2,'Trésorier',10);
71 INSERT INTO statuts
VALUES (4,'Membre actif',30);
72 INSERT INTO statuts
VALUES (5,'Membre bienfaiteur',40);
73 INSERT INTO statuts
VALUES (6,'Membre fondateur',50);
74 INSERT INTO statuts
VALUES (3,'Secrétaire',20);
75 INSERT INTO statuts
VALUES (7,'Ancien',60);
76 INSERT INTO statuts
VALUES (8,'Personne morale',70);
77 INSERT INTO statuts
VALUES (9,'Non membre',80);
78 INSERT INTO statuts
VALUES (10,'Vice-président',5);
80 DROP TABLE types_cotisation
;
81 CREATE TABLE types_cotisation (
82 id_type_cotis
integer NOT NULL,
83 libelle_type_cotis
character varying(30) DEFAULT '' NOT NULL
86 INSERT INTO types_cotisation
VALUES (1,'Cotisation annuelle normale');
87 INSERT INTO types_cotisation
VALUES (2,'Cotisation annuelle réduite');
88 INSERT INTO types_cotisation
VALUES (3,'Cotisation entreprise');
89 INSERT INTO types_cotisation
VALUES (4,'Donation en nature');
90 INSERT INTO types_cotisation
VALUES (5,'Donation pécunière');
91 INSERT INTO types_cotisation
VALUES (6,'Partenariat');
93 DROP TABLE preferences
;
94 CREATE TABLE preferences (
95 pref_nom
character varying(40) DEFAULT '' NOT NULL,
96 pref_adresse
character varying(150) DEFAULT '' NOT NULL,
97 pref_adresse2
character varying(150) DEFAULT NULL,
98 pref_cp
character varying(10) DEFAULT '' NOT NULL,
99 pref_ville
character varying(50) DEFAULT '' NOT NULL,
100 pref_pays
character varying(50) DEFAULT NULL,
101 pref_lang
character varying(20) DEFAULT '' NOT NULL,
102 pref_numrows
integer DEFAULT '30' NOT NULL,
103 pref_log
character(1) DEFAULT '1' NOT NULL,
104 pref_email_nom
character varying(20) DEFAULT '' NOT NULL,
105 pref_email
character varying(150) DEFAULT '' NOT NULL,
106 pref_etiq_marges
integer DEFAULT '0' NOT NULL,
107 pref_etiq_hspace
integer DEFAULT '0' NOT NULL,
108 pref_etiq_vspace
integer DEFAULT '0' NOT NULL,
109 pref_etiq_hsize
integer DEFAULT '0' NOT NULL,
110 pref_etiq_vsize
integer DEFAULT '0' NOT NULL,
111 pref_etiq_cols
integer DEFAULT '0' NOT NULL,
112 pref_etiq_rows
integer DEFAULT '0' NOT NULL,
113 pref_etiq_corps
integer DEFAULT '0' NOT NULL,
114 pref_admin_login
character varying(20) DEFAULT '' NOT NULL,
115 pref_admin_pass
character varying(20) DEFAULT '' NOT NULL
118 DROP SEQUENCE logs_id_seq
;
119 CREATE SEQUENCE logs_id_seq
128 id_log
integer DEFAULT nextval('logs_id_seq'::text) NOT NULL,
129 date_log
timestamp NOT NULL,
130 ip_log
character varying(30) DEFAULT '' NOT NULL,
131 adh_log
character varying(41) DEFAULT '' NOT NULL,