Dean
/
Bookdata-tools
mirror of https://github.com/BoiseState/bookdata-tools


  
1

	
2

	
3

	
4

	
5

	
6

	
7

	
8

	
9

	
10

	
11

	
12

	
13

	
14

	
15

	
16

	
17

	
18

	
19

	
20

	
21

	
22

	
23

	
24

	
25

	
26

	
27

	
28

	
            -- Initial table creation with no constraints or indexes
CREATE SCHEMA IF NOT EXISTS ol;

DROP TABLE IF EXISTS ol.author;
CREATE TABLE ol.author (
    author_id SERIAL NOT NULL,
    author_key VARCHAR(100) NOT NULL,
    author_data JSONB NOT NULL
);

DROP TABLE IF EXISTS ol.work CASCADE;
CREATE TABLE ol.work (
    work_id SERIAL NOT NULL,
    work_key VARCHAR(100) NOT NULL,
    work_data JSONB NOT NULL
);

DROP TABLE IF EXISTS ol.edition CASCADE;
CREATE TABLE ol.edition (
    edition_id SERIAL NOT NULL,
    edition_key VARCHAR(100) NOT NULL,
    edition_data JSONB NOT NULL
);

INSERT INTO stage_dep (stage_name, dep_name, dep_key)
SELECT 'ol-schema', stage_name, stage_key
FROM stage_status
WHERE stage_name = 'common-schema';