BEGIN; -- -------------------------------------------------------- -- -- Table structure for table `active_sessions` -- CREATE TABLE active_sessions ( id int NOT NULL DEFAULT '0', user_id int DEFAULT NULL, session_id char(255) DEFAULT NULL, lastused TIMESTAMP DEFAULT NULL, ip char(30) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `archive_restoration_request` -- CREATE TABLE archive_restoration_request ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', request_user_id INT4 NOT NULL DEFAULT '0', admin_user_id INT4 NOT NULL DEFAULT '0', datetime TIMESTAMP NOT NULL DEFAULT '0001-01-01 00:00:00' ); -- -------------------------------------------------------- -- -- Table structure for table `archiving_settings` -- CREATE TABLE archiving_settings ( id INT4 NOT NULL DEFAULT '0', archiving_type_id INT4 NOT NULL DEFAULT '0', expiration_date DATE DEFAULT NULL, document_transaction_id INT4 DEFAULT NULL, time_period_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `archiving_type_lookup` -- CREATE TABLE archiving_type_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `browse_criteria` -- CREATE TABLE browse_criteria ( id INT4 NOT NULL DEFAULT '0', criteria_id INT4 NOT NULL DEFAULT '0', precedence INT4 NOT NULL DEFAULT '0', PRIMARY KEY (id) ); -- -------------------------------------------------------- -- -- Table structure for table `data_types` -- CREATE TABLE data_types ( id INT4 NOT NULL DEFAULT '0', name char(255) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `dependant_document_instance` -- CREATE TABLE dependant_document_instance ( id INT4 NOT NULL DEFAULT '0', document_title TEXT DEFAULT '' NOT NULL, user_id INT4 NOT NULL DEFAULT '0', template_document_id INT4 DEFAULT NULL, parent_document_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `dependant_document_template` -- CREATE TABLE dependant_document_template ( id INT4 NOT NULL DEFAULT '0', document_title TEXT DEFAULT '' NOT NULL, default_user_id INT4 NOT NULL DEFAULT '0', template_document_id INT4 DEFAULT NULL, group_folder_approval_link_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `discussion_comments` -- CREATE TABLE discussion_comments ( id INT4 NOT NULL DEFAULT '0', thread_id INT4 NOT NULL DEFAULT '0', in_reply_to INT4 DEFAULT NULL, user_id INT4 NOT NULL DEFAULT '0', subject text, body text, DATE TIMESTAMP DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `discussion_threads` -- CREATE TABLE discussion_threads ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', first_comment_id INT4 NOT NULL DEFAULT '0', last_comment_id INT4 NOT NULL DEFAULT '0', views INT4 NOT NULL DEFAULT '0', replies INT4 NOT NULL DEFAULT '0', creator_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `document_archiving_link` -- CREATE TABLE document_archiving_link ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', archiving_settings_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `document_fields` -- CREATE TABLE document_fields ( id INT4 NOT NULL DEFAULT '0', name char(255) NOT NULL DEFAULT '', data_type char(100) NOT NULL DEFAULT '', is_generic boolean DEFAULT NULL, has_lookup boolean DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `document_fields_link` -- CREATE TABLE document_fields_link ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', document_field_id INT4 NOT NULL DEFAULT '0', value char(255) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `document_link` -- CREATE TABLE document_link ( id INT4 NOT NULL DEFAULT '0', parent_document_id INT4 NOT NULL DEFAULT '0', child_document_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `document_subscriptions` -- CREATE TABLE document_subscriptions ( id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', is_alerted boolean DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `document_text` -- CREATE TABLE document_text ( document_id INT4 DEFAULT NULL, document_text text ); -- -------------------------------------------------------- -- -- Table structure for table `document_transaction_types_lookup` -- CREATE TABLE document_transaction_types_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `document_transactions` -- CREATE TABLE document_transactions ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', version char(50) DEFAULT NULL, user_id INT4 NOT NULL DEFAULT '0', datetime TIMESTAMP NOT NULL DEFAULT '0001-01-01 00:00:00', ip char(30) DEFAULT NULL, filename char(255) NOT NULL DEFAULT '', comment char(255) NOT NULL DEFAULT '', transaction_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `document_type_fields_link` -- CREATE TABLE document_type_fields_link ( id INT4 NOT NULL DEFAULT '0', document_type_id INT4 NOT NULL DEFAULT '0', field_id INT4 NOT NULL DEFAULT '0', is_mandatory boolean NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `document_types_lookup` -- CREATE TABLE document_types_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE documents ( id INT4 NOT NULL DEFAULT '0', document_type_id INT4 NOT NULL DEFAULT '0', name TEXT DEFAULT '' NOT NULL, filename TEXT DEFAULT '' NOT NULL, size INT8 NOT NULL DEFAULT '0', creator_id INT4 NOT NULL DEFAULT '0', modified TIMESTAMP NOT NULL DEFAULT '0001-01-01 00:00:00', description varchar(200) NOT NULL DEFAULT '', security INT4 NOT NULL DEFAULT '0', mime_id INT4 NOT NULL DEFAULT '0', folder_id INT4 NOT NULL DEFAULT '0', major_version INT4 NOT NULL DEFAULT '0', minor_version INT4 NOT NULL DEFAULT '0', is_checked_out boolean NOT NULL DEFAULT '0', parent_folder_ids text, full_path text, checked_out_user_id INT4 DEFAULT NULL, status_id INT4 DEFAULT NULL, created TIMESTAMP NOT NULL DEFAULT '0001-01-01 00:00:00' ); -- -------------------------------------------------------- -- -- Table structure for table `folder_doctypes_link` -- CREATE TABLE folder_doctypes_link ( id INT4 NOT NULL DEFAULT '0', folder_id INT4 NOT NULL DEFAULT '0', document_type_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `folder_subscriptions` -- CREATE TABLE folder_subscriptions ( id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0', folder_id INT4 NOT NULL DEFAULT '0', is_alerted boolean DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `folders` -- CREATE TABLE folders ( id INT4 NOT NULL DEFAULT '0', name varchar(255) DEFAULT NULL, description varchar(255) DEFAULT NULL, parent_id INT4 DEFAULT NULL, creator_id INT4 DEFAULT NULL, unit_id INT4 DEFAULT NULL, is_public boolean NOT NULL DEFAULT '0', parent_folder_ids text, full_path text, inherit_parent_folder_permission INT4 DEFAULT NULL, permission_folder_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `folders_users_roles_link` -- CREATE TABLE folders_users_roles_link ( id INT4 NOT NULL DEFAULT '0', group_folder_approval_id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', datetime TIMESTAMP DEFAULT NULL, done boolean DEFAULT NULL, active boolean DEFAULT NULL, dependant_documents_created boolean DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `groups_folders_approval_link` -- CREATE TABLE groups_folders_approval_link ( id INT4 NOT NULL DEFAULT '0', folder_id INT4 NOT NULL DEFAULT '0', group_id INT4 NOT NULL DEFAULT '0', precedence INT4 NOT NULL DEFAULT '0', role_id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `groups_folders_link` -- CREATE TABLE groups_folders_link ( id INT4 NOT NULL DEFAULT '0', group_id INT4 NOT NULL DEFAULT '0', folder_id INT4 NOT NULL DEFAULT '0', can_read boolean NOT NULL DEFAULT '0', can_write boolean NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `groups_lookup` -- CREATE TABLE groups_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) NOT NULL DEFAULT '', is_sys_admin boolean NOT NULL DEFAULT '0', is_unit_admin boolean NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `groups_units_link` -- CREATE TABLE groups_units_link ( id INT4 NOT NULL DEFAULT '0', group_id INT4 NOT NULL DEFAULT '0', unit_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `help` -- CREATE TABLE help ( id INT4 NOT NULL DEFAULT '0', fSection varchar(100) NOT NULL DEFAULT '', help_info TEXT DEFAULT '' NOT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `links` -- CREATE TABLE links ( id INT4 NOT NULL DEFAULT '0', name char(100) NOT NULL DEFAULT '', url char(100) NOT NULL DEFAULT '', rank INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `metadata_lookup` -- CREATE TABLE metadata_lookup ( id INT4 NOT NULL DEFAULT '0', document_field_id INT4 NOT NULL DEFAULT '0', name char(255) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `mime_types` -- CREATE TABLE mime_types ( id INT4 NOT NULL DEFAULT '0', filetypes char(100) NOT NULL DEFAULT '', mimetypes char(100) NOT NULL DEFAULT '', icon_path char(255) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE news ( id INT4 NOT NULL DEFAULT '0', synopsis varchar(255) NOT NULL DEFAULT '', body text, rank INT4 DEFAULT NULL, image text, image_size INT4 DEFAULT NULL, image_mime_type_id INT4 DEFAULT NULL, active boolean DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `organisations_lookup` -- CREATE TABLE organisations_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE roles ( id INT4 NOT NULL DEFAULT '0', name char(255) NOT NULL DEFAULT '', active boolean NOT NULL DEFAULT '0', can_read boolean NOT NULL DEFAULT '0', can_write boolean NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `search_document_user_link` -- CREATE TABLE search_document_user_link ( document_id INT4 DEFAULT NULL, user_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `status_lookup` -- CREATE TABLE status_lookup ( id INT4 NOT NULL DEFAULT '0', name char(255) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `system_settings` -- CREATE TABLE system_settings ( id INT4 NOT NULL DEFAULT '0', name char(255) NOT NULL DEFAULT '', value char(255) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `time_period` -- CREATE TABLE time_period ( id INT4 NOT NULL DEFAULT '0', time_unit_id INT4 DEFAULT NULL, units INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `time_unit_lookup` -- CREATE TABLE time_unit_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `units_lookup` -- CREATE TABLE units_lookup ( id INT4 NOT NULL DEFAULT '0', name char(100) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `units_organisations_link` -- CREATE TABLE units_organisations_link ( id INT4 NOT NULL DEFAULT '0', unit_id INT4 NOT NULL DEFAULT '0', organisation_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE users ( id INT4 NOT NULL DEFAULT '0', username char(255) NOT NULL DEFAULT '', name char(255) NOT NULL DEFAULT '', password char(255) NOT NULL DEFAULT '', quota_max INT4 NOT NULL DEFAULT '0', quota_current INT4 NOT NULL DEFAULT '0', email char(255) DEFAULT NULL, mobile char(255) DEFAULT NULL, email_notification boolean NOT NULL DEFAULT '0', sms_notification boolean NOT NULL DEFAULT '0', ldap_dn char(255) DEFAULT NULL, max_sessions INT4 DEFAULT NULL, language_id INT4 DEFAULT NULL ); -- -------------------------------------------------------- -- -- Table structure for table `users_groups_link` -- CREATE TABLE users_groups_link ( id INT4 NOT NULL DEFAULT '0', user_id INT4 NOT NULL DEFAULT '0', group_id INT4 NOT NULL DEFAULT '0' ); -- -------------------------------------------------------- -- -- Table structure for table `web_documents` -- CREATE TABLE web_documents ( id INT4 NOT NULL DEFAULT '0', document_id INT4 NOT NULL DEFAULT '0', web_site_id INT4 NOT NULL DEFAULT '0', unit_id INT4 NOT NULL DEFAULT '0', status_id INT4 NOT NULL DEFAULT '0', datetime TIMESTAMP NOT NULL DEFAULT '0001-01-01 00:00:00' ); -- -------------------------------------------------------- -- -- Table structure for table `web_documents_status_lookup` -- CREATE TABLE web_documents_status_lookup ( id INT4 NOT NULL DEFAULT '0', name char(50) NOT NULL DEFAULT '' ); -- -------------------------------------------------------- -- -- Table structure for table `web_sites` -- CREATE TABLE web_sites ( id INT4 NOT NULL DEFAULT '0', web_site_name char(100) NOT NULL DEFAULT '', web_site_url char(50) NOT NULL DEFAULT '', web_master_id INT4 NOT NULL DEFAULT '0' ); -- -- Dumping data for table `active_sessions` -- -- -- Dumping data for table `archive_restoration_request` -- -- -- Dumping data for table `archiving_settings` -- -- -- Dumping data for table `browse_criteria` -- INSERT INTO browse_criteria VALUES (1, -1, 0); INSERT INTO browse_criteria VALUES (2, -2, 1); INSERT INTO browse_criteria VALUES (3, -3, 2); INSERT INTO browse_criteria VALUES (4, -4, 3); INSERT INTO browse_criteria VALUES (5, -5, 4); -- -- Dumping data for table `archiving_type_lookup` -- INSERT INTO archiving_type_lookup VALUES (1, 'Date'); INSERT INTO archiving_type_lookup VALUES (2, 'Utilisation'); -- -- Dumping data for table `data_types` -- INSERT INTO data_types VALUES (1, 'STRING'); INSERT INTO data_types VALUES (2, 'CHAR'); INSERT INTO data_types VALUES (3, 'TEXT'); INSERT INTO data_types VALUES (4, 'INT'); INSERT INTO data_types VALUES (5, 'FLOAT'); -- -- Dumping data for table `dependant_document_instance` -- -- -- Dumping data for table `dependant_document_template` -- -- -- Dumping data for table `discussion_comments` -- -- -- Dumping data for table `discussion_threads` -- -- -- Dumping data for table `document_archiving_link` -- -- -- Dumping data for table `document_fields` -- INSERT INTO document_fields VALUES (1, 'Category', 'STRING', TRUE, NULL); -- -- Dumping data for table `document_fields_link` -- -- -- Dumping data for table `document_link` -- -- -- Dumping data for table `document_subscriptions` -- -- -- Dumping data for table `document_text` -- -- -- Dumping data for table `document_transaction_types_lookup` -- INSERT INTO document_transaction_types_lookup VALUES (1, 'Create'); INSERT INTO document_transaction_types_lookup VALUES (2, 'Update'); INSERT INTO document_transaction_types_lookup VALUES (3, 'Delete'); INSERT INTO document_transaction_types_lookup VALUES (4, 'Rename'); INSERT INTO document_transaction_types_lookup VALUES (5, 'Move'); INSERT INTO document_transaction_types_lookup VALUES (6, 'Download'); INSERT INTO document_transaction_types_lookup VALUES (7, 'Check In'); INSERT INTO document_transaction_types_lookup VALUES (8, 'Check Out'); INSERT INTO document_transaction_types_lookup VALUES (9, 'Collaboration Step Rollback'); INSERT INTO document_transaction_types_lookup VALUES (10, 'View'); INSERT INTO document_transaction_types_lookup VALUES (11, 'Expunge'); INSERT INTO document_transaction_types_lookup VALUES (12, 'Force CheckIn'); INSERT INTO document_transaction_types_lookup VALUES (13, 'Email Link'); INSERT INTO document_transaction_types_lookup VALUES (14, 'Collaboration Step Approve'); -- -- Dumping data for table `document_transactions` -- -- -- Dumping data for table `document_type_fields_link` -- -- -- Dumping data for table `document_types_lookup` -- INSERT INTO document_types_lookup VALUES (1, 'Default'); -- -- Dumping data for table `documents` -- -- -- Dumping data for table `folder_doctypes_link` -- INSERT INTO folder_doctypes_link VALUES (1, 2, 1); -- -- Dumping data for table `folder_subscriptions` -- -- -- Dumping data for table `folders` -- INSERT INTO folders VALUES (1, 'Root Folder', 'Root Document Folder', 0, 1, 0, FALSE, NULL, NULL, NULL, 1); INSERT INTO folders VALUES (2, 'Default Unit', 'Default Unit Root Folder', 1, 1, 1, FALSE, '1', 'Root Folder', NULL, 1); -- -- Dumping data for table `folders_users_roles_link` -- -- -- Dumping data for table `groups_folders_approval_link` -- -- -- Dumping data for table `groups_folders_link` -- -- -- Dumping data for table `groups_lookup` -- INSERT INTO groups_lookup VALUES (1, 'System Administrators', TRUE, FALSE); INSERT INTO groups_lookup VALUES (2, 'Unit Administrators', FALSE, TRUE); INSERT INTO groups_lookup VALUES (3, 'Anonymous', FALSE, FALSE); -- -- Dumping data for table `groups_units_link` -- INSERT INTO groups_units_link VALUES (1, 2, 1); -- -- Dumping data for table `help` -- INSERT INTO help VALUES (1, 'browse', 'dochelp.html'); INSERT INTO help VALUES (2, 'dashboard', 'dashboardHelp.html'); INSERT INTO help VALUES (3, 'addFolder', 'addFolderHelp.html'); INSERT INTO help VALUES (4, 'editFolder', 'editFolderHelp.html'); INSERT INTO help VALUES (5, 'addFolderCollaboration', 'addFolderCollaborationHelp.html'); INSERT INTO help VALUES (6, 'modifyFolderCollaboration', 'addFolderCollaborationHelp.html'); INSERT INTO help VALUES (7, 'addDocument', 'addDocumentHelp.html'); INSERT INTO help VALUES (8, 'viewDocument', 'viewDocumentHelp.html'); INSERT INTO help VALUES (9, 'modifyDocument', 'modifyDocumentHelp.html'); INSERT INTO help VALUES (10, 'modifyDocumentRouting', 'modifyDocumentRoutingHelp.html'); INSERT INTO help VALUES (11, 'emailDocument', 'emailDocumentHelp.html'); INSERT INTO help VALUES (12, 'deleteDocument', 'deleteDocumentHelp.html'); INSERT INTO help VALUES (13, 'administration', 'administrationHelp.html'); INSERT INTO help VALUES (14, 'addGroup', 'addGroupHelp.html'); INSERT INTO help VALUES (15, 'editGroup', 'editGroupHelp.html'); INSERT INTO help VALUES (16, 'removeGroup', 'removeGroupHelp.html'); INSERT INTO help VALUES (17, 'assignGroupToUnit', 'assignGroupToUnitHelp.html'); INSERT INTO help VALUES (18, 'removeGroupFromUnit', 'removeGroupFromUnitHelp.html'); INSERT INTO help VALUES (19, 'addUnit', 'addUnitHelp.html'); INSERT INTO help VALUES (20, 'editUnit', 'editUnitHelp.html'); INSERT INTO help VALUES (21, 'removeUnit', 'removeUnitHelp.html'); INSERT INTO help VALUES (22, 'addOrg', 'addOrgHelp.html'); INSERT INTO help VALUES (23, 'editOrg', 'editOrgHelp.html'); INSERT INTO help VALUES (24, 'removeOrg', 'removeOrgHelp.html'); INSERT INTO help VALUES (25, 'addRole', 'addRoleHelp.html'); INSERT INTO help VALUES (26, 'editRole', 'editRoleHelp.html'); INSERT INTO help VALUES (27, 'removeRole', 'removeRoleHelp.html'); INSERT INTO help VALUES (28, 'addLink', 'addLinkHelp.html'); INSERT INTO help VALUES (29, 'addLinkSuccess', 'addLinkHelp.html'); INSERT INTO help VALUES (30, 'editLink', 'editLinkHelp.html'); INSERT INTO help VALUES (31, 'removeLink', 'removeLinkHelp.html'); INSERT INTO help VALUES (32, 'systemAdministration', 'systemAdministrationHelp.html'); INSERT INTO help VALUES (33, 'deleteFolder', 'deleteFolderHelp.html'); INSERT INTO help VALUES (34, 'editDocType', 'editDocTypeHelp.html'); INSERT INTO help VALUES (35, 'removeDocType', 'removeDocTypeHelp.html'); INSERT INTO help VALUES (36, 'addDocType', 'addDocTypeHelp.html'); INSERT INTO help VALUES (37, 'addDocTypeSuccess', 'addDocTypeHelp.html'); INSERT INTO help VALUES (38, 'manageSubscriptions', 'manageSubscriptionsHelp.html'); INSERT INTO help VALUES (39, 'addSubscription', 'addSubscriptionHelp.html'); INSERT INTO help VALUES (40, 'removeSubscription', 'removeSubscriptionHelp.html'); INSERT INTO help VALUES (41, 'preferences', 'preferencesHelp.html'); INSERT INTO help VALUES (42, 'editPrefsSuccess', 'preferencesHelp.html'); INSERT INTO help VALUES (43, 'modifyDocumentGenericMetaData', 'modifyDocumentGenericMetaDataHelp.html'); INSERT INTO help VALUES (44, 'viewHistory', 'viewHistoryHelp.html'); INSERT INTO help VALUES (45, 'checkInDocument', 'checkInDocumentHelp.html'); INSERT INTO help VALUES (46, 'checkOutDocument', 'checkOutDocumentHelp.html'); INSERT INTO help VALUES (47, 'advancedSearch', 'advancedSearchHelp.html'); INSERT INTO help VALUES (48, 'deleteFolderCollaboration', 'deleteFolderCollaborationHelp.html'); INSERT INTO help VALUES (49, 'addFolderDocType', 'addFolderDocTypeHelp.html'); INSERT INTO help VALUES (50, 'deleteFolderDocType', 'deleteFolderDocTypeHelp.html'); INSERT INTO help VALUES (51, 'addGroupFolderLink', 'addGroupFolderLinkHelp.html'); INSERT INTO help VALUES (52, 'deleteGroupFolderLink', 'deleteGroupFolderLinkHelp.html'); INSERT INTO help VALUES (53, 'addWebsite', 'addWebsiteHelp.html'); INSERT INTO help VALUES (54, 'addWebsiteSuccess', 'addWebsiteHelp.html'); INSERT INTO help VALUES (55, 'editWebsite', 'editWebsiteHelp.html'); INSERT INTO help VALUES (56, 'removeWebSite', 'removeWebSiteHelp.html'); INSERT INTO help VALUES (57, 'standardSearch', 'standardSearchHelp.html'); INSERT INTO help VALUES (58, 'modifyDocumentTypeMetaData', 'modifyDocumentTypeMetaDataHelp.html'); INSERT INTO help VALUES (59, 'addDocField', 'addDocFieldHelp.html'); INSERT INTO help VALUES (60, 'editDocField', 'editDocFieldHelp.html'); INSERT INTO help VALUES (61, 'removeDocField', 'removeDocFieldHelp.html'); INSERT INTO help VALUES (62, 'addMetaData', 'addMetaDataHelp.html'); INSERT INTO help VALUES (63, 'editMetaData', 'editMetaDataHelp.html'); INSERT INTO help VALUES (64, 'removeMetaData', 'removeMetaDataHelp.html'); INSERT INTO help VALUES (65, 'addUser', 'addUserHelp.html'); INSERT INTO help VALUES (66, 'editUser', 'editUserHelp.html'); INSERT INTO help VALUES (67, 'removeUser', 'removeUserHelp.html'); INSERT INTO help VALUES (68, 'addUserToGroup', 'addUserToGroupHelp.html'); INSERT INTO help VALUES (69, 'removeUserFromGroup', 'removeUserFromGroupHelp.html'); INSERT INTO help VALUES (70, 'viewDiscussion', 'viewDiscussionThread.html'); INSERT INTO help VALUES (71, 'addComment', 'addDiscussionComment.html'); INSERT INTO help VALUES (72, 'listNews', 'listDashboardNewsHelp.html'); INSERT INTO help VALUES (73, 'editNews', 'editDashboardNewsHelp.html'); INSERT INTO help VALUES (74, 'previewNews', 'previewDashboardNewsHelp.html'); INSERT INTO help VALUES (75, 'addNews', 'addDashboardNewsHelp.html'); INSERT INTO help VALUES (76, 'modifyDocumentArchiveSettings', 'modifyDocumentArchiveSettingsHelp.html'); INSERT INTO help VALUES (77, 'addDocumentArchiveSettings', 'addDocumentArchiveSettingsHelp.html'); INSERT INTO help VALUES (78, 'listDocFields', 'listDocumentFieldsAdmin.html'); INSERT INTO help VALUES (79, 'editDocFieldLookups', 'editDocFieldLookups.html'); INSERT INTO help VALUES (80, 'addMetaDataForField', 'addMetaDataForField.html'); INSERT INTO help VALUES (81, 'editMetaDataForField', 'editMetaDataForField.html'); INSERT INTO help VALUES (82, 'removeMetaDataFromField', 'removeMetaDataFromField.html'); INSERT INTO help VALUES (83, 'listDocs', 'listDocumentsCheckoutHelp.html'); INSERT INTO help VALUES (84, 'editDocCheckout', 'editDocCheckoutHelp.html'); INSERT INTO help VALUES (85, 'listDocTypes', 'listDocTypesHelp.html'); INSERT INTO help VALUES (86, 'editDocTypeFields', 'editDocFieldHelp.html'); INSERT INTO help VALUES (87, 'addDocTypeFieldsLink', 'addDocTypeFieldHelp.html'); INSERT INTO help VALUES (88, 'listGroups', 'listGroupsHelp.html'); INSERT INTO help VALUES (89, 'editGroupUnit', 'editGroupUnitHelp.html'); INSERT INTO help VALUES (90, 'listOrg', 'listOrgHelp.html'); INSERT INTO help VALUES (91, 'listRole', 'listRolesHelp.html'); INSERT INTO help VALUES (92, 'listUnits', 'listUnitHelp.html'); INSERT INTO help VALUES (93, 'editUnitOrg', 'editUnitOrgHelp.html'); INSERT INTO help VALUES (94, 'removeUnitFromOrg', 'removeUnitFromOrgHelp.html'); INSERT INTO help VALUES (95, 'addUnitToOrg', 'addUnitToOrgHelp.html'); INSERT INTO help VALUES (96, 'listUsers', 'listUsersHelp.html'); INSERT INTO help VALUES (97, 'editUserGroups', 'editUserGroupsHelp.html'); INSERT INTO help VALUES (98, 'listWebsites', 'listWebsitesHelp.html'); -- -- Dumping data for table `links` -- -- -- Dumping data for table `metadata_lookup` -- -- -- Dumping data for table `mime_types` -- INSERT INTO mime_types VALUES (1, 'ai', 'application/postscript', NULL); INSERT INTO mime_types VALUES (2, 'aif', 'audio/x-aiff', NULL); INSERT INTO mime_types VALUES (3, 'aifc', 'audio/x-aiff', NULL); INSERT INTO mime_types VALUES (4, 'aiff', 'audio/x-aiff', NULL); INSERT INTO mime_types VALUES (5, 'asc', 'text/plain', 'icons/txt.gif'); INSERT INTO mime_types VALUES (6, 'au', 'audio/basic', NULL); INSERT INTO mime_types VALUES (7, 'avi', 'video/x-msvideo', NULL); INSERT INTO mime_types VALUES (8, 'bcpio', 'application/x-bcpio', NULL); INSERT INTO mime_types VALUES (9, 'bin', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (10, 'bmp', 'image/bmp', 'icons/bmp.gif'); INSERT INTO mime_types VALUES (11, 'cdf', 'application/x-netcdf', NULL); INSERT INTO mime_types VALUES (12, 'class', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (13, 'cpio', 'application/x-cpio', NULL); INSERT INTO mime_types VALUES (14, 'cpt', 'application/mac-compactpro', NULL); INSERT INTO mime_types VALUES (15, 'csh', 'application/x-csh', NULL); INSERT INTO mime_types VALUES (16, 'css', 'text/css', NULL); INSERT INTO mime_types VALUES (17, 'dcr', 'application/x-director', NULL); INSERT INTO mime_types VALUES (18, 'dir', 'application/x-director', NULL); INSERT INTO mime_types VALUES (19, 'dms', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (20, 'doc', 'application/msword', 'icons/word.gif'); INSERT INTO mime_types VALUES (21, 'dvi', 'application/x-dvi', NULL); INSERT INTO mime_types VALUES (22, 'dxr', 'application/x-director', NULL); INSERT INTO mime_types VALUES (23, 'eps', 'application/postscript', NULL); INSERT INTO mime_types VALUES (24, 'etx', 'text/x-setext', NULL); INSERT INTO mime_types VALUES (25, 'exe', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (26, 'ez', 'application/andrew-inset', NULL); INSERT INTO mime_types VALUES (27, 'gif', 'image/gif', 'icons/gif.gif'); INSERT INTO mime_types VALUES (28, 'gtar', 'application/x-gtar', NULL); INSERT INTO mime_types VALUES (29, 'hdf', 'application/x-hdf', NULL); INSERT INTO mime_types VALUES (30, 'hqx', 'application/mac-binhex40', NULL); INSERT INTO mime_types VALUES (31, 'htm', 'text/html', 'icons/html.gif'); INSERT INTO mime_types VALUES (32, 'html', 'text/html', 'icons/html.gif'); INSERT INTO mime_types VALUES (33, 'ice', 'x-conference/x-cooltalk', NULL); INSERT INTO mime_types VALUES (34, 'ief', 'image/ief', NULL); INSERT INTO mime_types VALUES (35, 'iges', 'model/iges', NULL); INSERT INTO mime_types VALUES (36, 'igs', 'model/iges', NULL); INSERT INTO mime_types VALUES (37, 'jpe', 'image/jpeg', 'icons/jpg.gif'); INSERT INTO mime_types VALUES (38, 'jpeg', 'image/jpeg', 'icons/jpg.gif'); INSERT INTO mime_types VALUES (39, 'jpg', 'image/jpeg', 'icons/jpg.gif'); INSERT INTO mime_types VALUES (40, 'js', 'application/x-javascript', NULL); INSERT INTO mime_types VALUES (41, 'kar', 'audio/midi', NULL); INSERT INTO mime_types VALUES (42, 'latex', 'application/x-latex', NULL); INSERT INTO mime_types VALUES (43, 'lha', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (44, 'lzh', 'application/octet-stream', NULL); INSERT INTO mime_types VALUES (45, 'man', 'application/x-troff-man', NULL); INSERT INTO mime_types VALUES (46, 'mdb', 'application/access', 'icons/access.gif'); INSERT INTO mime_types VALUES (47, 'mdf', 'application/access', 'icons/access.gif'); INSERT INTO mime_types VALUES (48, 'me', 'application/x-troff-me', NULL); INSERT INTO mime_types VALUES (49, 'mesh', 'model/mesh', NULL); INSERT INTO mime_types VALUES (50, 'mid', 'audio/midi', NULL); INSERT INTO mime_types VALUES (51, 'midi', 'audio/midi', NULL); INSERT INTO mime_types VALUES (52, 'mif', 'application/vnd.mif', NULL); INSERT INTO mime_types VALUES (53, 'mov', 'video/quicktime', NULL); INSERT INTO mime_types VALUES (54, 'movie', 'video/x-sgi-movie', NULL); INSERT INTO mime_types VALUES (55, 'mp2', 'audio/mpeg', NULL); INSERT INTO mime_types VALUES (56, 'mp3', 'audio/mpeg', NULL); INSERT INTO mime_types VALUES (57, 'mpe', 'video/mpeg', NULL); INSERT INTO mime_types VALUES (58, 'mpeg', 'video/mpeg', NULL); INSERT INTO mime_types VALUES (59, 'mpg', 'video/mpeg', NULL); INSERT INTO mime_types VALUES (60, 'mpga', 'audio/mpeg', NULL); INSERT INTO mime_types VALUES (61, 'mpp', 'application/vnd.ms-project', 'icons/project.gif'); INSERT INTO mime_types VALUES (62, 'ms', 'application/x-troff-ms', NULL); INSERT INTO mime_types VALUES (63, 'msh', 'model/mesh', NULL); INSERT INTO mime_types VALUES (64, 'nc', 'application/x-netcdf', NULL); INSERT INTO mime_types VALUES (65, 'oda', 'application/oda', NULL); INSERT INTO mime_types VALUES (66, 'pbm', 'image/x-portable-bitmap', NULL); INSERT INTO mime_types VALUES (67, 'pdb', 'chemical/x-pdb', NULL); INSERT INTO mime_types VALUES (68, 'pdf', 'application/pdf', 'icons/pdf.gif'); INSERT INTO mime_types VALUES (69, 'pgm', 'image/x-portable-graymap', NULL); INSERT INTO mime_types VALUES (70, 'pgn', 'application/x-chess-pgn', NULL); INSERT INTO mime_types VALUES (71, 'png', 'image/png', NULL); INSERT INTO mime_types VALUES (72, 'pnm', 'image/x-portable-anymap', NULL); INSERT INTO mime_types VALUES (73, 'ppm', 'image/x-portable-pixmap', NULL); INSERT INTO mime_types VALUES (74, 'ppt', 'application/vnd.ms-powerpoint', 'icons/powerp.gif'); INSERT INTO mime_types VALUES (75, 'ps', 'application/postscript', NULL); INSERT INTO mime_types VALUES (76, 'qt', 'video/quicktime', NULL); INSERT INTO mime_types VALUES (77, 'ra', 'audio/x-realaudio', NULL); INSERT INTO mime_types VALUES (78, 'ram', 'audio/x-pn-realaudio', NULL); INSERT INTO mime_types VALUES (79, 'ras', 'image/x-cmu-raster', NULL); INSERT INTO mime_types VALUES (80, 'rgb', 'image/x-rgb', NULL); INSERT INTO mime_types VALUES (81, 'rm', 'audio/x-pn-realaudio', NULL); INSERT INTO mime_types VALUES (82, 'roff', 'application/x-troff', NULL); INSERT INTO mime_types VALUES (83, 'rpm', 'audio/x-pn-realaudio-plugin', NULL); INSERT INTO mime_types VALUES (84, 'rtf', 'text/rtf', NULL); INSERT INTO mime_types VALUES (85, 'rtx', 'text/richtext', NULL); INSERT INTO mime_types VALUES (86, 'sgm', 'text/sgml', NULL); INSERT INTO mime_types VALUES (87, 'sgml', 'text/sgml', NULL); INSERT INTO mime_types VALUES (88, 'sh', 'application/x-sh', NULL); INSERT INTO mime_types VALUES (89, 'shar', 'application/x-shar', NULL); INSERT INTO mime_types VALUES (90, 'silo', 'model/mesh', NULL); INSERT INTO mime_types VALUES (91, 'sit', 'application/x-stuffit', NULL); INSERT INTO mime_types VALUES (92, 'skd', 'application/x-koan', NULL); INSERT INTO mime_types VALUES (93, 'skm', 'application/x-koan', NULL); INSERT INTO mime_types VALUES (94, 'skp', 'application/x-koan', NULL); INSERT INTO mime_types VALUES (95, 'skt', 'application/x-koan', NULL); INSERT INTO mime_types VALUES (96, 'smi', 'application/smil', NULL); INSERT INTO mime_types VALUES (97, 'smil', 'application/smil', NULL); INSERT INTO mime_types VALUES (98, 'snd', 'audio/basic', NULL); INSERT INTO mime_types VALUES (99, 'spl', 'application/x-futuresplash', NULL); INSERT INTO mime_types VALUES (100, 'src', 'application/x-wais-source', NULL); INSERT INTO mime_types VALUES (101, 'sv4cpio', 'application/x-sv4cpio', NULL); INSERT INTO mime_types VALUES (102, 'sv4crc', 'application/x-sv4crc', NULL); INSERT INTO mime_types VALUES (103, 'swf', 'application/x-shockwave-flash', NULL); INSERT INTO mime_types VALUES (104, 't', 'application/x-troff', NULL); INSERT INTO mime_types VALUES (105, 'tar', 'application/x-tar', NULL); INSERT INTO mime_types VALUES (106, 'tcl', 'application/x-tcl', NULL); INSERT INTO mime_types VALUES (107, 'tex', 'application/x-tex', NULL); INSERT INTO mime_types VALUES (108, 'texi', 'application/x-texinfo', NULL); INSERT INTO mime_types VALUES (109, 'texinfo', 'application/x-texinfo', NULL); INSERT INTO mime_types VALUES (110, 'tif', 'image/tiff', 'icons/tiff.gif'); INSERT INTO mime_types VALUES (111, 'tiff', 'image/tiff', 'icons/tiff.gif'); INSERT INTO mime_types VALUES (112, 'tr', 'application/x-troff', NULL); INSERT INTO mime_types VALUES (113, 'tsv', 'text/tab-separated-values', NULL); INSERT INTO mime_types VALUES (114, 'txt', 'text/plain', 'icons/txt.gif'); INSERT INTO mime_types VALUES (115, 'ustar', 'application/x-ustar', NULL); INSERT INTO mime_types VALUES (116, 'vcd', 'application/x-cdlink', NULL); INSERT INTO mime_types VALUES (117, 'vrml', 'model/vrml', NULL); INSERT INTO mime_types VALUES (118, 'vsd', 'application/vnd.visio', 'icons/visio.gif'); INSERT INTO mime_types VALUES (119, 'wav', 'audio/x-wav', NULL); INSERT INTO mime_types VALUES (120, 'wrl', 'model/vrml', NULL); INSERT INTO mime_types VALUES (121, 'xbm', 'image/x-xbitmap', NULL); INSERT INTO mime_types VALUES (122, 'xls', 'application/vnd.ms-excel', 'icons/excel.gif'); INSERT INTO mime_types VALUES (123, 'xml', 'text/xml', NULL); INSERT INTO mime_types VALUES (124, 'xpm', 'image/x-xpixmap', NULL); INSERT INTO mime_types VALUES (125, 'xwd', 'image/x-xwindowdump', NULL); INSERT INTO mime_types VALUES (126, 'xyz', 'chemical/x-pdb', NULL); INSERT INTO mime_types VALUES (127, 'zip', 'application/zip', 'icons/zip.gif'); INSERT INTO mime_types VALUES (128, 'gz', 'application/x-gzip', 'icons/zip.gif'); INSERT INTO mime_types VALUES (129, 'tgz', 'application/x-gzip', 'icons/zip.gif'); INSERT INTO mime_types VALUES (130, 'sxw', 'application/vnd.sun.xml.writer', 'icons/oowriter.gif'); INSERT INTO mime_types VALUES (131, 'stw', 'application/vnd.sun.xml.writer.template', 'icons/oowriter.gif'); INSERT INTO mime_types VALUES (132, 'sxc', 'application/vnd.sun.xml.calc', 'icons/oocalc.gif'); INSERT INTO mime_types VALUES (133, 'stc', 'application/vnd.sun.xml.calc.template', 'icons/oocalc.gif'); INSERT INTO mime_types VALUES (134, 'sxd', 'application/vnd.sun.xml.draw', NULL); INSERT INTO mime_types VALUES (135, 'std', 'application/vnd.sun.xml.draw.template', NULL); INSERT INTO mime_types VALUES (136, 'sxi', 'application/vnd.sun.xml.impress', 'icons/ooimpress.gif'); INSERT INTO mime_types VALUES (137, 'sti', 'application/vnd.sun.xml.impress.template', 'icons/ooimpress.gif'); INSERT INTO mime_types VALUES (138, 'sxg', 'application/vnd.sun.xml.writer.global', NULL); INSERT INTO mime_types VALUES (139, 'sxm', 'application/vnd.sun.xml.math', NULL); -- -- Dumping data for table `news` -- -- -- Dumping data for table `organisations_lookup` -- INSERT INTO organisations_lookup VALUES (1, 'Default Organisation'); -- -- Dumping data for table `roles` -- -- -- Dumping data for table `search_document_user_link` -- -- -- Dumping data for table `status_lookup` -- INSERT INTO status_lookup VALUES (1, 'Live'); INSERT INTO status_lookup VALUES (2, 'Published'); INSERT INTO status_lookup VALUES (3, 'Deleted'); INSERT INTO status_lookup VALUES (4, 'Archived'); -- -- Dumping data for table `system_settings` -- INSERT INTO system_settings VALUES (1, 'lastIndexUpdate', '0'); INSERT INTO system_settings VALUES (2, 'knowledgeTreeVersion', '2.0.2'); -- -- Dumping data for table `time_period` -- -- -- Dumping data for table `time_unit_lookup` -- INSERT INTO time_unit_lookup VALUES (1, 'Years'); INSERT INTO time_unit_lookup VALUES (2, 'Months'); INSERT INTO time_unit_lookup VALUES (3, 'Days'); -- -- Dumping data for table `units_lookup` -- INSERT INTO units_lookup VALUES (1, 'Default Unit'); -- -- Dumping data for table `units_organisations_link` -- INSERT INTO units_organisations_link VALUES (1, 1, 1); -- -- Dumping data for table `users` -- INSERT INTO users VALUES (1, 'admin', 'Administrator', '21232f297a57a5a743894a0e4a801fc3', 0, 0, '', '', TRUE, TRUE, '', 1, 1); INSERT INTO users VALUES (2, 'unitAdmin', 'Unit Administrator', '21232f297a57a5a743894a0e4a801fc3', 0, 0, '', '', TRUE, TRUE, '', 1, 1); INSERT INTO users VALUES (3, 'guest', 'Anonymous', '084e0343a0486ff05530df6c705c8bb4', 0, 0, '', '', FALSE, FALSE, '', 19, 1); -- -- Dumping data for table `users_groups_link` -- INSERT INTO users_groups_link VALUES (1, 1, 1); INSERT INTO users_groups_link VALUES (2, 2, 2); INSERT INTO users_groups_link VALUES (3, 3, 3); -- -- Dumping data for table `web_documents` -- -- -- Dumping data for table `web_documents_status_lookup` -- INSERT INTO web_documents_status_lookup VALUES (1, 'Pending'); INSERT INTO web_documents_status_lookup VALUES (2, 'Published'); INSERT INTO web_documents_status_lookup VALUES (3, 'Not Published'); -- -- Dumping data for table `web_sites` -- CREATE SEQUENCE zseq_active_sessions; CREATE SEQUENCE zseq_archive_restoration_request; CREATE SEQUENCE zseq_archiving_settings; CREATE SEQUENCE zseq_archiving_type_lookup; CREATE SEQUENCE zseq_browse_criteria; CREATE SEQUENCE zseq_data_types; CREATE SEQUENCE zseq_dependant_document_instance; CREATE SEQUENCE zseq_dependant_document_template; CREATE SEQUENCE zseq_discussion_comments; CREATE SEQUENCE zseq_discussion_threads; CREATE SEQUENCE zseq_document_archiving_link; CREATE SEQUENCE zseq_document_fields; CREATE SEQUENCE zseq_document_fields_link; CREATE SEQUENCE zseq_document_link; CREATE SEQUENCE zseq_document_subscriptions; CREATE SEQUENCE zseq_document_text; CREATE SEQUENCE zseq_document_transaction_types_lookup; CREATE SEQUENCE zseq_document_transactions; CREATE SEQUENCE zseq_document_type_fields_link; CREATE SEQUENCE zseq_document_types_lookup; CREATE SEQUENCE zseq_documents; CREATE SEQUENCE zseq_folder_doctypes_link; CREATE SEQUENCE zseq_folder_subscriptions; CREATE SEQUENCE zseq_folders; CREATE SEQUENCE zseq_folders_users_roles_link; CREATE SEQUENCE zseq_groups_folders_approval_link; CREATE SEQUENCE zseq_groups_folders_link; CREATE SEQUENCE zseq_groups_lookup; CREATE SEQUENCE zseq_groups_units_link; CREATE SEQUENCE zseq_help; CREATE SEQUENCE zseq_links; CREATE SEQUENCE zseq_metadata_lookup; CREATE SEQUENCE zseq_mime_types; CREATE SEQUENCE zseq_news; CREATE SEQUENCE zseq_organisations_lookup; CREATE SEQUENCE zseq_roles; CREATE SEQUENCE zseq_search_document_user_link; CREATE SEQUENCE zseq_status_lookup; CREATE SEQUENCE zseq_system_settings; CREATE SEQUENCE zseq_time_period; CREATE SEQUENCE zseq_time_unit_lookup; CREATE SEQUENCE zseq_units_lookup; CREATE SEQUENCE zseq_units_organisations_link; CREATE SEQUENCE zseq_users; CREATE SEQUENCE zseq_users_groups_link; CREATE SEQUENCE zseq_web_documents; CREATE SEQUENCE zseq_web_documents_status_lookup; CREATE SEQUENCE zseq_web_sites; COMMIT;