134
134
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=3
135
135
WHERE DB_COLUMN_PREFIXname='PluginParameterMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=2;
137
# A_GallerySessionMap_1.0
138
ALTER TABLE DB_TABLE_PREFIXSessionMap
139
MODIFY COLUMN DB_COLUMN_PREFIXdata longtext;
141
UPDATE DB_TABLE_PREFIXSchema
142
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
143
WHERE DB_COLUMN_PREFIXname='SessionMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
137
145
# A_GalleryUser_1.0
138
146
ALTER TABLE DB_TABLE_PREFIXUser
139
147
MODIFY COLUMN DB_COLUMN_PREFIXemail varchar(255);
150
158
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
151
159
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
162
ALTER TABLE DB_TABLE_PREFIXSchema
163
ADD COLUMN DB_COLUMN_PREFIXcreateSql text;
165
UPDATE DB_TABLE_PREFIXSchema
166
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
167
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
170
ALTER TABLE DB_TABLE_PREFIXSchema
171
ADD COLUMN DB_COLUMN_PREFIXpluginId varchar(32),
172
ADD COLUMN DB_COLUMN_PREFIXtype varchar(32),
173
ADD COLUMN DB_COLUMN_PREFIXinfo text;
175
UPDATE DB_TABLE_PREFIXSchema
176
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
177
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
154
180
CREATE TABLE DB_TABLE_PREFIXExternalIdMap(
155
181
DB_COLUMN_PREFIXexternalId varchar(128) NOT NULL,
637
663
DB_COLUMN_PREFIXremoteIdentifier varchar(128) NOT NULL,
638
664
DB_COLUMN_PREFIXcreationTimestamp int(11) NOT NULL,
639
665
DB_COLUMN_PREFIXmodificationTimestamp int(11) NOT NULL,
640
DB_COLUMN_PREFIXdata text,
666
DB_COLUMN_PREFIXdata longtext,
641
667
PRIMARY KEY(DB_COLUMN_PREFIXid),
642
668
INDEX DB_TABLE_PREFIXSessionMap_53500(DB_COLUMN_PREFIXuserId, DB_COLUMN_PREFIXcreationTimestamp, DB_COLUMN_PREFIXmodificationTimestamp)
813
839
DB_COLUMN_PREFIXname varchar(128) NOT NULL,
814
840
DB_COLUMN_PREFIXmajor int(11) NOT NULL,
815
841
DB_COLUMN_PREFIXminor int(11) NOT NULL,
842
DB_COLUMN_PREFIXcreateSql text,
843
DB_COLUMN_PREFIXpluginId varchar(32),
844
DB_COLUMN_PREFIXtype varchar(32),
845
DB_COLUMN_PREFIXinfo text,
816
846
PRIMARY KEY(DB_COLUMN_PREFIXname)
818
848
/*!40100 DEFAULT CHARACTER SET utf8 */;
1047
1077
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=3
1048
1078
WHERE DB_COLUMN_PREFIXname='PluginParameterMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=2;
1080
# A_GallerySessionMap_1.0
1081
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD COLUMN DB_COLUMN_PREFIXdataTemp text;
1083
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdataTemp = CAST(DB_COLUMN_PREFIXdata AS text);
1085
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP DB_COLUMN_PREFIXdata;
1087
ALTER TABLE DB_TABLE_PREFIXSessionMap RENAME DB_COLUMN_PREFIXdataTemp to DB_COLUMN_PREFIXdata;
1089
UPDATE DB_TABLE_PREFIXSchema
1090
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
1091
WHERE DB_COLUMN_PREFIXname='SessionMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
1050
1093
# A_GalleryUser_1.0
1051
1094
ALTER TABLE DB_TABLE_PREFIXUser ADD COLUMN DB_COLUMN_PREFIXemailTemp VARCHAR(255);
1071
1114
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
1072
1115
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
1118
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXcreateSql text;
1120
UPDATE DB_TABLE_PREFIXSchema
1121
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
1122
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
1125
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXpluginId VARCHAR(32);
1127
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXtype VARCHAR(32);
1129
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXinfo text;
1131
UPDATE DB_TABLE_PREFIXSchema
1132
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
1133
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
1074
1135
# ExternalIdMap
1075
1136
CREATE TABLE DB_TABLE_PREFIXExternalIdMap(
1076
1137
DB_COLUMN_PREFIXexternalId VARCHAR(128) NOT NULL,
1759
1820
CREATE TABLE DB_TABLE_PREFIXSchema(
1760
1821
DB_COLUMN_PREFIXname VARCHAR(128) NOT NULL,
1761
1822
DB_COLUMN_PREFIXmajor INTEGER NOT NULL,
1762
DB_COLUMN_PREFIXminor INTEGER NOT NULL
1823
DB_COLUMN_PREFIXminor INTEGER NOT NULL,
1824
DB_COLUMN_PREFIXcreateSql text,
1825
DB_COLUMN_PREFIXpluginId VARCHAR(32),
1826
DB_COLUMN_PREFIXtype VARCHAR(32),
1827
DB_COLUMN_PREFIXinfo text
1765
1830
ALTER TABLE DB_TABLE_PREFIXSchema ADD PRIMARY KEY (DB_COLUMN_PREFIXname);
1991
2056
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=3
1992
2057
WHERE DB_COLUMN_PREFIXname='PluginParameterMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=2;
2059
# A_GallerySessionMap_1.0
2060
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD (DB_COLUMN_PREFIXdataTemp CLOB);
2062
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdataTemp = DB_COLUMN_PREFIXdata;
2064
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP (DB_COLUMN_PREFIXdata);
2066
ALTER TABLE DB_TABLE_PREFIXSessionMap RENAME COLUMN DB_COLUMN_PREFIXdataTemp TO DB_COLUMN_PREFIXdata;
2068
UPDATE DB_TABLE_PREFIXSchema
2069
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
2070
WHERE DB_COLUMN_PREFIXname='SessionMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
1994
2072
# A_GalleryUser_1.0
1995
2073
ALTER TABLE DB_TABLE_PREFIXUser ADD (DB_COLUMN_PREFIXemailTemp VARCHAR2(255));
2012
2090
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
2013
2091
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
2094
ALTER TABLE DB_TABLE_PREFIXSchema
2095
ADD (DB_COLUMN_PREFIXcreateSql VARCHAR2(4000));
2097
UPDATE DB_TABLE_PREFIXSchema
2098
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
2099
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
2102
ALTER TABLE DB_TABLE_PREFIXSchema
2103
ADD (DB_COLUMN_PREFIXpluginId VARCHAR2(32));
2105
ALTER TABLE DB_TABLE_PREFIXSchema
2106
ADD (DB_COLUMN_PREFIXtype VARCHAR2(32));
2108
ALTER TABLE DB_TABLE_PREFIXSchema
2109
ADD (DB_COLUMN_PREFIXinfo CLOB);
2111
UPDATE DB_TABLE_PREFIXSchema
2112
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
2113
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
2015
2115
# ExternalIdMap
2016
2116
CREATE TABLE DB_TABLE_PREFIXExternalIdMap(
2017
2117
DB_COLUMN_PREFIXexternalId VARCHAR2(128) NOT NULL,
2791
2891
CREATE TABLE DB_TABLE_PREFIXSchema(
2792
2892
DB_COLUMN_PREFIXname VARCHAR2(128) NOT NULL,
2793
2893
DB_COLUMN_PREFIXmajor INTEGER NOT NULL,
2794
DB_COLUMN_PREFIXminor INTEGER NOT NULL
2894
DB_COLUMN_PREFIXminor INTEGER NOT NULL,
2895
DB_COLUMN_PREFIXcreateSql VARCHAR2(4000),
2896
DB_COLUMN_PREFIXpluginId VARCHAR2(32),
2897
DB_COLUMN_PREFIXtype VARCHAR2(32),
2898
DB_COLUMN_PREFIXinfo CLOB
2797
2901
ALTER TABLE DB_TABLE_PREFIXSchema
2920
3030
UPDATE DB_TABLE_PREFIXGroup SET DB_COLUMN_PREFIXgroupNameTemp = CAST(DB_COLUMN_PREFIXgroupName AS VARCHAR(128));
2922
ALTER TABLE DB_TABLE_PREFIXGroup DROP DB_COLUMN_PREFIXgroupName;
2924
ALTER TABLE DB_TABLE_PREFIXGroup RENAME DB_COLUMN_PREFIXgroupNameTemp to DB_COLUMN_PREFIXgroupName;
3032
ALTER TABLE DB_TABLE_PREFIXGroup DROP COLUMN DB_COLUMN_PREFIXgroupName;
3034
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXGroup');
3036
ALTER TABLE DB_TABLE_PREFIXGroup ADD COLUMN DB_COLUMN_PREFIXgroupName VARCHAR(128);
3038
UPDATE DB_TABLE_PREFIXGroup SET DB_COLUMN_PREFIXgroupName = DB_COLUMN_PREFIXgroupNameTemp;
3040
ALTER TABLE DB_TABLE_PREFIXGroup DROP COLUMN DB_COLUMN_PREFIXgroupNameTemp;
3042
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXGroup');
2926
3044
UPDATE DB_TABLE_PREFIXSchema
2927
3045
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
2947
3065
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginTypeTemp = CAST(DB_COLUMN_PREFIXpluginType AS VARCHAR(32));
2949
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP DB_COLUMN_PREFIXpluginType;
2951
ALTER TABLE DB_TABLE_PREFIXPluginMap RENAME DB_COLUMN_PREFIXpluginTypeTemp to DB_COLUMN_PREFIXpluginType;
3067
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginType;
3069
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginMap');
3071
ALTER TABLE DB_TABLE_PREFIXPluginMap ADD COLUMN DB_COLUMN_PREFIXpluginType VARCHAR(32);
3073
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginType = DB_COLUMN_PREFIXpluginTypeTemp;
3075
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginTypeTemp;
3077
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginMap');
2953
3079
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER DB_COLUMN_PREFIXpluginType SET NOT NULL;
2957
3083
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginIdTemp = CAST(DB_COLUMN_PREFIXpluginId AS VARCHAR(32));
2959
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP DB_COLUMN_PREFIXpluginId;
2961
ALTER TABLE DB_TABLE_PREFIXPluginMap RENAME DB_COLUMN_PREFIXpluginIdTemp to DB_COLUMN_PREFIXpluginId;
3085
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginId;
3087
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginMap');
3089
ALTER TABLE DB_TABLE_PREFIXPluginMap ADD COLUMN DB_COLUMN_PREFIXpluginId VARCHAR(32);
3091
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginId = DB_COLUMN_PREFIXpluginIdTemp;
3093
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginIdTemp;
3095
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginMap');
2963
3097
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER DB_COLUMN_PREFIXpluginId SET NOT NULL;
2979
3113
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginTypeTemp = CAST(DB_COLUMN_PREFIXpluginType AS VARCHAR(32));
2981
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXpluginType;
2983
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXpluginTypeTemp to DB_COLUMN_PREFIXpluginType;
3115
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginType;
3117
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
3119
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD COLUMN DB_COLUMN_PREFIXpluginType VARCHAR(32);
3121
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginType = DB_COLUMN_PREFIXpluginTypeTemp;
3123
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginTypeTemp;
3125
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
2985
3127
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXpluginType SET NOT NULL;
2989
3131
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginIdTemp = CAST(DB_COLUMN_PREFIXpluginId AS VARCHAR(32));
2991
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXpluginId;
2993
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXpluginIdTemp to DB_COLUMN_PREFIXpluginId;
3133
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginId;
3135
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
3137
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD COLUMN DB_COLUMN_PREFIXpluginId VARCHAR(32);
3139
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginId = DB_COLUMN_PREFIXpluginIdTemp;
3141
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginIdTemp;
3143
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
2995
3145
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXpluginId SET NOT NULL;
3009
3159
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXparameterValueTemp = CAST(DB_COLUMN_PREFIXparameterValue AS VARCHAR(10000));
3011
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXparameterValue;
3013
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXparameterValueTemp to DB_COLUMN_PREFIXparameterValue;
3161
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXparameterValue;
3163
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
3165
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD COLUMN DB_COLUMN_PREFIXparameterValue VARCHAR(10000);
3167
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXparameterValue = DB_COLUMN_PREFIXparameterValueTemp;
3169
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXparameterValueTemp;
3171
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXPluginParameterMap');
3015
3173
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXparameterValue SET NOT NULL;
3018
3176
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=3
3019
3177
WHERE DB_COLUMN_PREFIXname='PluginParameterMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=2;
3179
# A_GallerySessionMap_1.0
3180
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD COLUMN DB_COLUMN_PREFIXdataTemp CLOB(2G) NOT LOGGED;
3182
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdataTemp = DB_COLUMN_PREFIXdata;
3184
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP COLUMN DB_COLUMN_PREFIXdata;
3186
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXSessionMap');
3188
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD COLUMN DB_COLUMN_PREFIXdata CLOB(2G) NOT LOGGED;
3190
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdata = DB_COLUMN_PREFIXdataTemp;
3192
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP COLUMN DB_COLUMN_PREFIXdataTemp;
3194
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXSessionMap');
3196
UPDATE DB_TABLE_PREFIXSchema
3197
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3198
WHERE DB_COLUMN_PREFIXname='SessionMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
3021
3200
# A_GalleryUser_1.0
3022
3201
ALTER TABLE DB_TABLE_PREFIXUser ADD COLUMN DB_COLUMN_PREFIXemailTemp VARCHAR(255);
3024
3203
UPDATE DB_TABLE_PREFIXUser SET DB_COLUMN_PREFIXemailTemp = CAST(DB_COLUMN_PREFIXemail AS VARCHAR(255));
3026
ALTER TABLE DB_TABLE_PREFIXUser DROP DB_COLUMN_PREFIXemail;
3028
ALTER TABLE DB_TABLE_PREFIXUser RENAME DB_COLUMN_PREFIXemailTemp to DB_COLUMN_PREFIXemail;
3205
ALTER TABLE DB_TABLE_PREFIXUser DROP COLUMN DB_COLUMN_PREFIXemail;
3207
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXUser');
3209
ALTER TABLE DB_TABLE_PREFIXUser ADD COLUMN DB_COLUMN_PREFIXemail VARCHAR(255);
3211
UPDATE DB_TABLE_PREFIXUser SET DB_COLUMN_PREFIXemail = DB_COLUMN_PREFIXemailTemp;
3213
ALTER TABLE DB_TABLE_PREFIXUser DROP COLUMN DB_COLUMN_PREFIXemailTemp;
3215
CALL ADMIN_CMD ('REORG TABLE DB_TABLE_PREFIXUser');
3030
3217
UPDATE DB_TABLE_PREFIXSchema
3031
3218
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3038
3225
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
3039
3226
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
3229
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXcreateSql VARCHAR(10000);
3231
UPDATE DB_TABLE_PREFIXSchema
3232
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3233
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
3236
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXpluginId VARCHAR(32);
3238
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXtype VARCHAR(32);
3240
ALTER TABLE DB_TABLE_PREFIXSchema ADD COLUMN DB_COLUMN_PREFIXinfo VARCHAR(15000);
3242
UPDATE DB_TABLE_PREFIXSchema
3243
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
3244
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
3041
3246
# ExternalIdMap
3042
3247
CREATE TABLE DB_TABLE_PREFIXExternalIdMap(
3043
3248
DB_COLUMN_PREFIXexternalId VARCHAR(128) NOT NULL,
3765
3970
CREATE TABLE DB_TABLE_PREFIXSchema(
3766
3971
DB_COLUMN_PREFIXname VARCHAR(128) NOT NULL,
3767
3972
DB_COLUMN_PREFIXmajor INTEGER NOT NULL,
3768
DB_COLUMN_PREFIXminor INTEGER NOT NULL
3973
DB_COLUMN_PREFIXminor INTEGER NOT NULL,
3974
DB_COLUMN_PREFIXcreateSql VARCHAR(10000),
3975
DB_COLUMN_PREFIXpluginId VARCHAR(32),
3976
DB_COLUMN_PREFIXtype VARCHAR(32),
3977
DB_COLUMN_PREFIXinfo VARCHAR(15000)
3771
3980
ALTER TABLE DB_TABLE_PREFIXSchema ADD PRIMARY KEY (DB_COLUMN_PREFIXname);
3888
4093
WHERE DB_COLUMN_PREFIXname='Entity' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
3890
4095
# A_GalleryGroup_1.0
3891
ALTER TABLE DB_TABLE_PREFIXGroup ADD DB_COLUMN_PREFIXgroupNameTemp NVARCHAR(128) NULL;
3893
UPDATE DB_TABLE_PREFIXGroup SET DB_COLUMN_PREFIXgroupNameTemp = CAST(DB_COLUMN_PREFIXgroupName AS NVARCHAR(128) NULL);
3895
ALTER TABLE DB_TABLE_PREFIXGroup DROP DB_COLUMN_PREFIXgroupName;
3897
ALTER TABLE DB_TABLE_PREFIXGroup RENAME DB_COLUMN_PREFIXgroupNameTemp to DB_COLUMN_PREFIXgroupName;
4096
ALTER TABLE DB_TABLE_PREFIXGroup ADD DB_COLUMN_PREFIXgroupNameTemp NVARCHAR(128);
4098
UPDATE DB_TABLE_PREFIXGroup SET DB_COLUMN_PREFIXgroupNameTemp = CAST(DB_COLUMN_PREFIXgroupName AS NVARCHAR(128));
4100
ALTER TABLE DB_TABLE_PREFIXGroup DROP COLUMN DB_COLUMN_PREFIXgroupName;
4102
ALTER TABLE DB_TABLE_PREFIXGroup ADD DB_COLUMN_PREFIXgroupName NVARCHAR(128);
4104
UPDATE DB_TABLE_PREFIXGroup SET DB_COLUMN_PREFIXgroupName = DB_COLUMN_PREFIXgroupNameTemp;
4106
ALTER TABLE DB_TABLE_PREFIXGroup DROP COLUMN DB_COLUMN_PREFIXgroupNameTemp;
3899
4108
UPDATE DB_TABLE_PREFIXSchema
3900
4109
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3920
4129
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginTypeTemp = CAST(DB_COLUMN_PREFIXpluginType AS NVARCHAR(32));
3922
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP DB_COLUMN_PREFIXpluginType;
3924
ALTER TABLE DB_TABLE_PREFIXPluginMap RENAME DB_COLUMN_PREFIXpluginTypeTemp to DB_COLUMN_PREFIXpluginType;
3926
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER DB_COLUMN_PREFIXpluginType SET NOT NULL;
4131
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginType;
4133
ALTER TABLE DB_TABLE_PREFIXPluginMap ADD DB_COLUMN_PREFIXpluginType NVARCHAR(32);
4135
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginType = DB_COLUMN_PREFIXpluginTypeTemp;
4137
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginTypeTemp;
4139
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER COLUMN DB_COLUMN_PREFIXpluginType NVARCHAR(32) NOT NULL;
3928
4141
ALTER TABLE DB_TABLE_PREFIXPluginMap ADD DB_COLUMN_PREFIXpluginIdTemp NVARCHAR(32);
3930
4143
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginIdTemp = CAST(DB_COLUMN_PREFIXpluginId AS NVARCHAR(32));
3932
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP DB_COLUMN_PREFIXpluginId;
3934
ALTER TABLE DB_TABLE_PREFIXPluginMap RENAME DB_COLUMN_PREFIXpluginIdTemp to DB_COLUMN_PREFIXpluginId;
3936
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER DB_COLUMN_PREFIXpluginId SET NOT NULL;
4145
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginId;
4147
ALTER TABLE DB_TABLE_PREFIXPluginMap ADD DB_COLUMN_PREFIXpluginId NVARCHAR(32);
4149
UPDATE DB_TABLE_PREFIXPluginMap SET DB_COLUMN_PREFIXpluginId = DB_COLUMN_PREFIXpluginIdTemp;
4151
ALTER TABLE DB_TABLE_PREFIXPluginMap DROP COLUMN DB_COLUMN_PREFIXpluginIdTemp;
4153
ALTER TABLE DB_TABLE_PREFIXPluginMap ALTER COLUMN DB_COLUMN_PREFIXpluginId NVARCHAR(32) NOT NULL;
3938
4155
UPDATE DB_TABLE_PREFIXSchema
3939
4156
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3940
4157
WHERE DB_COLUMN_PREFIXname='PluginMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
3942
4159
# A_GalleryPluginPackageMap_1.0
3943
ALTER TABLE DB_TABLE_PREFIXPluginPackageMap ADD DB_COLUMN_PREFIXlocked BIT;
3945
ALTER TABLE DB_TABLE_PREFIXPluginPackageMap ALTER COLUMN DB_COLUMN_PREFIXlocked BIT NOT NULL;
3947
ALTER TABLE DB_TABLE_PREFIXPluginPackageMap ADD CONSTRAINT DB_COLUMN_PREFIXlocked_82449 DEFAULT '0' FOR DB_COLUMN_PREFIXlocked;
4160
ALTER TABLE DB_TABLE_PREFIXPluginPackageMap ADD DB_COLUMN_PREFIXlocked BIT DEFAULT '0' NOT NULL;
3949
4162
UPDATE DB_TABLE_PREFIXSchema
3950
4163
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3956
4169
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginTypeTemp = CAST(DB_COLUMN_PREFIXpluginType AS NVARCHAR(32));
3958
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXpluginType;
3960
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXpluginTypeTemp to DB_COLUMN_PREFIXpluginType;
3962
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXpluginType SET NOT NULL;
4171
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginType;
4173
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD DB_COLUMN_PREFIXpluginType NVARCHAR(32);
4175
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginType = DB_COLUMN_PREFIXpluginTypeTemp;
4177
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginTypeTemp;
4179
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER COLUMN DB_COLUMN_PREFIXpluginType NVARCHAR(32) NOT NULL;
3964
4181
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD DB_COLUMN_PREFIXpluginIdTemp NVARCHAR(32);
3966
4183
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginIdTemp = CAST(DB_COLUMN_PREFIXpluginId AS NVARCHAR(32));
3968
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXpluginId;
3970
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXpluginIdTemp to DB_COLUMN_PREFIXpluginId;
3972
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXpluginId SET NOT NULL;
4185
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginId;
4187
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD DB_COLUMN_PREFIXpluginId NVARCHAR(32);
4189
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXpluginId = DB_COLUMN_PREFIXpluginIdTemp;
4191
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXpluginIdTemp;
4193
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER COLUMN DB_COLUMN_PREFIXpluginId NVARCHAR(32) NOT NULL;
3974
4195
UPDATE DB_TABLE_PREFIXSchema
3975
4196
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
3986
4207
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXparameterValueTemp = CAST(DB_COLUMN_PREFIXparameterValue AS NVARCHAR(MAX));
3988
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP DB_COLUMN_PREFIXparameterValue;
3990
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap RENAME DB_COLUMN_PREFIXparameterValueTemp to DB_COLUMN_PREFIXparameterValue;
3992
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER DB_COLUMN_PREFIXparameterValue SET NOT NULL;
4209
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXparameterValue;
4211
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ADD DB_COLUMN_PREFIXparameterValue NVARCHAR(MAX);
4213
UPDATE DB_TABLE_PREFIXPluginParameterMap SET DB_COLUMN_PREFIXparameterValue = DB_COLUMN_PREFIXparameterValueTemp;
4215
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap DROP COLUMN DB_COLUMN_PREFIXparameterValueTemp;
4217
ALTER TABLE DB_TABLE_PREFIXPluginParameterMap ALTER COLUMN DB_COLUMN_PREFIXparameterValue NVARCHAR(MAX) NOT NULL;
3994
4219
UPDATE DB_TABLE_PREFIXSchema
3995
4220
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=3
3996
4221
WHERE DB_COLUMN_PREFIXname='PluginParameterMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=2;
4223
# A_GallerySessionMap_1.0
4224
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD DB_COLUMN_PREFIXdataTemp NVARCHAR(MAX);
4226
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdataTemp = CAST(DB_COLUMN_PREFIXdata AS NVARCHAR(MAX));
4228
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP COLUMN DB_COLUMN_PREFIXdata;
4230
ALTER TABLE DB_TABLE_PREFIXSessionMap ADD DB_COLUMN_PREFIXdata NVARCHAR(MAX);
4232
UPDATE DB_TABLE_PREFIXSessionMap SET DB_COLUMN_PREFIXdata = DB_COLUMN_PREFIXdataTemp;
4234
ALTER TABLE DB_TABLE_PREFIXSessionMap DROP COLUMN DB_COLUMN_PREFIXdataTemp;
4236
UPDATE DB_TABLE_PREFIXSchema
4237
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
4238
WHERE DB_COLUMN_PREFIXname='SessionMap' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
3998
4240
# A_GalleryUser_1.0
3999
ALTER TABLE DB_TABLE_PREFIXUser ADD DB_COLUMN_PREFIXemailTemp NVARCHAR(255) NULL;
4001
UPDATE DB_TABLE_PREFIXUser SET DB_COLUMN_PREFIXemailTemp = CAST(DB_COLUMN_PREFIXemail AS NVARCHAR(255) NULL);
4003
ALTER TABLE DB_TABLE_PREFIXUser DROP DB_COLUMN_PREFIXemail;
4005
ALTER TABLE DB_TABLE_PREFIXUser RENAME DB_COLUMN_PREFIXemailTemp to DB_COLUMN_PREFIXemail;
4241
ALTER TABLE DB_TABLE_PREFIXUser ADD DB_COLUMN_PREFIXemailTemp NVARCHAR(255);
4243
UPDATE DB_TABLE_PREFIXUser SET DB_COLUMN_PREFIXemailTemp = CAST(DB_COLUMN_PREFIXemail AS NVARCHAR(255));
4245
ALTER TABLE DB_TABLE_PREFIXUser DROP COLUMN DB_COLUMN_PREFIXemail;
4247
ALTER TABLE DB_TABLE_PREFIXUser ADD DB_COLUMN_PREFIXemail NVARCHAR(255);
4249
UPDATE DB_TABLE_PREFIXUser SET DB_COLUMN_PREFIXemail = DB_COLUMN_PREFIXemailTemp;
4251
ALTER TABLE DB_TABLE_PREFIXUser DROP COLUMN DB_COLUMN_PREFIXemailTemp;
4007
4253
UPDATE DB_TABLE_PREFIXSchema
4008
4254
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
4009
4255
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
4011
4257
# A_GalleryUser_1.1
4012
ALTER TABLE DB_TABLE_PREFIXUser ADD DB_COLUMN_PREFIXlocked BIT NULL;
4014
ALTER TABLE DB_TABLE_PREFIXUser ADD CONSTRAINT DB_COLUMN_PREFIXlocked_82449 DEFAULT '0' FOR DB_COLUMN_PREFIXlocked;
4258
ALTER TABLE DB_TABLE_PREFIXUser ADD DB_COLUMN_PREFIXlocked BIT DEFAULT '0' NULL;
4016
4260
UPDATE DB_TABLE_PREFIXSchema
4017
4261
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
4018
4262
WHERE DB_COLUMN_PREFIXname='User' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
4265
ALTER TABLE DB_TABLE_PREFIXSchema ADD DB_COLUMN_PREFIXcreateSql NVARCHAR(MAX) NULL;
4267
UPDATE DB_TABLE_PREFIXSchema
4268
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1
4269
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=0;
4272
ALTER TABLE DB_TABLE_PREFIXSchema ADD DB_COLUMN_PREFIXpluginId NVARCHAR(32) NULL;
4274
ALTER TABLE DB_TABLE_PREFIXSchema ADD DB_COLUMN_PREFIXtype NVARCHAR(32) NULL;
4276
ALTER TABLE DB_TABLE_PREFIXSchema ADD DB_COLUMN_PREFIXinfo NVARCHAR(MAX) NULL;
4278
UPDATE DB_TABLE_PREFIXSchema
4279
SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=2
4280
WHERE DB_COLUMN_PREFIXname='Schema' AND DB_COLUMN_PREFIXmajor=1 AND DB_COLUMN_PREFIXminor=1;
4020
4282
# ExternalIdMap
4021
4283
CREATE TABLE DB_TABLE_PREFIXExternalIdMap(
4022
4284
DB_COLUMN_PREFIXexternalId NVARCHAR(128) NOT NULL,
4705
4967
CREATE TABLE DB_TABLE_PREFIXSchema(
4706
4968
DB_COLUMN_PREFIXname NVARCHAR(128) NOT NULL,
4707
4969
DB_COLUMN_PREFIXmajor INT NOT NULL,
4708
DB_COLUMN_PREFIXminor INT NOT NULL
4970
DB_COLUMN_PREFIXminor INT NOT NULL,
4971
DB_COLUMN_PREFIXcreateSql NVARCHAR(MAX) NULL,
4972
DB_COLUMN_PREFIXpluginId NVARCHAR(32) NULL,
4973
DB_COLUMN_PREFIXtype NVARCHAR(32) NULL,
4974
DB_COLUMN_PREFIXinfo NVARCHAR(MAX) NULL
4711
4977
ALTER TABLE DB_TABLE_PREFIXSchema ADD PRIMARY KEY (DB_COLUMN_PREFIXname);