/usr/share/knowledgeroot/dumps/upgrade_mysql.sql is in knowledgeroot 0.9.9.5-6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | CREATE TABLE `access` (
`id` int(11) NOT NULL auto_increment,
`table_name` varchar(255) NOT NULL DEFAULT '',
`belongs_to` int(11) NOT NULL DEFAULT 0,
`owner_group` varchar(5) NOT NULL DEFAULT '',
`owner_group_id` int(11) NOT NULL DEFAULT 0,
`rights` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
ALTER TABLE `files` ADD `counter` int(11) DEFAULT '0' NOT NULL;
ALTER TABLE `tree` ADD `symlink` int(11) DEFAULT '0' NOT NULL;
ALTER TABLE `tree` ADD `sorting` int(11) DEFAULT '0' NOT NULL;
ALTER TABLE `tree` ADD `tooltip` varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE `settings` CHANGE `value` `value` TEXT NOT NULL;
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('fckeditor', 1, 0);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('tinymce', 0, 0);
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('downloads.static', '0', 'enable static download links', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.order.self', '0', 'enable self order of tree elements', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.handle', '0', 'enable handling of sessin', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.lifetime', '60', 'lifetime of session in minutes', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.checkIP', '0', 'check ip of session', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.checkBrowser', '0', 'check browser of session', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.onlyCookies', '0', 'allow only cookie sessions', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.context', '1', 'enable/disable context menus', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.dragdrop', '1', 'enable/disable drag and drop in tree', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.recursivdelete', '2', 'set recusriv delete, 2 - only admins; 1 - all users with login, 0 - all users', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.edittooltiptext', '0', 'enable/disable edit of tooltiptext of tree element', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.showcounter', '0', 'enable/disable counting of tree items', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('content.showcounter', '1', 'enable/disable counting of content items', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.showsourceforgelogo', '0', 'show sourceforge logo', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.showlogo', '0', 'show knowledgeroot logo instead of text title', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('version', '0.9.9', 'knowledgeroot version - do not edit! - it only shows the database version of knowledgeroot', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('baseurl', '', 'base url for knowledgeroot', '');
|