data.sql

PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。

(79, 'CustomErrorMessages', 'Custom Error Handler', 'Enables and disables the custom error handler feature. Default is \'On\' (enabled).', 'customerrorhandler', 'default', 'on', 'radio', 'a:1:{s:7:"options";a:2:{i:0;s:2:"on";i:1;s:3:"off";}}', 1),
(80, 'ui', 'Enable Custom Skinning', 'Defines whether customs skins may be used for the KnowledgeTree user interface. Default is \'False\'.', 'morphEnabled', 'default', 'false', 'boolean', NULL, 1),
(81, 'ui', 'Default Skin', 'Defines, when skinning is enabled, the location of the custom skin to use for the KnowledgeTree user interface.', 'morphTo', 'default', 'blue', 'string', NULL, 1),
(82, 'KnowledgeTree', 'Log Level', 'Defines the level of logging to use (DEBUG, INFO, WARN, ERROR). The default is INFO.', 'logLevel', 'default', 'INFO', 'dropdown', 'a:1:{s:7:"options";a:4:{i:0;a:2:{s:5:"label";s:4:"INFO";s:5:"value";s:4:"INFO";}i:1;a:2:{s:5:"label";s:4:"WARN";s:5:"value";s:4:"WARN";}i:2;a:2:{s:5:"label";s:5:"ERROR";s:5:"value";s:5:"ERROR";}i:3;a:2:{s:5:"label";s:5:"DEBUG";s:5:"value";s:5:"DEBUG";}}}', 1),
(83, 'storage', 'Manager', 'Defines the storage manager to use for storing documents on the file system. ', 'manager', 'default', 'KTOnDiskHashedStorageManager', 'string', NULL, 1),
(84, 'ui', 'IE GIF Theme Overrides', 'Defines whether to use the additional IE-specific GIF theme overrides, which may restrict <br>the working of arbitrary theme packs without having GIF versions available. Default is \'False\'.', 'ieGIF', 'false', 'true', 'boolean', NULL, 1),
(85, 'ui', 'Automatic Refresh', 'Set to true to automatically refresh the page after the session would have expired.', 'automaticRefresh', 'default', 'false', 'boolean', NULL, 1),
(86, 'ui', 'dot', 'Location of the dot binary (command location). On Unix systems, to determine whether the \'dot\' application is installed.', 'dot', 'dot', 'dot', 'string', NULL, 1),
(87, 'urls', 'Log Directory', 'The path to the Log directory.', 'logDirectory', 'default', '${varDirectory}/log', 'string', NULL, 1),
(88, 'urls', 'UI Directory', 'The path to the UI directory.', 'uiDirectory', 'default', '${fileSystemRoot}/presentation/lookAndFeel/knowledgeTree', 'string', NULL, 1),
(89, 'urls', 'Temp Directory', 'The path to the temp directory.', 'tmpDirectory', 'default', '${varDirectory}/tmp', 'string', NULL, 1),
(90, 'urls', 'Stopwords File', 'The path to the stopword file.', 'stopwordsFile', 'default', '${fileSystemRoot}/config/stopwords.txt', 'string', NULL, 1),
(91, 'cache', 'Cache Enabled', 'Enables the KnowledgeTree cache. Default is \'False\'.', 'cacheEnabled', 'default', 'false', 'boolean', NULL, 1),
(92, 'cache', 'Cache Directory', 'The location of the KnowledgeTree cache.', 'cacheDirectory', 'default', '${varDirectory}/cache', 'string', NULL, 1),
(93, 'openoffice', 'Program Path', 'Defines the path to the OpenOffice program directory. ', 'programPath', 'default', '../openoffice/program', 'string', NULL, 1),
(94, 'urls', 'documentRoot', '', 'documentRoot', 'default', '${varDirectory}/Documents', 'string', NULL, 0),
(95, 'KnowledgeTree', 'Redirect To Browse View', 'Defines whether to redirect to the Browse view (Browse Documemts) on login, instead of the Dashboard.<br>Default is \'False\'. ', 'redirectToBrowse', 'default', 'false', 'boolean', NULL, 1),
(96, 'KnowledgeTree', 'Redirect To Browse View: Exceptions', 'Specifies that, when \'Redirect To Browse\' is set to \'True\' all users, except for the users listed in the text field below are redirected to the Browse view on log in. The users listed for this setting are directed to the KnowledgeTree Dashboard. To define exceptions, add user names in the text field as follows, e.g. admin, joebloggs, etc.', 'redirectToBrowseExceptions', '', '', 'string', NULL, 1),
(97, 'session', 'Allow Automatic Sign In', 'Defines whether to automatically create a user account on first login for any user who does not yet exist in the system. Default is \'False\'.', 'allowAutoSignup', 'default', 'false', 'boolean', 'string', 1),
(98, 'ldapAuthentication', 'Create Groups Automatically', 'Defines whether to allow LDAP groups to be created automatically. Default is \'False\'.', 'autoGroupCreation', 'default', 'false', 'boolean', 'string', 1),
(99, 'browse', 'Truncate Document and Folder Titles in Browse View', 'Defines the maximum number of characters to display for a document or folder title in the browse view. The maximum allowable number of characters is 255.', 'titleCharLength', 'default', '40', 'numeric_string', 'string', 1),
(100, 'import', 'Disable Bulk Import', 'Disable the bulk import plugin', 'disableBulkImport', 'default', 'false', 'string', NULL, 1),
(101, 'session', 'Enable version check', 'Compares the system version with the database version to determine if a database upgrade is needed.','dbversioncompare', 'default', 'true', 'boolean', NULL, 0),
(102, 'tweaks', 'Update Document Version (Content) on Editing Metadata', 'The document version is equivalent to the document content version. When set to true the document version will be increased when the document metadata is updated.', 'updateContentVersion', 'default', 'false', 'boolean', NULL, 1),
(103, 'tweaks', 'Always Force Original Filename on Checkin', 'When set to true, the checkbox for "Force Original Filename" will be hidden on check-in. This ensures that the filename will always stay the same.', 'disableForceFilenameOption', 'default', 'false', 'boolean', NULL, 1),
(104, 'KnowledgeTree', 'The Location of the Mime Magic File', 'The path to the mime magic database file.', 'magicDatabase', 'default', '/usr/share/file/magic', 'string', NULL, 1),
(105, 'search', 'Maximum results from SQL query', 'The maximum results from an SQL query', 'maxSqlResults', 'default', '1000', 'numeric_string', NULL, 1);
/*!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`
--