Skip to content
Permalink
Branch: master
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
741 lines (632 sloc) 28.6 KB
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
--
-- Table structure for table `authassignment`
--
CREATE TABLE IF NOT EXISTS `AuthAssignment` (
`itemname` varchar(64) collate utf8_unicode_ci NOT NULL,
`userid` varchar(64) collate utf8_unicode_ci NOT NULL,
`bizrule` text collate utf8_unicode_ci,
`data` text collate utf8_unicode_ci,
PRIMARY KEY (`itemname`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `authassignment`
--
INSERT INTO `AuthAssignment` (`itemname`, `userid`, `bizrule`, `data`)VALUES
('Admin', '1', NULL, 'N;'),
('Admin', 'admin', NULL, 'N;');
-- --------------------------------------------------------
--
-- Table structure for table `AuthItem`
--
CREATE TABLE IF NOT EXISTS `AuthItem` (
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`type` int(11) NOT NULL,
`description` text collate utf8_unicode_ci,
`bizrule` text collate utf8_unicode_ci,
`data` text collate utf8_unicode_ci,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `AuthItem`
--
INSERT INTO `AuthItem` (`name`, `type`, `description`, `bizrule`, `data`) VALUES
('Admin', 2, NULL, NULL, 'N;'),
('Admin.Default.*', 1, NULL, NULL, 'N;'),
('Authenticated', 2, NULL, NULL, 'N;'),
('FileInfo.*', 1, NULL, NULL, 'N;'),
('FileInfo.Admin', 0, NULL, NULL, 'N;'),
('FileInfo.Create', 0, NULL, NULL, 'N;'),
('FileInfo.Delete', 0, NULL, NULL, 'N;'),
('FileInfo.Index', 0, NULL, NULL, 'N;'),
('FileInfo.Update', 0, NULL, NULL, 'N;'),
('FileInfo.View', 0, NULL, NULL, 'N;'),
('Guest', 2, NULL, NULL, 'N;'),
('Site.*', 1, NULL, NULL, 'N;'),
('Site.Contact', 0, NULL, NULL, 'N;'),
('Site.Error', 0, NULL, NULL, 'N;'),
('Site.Index', 0, NULL, NULL, 'N;'),
('Site.Login', 0, NULL, NULL, 'N;'),
('Site.Logout', 0, NULL, NULL, 'N;'),
('Upload.*', 1, NULL, NULL, 'N;'),
('Upload.Index', 0, NULL, NULL, 'N;'),
('User.*', 1, NULL, NULL, 'N;'),
('User.Admin', 0, NULL, NULL, 'N;'),
('User.Create', 0, NULL, NULL, 'N;'),
('User.Delete', 0, NULL, NULL, 'N;'),
('User.Index', 0, NULL, NULL, 'N;'),
('User.Pass', 0, NULL, NULL, 'N;'),
('User.Update', 0, NULL, NULL, 'N;'),
('User.View', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.Admin', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.Delete', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.Download', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.Index', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.Update', 0, NULL, NULL, 'N;'),
('ZipGzDownloads.View', 0, NULL, NULL, 'N;');
-- --------------------------------------------------------
--
-- Table structure for table `AuthItemChild`
--
CREATE TABLE IF NOT EXISTS `AuthItemChild` (
`parent` varchar(64) collate utf8_unicode_ci NOT NULL,
`child` varchar(64) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`parent`,`child`),
KEY `child` (`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `AuthItemChild`
--
INSERT INTO `AuthItemChild` (`parent`, `child`) VALUES
('Admin.Default.*', 'FileInfo.*'),
('Authenticated', 'Guest'),
('Admin.Default.*', 'Site.*'),
('Authenticated', 'Site.*'),
('Guest', 'Site.*'),
('Authenticated', 'Site.Contact'),
('Guest', 'Site.Contact'),
('Authenticated', 'Site.Error'),
('Guest', 'Site.Error'),
('Authenticated', 'Site.Index'),
('Guest', 'Site.Index'),
('Authenticated', 'Site.Login'),
('Guest', 'Site.Login'),
('Authenticated', 'Site.Logout'),
('Guest', 'Site.Logout'),
('Admin.Default.*', 'Upload.*'),
('Authenticated', 'Upload.*'),
('Authenticated', 'Upload.Index'),
('Admin.Default.*', 'User.*'),
('Authenticated', 'User.Pass'),
('Admin.Default.*', 'ZipGzDownloads.Admin'),
('Authenticated', 'ZipGzDownloads.Download'),
('Authenticated', 'ZipGzDownloads.Index'),
('Authenticated', 'ZipGzDownloads.View');
-- --------------------------------------------------------
--
-- Table structure for table `csv_meta_paths`
--
CREATE TABLE IF NOT EXISTS `csv_meta_paths` (
`id` int(10) NOT NULL auto_increment,
`user_id` int(7) NOT NULL,
`path` varchar(255) collate utf8_unicode_ci NOT NULL,
`zipped` int(1) NOT NULL DEFAULT '0',
`creationdate` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `error_type`
--
CREATE TABLE IF NOT EXISTS `error_type` (
`id` int(3) NOT NULL auto_increment,
`error_message` varchar(75) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
--
-- Dumping data for table `error_type`
--
INSERT INTO `error_type` (`id`, `error_message`) VALUES
(1, 'Unable to download file'),
(2, 'Could not create checksum'),
(3, 'Duplicate Checksum.'),
(4, 'Unable to extract file metadata'),
(5, 'Corrupt File. Checksum mismatch'),
(6, 'Filtered URL. File not downloaded'),
(7, 'Unable to add file to Zip download'),
(8, 'Invalid url string. File could not be downloaded'),
(9, 'Unknown error'),
(10, 'No Error'),
(11, 'Virus detected'),
(12, 'Unsupported file type'),
(13, 'Unable to move file'),
(14, 'Unable to delete file'),
(15, 'Unable to determine full text status'),
(16, 'Virus check couldn''t scan file'),
(17, 'Duplicate Filename'),
(18, 'file media-type doesn''t match file extension');
--
-- Table structure for table `event_list`
--
CREATE TABLE IF NOT EXISTS `event_list` (
`id` int(3) NOT NULL auto_increment,
`event_name` varchar(250) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;
--
-- Dumping data for table `event_list`
--
INSERT INTO `event_list` (`id`, `event_name`) VALUES
(1, 'Downloaded'),
(2, 'Renamed'),
(3, 'Download Last Modified time corrected'),
(4, 'Virus check'),
(5, 'Local checksum creation'),
(7, 'Deleted - virus detected'),
(8, 'Metadata Extraction'),
(9, 'Zipped for download'),
(10, 'Deleted - expired'),
(11, 'File integrity check'),
(12, 'Full text check'),
(13, 'Download failed'),
(15, 'Remote checksum creation');
--
-- Table structure for table `excel_metadata`
--
CREATE TABLE IF NOT EXISTS `Excel_Metadata` (
`id` int(7) NOT NULL auto_increment,
`app_name` varchar(50) collate utf8_unicode_ci default NULL,
`app_version` varchar(50) collate utf8_unicode_ci default NULL,
`author` varchar(255) collate utf8_unicode_ci default NULL,
`company` varchar(255) collate utf8_unicode_ci NOT NULL,
`content_type` varchar(100) collate utf8_unicode_ci default NULL,
`creationdate` varchar(50) collate utf8_unicode_ci default NULL,
`last_author` varchar(255) collate utf8_unicode_ci default NULL,
`last_modified` varchar(255) collate utf8_unicode_ci default NULL,
`creator` varchar(255) collate utf8_unicode_ci default NULL,
`date_create` varchar(255) collate utf8_unicode_ci default NULL,
`protected` varchar(25) collate utf8_unicode_ci default NULL,
`publisher` varchar(255) collate utf8_unicode_ci default NULL,
`resourcename` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`possible_doc_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `excel_metadata`
--
--
-- Table structure for table `file_type`
--
CREATE TABLE IF NOT EXISTS `file_type` (
`id` int(4) NOT NULL auto_increment,
`file_type` varchar(125) collate utf8_unicode_ci NOT NULL,
`file_type_name` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
--
-- Table structure for table `file_type`
--
CREATE TABLE `file_type` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`file_type` varchar(125) COLLATE utf8_unicode_ci NOT NULL,
`file_type_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;
--
-- Dumping data for table `file_type`
-- Note: Not all file types are actively used (OGG and MOV)
--
INSERT INTO `file_type` VALUES(1, 'application/pdf', 'PDF');
INSERT INTO `file_type` VALUES(2, 'application/msword', 'DOC');
INSERT INTO `file_type` VALUES(3, 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'DOCX');
INSERT INTO `file_type` VALUES(4, 'image/tiff', 'TIFF');
INSERT INTO `file_type` VALUES(5, 'image/jpeg', 'JPEG');
INSERT INTO `file_type` VALUES(6, 'image/gif', 'GIF');
INSERT INTO `file_type` VALUES(7, 'text/plain', 'TXT');
INSERT INTO `file_type` VALUES(8, 'application/vnd.ms-excel', 'XLS');
INSERT INTO `file_type` VALUES(9, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'XLSX');
INSERT INTO `file_type` VALUES(10, 'image/png', 'PNG');
INSERT INTO `file_type` VALUES(11, 'application/vnd.ms-powerpoint', 'PPT');
INSERT INTO `file_type` VALUES(12, 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'PPTX');
INSERT INTO `file_type` VALUES(13, 'audio/mpeg', 'MP3');
INSERT INTO `file_type` VALUES(14, 'audio/vorbis', 'OGG');
INSERT INTO `file_type` VALUES(15, 'audio/ogg', 'OGG');
INSERT INTO `file_type` VALUES(16, 'video/ogg', 'OGG');
INSERT INTO `file_type` VALUES(17, 'application/ogg', 'OGG');
INSERT INTO `file_type` VALUES(18, 'video/mp4', 'MP4');
INSERT INTO `file_type` VALUES(19, 'video/quicktime', 'MOV');
--
-- Table structure for table `file_info`
--
CREATE TABLE IF NOT EXISTS `file_info` (
`id` int(10) NOT NULL auto_increment,
`org_file_path` varchar(2084) collate utf8_unicode_ci default NULL,
`temp_file_path` varchar(1000) collate utf8_unicode_ci default NULL COMMENT 'original file path. 2083 character URL appears to be IE limit',
`short_filename` varchar(275) collate utf8_unicode_ci default NULL,
`file_type_id` int(1) NOT NULL default '0' COMMENT 'current file path on the server',
`checksum_run` int(1) NOT NULL default '0',
`remote_checksum` varchar(40) collate utf8_unicode_ci default NULL COMMENT 'remote checksum of a file',
`checksum` varchar(40) collate utf8_unicode_ci default NULL COMMENT 'file check sum sha1 or md5. sha1 is the default',
`virus_check` int(1) NOT NULL default '0' COMMENT 'has file had virus check',
`fulltext_available` int(1) NOT NULL default '0' COMMENT 'Whether text can be extracted.',
`metadata` int(1) NOT NULL default '0' COMMENT 'Whether metadata extraction has been run',
`dynamic_file` int(1) NOT NULL default '0' COMMENT 'is the file dynamically generated from orginal URL',
`last_modified` varchar(15) collate utf8_unicode_ci default NULL COMMENT 'file last modified timestamp',
`zipped` int(1) NOT NULL default '0' COMMENT 'Yes/No added to a Zip Archive',
`problem_file` int(1) NOT NULL default '0',
`events_frozen` int(1) NOT NULL default '0' COMMENT 'File events have ended due to error or file zipped and processing complete.',
`expired_deleted` int(1) NOT NULL default '0' COMMENT 'set to 1 for expired files that have been deleted.',
`user_id` int(6) NOT NULL default '0' COMMENT 'CONSTRAINT FOREIGN KEY (user_id) REFERENCES user(id)',
`upload_file_id` int(6) NOT NULL default '0' COMMENT 'CONSTRAINT FOREIGN KEY (upload_file_id) REFERENCES user_uploads(id)',
`download_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='downloaded file information' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `file_info`
--
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `file_event_history` (
`id` int(15) NOT NULL auto_increment,
`file_id` int(12) NOT NULL,
`event_id` int(2) NOT NULL,
`event_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `files_for_download`
--
CREATE TABLE IF NOT EXISTS `files_for_download` (
`id` int(10) NOT NULL auto_increment,
`url` varchar(500) collate utf8_unicode_ci NOT NULL,
`user_uploads_id` int(7) NOT NULL COMMENT "CONSTRAINT FOREIGN KEY (user_uploads_id) REFERENCES user_uploads(id)",
`user_id` int(6) NOT NULL COMMENT "CONSTRAINT FOREIGN KEY (user_id) REFERENCES user(id)",
`processed` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `Gif_Metadata`
--
CREATE TABLE IF NOT EXISTS `Gif_Metadata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`black_is_zero` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`color_space_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`num_channels` int(4) DEFAULT NULL,
`compression_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`lossless_compression` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`compression_num_progressive_scans` int(4) DEFAULT NULL,
`file_size` int(10) DEFAULT NULL,
`data_sample_format` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`horizontal_pixel_offset` int(5) DEFAULT NULL,
`orientation` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`vertical_pixel_offset` int(5) DEFAULT NULL,
`graphic_control_extension` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`image_descriptor` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`height` int(5) DEFAULT NULL,
`file_name` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
`width` int(5) DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `jpg_metadata`
--
CREATE TABLE IF NOT EXISTS `Jpg_Metadata` (
`id` int(12) NOT NULL auto_increment,
`author` varchar(255) collate utf8_unicode_ci NOT NULL,
`color_space` varchar(25) collate utf8_unicode_ci default NULL,
`component_one` varchar(150) collate utf8_unicode_ci default NULL,
`component_two` varchar(150) collate utf8_unicode_ci default NULL,
`component_three` varchar(150) collate utf8_unicode_ci default NULL,
`compression` varchar(25) collate utf8_unicode_ci default NULL,
`content_type` varchar(50) collate utf8_unicode_ci default NULL,
`data_precision` varchar(15) collate utf8_unicode_ci default NULL,
`date_time` varchar(50) collate utf8_unicode_ci default NULL,
`exif_image_height` varchar(25) collate utf8_unicode_ci default NULL,
`exif_image_width` varchar(25) collate utf8_unicode_ci default NULL,
`last_modified` varchar(50) collate utf8_unicode_ci default NULL,
`number_of_components` varchar(5) collate utf8_unicode_ci default NULL,
`orientation` varchar(75) collate utf8_unicode_ci default NULL,
`software` varchar(75) collate utf8_unicode_ci default NULL,
`x_resolution` varchar(50) collate utf8_unicode_ci default NULL,
`y_resolution` varchar(50) collate utf8_unicode_ci default NULL,
`resourcename` varchar(255) collate utf8_unicode_ci default NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `Mp3_Metadata`
--
CREATE TABLE `Mp3_Metadata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`content_length` int(11) DEFAULT NULL,
`content_type` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`channels` tinyint(2) DEFAULT NULL,
`creator` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`resource_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`sample_rate` int(7) DEFAULT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`version` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`album` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`artist` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`audio_channel_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`audio_compressor` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`audio_sample_rate` int(7) DEFAULT NULL,
`composer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`genre` varchar(125) COLLATE utf8_unicode_ci DEFAULT NULL,
`release_date` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(11) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `Mp4_Metadata`
--
CREATE TABLE `Mp4_Metadata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content_length` int(11) DEFAULT NULL,
`content_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`creation_date` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_modified` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_save_date` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`resource_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tiff_image_length` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
`tiff_image_width` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
`audio_channel_type` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`audio_sample_rate` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(11) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `pdf_metadata`
--
CREATE TABLE IF NOT EXISTS `PDF_Metadata` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`author` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`creation_date` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'file creation date',
`last_modified` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'file last modified date',
`creator` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`producer` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'software used to create the PDF',
`resource_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'similar too but not the same as title',
`title` text COLLATE utf8_unicode_ci,
`pages` int(5) DEFAULT '0' COMMENT 'Number of pages',
`subject` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`keywords` text COLLATE utf8_unicode_ci,
`licensed_to` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'who the pdf software is registered too',
`possible_doc_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(10) DEFAULT NULL COMMENT 'id of associated file',
`user_id` int(6) DEFAULT NULL COMMENT 'id of user associated with the file',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pdf_metadata`
--
-- --------------------------------------------------------
--
-- Table structure for table `PNG_Metadata`
--
CREATE TABLE IF NOT EXISTS `PNG_Metadata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`black_is_zero` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`color_space_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`num_channels` int(4) DEFAULT NULL,
`compression_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`lossless_compression` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`compression_num_progressive_scans` int(4) DEFAULT NULL,
`file_size` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`bits_per_sample` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`planar_configuration` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_sample_format` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`orientation` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`pixel_aspect_ratio` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`vertical_pixel_size` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`horizontal_pixel_size` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ihdr` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`text_entry` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`transparency_alpha` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`height` int(5) DEFAULT NULL,
`phys` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_name` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
`width` int(5) DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `PPT_Metadata`
--
CREATE TABLE IF NOT EXISTS `PPT_Metadata` (
`id` int(7) NOT NULL auto_increment,
`app_name` varchar(50) collate utf8_unicode_ci default NULL,
`app_version` varchar(50) collate utf8_unicode_ci default NULL,
`author` varchar(255) collate utf8_unicode_ci default NULL,
`comments` text collate utf8_unicode_ci,
`content_type` varchar(100) collate utf8_unicode_ci default NULL,
`creationdate` varchar(255) collate utf8_unicode_ci default NULL,
`last_author` varchar(255) collate utf8_unicode_ci default NULL,
`last_modified` varchar(255) collate utf8_unicode_ci default NULL,
`last_save_date` varchar(255) collate utf8_unicode_ci default NULL,
`keywords` varchar(255) collate utf8_unicode_ci default NULL,
`slide_count` int(4) default NULL,
`template` varchar(50) collate utf8_unicode_ci default NULL,
`publisher` varchar(255) collate utf8_unicode_ci default NULL,
`resource_name` varchar(255) collate utf8_unicode_ci default NULL,
`subject` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`pages` int(5) default NULL,
`possible_doc_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `problem_files`
--
CREATE TABLE IF NOT EXISTS `problem_files` (
`id` int(7) NOT NULL auto_increment,
`error_id` int(3) NOT NULL,
`file_id` int(10) NOT NULL,
`csv_added` int(1) NOT NULL default '0' COMMENT 'problem has been added to error csv file',
`problem_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `error_id` (`error_id`),
KEY `file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `rights`
--
CREATE TABLE IF NOT EXISTS `Rights` (
`itemname` varchar(64) collate utf8_unicode_ci NOT NULL,
`type` int(11) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`itemname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `rights`
--
-- --------------------------------------------------------
--
-- Table structure for table `Text_Metadata`
--
CREATE TABLE IF NOT EXISTS `Text_Metadata` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`content_encoding` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_size` int(12) DEFAULT NULL COMMENT 'file size is in bytes',
`file_name` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Table structure for table `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`id` int(5) NOT NULL auto_increment,
`username` varchar(25) collate utf8_unicode_ci NOT NULL,
`email` varchar(256) collate utf8_unicode_ci NOT NULL,
`password` varchar(64) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` VALUES(1, 'admin', 'your_email@email.org', '$2a$08$M4LR2i3zWzmHKxtaH9kB5.SNDNaJjZr4F2.L2cEAhxsMJ4Pcxlo2G');
-- --------------------------------------------------------
--
-- Table structure for table `user_session_info`
--
CREATE TABLE IF NOT EXISTS `user_session_info` (
`id` char(32) collate utf8_unicode_ci NOT NULL,
`expire` int(11) default NULL,
`data` text collate utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `user_session_info`
--
-- --------------------------------------------------------
--
-- Table structure for table `user_uploads`
--
CREATE TABLE `upload` (
`id` int(7) NOT NULL AUTO_INCREMENT,
`user_id` int(6) NOT NULL COMMENT "CONSTRAINT FOREIGN KEY (user_id) REFERENCES user(id)",
`path` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`urls_in_list` int(7) NOT NULL DEFAULT '0' COMMENT 'number of urls listed in the file',
`last_url_processed` int(15) NOT NULL DEFAULT '1' COMMENT 'last url in the list added to the database for download',
`processed` int(1) NOT NULL DEFAULT '0' COMMENT 'Y/N complete upload list processed',
`process_time` timestamp NULL DEFAULT NULL COMMENT 'time list finished processing',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `upload`
--
--
-- Table structure for table `word_metadata`
--
CREATE TABLE IF NOT EXISTS `Word_Metadata` (
`id` int(12) NOT NULL auto_increment,
`app_name` varchar(50) collate utf8_unicode_ci default NULL,
`app_version` varchar(50) collate utf8_unicode_ci default NULL,
`author` varchar(255) collate utf8_unicode_ci default NULL,
`comments` varchar(255) collate utf8_unicode_ci default NULL,
`company` varchar(255) collate utf8_unicode_ci default NULL,
`content_type` varchar(100) collate utf8_unicode_ci default NULL,
`creationdate` varchar(50) collate utf8_unicode_ci default NULL,
`keywords` varchar(255) collate utf8_unicode_ci default NULL,
`last_author` varchar(255) collate utf8_unicode_ci default NULL,
`last_modified` varchar(255) collate utf8_unicode_ci default NULL,
`pages` int(5) default NULL,
`revision_number` int(4) default NULL,
`template` varchar(50) collate utf8_unicode_ci default NULL,
`creator` varchar(255) collate utf8_unicode_ci default NULL,
`date_create` varchar(255) collate utf8_unicode_ci default NULL,
`publisher` varchar(255) collate utf8_unicode_ci default NULL,
`resourcename` varchar(255) collate utf8_unicode_ci default NULL,
`subject` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`possible_doc_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`possible_doc_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_id` int(12) NOT NULL,
`user_id` int(7) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `word_metadata`
--
--
-- Table structure for table `zip_gz_downloads`
--
CREATE TABLE IF NOT EXISTS `zip_gz_downloads` (
`id` int(9) NOT NULL auto_increment,
`user_id` int(7) NOT NULL,
`path` varchar(500) collate utf8_unicode_ci NOT NULL,
`downloaded` int(1) NOT NULL default '0',
`deletion_reminder` int(1) NOT NULL DEFAULT '0' COMMENT '1- reminder sent. 0-reminder hasn''t been sent.',
`creationdate` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `zip_gz_downloads`
--
--
-- Constraints for dumped tables
--
--
-- Constraints for table `authassignment`
--
ALTER TABLE `AuthAssignment`
ADD CONSTRAINT `AuthAssignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `AuthItem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `authitemchild`
--
ALTER TABLE `AuthItemChild`
ADD CONSTRAINT `AuthItemChildibfk_1` FOREIGN KEY (`parent`) REFERENCES `AuthItem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `AuthItemChild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `AuthItem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `rights`
--
ALTER TABLE `Rights`
ADD CONSTRAINT `Rights_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `AuthItem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `problem_files`
--
ALTER TABLE `problem_files`
ADD CONSTRAINT `problem_files_ibfk_1` FOREIGN KEY (`error_id`) REFERENCES `error_type` (`id`),
ADD CONSTRAINT `problem_files_ibfk_2` FOREIGN KEY (`file_id`) REFERENCES `file_info` (`id`);
You can’t perform that action at this time.