150306 14:06:22 19 Connect root@localhost on 19 Query select @@version_comment limit 1 19 Query drop database jtalks 150306 14:06:26 19 Quit 20 Connect root@localhost on 20 Query select @@version_comment limit 1 20 Query create database jtalks character set utf8 20 Quit 150306 14:06:43 22 Connect test@localhost on jtalks 23 Connect test@localhost on jtalks 21 Connect test@localhost on jtalks 21 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 23 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 22 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 23 Query SHOW WARNINGS 21 Query SHOW WARNINGS 22 Query SHOW WARNINGS 21 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 21 Query SHOW COLLATION 21 Query SET NAMES utf8 22 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 22 Query SHOW COLLATION 21 Query SET character_set_results = NULL 21 Query SET autocommit=1 21 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 22 Query SET NAMES utf8 22 Query SET character_set_results = NULL 22 Query SET autocommit=1 22 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 23 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 23 Query SHOW COLLATION 23 Query SET NAMES utf8 23 Query SET character_set_results = NULL 23 Query SET autocommit=1 23 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 23 Query SELECT @@session.tx_isolation 22 Query SELECT @@session.tx_isolation 21 Query SELECT @@session.tx_isolation 21 Query SELECT @@session.tx_isolation 150306 14:06:46 21 Query show tables like 'common_schema_version' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE jtalks.common_schema_version ( version VARCHAR(20) NOT NULL UNIQUE, description VARCHAR(100), type VARCHAR(10) NOT NULL, script VARCHAR(200) NOT NULL UNIQUE, checksum INT, installed_by VARCHAR(30) NOT NULL, installed_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP, execution_time INT, state VARCHAR(15) NOT NULL, current_version BOOL NOT NULL, PRIMARY KEY(version) ) ENGINE=InnoDB 150306 14:06:47 22 Query select @@session.tx_read_only 22 Query ALTER TABLE jtalks.common_schema_version ADD INDEX common_schema_version_current_version_index (current_version) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('0', '<< Flyway Init >>', 'INIT', '<< Flyway Init >>', null, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `USERS` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `FIRST_NAME` varchar(255) DEFAULT NULL, `LAST_NAME` varchar(255) DEFAULT NULL, `USERNAME` varchar(255) NOT NULL, `ENCODED_USERNAME` varchar(255) NOT NULL, `EMAIL` varchar(255) NOT NULL, `PASSWORD` varchar(255) NOT NULL, `ROLE` varchar(255) DEFAULT NULL, `LAST_LOGIN` datetime DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UUID` (`UUID`), UNIQUE KEY `USERNAME` (`USERNAME`), UNIQUE KEY `EMAIL` (`EMAIL`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('1', 'Base version', 'SQL', 'V1__Base_version.sql', -417099139, SUBSTRING_INDEX(USER(),'@',1), 421, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD AVATAR BLOB 150306 14:06:48 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('2', 'Avatar', 'SQL', 'V2__Avatar.sql', -702111698, SUBSTRING_INDEX(USER(),'@',1), 828, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" 22 Query set foreign_key_checks=0 22 Query select @@session.tx_read_only 22 Query DROP TABLE IF EXISTS `acl_sid` 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `acl_sid` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `principal` tinyint(1) NOT NULL, -- a label, that shows whether the object is principal(is there a possibility to login with this object or not, i.e. groups cannot be here; true indicates that the sid is a user, false means that the sid is a granted authority) `sid` varchar(100) NOT NULL, -- an entity, which get the permissions() PRIMARY KEY (`id`), UNIQUE KEY `uk_acl_sid` (`sid`,`principal`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 150306 14:06:49 22 Query select @@session.tx_read_only 22 Query DROP TABLE IF EXISTS `acl_class` 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `acl_class` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `class` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_acl_class` (`class`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 22 Query select @@session.tx_read_only 22 Query DROP TABLE IF EXISTS `acl_entry` 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `acl_entry` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `acl_object_identity` bigint(20) NOT NULL, -- a link to an an entry in acl_object_identity table - the id of the object `ace_order` int(11) NOT NULL, -- an order of permissions priority (AccessControlEntry (ACE) represents individual permission assignment) `sid` bigint(20) NOT NULL, -- a link to a acl_sid table - who gets the permissions `mask` int(11) NOT NULL, -- bit mask, which identifies the permissions (for example for read, write etc.) `granting` tinyint(1) NOT NULL, -- a value, that identifies whether the permission is allowed or not (for JCommune - 1 - allowed, 0 - not allowed). The granting field, if set to true, indicates that the permissions indicated by mask are granted to the corresponding sid, otherwise they are revoked or blocked. `audit_success` tinyint(1) NOT NULL, -- a flag to indicate whether to audit a successful permission `audit_failure` tinyint(1) NOT NULL, -- a flag to indicate whether to audit a failed permission PRIMARY KEY (`id`), UNIQUE KEY `uk_acl_entry` (`acl_object_identity`,`ace_order`), KEY `fk_acl_entry_obj_id` (`acl_object_identity`), KEY `fk_acl_entry_sid` (`sid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 22 Query select @@session.tx_read_only 22 Query DROP TABLE IF EXISTS `acl_object_identity` 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `acl_object_identity` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `object_id_class` bigint(20) NOT NULL, -- a link to acl_class table - the type of the object `object_id_identity` bigint(20) NOT NULL, -- an id of the object (for JCommune - the ID of the object) `parent_object` bigint(20) DEFAULT NULL, -- a link to a parent object `owner_sid` bigint(20) DEFAULT NULL, -- a link to a acl_sid table - the owner of the object(each object must have an owner). Pay attention if object was inherited - the fields parent_object and entries_inheriting are used to give the due details `entries_inheriting` tinyint(1) NOT NULL, -- gives the key whether the parent permissions should be extended to children PRIMARY KEY (`id`), UNIQUE KEY `uk_acl_objid` (`object_id_class`,`object_id_identity`), KEY `fk_acl_obj_parent` (`parent_object`), KEY `fk_acl_obj_class` (`object_id_class`), KEY `fk_acl_obj_owner` (`owner_sid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 150306 14:06:50 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `acl_entry` ADD CONSTRAINT `fk_acl_entry_obj_id` FOREIGN KEY (`acl_object_identity`) REFERENCES `acl_object_identity` (`id`), ADD CONSTRAINT `fk_acl_entry_sid` FOREIGN KEY (`sid`) REFERENCES `acl_sid` (`id`) 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `acl_object_identity` ADD CONSTRAINT `fk_acl_obj_parent` FOREIGN KEY (`parent_object`) REFERENCES `acl_object_identity` (`id`), ADD CONSTRAINT `fk_acl_obj_class` FOREIGN KEY (`object_id_class`) REFERENCES `acl_class` (`id`), ADD CONSTRAINT `fk_acl_obj_owner` FOREIGN KEY (`owner_sid`) REFERENCES `acl_sid` (`id`) 22 Query set foreign_key_checks=1 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('3', 'ACL tables', 'SQL', 'V3__ACL_tables.sql', -487109400, SUBSTRING_INDEX(USER(),'@',1), 1953, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD PERMANENT_BAN BOOLEAN NOT NULL DEFAULT FALSE 150306 14:06:51 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD BAN_EXPIRATION_DATE DATETIME DEFAULT NULL 150306 14:06:52 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD BAN_REASON LONGTEXT DEFAULT NULL 150306 14:06:53 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('4', 'Ban status', 'SQL', 'V4__Ban_status.sql', 47388248, SUBSTRING_INDEX(USER(),'@',1), 2422, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE USERS ADD SALT VARCHAR(64) NOT NULL DEFAULT '' 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('5', 'Add salt to users', 'SQL', 'V5__Add_salt_to_users.sql', 32818975, SUBSTRING_INDEX(USER(),'@',1), 719, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 150306 14:06:54 21 Query SET autocommit=0 21 Query SELECT `ID`, `PASSWORD` FROM `USERS` WHERE `SALT` = '' 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('6', 'Update user passwords', 'JAVA', 'org.jtalks.common.migrations.V6__Update_user_passwords', null, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE PERSISTENT_LOGINS (USERNAME VARCHAR(64) NOT NULL, SERIES VARCHAR(64) PRIMARY KEY, TOKEN VARCHAR(64) NOT NULL, LAST_USED TIMESTAMP NOT NULL) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('7', 'Persistent logins table', 'SQL', 'V7__Persistent_logins_table.sql', 1716291607, SUBSTRING_INDEX(USER(),'@',1), 235, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `SECTIONS` ( `SECTION_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `NAME` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, `POSITION` int(11) DEFAULT NULL, `COMPONENT_ID` bigint(20), PRIMARY KEY (`SECTION_ID`), UNIQUE KEY `UUID` (`UUID`) ) 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `GROUPS` ( `GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `NAME` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, PRIMARY KEY (`GROUP_ID`), UNIQUE KEY `UUID` (`UUID`) ) 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `BRANCHES` ( `BRANCH_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `NAME` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, `POSITION` int(11) DEFAULT NULL, `SECTION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`BRANCH_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_SECTION` (`SECTION_ID`), CONSTRAINT `FK_SECTION` FOREIGN KEY (`SECTION_ID`) REFERENCES `SECTIONS` (`SECTION_ID`) ) 150306 14:06:55 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `COMPONENTS` ( `CMP_ID` bigint(20) NOT NULL AUTO_INCREMENT, `COMPONENT_TYPE` varchar(255) NOT NULL, `UUID` varchar(255) NOT NULL, `NAME` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, `C_TYPE` int(11) DEFAULT NULL, PRIMARY KEY (`CMP_ID`), UNIQUE KEY `UUID` (`UUID`), UNIQUE KEY `NAME` (`NAME`), UNIQUE KEY `C_TYPE` (`C_TYPE`) ) 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `GROUP_USER_REF` ( `GROUP_ID` bigint(20) NOT NULL, `USER_ID` bigint(20) NOT NULL, KEY `FK556C5FDF4ECBCAA4` (`USER_ID`), KEY `FK556C5FDFB7F395D0` (`GROUP_ID`), CONSTRAINT `FK556C5FDF4ECBCAA4` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`), CONSTRAINT `FK556C5FDFB7F395D0` FOREIGN KEY (`GROUP_ID`) REFERENCES `GROUPS` (`GROUP_ID`) ) 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `PROPERTIES` ( `PROPERTY_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `NAME` varchar(255) NOT NULL, `VALUE` varchar(255) DEFAULT NULL, `CMP_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`PROPERTY_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_COMPONENT` (`CMP_ID`), CONSTRAINT `FK_COMPONENT` FOREIGN KEY (`CMP_ID`) REFERENCES `COMPONENTS` (`CMP_ID`) ) 150306 14:06:56 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `RANKS` ( `RANK_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) NOT NULL, `RANK_NAME` varchar(255) NOT NULL, `AUTO_ASSIGNED` bit(1) DEFAULT NULL, `POST_COUNT` int(11) DEFAULT NULL, PRIMARY KEY (`RANK_ID`), UNIQUE KEY `UUID` (`UUID`), UNIQUE KEY `RANK_NAME` (`RANK_NAME`) ) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('8', 'New Entities', 'SQL', 'V8__New_Entities.sql', -1707833816, SUBSTRING_INDEX(USER(),'@',1), 2031, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE acl_sid DEFAULT CHARACTER SET utf8 21 Query select @@session.tx_read_only 21 Query ALTER TABLE acl_class DEFAULT CHARACTER SET utf8 21 Query select @@session.tx_read_only 21 Query ALTER TABLE acl_class MODIFY class VARCHAR(255) CHARACTER SET utf8 150306 14:06:57 21 Query select @@session.tx_read_only 21 Query ALTER TABLE acl_entry DEFAULT CHARACTER SET utf8 21 Query select @@session.tx_read_only 21 Query ALTER TABLE acl_object_identity DEFAULT CHARACTER SET utf8 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('9', 'ACL Charset Change', 'SQL', 'V9__ACL_Charset_Change.sql', -426457137, SUBSTRING_INDEX(USER(),'@',1), 812, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table PERSISTENT_LOGINS rename persistent_logins 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins change USERNAME username varchar(64) not null 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins change SERIES series varchar(64) not null 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins change TOKEN token varchar(64) not null 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins change LAST_USED last_used timestamp not null 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins ENGINE = InnoDB 21 Query select @@session.tx_read_only 21 Query alter table persistent_logins DEFAULT CHARACTER SET utf8 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('10', 'Persistent Logins Case Change', 'SQL', 'V10__Persistent_Logins_Case_Change.sql', -1716166276, SUBSTRING_INDEX(USER(),'@',1), 687, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table BRANCHES ENGINE = InnoDB DEFAULT CHARACTER SET utf8 150306 14:06:58 21 Query select @@session.tx_read_only 21 Query alter table COMPONENTS ENGINE = InnoDB DEFAULT CHARACTER SET utf8 150306 14:06:59 21 Query select @@session.tx_read_only 21 Query alter table GROUPS ENGINE = InnoDB DEFAULT CHARACTER SET utf8 21 Query select @@session.tx_read_only 21 Query alter table GROUP_USER_REF ENGINE = InnoDB DEFAULT CHARACTER SET utf8 150306 14:07:00 21 Query select @@session.tx_read_only 21 Query alter table PROPERTIES ENGINE = InnoDB DEFAULT CHARACTER SET utf8 150306 14:07:01 21 Query select @@session.tx_read_only 21 Query alter table RANKS ENGINE = InnoDB DEFAULT CHARACTER SET utf8 21 Query select @@session.tx_read_only 21 Query alter table SECTIONS ENGINE = InnoDB DEFAULT CHARACTER SET utf8 150306 14:07:02 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('11', 'Tables Engine Charset Change', 'SQL', 'V11__Tables_Engine_Charset_Change.sql', -41936755, SUBSTRING_INDEX(USER(),'@',1), 4156, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `BRANCHES` ADD COLUMN `MODERATORS_GROUP_ID` bigint(20) DEFAULT NULL 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `BRANCHES` ADD CONSTRAINT `FK_MODERATORS_GROUP_ID` FOREIGN KEY (`MODERATORS_GROUP_ID`) REFERENCES `GROUPS` (`GROUP_ID`) 150306 14:07:03 22 Query select @@session.tx_read_only 22 Query UPDATE `BRANCHES` SET `MODERATORS_GROUP_ID` = `BRANCH_ID` WHERE EXISTS ( SELECT * FROM `GROUPS` WHERE `GROUP_ID` = `BRANCH_ID` ) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('12', 'Moderators Group Column In Branches', 'SQL', 'V12__Moderators_Group_Column_In_Branches.sql', 140599915, SUBSTRING_INDEX(USER(),'@',1), 1031, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table BRANCHES modify DESCRIPTION text null 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('13', 'Branch Table Column Type Change', 'SQL', 'V13__Branch_Table_Column_Type_Change.sql', 1899329008, SUBSTRING_INDEX(USER(),'@',1), 797, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table USERS drop BAN_EXPIRATION_DATE 150306 14:07:04 22 Query select @@session.tx_read_only 22 Query alter table USERS drop PERMANENT_BAN 150306 14:07:05 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('14', 'Users Table Unnecessary columns', 'SQL', 'V14__Users_Table_Unnecessary_columns.sql', 335381641, SUBSTRING_INDEX(USER(),'@',1), 1172, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD COLUMN REGISTRATION_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL 150306 14:07:06 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('15', 'USERS Registration Date Adding', 'SQL', 'V15__USERS_Registration_Date_Adding.sql', -1405682119, SUBSTRING_INDEX(USER(),'@',1), 813, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table BRANCHES modify DESCRIPTION varchar(512) default null 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('16', 'Branch Table Column Type Change Back', 'SQL', 'V16__Branch_Table_Column_Type_Change_Back.sql', -889513587, SUBSTRING_INDEX(USER(),'@',1), 797, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table USERS modify USERNAME varchar(255) NOT NULL COLLATE utf8_bin 150306 14:07:07 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('17', 'USER Username Collation Change', 'SQL', 'V17__USER_Username_Collation_Change.sql', -223193607, SUBSTRING_INDEX(USER(),'@',1), 515, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table PROPERTIES add column VALIDATION_RULE varchar(64) NOT NULL default '' 150306 14:07:08 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('18', 'Property Validation Rule Add', 'SQL', 'V18__Property_Validation_Rule_Add.sql', 1118804998, SUBSTRING_INDEX(USER(),'@',1), 547, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table acl_sid COMMENT 'list of objects, that get the permissions for something' 21 Query select @@session.tx_read_only 21 Query alter table acl_sid modify principal tinyint(1) NOT NULL comment 'true - sid is user, false - sid is a granted authority' 21 Query select @@session.tx_read_only 21 Query alter table acl_sid modify sid varchar(100) NOT NULL comment 'an entity, which get the permissions' 21 Query select @@session.tx_read_only 21 Query alter table acl_class COMMENT 'list of classes, for which the perms are given' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry COMMENT 'logs of security journal' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify acl_object_identity bigint(20) NOT NULL comment 'a link to an an entry in acl_object_identity table' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify ace_order int(11) NOT NULL comment 'AccessControlEntry individual permission assignment order' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify sid bigint(20) NOT NULL comment 'a link to a acl_sid table - who gets the permissions' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify mask int(11) NOT NULL comment 'bit mask, which identifies the permissions (read, write)' 150306 14:07:09 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify granting tinyint(1) NOT NULL comment 'whether the permission is allowed or not (revoked, blocked)' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify audit_success tinyint(1) NOT NULL comment 'flag to indicate whether to audit a successful permission' 21 Query select @@session.tx_read_only 21 Query alter table acl_entry modify audit_failure tinyint(1) NOT NULL comment 'flag to indicate whether to audit a failed permission' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity COMMENT 'Each table entry is the representation of the object' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity modify object_id_class bigint(20) NOT NULL comment 'link to acl_class table - the type of the object' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity modify object_id_identity bigint(20) NOT NULL comment 'id of the object (for JCommune - the ID of the object)' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity modify parent_object bigint(20) DEFAULT NULL comment 'link to a parent object' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity modify owner_sid bigint(20) DEFAULT NULL comment 'owner of the object, if object was inherited' 21 Query select @@session.tx_read_only 21 Query alter table acl_object_identity modify entries_inheriting tinyint(1) NOT NULL comment 'key whether the parent perm should be extended to children' 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.common_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('19', 'ACL Tables Structure Comments', 'SQL', 'V19__ACL_Tables_Structure_Comments.sql', -1503689930, SUBSTRING_INDEX(USER(),'@',1), 1344, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE USERS ADD ENABLED bool DEFAULT FALSE 150306 14:07:10 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('20', 'Added ENABLED column to USERS', 'SQL', 'V20__Added_ENABLED_column_to_USERS.sql', -693428966, SUBSTRING_INDEX(USER(),'@',1), 594, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE PROPERTIES CHANGE value value text NULL 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('21', 'Extend property value size', 'SQL', 'V21__Extend_property_value_size.sql', -79205389, SUBSTRING_INDEX(USER(),'@',1), 531, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.common_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.common_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `USERS` ADD `VERSION` BIGINT NOT NULL DEFAULT 0 150306 14:07:11 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.common_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.common_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('22', 'User add version for optimistic locking', 'SQL', 'V22__User_add_version_for_optimistic_locking.sql', 1336348685, SUBSTRING_INDEX(USER(),'@',1), 563, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.common_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.common_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query show tables like 'jcommune_schema_version' 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE jtalks.jcommune_schema_version ( version VARCHAR(20) NOT NULL UNIQUE, description VARCHAR(100), type VARCHAR(10) NOT NULL, script VARCHAR(200) NOT NULL UNIQUE, checksum INT, installed_by VARCHAR(30) NOT NULL, installed_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP, execution_time INT, state VARCHAR(15) NOT NULL, current_version BOOL NOT NULL, PRIMARY KEY(version) ) ENGINE=InnoDB 21 Query select @@session.tx_read_only 21 Query ALTER TABLE jtalks.jcommune_schema_version ADD INDEX jcommune_schema_version_current_version_index (current_version) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('0', '<< Flyway Init >>', 'INIT', '<< Flyway Init >>', null, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `SECTION` ( `SECTION_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `NAME` varchar(255) COLLATE utf8_bin NOT NULL, `POSITION` bigint(20) DEFAULT NULL, `DESCRIPTION` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SECTION_ID`), UNIQUE KEY `UUID` (`UUID`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `BRANCH` ( `BRANCH_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `NAME` varchar(255) COLLATE utf8_bin NOT NULL, `DESCRIPTION` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BRANCHES_INDEX` int(11) DEFAULT NULL, `SECTION_ID` bigint(20) NOT NULL, PRIMARY KEY (`BRANCH_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_SECTION` (`SECTION_ID`), CONSTRAINT `FK_SECTION_REF` FOREIGN KEY (`SECTION_ID`) REFERENCES `SECTION` (`SECTION_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:12 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `BRANCH_SUBSCRIPTIONS` ( `BRANCH_ID` bigint(20) NOT NULL, `USER_ID` bigint(20) NOT NULL, KEY `FK_USER` (`USER_ID`), KEY `FK_BRANCH` (`BRANCH_ID`), CONSTRAINT `FK_BRANCH_SUB` FOREIGN KEY (`BRANCH_ID`) REFERENCES `BRANCH` (`BRANCH_ID`), CONSTRAINT `FK_USER_BRANCH_SUB` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `TOPIC` ( `TOPIC_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `TITLE` varchar(255) COLLATE utf8_bin NOT NULL, `CREATION_DATE` datetime NOT NULL, `TOPIC_STARTER` bigint(20) NOT NULL, `BRANCH_ID` bigint(20) DEFAULT NULL, `TOPICS_INDEX` int(11) DEFAULT NULL, `MODIFICATION_DATE` datetime DEFAULT NULL, `TOPIC_WEIGHT` int(11) NOT NULL, `STICKED` tinyint(1) NOT NULL, `ANNOUNCEMENT` tinyint(1) NOT NULL, `VIEWS` int(11) DEFAULT '0', PRIMARY KEY (`TOPIC_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_TOPIC_STARTER` (`TOPIC_STARTER`), KEY `FK_BRANCH` (`BRANCH_ID`), CONSTRAINT `FK_BRANCH` FOREIGN KEY (`BRANCH_ID`) REFERENCES `BRANCH` (`BRANCH_ID`), CONSTRAINT `FK_TOPIC_STARTER` FOREIGN KEY (`TOPIC_STARTER`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `POST` ( `POST_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `POST_DATE` datetime NOT NULL, `POST_CONTENT` longtext COLLATE utf8_bin NOT NULL, `USER_CREATED` bigint(20) NOT NULL, `TOPIC_ID` bigint(20) DEFAULT NULL, `LIST_INDEX` int(11) DEFAULT NULL, `MODIFICATION_DATE` datetime DEFAULT NULL, PRIMARY KEY (`POST_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_USER` (`USER_CREATED`), KEY `FK_TOPIC` (`TOPIC_ID`), CONSTRAINT `FK_TOPIC` FOREIGN KEY (`TOPIC_ID`) REFERENCES `TOPIC` (`TOPIC_ID`), CONSTRAINT `FK_USER` FOREIGN KEY (`USER_CREATED`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:13 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `PRIVATE_MESSAGE` ( `PM_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `USER_FROM` bigint(20) NOT NULL, `USER_TO` bigint(20) NOT NULL, `CREATION_DATE` datetime NOT NULL, `TITLE` varchar(255) COLLATE utf8_bin NOT NULL, `BODY` longtext COLLATE utf8_bin NOT NULL, `STATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`PM_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_USER_TO` (`USER_TO`), KEY `FK_USER_FROM` (`USER_FROM`), CONSTRAINT `FK_USER_FROM` FOREIGN KEY (`USER_FROM`) REFERENCES `USERS` (`ID`), CONSTRAINT `FK_USER_TO` FOREIGN KEY (`USER_TO`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `TOPIC_SUBSCRIPTIONS` ( `TOPIC_ID` bigint(20) NOT NULL, `USER_ID` bigint(20) NOT NULL, KEY `FK_USER` (`USER_ID`), KEY `FK_TOPIC` (`TOPIC_ID`), CONSTRAINT `FK_TOPIC_SUB` FOREIGN KEY (`TOPIC_ID`) REFERENCES `TOPIC` (`TOPIC_ID`), CONSTRAINT `FK_USER_TOPIC_SUB` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `JC_USER_DETAILS` ( `USER_ID` bigint(20) NOT NULL, `SIGNATURE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LANGUAGE` varchar(255) COLLATE utf8_bin DEFAULT 'ENGLISH', `PAGE_SIZE` int(11) DEFAULT '50', CONSTRAINT `FK_JC_USER` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:14 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('1', 'Base version', 'SQL', 'V1__Base%20version.sql', 1794524048, SUBSTRING_INDEX(USER(),'@',1), 2343, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `JC_USER_DETAILS` ADD `LOCATION` varchar(255) COLLATE utf8_bin DEFAULT NULL 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `JC_USER_DETAILS` ADD `REGISTRATION_DATE` datetime NOT NULL 150306 14:07:15 22 Query select @@session.tx_read_only 22 Query UPDATE `JC_USER_DETAILS` SET `REGISTRATION_DATE` = NOW() 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('2', 'Add location and regdate to user', 'SQL', 'V2__Add_location_and_regdate_to_user.sql', -178589530, SUBSTRING_INDEX(USER(),'@',1), 937, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query update USERS set AVATAR = '' where AVATAR = NULL 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('3', 'Default avatar', 'SQL', 'V3__Default%20avatar.sql', 499140063, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `CONTACT_TYPE` ( `TYPE_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `TYPE` VARCHAR(255) NOT NULL, `ICON` VARCHAR(255) NOT NULL, PRIMARY KEY (`TYPE_ID`) ) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `USER_CONTACT` ( `CONTACT_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `VALUE` VARCHAR(255) COLLATE utf8_bin NOT NULL, `TYPE_ID` BIGINT(20) NOT NULL, `USER_ID` BIGINT(20) NOT NULL, PRIMARY KEY (`CONTACT_ID`), KEY `FK_USER` (`USER_ID`), KEY `FK_TYPE` (`TYPE_ID`), CONSTRAINT `FK_TYPE_REF` FOREIGN KEY (`TYPE_ID`) REFERENCES `CONTACT_TYPE` (`TYPE_ID`), CONSTRAINT `FK_USER_REF` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ) ENGINE=INNODB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('4', 'Add user contacts', 'SQL', 'V4__Add_user_contacts.sql', -816563147, SUBSTRING_INDEX(USER(),'@',1), 515, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `JC_USER_DETAILS` ADD `POST_COUNT` int NULL 150306 14:07:16 22 Query select @@session.tx_read_only 22 Query UPDATE `JC_USER_DETAILS` UD SET `POST_COUNT` = (SELECT COUNT(1) from `POST` WHERE `USER_CREATED` = UD.`USER_ID`) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('5', 'User post count', 'SQL', 'V5__User_post_count.sql', 122254442, SUBSTRING_INDEX(USER(),'@',1), 453, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table `acl_sid` charset "utf8" 22 Query select @@session.tx_read_only 22 Query alter table `acl_sid` modify `sid` varchar(100) charset "utf8" not null 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('6', 'Acl Sid encoding fix', 'SQL', 'V6__Acl_Sid_encoding_fix.sql', 1840705309, SUBSTRING_INDEX(USER(),'@',1), 110, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(1,'ICQ','/resources/images/iconOfUserContact/icq.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(2,'Skype','/resources/images/iconOfUserContact/skype.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(3,'Mail','/resources/images/iconOfUserContact/mail.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(4,'Telephone','/resources/images/iconOfUserContact/telephone.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(5,'Jabber','/resources/images/iconOfUserContact/jabber.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(6,'Facebook','/resources/images/iconOfUserContact/facebook.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(7,'Twitter','/resources/images/iconOfUserContact/twitter.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(8,'Google+','/resources/images/iconOfUserContact/google+.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(9,'Vkontakte','/resources/images/iconOfUserContact/vkontakte.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(10,'Odnoklassniki','/resources/images/iconOfUserContact/odnoklassniki.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(11,'Livejournal','/resources/images/iconOfUserContact/livejournal.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(12,'Tumblr','/resources/images/iconOfUserContact/tumblr.png') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` VALUES(13,'Blogger','/resources/images/iconOfUserContact/blogger.png') 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('7', 'Add any contact type', 'SQL', 'V7__Add_any_contact_type.sql', -83545317, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `JC_USER_DETAILS` ADD `ENABLED` bool DEFAULT FALSE 22 Query select @@session.tx_read_only 22 Query UPDATE `JC_USER_DETAILS` UD SET `ENABLED` = TRUE 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('8', 'Account activation status', 'SQL', 'V8__Account_activation_status.sql', 502288429, SUBSTRING_INDEX(USER(),'@',1), 437, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` DROP FOREIGN KEY `FK_USER_TO` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` MODIFY `USER_TO` bigint(20) 150306 14:07:17 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` MODIFY `TITLE` varchar(255) COLLATE utf8_bin 150306 14:07:18 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` MODIFY `BODY` longtext COLLATE utf8_bin 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('9', 'PM constraint removal', 'SQL', 'V9__PM_constraint_removal.sql', -804273584, SUBSTRING_INDEX(USER(),'@',1), 2015, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CONTACT_TYPE` ADD COLUMN `UUID` varchar(255) COLLATE utf8_bin NOT NULL 150306 14:07:19 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `USER_CONTACT` ADD COLUMN `UUID` varchar(255) COLLATE utf8_bin NOT NULL 22 Query select @@session.tx_read_only 22 Query UPDATE `CONTACT_TYPE` SET `UUID` = uuid() 22 Query select @@session.tx_read_only 22 Query UPDATE `USER_CONTACT` SET `UUID` = uuid() 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('10', 'UUID in contacts', 'SQL', 'V10__UUID_in_contacts.sql', -2018033147, SUBSTRING_INDEX(USER(),'@',1), 1016, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` ADD `READ_FLAG` bool DEFAULT FALSE NOT NULL 150306 14:07:20 22 Query select @@session.tx_read_only 22 Query TRUNCATE PRIVATE_MESSAGE 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('11', 'Private message read flag', 'SQL', 'V11__Private_message_read_flag.sql', -1894602641, SUBSTRING_INDEX(USER(),'@',1), 875, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `LAST_READ_POSTS` ( `TOPIC_ID` bigint(20) NOT NULL, `USER_ID` bigint(20) NOT NULL, `LAST_READ_POST_INDEX` int(11) NOT NULL, CONSTRAINT `FK_USER_READ_POSTS` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`), CONSTRAINT `FK_TOPIC_READ_POSTS` FOREIGN KEY (`TOPIC_ID`) REFERENCES `TOPIC` (`TOPIC_ID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:21 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('12', 'Last read posts', 'SQL', 'V12__Last_read_posts.sql', 497980850, SUBSTRING_INDEX(USER(),'@',1), 281, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query TRUNCATE LAST_READ_POSTS 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `LAST_READ_POSTS` ADD `ID` bigint(20) NOT NULL AUTO_INCREMENT, ADD `UUID` varchar(255) COLLATE utf8_bin NOT NULL, ADD PRIMARY KEY (`ID`) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('13', 'Last read post id and date', 'SQL', 'V13__Last_read_post_id_and_date.sql', -841645845, SUBSTRING_INDEX(USER(),'@',1), 859, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE LAST_READ_POSTS DROP FOREIGN KEY `FK_USER_READ_POSTS`, DROP FOREIGN KEY `FK_TOPIC_READ_POSTS` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE LAST_READ_POSTS ADD CONSTRAINT `FK_USER_READ_POSTS` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ON DELETE CASCADE, ADD CONSTRAINT `FK_TOPIC_READ_POSTS` FOREIGN KEY (`TOPIC_ID`) REFERENCES `TOPIC` (`TOPIC_ID`) ON DELETE CASCADE 150306 14:07:22 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('14', 'Last read posts cascades', 'SQL', 'V14__Last_read_posts_cascades.sql', -1703519259, SUBSTRING_INDEX(USER(),'@',1), 516, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO `SECTIONS`(`SECTION_ID`, `UUID`, `NAME`, `DESCRIPTION`, `POSITION`) SELECT `SECTION_ID`, `UUID`, `NAME`, `DESCRIPTION`, `POSITION` FROM `SECTION` 22 Query select @@session.tx_read_only 22 Query INSERT INTO `BRANCHES`(`BRANCH_ID`, `UUID`, `NAME`, `DESCRIPTION`, `POSITION`, `SECTION_ID`) SELECT `BRANCH_ID`, `UUID`, `NAME`, `DESCRIPTION`, `BRANCHES_INDEX`, `SECTION_ID` FROM `BRANCH` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` DROP FOREIGN KEY `FK_BRANCH` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `BRANCH` DROP FOREIGN KEY `FK_SECTION_REF` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `BRANCH_SUBSCRIPTIONS` DROP FOREIGN KEY `FK_BRANCH_SUB` 22 Query select @@session.tx_read_only 22 Query DROP TABLE `SECTION` 22 Query select @@session.tx_read_only 22 Query DROP TABLE `BRANCH` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` ADD CONSTRAINT `FK_BRANCH` FOREIGN KEY (`BRANCH_ID`) REFERENCES `BRANCHES` (`BRANCH_ID`) 150306 14:07:23 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `BRANCH_SUBSCRIPTIONS` ADD CONSTRAINT `FK_BRANCH_SUB` FOREIGN KEY (`BRANCH_ID`) REFERENCES `BRANCHES` (`BRANCH_ID`) 150306 14:07:24 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('15', 'Branches and sections integration with common', 'SQL', 'V15__Branches_and_sections_integration_with_common.sql', -1207573378, SUBSTRING_INDEX(USER(),'@',1), 2015, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` (`TYPE_ID`, `TYPE`, `ICON`, `UUID`) VALUES(14, 'AIM','/resources/images/iconOfUserContact/aim.png', uuid()) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` (`TYPE_ID`, `TYPE`, `ICON`, `UUID`) VALUES(15, 'YIM','/resources/images/iconOfUserContact/yim.png', uuid()) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` (`TYPE_ID`, `TYPE`, `ICON`, `UUID`) VALUES(16, 'MSN','/resources/images/iconOfUserContact/msn.png', uuid()) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `CONTACT_TYPE` (`TYPE_ID`, `TYPE`, `ICON`, `UUID`) VALUES(17, 'Website','/resources/images/iconOfUserContact/site.png', uuid()) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('16', 'Add contact types', 'SQL', 'V16__Add_contact_types.sql', -1873732543, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE CONTACT_TYPE ADD MASK VARCHAR(50) NOT NULL DEFAULT '', ADD DISPLAY_PATTERN VARCHAR(255) NOT NULL DEFAULT '%s', ADD VALIDATION_PATTERN VARCHAR(255) NOT NULL DEFAULT '.+' 150306 14:07:25 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='000111222', VALIDATION_PATTERN='^([0-9]){5,9}$' WHERE TYPE_ID = 1 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='skypename', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[-\\.\\w]{6,30}$' WHERE TYPE_ID = 2 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='mail@server.com', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^([a-z0-9_\\.-]+)@([\\da-z\\._-]+)\\.([a-z]{2,6})$' WHERE TYPE_ID = 3 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='+38.0672345678', VALIDATION_PATTERN='^\\+[0-9]{1,3}\\.[0-9]{4,14}(?:x.+)?$' WHERE TYPE_ID = 4 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='vanya@gmail.com', VALIDATION_PATTERN='^(?:([^@/<>\'\"]+)@)?([^@/<>\'\"]+)(?:/([^<>\'\"]*))?$' WHERE TYPE_ID = 5 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='facebook.name', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[A-Za-z\\d.]{5,}$' WHERE TYPE_ID = 6 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='twitter_name', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[\\w]+$' WHERE TYPE_ID = 7 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='mail@gmail.com', VALIDATION_PATTERN='^([a-z0-9_\\.-]+)@gmail.com$' WHERE TYPE_ID = 8 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='id123456', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^id[\\d]+$' WHERE TYPE_ID = 9 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='12423632', DISPLAY_PATTERN='http://www.odnoklassniki.ru/profile/%s', VALIDATION_PATTERN='^[\\d]+$' WHERE TYPE_ID = 10 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='user-name.livejournal.com', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[A-Za-z0-9-]+\\.livejournal\\.com' WHERE TYPE_ID = 11 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='user-name.tumblr.com', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[A-Za-z0-9-]+\\.tumblr\\.com' WHERE TYPE_ID = 12 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='user-name.blogspot.com', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^[A-Za-z0-9-]+\\.blogspot\\.com' WHERE TYPE_ID = 13 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='aim@server.com', VALIDATION_PATTERN='^([a-z0-9_\\.-]+)@([\\da-z\\._-]+)\\.([a-z]{2,6})$' WHERE TYPE_ID = 14 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='yim@server.com', VALIDATION_PATTERN='^([a-z0-9_\\.-]+)@([\\da-z\\._-]+)\\.([a-z]{2,6})$' WHERE TYPE_ID = 15 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='msn@server.com', VALIDATION_PATTERN='^([a-z0-9_\\.-]+)@([\\da-z\\._-]+)\\.([a-z]{2,6})$' WHERE TYPE_ID = 16 22 Query select @@session.tx_read_only 22 Query UPDATE CONTACT_TYPE SET MASK='http://site-name.domain.com', DISPLAY_PATTERN='%s', VALIDATION_PATTERN='^(https?:\\/\\/)([\\da-z\\.-]+)\\.([a-z]{2,6})([\\/\\w \\.-]*)*\\/?$' WHERE TYPE_ID = 17 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('17', 'Contact types validation', 'SQL', 'V17__Contact_types_validation.sql', 165241157, SUBSTRING_INDEX(USER(),'@',1), 437, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query # skype UPDATE CONTACT_TYPE SET DISPLAY_PATTERN='%s' WHERE TYPE_ID = 2 22 Query select @@session.tx_read_only 22 Query #phone number UPDATE CONTACT_TYPE SET MASK='+380672345678', VALIDATION_PATTERN='^\\+[0-9]{5,20}$' WHERE TYPE_ID = 4 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('18', 'Contact types improvements', 'SQL', 'V18__Contact_types_improvements.sql', 219435721, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `JC_USER_DETAILS` CHANGE `SIGNATURE` `SIGNATURE` TEXT 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('19', 'JCUser details signature', 'SQL', 'V19__JCUser_details_signature.sql', -1708917975, SUBSTRING_INDEX(USER(),'@',1), 609, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `POLLS` ( `POLL_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `TITLE` VARCHAR(255) NOT NULL, `ENDING_DATE` DATETIME, `SINGLE_ANSWER` TINYINT(1) NOT NULL DEFAULT '1', PRIMARY KEY (`POLL_ID`), UNIQUE KEY `UUID` (`UUID`), CONSTRAINT `SHARED_PK_POLL_TOPIC` FOREIGN KEY (`POLL_ID`) REFERENCES `TOPIC` (`TOPIC_ID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `POLL_OPTIONS` ( `PO_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `NAME` VARCHAR(255) NOT NULL, `LIST_INDEX` INT(11) DEFAULT NULL, `VOTES_COUNT` INT(11) NOT NULL DEFAULT '0', `POLL_ID` BIGINT(20) DEFAULT NULL, PRIMARY KEY (`PO_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_POLL` (`POLL_ID`), CONSTRAINT `FK_POLL` FOREIGN KEY (`POLL_ID`) REFERENCES `POLLS` (`POLL_ID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:26 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('20', 'Add poll', 'SQL', 'V20__Add_poll.sql', -1999166509, SUBSTRING_INDEX(USER(),'@',1), 437, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO GROUPS (`UUID`, `NAME`, `DESCRIPTION`) SELECT (SELECT UUID() FROM dual),'Administrators', 'Administrators group.' FROM dual WHERE NOT EXISTS (SELECT gr.GROUP_ID FROM GROUPS gr WHERE gr.NAME='Administrators') 22 Query select @@session.tx_read_only 22 Query INSERT INTO GROUPS (`UUID`, `NAME`, `DESCRIPTION`) SELECT (SELECT UUID() FROM dual),'Registered Users', 'The group for all registered users.' FROM dual WHERE NOT EXISTS (SELECT gr.GROUP_ID FROM GROUPS gr WHERE gr.NAME='Registered Users') 22 Query select @@session.tx_read_only 22 Query INSERT INTO GROUPS (`UUID`, `NAME`, `DESCRIPTION`) SELECT (SELECT UUID() FROM dual),'Banned Users', 'The group for banned users.' FROM dual WHERE NOT EXISTS (SELECT gr.GROUP_ID FROM GROUPS gr WHERE gr.NAME='Banned Users') 22 Query SET @admin_group_sid := concat('usergroup:',(select GROUP_ID from GROUPS where `NAME`='Administrators')) 22 Query SET @registered_group_sid := concat('usergroup:',(select GROUP_ID from GROUPS where `NAME`='Registered Users')) 22 Query SET @banned_group_sid := concat('usergroup:',(select GROUP_ID from GROUPS where `NAME`='Banned Users')) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `acl_sid`(`principal`,`sid`) SELECT 1, 'user:anonymousUser' FROM dual WHERE NOT EXISTS (SELECT * FROM `acl_sid` WHERE sid='user:anonymousUser') 22 Query select @@session.tx_read_only 22 Query INSERT INTO `acl_sid`(`principal`,`sid`) SELECT 0, @admin_group_sid FROM dual WHERE NOT EXISTS (SELECT * FROM `acl_sid` WHERE `sid`=@admin_group_sid) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `acl_sid`(`principal`,`sid`) SELECT 0, @registered_group_sid FROM dual WHERE NOT EXISTS (SELECT * FROM `acl_sid` WHERE `sid`=@registered_group_sid) 22 Query select @@session.tx_read_only 22 Query INSERT INTO `acl_sid`(`principal`,`sid`) SELECT 0, @banned_group_sid FROM dual WHERE NOT EXISTS (SELECT * FROM `acl_sid` WHERE `sid`=@banned_group_sid) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('21', 'Add predefined groups', 'SQL', 'V21__Add_predefined_groups.sql', -627465892, SUBSTRING_INDEX(USER(),'@',1), 47, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POLLS CHANGE `SINGLE_ANSWER` `MULTIPLE_ANSWER` TINYINT(1) NOT NULL DEFAULT '0' 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('22', 'Renamed column in poll', 'SQL', 'V22__Renamed_column_in_poll.sql', -1223896890, SUBSTRING_INDEX(USER(),'@',1), 47, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query SELECT UUID() FROM dual 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('23', 'Add md5 encrypt existing passwords', 'SQL', 'V23__Add_md5_encrypt_existing_passwords.sql', 617063670, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE TOPIC DROP FOREIGN KEY FK_BRANCH 22 Query select @@session.tx_read_only 22 Query ALTER TABLE TOPIC ADD CONSTRAINT FK_BRANCH FOREIGN KEY (BRANCH_ID) REFERENCES BRANCHES (BRANCH_ID) ON DELETE CASCADE 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POST DROP FOREIGN KEY FK_TOPIC 150306 14:07:27 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POST ADD CONSTRAINT FK_TOPIC FOREIGN KEY (TOPIC_ID) REFERENCES TOPIC (TOPIC_ID) ON DELETE CASCADE 22 Query select @@session.tx_read_only 22 Query ALTER TABLE TOPIC_SUBSCRIPTIONS DROP FOREIGN KEY FK_TOPIC_SUB 150306 14:07:28 22 Query select @@session.tx_read_only 22 Query ALTER TABLE TOPIC_SUBSCRIPTIONS ADD CONSTRAINT FK_TOPIC_SUB FOREIGN KEY (TOPIC_ID) REFERENCES TOPIC (TOPIC_ID) ON DELETE CASCADE 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POLLS DROP FOREIGN KEY SHARED_PK_POLL_TOPIC 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POLLS ADD CONSTRAINT SHARED_PK_POLL_TOPIC FOREIGN KEY (POLL_ID) REFERENCES TOPIC (TOPIC_ID) ON DELETE CASCADE 150306 14:07:29 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POLL_OPTIONS DROP FOREIGN KEY FK_POLL 22 Query select @@session.tx_read_only 22 Query ALTER TABLE POLL_OPTIONS ADD CONSTRAINT FK_POLL FOREIGN KEY (POLL_ID) REFERENCES POLLS (POLL_ID) ON DELETE CASCADE 150306 14:07:30 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('24', 'Branches children cascade deletion', 'SQL', 'V24__Branches_children_cascade_deletion.sql', -685873185, SUBSTRING_INDEX(USER(),'@',1), 3734, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` DROP COLUMN `TOPIC_WEIGHT` 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('25', 'Delete topic weight', 'SQL', 'V25__Delete_topic_weight.sql', 1798812406, SUBSTRING_INDEX(USER(),'@',1), 547, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `PRIVATE_MESSAGE` CHANGE COLUMN `USER_TO` `USER_TO` BIGINT(20) NULL 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('26', 'Private messages userto null', 'SQL', 'V26__Private_messages_userto_null.sql', -737063870, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` ADD `CLOSED` bool DEFAULT FALSE 150306 14:07:31 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('27', 'Closed topic flag', 'SQL', 'V27__Closed_topic_flag.sql', 542120433, SUBSTRING_INDEX(USER(),'@',1), 563, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `SIMPLE_PAGES` ( `PAGE_ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `NAME` varchar(64) COLLATE utf8_bin NOT NULL, `PATH_NAME` varchar(64) COLLATE utf8_bin NOT NULL UNIQUE, `CONTENT` longtext COLLATE utf8_bin NOT NULL, PRIMARY KEY (`PAGE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('28', 'Simple pages table', 'SQL', 'V28__Simple_pages_table.sql', -1242640368, SUBSTRING_INDEX(USER(),'@',1), 250, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO `SIMPLE_PAGES` (`UUID`, `NAME`, `PATH_NAME`, `CONTENT`) VALUES (uuid(), 'Title', 'for_newbies', 'Nothing here') 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('29', 'Insert empty simple page', 'SQL', 'V29__Insert_empty_simple_page.sql', -1706526265, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE VIEW BRANCHES_VIEW_TOPICS AS SELECT acl_entry.id, BRANCHES.BRANCH_ID, GROUPS.GROUP_ID FROM acl_entry, acl_object_identity, acl_class ,acl_sid, BRANCHES, GROUPS WHERE acl_entry.mask=6 AND acl_entry.granting=1 AND acl_object_identity.id=acl_entry.acl_object_identity AND acl_class.id=acl_object_identity.object_id_class AND acl_class.class='BRANCH' AND BRANCHES.BRANCH_ID=acl_object_identity.object_id_identity AND acl_entry.sid=acl_sid.id AND acl_sid.sid LIKE 'usergroup:%' AND GROUPS.GROUP_ID=SUBSTRING(acl_sid.sid,LENGTH('usergroup:')+1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('30', 'Views', 'SQL', 'V30__Views.sql', -110073031, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query DROP VIEW BRANCHES_VIEW_TOPICS 22 Query select @@session.tx_read_only 22 Query CREATE VIEW BRANCHES_VIEW_TOPICS AS SELECT acl_entry.id AS ID, BRANCHES.BRANCH_ID, SUBSTRING(acl_sid.sid,INSTR(acl_sid.sid,":")+1) AS SID FROM acl_entry, acl_object_identity, acl_class ,acl_sid, BRANCHES WHERE acl_entry.mask=6 AND acl_entry.granting=1 AND acl_object_identity.id=acl_entry.acl_object_identity AND acl_class.id=acl_object_identity.object_id_class AND acl_class.class='BRANCH' AND BRANCHES.BRANCH_ID=acl_object_identity.object_id_identity AND acl_sid.id=acl_entry.sid AND (acl_sid.sid LIKE 'usergroup:%' OR acl_sid.sid LIKE 'user:anonymousUser') 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('31', 'Rollback Views and create Branches view topics', 'SQL', 'V31__Rollback_Views_and_create_Branches_view_topics.sql', 1556877349, SUBSTRING_INDEX(USER(),'@',1), 47, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE BRANCH_SUBSCRIPTIONS DROP FOREIGN KEY FK_BRANCH_SUB 22 Query select @@session.tx_read_only 22 Query ALTER TABLE BRANCH_SUBSCRIPTIONS ADD CONSTRAINT FK_BRANCH_SUB FOREIGN KEY (BRANCH_ID) REFERENCES BRANCHES (BRANCH_ID) ON DELETE CASCADE 150306 14:07:32 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('32', 'Cascade for branch subscriptions', 'SQL', 'V32__Cascade_for_branch_subscriptions.sql', 378031377, SUBSTRING_INDEX(USER(),'@',1), 531, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE VIEW COUNT_POSTS_TOPICS_VIEW AS SELECT tp.TOPIC_ID, tp.BRANCH_ID, COUNT(*)-1 as POSTS_COUNT FROM TOPIC tp join POST p ON p.TOPIC_ID=tp.TOPIC_ID group by tp.TOPIC_ID 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('33', 'View topics posts count', 'SQL', 'V33__View_topics_posts_count.sql', -1838482521, SUBSTRING_INDEX(USER(),'@',1), 47, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table TOPIC add(POLL_ID bigint(10)) 150306 14:07:33 21 Query select @@session.tx_read_only 21 Query alter table TOPIC add constraint TOPIC_POLL_FK foreign key(POLL_ID) references POLLS(POLL_ID) 21 Query select @@session.tx_read_only 21 Query update TOPIC, POLLS set TOPIC.POLL_ID=POLLS.POLL_ID where TOPIC.TOPIC_ID=POLLS.POLL_ID 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('34', 'Add POLL ID to TOPIC', 'SQL', 'V34__Add_POLL_ID_to_TOPIC.sql', 1387747889, SUBSTRING_INDEX(USER(),'@',1), 1297, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query alter table POLLS drop foreign key SHARED_PK_POLL_TOPIC 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('35', 'DROP POLL TOPIC FK', 'SQL', 'V35__DROP_POLL_TOPIC_FK.sql', 264499674, SUBSTRING_INDEX(USER(),'@',1), 63, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE `JC_USER_DETAILS` ADD COLUMN `AVATAR_LAST_MODIFICATION_TIME` DATETIME NULL DEFAULT NULL 150306 14:07:35 21 Query select @@session.tx_read_only 21 Query UPDATE `JC_USER_DETAILS` SET `AVATAR_LAST_MODIFICATION_TIME` = NOW() 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('36', 'Avatar last modification time', 'SQL', 'V36__Avatar_last_modification_time.sql', 1023222300, SUBSTRING_INDEX(USER(),'@',1), 1110, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE `JC_USER_DETAILS` CHANGE COLUMN `PAGE_SIZE` `PAGE_SIZE` INT(11) NULL DEFAULT '15' 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('37', 'Updated default page size', 'SQL', 'V37__Updated_default_page_size.sql', 1457915808, SUBSTRING_INDEX(USER(),'@',1), 78, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query DROP VIEW BRANCHES_VIEW_TOPICS 21 Query select @@session.tx_read_only 21 Query CREATE VIEW BRANCHES_VIEW_TOPICS AS SELECT acl_entry.id AS ID, BRANCHES.BRANCH_ID, SUBSTRING(acl_sid.sid,INSTR(acl_sid.sid,":")+1) AS SID, acl_entry.granting AS GRANTING FROM acl_entry, acl_object_identity, acl_class ,acl_sid, BRANCHES WHERE acl_entry.mask=6 AND acl_object_identity.id=acl_entry.acl_object_identity AND acl_class.id=acl_object_identity.object_id_class AND acl_class.class='BRANCH' AND BRANCHES.BRANCH_ID=acl_object_identity.object_id_identity AND acl_sid.id=acl_entry.sid AND (acl_sid.sid LIKE 'usergroup:%' OR acl_sid.sid LIKE 'user:anonymousUser') 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('38', 'Rollback Branches view topics and create new Branches view topics', 'SQL', 'V38__Rollback_Branches_view_topics_and_create_new_Branches_view_topics.sql', -97835311, SUBSTRING_INDEX(USER(),'@',1), 94, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE BRANCHES ADD LAST_POST BIGINT(20) DEFAULT NULL 150306 14:07:36 21 Query select @@session.tx_read_only 21 Query ALTER TABLE BRANCHES ADD CONSTRAINT BRANCH_LAST_POST_FK FOREIGN KEY(LAST_POST) REFERENCES POST(POST_ID) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('39', 'Branch last updated post', 'SQL', 'V39__Branch_last_updated_post.sql', -578904231, SUBSTRING_INDEX(USER(),'@',1), 1406, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query UPDATE BRANCHES SET LAST_POST = ( SELECT POST.POST_ID FROM POST INNER JOIN ( SELECT TOPIC.BRANCH_ID, MAX(POST.POST_DATE) as LAST_POST_TIME FROM POST INNER JOIN TOPIC ON TOPIC.TOPIC_ID = POST.TOPIC_ID GROUP BY TOPIC.BRANCH_ID ) AS STATISTICS ON POST.POST_DATE = STATISTICS.LAST_POST_TIME WHERE BRANCHES.BRANCH_ID = STATISTICS.BRANCH_ID ) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('40', 'Update last post in exist branches', 'SQL', 'V40__Update_last_post_in_exist_branches.sql', 1459975447, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `CODE_REVIEWS` ( `CODE_REVIEW_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, PRIMARY KEY (`CODE_REVIEW_ID`), UNIQUE KEY `UUID` (`UUID`) ) ENGINE=InnoDb DEFAULT CHARSET='utf8' COLLATE='utf8_bin' 150306 14:07:37 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `CODE_REVIEW_COMMENTS` ( `COMMENT_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `LIST_INDEX` INT(11) DEFAULT NULL, `COMMENT` LONGTEXT NOT NULL, `LINE_NUMBER` INT NOT NULL, `AUTHOR` BIGINT(20) NOT NULL, `CODE_REVIEW_ID` BIGINT(20) NULL DEFAULT NULL, PRIMARY KEY (`COMMENT_ID`), UNIQUE INDEX `UUID` (`UUID`), INDEX `FK_CRC_CODE_REVIEW` (`CODE_REVIEW_ID`), INDEX `FK_CRC_AUTHOR` (`AUTHOR`), CONSTRAINT `FK_CRC_CODE_REVIEW` FOREIGN KEY (`CODE_REVIEW_ID`) REFERENCES `CODE_REVIEWS` (`CODE_REVIEW_ID`) ON DELETE CASCADE, CONSTRAINT `FK_CRC_AUTHOR` FOREIGN KEY (`AUTHOR`) REFERENCES `USERS` (`ID`) ) ENGINE=InnoDb DEFAULT CHARSET='utf8' COLLATE='utf8_bin' 21 Query select @@session.tx_read_only 21 Query ALTER TABLE TOPIC ADD(CODE_REVIEW_ID bigint(20)) 150306 14:07:38 21 Query select @@session.tx_read_only 21 Query ALTER TABLE TOPIC ADD CONSTRAINT TOPIC_CODE_REVIEW_FK FOREIGN KEY(CODE_REVIEW_ID) REFERENCES CODE_REVIEWS(CODE_REVIEW_ID) 150306 14:07:39 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('41', 'Adding code review tables', 'SQL', 'V41__Adding_code_review_tables.sql', 1656312285, SUBSTRING_INDEX(USER(),'@',1), 2063, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` DROP FOREIGN KEY `FK_CRC_CODE_REVIEW` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` DROP FOREIGN KEY `TOPIC_CODE_REVIEW_FK` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEWS` CHANGE COLUMN `CODE_REVIEW_ID` `CR_ID` BIGINT(20) NOT NULL AUTO_INCREMENT FIRST 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `TOPIC` ADD CONSTRAINT `FK_TOPIC_CODE_REVIEW` FOREIGN KEY (`CODE_REVIEW_ID`) REFERENCES `CODE_REVIEWS` (`CR_ID`) 150306 14:07:40 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` ADD CONSTRAINT `FK_CRC_CODE_REVIEW` FOREIGN KEY (`CODE_REVIEW_ID`) REFERENCES `CODE_REVIEWS` (`CR_ID`) 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` DROP FOREIGN KEY `FK_CRC_AUTHOR` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` ALTER `AUTHOR` DROP DEFAULT 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` CHANGE COLUMN `AUTHOR` `AUTHOR_ID` BIGINT(20) NOT NULL AFTER `LINE_NUMBER` 22 Query select @@session.tx_read_only 150306 14:07:41 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` ADD CONSTRAINT `FK_CRC_AUTHOR` FOREIGN KEY (`AUTHOR_ID`) REFERENCES `USERS` (`ID`) 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` CHANGE COLUMN `COMMENT` `BODY` LONGTEXT NOT NULL COLLATE 'utf8_bin' AFTER `LIST_INDEX` 22 Query select @@session.tx_read_only 22 Query ALTER TABLE `CODE_REVIEW_COMMENTS` ADD COLUMN `CREATION_DATE` DATETIME NOT NULL AFTER `BODY`, DROP COLUMN `LIST_INDEX` 150306 14:07:42 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('42', 'Renaming code review columns', 'SQL', 'V42__Renaming_code_review_columns.sql', 941454330, SUBSTRING_INDEX(USER(),'@',1), 3110, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `CODE_REVIEW_SUBSCRIBER` ( `CR_ID` BIGINT(20) NOT NULL, `USER_ID` BIGINT(20) NOT NULL, KEY `FK_USER` (`USER_ID`), KEY `FK_CODE_REVIEW` (`CR_ID`), CONSTRAINT `FK_CODE_REVIEW_SUBSCRIBER` FOREIGN KEY (`CR_ID`) REFERENCES `CODE_REVIEWS` (`CR_ID`), CONSTRAINT `FK_USER_CODE_REVIEW_SUBSCRIBER` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('43', 'Added CR subscriber', 'SQL', 'V43__Added_CR_subscriber.sql', -116863223, SUBSTRING_INDEX(USER(),'@',1), 297, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query DROP TABLE `CODE_REVIEW_SUBSCRIBER` 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('44', 'Unused code review subscriber table removed', 'SQL', 'V44__Unused_code_review_subscriber_table_removed.sql', 37467714, SUBSTRING_INDEX(USER(),'@',1), 141, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query UPDATE USERS, JC_USER_DETAILS set USERS.ENABLED = JC_USER_DETAILS.ENABLED WHERE USERS.ID = JC_USER_DETAILS.USER_ID 22 Query select @@session.tx_read_only 22 Query ALTER TABLE JC_USER_DETAILS DROP COLUMN ENABLED 150306 14:07:43 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('45', 'Column ENABLED deleted from JC USER DETAILS', 'SQL', 'V45__Column_ENABLED_deleted_from_JC_USER_DETAILS.sql', -2051303896, SUBSTRING_INDEX(USER(),'@',1), 422, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE EXTERNAL_LINK ( LINK_ID BIGINT(20) NOT NULL AUTO_INCREMENT, UUID VARCHAR(255) NOT NULL, URL VARCHAR(255) NOT NULL, TITLE VARCHAR(255) NOT NULL, HINT VARCHAR(255) NOT NULL, PRIMARY KEY (LINK_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 22 Query select @@session.tx_read_only 22 Query UPDATE EXTERNAL_LINK SET UUID = uuid() 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('46', 'Added EXTERNAL LINK table', 'SQL', 'V46__Added_EXTERNAL_LINK_table.sql', -51611587, SUBSTRING_INDEX(USER(),'@',1), 297, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 21 Query SET autocommit=0 21 Query select * from jtalks.jcommune_schema_version for update 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 21 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 21 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SET autocommit=0 22 Query select @@session.tx_read_only 22 Query CREATE TABLE `BANNER` ( `ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `POSITION` VARCHAR(255) NOT NULL, `CONTENT` LONGTEXT NOT NULL, PRIMARY KEY (`ID`), UNIQUE INDEX `UUID` (`UUID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 21 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 21 Query select @@session.tx_read_only 21 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('47', 'Add HTML and JS banners', 'SQL', 'V47__Add_HTML_and_JS_banners.sql', 1751780575, SUBSTRING_INDEX(USER(),'@',1), 516, 'SUCCESS', 1) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query alter table PROPERTIES modify VALIDATION_RULE varchar(255) default NULL 150306 14:07:44 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('48', 'Add default value for properties validation', 'SQL', 'V48__Add_default_value_for_properties_validation.sql', 1280624286, SUBSTRING_INDEX(USER(),'@',1), 703, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE JC_USER_DETAILS ADD(ALL_FORUM_MARKED_AS_READ_TIME DATETIME) 150306 14:07:45 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('49', 'JCUser mark all forum as read time', 'SQL', 'V49__JCUser_mark_all_forum_as_read_time.sql', 478238955, SUBSTRING_INDEX(USER(),'@',1), 562, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE JC_USER_DETAILS ADD(AUTOSUBSCRIBE TINYINT(1) DEFAULT 1) 21 Query select @@session.tx_read_only 21 Query UPDATE JC_USER_DETAILS SET AUTOSUBSCRIBE=1 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('50', 'JCUser autosubscribe', 'SQL', 'V50__JCUser_autosubscribe.sql', -785170823, SUBSTRING_INDEX(USER(),'@',1), 625, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE JC_USER_DETAILS ADD(MENTIONING_NOTIFICATIONS_ENABLED TINYINT(1) DEFAULT 1) 150306 14:07:46 21 Query select @@session.tx_read_only 21 Query UPDATE JC_USER_DETAILS SET MENTIONING_NOTIFICATIONS_ENABLED=1 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('51', 'JCUser mentioning in forum setting', 'SQL', 'V51__JCUser_mentioning_in_forum_setting.sql', -1550012379, SUBSTRING_INDEX(USER(),'@',1), 515, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE POST DROP COLUMN LIST_INDEX 150306 14:07:47 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('52', 'Deleted LIST INDEX from POST', 'SQL', 'V52__Deleted_LIST_INDEX_from_POST.sql', -1258644872, SUBSTRING_INDEX(USER(),'@',1), 594, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `PLUGIN` ( `ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `NAME` VARCHAR(255) NOT NULL, `IS_ACTIVE` TINYINT(1) NOT NULL, PRIMARY KEY (`ID`), UNIQUE INDEX `UUID` (`UUID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `PLUGIN_PROPERTY` ( `ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `TYPE` VARCHAR(255) NOT NULL, `VALUE` VARCHAR(255) NOT NULL, `LIST_INDEX` INT(11) DEFAULT NULL, `PLUGIN_ID` BIGINT(20) NULL DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE INDEX `UUID` (`UUID`), KEY `FK_PLUGIN` (`PLUGIN_ID`), CONSTRAINT `FK_PLUGIN` FOREIGN KEY (`PLUGIN_ID`) REFERENCES `PLUGIN` (`ID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('53', 'Plugins', 'SQL', 'V53__Plugins.sql', -1415145567, SUBSTRING_INDEX(USER(),'@',1), 641, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE PLUGIN_PROPERTY ADD COLUMN NAME VARCHAR(255) NOT NULL 150306 14:07:48 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('54', 'Plugins configuration property add name', 'SQL', 'V54__Plugins_configuration_property_add_name.sql', 161964431, SUBSTRING_INDEX(USER(),'@',1), 484, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query update EXTERNAL_LINK set hint=title where hint is null or length(trim(hint))=0 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('55', 'Update hint for External links', 'SQL', 'V55__Update_hint_for_External_links.sql', -1131850058, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE USERS DROP COLUMN REGISTRATION_DATE 150306 14:07:49 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('56', 'Remove column REGISTRATION DATE from Users', 'SQL', 'V56__Remove_column_REGISTRATION_DATE_from_Users.sql', -720184020, SUBSTRING_INDEX(USER(),'@',1), 797, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE JC_USER_DETAILS ADD(SEND_PM_NOTIFICATION TINYINT(1) DEFAULT 1) 21 Query select @@session.tx_read_only 21 Query UPDATE JC_USER_DETAILS SET SEND_PM_NOTIFICATION=1 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('57', 'Add column SEND PM NOTIFICATION to Users', 'SQL', 'V57__Add_column_SEND_PM_NOTIFICATION_to_Users.sql', 1919891589, SUBSTRING_INDEX(USER(),'@',1), 422, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE LAST_READ_POSTS ADD(LAST_READ_POST_DATE DATETIME not null) 150306 14:07:50 21 Query select @@session.tx_read_only 21 Query DELETE FROM LAST_READ_POSTS WHERE LAST_READ_POST_INDEX < 0 21 Query select @@session.tx_read_only 21 Query UPDATE LAST_READ_POSTS SET LAST_READ_POST_DATE = ( SELECT POST_DATE FROM POST P1 WHERE P1.TOPIC_ID=LAST_READ_POSTS.TOPIC_ID AND LAST_READ_POST_INDEX = (SELECT count(1) FROM POST P2 WHERE P2.TOPIC_ID = P1.TOPIC_ID and P2.POST_DATE < P1.POST_DATE ) ) 21 Query select @@session.tx_read_only 21 Query ALTER TABLE LAST_READ_POSTS CHANGE COLUMN `LAST_READ_POST_INDEX` `LAST_READ_POST_INDEX` INT(11) NULL 21 Query select @@session.tx_read_only 21 Query DROP VIEW IF EXISTS COUNT_POSTS_TOPICS_VIEW 21 Query select @@session.tx_read_only 21 Query CREATE VIEW COUNT_POSTS_TOPICS_VIEW AS SELECT tp.TOPIC_ID, tp.BRANCH_ID, MAX(POST_DATE) as LAST_POST_DATE FROM TOPIC tp join POST p ON p.TOPIC_ID=tp.TOPIC_ID group by tp.TOPIC_ID 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('58', 'Add column for last read post date', 'SQL', 'V58__Add_column_for_last_read_post_date.sql', 273887255, SUBSTRING_INDEX(USER(),'@',1), 1078, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE LAST_READ_POSTS DROP LAST_READ_POST_INDEX 150306 14:07:51 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('59', 'Remove column last read post idex', 'SQL', 'V59__Remove_column_last_read_post_idex.sql', 181960951, SUBSTRING_INDEX(USER(),'@',1), 485, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query ALTER TABLE PLUGIN_PROPERTY ADD(HINT varchar(255) DEFAULT null) 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('60', 'Add column HINT to PLUGIN PROPERTY', 'SQL', 'V60__Add_column_HINT_to_PLUGIN_PROPERTY.sql', -676008995, SUBSTRING_INDEX(USER(),'@',1), 500, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query CREATE TABLE `MARK_BRANCH_AS_READ_TIME` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `UUID` varchar(255) COLLATE utf8_bin NOT NULL, `USER_ID` bigint(20) NOT NULL, `BRANCH_ID` bigint(20) NOT NULL, `MARKED_AS_READ_TIME` DATETIME NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UUID` (`UUID`), UNIQUE KEY (`USER_ID`, `BRANCH_ID`), CONSTRAINT `FK_USER_READER` FOREIGN KEY (`USER_ID`) REFERENCES `USERS` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_READED_BRANCH` FOREIGN KEY (`BRANCH_ID`) REFERENCES `BRANCHES` (`BRANCH_ID`) ON DELETE CASCADE ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 150306 14:07:52 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('62', 'Add mark branch as read time', 'SQL', 'V62__Add_mark_branch_as_read_time.sql', -1830072759, SUBSTRING_INDEX(USER(),'@',1), 313, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query create table POST_COMMENT ( ID bigint (20) not null auto_increment, UUID varchar(255) not null, BODY longtext not null, CREATION_DATE datetime not null, AUTHOR_ID bigint(20) not null, POST_ID bigint(20) not null, primary key (ID), constraint FK_COMMENT_POST foreign key (POST_ID) references POST (POST_ID) on delete cascade, constraint FK_COMMENT_AUTHOR foreign key (AUTHOR_ID) references USERS (ID) )engine=InnoDb default charset='utf8' collate='utf8_bin' 21 Query select @@session.tx_read_only 21 Query insert into POST_COMMENT (UUID, BODY, CREATION_DATE, AUTHOR_ID, POST_ID) select UUID, BODY, CREATION_DATE, AUTHOR_ID, (select POST_ID from POST p join TOPIC t on t.TOPIC_ID = p.TOPIC_ID where t.CODE_REVIEW_ID=crc.CODE_REVIEW_ID) from CODE_REVIEW_COMMENTS crc 21 Query select @@session.tx_read_only 21 Query create table TOPIC_ATTRIBUTE ( ID bigint(20) not null auto_increment, NAME varchar(255) not null, VALUE longtext not null, TOPIC_ID bigint(20) not null, primary key (ID), unique key (NAME, TOPIC_ID), constraint FK_TOPIC_ATTRIBUTE foreign key (TOPIC_ID) references TOPIC (TOPIC_ID) on delete cascade )engine=InnoDb default charset='utf8' collate='utf8_bin' 21 Query select @@session.tx_read_only 21 Query create table COMMENT_ATTRIBUTE ( ID bigint(20) not null auto_increment, NAME varchar(255) not null, VALUE longtext not null, COMMENT_ID bigint(20) not null, primary key (ID), unique key (NAME, COMMENT_ID), constraint FK_COMMENT_ATTRIBUTE foreign key (COMMENT_ID) references POST_COMMENT (ID) on delete cascade )engine=InnoDb default charset='utf8' collate='utf8_bin' 21 Query select @@session.tx_read_only 21 Query alter table POST add RATING int default 0 150306 14:07:53 21 Query select @@session.tx_read_only 21 Query alter table TOPIC add TYPE varchar(255) 150306 14:07:54 21 Query select @@session.tx_read_only 21 Query update TOPIC set TYPE = 'Discussion' where CODE_REVIEW_ID is null 21 Query select @@session.tx_read_only 21 Query update TOPIC set TYPE = 'Code review' where CODE_REVIEW_ID is not null 21 Query select @@session.tx_read_only 21 Query alter table TOPIC modify TYPE varchar(255) not null 150306 14:07:55 21 Query select @@session.tx_read_only 21 Query insert into COMMENT_ATTRIBUTE (NAME, VALUE, COMMENT_ID) select 'line_number', CAST(LINE_NUMBER as char(255)), (select ID from POST_COMMENT pc join POST p on pc.POST_ID = p.POST_ID join TOPIC t on p.TOPIC_ID = t.TOPIC_ID where t.CODE_REVIEW_ID = crc.CODE_REVIEW_ID and crc.UUID = pc.UUID) from CODE_REVIEW_COMMENTS crc 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('63', 'Prepare topics for using in plugins', 'SQL', 'V63__Prepare_topics_for_using_in_plugins.sql', 1635004849, SUBSTRING_INDEX(USER(),'@',1), 2860, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query select @@session.tx_read_only 21 Query create table POST_VOTE ( ID bigint(20) not null auto_increment, UUID varchar(255) not null, USER_ID bigint(20) not null, POST_ID bigint(20) not null, VOTE_DATE datetime not null, IS_VOTED_UP tinyint(1) not null, primary key(ID), unique key (USER_ID, POST_ID), constraint FK_VOTED_USER foreign key (USER_ID) references USERS (ID), constraint FK_VOTE_POST foreign key (POST_ID) references POST (POST_ID) on delete cascade )engine=InnoDb default charset='utf8' collate='utf8_bin' 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('64', 'Added POST VOTE table', 'SQL', 'V64__Added_POST_VOTE_table.sql', 323432171, SUBSTRING_INDEX(USER(),'@',1), 234, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 21 Query SET autocommit=0 21 Query set @adminUserName := 'admin' 21 Query set @adminPassword := 'admin' 21 Query set @adminGroupName := 'Administrators' 21 Query set @adminGroupDescription := 'Administrators group.' 21 Query set @adminRoleName := 'ADMIN_ROLE' 21 Query set @adminEMail := 'admin@jtalks.org' 21 Query set @moderatorsGroupName := 'Moderators' 21 Query set @moderatorsGroupDescription := 'General group for all moderators' 21 Query set @forumComponentName := 'JTalks Sample Forum' 21 Query set @forumComponentType := 'FORUM' 21 Query set @forumComponentAclClass :='COMPONENT' 21 Query set @forumComponentId := 2 21 Query set @availableUsersText := 'Available users: admin/admin' 21 Query set @isPrincipal := true 21 Query set @notPricipal := false 21 Query set @adminMask := 16 21 Query select @@session.tx_read_only 21 Query insert into COMPONENTS (CMP_ID, COMPONENT_TYPE, UUID, `NAME`, DESCRIPTION) select @forumComponentId, @forumComponentType, UUID(), @forumComponentName, @availableUsersText from dual where not exists (select 1 from COMPONENTS where COMPONENT_TYPE = @forumComponentType) 21 Query select @@session.tx_read_only 21 Query insert into GROUPS (UUID, `NAME`, DESCRIPTION) select UUID(), @moderatorsGroupName, @moderatorsGroupDescription from dual where not exists (select GROUP_ID from GROUPS where `NAME` = @moderatorsGroupName) 21 Query select @@session.tx_read_only 21 Query insert into GROUPS (UUID, `NAME`, DESCRIPTION) select UUID(), @adminGroupName, @adminGroupDescription from dual where not exists (select gr.GROUP_ID from GROUPS gr where gr.NAME = @adminGroupName) 21 Query select @@session.tx_read_only 21 Query insert into USERS (UUID, FIRST_NAME, LAST_NAME, USERNAME, ENCODED_USERNAME, EMAIL, PASSWORD, ROLE, SALT, ENABLED) select UUID(), @adminUserName, @adminUserName, @adminUserName, @adminUserName, @adminEMail, MD5(@adminPassword), @adminRoleName, '', true from dual where not exists (select 1 from USERS where USERNAME = @adminUserName) 21 Query select @@session.tx_read_only 21 Query alter table JC_USER_DETAILS add unique (USER_ID) 21 Query select @@session.tx_read_only 21 Query insert into JC_USER_DETAILS (USER_ID, REGISTRATION_DATE, POST_COUNT) select ID, NOW(), 0 from USERS where USERNAME = @adminUserName and not exists (select 1 from JC_USER_DETAILS where USER_ID = USERS.ID) 21 Query set @admin_group_id := (select GROUP_ID from GROUPS where `NAME` = @adminGroupName) 21 Query select @@session.tx_read_only 21 Query insert into GROUP_USER_REF (GROUP_ID, USER_ID) select @admin_group_id, ID from USERS where USERNAME = @adminUserName and not exists (select * from GROUP_USER_REF where GROUP_ID = @admin_group_id and USER_ID = USERS.ID) 21 Query set @component_acl_class := 1 21 Query set @group_acl_class := 2 21 Query set @branch_acl_class := 3 21 Query select @@session.tx_read_only 21 Query insert ignore into acl_class (ID, CLASS) values (@branch_acl_class, 'BRANCH'), (@group_acl_class, 'GROUP'), (@component_acl_class, 'COMPONENT') 21 Query set @acl_sid_admin_group := (select GROUP_CONCAT('usergroup:', CONVERT(GROUP_ID, char(19))) from GROUPS g where g.NAME = @adminGroupName) 21 Query set @acl_sid_admin_user := (select GROUP_CONCAT('user:', CONVERT(ID, char(19))) from USERS u where u.USERNAME = @adminUserName) 21 Query set @forum_object_id_identity := (select component.CMP_ID from COMPONENTS component where component.COMPONENT_TYPE = @forumComponentType) 21 Query select @@session.tx_read_only 21 Query insert into acl_sid (principal, sid) select @isPrincipal, @acl_sid_admin_user from dual where not exists (select acl_sid.sid from acl_sid where sid = @acl_sid_admin_user) 21 Query set @acl_sid_admin_user_id := (select sid.id from acl_sid sid where sid.sid = @acl_sid_admin_user) 21 Query select @@session.tx_read_only 21 Query insert ignore into acl_sid (principal, sid) values(@notPrincipal, @acl_sid_admin_group) 21 Query set @acl_sid_admin_group_id := (select sid.id from acl_sid sid where sid.sid = @acl_sid_admin_group) 21 Query set @forum_component_acl_class_id := (select class.id from acl_class class where class.class = @forumComponentAclClass) 21 Query select @@session.tx_read_only 21 Query insert ignore into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) select @forum_component_acl_class_id, @forum_object_id_identity, @acl_sid_admin_user_id, 1 from dual 21 Query set @forum_acl_object_identity_id := (select aoi.id from acl_object_identity aoi where aoi.object_id_class = @forum_component_acl_class_id and aoi.object_id_identity = @forum_object_id_identity) 21 Query set @ace_order_max := (select MAX(ae.ace_order) from acl_entry ae) 21 Query set @ace_order := (case when @ace_order_max is null then 0 else @ace_order_max + 1 end) 21 Query select @@session.tx_read_only 21 Query insert ignore into acl_entry (acl_object_identity, sid, ace_order, mask, granting, audit_success, audit_failure) select @forum_acl_object_identity_id, @acl_sid_admin_group_id, @ace_order, @adminMask, 1, 0 , 0 from dual 21 Query commit 21 Query SET autocommit=1 21 Query select @@session.tx_read_only 22 Query UPDATE jtalks.jcommune_schema_version SET current_version=0 22 Query select @@session.tx_read_only 22 Query INSERT INTO jtalks.jcommune_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('65', 'Add admin user', 'SQL', 'V65__Add_admin_user.sql', -2062736191, SUBSTRING_INDEX(USER(),'@',1), 531, 'SUCCESS', 1) 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 22 Query SET autocommit=0 22 Query select * from jtalks.jcommune_schema_version for update 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 22 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 22 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 22 Query commit 22 Query SET autocommit=1 22 Query select @@session.tx_read_only 150306 14:07:57 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'banner' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'banner' 22 Query SHOW FULL COLUMNS FROM `banner` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 22 Query SHOW FULL COLUMNS FROM `branches` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches_view_topics' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches_view_topics' 22 Query SHOW FULL COLUMNS FROM `branches_view_topics` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branch_subscriptions' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branch_subscriptions' 22 Query SHOW FULL COLUMNS FROM `branch_subscriptions` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'comment_attribute' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'comment_attribute' 22 Query SHOW FULL COLUMNS FROM `comment_attribute` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 22 Query SHOW FULL COLUMNS FROM `components` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'contact_type' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'contact_type' 22 Query SHOW FULL COLUMNS FROM `contact_type` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'external_link' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'external_link' 22 Query SHOW FULL COLUMNS FROM `external_link` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 22 Query SHOW FULL COLUMNS FROM `groups` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 22 Query SHOW FULL COLUMNS FROM `group_user_ref` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jc_user_details' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jc_user_details' 22 Query SHOW FULL COLUMNS FROM `jc_user_details` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'last_read_posts' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'last_read_posts' 22 Query SHOW FULL COLUMNS FROM `last_read_posts` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'mark_branch_as_read_time' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'mark_branch_as_read_time' 22 Query SHOW FULL COLUMNS FROM `mark_branch_as_read_time` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin' 22 Query SHOW FULL COLUMNS FROM `plugin` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin_property' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin_property' 22 Query SHOW FULL COLUMNS FROM `plugin_property` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'polls' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'polls' 22 Query SHOW FULL COLUMNS FROM `polls` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poll_options' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poll_options' 22 Query SHOW FULL COLUMNS FROM `poll_options` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post' 22 Query SHOW FULL COLUMNS FROM `post` FROM `jtalks` LIKE '%' 150306 14:07:58 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_comment' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_comment' 22 Query SHOW FULL COLUMNS FROM `post_comment` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_vote' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_vote' 22 Query SHOW FULL COLUMNS FROM `post_vote` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'private_message' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'private_message' 22 Query SHOW FULL COLUMNS FROM `private_message` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 22 Query SHOW FULL COLUMNS FROM `properties` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 22 Query SHOW FULL COLUMNS FROM `sections` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'simple_pages' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'simple_pages' 22 Query SHOW FULL COLUMNS FROM `simple_pages` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic' 22 Query SHOW FULL COLUMNS FROM `topic` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_attribute' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_attribute' 22 Query SHOW FULL COLUMNS FROM `topic_attribute` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_subscriptions' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_subscriptions' 22 Query SHOW FULL COLUMNS FROM `topic_subscriptions` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 22 Query SHOW FULL COLUMNS FROM `users` FROM `jtalks` LIKE '%' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'user_contact' 22 Query SHOW FULL TABLES FROM `jtalks` LIKE 'user_contact' 22 Query SHOW FULL COLUMNS FROM `user_contact` FROM `jtalks` LIKE '%' 150306 14:09:00 22 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 22 Query SET autocommit=0 22 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 22 Query commit 22 Query SET autocommit=1 22 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 22 Query select @@session.tx_read_only 22 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 22 Query SET autocommit=0 22 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 22 Query commit 22 Query SET autocommit=1 22 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 22 Query select @@session.tx_read_only 150306 14:09:13 23 Quit 21 Quit 22 Quit 150306 14:09:29 25 Connect test@localhost on jtalks 26 Connect test@localhost on jtalks 24 Connect test@localhost on jtalks 26 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 25 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 24 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 26 Query SHOW WARNINGS 24 Query SHOW WARNINGS 24 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 24 Query SHOW COLLATION 26 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 26 Query SHOW COLLATION 26 Query SET NAMES utf8 26 Query SET character_set_results = NULL 26 Query SET autocommit=1 26 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 26 Query SELECT @@session.tx_isolation 24 Query SET NAMES utf8 24 Query SET character_set_results = NULL 24 Query SET autocommit=1 24 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 24 Query SELECT @@session.tx_isolation 25 Query SHOW WARNINGS 25 Query /* mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment 25 Query SHOW COLLATION 25 Query SET NAMES utf8 25 Query SET character_set_results = NULL 25 Query SET autocommit=1 25 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 25 Query SELECT @@session.tx_isolation 24 Query SELECT @@session.tx_isolation 150306 14:09:32 24 Query show tables like 'common_schema_version' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 24 Query SELECT COUNT(*) FROM jtalks.common_schema_version 26 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 26 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 24 Query SET autocommit=0 24 Query select * from jtalks.common_schema_version for update 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 24 Query SELECT COUNT(*) FROM jtalks.common_schema_version 24 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 24 Query SELECT COUNT(*) FROM jtalks.common_schema_version 24 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 24 Query commit 24 Query SET autocommit=1 24 Query select @@session.tx_read_only 24 Query show tables like 'jcommune_schema_version' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 26 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 25 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 26 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 24 Query SET autocommit=0 24 Query select * from jtalks.jcommune_schema_version for update 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 24 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 24 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jcommune_schema_version' 24 Query SELECT COUNT(*) FROM jtalks.jcommune_schema_version 24 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.jcommune_schema_version where current_version=1 24 Query commit 24 Query SET autocommit=1 24 Query select @@session.tx_read_only 150306 14:09:34 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'banner' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'banner' 24 Query SHOW FULL COLUMNS FROM `banner` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 24 Query SHOW FULL COLUMNS FROM `branches` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches_view_topics' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches_view_topics' 24 Query SHOW FULL COLUMNS FROM `branches_view_topics` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branch_subscriptions' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branch_subscriptions' 24 Query SHOW FULL COLUMNS FROM `branch_subscriptions` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'comment_attribute' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'comment_attribute' 24 Query SHOW FULL COLUMNS FROM `comment_attribute` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 24 Query SHOW FULL COLUMNS FROM `components` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'contact_type' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'contact_type' 24 Query SHOW FULL COLUMNS FROM `contact_type` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'external_link' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'external_link' 24 Query SHOW FULL COLUMNS FROM `external_link` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 24 Query SHOW FULL COLUMNS FROM `groups` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 24 Query SHOW FULL COLUMNS FROM `group_user_ref` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jc_user_details' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'jc_user_details' 24 Query SHOW FULL COLUMNS FROM `jc_user_details` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'last_read_posts' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'last_read_posts' 24 Query SHOW FULL COLUMNS FROM `last_read_posts` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'mark_branch_as_read_time' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'mark_branch_as_read_time' 24 Query SHOW FULL COLUMNS FROM `mark_branch_as_read_time` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin' 24 Query SHOW FULL COLUMNS FROM `plugin` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin_property' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'plugin_property' 24 Query SHOW FULL COLUMNS FROM `plugin_property` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'polls' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'polls' 24 Query SHOW FULL COLUMNS FROM `polls` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poll_options' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poll_options' 24 Query SHOW FULL COLUMNS FROM `poll_options` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post' 24 Query SHOW FULL COLUMNS FROM `post` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_comment' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_comment' 24 Query SHOW FULL COLUMNS FROM `post_comment` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_vote' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'post_vote' 24 Query SHOW FULL COLUMNS FROM `post_vote` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'private_message' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'private_message' 24 Query SHOW FULL COLUMNS FROM `private_message` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 24 Query SHOW FULL COLUMNS FROM `properties` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 24 Query SHOW FULL COLUMNS FROM `sections` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'simple_pages' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'simple_pages' 24 Query SHOW FULL COLUMNS FROM `simple_pages` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic' 24 Query SHOW FULL COLUMNS FROM `topic` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_attribute' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_attribute' 24 Query SHOW FULL COLUMNS FROM `topic_attribute` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_subscriptions' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_subscriptions' 24 Query SHOW FULL COLUMNS FROM `topic_subscriptions` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 24 Query SHOW FULL COLUMNS FROM `users` FROM `jtalks` LIKE '%' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'user_contact' 24 Query SHOW FULL TABLES FROM `jtalks` LIKE 'user_contact' 24 Query SHOW FULL COLUMNS FROM `user_contact` FROM `jtalks` LIKE '%' 150306 14:09:45 27 Connect test@localhost on jtalks 29 Connect test@localhost on jtalks 28 Connect test@localhost on jtalks 29 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 27 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 28 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 27 Query SHOW WARNINGS 28 Query SHOW WARNINGS 29 Query SHOW WARNINGS 28 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SELECT @@session.auto_increment_increment 27 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SELECT @@session.auto_increment_increment 27 Query SHOW COLLATION 29 Query /* mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq ) */SELECT @@session.auto_increment_increment 29 Query SHOW COLLATION 27 Query SET NAMES utf8 27 Query SET character_set_results = NULL 27 Query SET autocommit=1 27 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 28 Query SHOW COLLATION 29 Query SET NAMES utf8 28 Query SET NAMES utf8 28 Query SET character_set_results = NULL 28 Query SET autocommit=1 28 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 29 Query SET character_set_results = NULL 29 Query SET autocommit=1 29 Query SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' 27 Query SELECT @@session.tx_isolation 28 Query SELECT @@session.tx_isolation 29 Query SELECT @@session.tx_isolation 29 Query SELECT @@session.tx_isolation 29 Query show tables like 'common_schema_version' 29 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 29 Query SELECT COUNT(*) FROM jtalks.common_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 27 Query SET autocommit=0 27 Query select * from jtalks.common_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.common_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'common_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.common_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.common_schema_version where current_version=1 27 Query commit 27 Query SET autocommit=1 27 Query show tables like 'poulpe_schema_version' 29 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SET autocommit=0 28 Query CREATE TABLE jtalks.poulpe_schema_version ( version VARCHAR(20) NOT NULL UNIQUE, description VARCHAR(100), type VARCHAR(10) NOT NULL, script VARCHAR(200) NOT NULL UNIQUE, checksum INT, installed_by VARCHAR(30) NOT NULL, installed_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP, execution_time INT, state VARCHAR(15) NOT NULL, current_version BOOL NOT NULL, PRIMARY KEY(version) ) ENGINE=InnoDB 150306 14:09:46 28 Query ALTER TABLE jtalks.poulpe_schema_version ADD INDEX poulpe_schema_version_current_version_index (current_version) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('0', '<< Flyway Init >>', 'INIT', '<< Flyway Init >>', null, SUBSTRING_INDEX(USER(),'@',1), 0, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query CREATE TABLE `POULPE_GROUP` ( `GROUP_ID` BIGINT(20) NOT NULL, `BRANCH_ID` BIGINT(20) NULL DEFAULT NULL, `POSITION` INT(11) NULL DEFAULT NULL) 27 Query CREATE TABLE `TOPIC_TYPES`( `ID` BIGINT(20) NOT NULL AUTO_INCREMENT , `UUID` VARCHAR(255) NOT NULL , `TITLE` VARCHAR(255) NOT NULL , `DESCRIPTION` VARCHAR(255) NULL DEFAULT NULL , PRIMARY KEY (`ID`) , UNIQUE INDEX `UUID` (`UUID` ASC) , UNIQUE INDEX `TITLE` (`TITLE` ASC)) 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('1', 'Base version', 'SQL', 'V1__Base_version.sql', 1795129490, SUBSTRING_INDEX(USER(),'@',1), 547, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query DROP TABLE `POULPE_GROUP` 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('2', 'Drop poulpe group', 'SQL', 'V2__Drop_poulpe_group.sql', -587108657, SUBSTRING_INDEX(USER(),'@',1), 93, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 150306 14:09:47 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query CREATE TABLE `BASE_COMPONENTS` ( `COMPONENT_TYPE` VARCHAR(20) NOT NULL, PRIMARY KEY (`COMPONENT_TYPE`) ) 27 Query INSERT INTO `BASE_COMPONENTS` (`COMPONENT_TYPE`) VALUES ('FORUM') 27 Query INSERT INTO `BASE_COMPONENTS` (`COMPONENT_TYPE`) VALUES ('ARTICLE') 27 Query INSERT INTO `BASE_COMPONENTS` (`COMPONENT_TYPE`) VALUES ('ADMIN_PANEL') 27 Query CREATE TABLE `DEFAULT_PROPERTIES` ( `PROPERTY_ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `UUID` VARCHAR(255) NOT NULL, `BASE_COMPONENT_TYPE` VARCHAR(20) DEFAULT NULL, `NAME` VARCHAR(255) NOT NULL, `VALUE` VARCHAR(255) DEFAULT NULL, `VALIDATION_RULE` VARCHAR(64) NOT NULL DEFAULT '', PRIMARY KEY (`PROPERTY_ID`), UNIQUE KEY `UUID` (`UUID`), KEY `FK_BASE_COMPONENT` (`BASE_COMPONENT_TYPE`), CONSTRAINT `FK_BASE_COMPONENT` FOREIGN KEY (`BASE_COMPONENT_TYPE`) REFERENCES `BASE_COMPONENTS` (`COMPONENT_TYPE`) ) 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES ('7149f814-3421-43f0-b890-b79b74253cd6', 'FORUM', 'jcommune.name', 'JCommune', '') 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES ('f989f4d4-877d-44f8-a0aa-ed26196c93d7', 'FORUM', 'jcommune.caption', 'The best forum engine ever', '') 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES ('d34c48eb-8afb-4c28-b61a-82c81c33cd26', 'FORUM', 'jcommune.post_preview_size', '200', '/[0-9]+/') 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES ('3f48867c-3a9d-410f-94c0-40945e26154e', 'FORUM', 'jcommune.session_timeout', '24', '/[0-9]+/') 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('3', 'Default parameters and base component', 'SQL', 'V3__Default_parameters_and_base_component.sql', -2127904657, SUBSTRING_INDEX(USER(),'@',1), 468, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES ('7149f814-3421-43f0-b890-ed26196c93d7', 'FORUM', 'jcommune.sending_notifications_enabled', 'true', '/(true)|(false)/') 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('4', 'Forum email notification property', 'SQL', 'V4__Forum_email_notification_property.sql', -2116973684, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query UPDATE COMPONENTS c SET c.COMPONENT_TYPE = "FORUM" WHERE c.C_TYPE = 0 27 Query UPDATE COMPONENTS c SET c.COMPONENT_TYPE = "ARTICLE" WHERE c.C_TYPE = 1 27 Query UPDATE COMPONENTS c SET c.COMPONENT_TYPE = "ADMIN_PANEL" WHERE c.C_TYPE = 2 27 Query ALTER TABLE COMPONENTS DROP COLUMN C_TYPE, DROP INDEX `C_TYPE` 150306 14:09:48 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('5', 'ComponentType in string instead of int', 'SQL', 'V5__ComponentType_in_string_instead_of_int.sql', 1969340858, SUBSTRING_INDEX(USER(),'@',1), 609, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query INSERT INTO `PROPERTIES` (`UUID`, `NAME`, `VALUE`, `CMP_ID`, `VALIDATION_RULE`) SELECT UUID(), dp.`NAME`, dp.`VALUE`, c.`CMP_ID`, dp.`VALIDATION_RULE` FROM `DEFAULT_PROPERTIES` dp left outer join `PROPERTIES` p on dp.`NAME` = p.`NAME` join `COMPONENTS` c on c.`COMPONENT_TYPE` = dp.`BASE_COMPONENT_TYPE` WHERE p.`NAME` is NULL 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('6', 'Adding default properties to existent components', 'SQL', 'V6__Adding_default_properties_to_existent_components.sql', -1773942735, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query SET @adminUserName := 'admin' 27 Query SET @passwordHash := '21232f297a57a5a743894a0e4a801fc3' 27 Query SET @adminGroupName := 'Administrators' 27 Query SET @poulpeComponentName := 'Admin panel' 27 Query SET @poulpeComponentType := 'ADMIN_PANEL' 27 Query SET @aclClass :='COMPONENT' 27 Query SET @adminPanelComponentId := 1 27 Query INSERT IGNORE INTO COMPONENTS (CMP_ID, COMPONENT_TYPE, UUID, `NAME`, DESCRIPTION) SELECT @adminPanelComponentId, @poulpeComponentType, '7241a11-5620-87a0-a810-ed26496z92m7',@poulpeComponentName,'JTalks Admin panel' FROM dual WHERE NOT EXISTS (SELECT * FROM COMPONENTS components WHERE components.COMPONENT_TYPE=@poulpeComponentType) 27 Query INSERT INTO GROUPS (UUID, `NAME`, DESCRIPTION) SELECT '7141a12-5620-87h0-a210-ed26491k82m7',@adminGroupName, 'Administrators group.' FROM dual WHERE NOT EXISTS (SELECT gr.GROUP_ID FROM GROUPS gr WHERE gr.NAME=@adminGroupName) 27 Query INSERT IGNORE INTO USERS (UUID, FIRST_NAME, LAST_NAME, USERNAME, ENCODED_USERNAME, EMAIL, PASSWORD, ROLE, SALT, ENABLED) VALUES('7241p12-2720-99h0-r210-ed26491k86j7', @adminUserName, @adminUserName, @adminUserName, @adminUserName, 'admin@jtalks.org', @passwordHash, 'ADMIN_ROLE', '', true) 27 Query INSERT IGNORE INTO GROUP_USER_REF(USER_ID, GROUP_ID) SELECT u.ID, g.GROUP_ID FROM USERS u, GROUPS g WHERE u.USERNAME = @adminUserName AND g.NAME = @adminGroupName AND NOT EXISTS (SELECT gur.USER_ID, gur.GROUP_ID, u.ID, g.GROUP_ID FROM GROUP_USER_REF gur, USERS u, GROUPS g WHERE u.ID = gur.USER_ID AND g.GROUP_ID = gur.GROUP_ID AND u.USERNAME = @adminUserName AND g.NAME = @adminGroupName) 27 Query INSERT IGNORE INTO acl_class (class) VALUE(@aclClass) 27 Query SET @acl_sid_group := (SELECT GROUP_CONCAT('usergroup:', CONVERT(GROUP_ID, char(19))) FROM GROUPS g WHERE g.NAME = @adminGroupName) 27 Query SET @acl_sid_user := (SELECT GROUP_CONCAT('user:', CONVERT(ID, char(19))) FROM USERS u WHERE u.USERNAME = @adminUserName) 27 Query SET @object_id_identity := (SELECT component.CMP_ID FROM COMPONENTS component WHERE component.COMPONENT_TYPE = @poulpeComponentType) 27 Query INSERT INTO acl_sid (principal, sid) SELECT 1, @acl_sid_user FROM dual WHERE NOT exists (SELECT acl_sid.sid FROM acl_sid WHERE sid = @acl_sid_user) 27 Query SET @acl_sid_id_user := (SELECT sid.id FROM acl_sid sid WHERE sid.sid = @acl_sid_user) 27 Query INSERT IGNORE INTO acl_sid (principal, sid) VALUES(0, @acl_sid_group) 27 Query SET @acl_sid_id_group := (SELECT sid.id FROM acl_sid sid WHERE sid.sid = @acl_sid_group) 27 Query SET @acl_class_id :=(SELECT class.id FROM acl_class class WHERE class.class = @aclClass) 27 Query INSERT IGNORE INTO acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) SELECT @acl_class_id, @object_id_identity, @acl_sid_id_user, 1 FROM dual WHERE NOT EXISTS (SELECT aoi.object_id_class, aoi.object_id_identity, aoi.owner_sid FROM acl_object_identity aoi WHERE aoi.object_id_class = @acl_class_id AND aoi.object_id_identity = @object_id_identity AND aoi.owner_sid = @acl_sid_id_user) 27 Query SET @acl_object_identity_id := (SELECT aoi.id FROM acl_object_identity aoi WHERE aoi.object_id_class = @acl_class_id AND aoi.object_id_identity = @object_id_identity) 27 Query SET @ace_order_max := (SELECT MAX(ae.ace_order) FROM acl_entry ae) 27 Query SET @ace_order := (CASE WHEN @ace_order_max is null THEN 0 ELSE @ace_order_max+1 END) 27 Query INSERT IGNORE INTO acl_entry (acl_object_identity, sid, ace_order, mask, granting, audit_success, audit_failure) SELECT @acl_object_identity_id, @acl_sid_id_group, @ace_order, 16, 1, 0 , 0 FROM dual WHERE NOT EXISTS (SELECT ae.acl_object_identity, ae.sid FROM acl_entry ae WHERE ae.acl_object_identity = @acl_object_identity_id AND ae.sid = @acl_sid_id_group) 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('7', 'Addin admin group user component', 'SQL', 'V7__Addin_admin_group_user_component.sql', -1036305526, SUBSTRING_INDEX(USER(),'@',1), 78, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES (UUID(), 'FORUM', 'jcommune.url_address', '', '/(http:\\/\\/).+/') 27 Query INSERT INTO PROPERTIES (UUID, NAME, VALUE, CMP_ID, VALIDATION_RULE) SELECT UUID(), dp.NAME, dp.VALUE, c.CMP_ID, dp.VALIDATION_RULE FROM DEFAULT_PROPERTIES dp left join PROPERTIES p on dp.NAME = p.NAME join COMPONENTS c on c.COMPONENT_TYPE = dp.BASE_COMPONENT_TYPE WHERE p.NAME is NULL 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('8', 'Jcommune URL address default property', 'SQL', 'V8__Jcommune_URL_address_default_property.sql', -1909502884, SUBSTRING_INDEX(USER(),'@',1), 32, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query INSERT INTO DEFAULT_PROPERTIES (UUID, BASE_COMPONENT_TYPE, NAME, VALUE, VALIDATION_RULE) VALUES ('6f62d4ab-f8c9-4366-9516-9ecac7f602f6', 'FORUM', 'jcommune.avatar_max_size', '4194304', '') 28 Query INSERT INTO PROPERTIES (UUID, NAME, VALUE, CMP_ID, VALIDATION_RULE) SELECT UUID(), dp.NAME, dp.VALUE, c.CMP_ID, dp.VALIDATION_RULE FROM DEFAULT_PROPERTIES dp left join PROPERTIES p on dp.NAME = p.NAME join COMPONENTS c on c.COMPONENT_TYPE = dp.BASE_COMPONENT_TYPE WHERE p.NAME is NULL 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('9', 'Adding avatar max size', 'SQL', 'V9__Adding_avatar_max_size.sql', 524192472, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query DELETE FROM DEFAULT_PROPERTIES WHERE NAME = 'jcommune.name' 28 Query DELETE FROM DEFAULT_PROPERTIES WHERE NAME = 'jcommune.post_preview_size' 28 Query DELETE FROM DEFAULT_PROPERTIES WHERE NAME = 'jcommune.caption' 28 Query DELETE FROM PROPERTIES WHERE NAME = 'jcommune.name' 28 Query DELETE FROM PROPERTIES WHERE NAME = 'jcommune.post_preview_size' 28 Query DELETE FROM PROPERTIES WHERE NAME = 'jcommune.caption' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('10', 'Removing some jCommune props', 'SQL', 'V10__Removing_some_jCommune_props.sql', -1909535396, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query ALTER TABLE PROPERTIES CHANGE VALIDATION_RULE VALIDATION_RULE VARCHAR(255) 28 Query ALTER TABLE DEFAULT_PROPERTIES CHANGE VALIDATION_RULE VALIDATION_RULE VARCHAR(255) 150306 14:09:49 28 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/([0-9]|1[0-9]|2[0-4])/' WHERE NAME = 'jcommune.session_timeout' 28 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/([0-9]{1,6}|10([0-3][0-9]{4}|4([0-7][0-9]{3}|8([0-4][0-9]{2}|5([0-6][0-9]|7[0-6])))))/', VALUE = '51200' WHERE NAME = 'jcommune.avatar_max_size' 28 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/([0-9]|1[0-9]|2[0-4])/' WHERE NAME = 'jcommune.session_timeout' 28 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/([0-9]{1,6}|10([0-3][0-9]{4}|4([0-7][0-9]{3}|8([0-4][0-9]{2}|5([0-6][0-9]|7[0-6])))))/', VALUE = '51200' WHERE NAME = 'jcommune.avatar_max_size' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('11', 'Adding jcommune props validation', 'SQL', 'V11__Adding_jcommune_props_validation.sql', 872690839, SUBSTRING_INDEX(USER(),'@',1), 860, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/(http:\/\/([0-9A-Za-z\.-]+)(:[0-9]+)?(\/[0-9A-Za-z\.-]*)?)/' WHERE NAME = 'jcommune.url_address' 28 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/(http:\/\/([0-9A-Za-z\.-]+)(:[0-9]+)?(\/[0-9A-Za-z\.-]*)?)/' WHERE NAME = 'jcommune.url_address' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('12', 'Adding good jCommune URL validation', 'SQL', 'V12__Adding_good_jCommune_URL_validation.sql', 1443484063, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/(http:\\/\\/([0-9A-Za-z\\.-]+)(:[0-9]+)?(\\/[0-9A-Za-z\\.-]*)?)/' WHERE NAME = 'jcommune.url_address' 28 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/(http:\\/\\/([0-9A-Za-z\\.-]+)(:[0-9]+)?(\\/[0-9A-Za-z\\.-]*)?)/' WHERE NAME = 'jcommune.url_address' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('13', 'Fixing URL regexp', 'SQL', 'V13__Fixing_URL_regexp.sql', 1396800174, SUBSTRING_INDEX(USER(),'@',1), 15, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query ALTER TABLE DEFAULT_PROPERTIES MODIFY COLUMN VALIDATION_RULE VARCHAR(255) 28 Query ALTER TABLE PROPERTIES MODIFY COLUMN VALIDATION_RULE VARCHAR(255) 28 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/((https?:\\/\\/)?(([\\w][-\\w_\\.]*\\.[a-z]{1,5})|(localhost)|([0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}))(:[0-9]{1,5})?(\\/[-\\w_\\s()?=&#\\.]+)*\\/?)/' WHERE NAME = 'jcommune.url_address' 28 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/((https?:\\/\\/)?(([\\w][-\\w_\\.]*\\.[a-z]{1,5})|(localhost)|([0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}))(:[0-9]{1,5})?(\\/[-\\w_\\s()?=&#\\.]+)*\\/?)/' WHERE NAME = 'jcommune.url_address' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('14', 'Rewriting URL regexp', 'SQL', 'V14__Rewriting_URL_regexp.sql', -633422763, SUBSTRING_INDEX(USER(),'@',1), 125, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES (UUID(), 'ADMIN_PANEL', 'poulpe.experimental_feature', 'false', '/(true)|(false)/') 28 Query INSERT INTO PROPERTIES (UUID, NAME, VALUE, CMP_ID, VALIDATION_RULE) SELECT UUID(), dp.NAME, dp.VALUE, c.CMP_ID, dp.VALIDATION_RULE FROM DEFAULT_PROPERTIES dp left join PROPERTIES p on dp.NAME = p.NAME join COMPONENTS c on c.COMPONENT_TYPE = dp.BASE_COMPONENT_TYPE WHERE p.NAME is NULL 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('15', 'Poulpe experimental feature property', 'SQL', 'V15__Poulpe_experimental_feature_property.sql', -2031503941, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query UPDATE DEFAULT_PROPERTIES SET NAME = 'poulpe.experimental_features_enabled' WHERE NAME = 'poulpe.experimental_feature' 28 Query UPDATE PROPERTIES SET NAME = 'poulpe.experimental_features_enabled' WHERE NAME = 'poulpe.experimental_feature' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('16', 'Rename experimental feature to experimental features enabled', 'SQL', 'V16__Rename_experimental_feature_to_experimental_features_enabled.sql', -192006739, SUBSTRING_INDEX(USER(),'@',1), 47, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query alter table `GROUPS` ADD CONSTRAINT UNIQUE INDEX `group_name_u_ind`(`name`) 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 150306 14:09:50 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('17', 'Add group name unique index', 'SQL', 'V17__Add_group_name_unique_index.sql', 1355299887, SUBSTRING_INDEX(USER(),'@',1), 203, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SET autocommit=0 28 Query UPDATE USERS SET ENABLED = 1 WHERE USERNAME = 'admin' 28 Query commit 28 Query SET autocommit=1 27 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 27 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('18', 'Activate admin user', 'SQL', 'V18__Activate_admin_user.sql', 2111161642, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 27 Query commit 27 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query ALTER TABLE PROPERTIES MODIFY VALIDATION_RULE VARCHAR(255) DEFAULT NULL 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('19', 'Reconcile PROPERTIES table with common scripts', 'SQL', 'V19__Reconcile_PROPERTIES_table_with_common_scripts.sql', -1097243457, SUBSTRING_INDEX(USER(),'@',1), 31, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query UPDATE DEFAULT_PROPERTIES SET VALIDATION_RULE = '/([1-9]\\d{0,2}|1[0-3]\\d{2}|14[0-3]\\d|1440|0)/' WHERE NAME = 'jcommune.session_timeout' 27 Query UPDATE PROPERTIES SET VALIDATION_RULE = '/([1-9]\\d{0,2}|1[0-3]\\d{2}|14[0-3]\\d|1440|0)/' WHERE NAME = 'jcommune.session_timeout' 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('20', 'Session timeout minutes regexp', 'SQL', 'V20__Session_timeout_minutes_regexp.sql', 295991893, SUBSTRING_INDEX(USER(),'@',1), 15, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES (UUID(), 'ADMIN_PANEL', 'poulpe.rest_login', '', '/^.{0,64}$/') 27 Query INSERT INTO `DEFAULT_PROPERTIES` (`UUID`, `BASE_COMPONENT_TYPE`, `NAME`, `VALUE`, `VALIDATION_RULE`) VALUES (UUID(), 'ADMIN_PANEL', 'poulpe.rest_password', '', '/^.{0,64}$/') 27 Query INSERT INTO PROPERTIES (UUID, NAME, VALUE, CMP_ID, VALIDATION_RULE) SELECT UUID(), dp.NAME, dp.VALUE, c.CMP_ID, dp.VALIDATION_RULE FROM DEFAULT_PROPERTIES dp left join PROPERTIES p on dp.NAME = p.NAME join COMPONENTS c on c.COMPONENT_TYPE = dp.BASE_COMPONENT_TYPE WHERE p.NAME is NULL 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('21', 'UserName and password REST service properties', 'SQL', 'V21__UserName_and_password_REST_service_properties.sql', 491569337, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 28 Query SET autocommit=0 28 Query select * from jtalks.poulpe_schema_version for update 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 28 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 28 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 28 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SET autocommit=0 27 Query UPDATE `DEFAULT_PROPERTIES` SET `VALIDATION_RULE`='/^[a-zA-Z0-9 ]{0,64}$/' WHERE `NAME`='poulpe.rest_login' OR `NAME`='poulpe.rest_password' 27 Query UPDATE `PROPERTIES` SET `VALIDATION_RULE`='/^[a-zA-Z0-9 ]{0,64}$/' WHERE `NAME`='poulpe.rest_login' OR `NAME`='poulpe.rest_password' 27 Query commit 27 Query SET autocommit=1 28 Query UPDATE jtalks.poulpe_schema_version SET current_version=0 28 Query INSERT INTO jtalks.poulpe_schema_version (version, description, type, script, checksum, installed_by, execution_time, state, current_version) VALUES ('22', 'Change VALIDATION RULE UserName and password REST', 'SQL', 'V22__Change_VALIDATION_RULE_UserName_and_password_REST.sql', -284280166, SUBSTRING_INDEX(USER(),'@',1), 16, 'SUCCESS', 1) 28 Query commit 28 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select * from jtalks.poulpe_schema_version for update 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'poulpe_schema_version' 27 Query SELECT COUNT(*) FROM jtalks.poulpe_schema_version 27 Query select VERSION, DESCRIPTION, TYPE, SCRIPT, CHECKSUM, INSTALLED_ON, EXECUTION_TIME, STATE from jtalks.poulpe_schema_version where current_version=1 27 Query commit 27 Query SET autocommit=1 150306 14:09:51 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'base_components' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'base_components' 27 Query SHOW FULL COLUMNS FROM `base_components` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'branches' 27 Query SHOW FULL COLUMNS FROM `branches` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'components' 27 Query SHOW FULL COLUMNS FROM `components` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'default_properties' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'default_properties' 27 Query SHOW FULL COLUMNS FROM `default_properties` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'groups' 27 Query SHOW FULL COLUMNS FROM `groups` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'group_user_ref' 27 Query SHOW FULL COLUMNS FROM `group_user_ref` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'properties' 27 Query SHOW FULL COLUMNS FROM `properties` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'sections' 27 Query SHOW FULL COLUMNS FROM `sections` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_types' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'topic_types' 27 Query SHOW FULL COLUMNS FROM `topic_types` FROM `jtalks` LIKE '%' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 27 Query SHOW FULL TABLES FROM `jtalks` LIKE 'users' 27 Query SHOW FULL COLUMNS FROM `users` FROM `jtalks` LIKE '%' 150306 14:09:52 27 Query SELECT USER() 150306 14:10:00 24 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 24 Query SET autocommit=0 24 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 24 Query commit 24 Query SET autocommit=1 24 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 24 Query select @@session.tx_read_only 24 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 24 Query SET autocommit=0 24 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 24 Query commit 24 Query SET autocommit=1 24 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 24 Query select @@session.tx_read_only 150306 14:11:00 24 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 24 Query SET autocommit=0 24 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 24 Query commit 24 Query SET autocommit=1 24 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 24 Query select @@session.tx_read_only 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 150306 14:11:23 27 Query SET autocommit=0 27 Query select component0_.CMP_ID as CMP1_2_, component0_.UUID as UUID2_, component0_.NAME as NAME2_, component0_.DESCRIPTION as DESCRIPT5_2_, component0_.COMPONENT_TYPE as COMPONENT2_2_ from COMPONENTS component0_ 27 Query select sections0_.COMPONENT_ID as COMPONENT5_2_1_, sections0_.SECTION_ID as SECTION1_1_, sections0_.POSITION as POSITION1_, sections0_.SECTION_ID as SECTION1_4_0_, sections0_.UUID as UUID4_0_, sections0_.NAME as NAME4_0_, sections0_.DESCRIPTION as DESCRIPT4_4_0_ from SECTIONS sections0_ where sections0_.COMPONENT_ID=2 27 Query select properties0_.CMP_ID as CMP6_2_1_, properties0_.PROPERTY_ID as PROPERTY1_1_, properties0_.PROPERTY_ID as PROPERTY1_8_0_, properties0_.UUID as UUID8_0_, properties0_.NAME as NAME8_0_, properties0_.VALUE as VALUE8_0_, properties0_.VALIDATION_RULE as VALIDATION5_8_0_ from PROPERTIES properties0_ where properties0_.CMP_ID=2 27 Query select properties0_.CMP_ID as CMP6_2_1_, properties0_.PROPERTY_ID as PROPERTY1_1_, properties0_.PROPERTY_ID as PROPERTY1_8_0_, properties0_.UUID as UUID8_0_, properties0_.NAME as NAME8_0_, properties0_.VALUE as VALUE8_0_, properties0_.VALIDATION_RULE as VALIDATION5_8_0_ from PROPERTIES properties0_ where properties0_.CMP_ID=1 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select component0_.CMP_ID as CMP1_2_, component0_.UUID as UUID2_, component0_.NAME as NAME2_, component0_.DESCRIPTION as DESCRIPT5_2_, component0_.COMPONENT_TYPE as COMPONENT2_2_ from COMPONENTS component0_ where component0_.COMPONENT_TYPE='ADMIN_PANEL' 27 Query commit 27 Query SET autocommit=1 150306 14:11:50 27 Query SET autocommit=0 27 Query select group0_.GROUP_ID as GROUP1_5_, group0_.UUID as UUID5_, group0_.NAME as NAME5_, group0_.DESCRIPTION as DESCRIPT4_5_ from GROUPS group0_ 27 Query commit 27 Query SET autocommit=1 27 Query SET autocommit=0 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 1 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='GROUP' and acl_object_identity.object_id_identity = 1 27 Query select id from acl_sid where principal=1 and sid='user:0' 27 Query insert into acl_sid (principal, sid) values (1, 'user:0') 27 Query SELECT @@IDENTITY 27 Query select id from acl_class where class='GROUP' 27 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (2, 1, 8, 1) 150306 14:11:51 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 1 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 2 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='GROUP' and acl_object_identity.object_id_identity = 2 27 Query select id from acl_sid where principal=1 and sid='user:0' 27 Query select id from acl_class where class='GROUP' 27 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (2, 2, 8, 1) 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 2 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 3 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='GROUP' and acl_object_identity.object_id_identity = 3 27 Query select id from acl_sid where principal=1 and sid='user:0' 27 Query select id from acl_class where class='GROUP' 27 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (2, 3, 8, 1) 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 3 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 4 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='GROUP' and acl_object_identity.object_id_identity = 4 27 Query select id from acl_sid where principal=1 and sid='user:0' 27 Query select id from acl_class where class='GROUP' 27 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (2, 4, 8, 1) 27 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 4 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 27 Query commit 27 Query SET autocommit=1 150306 14:12:00 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 150306 14:13:00 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 24 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 24 Query SET autocommit=0 24 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 24 Query commit 24 Query SET autocommit=1 24 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 24 Query select @@session.tx_read_only 150306 14:14:00 24 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 24 Query SET autocommit=0 24 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 24 Query commit 24 Query SET autocommit=1 24 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 24 Query select @@session.tx_read_only 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 150306 14:15:00 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only 26 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 26 Query SET autocommit=0 26 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where this_1_.ENABLED=0 26 Query commit 26 Query SET autocommit=1 26 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 26 Query select @@session.tx_read_only