This repository has been archived by the owner on Nov 25, 2020. It is now read-only.
/
create.pgsql
97 lines (83 loc) · 2.22 KB
/
create.pgsql
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
CREATE TABLE ajxp_users (
login varchar(255) PRIMARY KEY,
password varchar(255) NOT NULL,
"groupPath" varchar(255)
);
CREATE TABLE ajxp_user_rights (
rid serial PRIMARY KEY,
login varchar(255) NOT NULL,
repo_uuid varchar(33) NOT NULL,
rights text NOT NULL
);
CREATE INDEX ajxp_user_rights_i ON ajxp_user_rights(repo_uuid);
CREATE INDEX ajxp_user_rights_k ON ajxp_user_rights(login);
CREATE TABLE ajxp_user_prefs (
rid serial PRIMARY KEY,
login varchar(255) NOT NULL,
name varchar(255) NOT NULL,
val bytea
);
CREATE TABLE ajxp_user_bookmarks (
rid serial PRIMARY KEY,
login varchar(255) NOT NULL,
repo_uuid varchar(33) NOT NULL,
path varchar(255),
title varchar(255)
);
CREATE TABLE ajxp_repo (
uuid varchar(33) PRIMARY KEY,
parent_uuid varchar(33) default NULL,
owner_user_id varchar(255) default NULL,
child_user_id varchar(255) default NULL,
path varchar(255),
display varchar(255),
"accessType" varchar(20),
recycle varchar(255),
bcreate BOOLEAN,
writeable BOOLEAN,
enabled BOOLEAN,
"isTemplate" BOOLEAN,
"inferOptionsFromParent" BOOLEAN,
slug varchar(255),
"groupPath" varchar(255)
);
CREATE TABLE ajxp_repo_options (
oid serial PRIMARY KEY,
uuid varchar(33) NOT NULL,
name varchar(50) NOT NULL,
val bytea
);
CREATE INDEX ajxp_repo_options_uuid_idx ON ajxp_repo_options (uuid);
CREATE TABLE ajxp_roles (
role_id varchar(255) PRIMARY KEY,
serial_role bytea NOT NULL,
searchable_repositories text
);
CREATE TABLE ajxp_groups (
"groupPath" varchar(255) PRIMARY KEY,
"groupLabel" varchar(255) NOT NULL
);
CREATE TABLE ajxp_plugin_configs (
id varchar(50) PRIMARY KEY,
configs bytea NOT NULL
);
CREATE TABLE ajxp_simple_store (
object_id varchar(255) NOT NULL,
store_id varchar(50) NOT NULL,
serialized_data bytea,
binary_data bytea,
related_object_id varchar(255),
insertion_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(object_id, store_id)
);
CREATE TABLE ajxp_user_teams (
team_id VARCHAR(255) NOT NULL,
user_id varchar(255) NOT NULL,
team_label VARCHAR(255) NOT NULL,
owner_id varchar(255) NOT NULL,
PRIMARY KEY(team_id, user_id)
);
CREATE TABLE ajxp_version (
db_build INT NOT NULL
);
INSERT INTO ajxp_version VALUES (0);