-- -- $Id$ -- -- KnowledgeTree Community Edition -- Document Management Made Simple -- Copyright (C) 2008 KnowledgeTree Inc. -- Portions copyright The Jam Warehouse Software (Pty) Limited -- -- This program is free software; you can redistribute it and/or modify it under -- the terms of the GNU General Public License version 3 as published by the -- Free Software Foundation. -- -- This program is distributed in the hope that it will be useful, but WITHOUT -- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS -- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more -- details. -- -- You should have received a copy of the GNU General Public License -- along with this program. If not, see . -- -- You can contact KnowledgeTree Inc., PO Box 7775 #87847, San Francisco, -- California 94120-7775, or email info@knowledgetree.com. -- -- The interactive user interfaces in modified source and object code versions -- of this program must display Appropriate Legal Notices, as required under -- Section 5 of the GNU General Public License version 3. -- -- In accordance with Section 7(b) of the GNU General Public License version 3, -- these Appropriate Legal Notices must retain the display of the "Powered by -- KnowledgeTree" logo and retain the original copyright notice. If the display of the -- logo is not reasonably feasible for technical reasons, the Appropriate Legal Notices -- must display the words "Powered by KnowledgeTree" and retain the original -- copyright notice. -- Contributor( s): ______________________________________ -- -- MySQL dump 10.11 -- -- Host: localhost Database: ktdms -- ------------------------------------------------------ -- Server version 5.0.41-log /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Dumping data for table `active_sessions` -- LOCK TABLES `active_sessions` WRITE; /*!40000 ALTER TABLE `active_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `active_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `archive_restoration_request` -- LOCK TABLES `archive_restoration_request` WRITE; /*!40000 ALTER TABLE `archive_restoration_request` DISABLE KEYS */; /*!40000 ALTER TABLE `archive_restoration_request` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `archiving_settings` -- LOCK TABLES `archiving_settings` WRITE; /*!40000 ALTER TABLE `archiving_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `archiving_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `archiving_type_lookup` -- LOCK TABLES `archiving_type_lookup` WRITE; /*!40000 ALTER TABLE `archiving_type_lookup` DISABLE KEYS */; INSERT INTO `archiving_type_lookup` VALUES (1,'Date'), (2,'Utilisation'); /*!40000 ALTER TABLE `archiving_type_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `authentication_sources` -- LOCK TABLES `authentication_sources` WRITE; /*!40000 ALTER TABLE `authentication_sources` DISABLE KEYS */; /*!40000 ALTER TABLE `authentication_sources` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `column_entries` -- LOCK TABLES `column_entries` WRITE; /*!40000 ALTER TABLE `column_entries` DISABLE KEYS */; INSERT INTO `column_entries` VALUES (1,'ktcore.columns.selection','ktcore.views.browse','',0,1), (2,'ktcore.columns.title','ktcore.views.browse','',1,1), (3,'ktcore.columns.download','ktcore.views.browse','',2,0), (4,'ktcore.columns.creationdate','ktcore.views.browse','',3,0), (5,'ktcore.columns.modificationdate','ktcore.views.browse','',4,0), (6,'ktcore.columns.creator','ktcore.views.browse','',5,0), (7,'ktcore.columns.workflow_state','ktcore.views.browse','',6,0), (8,'ktcore.columns.selection','ktcore.views.search','',0,1), (9,'ktcore.columns.title','ktcore.views.search','',1,1), (10,'ktcore.columns.download','ktcore.views.search','',2,0), (11,'ktcore.columns.creationdate','ktcore.views.search','',3,0), (12,'ktcore.columns.modificationdate','ktcore.views.search','',4,0), (13,'ktcore.columns.creator','ktcore.views.search','',5,0), (14,'ktcore.columns.workflow_state','ktcore.views.search','',6,0); /*!40000 ALTER TABLE `column_entries` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `comment_searchable_text` -- LOCK TABLES `comment_searchable_text` WRITE; /*!40000 ALTER TABLE `comment_searchable_text` DISABLE KEYS */; /*!40000 ALTER TABLE `comment_searchable_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `config_settings` -- LOCK TABLES `config_settings` WRITE; /*!40000 ALTER TABLE `config_settings` DISABLE KEYS */; INSERT INTO `config_settings` VALUES (1,'ui','appName','','KnowledgeTree','OEM application name','KnowledgeTree',1), (2,'KnowledgeTree','schedulerInterval','','30','','30',1), (3,'dashboard','alwaysShowYCOD','boolean','default','Display the \"Your Checked-out Documents\" dashlet even when empty.','0',1), (4,'urls','graphicsUrl','','${rootUrl}/graphics','','${rootUrl}/graphics',1), (5,'urls','uiUrl','','${rootUrl}/presentation/lookAndFeel/knowledgeTree','','${rootUrl}/presentation/lookAndFeel/knowledgeTree',1), (6,'tweaks','browseToUnitFolder','boolean','default','Whether to browse to the user\'s (first) unit when first going to the browse section.','0',1), (7,'tweaks','genericMetaDataRequired','boolean','1','','1',1), (8,'tweaks','developmentWindowLog','boolean','0','','0',1), (9,'tweaks','noisyBulkOperations','boolean','default','Whether bulk operations should generate a transaction notice on each ; item, or only on the folder. Default of \"false\" indicates that only the folder transaction should occur.','0',1), (10,'email','emailServer','','none','','none',1), (11,'email','emailPort','','default','','',1), (12,'email','emailAuthentication','boolean','0','Do you need auth to connect to SMTP?\r\n','0',1), (13,'email','emailUsername','','username','','username',1), (14,'email','emailPassword','','password','','password',1), (15,'email','emailFrom','','kt@example.org','','kt@example.org',1), (16,'email','emailFromName','','KnowledgeTree Document Management System','','KnowledgeTree Document Management System',1), (17,'email','allowAttachment','boolean','default','Set to true to allow users to send attachments from the document\r\n management system\r\n.','0',1), (18,'email','allowEmailAddresses','boolean','default','Set to true to allow users to send to any email address, as opposed to\r\n only users of the system\r\n.','0',1), (19,'email','sendAsSystem','boolean','default','Set to true to always send email from the emailFrom address listed above, even if there is an identifiable sending user\r\n.','0',1), (20,'email','onlyOwnGroups','boolean','default','Set to true to only allow users to send emails to those in the same\r\n groups as them\r\n.','0',1), (21,'user_prefs','passwordLength','','6','Minimum password length on password-setting\r\n','6',1), (22,'user_prefs','restrictAdminPasswords','boolean','default','Apply the minimum password length to admin while creating / editing accounts?\r\n default is set to \"false\" meaning that admins can create users with shorter passwords.\r\n','0',1), (23,'user_prefs','restrictPreferences','boolean','0','Restrict users from accessing their preferences menus?\r\n','0',1), (24,'session','sessionTimeout','','1200','Session timeout (in seconds)\r\n','1200',1), (25,'session','allowAnonymousLogin','boolean','0','By default, do not auto-login users as anonymous.\r\n Set this to true if you UNDERSTAND the security system that KT\r\n uses, and have sensibly applied the roles \"Everyone\" and \"Authenticated Users\".\r\n','0',1), (26,'ui','companyLogo','','${rootUrl}/resources/companylogo.png','Add the logo of your company to the site\'s appearance. This logo MUST be 50px tall, and on a white background.\r\n','${rootUrl}/resources/companylogo.png',1), (27,'ui','companyLogoWidth','','313px','The logo\'s width in pixels\r\n','313px',1), (28,'ui','companyLogoTitle','','ACME Corporation','ALT text - for accessibility purposes.\r\n','ACME Corporation',1), (29,'ui','alwaysShowAll','boolean','0','Do not restrict to searches (e.g. always show_all) on users and groups pages.\r\n','0',1), (30,'ui','condensedAdminUI','boolean','0','Use a condensed admin ui\r\n?','0',1), (31,'ui','fakeMimetype','boolean','0','Allow \"open\" from downloads. Changing this to \"true\" will prevent (most)\r\n browsers from giving users the \"open\" option.\r\n','0',1), (32,'ui','metadata_sort','boolean','0','Sort the metadata fields alphabetically\r\n','1',1), (33,'i18n','useLike','boolean','default','If your language doesn\'t have distinguishable words (usually, doesn\'t\r\n have a space character), set useLike to true to use a search that can\r\n deal with this, but which is slower.\r\n','0',1), (34,'import','unzip','','unzip','Unzip command - will use execSearchPath to find if the path to the binary is not given\r\n.','unzip',1), (35,'export','zip','','zip','Zip command - will use execSearchPath to find if the path to the\r\n binary is not given\r\n.','zip',1), (36,'externalBinary','xls2csv','','xls2csv','','xls2csv',1), (37,'externalBinary','pdftotext','','pdftotext','','pdftotext',1), (38,'externalBinary','catppt','','catppt','','catppt',1), (39,'externalBinary','pstotext','','pstotext','','pstotext',1), (40,'externalBinary','catdoc','','catdoc','','catdoc',1), (41,'externalBinary','antiword','','antiword','','antiword',1), (42,'externalBinary','python','','python','','python',1), (43,'externalBinary','java','','java','','java',1), (44,'externalBinary','php','','php','','php',1), (45,'externalBinary','df','','df','','df',1), (46,'cache','proxyCacheDirectory','','${varDirectory}/proxies','','${varDirectory}/proxies',1), (47,'cache','proxyCacheEnabled','boolean','1','','1',1), (48,'KTWebDAVSettings','debug','','off','This section is for KTWebDAV only, _LOTS_ of debug info will be logged if the following is \"on\"\r\n','off',1), (49,'KTWebDAVSettings','safemode','','on','To allow write access to WebDAV clients set safe mode to \"off\".','on',1), (50,'BaobabSettings','debug','','off','This section is for Baobab only\r\n, _LOTS_ of debug info will be logged if the following is \"on\"\r\n.','off',1), (51,'BaobabSettings','safemode','','on','To allow write access to WebDAV clients set safe mode to \"off\" below\r\n.','on',1), (52,'search','searchBasePath','','${fileSystemRoot}/search2','','${fileSystemRoot}/search2',1), (53,'search','fieldsPath','','${searchBasePath}/search/fields','','${searchBasePath}/search/fields',1), (54,'search','resultsDisplayFormat','','searchengine','The format in which to display the results\r\n options are searchengine or browseview defaults to searchengine\r\n.','searchengine',1), (55,'search','resultsPerPage','','50','The number of results per page\r\n, defaults to 25\r\n','25',1), (56,'search','dateFormat','','Y-m-d','The date format used when making queries using widgets\r\n, defaults to Y-m-d\r\n','Y-m-d',1), (57,'browse','previewActivation','','default','The document info box / preview is activated by mousing over or clicking on the icon\r\n. Options: onclick (default) or mouse-over\r\n.','onclick',1), (58,'indexer','coreClass','','JavaXMLRPCLuceneIndexer','The core indexing class\r\n. Choices: JavaXMLRPCLuceneIndexer or PHPLuceneIndexer.','JavaXMLRPCLuceneIndexer',1), (59,'indexer','batchDocuments','','20','The number of documents to be indexed in a cron session, defaults to 20\r\n.','20',1), (60,'indexer','batchMigrateDocuments','','500','The number of documents to be migrated in a cron session, defaults to 500\r\n.','500',1), (61,'indexer','indexingBasePath','','${searchBasePath}/indexing','','${searchBasePath}/indexing',1), (62,'indexer','luceneDirectory','','${varDirectory}/indexes','The location of the lucene indexes\r\n.','${varDirectory}/indexes',1), (63,'indexer','extractorPath','','${indexingBasePath}/extractors','','${indexingBasePath}/extractors',1), (64,'indexer','extractorHookPath','','${indexingBasePath}/extractorHooks','','${indexingBasePath}/extractorHooks',1), (65,'indexer','javaLuceneURL','','http://127.0.0.1:8875','The url for the Java Lucene Server. This should match up the the Lucene Server configuration. Defaults to http://127.0.0.1:8875\r\n','http://127.0.0.1:8875',1), (66,'openoffice','host','','default','The host on which open office is installed\r\n. Defaults to 127.0.0.1\r\n','127.0.0.1',1), (67,'openoffice','port','','default','The port on which open office is listening. Defaults to 8100\r\n','8100',1), (68,'webservice','uploadDirectory','','${varDirectory}/uploads','Directory to which all uploads via webservices are persisted before moving into the repository\r\n.','${varDirectory}/uploads',1), (69,'webservice','downloadUrl','','${rootUrl}/ktwebservice/download.php','Url which is sent to clients via web service calls so they can then download file via HTTP GET\r\n.','${rootUrl}/ktwebservice/download.php',1), (70,'webservice','uploadExpiry','','30','Period indicating how long a file should be retained in the uploads directory.\r\n','30',1), (71,'webservice','downloadExpiry','','30','Period indicating how long a download link will be available.','30',1), (72,'webservice','randomKeyText','','bkdfjhg23yskjdhf2iu','Random text used to construct a hash. This can be customised on installations so there is less chance of overlap between installations.\r\n','bkdfjhg23yskjdhf2iu',1), (73,'webservice','validateSessionCount','boolean','0','Validating session counts can interfere with access. It is best to leave this disabled, unless very strict access is required.\r\n','0',1), (74,'webservice','useDefaultDocumentTypeIfInvalid','boolean','1','If the document type is invalid when adding a document, we can be tollerant and just default to the Default document type.\r\n','1',1), (75,'webservice','debug','boolean','0','The web service debugging if the logLevel is set to DEBUG. We can set the value to 4 or 5 to get more verbose web service logging.\r\n Level 4 logs the name of functions being accessed. Level 5 logs the SOAP XML requests and responses.\r\n','0',1), (76,'clientToolPolicies','explorerMetadataCapture','boolean','1','This setting is one of two which control whether or not the client is prompted for metadata when a\r\n document is added to knowledgetree via KTtools. It defaults to true.\r\n','1',1), (77,'clientToolPolicies','officeMetadataCapture','boolean','1','This setting is one of two which control whether or not the client is prompted for metadata when a document is added to knowledgetree via KTtools. It defaults to true.','1',1), (78,'clientToolPolicies','captureReasonsDelete','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (79,'clientToolPolicies','captureReasonsCheckin','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (80,'clientToolPolicies','captureReasonsCheckout','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (81,'clientToolPolicies','captureReasonsCancelCheckout','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (82,'clientToolPolicies','captureReasonsCopyInKT','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (83,'clientToolPolicies','captureReasonsMoveInKT','boolean','1','This setting is one of six which govern whether reasons are asked for in KTtools\r\n.','1',1), (84,'clientToolPolicies','allowRememberPassword','boolean','1','This setting governs whether the password can be stored on the client or not.','1',1), (85,'DiskUsage','warningThreshold','','10','When free space in a mount point is less than this percentage, the disk usage dashlet will highlight the mount in ORANGE\r\n.','10',1), (86,'DiskUsage','urgentThreshold','','5','When free space in a mount point is less than this percentage, the disk usage dashlet will highlight the mount in RED\r\n.','5',1), (87,'KnowledgeTree','useNewDashboard','','default','','1',1), (88,'i18n','defaultLanguage','','en','Default language for the interface\r\n.','en',1), (89,'CustomErrorMessages','customerrormessages','','off','Turn custom error messages on or off here','on',1), (90,'CustomErrorMessages','customerrorpagepath','','customerrorpage.php','Name or url of custom error page\r\n.','customerrorpage.php',1), (91,'CustomErrorMessages','customerrorhandler','','off','Turn custom error handler on or off','on',1), (92,'ui','morphEnabled','boolean','0','Enable Morph','0',1), (93,'ui','morphTo','','blue','Morph Theme\r\n','blue',1), (94,'KnowledgeTree','logLevel','','default','Choice: INFO or DEBUG','INFO',1), (95,'storage','manager','','default','','KTOnDiskHashedStorageManager',1), (96,'ui','ieGIF','boolean','0','','1',1), (97,'ui','automaticRefresh','boolean','0','','0',1), (98,'ui','dot','','dot','','dot',1), (99,'tweaks','phpErrorLogFile','boolean','default','If you want to enable PHP error logging to the log/php_error_log file, change this setting to true\r\n.','0',1), (100,'urls','logDirectory','','default','','${varDirectory}/log',1), (101,'urls','uiDirectory','','default','','${fileSystemRoot}/presentation/lookAndFeel/knowledgeTree',1), (102,'urls','tmpDirectory','','default','','${varDirectory}/tmp',1), (103,'urls','stopwordsFile','','default','','${fileSystemRoot}/config/stopwords.txt',1), (104,'cache','cacheEnabled','boolean','default','','0',1), (105,'cache','cacheDirectory','','default','','${varDirectory}/cache',1), (106,'cache','cachePlugins','boolean','default','','1',1), (107,'urls','varDirectory','','default','','${fileSystemRoot}/var',1), (108,'urls','documentRoot','','default','','${varDirectory}/Documents',0); /*!40000 ALTER TABLE `config_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `dashlet_disables` -- LOCK TABLES `dashlet_disables` WRITE; /*!40000 ALTER TABLE `dashlet_disables` DISABLE KEYS */; /*!40000 ALTER TABLE `dashlet_disables` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `data_types` -- LOCK TABLES `data_types` WRITE; /*!40000 ALTER TABLE `data_types` DISABLE KEYS */; INSERT INTO `data_types` VALUES (1,'STRING'), (2,'CHAR'), (3,'TEXT'), (4,'INT'), (5,'FLOAT'); /*!40000 ALTER TABLE `data_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `discussion_comments` -- LOCK TABLES `discussion_comments` WRITE; /*!40000 ALTER TABLE `discussion_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `discussion_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `discussion_threads` -- LOCK TABLES `discussion_threads` WRITE; /*!40000 ALTER TABLE `discussion_threads` DISABLE KEYS */; /*!40000 ALTER TABLE `discussion_threads` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_archiving_link` -- LOCK TABLES `document_archiving_link` WRITE; /*!40000 ALTER TABLE `document_archiving_link` DISABLE KEYS */; /*!40000 ALTER TABLE `document_archiving_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_content_version` -- LOCK TABLES `document_content_version` WRITE; /*!40000 ALTER TABLE `document_content_version` DISABLE KEYS */; /*!40000 ALTER TABLE `document_content_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_fields` -- LOCK TABLES `document_fields` WRITE; /*!40000 ALTER TABLE `document_fields` DISABLE KEYS */; INSERT INTO `document_fields` VALUES (2,'Tag','STRING',0,0,0,2,0,'Tag Words',0), (3,'Document Author','STRING',0,0,0,3,0,'Please add a document author',0), (4,'Category','STRING',0,1,0,3,0,'Please select a category',1), (5,'Media Type','STRING',0,1,0,3,0,'Please select a media type',2); /*!40000 ALTER TABLE `document_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_fields_link` -- LOCK TABLES `document_fields_link` WRITE; /*!40000 ALTER TABLE `document_fields_link` DISABLE KEYS */; /*!40000 ALTER TABLE `document_fields_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_incomplete` -- LOCK TABLES `document_incomplete` WRITE; /*!40000 ALTER TABLE `document_incomplete` DISABLE KEYS */; /*!40000 ALTER TABLE `document_incomplete` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_link` -- LOCK TABLES `document_link` WRITE; /*!40000 ALTER TABLE `document_link` DISABLE KEYS */; /*!40000 ALTER TABLE `document_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_link_types` -- LOCK TABLES `document_link_types` WRITE; /*!40000 ALTER TABLE `document_link_types` DISABLE KEYS */; INSERT INTO `document_link_types` VALUES (-1,'depended on','was depended on by','Depends relationship whereby one documents depends on another\'s creation to go through approval'), (0,'Default','Default (reverse)','Default link type'), (3,'Attachment','','Document Attachment'), (4,'Reference','','Document Reference'), (5,'Copy','','Document Copy'); /*!40000 ALTER TABLE `document_link_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_metadata_version` -- LOCK TABLES `document_metadata_version` WRITE; /*!40000 ALTER TABLE `document_metadata_version` DISABLE KEYS */; /*!40000 ALTER TABLE `document_metadata_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_role_allocations` -- LOCK TABLES `document_role_allocations` WRITE; /*!40000 ALTER TABLE `document_role_allocations` DISABLE KEYS */; /*!40000 ALTER TABLE `document_role_allocations` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_searchable_text` -- LOCK TABLES `document_searchable_text` WRITE; /*!40000 ALTER TABLE `document_searchable_text` DISABLE KEYS */; /*!40000 ALTER TABLE `document_searchable_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_subscriptions` -- LOCK TABLES `document_subscriptions` WRITE; /*!40000 ALTER TABLE `document_subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `document_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_tags` -- LOCK TABLES `document_tags` WRITE; /*!40000 ALTER TABLE `document_tags` DISABLE KEYS */; /*!40000 ALTER TABLE `document_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_text` -- LOCK TABLES `document_text` WRITE; /*!40000 ALTER TABLE `document_text` DISABLE KEYS */; /*!40000 ALTER TABLE `document_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_transaction_text` -- LOCK TABLES `document_transaction_text` WRITE; /*!40000 ALTER TABLE `document_transaction_text` DISABLE KEYS */; /*!40000 ALTER TABLE `document_transaction_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_transaction_types_lookup` -- LOCK TABLES `document_transaction_types_lookup` WRITE; /*!40000 ALTER TABLE `document_transaction_types_lookup` DISABLE KEYS */; INSERT INTO `document_transaction_types_lookup` VALUES (1,'Create','ktcore.transactions.create'), (2,'Update','ktcore.transactions.update'), (3,'Delete','ktcore.transactions.delete'), (4,'Rename','ktcore.transactions.rename'), (5,'Move','ktcore.transactions.move'), (6,'Download','ktcore.transactions.download'), (7,'Check In','ktcore.transactions.check_in'), (8,'Check Out','ktcore.transactions.check_out'), (9,'Collaboration Step Rollback','ktcore.transactions.collaboration_step_rollback'), (10,'View','ktcore.transactions.view'), (11,'Expunge','ktcore.transactions.expunge'), (12,'Force CheckIn','ktcore.transactions.force_checkin'), (13,'Email Link','ktcore.transactions.email_link'), (14,'Collaboration Step Approve','ktcore.transactions.collaboration_step_approve'), (15,'Email Attachment','ktcore.transactions.email_attachment'), (16,'Workflow state transition','ktcore.transactions.workflow_state_transition'), (17,'Permissions changed','ktcore.transactions.permissions_change'), (18,'Role allocations changed','ktcore.transactions.role_allocations_change'), (19,'Bulk Export','ktstandard.transactions.bulk_export'), (20,'Copy','ktcore.transactions.copy'), (21,'Delete Version','ktcore.transactions.delete_version'); /*!40000 ALTER TABLE `document_transaction_types_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_transactions` -- LOCK TABLES `document_transactions` WRITE; /*!40000 ALTER TABLE `document_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `document_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_type_fields_link` -- LOCK TABLES `document_type_fields_link` WRITE; /*!40000 ALTER TABLE `document_type_fields_link` DISABLE KEYS */; /*!40000 ALTER TABLE `document_type_fields_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_type_fieldsets_link` -- LOCK TABLES `document_type_fieldsets_link` WRITE; /*!40000 ALTER TABLE `document_type_fieldsets_link` DISABLE KEYS */; /*!40000 ALTER TABLE `document_type_fieldsets_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `document_types_lookup` -- LOCK TABLES `document_types_lookup` WRITE; /*!40000 ALTER TABLE `document_types_lookup` DISABLE KEYS */; INSERT INTO `document_types_lookup` VALUES (1,'Default',0); /*!40000 ALTER TABLE `document_types_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `documents` -- LOCK TABLES `documents` WRITE; /*!40000 ALTER TABLE `documents` DISABLE KEYS */; /*!40000 ALTER TABLE `documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `download_files` -- LOCK TABLES `download_files` WRITE; /*!40000 ALTER TABLE `download_files` DISABLE KEYS */; /*!40000 ALTER TABLE `download_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `field_behaviour_options` -- LOCK TABLES `field_behaviour_options` WRITE; /*!40000 ALTER TABLE `field_behaviour_options` DISABLE KEYS */; /*!40000 ALTER TABLE `field_behaviour_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `field_behaviours` -- LOCK TABLES `field_behaviours` WRITE; /*!40000 ALTER TABLE `field_behaviours` DISABLE KEYS */; /*!40000 ALTER TABLE `field_behaviours` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `field_orders` -- LOCK TABLES `field_orders` WRITE; /*!40000 ALTER TABLE `field_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `field_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `field_value_instances` -- LOCK TABLES `field_value_instances` WRITE; /*!40000 ALTER TABLE `field_value_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `field_value_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `fieldsets` -- LOCK TABLES `fieldsets` WRITE; /*!40000 ALTER TABLE `fieldsets` DISABLE KEYS */; INSERT INTO `fieldsets` VALUES (2,'Tag Cloud','tagcloud',0,0,NULL,1,0,0,0,'Tag Cloud',0), (3,'General information','generalinformation',0,0,NULL,1,0,0,0,'General document information',0); /*!40000 ALTER TABLE `fieldsets` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_descendants` -- LOCK TABLES `folder_descendants` WRITE; /*!40000 ALTER TABLE `folder_descendants` DISABLE KEYS */; /*!40000 ALTER TABLE `folder_descendants` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_doctypes_link` -- LOCK TABLES `folder_doctypes_link` WRITE; /*!40000 ALTER TABLE `folder_doctypes_link` DISABLE KEYS */; INSERT INTO `folder_doctypes_link` VALUES (1,1,1); /*!40000 ALTER TABLE `folder_doctypes_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_searchable_text` -- LOCK TABLES `folder_searchable_text` WRITE; /*!40000 ALTER TABLE `folder_searchable_text` DISABLE KEYS */; INSERT INTO `folder_searchable_text` VALUES (1,'Root Folder'); /*!40000 ALTER TABLE `folder_searchable_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_subscriptions` -- LOCK TABLES `folder_subscriptions` WRITE; /*!40000 ALTER TABLE `folder_subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `folder_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_transactions` -- LOCK TABLES `folder_transactions` WRITE; /*!40000 ALTER TABLE `folder_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `folder_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folder_workflow_map` -- LOCK TABLES `folder_workflow_map` WRITE; /*!40000 ALTER TABLE `folder_workflow_map` DISABLE KEYS */; /*!40000 ALTER TABLE `folder_workflow_map` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folders` -- LOCK TABLES `folders` WRITE; /*!40000 ALTER TABLE `folders` DISABLE KEYS */; INSERT INTO `folders` VALUES (1,'Root Folder','Root Document Folder',NULL,1,0,NULL,NULL,1,5,0,1); /*!40000 ALTER TABLE `folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `folders_users_roles_link` -- LOCK TABLES `folders_users_roles_link` WRITE; /*!40000 ALTER TABLE `folders_users_roles_link` DISABLE KEYS */; /*!40000 ALTER TABLE `folders_users_roles_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `groups_groups_link` -- LOCK TABLES `groups_groups_link` WRITE; /*!40000 ALTER TABLE `groups_groups_link` DISABLE KEYS */; /*!40000 ALTER TABLE `groups_groups_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `groups_lookup` -- LOCK TABLES `groups_lookup` WRITE; /*!40000 ALTER TABLE `groups_lookup` DISABLE KEYS */; INSERT INTO `groups_lookup` VALUES (1,'System Administrators',1,0,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `groups_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `help` -- LOCK TABLES `help` WRITE; /*!40000 ALTER TABLE `help` DISABLE KEYS */; INSERT INTO `help` VALUES (1,'browse','dochelp.html'), (2,'dashboard','dashboardHelp.html'), (3,'addFolder','addFolderHelp.html'), (4,'editFolder','editFolderHelp.html'), (5,'addFolderCollaboration','addFolderCollaborationHelp.html'), (6,'modifyFolderCollaboration','addFolderCollaborationHelp.html'), (7,'addDocument','addDocumentHelp.html'), (8,'viewDocument','viewDocumentHelp.html'), (9,'modifyDocument','modifyDocumentHelp.html'), (10,'modifyDocumentRouting','modifyDocumentRoutingHelp.html'), (11,'emailDocument','emailDocumentHelp.html'), (12,'deleteDocument','deleteDocumentHelp.html'), (13,'administration','administrationHelp.html'), (14,'addGroup','addGroupHelp.html'), (15,'editGroup','editGroupHelp.html'), (16,'removeGroup','removeGroupHelp.html'), (17,'assignGroupToUnit','assignGroupToUnitHelp.html'), (18,'removeGroupFromUnit','removeGroupFromUnitHelp.html'), (19,'addUnit','addUnitHelp.html'), (20,'editUnit','editUnitHelp.html'), (21,'removeUnit','removeUnitHelp.html'), (22,'addOrg','addOrgHelp.html'), (23,'editOrg','editOrgHelp.html'), (24,'removeOrg','removeOrgHelp.html'), (25,'addRole','addRoleHelp.html'), (26,'editRole','editRoleHelp.html'), (27,'removeRole','removeRoleHelp.html'), (28,'addLink','addLinkHelp.html'), (29,'addLinkSuccess','addLinkHelp.html'), (30,'editLink','editLinkHelp.html'), (31,'removeLink','removeLinkHelp.html'), (32,'systemAdministration','systemAdministrationHelp.html'), (33,'deleteFolder','deleteFolderHelp.html'), (34,'editDocType','editDocTypeHelp.html'), (35,'removeDocType','removeDocTypeHelp.html'), (36,'addDocType','addDocTypeHelp.html'), (37,'addDocTypeSuccess','addDocTypeHelp.html'), (38,'manageSubscriptions','manageSubscriptionsHelp.html'), (39,'addSubscription','addSubscriptionHelp.html'), (40,'removeSubscription','removeSubscriptionHelp.html'), (41,'preferences','preferencesHelp.html'), (42,'editPrefsSuccess','preferencesHelp.html'), (43,'modifyDocumentGenericMetaData','modifyDocumentGenericMetaDataHelp.html'), (44,'viewHistory','viewHistoryHelp.html'), (45,'checkInDocument','checkInDocumentHelp.html'), (46,'checkOutDocument','checkOutDocumentHelp.html'), (47,'advancedSearch','advancedSearchHelp.html'), (48,'deleteFolderCollaboration','deleteFolderCollaborationHelp.html'), (49,'addFolderDocType','addFolderDocTypeHelp.html'), (50,'deleteFolderDocType','deleteFolderDocTypeHelp.html'), (51,'addGroupFolderLink','addGroupFolderLinkHelp.html'), (52,'deleteGroupFolderLink','deleteGroupFolderLinkHelp.html'), (53,'addWebsite','addWebsiteHelp.html'), (54,'addWebsiteSuccess','addWebsiteHelp.html'), (55,'editWebsite','editWebsiteHelp.html'), (56,'removeWebSite','removeWebSiteHelp.html'), (57,'standardSearch','standardSearchHelp.html'), (58,'modifyDocumentTypeMetaData','modifyDocumentTypeMetaDataHelp.html'), (59,'addDocField','addDocFieldHelp.html'), (60,'editDocField','editDocFieldHelp.html'), (61,'removeDocField','removeDocFieldHelp.html'), (62,'addMetaData','addMetaDataHelp.html'), (63,'editMetaData','editMetaDataHelp.html'), (64,'removeMetaData','removeMetaDataHelp.html'), (65,'addUser','addUserHelp.html'), (66,'editUser','editUserHelp.html'), (67,'removeUser','removeUserHelp.html'), (68,'addUserToGroup','addUserToGroupHelp.html'), (69,'removeUserFromGroup','removeUserFromGroupHelp.html'), (70,'viewDiscussion','viewDiscussionThread.html'), (71,'addComment','addDiscussionComment.html'), (72,'listNews','listDashboardNewsHelp.html'), (73,'editNews','editDashboardNewsHelp.html'), (74,'previewNews','previewDashboardNewsHelp.html'), (75,'addNews','addDashboardNewsHelp.html'), (76,'modifyDocumentArchiveSettings','modifyDocumentArchiveSettingsHelp.html'), (77,'addDocumentArchiveSettings','addDocumentArchiveSettingsHelp.html'), (78,'listDocFields','listDocumentFieldsAdmin.html'), (79,'editDocFieldLookups','editDocFieldLookups.html'), (80,'addMetaDataForField','addMetaDataForField.html'), (81,'editMetaDataForField','editMetaDataForField.html'), (82,'removeMetaDataFromField','removeMetaDataFromField.html'), (83,'listDocs','listDocumentsCheckoutHelp.html'), (84,'editDocCheckout','editDocCheckoutHelp.html'), (85,'listDocTypes','listDocTypesHelp.html'), (86,'editDocTypeFields','editDocFieldHelp.html'), (87,'addDocTypeFieldsLink','addDocTypeFieldHelp.html'), (88,'listGroups','listGroupsHelp.html'), (89,'editGroupUnit','editGroupUnitHelp.html'), (90,'listOrg','listOrgHelp.html'), (91,'listRole','listRolesHelp.html'), (92,'listUnits','listUnitHelp.html'), (93,'editUnitOrg','editUnitOrgHelp.html'), (94,'removeUnitFromOrg','removeUnitFromOrgHelp.html'), (95,'addUnitToOrg','addUnitToOrgHelp.html'), (96,'listUsers','listUsersHelp.html'), (97,'editUserGroups','editUserGroupsHelp.html'), (98,'listWebsites','listWebsitesHelp.html'), (99,'loginDisclaimer','loginDisclaimer.html'), (100,'pageDisclaimer','pageDisclaimer.html'); /*!40000 ALTER TABLE `help` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `help_replacement` -- LOCK TABLES `help_replacement` WRITE; /*!40000 ALTER TABLE `help_replacement` DISABLE KEYS */; /*!40000 ALTER TABLE `help_replacement` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `index_files` -- LOCK TABLES `index_files` WRITE; /*!40000 ALTER TABLE `index_files` DISABLE KEYS */; /*!40000 ALTER TABLE `index_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `interceptor_instances` -- LOCK TABLES `interceptor_instances` WRITE; /*!40000 ALTER TABLE `interceptor_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `interceptor_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `links` -- LOCK TABLES `links` WRITE; /*!40000 ALTER TABLE `links` DISABLE KEYS */; /*!40000 ALTER TABLE `links` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `metadata_lookup` -- LOCK TABLES `metadata_lookup` WRITE; /*!40000 ALTER TABLE `metadata_lookup` DISABLE KEYS */; INSERT INTO `metadata_lookup` VALUES (2,4,'Technical',NULL,0,0), (3,4,'Financial',NULL,0,0), (4,4,'Legal',NULL,0,0), (5,4,'Administrative',NULL,0,0), (6,4,'Miscellaneous',NULL,0,0), (7,4,'Sales',NULL,0,0), (8,5,'Text',NULL,0,0), (9,5,'Image',NULL,0,0), (10,5,'Audio',NULL,0,0), (11,5,'Video',NULL,0,0); /*!40000 ALTER TABLE `metadata_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `metadata_lookup_tree` -- LOCK TABLES `metadata_lookup_tree` WRITE; /*!40000 ALTER TABLE `metadata_lookup_tree` DISABLE KEYS */; /*!40000 ALTER TABLE `metadata_lookup_tree` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `mime_document_mapping` -- LOCK TABLES `mime_document_mapping` WRITE; /*!40000 ALTER TABLE `mime_document_mapping` DISABLE KEYS */; /*!40000 ALTER TABLE `mime_document_mapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `mime_documents` -- LOCK TABLES `mime_documents` WRITE; /*!40000 ALTER TABLE `mime_documents` DISABLE KEYS */; /*!40000 ALTER TABLE `mime_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `mime_extractors` -- LOCK TABLES `mime_extractors` WRITE; /*!40000 ALTER TABLE `mime_extractors` DISABLE KEYS */; /*!40000 ALTER TABLE `mime_extractors` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `mime_types` -- LOCK TABLES `mime_types` WRITE; /*!40000 ALTER TABLE `mime_types` DISABLE KEYS */; INSERT INTO `mime_types` VALUES (1,'ai','application/ai','image','Adobe Illustrator Vector Graphic',NULL,NULL), (2,'aif','audio/x-aiff',NULL,'',NULL,NULL), (3,'aifc','audio/x-aiff',NULL,'',NULL,NULL), (4,'aiff','audio/x-aiff',NULL,'',NULL,NULL), (5,'asc','text/plain','text','Plain Text',NULL,NULL), (6,'au','audio/basic',NULL,'',NULL,NULL), (7,'avi','video/x-msvideo',NULL,'Video File',NULL,NULL), (8,'bcpio','application/x-bcpio',NULL,'',NULL,NULL), (9,'bin','application/octet-stream',NULL,'Binary File',NULL,NULL), (10,'bmp','image/bmp','image','BMP Image',NULL,NULL), (11,'cdf','application/x-netcdf',NULL,'',NULL,NULL), (12,'class','application/octet-stream',NULL,'',NULL,NULL), (13,'cpio','application/x-cpio',NULL,'',NULL,NULL), (14,'cpt','application/mac-compactpro',NULL,'',NULL,NULL), (15,'csh','application/x-csh',NULL,'',NULL,NULL), (16,'css','text/css',NULL,'',NULL,NULL), (17,'dcr','application/x-director',NULL,'',NULL,NULL), (18,'dir','application/x-director',NULL,'',NULL,NULL), (19,'dms','application/octet-stream',NULL,'',NULL,NULL), (20,'doc','application/msword','word','Word Document',NULL,NULL), (21,'dvi','application/x-dvi',NULL,'',NULL,NULL), (22,'dxr','application/x-director',NULL,'',NULL,NULL), (23,'eps','application/eps','image','Encapsulated Postscript',NULL,NULL), (24,'etx','text/x-setext',NULL,'',NULL,NULL), (25,'exe','application/octet-stream',NULL,'',NULL,NULL), (26,'ez','application/andrew-inset',NULL,'',NULL,NULL), (27,'gif','image/gif','image','GIF Image',NULL,NULL), (28,'gtar','application/x-gtar','compressed','',NULL,NULL), (29,'hdf','application/x-hdf',NULL,'',NULL,NULL), (30,'hqx','application/mac-binhex40',NULL,'',NULL,NULL), (31,'htm','text/html','html','HTML Webpage',NULL,NULL), (32,'html','text/html','html','HTML Webpage',NULL,NULL), (33,'ice','x-conference/x-cooltalk',NULL,'',NULL,NULL), (34,'ief','image/ief','image','',NULL,NULL), (35,'iges','model/iges',NULL,'',NULL,NULL), (36,'igs','model/iges',NULL,'',NULL,NULL), (37,'jpe','image/jpeg','image','JPEG Image',NULL,NULL), (38,'jpeg','image/jpeg','image','JPEG Image',NULL,NULL), (39,'jpg','image/jpeg','image','JPEG Image',NULL,NULL), (40,'js','application/x-javascript','html','',NULL,NULL), (41,'kar','audio/midi',NULL,'',NULL,NULL), (42,'latex','application/x-latex',NULL,'',NULL,NULL), (43,'lha','application/octet-stream',NULL,'',NULL,NULL), (44,'lzh','application/octet-stream',NULL,'',NULL,NULL), (45,'man','application/x-troff-man',NULL,'',NULL,NULL), (46,'mdb','application/access','database','Access Database',NULL,NULL), (47,'mdf','application/access','database','Access Database',NULL,NULL), (48,'me','application/x-troff-me',NULL,'',NULL,NULL), (49,'mesh','model/mesh',NULL,'',NULL,NULL), (50,'mid','audio/midi',NULL,'',NULL,NULL), (51,'midi','audio/midi',NULL,'',NULL,NULL), (52,'mif','application/vnd.mif',NULL,'',NULL,NULL), (53,'mov','video/quicktime',NULL,'Video File',NULL,NULL), (54,'movie','video/x-sgi-movie',NULL,'Video File',NULL,NULL), (55,'mp2','audio/mpeg',NULL,'',NULL,NULL), (56,'mp3','audio/mpeg',NULL,'',NULL,NULL), (57,'mpe','video/mpeg',NULL,'Video File',NULL,NULL), (58,'mpeg','video/mpeg',NULL,'Video File',NULL,NULL), (59,'mpg','video/mpeg',NULL,'Video File',NULL,NULL), (60,'mpga','audio/mpeg',NULL,'',NULL,NULL), (61,'mpp','application/vnd.ms-project','office','',NULL,NULL), (62,'ms','application/x-troff-ms',NULL,'',NULL,NULL), (63,'msh','model/mesh',NULL,'',NULL,NULL), (64,'nc','application/x-netcdf',NULL,'',NULL,NULL), (65,'oda','application/oda',NULL,'',NULL,NULL), (66,'pbm','image/x-portable-bitmap','image','',NULL,NULL), (67,'pdb','chemical/x-pdb',NULL,'',NULL,NULL), (68,'pdf','application/pdf','pdf','Acrobat PDF',NULL,NULL), (69,'pgm','image/x-portable-graymap','image','',NULL,NULL), (70,'pgn','application/x-chess-pgn',NULL,'',NULL,NULL), (71,'png','image/png','image','PNG Image',NULL,NULL), (72,'pnm','image/x-portable-anymap','image','',NULL,NULL), (73,'ppm','image/x-portable-pixmap','image','',NULL,NULL), (74,'ppt','application/vnd.ms-powerpoint','office','Powerpoint Presentation',NULL,NULL), (75,'ps','application/postscript','pdf','Postscript Document',NULL,NULL), (76,'qt','video/quicktime',NULL,'Video File',NULL,NULL), (77,'ra','audio/x-realaudio',NULL,'',NULL,NULL), (78,'ram','audio/x-pn-realaudio',NULL,'',NULL,NULL), (79,'ras','image/x-cmu-raster','image','',NULL,NULL), (80,'rgb','image/x-rgb','image','',NULL,NULL), (81,'rm','audio/x-pn-realaudio',NULL,'',NULL,NULL), (82,'roff','application/x-troff',NULL,'',NULL,NULL), (83,'rpm','audio/x-pn-realaudio-plugin',NULL,'',NULL,NULL), (84,'rtf','text/rtf',NULL,'',NULL,NULL), (85,'rtx','text/richtext',NULL,'',NULL,NULL), (86,'sgm','text/sgml',NULL,'',NULL,NULL), (87,'sgml','text/sgml',NULL,'',NULL,NULL), (88,'sh','application/x-sh',NULL,'',NULL,NULL), (89,'shar','application/x-shar',NULL,'',NULL,NULL), (90,'silo','model/mesh',NULL,'',NULL,NULL), (91,'sit','application/x-stuffit',NULL,'',NULL,NULL), (92,'skd','application/x-koan',NULL,'',NULL,NULL), (93,'skm','application/x-koan',NULL,'',NULL,NULL), (94,'skp','application/x-koan',NULL,'',NULL,NULL), (95,'skt','application/x-koan',NULL,'',NULL,NULL), (96,'smi','application/smil',NULL,'',NULL,NULL), (97,'smil','application/smil',NULL,'',NULL,NULL), (98,'snd','audio/basic',NULL,'',NULL,NULL), (99,'spl','application/x-futuresplash',NULL,'',NULL,NULL), (100,'src','application/x-wais-source',NULL,'',NULL,NULL), (101,'sv4cpio','application/x-sv4cpio',NULL,'',NULL,NULL), (102,'sv4crc','application/x-sv4crc',NULL,'',NULL,NULL), (103,'swf','application/x-shockwave-flash',NULL,'',NULL,NULL), (104,'t','application/x-troff',NULL,'',NULL,NULL), (105,'tar','application/x-tar','compressed','Tar or Compressed Tar File',NULL,NULL), (106,'tcl','application/x-tcl',NULL,'',NULL,NULL), (107,'tex','application/x-tex',NULL,'',NULL,NULL), (108,'texi','application/x-texinfo',NULL,'',NULL,NULL), (109,'texinfo','application/x-texinfo',NULL,'',NULL,NULL), (110,'tif','image/tiff','image','TIFF Image',NULL,NULL), (111,'tiff','image/tiff','image','TIFF Image',NULL,NULL), (112,'tr','application/x-troff',NULL,'',NULL,NULL), (113,'tsv','text/tab-separated-values',NULL,'',NULL,NULL), (114,'txt','text/plain','text','Plain Text',NULL,NULL), (115,'ustar','application/x-ustar',NULL,'',NULL,NULL), (116,'vcd','application/x-cdlink',NULL,'',NULL,NULL), (117,'vrml','model/vrml',NULL,'',NULL,NULL), (118,'vsd','application/vnd.visio','office','',NULL,NULL), (119,'wav','audio/x-wav',NULL,'',NULL,NULL), (120,'wrl','model/vrml',NULL,'',NULL,NULL), (121,'xbm','image/x-xbitmap','image','',NULL,NULL), (122,'xls','application/vnd.ms-excel','excel','Excel Spreadsheet',NULL,NULL), (123,'xml','text/xml',NULL,'',NULL,NULL), (124,'xpm','image/x-xpixmap','image','',NULL,NULL), (125,'xwd','image/x-xwindowdump','image','',NULL,NULL), (126,'xyz','chemical/x-pdb',NULL,'',NULL,NULL), (127,'zip','application/zip','compressed','ZIP Compressed File',NULL,NULL), (128,'gz','application/x-gzip','compressed','GZIP Compressed File',NULL,NULL), (129,'tgz','application/x-gzip','compressed','Tar or Compressed Tar File',NULL,NULL), (130,'sxw','application/vnd.sun.xml.writer','openoffice','OpenOffice.org Writer Document',NULL,NULL), (131,'stw','application/vnd.sun.xml.writer.template','openoffice','OpenOffice.org File',NULL,NULL), (132,'sxc','application/vnd.sun.xml.calc','openoffice','OpenOffice.org Spreadsheet',NULL,NULL), (133,'stc','application/vnd.sun.xml.calc.template','openoffice','OpenOffice.org File',NULL,NULL), (134,'sxd','application/vnd.sun.xml.draw','openoffice','OpenOffice.org File',NULL,NULL), (135,'std','application/vnd.sun.xml.draw.template','openoffice','OpenOffice.org File',NULL,NULL), (136,'sxi','application/vnd.sun.xml.impress','openoffice','OpenOffice.org Presentation',NULL,NULL), (137,'sti','application/vnd.sun.xml.impress.template','openoffice','OpenOffice.org File',NULL,NULL), (138,'sxg','application/vnd.sun.xml.writer.global','openoffice','OpenOffice.org File',NULL,NULL), (139,'sxm','application/vnd.sun.xml.math','openoffice','OpenOffice.org File',NULL,NULL), (140,'xlt','application/vnd.ms-excel','excel','Excel Template',NULL,NULL), (141,'dot','application/msword','word','Word Template',NULL,NULL), (142,'bz2','application/x-bzip2','compressed','BZIP2 Compressed File',NULL,NULL), (143,'diff','text/plain','text','Source Diff File',NULL,NULL), (144,'patch','text/plain','text','Patch File',NULL,NULL), (145,'odt','application/vnd.oasis.opendocument.text','opendocument','OpenDocument Text',NULL,NULL), (146,'ott','application/vnd.oasis.opendocument.text-template','opendocument','OpenDocument Text Template',NULL,NULL), (147,'oth','application/vnd.oasis.opendocument.text-web','opendocument','HTML Document Template',NULL,NULL), (148,'odm','application/vnd.oasis.opendocument.text-master','opendocument','OpenDocument Master Document',NULL,NULL), (149,'odg','application/vnd.oasis.opendocument.graphics','opendocument','OpenDocument Drawing',NULL,NULL), (150,'otg','application/vnd.oasis.opendocument.graphics-template','opendocument','OpenDocument Drawing Template',NULL,NULL), (151,'odp','application/vnd.oasis.opendocument.presentation','opendocument','OpenDocument Presentation',NULL,NULL), (152,'otp','application/vnd.oasis.opendocument.presentation-template','opendocument','OpenDocument Presentation Template',NULL,NULL), (153,'ods','application/vnd.oasis.opendocument.spreadsheet','opendocument','OpenDocument Spreadsheet',NULL,NULL), (154,'ots','application/vnd.oasis.opendocument.spreadsheet-template','opendocument','OpenDocument Spreadsheet Template',NULL,NULL), (155,'odc','application/vnd.oasis.opendocument.chart','opendocument','OpenDocument Chart',NULL,NULL), (156,'odf','application/vnd.oasis.opendocument.formula','opendocument','OpenDocument Formula',NULL,NULL), (157,'odb','application/vnd.oasis.opendocument.database','opendocument','OpenDocument Database',NULL,NULL), (158,'odi','application/vnd.oasis.opendocument.image','opendocument','OpenDocument Image',NULL,NULL), (159,'zip','application/x-zip','compressed','ZIP Compressed File',NULL,NULL), (160,'csv','text/csv','excel','Comma delimited spreadsheet',NULL,NULL), (161,'msi','application/x-msi','compressed','MSI Installer file',NULL,NULL), (162,'pps','application/vnd.ms-powerpoint','office','Powerpoint Presentation',NULL,NULL), (163,'docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document','word','Word Document',NULL,NULL), (164,'dotx','application/vnd.openxmlformats-officedocument.wordprocessingml.template','word','Word Document',NULL,NULL), (165,'potx','application/vnd.openxmlformats-officedocument.presentationml.template','office','Powerpoint Presentation',NULL,NULL), (166,'ppsx','application/vnd.openxmlformats-officedocument.presentationml.slideshow','office','Powerpoint Presentation',NULL,NULL), (167,'pptx','application/vnd.openxmlformats-officedocument.presentationml.presentation','office','Powerpoint Presentation',NULL,NULL), (168,'xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','excel','Excel Spreadsheet',NULL,NULL), (169,'xltx','application/vnd.openxmlformats-officedocument.spreadsheetml.template','excel','Excel Spreadsheet',NULL,NULL), (170,'msg','application/vnd.ms-outlook','office','Outlook Item',NULL,NULL), (171,'db','application/db','','Misc DB file',NULL,NULL); /*!40000 ALTER TABLE `mime_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `organisations_lookup` -- LOCK TABLES `organisations_lookup` WRITE; /*!40000 ALTER TABLE `organisations_lookup` DISABLE KEYS */; INSERT INTO `organisations_lookup` VALUES (1,'Default Organisation'); /*!40000 ALTER TABLE `organisations_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_assignments` -- LOCK TABLES `permission_assignments` WRITE; /*!40000 ALTER TABLE `permission_assignments` DISABLE KEYS */; INSERT INTO `permission_assignments` VALUES (1,1,1,2), (2,2,1,2), (3,3,1,2), (4,4,1,2), (5,5,1,2), (6,6,1,2), (7,7,1,2), (8,8,1,2); /*!40000 ALTER TABLE `permission_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_descriptor_groups` -- LOCK TABLES `permission_descriptor_groups` WRITE; /*!40000 ALTER TABLE `permission_descriptor_groups` DISABLE KEYS */; INSERT INTO `permission_descriptor_groups` VALUES (2,1); /*!40000 ALTER TABLE `permission_descriptor_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_descriptor_roles` -- LOCK TABLES `permission_descriptor_roles` WRITE; /*!40000 ALTER TABLE `permission_descriptor_roles` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_descriptor_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_descriptor_users` -- LOCK TABLES `permission_descriptor_users` WRITE; /*!40000 ALTER TABLE `permission_descriptor_users` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_descriptor_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_descriptors` -- LOCK TABLES `permission_descriptors` WRITE; /*!40000 ALTER TABLE `permission_descriptors` DISABLE KEYS */; INSERT INTO `permission_descriptors` VALUES (1,'d41d8cd98f00b204e9800998ecf8427e',''), (2,'a689e7c4dc953de8d93b1ed4843b2dfe','group(1)'); /*!40000 ALTER TABLE `permission_descriptors` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_dynamic_assignments` -- LOCK TABLES `permission_dynamic_assignments` WRITE; /*!40000 ALTER TABLE `permission_dynamic_assignments` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_dynamic_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_dynamic_conditions` -- LOCK TABLES `permission_dynamic_conditions` WRITE; /*!40000 ALTER TABLE `permission_dynamic_conditions` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_dynamic_conditions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_lookup_assignments` -- LOCK TABLES `permission_lookup_assignments` WRITE; /*!40000 ALTER TABLE `permission_lookup_assignments` DISABLE KEYS */; INSERT INTO `permission_lookup_assignments` VALUES (1,1,1,1), (2,2,1,1), (3,3,1,1), (4,1,2,2), (5,2,2,2), (6,3,2,2), (7,1,3,2), (8,2,3,2), (9,3,3,2), (10,4,3,2), (11,5,3,2), (12,1,4,2), (13,2,4,2), (14,3,4,2), (15,4,4,2), (16,5,4,2), (17,6,4,2), (18,1,5,2), (19,2,5,2), (20,3,5,2), (21,4,5,2), (22,5,5,2), (23,6,5,2), (24,7,5,2); /*!40000 ALTER TABLE `permission_lookup_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_lookups` -- LOCK TABLES `permission_lookups` WRITE; /*!40000 ALTER TABLE `permission_lookups` DISABLE KEYS */; INSERT INTO `permission_lookups` VALUES (1), (2), (3), (4), (5); /*!40000 ALTER TABLE `permission_lookups` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permission_objects` -- LOCK TABLES `permission_objects` WRITE; /*!40000 ALTER TABLE `permission_objects` DISABLE KEYS */; INSERT INTO `permission_objects` VALUES (1); /*!40000 ALTER TABLE `permission_objects` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'ktcore.permissions.read','Read',1), (2,'ktcore.permissions.write','Write',1), (3,'ktcore.permissions.addFolder','Add Folder',1), (4,'ktcore.permissions.security','Manage security',1), (5,'ktcore.permissions.delete','Delete',1), (6,'ktcore.permissions.workflow','Manage workflow',1), (7,'ktcore.permissions.folder_details','Folder Details',1), (8,'ktcore.permissions.folder_rename','Rename Folder',1); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `plugin_helper` -- LOCK TABLES `plugin_helper` WRITE; /*!40000 ALTER TABLE `plugin_helper` DISABLE KEYS */; /*!40000 ALTER TABLE `plugin_helper` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `plugin_rss` -- LOCK TABLES `plugin_rss` WRITE; /*!40000 ALTER TABLE `plugin_rss` DISABLE KEYS */; /*!40000 ALTER TABLE `plugin_rss` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `plugins` -- LOCK TABLES `plugins` WRITE; /*!40000 ALTER TABLE `plugins` DISABLE KEYS */; INSERT INTO `plugins` VALUES (1,'ktcore.tagcloud.plugin','plugins/tagcloud/TagCloudPlugin.php',0,0,NULL,0,'Tag Cloud Plugin',0), (2,'ktcore.rss.plugin','plugins/rssplugin/RSSPlugin.php',0,0,NULL,0,'RSS Plugin',0), (3,'ktcore.language.plugin','plugins/ktcore/KTCoreLanguagePlugin.php',0,0,NULL,0,'Core Language Support',-75), (4,'ktcore.plugin','plugins/ktcore/KTCorePlugin.php',0,0,NULL,0,'Core Application Functionality',-25), (5,'ktstandard.adminversion.plugin','plugins/ktstandard/AdminVersionPlugin/AdminVersionPlugin.php',0,0,NULL,0,'Admin Version Notifier',0), (6,'ktstandard.ldapauthentication.plugin','plugins/ktstandard/KTLDAPAuthenticationPlugin.php',0,0,NULL,0,'LDAP Authentication Plugin',0), (7,'ktstandard.pdf.plugin','plugins/ktstandard/PDFGeneratorPlugin.php',0,0,NULL,0,'PDF Generator Plugin',0), (8,'ktstandard.bulkexport.plugin','plugins/ktstandard/KTBulkExportPlugin.php',0,0,NULL,0,'Bulk Export Plugin',0), (9,'ktstandard.immutableaction.plugin','plugins/ktstandard/ImmutableActionPlugin.php',0,0,NULL,0,'Immutable action plugin',0), (10,'ktstandard.subscriptions.plugin','plugins/ktstandard/KTSubscriptions.php',0,0,NULL,0,'Subscription Plugin',0), (11,'ktstandard.discussion.plugin','plugins/ktstandard/KTDiscussion.php',0,0,NULL,0,'Document Discussions Plugin',0), (12,'ktstandard.email.plugin','plugins/ktstandard/KTEmail.php',0,0,NULL,0,'Email Plugin',0), (13,'ktstandard.indexer.plugin','plugins/ktstandard/KTIndexer.php',0,0,NULL,0,'Full-text Content Indexing',0), (14,'ktstandard.documentlinks.plugin','plugins/ktstandard/KTDocumentLinks.php',0,0,NULL,0,'Inter-document linking',0), (15,'ktstandard.workflowassociation.plugin','plugins/ktstandard/KTWorkflowAssociation.php',0,0,NULL,0,'Workflow Association Plugin',0), (16,'ktstandard.workflowassociation.documenttype.plugin','plugins/ktstandard/workflow/TypeAssociator.php',0,0,NULL,0,'Workflow allocation by document type',0), (17,'ktstandard.workflowassociation.folder.plugin','plugins/ktstandard/workflow/FolderAssociator.php',0,0,NULL,0,'Workflow allocation by location',0), (18,'ktstandard.disclaimers.plugin','plugins/ktstandard/KTDisclaimers.php',0,0,NULL,0,'Disclaimers Plugin',0), (19,'nbm.browseable.plugin','plugins/browseabledashlet/BrowseableDashletPlugin.php',0,0,NULL,0,'Orphaned Folders Plugin',0), (20,'ktstandard.ktwebdavdashlet.plugin','plugins/ktstandard/KTWebDAVDashletPlugin.php',0,0,NULL,0,'WebDAV Dashlet Plugin',0), (21,'ktcore.housekeeper.plugin','plugins/housekeeper/HouseKeeperPlugin.php',0,0,NULL,0,'Housekeeper',0); /*!40000 ALTER TABLE `plugins` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `role_allocations` -- LOCK TABLES `role_allocations` WRITE; /*!40000 ALTER TABLE `role_allocations` DISABLE KEYS */; /*!40000 ALTER TABLE `role_allocations` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (-4,'Authenticated Users'), (4,'Creator'), (-3,'Everyone'), (-2,'Owner'), (2,'Publisher'), (3,'Reviewer'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `saved_searches` -- LOCK TABLES `saved_searches` WRITE; /*!40000 ALTER TABLE `saved_searches` DISABLE KEYS */; /*!40000 ALTER TABLE `saved_searches` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `scheduler_tasks` -- LOCK TABLES `scheduler_tasks` WRITE; /*!40000 ALTER TABLE `scheduler_tasks` DISABLE KEYS */; INSERT INTO `scheduler_tasks` VALUES (1,'Indexing','search2/bin/cronIndexer.php','',0,'1min','2007-10-01 00:00:00',NULL,0,'system'), (2,'Index Migration','search2/bin/cronMigration.php','',0,'5mins','2007-10-01 00:00:00',NULL,0,'system'), (3,'Index Optimization','search2/bin/cronOptimize.php','',0,'weekly','2007-10-01 00:00:00',NULL,0,'system'), (4,'Periodic Document Expunge','bin/expungeall.php','',0,'weekly','2007-10-01 00:00:00',NULL,0,'disabled'), (5,'Database Maintenance','bin/dbmaint.php','optimize',0,'monthly','2007-10-01 00:00:00',NULL,0,'disabled'), (6,'Open Office test','bin/checkopenoffice.php','',0,'1min','2007-10-01 00:00:00',NULL,0,'enabled'), (7,'Cleanup Temporary Directory','search2/bin/cronCleanup.php','',0,'1min','2007-10-01 00:00:00',NULL,0,'enabled'), (8,'Disk Usage and Folder Utilisation Statistics','plugins/housekeeper/bin/UpdateStats.php','',0,'5mins','2007-10-01 00:00:00',NULL,0,'enabled'), (9,'Check Latest Version','plugins/ktstandard/AdminVersionPlugin/bin/UpdateNewVersion.php','',0,'daily','2007-10-01 00:00:00',NULL,0,'enabled'), (10,'Refresh Index Statistics','search2/bin/cronIndexStats.php','',0,'daily','2007-10-01 00:00:00',NULL,0,'enabled'), (11,'Refresh Resource Dependancies','search2/bin/cronResources.php','',0,'daily','2007-10-01 00:00:00',NULL,0,'enabled'); /*!40000 ALTER TABLE `scheduler_tasks` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `search_document_user_link` -- LOCK TABLES `search_document_user_link` WRITE; /*!40000 ALTER TABLE `search_document_user_link` DISABLE KEYS */; /*!40000 ALTER TABLE `search_document_user_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `search_ranking` -- LOCK TABLES `search_ranking` WRITE; /*!40000 ALTER TABLE `search_ranking` DISABLE KEYS */; INSERT INTO `search_ranking` VALUES ('Discussion','',150,'S'), ('documents','checked_out_user_id',1,'T'), ('documents','created',1,'T'), ('documents','creator_id',1,'T'), ('documents','id',1,'T'), ('documents','immutable',1,'T'), ('documents','is_checked_out',1,'T'), ('documents','modified',1,'T'), ('documents','modified_user_id',1,'T'), ('documents','title',300,'T'), ('DocumentText','',100,'S'), ('document_content_version','filename',10,'T'), ('document_content_version','filesize',1,'T'), ('document_metadata_version','document_type_id',1,'T'), ('document_metadata_version','name',1,'T'), ('document_metadata_version','workflow_id',1,'T'), ('document_metadata_version','workflow_state_id',1,'T'), ('tag_words','tag',1,'T'); /*!40000 ALTER TABLE `search_ranking` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `search_saved` -- LOCK TABLES `search_saved` WRITE; /*!40000 ALTER TABLE `search_saved` DISABLE KEYS */; /*!40000 ALTER TABLE `search_saved` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `search_saved_events` -- LOCK TABLES `search_saved_events` WRITE; /*!40000 ALTER TABLE `search_saved_events` DISABLE KEYS */; /*!40000 ALTER TABLE `search_saved_events` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `status_lookup` -- LOCK TABLES `status_lookup` WRITE; /*!40000 ALTER TABLE `status_lookup` DISABLE KEYS */; INSERT INTO `status_lookup` VALUES (1,'Live'), (2,'Published'), (3,'Deleted'), (4,'Archived'), (5,'Incomplete'), (6,'Version Deleted'); /*!40000 ALTER TABLE `status_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `system_settings` -- LOCK TABLES `system_settings` WRITE; /*!40000 ALTER TABLE `system_settings` DISABLE KEYS */; INSERT INTO `system_settings` VALUES (1,'lastIndexUpdate','0'), (2,'knowledgeTreeVersion','3.5.2'), (3,'databaseVersion','3.5.2'); /*!40000 ALTER TABLE `system_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `tag_words` -- LOCK TABLES `tag_words` WRITE; /*!40000 ALTER TABLE `tag_words` DISABLE KEYS */; /*!40000 ALTER TABLE `tag_words` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `time_period` -- LOCK TABLES `time_period` WRITE; /*!40000 ALTER TABLE `time_period` DISABLE KEYS */; /*!40000 ALTER TABLE `time_period` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `time_unit_lookup` -- LOCK TABLES `time_unit_lookup` WRITE; /*!40000 ALTER TABLE `time_unit_lookup` DISABLE KEYS */; INSERT INTO `time_unit_lookup` VALUES (1,'Years'), (2,'Months'), (3,'Days'); /*!40000 ALTER TABLE `time_unit_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `trigger_selection` -- LOCK TABLES `trigger_selection` WRITE; /*!40000 ALTER TABLE `trigger_selection` DISABLE KEYS */; /*!40000 ALTER TABLE `trigger_selection` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `type_workflow_map` -- LOCK TABLES `type_workflow_map` WRITE; /*!40000 ALTER TABLE `type_workflow_map` DISABLE KEYS */; /*!40000 ALTER TABLE `type_workflow_map` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `units_lookup` -- LOCK TABLES `units_lookup` WRITE; /*!40000 ALTER TABLE `units_lookup` DISABLE KEYS */; /*!40000 ALTER TABLE `units_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `units_organisations_link` -- LOCK TABLES `units_organisations_link` WRITE; /*!40000 ALTER TABLE `units_organisations_link` DISABLE KEYS */; /*!40000 ALTER TABLE `units_organisations_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `upgrades` -- LOCK TABLES `upgrades` WRITE; /*!40000 ALTER TABLE `upgrades` DISABLE KEYS */; INSERT INTO `upgrades` VALUES (1,'sql*2.0.6*0*2.0.6/create_upgrade_table.sql','Database upgrade to version 2.0.6: Create upgrade table','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (2,'upgrade*2.0.6*0*upgrade2.0.6','Upgrade from version 2.0.2 to 2.0.6','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (3,'func*2.0.6*0*addTemplateMimeTypes','Add MIME types for Excel and Word templates','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (4,'sql*2.0.6*0*2.0.6/add_email_attachment_transaction_type.sql','Database upgrade to version 2.0.6: Add email attachment transaction type','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (5,'sql*2.0.6*0*2.0.6/create_link_type_table.sql','Database upgrade to version 2.0.6: Create link type table','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (6,'sql*2.0.6*1*2.0.6/1-update_database_version.sql','Database upgrade to version 2.0.6: Update database version','2005-06-16 00:30:06',1,'upgrade*2.0.6*0*upgrade2.0.6'), (7,'upgrade*2.0.7*0*upgrade2.0.7','Upgrade from version 2.0.7 to 2.0.7','2005-07-21 22:35:15',1,'upgrade*2.0.7*0*upgrade2.0.7'), (8,'sql*2.0.7*0*2.0.7/document_link_update.sql','Database upgrade to version 2.0.7: Document link update','2005-07-21 22:35:16',1,'upgrade*2.0.7*0*upgrade2.0.7'), (9,'sql*2.0.8*0*2.0.8/nestedgroups.sql','Database upgrade to version 2.0.8: Nestedgroups','2005-08-02 16:02:06',1,'upgrade*2.0.8*0*upgrade2.0.8'), (10,'sql*2.0.8*0*2.0.8/help_replacement.sql','Database upgrade to version 2.0.8: Help replacement','2005-08-02 16:02:06',1,'upgrade*2.0.8*0*upgrade2.0.8'), (11,'upgrade*2.0.8*0*upgrade2.0.8','Upgrade from version 2.0.7 to 2.0.8','2005-08-02 16:02:06',1,'upgrade*2.0.8*0*upgrade2.0.8'), (12,'sql*2.0.8*0*2.0.8/permissions.sql','Database upgrade to version 2.0.8: Permissions','2005-08-02 16:02:07',1,'upgrade*2.0.8*0*upgrade2.0.8'), (13,'func*2.0.8*1*setPermissionObject','Set the permission object in charge of a document or folder','2005-08-02 16:02:07',1,'upgrade*2.0.8*0*upgrade2.0.8'), (14,'sql*2.0.8*1*2.0.8/1-metadata_versions.sql','Database upgrade to version 2.0.8: Metadata versions','2005-08-02 16:02:07',1,'upgrade*2.0.8*0*upgrade2.0.8'), (15,'sql*2.0.8*2*2.0.8/2-permissions.sql','Database upgrade to version 2.0.8: Permissions','2005-08-02 16:02:07',1,'upgrade*2.0.8*0*upgrade2.0.8'), (16,'sql*2.0.9*0*2.0.9/storagemanager.sql','','0000-00-00 00:00:00',1,NULL), (17,'sql*2.0.9*0*2.0.9/metadata_tree.sql','','0000-00-00 00:00:00',1,NULL), (18,'sql*2.0.9*0*2.0.9/document_incomplete.sql','','0000-00-00 00:00:00',1,NULL), (20,'upgrade*2.99.1*0*upgrade2.99.1','Upgrade from version 2.0.8 to 2.99.1','2005-10-07 14:26:15',1,'upgrade*2.99.1*0*upgrade2.99.1'), (21,'sql*2.99.1*0*2.99.1/workflow.sql','Database upgrade to version 2.99.1: Workflow','2005-10-07 14:26:15',1,'upgrade*2.99.1*0*upgrade2.99.1'), (22,'sql*2.99.1*0*2.99.1/fieldsets.sql','Database upgrade to version 2.99.1: Fieldsets','2005-10-07 14:26:16',1,'upgrade*2.99.1*0*upgrade2.99.1'), (23,'func*2.99.1*1*createFieldSets','Create a fieldset for each field without one','2005-10-07 14:26:16',1,'upgrade*2.99.1*0*upgrade2.99.1'), (24,'sql*2.99.2*0*2.99.2/saved_searches.sql','','0000-00-00 00:00:00',1,NULL), (25,'sql*2.99.2*0*2.99.2/transactions.sql','','0000-00-00 00:00:00',1,NULL), (26,'sql*2.99.2*0*2.99.2/field_mandatory.sql','','0000-00-00 00:00:00',1,NULL), (27,'sql*2.99.2*0*2.99.2/fieldsets_system.sql','','0000-00-00 00:00:00',1,NULL), (28,'sql*2.99.2*0*2.99.2/permission_by_user_and_roles.sql','','0000-00-00 00:00:00',1,NULL), (29,'sql*2.99.2*0*2.99.2/disabled_metadata.sql','','0000-00-00 00:00:00',1,NULL), (30,'sql*2.99.2*0*2.99.2/searchable_text.sql','','0000-00-00 00:00:00',1,NULL), (31,'sql*2.99.2*0*2.99.2/workflow.sql','','0000-00-00 00:00:00',1,NULL), (32,'sql*2.99.2*1*2.99.2/1-constraints.sql','','0000-00-00 00:00:00',1,NULL), (33,'sql*2.99.3*0*2.99.3/notifications.sql','','0000-00-00 00:00:00',1,NULL), (34,'sql*2.99.3*0*2.99.3/last_modified_user.sql','','0000-00-00 00:00:00',1,NULL), (35,'sql*2.99.3*0*2.99.3/authentication_sources.sql','','0000-00-00 00:00:00',1,NULL), (36,'sql*2.99.3*0*2.99.3/document_fields_constraints.sql','','0000-00-00 00:00:00',1,NULL), (37,'sql*2.99.5*0*2.99.5/dashlet_disabling.sql','','0000-00-00 00:00:00',1,NULL), (38,'sql*2.99.5*0*2.99.5/role_allocations.sql','','0000-00-00 00:00:00',1,NULL), (39,'sql*2.99.5*0*2.99.5/transaction_namespaces.sql','','0000-00-00 00:00:00',1,NULL), (40,'sql*2.99.5*0*2.99.5/fieldset_field_descriptions.sql','','0000-00-00 00:00:00',1,NULL), (41,'sql*2.99.5*0*2.99.5/role_changes.sql','','0000-00-00 00:00:00',1,NULL), (42,'sql*2.99.6*0*2.99.6/table_cleanup.sql','Database upgrade to version 2.99.6: Table cleanup','2006-01-20 17:04:05',1,'upgrade*2.99.7*99*upgrade2.99.7'), (43,'sql*2.99.6*0*2.99.6/plugin-registration.sql','Database upgrade to version 2.99.6: Plugin-registration','2006-01-20 17:04:05',1,'upgrade*2.99.7*99*upgrade2.99.7'), (44,'sql*2.99.7*0*2.99.7/documents_normalisation.sql','Database upgrade to version 2.99.7: Documents normalisation','2006-01-20 17:04:05',1,'upgrade*2.99.7*99*upgrade2.99.7'), (45,'sql*2.99.7*0*2.99.7/help_replacement.sql','Database upgrade to version 2.99.7: Help replacement','2006-01-20 17:04:05',1,'upgrade*2.99.7*99*upgrade2.99.7'), (46,'sql*2.99.7*0*2.99.7/table_cleanup.sql','Database upgrade to version 2.99.7: Table cleanup','2006-01-20 17:04:07',1,'upgrade*2.99.7*99*upgrade2.99.7'), (47,'func*2.99.7*1*normaliseDocuments','Normalise the documents table','2006-01-20 17:04:07',1,'upgrade*2.99.7*99*upgrade2.99.7'), (48,'sql*2.99.7*10*2.99.7/10-documents_normalisation.sql','Database upgrade to version 2.99.7: Documents normalisation','2006-01-20 17:04:07',1,'upgrade*2.99.7*99*upgrade2.99.7'), (49,'sql*2.99.7*20*2.99.7/20-fields.sql','Database upgrade to version 2.99.7: Fields','2006-01-20 17:04:07',1,'upgrade*2.99.7*99*upgrade2.99.7'), (50,'upgrade*2.99.7*99*upgrade2.99.7','Upgrade from version 2.99.5 to 2.99.7','2006-01-20 17:04:07',1,'upgrade*2.99.7*99*upgrade2.99.7'), (51,'sql*2.99.7*0*2.99.7/discussion.sql','','0000-00-00 00:00:00',1,NULL), (52,'func*2.99.7*-1*applyDiscussionUpgrade','func upgrade to version 2.99.7 phase -1','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (53,'sql*2.99.8*0*2.99.8/mime_types.sql','Database upgrade to version 2.99.8: Mime types','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (54,'sql*2.99.8*0*2.99.8/category-correction.sql','Database upgrade to version 2.99.8: Category-correction','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (55,'sql*2.99.8*0*2.99.8/trigger_selection.sql','Database upgrade to version 2.99.8: Trigger selection','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (56,'sql*2.99.8*0*2.99.8/units.sql','Database upgrade to version 2.99.8: Units','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (57,'sql*2.99.8*0*2.99.8/type_workflow_map.sql','Database upgrade to version 2.99.8: Type workflow map','2006-02-06 12:23:41',1,'upgrade*2.99.8*99*upgrade2.99.8'), (58,'sql*2.99.8*0*2.99.8/disabled_documenttypes.sql','Database upgrade to version 2.99.8: Disabled documenttypes','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (59,'func*2.99.8*1*fixUnits','func upgrade to version 2.99.8 phase 1','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (60,'sql*2.99.8*10*2.99.8/10-units.sql','Database upgrade to version 2.99.8: Units','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (61,'sql*2.99.8*15*2.99.8/15-status.sql','Database upgrade to version 2.99.8: Status','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (62,'sql*2.99.8*20*2.99.8/20-state_permission_assignments.sql','Database upgrade to version 2.99.8: State permission assignments','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (63,'sql*2.99.8*25*2.99.8/25-authentication_details.sql','Database upgrade to version 2.99.8: Authentication details','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (64,'upgrade*2.99.8*99*upgrade2.99.8','Upgrade from version 2.99.7 to 2.99.8','2006-02-06 12:23:42',1,'upgrade*2.99.8*99*upgrade2.99.8'), (65,'func*2.99.9*0*createSecurityDeletePermissions','Create the Core: Manage Security and Core: Delete permissions','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (66,'func*2.99.9*0*createLdapAuthenticationProvider','Create an LDAP authentication source based on your KT2 LDAP settings (must keep copy of config/environment.php to work)','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (67,'sql*2.99.9*0*2.99.9/mimetype-friendly.sql','Database upgrade to version 2.99.9: Mimetype-friendly','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (68,'sql*2.99.9*5*2.99.9/5-opendocument-mime-types.sql','Database upgrade to version 2.99.9: Opendocument-mime-types','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (69,'sql*3.0*0*3.0/zipfile-mimetype.sql','Database upgrade to version 3.0: Zipfile-mimetype','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (70,'upgrade*3.0*99*upgrade3.0','Upgrade from version 2.99.8 to 3.0','2006-02-28 09:23:21',1,'upgrade*3.0*99*upgrade3.0'), (71,'sql*3.0.1.1*0*3.0.1.1/document_role_allocations.sql','Database upgrade to version 3.0.1.1: Document role allocations','2006-03-28 11:22:19',1,'upgrade*3.0.1.1*99*upgrade3.0.1.1'), (72,'upgrade*3.0.1.1*99*upgrade3.0.1.1','Upgrade from version 3.0 to 3.0.1.1','2006-03-28 11:22:19',1,'upgrade*3.0.1.1*99*upgrade3.0.1.1'), (73,'sql*3.0.1.2*0*3.0.1.2/user_more_authentication_details.sql','Database upgrade to version 3.0.1.2: User more authentication details','2006-04-07 16:50:28',1,'upgrade*3.0.1.2*99*upgrade3.0.1.2'), (74,'upgrade*3.0.1.2*99*upgrade3.0.1.2','Upgrade from version 3.0.1.1 to 3.0.1.2','2006-04-07 16:50:28',1,'upgrade*3.0.1.2*99*upgrade3.0.1.2'), (75,'sql*3.0.1.2*0*3.0.1.2/owner_role_move.sql','Database upgrade to version 3.0.1.2: Owner role move','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (76,'func*3.0.1.3*0*addTransactionTypes3013','Add new folder transaction types','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (77,'sql*3.0.1.3*0*3.0.1.3/user_history.sql','Database upgrade to version 3.0.1.3: User history','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (78,'sql*3.0.1.3*0*3.0.1.3/folder_transactions.sql','Database upgrade to version 3.0.1.3: Folder transactions','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (79,'sql*3.0.1.3*0*3.0.1.3/plugin-unavailable.sql','Database upgrade to version 3.0.1.3: Plugin-unavailable','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (80,'func*3.0.1.4*0*createWorkflowPermission','Create the Core: Manage Workflow','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (81,'upgrade*3.0.1.4*99*upgrade3.0.1.4','Upgrade from version 3.0.1.2 to 3.0.1.4','2006-04-18 11:06:34',1,'upgrade*3.0.1.4*99*upgrade3.0.1.4'), (82,'sql*3.0.1.5*0*3.0.1.5/anonymous-user.sql','Database upgrade to version 3.0.1.5: Anonymous-user','2006-04-18 12:38:41',1,'upgrade*3.0.1.5*99*upgrade3.0.1.5'), (83,'upgrade*3.0.1.5*99*upgrade3.0.1.5','Upgrade from version 3.0.1.4 to 3.0.1.5','2006-04-18 12:38:41',1,'upgrade*3.0.1.5*99*upgrade3.0.1.5'), (84,'sql*3.0.1.6*0*3.0.1.6/workflow-into-metadata.sql','Database upgrade to version 3.0.1.6: Workflow-into-metadata','2006-04-20 14:22:24',1,'upgrade*3.0.1.6*99*upgrade3.0.1.6'), (85,'upgrade*3.0.1.6*99*upgrade3.0.1.6','Upgrade from version 3.0.1.5 to 3.0.1.6','2006-04-20 14:22:24',1,'upgrade*3.0.1.6*99*upgrade3.0.1.6'), (86,'sql*3.0.1.7*0*3.0.1.7/session_id.sql','Database upgrade to version 3.0.1.7: Session id','2006-04-20 17:03:55',1,'upgrade*3.0.1.7*99*upgrade3.0.1.7'), (87,'upgrade*3.0.1.7*99*upgrade3.0.1.7','Upgrade from version 3.0.1.6 to 3.0.1.7','2006-04-20 17:03:56',1,'upgrade*3.0.1.7*99*upgrade3.0.1.7'), (88,'sql*3.0.1.8*0*3.0.1.8/friendly-plugins.sql','Database upgrade to version 3.0.1.8: Friendly-plugins','2006-04-23 12:54:12',1,'upgrade*3.0.1.8*99*upgrade3.0.1.8'), (89,'sql*3.0.1.8*0*3.0.1.8/longer-text.sql','Database upgrade to version 3.0.1.8: Longer-text','2006-04-23 12:54:12',1,'upgrade*3.0.1.8*99*upgrade3.0.1.8'), (90,'sql*3.0.1.8*0*3.0.1.8/admin-mode-logging.sql','Database upgrade to version 3.0.1.8: Admin-mode-logging','2006-04-23 12:54:12',1,'upgrade*3.0.1.8*99*upgrade3.0.1.8'), (91,'upgrade*3.0.1.8*99*upgrade3.0.1.8','Upgrade from version 3.0.1.7 to 3.0.1.8','2006-04-23 12:54:12',1,'upgrade*3.0.1.8*99*upgrade3.0.1.8'), (92,'upgrade*3.0.2*99*upgrade3.0.2','Upgrade from version 3.0.1.8 to 3.0.2','2006-05-02 10:08:13',1,'upgrade*3.0.2*99*upgrade3.0.2'), (93,'sql*3.0.2.1*0*3.0.2.1/disclaimer-help-files.sql','Database upgrade to version 3.0.2.1: Disclaimer-help-files','2006-05-25 16:04:23',1,'upgrade*3.0.2.2*99*upgrade3.0.2.2'), (94,'sql*3.0.2.2*0*3.0.2.2/folder_search.sql','Database upgrade to version 3.0.2.2: Folder search','2006-05-25 16:04:23',1,'upgrade*3.0.2.2*99*upgrade3.0.2.2'), (95,'upgrade*3.0.2.2*99*upgrade3.0.2.2','Upgrade from version 3.0.2 to 3.0.2.2','2006-05-25 16:04:24',1,'upgrade*3.0.2.2*99*upgrade3.0.2.2'), (96,'sql*3.0.2.3*0*3.0.2.3/msi-filetype.sql','Database upgrade to version 3.0.2.3: Msi-filetype','2006-05-30 10:55:58',1,'upgrade*3.0.2.4*99*upgrade3.0.2.4'), (97,'sql*3.0.2.4*0*3.0.2.4/discussion-fulltext.sql','Database upgrade to version 3.0.2.4: Discussion-fulltext','2006-05-30 10:55:59',1,'upgrade*3.0.2.4*99*upgrade3.0.2.4'), (98,'upgrade*3.0.2.4*99*upgrade3.0.2.4','Upgrade from version 3.0.2.2 to 3.0.2.4','2006-05-30 10:55:59',1,'upgrade*3.0.2.4*99*upgrade3.0.2.4'), (99,'upgrade*3.0.3*99*upgrade3.0.3','Upgrade from version 3.0.2.4 to 3.0.3','2006-05-31 13:02:04',1,'upgrade*3.0.3*99*upgrade3.0.3'), (100,'sql*3.0.3.1*0*3.0.3.1/utf8.sql','Database upgrade to version 3.0.3.1: Utf8','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (101,'sql*3.0.3.1*0*3.0.3.1/document_immutable.sql','Database upgrade to version 3.0.3.1: Document immutable','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (102,'sql*3.0.3.1*0*3.0.3.1/workflow-triggers.sql','Database upgrade to version 3.0.3.1: Workflow-triggers','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (103,'func*3.0.3.2*0*createFolderDetailsPermission','Create the Core: Folder Details permission','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (104,'func*3.0.3.3*0*generateWorkflowTriggers','Migrate old in-transition guards to triggers','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (105,'sql*3.0.3.4*0*3.0.3.4/column_entries.sql','Database upgrade to version 3.0.3.4: Column entries','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (106,'sql*3.0.3.4*0*3.0.3.4/bulk_export_transaction.sql','Database upgrade to version 3.0.3.4: Bulk export transaction','2006-07-12 12:00:33',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (107,'upgrade*3.0.3.4*99*upgrade3.0.3.4','Upgrade from version 3.0.3 to 3.0.3.4','2006-07-12 12:00:34',1,'upgrade*3.0.3.4*99*upgrade3.0.3.4'), (108,'sql*3.0.3.5*0*3.0.3.5/notifications_data_text.sql','Database upgrade to version 3.0.3.5: Notifications data text','2006-07-14 15:26:49',1,'upgrade*3.0.3.5*99*upgrade3.0.3.5'), (109,'upgrade*3.0.3.5*99*upgrade3.0.3.5','Upgrade from version 3.0.3.4 to 3.0.3.5','2006-07-14 15:26:49',1,'upgrade*3.0.3.5*99*upgrade3.0.3.5'), (110,'sql*3.0.3.6*0*3.0.3.6/document-restore.sql','Database upgrade to version 3.0.3.6: Document-restore','2006-07-26 11:48:28',1,'upgrade*3.0.3.7*99*upgrade3.0.3.7'), (111,'func*3.0.3.7*0*rebuildAllPermissions','Rebuild all permissions to ensure correct functioning of permission-definitions.','2006-07-26 11:48:28',1,'upgrade*3.0.3.7*99*upgrade3.0.3.7'), (112,'upgrade*3.0.3.7*99*upgrade3.0.3.7','Upgrade from version 3.0.3.5 to 3.0.3.7','2006-07-26 11:48:28',1,'upgrade*3.0.3.7*99*upgrade3.0.3.7'), (113,'upgrade*3.1*99*upgrade3.1','Upgrade from version 3.0.3.7 to 3.1','2006-07-31 10:41:12',1,'upgrade*3.1*99*upgrade3.1'), (114,'sql*3.1.1*0*3.1.1/parentless-documents.sql','Database upgrade to version 3.1.1: Parentless-documents','2006-08-15 11:58:07',1,'upgrade*3.1.1*99*upgrade3.1.1'), (115,'upgrade*3.1.1*99*upgrade3.1.1','Upgrade from version 3.1 to 3.1.1','2006-08-15 11:58:07',1,'upgrade*3.1.1*99*upgrade3.1.1'), (116,'sql*3.1.2*0*3.1.2/user-disable.sql','Database upgrade to version 3.1.2: User-disable','2006-09-08 17:08:26',1,'upgrade*3.1.2*99*upgrade3.1.2'), (117,'upgrade*3.1.2*99*upgrade3.1.2','Upgrade from version 3.1.1 to 3.1.2','2006-09-08 17:08:26',1,'upgrade*3.1.2*99*upgrade3.1.2'), (118,'func*3.1.5*0*upgradeSavedSearches','Upgrade saved searches to use namespaces instead of integer ids','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (119,'sql*3.1.6*0*3.1.6/interceptor_instances.sql','Database upgrade to version 3.1.6: Interceptor instances','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (120,'sql*3.1.6*0*3.1.6/workflow-sanity.sql','Database upgrade to version 3.1.6: Workflow-sanity','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (121,'sql*3.1.6.2*0*3.1.6.2/workflow_state_disabled_actions.sql','Database upgrade to version 3.1.6.2: Workflow state disabled actions','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (122,'sql*3.1.6.2*0*3.1.6.2/folder_owner_role.sql','Database upgrade to version 3.1.6.2: Folder owner role','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (123,'func*3.1.6.3*0*cleanupGroupMembership','Cleanup any old references to missing groups, etc.','2006-10-17 12:09:45',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (124,'sql*3.1.6.3*0*3.1.6.3/groups-integrity.sql','Database upgrade to version 3.1.6.3: Groups-integrity','2006-10-17 12:09:46',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (125,'sql*3.1.6.5*0*3.1.6.5/workflow-state-referencefixes.sql','Database upgrade to version 3.1.6.5: Workflow-state-referencefixes','2006-10-17 12:09:46',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (126,'sql*3.1.6.6*0*3.1.6.6/copy_transaction.sql','Database upgrade to version 3.1.6.6: Copy transaction','2006-10-17 12:09:46',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (127,'sql*3.1.6.7*0*3.1.6.7/sane-names-for-stuff.sql','Database upgrade to version 3.1.6.7: Sane-names-for-stuff','2006-10-17 12:09:46',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (128,'upgrade*3.1.6.7*99*upgrade3.1.6.7','Upgrade from version 3.1.2 to 3.1.6.7','2006-10-17 12:09:46',1,'upgrade*3.1.6.7*99*upgrade3.1.6.7'), (129,'sql*3.3.0.1*0*3.3.0.1/system-settings-to-text.sql','Database upgrade to version 3.3.0.1: System-settings-to-text','2007-01-28 23:49:52',1,'upgrade*3.3.1*99*upgrade3.3.1'), (130,'upgrade*3.3.0.1*99*upgrade3.3.0.1','Upgrade from version 3.1.6.7 to 3.3.0.1','2006-10-30 12:49:33',1,'upgrade*3.3.0.1*99*upgrade3.3.0.1'), (131,'sql*3.3.1*0*3.3.1/rss.sql','Database upgrade to version 3.3.1: Rss','2007-01-28 23:49:52',1,'upgrade*3.3.1*99*upgrade3.3.1'), (132,'upgrade*3.3.1*99*upgrade3.3.1','Upgrade from version 3.3.0.1 to 3.3.1','2007-01-28 23:49:52',1,'upgrade*3.3.1*99*upgrade3.3.1'), (133,'sql*3.3.2*0*3.3.2/tagclouds.sql','Database upgrade to version 3.3.2: Tagclouds','2007-02-23 11:55:09',1,'upgrade*3.3.2*99*upgrade3.3.2'), (134,'upgrade*3.3.2*99*upgrade3.3.2','Upgrade from version 3.3.1 to 3.3.2','2007-02-23 11:55:09',1,'upgrade*3.3.2*99*upgrade3.3.2'), (135,'sql*3.4.0*0*3.4.0/upload_download.sql','Upgrade to version 3.4.0: Upload download','2007-04-17 00:00:00',1,'upgrade*3.4.0*99*upgrade3.4.0'), (136,'upgrade*3.4.0*99*upgrade3.4.0','Upgrade from version 3.3.2 to 3.4.0','2007-04-17 00:00:00',1,'upgrade*3.4.0*99*upgrade3.4.0'), (137,'sql*3.4.5*0*3.4.5/plugin_helper.sql','Create the plugin helper table.','2007-11-20 00:00:00',1,'upgrade*3.4.5*99*upgrade3.4.5'), (138,'upgrade*3.4.5*99*upgrade3.4.5','Upgrade from version 3.4.0 to 3.4.5','2007-11-20 00:00:00',1,'upgrade*3.4.5*99*upgrade3.4.5'), (139,'sql*3.4.6*0*3.4.6/remove_backslashes.sql','Remove backslashes.','2007-11-20 00:00:00',1,'upgrade*3.4.6*99*upgrade3.4.6'), (140,'upgrade*3.4.6*99*upgrade3.4.6','Upgrade from version 3.4.5 to 3.4.6','2007-11-20 00:00:00',1,'upgrade*3.4.6*99*upgrade3.4.6'), (141,'sql*3.5.0*0*3.5.0/admin_version_path_update.sql','Update Admin Version Plugin Path','2007-08-28 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (142,'sql*3.5.0*0*3.5.0/saved_searches.sql','Database upgrade to version 3.5.0: Saved searches','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (143,'sql*3.5.0*0*3.5.0/index_files.sql','Database upgrade to version 3.5.0: Index files','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (144,'sql*3.5.0*0*3.5.0/search_ranking.sql','Database upgrade to version 3.5.0: Search ranking','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (145,'sql*3.5.0*0*3.5.0/document_checkout.sql','Database upgrade to version 3.5.0: Document checkout','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (146,'func*3.5.0*0*cleanupOldKTAdminVersionNotifier','Cleanup any old files from the old KTAdminVersionNotifier','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (147,'upgrade*3.5.0*99*upgrade3.5.0','Upgrade from version 3.4.0 to 3.5.0','2007-09-25 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (148,'sql*3.5.0*0*3.5.0/folder_descendants.sql','Database upgrade to version 3.5.0: Folder descendants','2007-10-11 17:41:32',1,'upgrade*3.5.0*99*upgrade3.5.0'), (149,'sql*3.5.0*0*3.5.0/relation_friendly.sql','Database upgrade to version 3.5.0: Relation friendly','2007-10-11 17:41:33',1,'upgrade*3.5.0*99*upgrade3.5.0'), (150,'sql*3.5.0*0*3.5.0/plugin_rss_engine.sql','Database upgrade to version 3.5.0: Plugin rss engine','2007-10-11 17:41:33',1,'upgrade*3.5.0*99*upgrade3.5.0'), (151,'sql*3.5.0*0*3.5.0/document_transaction_type.sql','Database upgrade to version 3.5.0: Document transaction type','2007-10-11 17:41:33',1,'upgrade*3.5.0*99*upgrade3.5.0'), (152,'sql*3.5.0*0*3.5.0/scheduler_tables.sql','Database upgrade to version 3.5.0: Scheduler tables','2007-10-23 15:40:56',1,'upgrade*3.5.0*99*upgrade3.5.0'), (153,'func*3.5.0*0*registerIndexingTasks','Register the required indexing background tasks','2007-10-23 15:40:56',1,'upgrade*3.5.0*99*upgrade3.5.0'), (154,'func*3.5.0*0*updateConfigFile35','Update the config.ini file for 3.5','2007-10-23 15:40:56',1,'upgrade*3.5.0*99*upgrade3.5.0'), (155,'sql*3.5.0*0*3.5.0/mime_types.sql','Database upgrade to version 3.5.0: Mime types','2007-10-23 15:40:58',1,'upgrade*3.5.0*99*upgrade3.5.0'), (156,'upgrade*3.5.0*99*upgrade3.5.0','Upgrade from version 3.4.5 to 3.5.0','2007-11-21 00:00:00',1,'upgrade*3.5.0*99*upgrade3.5.0'), (157,'sql*3.5.1*0*3.5.1/indexing_tasks_registration.sql','Register indexing tasks with the scheduler.','2007-11-21 00:00:00',1,'upgrade*3.5.1*99*upgrade3.5.1'), (158,'sql*3.5.1*0*3.5.1/png_mime_type.sql','Register PNG mimetype.','2007-11-21 00:00:00',1,'upgrade*3.5.1*99*upgrade3.5.1'), (159,'upgrade*3.5.1*99*upgrade3.5.1','Upgrade from version 3.5.0 to 3.5.1','2007-11-21 00:00:00',1,'upgrade*3.5.1*99*upgrade3.5.1'), (160,'sql*3.5.2*0*3.5.2/document_transactions.sql','Updates document_transactions table. Changes chars to varchars.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (161,'sql*3.5.2*0*3.5.2/metadata_length.sql','Updates metadata length. Changes chars to varchars.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (162,'sql*3.5.2*0*3.5.2/scheduler_tasks.sql','Initialise some scheduler tasks.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (163,'sql*3.5.2*0*3.5.2/csv_mime.sql','Update mime types for CSV files.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (164,'func*3.5.2*1*setStorageEngine','Recreate db integrity: Set storage engine to InnoDB for transaction safety','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (165,'func*3.5.2*2*dropForeignKeys','Recreate db integrity: Drop foreign keys on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (166,'func*3.5.2*3*dropPrimaryKeys','Recreate db integrity:Drop primary keys on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (167,'func*3.5.2*4*dropIndexes','Recreate db integrity:Drop indexes on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (168,'func*3.5.2*5*createPrimaryKeys','Recreate db integrity:Create primary keys on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (169,'func*3.5.2*6*createForeignKeys','Recreate db integrity:Create foreign keys on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (170,'func*3.5.2*7*createIndexes','Recreate db integrity:Create indexes on the database','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (171,'func*3.5.2*0*removeSlashesFromObjects','Remove slashes from documents and folders','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (172,'sql*3.5.2*0*3.5.2/plugins_orderby.sql','Plugins orderby update','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (173,'sql*3.5.2*0*3.5.2/oem_no.sql','Database upgrade to version 3.5.2: Oem no','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (174,'sql*3.5.2*0*3.5.2/document_link.sql','Document Link update','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (175,'sql*3.5.2*0*3.5.2/index_file_status_message.sql','Index file status message update','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (176,'sql*3.5.2*0*3.5.2/clean_plugin_helper.sql','Clean out the plugin helper table.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (177,'sql*3.5.2*0*3.5.2/openxml_mime_types.sql','Add the OpenXML mimetypes.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (178,'sql*3.5.2*0*3.5.2/rss_plugin_title.sql','Increase size of RSS Title.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (179,'sql*3.5.2*0*3.5.2/temp_cleanup.sql','Adds background script to clean up temporary index files.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (180,'sql*3.5.2*0*3.5.2/scheduler_permissions.sql','Update scheduler permissions..','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (181,'sql*3.5.2*0*3.5.2/mime_type_update.sql','Update MIME types.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (182,'sql*3.5.2*0*3.5.2/zdashboard_tasks.sql','Update Dashboard tasks.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (183,'sql*3.5.2*0*3.5.2/zdashboard_tasks2.sql','Update more Dashboard tasks.','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'), (184,'upgrade*3.5.2*99*upgrade3.5.2','Upgrade from version 3.5.1 to 3.5.2','2007-11-21 00:00:00',1,'upgrade*3.5.2*99*upgrade3.5.2'); /*!40000 ALTER TABLE `upgrades` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `uploaded_files` -- LOCK TABLES `uploaded_files` WRITE; /*!40000 ALTER TABLE `uploaded_files` DISABLE KEYS */; /*!40000 ALTER TABLE `uploaded_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `user_history` -- LOCK TABLES `user_history` WRITE; /*!40000 ALTER TABLE `user_history` DISABLE KEYS */; /*!40000 ALTER TABLE `user_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (-2,'anonymous','Anonymous','---------------',0,0,NULL,NULL,0,0,NULL,30000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0), (1,'admin','Administrator','21232f297a57a5a743894a0e4a801fc3',0,0,'','',1,1,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `users_groups_link` -- LOCK TABLES `users_groups_link` WRITE; /*!40000 ALTER TABLE `users_groups_link` DISABLE KEYS */; INSERT INTO `users_groups_link` VALUES (1,1,1); /*!40000 ALTER TABLE `users_groups_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_actions` -- LOCK TABLES `workflow_actions` WRITE; /*!40000 ALTER TABLE `workflow_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_documents` -- LOCK TABLES `workflow_documents` WRITE; /*!40000 ALTER TABLE `workflow_documents` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_state_actions` -- LOCK TABLES `workflow_state_actions` WRITE; /*!40000 ALTER TABLE `workflow_state_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_state_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_state_disabled_actions` -- LOCK TABLES `workflow_state_disabled_actions` WRITE; /*!40000 ALTER TABLE `workflow_state_disabled_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_state_disabled_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_state_permission_assignments` -- LOCK TABLES `workflow_state_permission_assignments` WRITE; /*!40000 ALTER TABLE `workflow_state_permission_assignments` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_state_permission_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_state_transitions` -- LOCK TABLES `workflow_state_transitions` WRITE; /*!40000 ALTER TABLE `workflow_state_transitions` DISABLE KEYS */; INSERT INTO `workflow_state_transitions` VALUES (2,2), (3,3), (3,4), (5,5), (6,6); /*!40000 ALTER TABLE `workflow_state_transitions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_states` -- LOCK TABLES `workflow_states` WRITE; /*!40000 ALTER TABLE `workflow_states` DISABLE KEYS */; INSERT INTO `workflow_states` VALUES (2,2,'Draft','Draft',NULL,0,0), (3,2,'Approval','Approval',NULL,0,0), (4,2,'Published','Published',NULL,0,0), (5,3,'Draft','Draft',NULL,0,0), (6,3,'Final','Final',NULL,0,0), (7,3,'Published','Published',NULL,0,0); /*!40000 ALTER TABLE `workflow_states` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_transitions` -- LOCK TABLES `workflow_transitions` WRITE; /*!40000 ALTER TABLE `workflow_transitions` DISABLE KEYS */; INSERT INTO `workflow_transitions` VALUES (2,2,'Request Approval','Request Approval',3,NULL,NULL,NULL,NULL), (3,2,'Reject','Reject',2,NULL,NULL,NULL,NULL), (4,2,'Approve','Approve',4,NULL,NULL,NULL,NULL), (5,3,'Draft Completed','Draft Completed',6,NULL,NULL,NULL,NULL), (6,3,'Publish','Publish',7,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `workflow_transitions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflow_trigger_instances` -- LOCK TABLES `workflow_trigger_instances` WRITE; /*!40000 ALTER TABLE `workflow_trigger_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_trigger_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `workflows` -- LOCK TABLES `workflows` WRITE; /*!40000 ALTER TABLE `workflows` DISABLE KEYS */; INSERT INTO `workflows` VALUES (2,'Review Process','Review Process',2,1), (3,'Generate Document','Generate Document',5,1); /*!40000 ALTER TABLE `workflows` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_active_sessions` -- LOCK TABLES `zseq_active_sessions` WRITE; /*!40000 ALTER TABLE `zseq_active_sessions` DISABLE KEYS */; INSERT INTO `zseq_active_sessions` VALUES (1); /*!40000 ALTER TABLE `zseq_active_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_archive_restoration_request` -- LOCK TABLES `zseq_archive_restoration_request` WRITE; /*!40000 ALTER TABLE `zseq_archive_restoration_request` DISABLE KEYS */; INSERT INTO `zseq_archive_restoration_request` VALUES (1); /*!40000 ALTER TABLE `zseq_archive_restoration_request` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_archiving_settings` -- LOCK TABLES `zseq_archiving_settings` WRITE; /*!40000 ALTER TABLE `zseq_archiving_settings` DISABLE KEYS */; INSERT INTO `zseq_archiving_settings` VALUES (1); /*!40000 ALTER TABLE `zseq_archiving_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_archiving_type_lookup` -- LOCK TABLES `zseq_archiving_type_lookup` WRITE; /*!40000 ALTER TABLE `zseq_archiving_type_lookup` DISABLE KEYS */; INSERT INTO `zseq_archiving_type_lookup` VALUES (2); /*!40000 ALTER TABLE `zseq_archiving_type_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_authentication_sources` -- LOCK TABLES `zseq_authentication_sources` WRITE; /*!40000 ALTER TABLE `zseq_authentication_sources` DISABLE KEYS */; INSERT INTO `zseq_authentication_sources` VALUES (1); /*!40000 ALTER TABLE `zseq_authentication_sources` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_column_entries` -- LOCK TABLES `zseq_column_entries` WRITE; /*!40000 ALTER TABLE `zseq_column_entries` DISABLE KEYS */; INSERT INTO `zseq_column_entries` VALUES (14); /*!40000 ALTER TABLE `zseq_column_entries` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_config_settings` -- LOCK TABLES `zseq_config_settings` WRITE; /*!40000 ALTER TABLE `zseq_config_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_config_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_dashlet_disables` -- LOCK TABLES `zseq_dashlet_disables` WRITE; /*!40000 ALTER TABLE `zseq_dashlet_disables` DISABLE KEYS */; INSERT INTO `zseq_dashlet_disables` VALUES (1); /*!40000 ALTER TABLE `zseq_dashlet_disables` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_data_types` -- LOCK TABLES `zseq_data_types` WRITE; /*!40000 ALTER TABLE `zseq_data_types` DISABLE KEYS */; INSERT INTO `zseq_data_types` VALUES (5); /*!40000 ALTER TABLE `zseq_data_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_discussion_comments` -- LOCK TABLES `zseq_discussion_comments` WRITE; /*!40000 ALTER TABLE `zseq_discussion_comments` DISABLE KEYS */; INSERT INTO `zseq_discussion_comments` VALUES (1); /*!40000 ALTER TABLE `zseq_discussion_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_discussion_threads` -- LOCK TABLES `zseq_discussion_threads` WRITE; /*!40000 ALTER TABLE `zseq_discussion_threads` DISABLE KEYS */; INSERT INTO `zseq_discussion_threads` VALUES (1); /*!40000 ALTER TABLE `zseq_discussion_threads` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_archiving_link` -- LOCK TABLES `zseq_document_archiving_link` WRITE; /*!40000 ALTER TABLE `zseq_document_archiving_link` DISABLE KEYS */; INSERT INTO `zseq_document_archiving_link` VALUES (1); /*!40000 ALTER TABLE `zseq_document_archiving_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_content_version` -- LOCK TABLES `zseq_document_content_version` WRITE; /*!40000 ALTER TABLE `zseq_document_content_version` DISABLE KEYS */; INSERT INTO `zseq_document_content_version` VALUES (1); /*!40000 ALTER TABLE `zseq_document_content_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_fields` -- LOCK TABLES `zseq_document_fields` WRITE; /*!40000 ALTER TABLE `zseq_document_fields` DISABLE KEYS */; INSERT INTO `zseq_document_fields` VALUES (5); /*!40000 ALTER TABLE `zseq_document_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_fields_link` -- LOCK TABLES `zseq_document_fields_link` WRITE; /*!40000 ALTER TABLE `zseq_document_fields_link` DISABLE KEYS */; INSERT INTO `zseq_document_fields_link` VALUES (1); /*!40000 ALTER TABLE `zseq_document_fields_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_link` -- LOCK TABLES `zseq_document_link` WRITE; /*!40000 ALTER TABLE `zseq_document_link` DISABLE KEYS */; INSERT INTO `zseq_document_link` VALUES (1); /*!40000 ALTER TABLE `zseq_document_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_link_types` -- LOCK TABLES `zseq_document_link_types` WRITE; /*!40000 ALTER TABLE `zseq_document_link_types` DISABLE KEYS */; INSERT INTO `zseq_document_link_types` VALUES (5); /*!40000 ALTER TABLE `zseq_document_link_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_metadata_version` -- LOCK TABLES `zseq_document_metadata_version` WRITE; /*!40000 ALTER TABLE `zseq_document_metadata_version` DISABLE KEYS */; INSERT INTO `zseq_document_metadata_version` VALUES (1); /*!40000 ALTER TABLE `zseq_document_metadata_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_role_allocations` -- LOCK TABLES `zseq_document_role_allocations` WRITE; /*!40000 ALTER TABLE `zseq_document_role_allocations` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_document_role_allocations` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_subscriptions` -- LOCK TABLES `zseq_document_subscriptions` WRITE; /*!40000 ALTER TABLE `zseq_document_subscriptions` DISABLE KEYS */; INSERT INTO `zseq_document_subscriptions` VALUES (1); /*!40000 ALTER TABLE `zseq_document_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_tags` -- LOCK TABLES `zseq_document_tags` WRITE; /*!40000 ALTER TABLE `zseq_document_tags` DISABLE KEYS */; INSERT INTO `zseq_document_tags` VALUES (1); /*!40000 ALTER TABLE `zseq_document_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_transaction_types_lookup` -- LOCK TABLES `zseq_document_transaction_types_lookup` WRITE; /*!40000 ALTER TABLE `zseq_document_transaction_types_lookup` DISABLE KEYS */; INSERT INTO `zseq_document_transaction_types_lookup` VALUES (21); /*!40000 ALTER TABLE `zseq_document_transaction_types_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_transactions` -- LOCK TABLES `zseq_document_transactions` WRITE; /*!40000 ALTER TABLE `zseq_document_transactions` DISABLE KEYS */; INSERT INTO `zseq_document_transactions` VALUES (1); /*!40000 ALTER TABLE `zseq_document_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_type_fields_link` -- LOCK TABLES `zseq_document_type_fields_link` WRITE; /*!40000 ALTER TABLE `zseq_document_type_fields_link` DISABLE KEYS */; INSERT INTO `zseq_document_type_fields_link` VALUES (1); /*!40000 ALTER TABLE `zseq_document_type_fields_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_type_fieldsets_link` -- LOCK TABLES `zseq_document_type_fieldsets_link` WRITE; /*!40000 ALTER TABLE `zseq_document_type_fieldsets_link` DISABLE KEYS */; INSERT INTO `zseq_document_type_fieldsets_link` VALUES (1); /*!40000 ALTER TABLE `zseq_document_type_fieldsets_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_document_types_lookup` -- LOCK TABLES `zseq_document_types_lookup` WRITE; /*!40000 ALTER TABLE `zseq_document_types_lookup` DISABLE KEYS */; INSERT INTO `zseq_document_types_lookup` VALUES (1); /*!40000 ALTER TABLE `zseq_document_types_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_documents` -- LOCK TABLES `zseq_documents` WRITE; /*!40000 ALTER TABLE `zseq_documents` DISABLE KEYS */; INSERT INTO `zseq_documents` VALUES (1); /*!40000 ALTER TABLE `zseq_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_field_behaviours` -- LOCK TABLES `zseq_field_behaviours` WRITE; /*!40000 ALTER TABLE `zseq_field_behaviours` DISABLE KEYS */; INSERT INTO `zseq_field_behaviours` VALUES (1); /*!40000 ALTER TABLE `zseq_field_behaviours` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_field_value_instances` -- LOCK TABLES `zseq_field_value_instances` WRITE; /*!40000 ALTER TABLE `zseq_field_value_instances` DISABLE KEYS */; INSERT INTO `zseq_field_value_instances` VALUES (1); /*!40000 ALTER TABLE `zseq_field_value_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_fieldsets` -- LOCK TABLES `zseq_fieldsets` WRITE; /*!40000 ALTER TABLE `zseq_fieldsets` DISABLE KEYS */; INSERT INTO `zseq_fieldsets` VALUES (3); /*!40000 ALTER TABLE `zseq_fieldsets` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_folder_doctypes_link` -- LOCK TABLES `zseq_folder_doctypes_link` WRITE; /*!40000 ALTER TABLE `zseq_folder_doctypes_link` DISABLE KEYS */; INSERT INTO `zseq_folder_doctypes_link` VALUES (2); /*!40000 ALTER TABLE `zseq_folder_doctypes_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_folder_subscriptions` -- LOCK TABLES `zseq_folder_subscriptions` WRITE; /*!40000 ALTER TABLE `zseq_folder_subscriptions` DISABLE KEYS */; INSERT INTO `zseq_folder_subscriptions` VALUES (1); /*!40000 ALTER TABLE `zseq_folder_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_folder_transactions` -- LOCK TABLES `zseq_folder_transactions` WRITE; /*!40000 ALTER TABLE `zseq_folder_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_folder_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_folders` -- LOCK TABLES `zseq_folders` WRITE; /*!40000 ALTER TABLE `zseq_folders` DISABLE KEYS */; INSERT INTO `zseq_folders` VALUES (2); /*!40000 ALTER TABLE `zseq_folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_folders_users_roles_link` -- LOCK TABLES `zseq_folders_users_roles_link` WRITE; /*!40000 ALTER TABLE `zseq_folders_users_roles_link` DISABLE KEYS */; INSERT INTO `zseq_folders_users_roles_link` VALUES (1); /*!40000 ALTER TABLE `zseq_folders_users_roles_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_groups_groups_link` -- LOCK TABLES `zseq_groups_groups_link` WRITE; /*!40000 ALTER TABLE `zseq_groups_groups_link` DISABLE KEYS */; INSERT INTO `zseq_groups_groups_link` VALUES (1); /*!40000 ALTER TABLE `zseq_groups_groups_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_groups_lookup` -- LOCK TABLES `zseq_groups_lookup` WRITE; /*!40000 ALTER TABLE `zseq_groups_lookup` DISABLE KEYS */; INSERT INTO `zseq_groups_lookup` VALUES (3); /*!40000 ALTER TABLE `zseq_groups_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_help` -- LOCK TABLES `zseq_help` WRITE; /*!40000 ALTER TABLE `zseq_help` DISABLE KEYS */; INSERT INTO `zseq_help` VALUES (100); /*!40000 ALTER TABLE `zseq_help` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_help_replacement` -- LOCK TABLES `zseq_help_replacement` WRITE; /*!40000 ALTER TABLE `zseq_help_replacement` DISABLE KEYS */; INSERT INTO `zseq_help_replacement` VALUES (1); /*!40000 ALTER TABLE `zseq_help_replacement` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_interceptor_instances` -- LOCK TABLES `zseq_interceptor_instances` WRITE; /*!40000 ALTER TABLE `zseq_interceptor_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_interceptor_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_links` -- LOCK TABLES `zseq_links` WRITE; /*!40000 ALTER TABLE `zseq_links` DISABLE KEYS */; INSERT INTO `zseq_links` VALUES (1); /*!40000 ALTER TABLE `zseq_links` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_metadata_lookup` -- LOCK TABLES `zseq_metadata_lookup` WRITE; /*!40000 ALTER TABLE `zseq_metadata_lookup` DISABLE KEYS */; INSERT INTO `zseq_metadata_lookup` VALUES (11); /*!40000 ALTER TABLE `zseq_metadata_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_metadata_lookup_tree` -- LOCK TABLES `zseq_metadata_lookup_tree` WRITE; /*!40000 ALTER TABLE `zseq_metadata_lookup_tree` DISABLE KEYS */; INSERT INTO `zseq_metadata_lookup_tree` VALUES (1); /*!40000 ALTER TABLE `zseq_metadata_lookup_tree` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_mime_documents` -- LOCK TABLES `zseq_mime_documents` WRITE; /*!40000 ALTER TABLE `zseq_mime_documents` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_mime_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_mime_extractors` -- LOCK TABLES `zseq_mime_extractors` WRITE; /*!40000 ALTER TABLE `zseq_mime_extractors` DISABLE KEYS */; INSERT INTO `zseq_mime_extractors` VALUES (1); /*!40000 ALTER TABLE `zseq_mime_extractors` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_mime_types` -- LOCK TABLES `zseq_mime_types` WRITE; /*!40000 ALTER TABLE `zseq_mime_types` DISABLE KEYS */; INSERT INTO `zseq_mime_types` VALUES (171); /*!40000 ALTER TABLE `zseq_mime_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_news` -- LOCK TABLES `zseq_news` WRITE; /*!40000 ALTER TABLE `zseq_news` DISABLE KEYS */; INSERT INTO `zseq_news` VALUES (1); /*!40000 ALTER TABLE `zseq_news` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_notifications` -- LOCK TABLES `zseq_notifications` WRITE; /*!40000 ALTER TABLE `zseq_notifications` DISABLE KEYS */; INSERT INTO `zseq_notifications` VALUES (1); /*!40000 ALTER TABLE `zseq_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_organisations_lookup` -- LOCK TABLES `zseq_organisations_lookup` WRITE; /*!40000 ALTER TABLE `zseq_organisations_lookup` DISABLE KEYS */; INSERT INTO `zseq_organisations_lookup` VALUES (1); /*!40000 ALTER TABLE `zseq_organisations_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_assignments` -- LOCK TABLES `zseq_permission_assignments` WRITE; /*!40000 ALTER TABLE `zseq_permission_assignments` DISABLE KEYS */; INSERT INTO `zseq_permission_assignments` VALUES (8); /*!40000 ALTER TABLE `zseq_permission_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_descriptors` -- LOCK TABLES `zseq_permission_descriptors` WRITE; /*!40000 ALTER TABLE `zseq_permission_descriptors` DISABLE KEYS */; INSERT INTO `zseq_permission_descriptors` VALUES (2); /*!40000 ALTER TABLE `zseq_permission_descriptors` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_dynamic_conditions` -- LOCK TABLES `zseq_permission_dynamic_conditions` WRITE; /*!40000 ALTER TABLE `zseq_permission_dynamic_conditions` DISABLE KEYS */; INSERT INTO `zseq_permission_dynamic_conditions` VALUES (1); /*!40000 ALTER TABLE `zseq_permission_dynamic_conditions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_lookup_assignments` -- LOCK TABLES `zseq_permission_lookup_assignments` WRITE; /*!40000 ALTER TABLE `zseq_permission_lookup_assignments` DISABLE KEYS */; INSERT INTO `zseq_permission_lookup_assignments` VALUES (24); /*!40000 ALTER TABLE `zseq_permission_lookup_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_lookups` -- LOCK TABLES `zseq_permission_lookups` WRITE; /*!40000 ALTER TABLE `zseq_permission_lookups` DISABLE KEYS */; INSERT INTO `zseq_permission_lookups` VALUES (5); /*!40000 ALTER TABLE `zseq_permission_lookups` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permission_objects` -- LOCK TABLES `zseq_permission_objects` WRITE; /*!40000 ALTER TABLE `zseq_permission_objects` DISABLE KEYS */; INSERT INTO `zseq_permission_objects` VALUES (1); /*!40000 ALTER TABLE `zseq_permission_objects` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_permissions` -- LOCK TABLES `zseq_permissions` WRITE; /*!40000 ALTER TABLE `zseq_permissions` DISABLE KEYS */; INSERT INTO `zseq_permissions` VALUES (8); /*!40000 ALTER TABLE `zseq_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_plugin_helper` -- LOCK TABLES `zseq_plugin_helper` WRITE; /*!40000 ALTER TABLE `zseq_plugin_helper` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_plugin_helper` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_plugin_rss` -- LOCK TABLES `zseq_plugin_rss` WRITE; /*!40000 ALTER TABLE `zseq_plugin_rss` DISABLE KEYS */; INSERT INTO `zseq_plugin_rss` VALUES (1); /*!40000 ALTER TABLE `zseq_plugin_rss` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_plugins` -- LOCK TABLES `zseq_plugins` WRITE; /*!40000 ALTER TABLE `zseq_plugins` DISABLE KEYS */; INSERT INTO `zseq_plugins` VALUES (21); /*!40000 ALTER TABLE `zseq_plugins` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_role_allocations` -- LOCK TABLES `zseq_role_allocations` WRITE; /*!40000 ALTER TABLE `zseq_role_allocations` DISABLE KEYS */; INSERT INTO `zseq_role_allocations` VALUES (1); /*!40000 ALTER TABLE `zseq_role_allocations` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_roles` -- LOCK TABLES `zseq_roles` WRITE; /*!40000 ALTER TABLE `zseq_roles` DISABLE KEYS */; INSERT INTO `zseq_roles` VALUES (4); /*!40000 ALTER TABLE `zseq_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_saved_searches` -- LOCK TABLES `zseq_saved_searches` WRITE; /*!40000 ALTER TABLE `zseq_saved_searches` DISABLE KEYS */; INSERT INTO `zseq_saved_searches` VALUES (1); /*!40000 ALTER TABLE `zseq_saved_searches` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_scheduler_tasks` -- LOCK TABLES `zseq_scheduler_tasks` WRITE; /*!40000 ALTER TABLE `zseq_scheduler_tasks` DISABLE KEYS */; INSERT INTO `zseq_scheduler_tasks` VALUES (11); /*!40000 ALTER TABLE `zseq_scheduler_tasks` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_search_saved` -- LOCK TABLES `zseq_search_saved` WRITE; /*!40000 ALTER TABLE `zseq_search_saved` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_search_saved` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_status_lookup` -- LOCK TABLES `zseq_status_lookup` WRITE; /*!40000 ALTER TABLE `zseq_status_lookup` DISABLE KEYS */; INSERT INTO `zseq_status_lookup` VALUES (6); /*!40000 ALTER TABLE `zseq_status_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_system_settings` -- LOCK TABLES `zseq_system_settings` WRITE; /*!40000 ALTER TABLE `zseq_system_settings` DISABLE KEYS */; INSERT INTO `zseq_system_settings` VALUES (3); /*!40000 ALTER TABLE `zseq_system_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_tag_words` -- LOCK TABLES `zseq_tag_words` WRITE; /*!40000 ALTER TABLE `zseq_tag_words` DISABLE KEYS */; INSERT INTO `zseq_tag_words` VALUES (1); /*!40000 ALTER TABLE `zseq_tag_words` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_time_period` -- LOCK TABLES `zseq_time_period` WRITE; /*!40000 ALTER TABLE `zseq_time_period` DISABLE KEYS */; INSERT INTO `zseq_time_period` VALUES (1); /*!40000 ALTER TABLE `zseq_time_period` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_time_unit_lookup` -- LOCK TABLES `zseq_time_unit_lookup` WRITE; /*!40000 ALTER TABLE `zseq_time_unit_lookup` DISABLE KEYS */; INSERT INTO `zseq_time_unit_lookup` VALUES (3); /*!40000 ALTER TABLE `zseq_time_unit_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_units_lookup` -- LOCK TABLES `zseq_units_lookup` WRITE; /*!40000 ALTER TABLE `zseq_units_lookup` DISABLE KEYS */; INSERT INTO `zseq_units_lookup` VALUES (1); /*!40000 ALTER TABLE `zseq_units_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_units_organisations_link` -- LOCK TABLES `zseq_units_organisations_link` WRITE; /*!40000 ALTER TABLE `zseq_units_organisations_link` DISABLE KEYS */; INSERT INTO `zseq_units_organisations_link` VALUES (1); /*!40000 ALTER TABLE `zseq_units_organisations_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_upgrades` -- LOCK TABLES `zseq_upgrades` WRITE; /*!40000 ALTER TABLE `zseq_upgrades` DISABLE KEYS */; INSERT INTO `zseq_upgrades` VALUES (184); /*!40000 ALTER TABLE `zseq_upgrades` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_user_history` -- LOCK TABLES `zseq_user_history` WRITE; /*!40000 ALTER TABLE `zseq_user_history` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_user_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_users` -- LOCK TABLES `zseq_users` WRITE; /*!40000 ALTER TABLE `zseq_users` DISABLE KEYS */; INSERT INTO `zseq_users` VALUES (3); /*!40000 ALTER TABLE `zseq_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_users_groups_link` -- LOCK TABLES `zseq_users_groups_link` WRITE; /*!40000 ALTER TABLE `zseq_users_groups_link` DISABLE KEYS */; INSERT INTO `zseq_users_groups_link` VALUES (3); /*!40000 ALTER TABLE `zseq_users_groups_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflow_state_disabled_actions` -- LOCK TABLES `zseq_workflow_state_disabled_actions` WRITE; /*!40000 ALTER TABLE `zseq_workflow_state_disabled_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_workflow_state_disabled_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflow_state_permission_assignments` -- LOCK TABLES `zseq_workflow_state_permission_assignments` WRITE; /*!40000 ALTER TABLE `zseq_workflow_state_permission_assignments` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_workflow_state_permission_assignments` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflow_states` -- LOCK TABLES `zseq_workflow_states` WRITE; /*!40000 ALTER TABLE `zseq_workflow_states` DISABLE KEYS */; INSERT INTO `zseq_workflow_states` VALUES (7); /*!40000 ALTER TABLE `zseq_workflow_states` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflow_transitions` -- LOCK TABLES `zseq_workflow_transitions` WRITE; /*!40000 ALTER TABLE `zseq_workflow_transitions` DISABLE KEYS */; INSERT INTO `zseq_workflow_transitions` VALUES (6); /*!40000 ALTER TABLE `zseq_workflow_transitions` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflow_trigger_instances` -- LOCK TABLES `zseq_workflow_trigger_instances` WRITE; /*!40000 ALTER TABLE `zseq_workflow_trigger_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `zseq_workflow_trigger_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `zseq_workflows` -- LOCK TABLES `zseq_workflows` WRITE; /*!40000 ALTER TABLE `zseq_workflows` DISABLE KEYS */; INSERT INTO `zseq_workflows` VALUES (3); /*!40000 ALTER TABLE `zseq_workflows` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-06-26 13:51:02