| commit | author | age | ||
| 5c0c11 | 1 | |
| PH | 2 | INSERT INTO contactrole_ref (contact_id, role) |
| 3 | ( SELECT contact_id, 'voting-right' FROM contact ); | |
| 4 | ||
| 5 | CREATE TABLE member_asset ( | |
| 6 | member_asset_id integer NOT NULL, | |
| 7 | bp_id integer NOT NULL, | |
| 8 | date date, | |
| 9 | action character varying(60), | |
| 10 | amount numeric, | |
| 11 | comment character varying(160) | |
| 12 | ); | |
| 13 | ||
| 14 | CREATE SEQUENCE member_asset_member_asset_id_seq | |
| 15 | START WITH 1 | |
| 91bafe | 16 | INCREMENT BY 1 |
| PH | 17 | NO MINVALUE |
| 5c0c11 | 18 | NO MAXVALUE |
| 91bafe | 19 | CACHE 1; |
| PH | 20 | |
| 5c0c11 | 21 | ALTER SEQUENCE member_asset_member_asset_id_seq OWNED BY member_asset.member_asset_id; |
| 91bafe | 22 | |
| 5c0c11 | 23 | ALTER TABLE ONLY member_asset ALTER COLUMN member_asset_id SET DEFAULT nextval('member_asset_member_asset_id_seq'::regclass); |
| 91bafe | 24 | |
| 5c0c11 | 25 | CREATE TABLE member_share ( |
| PH | 26 | member_share_id integer NOT NULL, |
| 27 | bp_id integer NOT NULL, | |
| 28 | date date, | |
| 29 | action character varying(60), | |
| 30 | quantity integer, | |
| 31 | comment character varying(160) | |
| 91bafe | 32 | ); |
| PH | 33 | |
| 5c0c11 | 34 | CREATE SEQUENCE member_share_member_share_id_seq |
| PH | 35 | START WITH 1 |
| 36 | INCREMENT BY 1 | |
| 37 | NO MINVALUE | |
| 38 | NO MAXVALUE | |
| 39 | CACHE 1; | |
| 91bafe | 40 | |
| 5c0c11 | 41 | ALTER SEQUENCE member_share_member_share_id_seq OWNED BY member_share.member_share_id; |
| PH | 42 | |
| 43 | ALTER TABLE ONLY member_share ALTER COLUMN member_share_id SET DEFAULT nextval('member_share_member_share_id_seq'::regclass); | |
| 91bafe | 44 | |
| 5c0c11 | 45 | ALTER TABLE ONLY member_asset |
| PH | 46 | ADD CONSTRAINT pk_member_asset PRIMARY KEY (member_asset_id); |
| 91bafe | 47 | |
| 5c0c11 | 48 | ALTER TABLE ONLY member_share |
| PH | 49 | ADD CONSTRAINT pk_member_share PRIMARY KEY (member_share_id); |
| 50 | ||
| 51 | ALTER TABLE ONLY member_asset | |
| 52 | ADD CONSTRAINT pk_member_asset PRIMARY KEY (member_asset_id); | |
| 53 | ||
| 54 | ALTER TABLE business_partner DROP CONSTRAINT ckc_shares_signed_business; | |
| 55 | ||
| 56 | ALTER TABLE business_partner DROP COLUMN shares_updated ; | |
| 57 | ||
| 58 | ALTER TABLE business_partner DROP COLUMN shares_signed ; | |
