| 1 |
CREATE TYPE discovery_type AS ENUM
|
| 2 |
(
|
| 3 |
'instance',
|
| 4 |
'repository'
|
| 5 |
);
|
| 6 |
|
| 7 |
CREATE TABLE IF NOT EXISTS discoveries
|
| 8 |
(
|
| 9 |
discovery_hash TEXT PRIMARY KEY UNIQUE NOT NULL,
|
| 10 |
discovery_time TEXT NOT NULL,
|
| 11 |
discovery_type discovery_type NOT NULL,
|
| 12 |
discovery TEXT NOT NULL
|
| 13 |
);
|