--- /dev/null
+alter table JournalArticle add indexable tinyint;
+
+commit;
+
+update JournalArticle set indexable = 1;
+
+create table ServiceComponent (
+ serviceComponentId bigint not null primary key,
+ buildNamespace varchar(75) null,
+ buildNumber bigint,
+ buildDate bigint,
+ data_ longtext null
+) engine InnoDB;
+
+delete from UserTracker;
+
+drop table UserTrackerPath;
+create table UserTrackerPath (
+ userTrackerPathId bigint not null primary key,
+ userTrackerId bigint,
+ path_ longtext null,
+ pathDate datetime null
+) engine InnoDB;