This repository has been archived by the owner on Nov 25, 2020. It is now read-only.
/
create.mysql
95 lines (84 loc) · 2.77 KB
/
create.mysql
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
CREATE TABLE IF NOT EXISTS ajxp_users (
login varchar(255) NOT NULL,
password varchar(255) NOT NULL,
groupPath varchar(255) NULL,
PRIMARY KEY (login)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_user_rights (
rid INTEGER PRIMARY KEY AUTO_INCREMENT,
login VARCHAR(255) NOT NULL,
repo_uuid VARCHAR(33) NOT NULL,
rights MEDIUMTEXT NOT NULL,
INDEX (login),
INDEX (repo_uuid)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_user_prefs (
rid INTEGER PRIMARY KEY AUTO_INCREMENT,
login VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
val BLOB
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_user_bookmarks (
rid INTEGER PRIMARY KEY AUTO_INCREMENT,
login VARCHAR(255) NOT NULL,
repo_uuid VARCHAR(33) NOT NULL,
path VARCHAR(255),
title VARCHAR(255)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS 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)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_repo_options (
oid INTEGER PRIMARY KEY AUTO_INCREMENT,
uuid VARCHAR(33) NOT NULL,
name VARCHAR(50) NOT NULL,
val BLOB,
INDEX (uuid)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_roles (
role_id VARCHAR(255) PRIMARY KEY,
serial_role TEXT(500) NOT NULL
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_groups (
groupPath VARCHAR(255) PRIMARY KEY,
groupLabel VARCHAR(255) NOT NULL
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_plugin_configs (
id VARCHAR(50) NOT NULL,
configs LONGBLOB NOT NULL,
PRIMARY KEY (id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_simple_store (
object_id VARCHAR(255) NOT NULL,
store_id VARCHAR(50) NOT NULL,
serialized_data LONGTEXT NULL,
binary_data LONGBLOB NULL,
related_object_id VARCHAR(255) NULL,
insertion_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(object_id, store_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_user_teams (
team_id VARCHAR(70) 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)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS ajxp_version (
db_build INT NOT NULL
);
INSERT INTO ajxp_version SET db_build=0;