Revision 34187
Added by Michele Artini over 9 years ago
| is_base.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS dnet_resource_kinds ( |
|
| 2 |
id varchar(255) NOT NULL PRIMARY KEY |
|
| 3 |
); |
|
| 4 |
CREATE TABLE IF NOT EXISTS dnet_resource_types ( |
|
| 5 |
id varchar(255) NOT NULL PRIMARY KEY |
|
| 6 |
); |
|
| 7 |
|
|
| 1 | 8 |
CREATE TABLE IF NOT EXISTS dnet_resources ( |
| 2 | 9 |
id varchar(255) NOT NULL PRIMARY KEY, |
| 3 |
family varchar(255) NOT NULL,
|
|
| 4 |
type varchar(255) NOT NULL, |
|
| 10 |
kind varchar(255) NOT NULL REFERENCES dnet_resource_kinds(id),
|
|
| 11 |
type varchar(255) NOT NULL REFERENCES dnet_resource_types(id),
|
|
| 5 | 12 |
valid boolean NOT NULL DEFAULT true, |
| 6 | 13 |
date timestamp NOT NULL DEFAULT now() |
| 7 | 14 |
); |
Also available in: Unified diff
refactoring