SweetCherrySync/schema-postgresql.sql at main · turkerozturk/SweetCherrySync · GitHub

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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72


CREATE TABLE IF NOT EXISTS bookmark (
    node_id integer,
    sequence integer
);


CREATE TABLE IF NOT EXISTS children (
    node_id integer,
    father_id integer,
    sequence integer,
    master_id integer
);


CREATE TABLE IF NOT EXISTS codebox (
    node_id integer,
    "offset" integer,
    justification text,
    txt text,
    syntax text,
    width integer,
    height integer,
    is_width_pix integer,
    do_highl_bra integer,
    do_show_linenum integer
);


CREATE TABLE IF NOT EXISTS grid (
    node_id integer,
    "offset" integer,
    justification text,
    txt text,
    col_min integer,
    col_max integer
);


CREATE TABLE IF NOT EXISTS image (
    node_id integer,
    "offset" integer,
    justification text,
    anchor text,
    png bytea,
    filename text,
    link text,
    "time" integer
);


CREATE TABLE IF NOT EXISTS node (
    node_id integer,
    name text,
    txt text,
    syntax text,
    tags text,
    is_ro integer,
    is_richtxt integer,
    has_codebox integer,
    has_table integer,
    has_image integer,
    level integer,
    ts_creation integer,
    ts_lastsave integer
);