--- /dev/null
+alter table JournalArticle add indexable int;
+
+go
+
+update JournalArticle set indexable = 1;
+
+create table ServiceComponent (
+ serviceComponentId decimal(20,0) not null primary key,
+ buildNamespace varchar(75) null,
+ buildNumber decimal(20,0),
+ buildDate decimal(20,0),
+ data_ text null
+)
+go
+
+delete from UserTracker;
+
+drop table UserTrackerPath;
+create table UserTrackerPath (
+ userTrackerPathId decimal(20,0) not null primary key,
+ userTrackerId decimal(20,0),
+ path_ varchar(1000) null,
+ pathDate datetime null
+)
+go