Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

101 lines (85 sloc) 3.366 kb
alter table BlogsEntry add draft BOOLEAN;
alter table BlogsEntry add allowTrackbacks BOOLEAN;
alter table BlogsEntry add trackbacks TEXT null;
COMMIT_TRANSACTION;
update BlogsEntry set draft = FALSE;
update BlogsEntry set allowTrackbacks = TRUE;
alter table Contact_ add facebookSn VARCHAR(75) null;
alter table Contact_ add mySpaceSn VARCHAR(75) null;
alter table Contact_ add twitterSn VARCHAR(75) null;
update Country set a2 = 'KR' where countryId = 10;
update Country set a2 = 'CR' where countryId = 69;
update Country set a2 = 'NI', a3 = 'NIC' where countryId = 159;
update Country set a2 = 'RS', a3 = 'SRB' where countryId = 189;
drop table ExpandoRow;
create table ExpandoRow (
rowId_ LONG not null primary key,
tableId LONG,
classPK LONG
);
drop table ExpandoValue;
create table ExpandoValue (
valueId LONG not null primary key,
tableId LONG,
columnId LONG,
rowId_ LONG,
classNameId LONG,
classPK LONG,
data_ STRING null
);
drop table SocialActivity;
create table SocialActivity (
activityId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate DATE null,
mirrorActivityId LONG,
classNameId LONG,
classPK LONG,
type_ INTEGER,
extraData STRING null,
receiverUserId LONG
);
create table SocialRequest (
uuid_ VARCHAR(75) null,
requestId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate DATE null,
modifiedDate DATE null,
classNameId LONG,
classPK LONG,
type_ INTEGER,
extraData STRING null,
receiverUserId LONG,
status INTEGER
);
alter table User_ add openId VARCHAR(1024) null;
update User_ set timeZoneId = 'America/Anchorage' where timeZoneId = 'AST';
update User_ set timeZoneId = 'America/Los_Angeles' where timeZoneId = 'PST';
update User_ set timeZoneId = 'America/Denver' where timeZoneId = 'MST';
update User_ set timeZoneId = 'America/Chicago' where timeZoneId = 'CST';
update User_ set timeZoneId = 'America/New_York' where timeZoneId = 'EST';
update User_ set timeZoneId = 'America/Puerto_Rico' where timeZoneId = 'PRT';
update User_ set timeZoneId = 'America/St_Johns' where timeZoneId = 'CNT';
update User_ set timeZoneId = 'America/Sao_Paulo' where timeZoneId = 'BET';
update User_ set timeZoneId = 'UTC' where timeZoneId = 'GMT';
update User_ set timeZoneId = 'Europe/Lisbon' where timeZoneId = 'WET';
update User_ set timeZoneId = 'Europe/Paris' where timeZoneId = 'CET';
update User_ set timeZoneId = 'Europe/Istanbul' where timeZoneId = 'EET';
update User_ set timeZoneId = 'Asia/Tehran' where timeZoneId = 'Iran';
update User_ set timeZoneId = 'Asia/Calcutta' where timeZoneId = 'IST';
update User_ set timeZoneId = 'Asia/Saigon' where timeZoneId = 'VST';
update User_ set timeZoneId = 'Asia/Shanghai' where timeZoneId = 'CTT';
update User_ set timeZoneId = 'Asia/Tokyo' where timeZoneId = 'JST';
update User_ set timeZoneId = 'Asia/Seoul' where timeZoneId = 'ROK';
update User_ set timeZoneId = 'Australia/Darwin' where timeZoneId = 'ACT';
update User_ set timeZoneId = 'Australia/Sydney' where timeZoneId = 'AET';
update User_ set timeZoneId = 'Pacific/Guadalcanal' where timeZoneId = 'SST';
update User_ set timeZoneId = 'Pacific/Auckland' where timeZoneId = 'NST';
alter table WikiPage add modifiedDate DATE null;
alter table WikiPage add summary STRING null;
COMMIT_TRANSACTION;
update WikiPage set modifiedDate = createDate;
Jump to Line
Something went wrong with that request. Please try again.