Revision 50634
Added by Michele Artini about 6 years ago
| create_affiliations_tables.sql | ||
|---|---|---|
| 16 | 16 |
PRIMARY KEY (pid, gid, year) |
| 17 | 17 |
); |
| 18 | 18 |
|
| 19 |
INSERT INTO groups(id, name, type) VALUES ('UNKNOWN', 'UNKNOWN', 'UNKNOWN');
|
|
| 20 |
|
|
| 19 | 21 |
CREATE VIEW affiliations_view AS SELECT |
| 20 | 22 |
p.id as pid, |
| 21 | 23 |
p.fullname as pname, |
Also available in: Unified diff