1 CREATE SEQUENCE plugin_contribtracker_legal_structure_pk_seq ;
2 CREATE TABLE plugin_contribtracker_legal_structure (
3 struct_id integer DEFAULT nextval('plugin_contribtracker_legal_structure_pk_seq') PRIMARY KEY,
4 name text UNIQUE NOT NULL
7 CREATE SEQUENCE plugin_contribtracker_role_pk_seq ;
8 CREATE TABLE plugin_contribtracker_role (
9 role_id integer DEFAULT nextval('plugin_contribtracker_role_pk_seq') PRIMARY KEY,
10 name text UNIQUE NOT NULL,
11 description text DEFAULT '' NOT NULL
14 CREATE SEQUENCE plugin_contribtracker_actor_pk_seq ;
15 CREATE TABLE plugin_contribtracker_actor (
16 actor_id integer DEFAULT nextval('plugin_contribtracker_actor_pk_seq') PRIMARY KEY,
17 name text UNIQUE NOT NULL,
18 address text DEFAULT '' NOT NULL,
19 email text DEFAULT '' NOT NULL,
20 description text DEFAULT '' NOT NULL,
21 struct_id integer REFERENCES plugin_contribtracker_legal_structure
24 CREATE SEQUENCE plugin_contribtracker_contribution_pk_seq ;
25 CREATE TABLE plugin_contribtracker_contribution (
26 contrib_id integer DEFAULT nextval('plugin_contribtracker_contribution_pk_seq') PRIMARY KEY,
27 name text DEFAULT '' NOT NULL,
29 description text DEFAULT '' NOT NULL,
30 group_id integer REFERENCES groups ON DELETE CASCADE
33 CREATE SEQUENCE plugin_contribtracker_participation_pk_seq ;
34 CREATE TABLE plugin_contribtracker_participation (
35 participation_id integer DEFAULT nextval('plugin_contribtracker_participation_pk_seq') PRIMARY KEY,
36 contrib_id integer REFERENCES plugin_contribtracker_contribution ON DELETE CASCADE,
37 actor_id integer REFERENCES plugin_contribtracker_actor,
38 role_id integer REFERENCES plugin_contribtracker_role