Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `filerun20220519`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `df_collections`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `df_collections` (

[20] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[22] Fix | Delete

`type` enum('regular','album') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'regular',

[23] Fix | Delete

`uid` mediumint(9) NOT NULL,

[24] Fix | Delete

`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

[25] Fix | Delete

PRIMARY KEY (`id`)

[26] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[27] Fix | Delete

[28] Fix | Delete

-- --------------------------------------------------------

[29] Fix | Delete

[30] Fix | Delete

[31] Fix | Delete

-- Table structure for table `df_collections_items`

[32] Fix | Delete

[33] Fix | Delete

[34] Fix | Delete

CREATE TABLE `df_collections_items` (

[35] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[36] Fix | Delete

`cid` int(11) NOT NULL,

[37] Fix | Delete

`pid` int(11) NOT NULL,

[38] Fix | Delete

`share_id` int(9) DEFAULT NULL,

[39] Fix | Delete

`added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

[40] Fix | Delete

`uid` mediumint(9) NOT NULL,

[41] Fix | Delete

PRIMARY KEY (`id`),

[42] Fix | Delete

KEY `parent_pid` (`cid`),

[43] Fix | Delete

KEY `pid` (`pid`),

[44] Fix | Delete

KEY `cid` (`cid`,`uid`)

[45] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[46] Fix | Delete

[47] Fix | Delete

-- --------------------------------------------------------

[48] Fix | Delete

[49] Fix | Delete

[50] Fix | Delete

-- Table structure for table `df_file_handlers`

[51] Fix | Delete

[52] Fix | Delete

[53] Fix | Delete

CREATE TABLE `df_file_handlers` (

[54] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[55] Fix | Delete

`uid` mediumint(9) DEFAULT NULL,

[56] Fix | Delete

`type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[57] Fix | Delete

`ext` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[58] Fix | Delete

`handler` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[59] Fix | Delete

`handler_edit` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[60] Fix | Delete

`weblink_handler` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[61] Fix | Delete

`weblink_edit_handler` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[62] Fix | Delete

PRIMARY KEY (`id`)

[63] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=25 ;

[64] Fix | Delete

[65] Fix | Delete

[66] Fix | Delete

-- Dumping data for table `df_file_handlers`

[67] Fix | Delete

[68] Fix | Delete

[69] Fix | Delete

INSERT INTO `df_file_handlers` VALUES

[70] Fix | Delete

(1, NULL, 'txt', NULL, 'plain_text_viewer', 'code_editor', 'plain_text_viewer', 'code_editor'),

[71] Fix | Delete

(2, NULL, 'code', NULL, 'code_editor', 'code_editor', 'code_editor', 'code_editor'),

[72] Fix | Delete

(3, NULL, 'img', NULL, 'image_viewer', 'image_editor', 'image_viewer', 'image_editor'),

[73] Fix | Delete

(4, NULL, 'img2', NULL, 'image_viewer', 'image_editor', 'image_viewer', 'image_editor'),

[74] Fix | Delete

(5, NULL, 'raw', NULL, 'image_viewer', 'image_editor', 'image_viewer', NULL),

[75] Fix | Delete

(6, NULL, 'wvideo', NULL, 'video_player', NULL, 'video_player', NULL),

[76] Fix | Delete

(7, NULL, 'mp3', NULL, 'audio_player', NULL, 'audio_player', NULL),

[77] Fix | Delete

(8, NULL, 'office', NULL, 'office_web_viewer', NULL, 'libreoffice_viewer', NULL),

[78] Fix | Delete

(9, NULL, 'ooffice', NULL, 'office_web_viewer', NULL, 'libreoffice_viewer', NULL),

[79] Fix | Delete

(10, NULL, 'arch', NULL, 'arch', NULL, NULL, NULL),

[80] Fix | Delete

(11, NULL, '3d', NULL, '3d_viewer', NULL, '3d_viewer', NULL),

[81] Fix | Delete

(12, NULL, 'cad', NULL, 'autodesk', NULL, 'autodesk', NULL),

[82] Fix | Delete

(13, NULL, NULL, 'odt', 'webodf', NULL, 'webodf', NULL),

[83] Fix | Delete

(14, NULL, NULL, 'ods', 'webodf', NULL, 'webodf', NULL),

[84] Fix | Delete

(15, NULL, NULL, 'odp', 'webodf', NULL, 'webodf', NULL),

[85] Fix | Delete

(16, NULL, NULL, 'pdf', 'open_in_browser', NULL, 'open_in_browser', NULL),

[86] Fix | Delete

(17, NULL, NULL, 'url', 'handle_url', NULL, 'handle_url', NULL),

[87] Fix | Delete

(18, NULL, NULL, 'html', 'code_editor', 'code_editor', 'code_editor', 'code_editor'),

[88] Fix | Delete

(19, NULL, NULL, 'kml', 'kml_viewer', NULL, 'kml_viewer', NULL),

[89] Fix | Delete

(20, NULL, NULL, 'kmz', 'kml_viewer', NULL, 'kml_viewer', NULL),

[90] Fix | Delete

(21, NULL, NULL, 'gpx', 'bing_kml_viewer', NULL, 'bing_kml_viewer', NULL),

[91] Fix | Delete

(22, NULL, NULL, 'md', 'markdown_viewer', 'code_editor', 'markdown_viewer', 'code_editor'),

[92] Fix | Delete

(23, NULL, NULL, 'epub', 'epub_reader', NULL, 'epub_reader', NULL),

[93] Fix | Delete

(24, NULL, NULL, 'csv', 'csv_editor', 'csv_editor', 'csv_editor', 'csv_editor');

[94] Fix | Delete

[95] Fix | Delete

-- --------------------------------------------------------

[96] Fix | Delete

[97] Fix | Delete

[98] Fix | Delete

-- Table structure for table `df_file_logs`

[99] Fix | Delete

[100] Fix | Delete

[101] Fix | Delete

CREATE TABLE `df_file_logs` (

[102] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[103] Fix | Delete

`pid` int(11) NOT NULL,

[104] Fix | Delete

`uid` mediumint(9) NOT NULL,

[105] Fix | Delete

`action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[106] Fix | Delete

`date` datetime NOT NULL,

[107] Fix | Delete

`data` text COLLATE utf8mb4_unicode_ci,

[108] Fix | Delete

PRIMARY KEY (`id`),

[109] Fix | Delete

KEY `pid` (`pid`),

[110] Fix | Delete

KEY `uid` (`uid`),

[111] Fix | Delete

KEY `action` (`action`),

[112] Fix | Delete

KEY `date` (`date`)

[113] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[114] Fix | Delete

[115] Fix | Delete

-- --------------------------------------------------------

[116] Fix | Delete

[117] Fix | Delete

[118] Fix | Delete

-- Table structure for table `df_logs`

[119] Fix | Delete

[120] Fix | Delete

[121] Fix | Delete

CREATE TABLE `df_logs` (

[122] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[123] Fix | Delete

`date` datetime NOT NULL DEFAULT '2002-02-02 00:00:00',

[124] Fix | Delete

`action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[125] Fix | Delete

`data` text COLLATE utf8mb4_unicode_ci NOT NULL,

[126] Fix | Delete

`uid` mediumint(9) NOT NULL DEFAULT '0',

[127] Fix | Delete

PRIMARY KEY (`id`),

[128] Fix | Delete

KEY `date` (`date`)

[129] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[130] Fix | Delete

[131] Fix | Delete

[132] Fix | Delete

-- Dumping data for table `df_logs`

[133] Fix | Delete

[134] Fix | Delete

[135] Fix | Delete

-- --------------------------------------------------------

[136] Fix | Delete

[137] Fix | Delete

[138] Fix | Delete

-- Table structure for table `df_modules_folders_notifications`

[139] Fix | Delete

[140] Fix | Delete

[141] Fix | Delete

CREATE TABLE `df_modules_folders_notifications` (

[142] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[143] Fix | Delete

`uid` int(9) NOT NULL,

[144] Fix | Delete

`pathid` int(10) NOT NULL,

[145] Fix | Delete

`shareid` int(8) DEFAULT NULL,

[146] Fix | Delete

`notify_write` int(1) NOT NULL DEFAULT '0',

[147] Fix | Delete

`notify_read` int(1) NOT NULL DEFAULT '0',

[148] Fix | Delete

`notify_social` int(1) NOT NULL DEFAULT '0',

[149] Fix | Delete

`notify_misc` int(1) NOT NULL DEFAULT '0',

[150] Fix | Delete

PRIMARY KEY (`id`),

[151] Fix | Delete

KEY `uid` (`uid`,`pathid`)

[152] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[153] Fix | Delete

[154] Fix | Delete

-- --------------------------------------------------------

[155] Fix | Delete

[156] Fix | Delete

[157] Fix | Delete

-- Table structure for table `df_modules_metadata_dt`

[158] Fix | Delete

[159] Fix | Delete

[160] Fix | Delete

CREATE TABLE `df_modules_metadata_dt` (

[161] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[162] Fix | Delete

`owner` mediumint(9) NOT NULL,

[163] Fix | Delete

`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[164] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[165] Fix | Delete

`ext` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[166] Fix | Delete

`file_types` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[167] Fix | Delete

`system` smallint(1) NOT NULL DEFAULT '0',

[168] Fix | Delete

PRIMARY KEY (`id`)

[169] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

[170] Fix | Delete

[171] Fix | Delete

[172] Fix | Delete

-- Dumping data for table `df_modules_metadata_dt`

[173] Fix | Delete

[174] Fix | Delete

[175] Fix | Delete

INSERT INTO `df_modules_metadata_dt` VALUES

[176] Fix | Delete

(1, 0, 'Documents', 'System type', 'pdf,txt', 'office,ooffice', 1),

[177] Fix | Delete

(2, 0, 'Photos', 'System type', 'psb,psd,tiff,tif,bmp', 'img,raw', 1),

[178] Fix | Delete

(3, 0, 'Audio', 'System type', '', 'mp3,audio', 1),

[179] Fix | Delete

(4, 0, 'Video', 'System type', '', 'wvideo,video', 1);

[180] Fix | Delete

[181] Fix | Delete

-- --------------------------------------------------------

[182] Fix | Delete

[183] Fix | Delete

[184] Fix | Delete

-- Table structure for table `df_modules_metadata_fields`

[185] Fix | Delete

[186] Fix | Delete

[187] Fix | Delete

CREATE TABLE `df_modules_metadata_fields` (

[188] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[189] Fix | Delete

`fsid` mediumint(9) NOT NULL,

[190] Fix | Delete

`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[191] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[192] Fix | Delete

`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[193] Fix | Delete

`autocomplete` smallint(1) DEFAULT NULL,

[194] Fix | Delete

`options` text COLLATE utf8mb4_unicode_ci NOT NULL,

[195] Fix | Delete

`hide_fieldset_name_in_column` smallint(1) NOT NULL DEFAULT '0',

[196] Fix | Delete

`hide_field_via_weblinks` smallint(1) NOT NULL DEFAULT '0',

[197] Fix | Delete

`show_column_by_default` smallint(1) NOT NULL DEFAULT '0',

[198] Fix | Delete

`system` smallint(1) NOT NULL DEFAULT '0',

[199] Fix | Delete

`source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[200] Fix | Delete

`sort` tinyint(1) DEFAULT NULL,

[201] Fix | Delete

PRIMARY KEY (`id`),

[202] Fix | Delete

KEY `name` (`name`),

[203] Fix | Delete

KEY `system` (`system`)

[204] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=32 ;

[205] Fix | Delete

[206] Fix | Delete

[207] Fix | Delete

-- Dumping data for table `df_modules_metadata_fields`

[208] Fix | Delete

[209] Fix | Delete

[210] Fix | Delete

INSERT INTO `df_modules_metadata_fields` VALUES

[211] Fix | Delete

(1, 0, 'comment', 'Comments (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[212] Fix | Delete

(2, 0, 'filelog', 'File Logs (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[213] Fix | Delete

(3, 0, 'label', 'Labels (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[214] Fix | Delete

(4, 0, 'star', 'Stars (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[215] Fix | Delete

(5, 0, 'filename', 'Search (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[216] Fix | Delete

(6, 0, 'zoho_collab', 'Zoho Collaborative Editing (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[217] Fix | Delete

(7, 0, 'autodesk_urn', 'Autodesk Viewer (System)', '', NULL, '', 0, 0, 0, 1, NULL, NULL),

[218] Fix | Delete

(8, 0, 'Tags', '', 'multiple', NULL, '', 0, 0, 0, 1, 'Tags', NULL),

[219] Fix | Delete

(9, 3, 'Width', '', 'small', NULL, '', 1, 0, 0, 0, 'MWG->width', 1),

[220] Fix | Delete

(10, 3, 'Height', '', 'small', NULL, '', 1, 0, 0, 0, 'MWG->height', 2),

[221] Fix | Delete

(11, 3, 'Date taken', '', 'date', NULL, '', 1, 0, 0, 0, 'MWG->DateCreated', 3),

[222] Fix | Delete

(12, 3, 'Author', '', 'multiple', NULL, '', 1, 0, 0, 0, 'MWG->Creator', 4),

[223] Fix | Delete

(13, 3, 'Description', '', 'large', NULL, '', 1, 0, 0, 0, 'MWG->Description', 5),

[224] Fix | Delete

(14, 3, 'Copyright', '', '', NULL, '', 1, 0, 0, 0, 'MWG->Copyright', 6),

[225] Fix | Delete

(15, 3, 'GPS latitude', '', 'small', NULL, '', 1, 0, 0, 0, 'MWG->GPSlatitude', 7),

[226] Fix | Delete

(16, 3, 'GPS longitude', '', 'small', NULL, '', 1, 0, 0, 0, 'MWG->GPSlongitude', 8),

[227] Fix | Delete

(17, 4, 'Date taken', '', 'date', NULL, '', 1, 0, 0, 0, 'video->DateCreated', 1),

[228] Fix | Delete

(18, 4, 'Movie title', '', '', NULL, '', 1, 0, 0, 0, 'video->title', 2),

[229] Fix | Delete

(19, 4, 'Width', '', 'small', NULL, '', 1, 0, 0, 0, 'video->width', 3),

[230] Fix | Delete

(20, 4, 'Height', '', 'small', NULL, '', 1, 0, 0, 0, 'video->height', 4),

[231] Fix | Delete

(21, 4, 'Codec', '', '', NULL, '', 1, 0, 0, 0, 'video->codec', 5),

[232] Fix | Delete

(22, 4, 'GPS latitude', '', 'small', NULL, '', 1, 0, 0, 0, 'video->GPSLatitude', 6),

[233] Fix | Delete

(23, 4, 'GPS longitude', '', 'small', NULL, '', 1, 0, 0, 0, 'video->GPSLongitude', 7),

[234] Fix | Delete

(24, 5, 'Artist', '', '', NULL, '', 1, 0, 0, 0, 'audio->artist', 1),

[235] Fix | Delete

(25, 5, 'Title', '', '', NULL, '', 1, 0, 0, 0, 'audio->title', 2),

[236] Fix | Delete

(26, 5, 'Album', '', '', NULL, '', 1, 0, 0, 0, 'audio->album', 3),

[237] Fix | Delete

(27, 5, 'Duration', '', 'small', NULL, '', 1, 0, 0, 0, 'audio->playtime', 4),

[238] Fix | Delete

(28, 5, 'Codec', '', '', NULL, '', 1, 0, 0, 0, 'audio->codec', 5),

[239] Fix | Delete

(29, 6, 'Author', '', '', NULL, '', 1, 0, 0, 0, NULL, 1),

[240] Fix | Delete

(30, 6, 'Description', '', '', NULL, '', 1, 0, 0, 0, NULL, 2),

[241] Fix | Delete

(31, 0, 'Rating', '', 'stars', NULL, '', 1, 0, 0, 1, 'Rating', NULL);

[242] Fix | Delete

[243] Fix | Delete

-- --------------------------------------------------------

[244] Fix | Delete

[245] Fix | Delete

[246] Fix | Delete

-- Table structure for table `df_modules_metadata_fieldsets`

[247] Fix | Delete

[248] Fix | Delete

[249] Fix | Delete

CREATE TABLE `df_modules_metadata_fieldsets` (

[250] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[251] Fix | Delete

`owner` mediumint(9) NOT NULL,

[252] Fix | Delete

`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[253] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[254] Fix | Delete

`generic` smallint(1) NOT NULL DEFAULT '0',

[255] Fix | Delete

`system` smallint(1) NOT NULL DEFAULT '0',

[256] Fix | Delete

`visible` smallint(1) NOT NULL DEFAULT '0',

[257] Fix | Delete

PRIMARY KEY (`id`)

[258] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;

[259] Fix | Delete

[260] Fix | Delete

[261] Fix | Delete

-- Dumping data for table `df_modules_metadata_fieldsets`

[262] Fix | Delete

[263] Fix | Delete

[264] Fix | Delete

INSERT INTO `df_modules_metadata_fieldsets` VALUES

[265] Fix | Delete

(1, 0, 'Comments (System)', 'Required for the file commenting system', 1, 1, 0),

[266] Fix | Delete

(2, 0, 'Label (System)', 'Required for the label system', 1, 1, 0),

[267] Fix | Delete

(3, 0, 'Image properties', '', 0, 1, 1),

[268] Fix | Delete

(4, 0, 'Video properties', '', 0, 1, 1),

[269] Fix | Delete

(5, 0, 'Audio properties', '', 0, 1, 1),

[270] Fix | Delete

(6, 0, 'Various information', '', 1, 0, 1);

[271] Fix | Delete

[272] Fix | Delete

-- --------------------------------------------------------

[273] Fix | Delete

[274] Fix | Delete

[275] Fix | Delete

-- Table structure for table `df_modules_metadata_files`

[276] Fix | Delete

[277] Fix | Delete

[278] Fix | Delete

CREATE TABLE `df_modules_metadata_files` (

[279] Fix | Delete

`id` int(10) NOT NULL AUTO_INCREMENT,

[280] Fix | Delete

`pid` int(10) NOT NULL,

[281] Fix | Delete

`type_id` mediumint(9) DEFAULT NULL,

[282] Fix | Delete

PRIMARY KEY (`id`),

[283] Fix | Delete

UNIQUE KEY `pid` (`pid`),

[284] Fix | Delete

KEY `type_id` (`type_id`)

[285] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[286] Fix | Delete

[287] Fix | Delete

-- --------------------------------------------------------

[288] Fix | Delete

[289] Fix | Delete

[290] Fix | Delete

-- Table structure for table `df_modules_metadata_values`

[291] Fix | Delete

[292] Fix | Delete

[293] Fix | Delete

CREATE TABLE `df_modules_metadata_values` (

[294] Fix | Delete

`id` int(10) NOT NULL AUTO_INCREMENT,

[295] Fix | Delete

`date_added` datetime NOT NULL,

[296] Fix | Delete

`date_modified` datetime DEFAULT NULL,

[297] Fix | Delete

`uid` mediumint(9) NOT NULL,

[298] Fix | Delete

`share_id` mediumint(9) DEFAULT NULL,

[299] Fix | Delete

`file_id` mediumint(9) NOT NULL,

[300] Fix | Delete

`field_id` mediumint(9) NOT NULL,

[301] Fix | Delete

`val` text COLLATE utf8mb4_unicode_ci,

[302] Fix | Delete

PRIMARY KEY (`id`),

[303] Fix | Delete

KEY `date_added` (`date_added`),

[304] Fix | Delete

KEY `uid` (`uid`,`file_id`,`field_id`),

[305] Fix | Delete

KEY `file_id` (`file_id`,`field_id`),

[306] Fix | Delete

KEY `uid_2` (`uid`,`field_id`),

[307] Fix | Delete

KEY `val` (`val`(100)),

[308] Fix | Delete

KEY `field_id` (`field_id`)

[309] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[310] Fix | Delete

[311] Fix | Delete

-- --------------------------------------------------------

[312] Fix | Delete

[313] Fix | Delete

[314] Fix | Delete

-- Table structure for table `df_modules_notifications`

[315] Fix | Delete

[316] Fix | Delete

[317] Fix | Delete

CREATE TABLE `df_modules_notifications` (

[318] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[319] Fix | Delete

`owner` mediumint(9) DEFAULT NULL,

[320] Fix | Delete

`object_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[321] Fix | Delete

`object_id` mediumint(9) NOT NULL DEFAULT '0',

[322] Fix | Delete

`action` text COLLATE utf8mb4_unicode_ci NOT NULL,

[323] Fix | Delete

`email_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[324] Fix | Delete

PRIMARY KEY (`id`)

[325] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[326] Fix | Delete

[327] Fix | Delete

-- --------------------------------------------------------

[328] Fix | Delete

[329] Fix | Delete

[330] Fix | Delete

-- Table structure for table `df_modules_search_index_queue`

[331] Fix | Delete

[332] Fix | Delete

[333] Fix | Delete

CREATE TABLE `df_modules_search_index_queue` (

[334] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[335] Fix | Delete

`uid` mediumint(9) NOT NULL,

[336] Fix | Delete

`path` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,

[337] Fix | Delete

`action` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[338] Fix | Delete

PRIMARY KEY (`id`)

[339] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[340] Fix | Delete

[341] Fix | Delete

-- --------------------------------------------------------

[342] Fix | Delete

[343] Fix | Delete

[344] Fix | Delete

-- Table structure for table `df_modules_shares`

[345] Fix | Delete

[346] Fix | Delete

[347] Fix | Delete

CREATE TABLE `df_modules_shares` (

[348] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[349] Fix | Delete

`uid` mediumint(9) NOT NULL,

[350] Fix | Delete

`created` datetime NOT NULL,

[351] Fix | Delete

`path` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,

[352] Fix | Delete

`type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[353] Fix | Delete

`alias` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[354] Fix | Delete

`with_gid` mediumint(9) DEFAULT NULL,

[355] Fix | Delete

`with_uid` mediumint(9) DEFAULT NULL,

[356] Fix | Delete

`anonymous` smallint(1) NOT NULL DEFAULT '0',

[357] Fix | Delete

`perms_upload` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[358] Fix | Delete

`perms_download` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[359] Fix | Delete

`perms_comment` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[360] Fix | Delete

`perms_read_comments` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[361] Fix | Delete

`perms_alter` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[362] Fix | Delete

`perms_share` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',

[363] Fix | Delete

PRIMARY KEY (`id`),

[364] Fix | Delete

KEY `uid` (`uid`,`path`(248))

[365] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[366] Fix | Delete

[367] Fix | Delete

-- --------------------------------------------------------

[368] Fix | Delete

[369] Fix | Delete

[370] Fix | Delete

-- Table structure for table `df_modules_trash`

[371] Fix | Delete

[372] Fix | Delete

[373] Fix | Delete

CREATE TABLE `df_modules_trash` (

[374] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[375] Fix | Delete

`uid` mediumint(9) NOT NULL,

[376] Fix | Delete

`relative_path` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,

[377] Fix | Delete

`date_deleted` datetime NOT NULL,

[378] Fix | Delete

PRIMARY KEY (`id`)

[379] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[380] Fix | Delete

[381] Fix | Delete

-- --------------------------------------------------------

[382] Fix | Delete

[383] Fix | Delete

[384] Fix | Delete

-- Table structure for table `df_modules_user_groups`

[385] Fix | Delete

[386] Fix | Delete

[387] Fix | Delete

CREATE TABLE `df_modules_user_groups` (

[388] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[389] Fix | Delete

`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[390] Fix | Delete

`owner` mediumint(9) DEFAULT NULL,

[391] Fix | Delete

`description` text COLLATE utf8mb4_unicode_ci NOT NULL,

[392] Fix | Delete

PRIMARY KEY (`id`)

[393] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[394] Fix | Delete

[395] Fix | Delete

-- --------------------------------------------------------

[396] Fix | Delete

[397] Fix | Delete

[398] Fix | Delete

-- Table structure for table `df_modules_user_roles`

[399] Fix | Delete

[400] Fix | Delete

[401] Fix | Delete

CREATE TABLE `df_modules_user_roles` (

[402] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[403] Fix | Delete

`system` smallint(1) NOT NULL DEFAULT '0',

[404] Fix | Delete

`owner` mediumint(9) DEFAULT NULL,

[405] Fix | Delete

`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[406] Fix | Delete

`description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[407] Fix | Delete

`admin_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[408] Fix | Delete

`admin_users` smallint(1) NOT NULL DEFAULT '0',

[409] Fix | Delete

`admin_roles` smallint(1) NOT NULL DEFAULT '0',

[410] Fix | Delete

`admin_notifications` smallint(1) NOT NULL DEFAULT '0',

[411] Fix | Delete

`admin_logs` smallint(1) NOT NULL DEFAULT '0',

[412] Fix | Delete

`admin_metadata` smallint(1) NOT NULL DEFAULT '0',

[413] Fix | Delete

`admin_over` text COLLATE utf8mb4_unicode_ci NOT NULL,

[414] Fix | Delete

`admin_max_users` smallint(7) NOT NULL DEFAULT '0',

[415] Fix | Delete

`admin_homefolder_template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[416] Fix | Delete

`homefolder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[417] Fix | Delete

`create_folder` smallint(1) NOT NULL DEFAULT '1',

[418] Fix | Delete

`space_quota_max` int(20) DEFAULT NULL,

[419] Fix | Delete

`space_quota_current` int(20) NOT NULL DEFAULT '0',

[420] Fix | Delete

`readonly` smallint(1) DEFAULT NULL,

[421] Fix | Delete

`upload` smallint(1) DEFAULT NULL,

[422] Fix | Delete

`upload_max_size` bigint(20) DEFAULT NULL,

[423] Fix | Delete

`upload_limit_types` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[424] Fix | Delete

`download` smallint(1) DEFAULT NULL,

[425] Fix | Delete

`preview` smallint(1) DEFAULT '1',

[426] Fix | Delete

`download_folders` smallint(1) DEFAULT NULL,

[427] Fix | Delete

`read_comments` smallint(1) DEFAULT NULL,

[428] Fix | Delete

`write_comments` smallint(1) DEFAULT NULL,

[429] Fix | Delete

`email` smallint(1) NOT NULL DEFAULT '0',

[430] Fix | Delete

`weblink` smallint(1) NOT NULL DEFAULT '0',

[431] Fix | Delete

`share` smallint(1) NOT NULL DEFAULT '0',

[432] Fix | Delete

`share_guests` smallint(1) NOT NULL DEFAULT '0',

[433] Fix | Delete

`metadata` smallint(1) NOT NULL DEFAULT '0',

[434] Fix | Delete

`file_history` smallint(1) NOT NULL DEFAULT '0',

[435] Fix | Delete

`users_may_see` text COLLATE utf8mb4_unicode_ci,

[436] Fix | Delete

`change_pass` smallint(1) NOT NULL DEFAULT '1',

[437] Fix | Delete

`edit_profile` smallint(1) NOT NULL DEFAULT '1',

[438] Fix | Delete

PRIMARY KEY (`id`)

[439] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

[440] Fix | Delete

[441] Fix | Delete

[442] Fix | Delete

-- Dumping data for table `df_modules_user_roles`

[443] Fix | Delete

[444] Fix | Delete

[445] Fix | Delete

INSERT INTO `df_modules_user_roles` VALUES

[446] Fix | Delete

(1, 1, NULL, 'Guest', 'Automatically deleted when there are no files shared with.', '', 0, 0, 0, 0, 0, '', 0, '', '', 0, NULL, 0, 1, 0, NULL, NULL, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '-ALL-', 0, 0);

[447] Fix | Delete

[448] Fix | Delete

-- --------------------------------------------------------

[449] Fix | Delete

[450] Fix | Delete

[451] Fix | Delete

-- Table structure for table `df_modules_weblinks`

[452] Fix | Delete

[453] Fix | Delete

[454] Fix | Delete

CREATE TABLE `df_modules_weblinks` (

[455] Fix | Delete

`id` int(10) NOT NULL AUTO_INCREMENT,

[456] Fix | Delete

`id_rnd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

[457] Fix | Delete

`uid` mediumint(9) NOT NULL,

[458] Fix | Delete

`pathid` int(10) DEFAULT NULL,

[459] Fix | Delete

`cid` int(11) DEFAULT NULL,

[460] Fix | Delete

`share_id` mediumint(9) DEFAULT NULL,

[461] Fix | Delete

`short_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[462] Fix | Delete

`password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[463] Fix | Delete

`date_created` datetime DEFAULT NULL,

[464] Fix | Delete

`date_modified` datetime DEFAULT NULL,

[465] Fix | Delete

`expiry` datetime DEFAULT NULL,

[466] Fix | Delete

`download_limit` mediumint(6) DEFAULT NULL,

[467] Fix | Delete

`allow_uploads` int(1) NOT NULL DEFAULT '0',

[468] Fix | Delete

`allow_editing` int(1) NOT NULL DEFAULT '0',

[469] Fix | Delete

`allow_downloads` int(1) NOT NULL DEFAULT '1',

[470] Fix | Delete

`system` smallint(1) NOT NULL DEFAULT '0',

[471] Fix | Delete

`notify` mediumint(1) NOT NULL DEFAULT '0',

[472] Fix | Delete

`download_terms` text COLLATE utf8mb4_unicode_ci,

[473] Fix | Delete

`show_comments` tinyint(1) NOT NULL DEFAULT '0',

[474] Fix | Delete

`show_comments_names` tinyint(1) NOT NULL DEFAULT '0',

[475] Fix | Delete

`show_metadata` tinyint(1) NOT NULL DEFAULT '0',

[476] Fix | Delete

`require_login` tinyint(1) NOT NULL DEFAULT '0',

[477] Fix | Delete

PRIMARY KEY (`id`),

[478] Fix | Delete

UNIQUE KEY `id_rnd` (`id_rnd`),

[479] Fix | Delete

KEY `uid` (`uid`,`pathid`),

[480] Fix | Delete

KEY `expiry` (`expiry`)

[481] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[482] Fix | Delete

[483] Fix | Delete

-- --------------------------------------------------------

[484] Fix | Delete

[485] Fix | Delete

[486] Fix | Delete

-- Table structure for table `df_notifications_logs`

[487] Fix | Delete

[488] Fix | Delete

[489] Fix | Delete

CREATE TABLE `df_notifications_logs` (

[490] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[491] Fix | Delete

`date` datetime NOT NULL,

[492] Fix | Delete

`has_errors` smallint(1) NOT NULL DEFAULT '0',

[493] Fix | Delete

`data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

[494] Fix | Delete

`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

[495] Fix | Delete

PRIMARY KEY (`id`)

[496] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[497] Fix | Delete

[498] Fix | Delete

-- --------------------------------------------------------

[499] Fix | Delete

12 3