Revision 34365
Added by Michele Artini over 9 years ago
| is_base.sql | ||
|---|---|---|
| 49 | 49 |
subscriber varchar(255) NOT NULL REFERENCES services(id) ON DELETE CASCADE |
| 50 | 50 |
); |
| 51 | 51 |
|
| 52 |
CREATE TABLE IF NOT EXISTS service_protocols ( |
|
| 53 |
service varchar(255) NOT NULL REFERENCES services(id) ON DELETE CASCADE, |
|
| 54 |
name varchar(255) NOT NULL, |
|
| 55 |
address varchar(512) NOT NULL UNIQUE, |
|
| 56 |
PRIMARY KEY (service, name) |
|
| 57 |
); |
|
| 58 |
|
|
| 59 | 52 |
CREATE TABLE IF NOT EXISTS datastructures ( |
| 60 | 53 |
id varchar(255) NOT NULL PRIMARY KEY REFERENCES resources(id) ON DELETE CASCADE, |
| 61 | 54 |
service varchar(255) NOT NULL REFERENCES services(id) ON DELETE SET NULL, |
Also available in: Unified diff
cleaning