forked from BEXIS2/Core
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Update_Script_29To210.txt
366 lines (227 loc) · 8.82 KB
/
Update_Script_29To210.txt
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
ALTER TABLE entities ADD COLUMN securable BOOLEAN DEFAULT TRUE;
ALTER TABLE entities ADD COLUMN usemetadata BOOLEAN DEFAULT TRUE;
CREATE TABLE parties (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
name character varying(255),
alias character varying(255),
description character varying(255),
startdate timestamp without time zone,
enddate timestamp without time zone,
partytyperef bigint NOT NULL
);
ALTER TABLE parties OWNER TO postgres;
CREATE SEQUENCE parties_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE parties_id_seq OWNER TO postgres;
ALTER SEQUENCE parties_id_seq OWNED BY parties.id;
CREATE TABLE partycustomattributes (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
name character varying(255),
description character varying(255),
validvalues character varying(255),
isvalueoptional character(1),
displayorder integer,
datatype character varying(255),
partytyperef bigint NOT NULL
);
ALTER TABLE partycustomattributes OWNER TO postgres;
CREATE SEQUENCE partycustomattributes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partycustomattributes_id_seq OWNER TO postgres;
ALTER SEQUENCE partycustomattributes_id_seq OWNED BY partycustomattributes.id;
CREATE TABLE partycustomattributevalues (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
value character varying(255),
customattributeref bigint NOT NULL,
partyref bigint
);
ALTER TABLE partycustomattributevalues OWNER TO postgres;
CREATE SEQUENCE partycustomattributevalues_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partycustomattributevalues_id_seq OWNER TO postgres;
ALTER SEQUENCE partycustomattributevalues_id_seq OWNED BY partycustomattributevalues.id;
CREATE TABLE partyrelationships (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
title character varying(255),
description character varying(255),
startdate timestamp without time zone,
enddate timestamp without time zone,
scope character varying(255),
partyrelationshiptyperef bigint NOT NULL,
firstpartyref bigint NOT NULL,
secondpartyref bigint NOT NULL
);
ALTER TABLE partyrelationships OWNER TO postgres;
CREATE SEQUENCE partyrelationships_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partyrelationships_id_seq OWNER TO postgres;
ALTER SEQUENCE partyrelationships_id_seq OWNED BY partyrelationships.id;
CREATE TABLE partyrelationshiptypes (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
title character varying(255),
description character varying(255),
indicateshierarchy character(1),
mincardinality integer,
maxcardinality integer
);
ALTER TABLE partyrelationshiptypes OWNER TO postgres;
CREATE SEQUENCE partyrelationshiptypes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partyrelationshiptypes_id_seq OWNER TO postgres;
ALTER SEQUENCE partyrelationshiptypes_id_seq OWNED BY partyrelationshiptypes.id;
CREATE TABLE partystatuses (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
"timestamp" timestamp without time zone,
description character varying(255),
changelog xml,
partystatustyperef bigint NOT NULL,
partyref bigint NOT NULL
);
ALTER TABLE partystatuses OWNER TO postgres;
CREATE SEQUENCE partystatuses_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partystatuses_id_seq OWNER TO postgres;
ALTER SEQUENCE partystatuses_id_seq OWNED BY partystatuses.id;
CREATE TABLE partystatustypes (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
name character varying(255),
description character varying(255),
displayorder integer,
partytyperef bigint NOT NULL
);
ALTER TABLE partystatustypes OWNER TO postgres;
CREATE SEQUENCE partystatustypes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partystatustypes_id_seq OWNER TO postgres;
ALTER SEQUENCE partystatustypes_id_seq OWNED BY partystatustypes.id;
CREATE TABLE partytypepairs (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
title character varying(255),
description character varying(255),
alowedsourceref bigint NOT NULL,
alowedtargetref bigint NOT NULL,
partyrelationshiptyperef bigint
);
ALTER TABLE partytypepairs OWNER TO postgres;
CREATE SEQUENCE partytypepairs_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partytypepairs_id_seq OWNER TO postgres;
ALTER SEQUENCE partytypepairs_id_seq OWNED BY partytypepairs.id;
CREATE TABLE partytypes (
id bigint NOT NULL,
versionno integer NOT NULL,
extra xml,
title character varying(255),
description character varying(255)
);
ALTER TABLE partytypes OWNER TO postgres;
CREATE SEQUENCE partytypes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE partytypes_id_seq OWNER TO postgres;
ALTER SEQUENCE partytypes_id_seq OWNED BY partytypes.id;
ALTER TABLE ONLY parties ALTER COLUMN id SET DEFAULT nextval('parties_id_seq'::regclass);
ALTER TABLE ONLY partycustomattributes ALTER COLUMN id SET DEFAULT nextval('partycustomattributes_id_seq'::regclass);
ALTER TABLE ONLY partycustomattributevalues ALTER COLUMN id SET DEFAULT nextval('partycustomattributevalues_id_seq'::regclass);
ALTER TABLE ONLY partyrelationships ALTER COLUMN id SET DEFAULT nextval('partyrelationships_id_seq'::regclass);
ALTER TABLE ONLY partyrelationshiptypes ALTER COLUMN id SET DEFAULT nextval('partyrelationshiptypes_id_seq'::regclass);
ALTER TABLE ONLY partystatuses ALTER COLUMN id SET DEFAULT nextval('partystatuses_id_seq'::regclass);
ALTER TABLE ONLY partystatustypes ALTER COLUMN id SET DEFAULT nextval('partystatustypes_id_seq'::regclass);
ALTER TABLE ONLY partytypepairs ALTER COLUMN id SET DEFAULT nextval('partytypepairs_id_seq'::regclass);
ALTER TABLE ONLY partytypes ALTER COLUMN id SET DEFAULT nextval('partytypes_id_seq'::regclass);
ALTER TABLE ONLY parties
ADD CONSTRAINT parties_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partycustomattributes
ADD CONSTRAINT partycustomattributes_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partycustomattributevalues
ADD CONSTRAINT partycustomattributevalues_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partyrelationships
ADD CONSTRAINT partyrelationships_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partyrelationshiptypes
ADD CONSTRAINT partyrelationshiptypes_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partystatuses
ADD CONSTRAINT partystatuses_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partystatustypes
ADD CONSTRAINT partystatustypes_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partytypepairs
ADD CONSTRAINT partytypepairs_pkey PRIMARY KEY (id);
ALTER TABLE ONLY partytypes
ADD CONSTRAINT partytypes_pkey PRIMARY KEY (id);
-----------------------------
ALTER TABLE ONLY partycustomattributevalues
ADD CONSTRAINT fk381d62f469a94133 FOREIGN KEY (customattributeref) REFERENCES partycustomattributes(id);
ALTER TABLE ONLY partycustomattributevalues
ADD CONSTRAINT fk381d62f49a4d3305 FOREIGN KEY (partyref) REFERENCES parties(id);
ALTER TABLE ONLY partyrelationships
ADD CONSTRAINT fk3e1d9d9a32f02b6a FOREIGN KEY (secondpartyref) REFERENCES parties(id);
ALTER TABLE ONLY partyrelationships
ADD CONSTRAINT fk3e1d9d9a8035a2e0 FOREIGN KEY (partyrelationshiptyperef) REFERENCES partyrelationshiptypes(id);
ALTER TABLE ONLY partyrelationships
ADD CONSTRAINT fk3e1d9d9ae4e49176 FOREIGN KEY (firstpartyref) REFERENCES parties(id);
ALTER TABLE ONLY parties
ADD CONSTRAINT fk6773b61c2c3a26bd FOREIGN KEY (partytyperef) REFERENCES partytypes(id);
ALTER TABLE ONLY partystatustypes
ADD CONSTRAINT fk70e058d42c3a26bd FOREIGN KEY (partytyperef) REFERENCES partytypes(id);
ALTER TABLE ONLY partytypepairs
ADD CONSTRAINT fk7f0af5433a71f844 FOREIGN KEY (alowedtargetref) REFERENCES partytypes(id);
ALTER TABLE ONLY partytypepairs
ADD CONSTRAINT fk7f0af5439f45e6fe FOREIGN KEY (alowedsourceref) REFERENCES partytypes(id);
ALTER TABLE ONLY partytypepairs
ADD CONSTRAINT fk7f0af543d4a0d58a FOREIGN KEY (partyrelationshiptyperef) REFERENCES partytypes(id);
ALTER TABLE ONLY partycustomattributes
ADD CONSTRAINT fkbe430b92c3a26bd FOREIGN KEY (partytyperef) REFERENCES partytypes(id);
ALTER TABLE ONLY partystatuses
ADD CONSTRAINT fkd713d1639a4d3305 FOREIGN KEY (partyref) REFERENCES parties(id);
ALTER TABLE ONLY partystatuses
ADD CONSTRAINT fkd713d163c3cbd5be FOREIGN KEY (partystatustyperef) REFERENCES partystatustypes(id);