-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathext_tables.sql
68 lines (59 loc) · 1.99 KB
/
ext_tables.sql
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
CREATE TABLE tx_ameosfilemanager_domain_model_folder (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
uid_parent int(11) DEFAULT '0' NOT NULL,
storage int(11) DEFAULT '0' NOT NULL,
identifier text,
title varchar(255) DEFAULT '' NOT NULL,
files int(11) DEFAULT '0' NOT NULL,
folders int(11) DEFAULT '0' NOT NULL,
# metas
description text,
keywords text,
category int(11) DEFAULT '0' NOT NULL,
# FE permissions for folder itself
no_read_access tinyint(4) DEFAULT '0' NOT NULL,
fe_group_read tinytext NOT NULL,
no_write_access tinyint(4) DEFAULT '0' NOT NULL,
fe_group_write tinytext NOT NULL,
fe_user_id int(11) DEFAULT '0' NOT NULL,
cats int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY fe_user_id (fe_user_id),
KEY folder_uid (uid_parent)
);
CREATE TABLE tx_ameosfilemanager_domain_model_filedownload (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
file int(11) DEFAULT '0' NOT NULL,
user_download int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY user_download (user_download)
);
CREATE TABLE sys_file_metadata (
datetime int(11) unsigned DEFAULT '0' NOT NULL,
# FE permissions for file itself
no_read_access tinyint(4) DEFAULT '0' NOT NULL,
fe_group_read tinytext NOT NULL,
no_write_access tinyint(4) DEFAULT '0' NOT NULL,
fe_group_write tinytext NOT NULL,
keywords text,
# if fe_user
fe_user_id int(11) DEFAULT '0' NOT NULL,
folder_uid int(11) DEFAULT '0' NOT NULL,
KEY folder_uid (folder_uid),
KEY fe_user_id (fe_user_id),
KEY no_read_access (no_read_access)
);