-
Notifications
You must be signed in to change notification settings - Fork 3.6k
/
update-5.2.2-5.2.3.sql
100 lines (69 loc) · 2.61 KB
/
update-5.2.2-5.2.3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
alter table BookmarksEntry add groupId LONG;
create table BrowserTracker (
browserTrackerId LONG not null primary key,
userId LONG,
browserKey LONG
);
update CalEvent set remindBy = '0' where remindBy = 'none';
update CalEvent set remindBy = '1' where remindBy = 'email';
update CalEvent set remindBy = '2' where remindBy = 'sms';
update CalEvent set remindBy = '3' where remindBy = 'aim';
update CalEvent set remindBy = '4' where remindBy = 'icq';
update CalEvent set remindBy = '5' where remindBy = 'msn';
update CalEvent set remindBy = '6' where remindBy = 'ym';
alter table Company add system BOOLEAN;
COMMIT_TRANSACTION;
update Company set system = FALSE;
alter table DLFileEntry add groupId LONG;
alter table DLFileRank add groupId LONG;
alter table DLFileShortcut add groupId LONG;
alter table DLFileVersion add groupId LONG;
update Group_ set name = classPK where classPK > 0 and name = '';
alter table IGImage add groupId LONG;
alter table JournalArticle add urlTitle VARCHAR(150) null;
COMMIT_TRANSACTION;
update JournalArticle set urlTitle = articleId;
alter table MBCategory add threadCount INTEGER;
alter table MBCategory add messageCount INTEGER;
alter table MBMessage add groupId LONG;
alter table MBMessage add classNameId LONG;
alter table MBMessage add classPK LONG;
alter table MBMessage add priority DOUBLE;
delete from MBMessageFlag where flag = 1;
COMMIT_TRANSACTION;
alter table MBMessageFlag add modifiedDate DATE null;
alter table MBMessageFlag add threadId LONG;
alter table MBThread add groupId LONG;
alter table Organization_ add leftOrganizationId LONG;
alter table Organization_ add rightOrganizationId LONG;
COMMIT_TRANSACTION;
update Organization_ set leftOrganizationId = 0, rightOrganizationId = 0;
update Region set regionCode = 'AB' where countryId = 1 and name = 'Alberta';
create table ResourceAction (
resourceActionId LONG not null primary key,
name VARCHAR(75) null,
actionId VARCHAR(75) null,
bitwiseValue LONG
);
create table ResourcePermission (
resourcePermissionId LONG not null primary key,
companyId LONG,
name VARCHAR(255) null,
scope INTEGER,
primKey VARCHAR(255) null,
roleId LONG,
actionIds LONG
);
COMMIT_TRANSACTION;
create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
create table Shard (
shardId LONG not null primary key,
classNameId LONG,
classPK LONG,
name VARCHAR(75) null
);
alter table User_ add firstName VARCHAR(75) null;
alter table User_ add middleName VARCHAR(75) null;
alter table User_ add lastName VARCHAR(75) null;
alter table User_ add jobTitle VARCHAR(100) null;
alter table WikiPage add groupId LONG;