filemanager.sql
2.15 KB
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
/* Drop Tables */
IF OBJECT_ID('[js_filemanager_shared]') IS NOT NULL DROP TABLE [js_filemanager_shared];
IF OBJECT_ID('[js_filemanager_folder]') IS NOT NULL DROP TABLE [js_filemanager_folder];
/* Create Tables */
-- 文件管理文件夹
CREATE TABLE [js_filemanager_folder]
(
[id] varchar(64) NOT NULL,
[parent_code] varchar(64) NOT NULL,
[parent_codes] varchar(1000) NOT NULL,
[tree_sort] decimal(10) NOT NULL,
[tree_sorts] varchar(1000) NOT NULL,
[tree_leaf] char(1) NOT NULL,
[tree_level] decimal(4) NOT NULL,
[tree_names] varchar(1000) NOT NULL,
[folder_name] nvarchar(100) NOT NULL,
[group_type] varchar(64) NOT NULL,
[office_code] varchar(64),
[status] char(1) DEFAULT '0' NOT NULL,
[create_by] varchar(64) NOT NULL,
[create_date] datetime NOT NULL,
[update_by] varchar(64) NOT NULL,
[update_date] datetime NOT NULL,
[remarks] nvarchar(500),
[corp_code] varchar(64) DEFAULT '0' NOT NULL,
[corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
PRIMARY KEY ([id])
);
-- 文件管理共享表
CREATE TABLE [js_filemanager_shared]
(
[id] varchar(64) NOT NULL,
[folder_id] varchar(64),
[file_upload_id] varchar(64),
[file_name] nvarchar(500) NOT NULL,
[receive_user_code] varchar(100) NOT NULL,
[receive_user_name] nvarchar(200) NOT NULL,
[click_num] numeric(10),
[status] char(1) DEFAULT '0' NOT NULL,
[create_by] varchar(64) NOT NULL,
[create_date] datetime NOT NULL,
[update_by] varchar(64) NOT NULL,
[update_date] datetime NOT NULL,
[remarks] nvarchar(500),
PRIMARY KEY ([id])
);
/* Create Indexes */
CREATE INDEX [idx_sys_file_tree_pc] ON [js_filemanager_folder] ([parent_code]);
CREATE INDEX [idx_sys_file_tree_ts] ON [js_filemanager_folder] ([tree_sort]);
CREATE INDEX [idx_sys_file_tree_tss] ON [js_filemanager_folder] ([tree_sorts]);
CREATE INDEX [idx_sys_file_tree_gt] ON [js_filemanager_folder] ([group_type]);
CREATE INDEX [idx_sys_file_tree_oc] ON [js_filemanager_folder] ([office_code]);
CREATE INDEX [idx_sys_file_tree_cb] ON [js_filemanager_folder] ([create_by]);
CREATE INDEX [idx_sys_file_share_ruc] ON [js_filemanager_shared] ([receive_user_code]);
CREATE INDEX [idx_sys_file_share_cb] ON [js_filemanager_shared] ([create_by]);