--- /dev/null
+drop table ActivityTracker;
+
+create table AnnouncementsDelivery (
+ deliveryId decimal(20,0) not null primary key,
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ type_ varchar(75) null,
+ email int,
+ sms int,
+ website int
+)
+go
+
+create table AnnouncementsEntry (
+ uuid_ varchar(75) null,
+ entryId decimal(20,0) not null primary key,
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ userName varchar(75) null,
+ createDate datetime null,
+ modifiedDate datetime null,
+ classNameId decimal(20,0),
+ classPK decimal(20,0),
+ title varchar(75) null,
+ content varchar(1000) null,
+ url varchar(1000) null,
+ type_ varchar(75) null,
+ displayDate datetime null,
+ expirationDate datetime null,
+ priority int,
+ alert int
+)
+go
+
+create table AnnouncementsFlag (
+ flagId decimal(20,0) not null primary key,
+ userId decimal(20,0),
+ createDate datetime null,
+ entryId decimal(20,0),
+ value int
+)
+go
+
+create table ExpandoColumn (
+ columnId decimal(20,0) not null primary key,
+ tableId decimal(20,0),
+ name varchar(75) null,
+ type_ int
+)
+go
+
+create table ExpandoRow (
+ rowId_ decimal(20,0) not null primary key,
+ tableId decimal(20,0),
+ classPK decimal(20,0)
+)
+go
+
+create table ExpandoTable (
+ tableId decimal(20,0) not null primary key,
+ classNameId decimal(20,0),
+ name varchar(75) null
+)
+go
+
+create table ExpandoValue (
+ valueId decimal(20,0) not null primary key,
+ tableId decimal(20,0),
+ columnId decimal(20,0),
+ rowId_ decimal(20,0),
+ classNameId decimal(20,0),
+ classPK decimal(20,0),
+ data_ varchar(75) null
+)
+go
+
+alter table IGImage add name varchar(75) null;
+alter table IGImage add custom1ImageId decimal(20,0) null;
+alter table IGImage add custom2ImageId decimal(20,0) null;
+
+update Group_ set type_ = 3 where type_ = 0;
+
+update Image set type_ = 'jpg' where type_ = 'jpeg';
+
+create table PortletItem (
+ portletItemId decimal(20,0) not null primary key,
+ groupId decimal(20,0),
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ userName varchar(75) null,
+ createDate datetime null,
+ modifiedDate datetime null,
+ name varchar(75) null,
+ portletId varchar(75) null,
+ classNameId decimal(20,0)
+)
+go
+
+create table SocialActivity (
+ activityId decimal(20,0) not null primary key,
+ groupId decimal(20,0),
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ createDate datetime null,
+ classNameId decimal(20,0),
+ classPK decimal(20,0),
+ type_ varchar(75) null,
+ extraData text null,
+ receiverUserId decimal(20,0)
+)
+go
+
+create table SocialRelation (
+ uuid_ varchar(75) null,
+ relationId decimal(20,0) not null primary key,
+ companyId decimal(20,0),
+ createDate datetime null,
+ userId1 decimal(20,0),
+ userId2 decimal(20,0),
+ type_ int
+)
+go
+
+create table TasksProposal (
+ proposalId decimal(20,0) not null primary key,
+ groupId decimal(20,0),
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ userName varchar(75) null,
+ createDate datetime null,
+ modifiedDate datetime null,
+ classNameId decimal(20,0),
+ classPK varchar(75) null,
+ name varchar(75) null,
+ description varchar(1000) null,
+ publishDate datetime null,
+ dueDate datetime null
+)
+go
+
+create table TasksReview (
+ reviewId decimal(20,0) not null primary key,
+ groupId decimal(20,0),
+ companyId decimal(20,0),
+ userId decimal(20,0),
+ userName varchar(75) null,
+ createDate datetime null,
+ modifiedDate datetime null,
+ proposalId decimal(20,0),
+ assignedByUserId decimal(20,0),
+ assignedByUserName varchar(75) null,
+ stage int,
+ completed int,
+ rejected int
+)
+go
+
+alter table WikiPage add parentTitle varchar(75) null;
+alter table WikiPage add redirectTitle varchar(75) null;