Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 100 lines (84 sloc) 2.423 kB
534f9cd @brianchandotcom LPS-9269 Do copy the values so you can later do joins faster
brianchandotcom authored
1 alter table AssetEntry add socialInformationEquity DOUBLE;
2
51fcd48 @lionah LPS-9828 Manual
lionah authored
3 alter table Company add maxUsers INTEGER;
4
5 COMMIT_TRANSACTION;
6
7 update Company set maxUsers = 0;
8
144459f @brianchandotcom LPS-9828 Manual
brianchandotcom authored
9 update ExpandoTable set name = 'CUSTOM_FIELDS' where name = 'DEFAULT_TABLE'
10
ca21534 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
11 alter table LayoutSet add settings_ TEXT null;
12
6f80214 @JorgeFerrer LPS-9821 The MBMessage entries associated to discussions should also …
JorgeFerrer authored
13 update MBThread set categoryId = -1 where groupId = 0;
14
ebbebcc @brianchandotcom LPS-9733 Source formatting (rename alphaNumeric to alphanumeric accor…
brianchandotcom authored
15 alter table PasswordPolicy add minAlphanumeric INTEGER;
ef3f1c4 @mikakoivisto LPS-5969 Manual
mikakoivisto authored
16 alter table PasswordPolicy add minLowerCase INTEGER;
17 alter table PasswordPolicy add minNumbers INTEGER;
18 alter table PasswordPolicy add minSpecial INTEGER;
19 alter table PasswordPolicy add minUpperCase INTEGER;
3f9d955 @mikakoivisto LPS-8484 Manual / Password reset link
mikakoivisto authored
20 alter table PasswordPolicy add resetTicketMaxAge LONG;
d4abf22 @brianchandotcom LPS-8484 Source formatting / refactor
brianchandotcom authored
21
22 COMMIT_TRANSACTION;
23
ebbebcc @brianchandotcom LPS-9733 Source formatting (rename alphaNumeric to alphanumeric accor…
brianchandotcom authored
24 update PasswordPolicy set minAlphanumeric = 0;
ef3f1c4 @mikakoivisto LPS-5969 Manual
mikakoivisto authored
25 update PasswordPolicy set minLowerCase = 0;
26 update PasswordPolicy set minNumbers = 0;
27 update PasswordPolicy set minSymbols = 0;
28 update PasswordPolicy set minUpperCase = 0;
3f9d955 @mikakoivisto LPS-8484 Manual / Password reset link
mikakoivisto authored
29 update PasswordPolicy set resetTicketMaxAge = 86400;
30
4ad5b40 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
31 create table SocialEquityAssetEntry (
32 equityAssetEntryId LONG not null primary key,
c53d437 @brianchandotcom LPS-9269 Scope asset stats per group
brianchandotcom authored
33 groupId LONG,
4ad5b40 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
34 companyId LONG,
35 userId LONG,
36 assetEntryId LONG,
37 informationK DOUBLE,
38 informationB DOUBLE,
39 informationEquity DOUBLE
40 );
41
ca21534 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
42 create table SocialEquityHistory (
43 equityHistoryId LONG not null primary key,
44 groupId LONG,
45 companyId LONG,
46 userId LONG,
47 createDate DATE null,
48 personalEquity INTEGER
49 );
50
51 create table SocialEquityLog (
52 equityLogId LONG not null primary key,
53 groupId LONG,
54 companyId LONG,
55 userId LONG,
56 assetEntryId LONG,
57 actionId VARCHAR(75) null,
58 actionDate INTEGER,
59 type_ INTEGER,
60 value INTEGER,
4ad5b40 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
61 validity INTEGER,
62 active_ BOOLEAN
ca21534 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
63 );
64
65 create table SocialEquitySetting (
66 equitySettingId LONG not null primary key,
67 groupId LONG,
68 companyId LONG,
69 classNameId LONG,
70 actionId VARCHAR(75) null,
71 type_ INTEGER,
72 value INTEGER,
4ad5b40 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
73 validity INTEGER
74 );
75
76 create table SocialEquityUser (
77 equityUserId LONG not null primary key,
e32728d @brianchandotcom LPS-9269 Scope user stats per group
brianchandotcom authored
78 groupId LONG,
4ad5b40 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
79 companyId LONG,
80 userId LONG,
81 contributionEquity DOUBLE,
82 participationK DOUBLE,
83 participationB DOUBLE,
84 participationEquity DOUBLE,
85 personalEquity DOUBLE
ca21534 @brianchandotcom LPS-9269 Manual
brianchandotcom authored
86 );
87
4f0520c @brianchandotcom LPS-9298 Manual
brianchandotcom authored
88 create table Ticket (
89 ticketId LONG not null primary key,
90 companyId LONG,
91 createDate DATE null,
92 classNameId LONG,
93 classPK LONG,
94 key_ VARCHAR(75) null,
95 expirationDate DATE null
534f9cd @brianchandotcom LPS-9269 Do copy the values so you can later do joins faster
brianchandotcom authored
96 );
97
98 alter table User_ add socialContributionEquity DOUBLE;
99 alter table User_ add socialParticipationEquity DOUBLE;
100 alter table User_ add socialPersonalEquity DOUBLE;
Something went wrong with that request. Please try again.