diff options
Diffstat (limited to '5.2.5-6.0.0.mysql')
-rw-r--r-- | 5.2.5-6.0.0.mysql | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/5.2.5-6.0.0.mysql b/5.2.5-6.0.0.mysql new file mode 100644 index 000000000000..66d1198f8abb --- /dev/null +++ b/5.2.5-6.0.0.mysql @@ -0,0 +1,61 @@ +ALTER TABLE ajxp_user_rights ADD INDEX (login), ADD INDEX (repo_uuid); +/* SEPARATOR */ +CREATE TABLE IF NOT EXISTS `ajxp_changes` ( + `seq` int(20) NOT NULL AUTO_INCREMENT, + `repository_identifier` TEXT NOT NULL, + `node_id` bigint(20) NOT NULL, + `type` enum('create','delete','path','content') NOT NULL, + `source` text NOT NULL, + `target` text NOT NULL, + PRIMARY KEY (`seq`), + KEY `node_id` (`node_id`,`type`) +); +/* SEPARATOR */ +CREATE TABLE IF NOT EXISTS `ajxp_index` ( + `node_id` int(20) NOT NULL AUTO_INCREMENT, + `node_path` text NOT NULL, + `bytesize` bigint(20) NOT NULL, + `md5` varchar(32) NOT NULL, + `mtime` int(11) NOT NULL, + `repository_identifier` text NOT NULL, + PRIMARY KEY (`node_id`) +); +/* SEPARATOR */ +DROP TRIGGER IF EXISTS `LOG_DELETE`; +/* SEPARATOR */ +CREATE TRIGGER `LOG_DELETE` AFTER DELETE ON `ajxp_index` +FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type) + VALUES (old.repository_identifier, old.node_id, old.node_path, 'NULL', 'delete'); +/* SEPARATOR */ +DROP TRIGGER IF EXISTS `LOG_INSERT`; +/* SEPARATOR */ +CREATE TRIGGER `LOG_INSERT` AFTER INSERT ON `ajxp_index` +FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type) + VALUES (new.repository_identifier, new.node_id, 'NULL', new.node_path, 'create'); +/* SEPARATOR */ +DROP TRIGGER IF EXISTS `LOG_UPDATE`; +/* SEPARATOR */ +CREATE TRIGGER `LOG_UPDATE` AFTER UPDATE ON `ajxp_index` +FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type) + VALUES (new.repository_identifier, new.node_id, old.node_path, new.node_path, CASE old.node_path = new.node_path WHEN true THEN 'content' ELSE 'path' END); +/* SEPARATOR */ +CREATE TABLE `ajxp_log.bak` LIKE `ajxp_log`; +/* SEPARATOR */ +INSERT `ajxp_log.bak` SELECT * FROM `ajxp_log`; +/* SEPARATOR */ +CREATE TABLE `ajxp_log2` LIKE `ajxp_log`; +/* SEPARATOR */ +INSERT `ajxp_log2` SELECT * FROM `ajxp_log`; +/* SEPARATOR */ +ALTER TABLE `ajxp_log2` ADD `source` VARCHAR( 255 ) NOT NULL AFTER `user` , ADD INDEX ( `source` ) ; +/* SEPARATOR */ +UPDATE `ajxp_log2` INNER JOIN ajxp_log ON ajxp_log2.id=ajxp_log.id SET ajxp_log2.source = ajxp_log.message, ajxp_log2.message = SUBSTRING_INDEX(SUBSTRING_INDEX(ajxp_log.params, '\t', 1), '\t', -1),ajxp_log2.params = SUBSTRING_INDEX(SUBSTRING_INDEX(ajxp_log.params, '\t', 2), '\t', -1); +/* SEPARATOR */ +DROP TABLE `ajxp_log`; +/* SEPARATOR */ +RENAME TABLE `ajxp_log2` TO `ajxp_log`; + +CREATE TABLE IF NOT EXISTS ajxp_version ( + db_build INT NOT NULL +); +INSERT INTO ajxp_version SET db_build=60;
\ No newline at end of file |