OSDN -- 开发和下载开源软件
简体中文翻译状态 translation status for zh
  • R/O
  • SSH
  • HTTPS

opengion: 提交


Commit MetaInfo

修订版2284 (tree)
时间2022-11-17 15:30:49
作者leem

Log Message

(empty log message)

更改概述

差异

--- trunk/opengionV8/uap/webapps/ge/changes/8400/8400.txt (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/changes/8400/8400.txt (revision 2284)
@@ -1,4 +1,10 @@
11 8.4.0.0 (2022/11/11)
2+ [INDEX削除]
3+ GE52_UQ と GE52_SA の差異は項目並びが違うだけなので以下の問題があり、GE52_SAを削除
4+ ・GE52_UQ 削除 → GE52_UQ 作成 → GE52_SA 削除する際にｴﾗｰ発生(ORA-02429: 一意キーまたは主キーの保持に使用される索引は削除できません。)
5+ ・ｲﾝﾎﾟｰﾄする際にｴﾗｰ発生(ORA-20000 Unable to Set Values for Index GE52_UQ: Does Not Exist or Insufficient Priv is Raised While Executing Impdp)
6+ 帳票ﾚｲｱｳﾄﾃｰﾌﾞﾙ(GE52) DROP INDEX GE52_SA;
7+
28 [共通項目の桁数増加(問合・ﾄﾗﾌﾞﾙ 0200009584)]
39 (1) 作成PG、作成親PG、更新PG、更新親PG X(10) → X(50)
410 ? 調査SQL文
--- trunk/opengionV8/uap/webapps/ge/changes/changes.txt (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/changes/changes.txt (revision 2284)
@@ -1,4 +1,11 @@
11 8.4.0.0 (2022/11/11)
2+ [INDEX削除]
3+ GE52_UQ と GE52_SA の差異は項目並びが違うだけなので以下の問題があり、GE52_SAを削除
4+ ・GE52_UQ 削除 → GE52_UQ 作成 → GE52_SA 削除する際にｴﾗｰ発生(ORA-02429: 一意キーまたは主キーの保持に使用される索引は削除できません。)
5+ ・ｲﾝﾎﾟｰﾄする際にｴﾗｰ発生(ORA-20000 Unable to Set Values for Index GE52_UQ: Does Not Exist or Insufficient Priv is Raised While Executing Impdp)
6+ 帳票ﾚｲｱｳﾄﾃｰﾌﾞﾙ(GE52)
7+ GE52_SA CLM,SYSTEM_ID,LISTID,KBTEXT
8+
29 [共通項目の桁数増加(問合・ﾄﾗﾌﾞﾙ 0200009584)]
310 作成PG(PGSET)、作成親PG(PGPSET)、更新PG(PGUPD)、更新親PG(PGPUPD) X(10) → X(50)
411 全ﾃｰﾌﾞﾙが対象
--- trunk/opengionV8/uap/webapps/ge/db/DERBY/sql/install/02_INDEX/AllDropC.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/DERBY/sql/install/02_INDEX/AllDropC.sql (revision 2284)
@@ -50,8 +50,6 @@
5050
5151 DROP INDEX GE51_SB;
5252
53-DROP INDEX GE52_SA;
54-
5553 DROP INDEX GE53_SA;
5654
5755 DROP INDEX GE56_SA;
--- trunk/opengionV8/uap/webapps/ge/db/DERBY/sql/install/02_INDEX/GE52C.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/DERBY/sql/install/02_INDEX/GE52C.sql (revision 2284)
@@ -5,8 +5,3 @@
55
66
77 ALTER TABLE GE52 ADD CONSTRAINT GE52_UQ PRIMARY KEY ( SYSTEM_ID,LISTID,KBTEXT,CLM );
8-
9-
10-DROP INDEX GE52_SA;
11-
12-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT );
--- trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/install/02_INDEX/AllDropC.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/install/02_INDEX/AllDropC.xml (revision 2284)
@@ -77,9 +77,6 @@
7777 DROP INDEX GE51_SB
7878 </EXEC_SQL>
7979 <EXEC_SQL>
80-DROP INDEX GE52_SA
81-</EXEC_SQL>
82-<EXEC_SQL>
8380 DROP INDEX GE53_SA
8481 </EXEC_SQL>
8582 <EXEC_SQL>
--- trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/install/02_INDEX/GE52C.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/install/02_INDEX/GE52C.xml (revision 2284)
@@ -8,11 +8,4 @@
88 <EXEC_SQL>
99 ALTER TABLE GE52 ADD CONSTRAINT GE52_UQ PRIMARY KEY ( SYSTEM_ID,LISTID,KBTEXT,CLM )
1010 </EXEC_SQL>
11-
12-<EXEC_SQL>
13-DROP INDEX GE52_SA
14-</EXEC_SQL>
15-<EXEC_SQL>
16-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT )
17-</EXEC_SQL>
1811 </ROWSET>
--- trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/verup/8400.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/DERBY/xml/verup/8400.xml (revision 2284)
@@ -1,5 +1,7 @@
11 <?xml version='1.0' encoding='UTF-8'?>
22 <ROWSET>
3+<EXEC_SQL>DROP INDEX GE52_SA</EXEC_SQL>
4+
35 <EXEC_SQL>ALTER TABLE GE12 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
46 <EXEC_SQL>ALTER TABLE GE12 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
57 <EXEC_SQL>ALTER TABLE GE12 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
@@ -12,46 +14,121 @@
1214 <EXEC_SQL>ALTER TABLE GE17 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1315 <EXEC_SQL>ALTER TABLE GE17 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1416 <EXEC_SQL>ALTER TABLE GE17 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
17+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
18+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
19+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
20+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1521 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1622 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1723 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
1824 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
19-<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
20-<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
21-<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
22-<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
23-<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
24-<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
25-<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
26-<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
27-<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
28-<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
29-<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
25+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
26+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
27+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
28+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
29+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
30+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
31+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
32+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
33+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
34+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
35+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
36+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
37+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
38+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
39+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
40+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
41+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
42+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
43+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
44+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
45+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
46+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
47+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
48+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
49+<EXEC_SQL>ALTER TABLE GE37 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
50+<EXEC_SQL>ALTER TABLE GE37 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
51+<EXEC_SQL>ALTER TABLE GE37 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
52+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
53+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
54+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
55+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
56+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
57+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
58+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
59+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
60+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
61+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
62+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
63+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
64+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
65+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
66+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
67+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
68+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
69+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
70+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
71+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
72+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
73+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
74+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
75+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
76+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
77+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
78+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
79+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
80+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
81+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
82+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
83+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
84+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
85+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
86+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
87+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
88+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
89+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
90+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
91+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
92+<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
93+<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
94+<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
95+<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
96+<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
97+<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
98+<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
99+<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
100+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
101+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
102+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
103+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
30104 <EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
105+<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
106+<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
107+<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
31108 <EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
32-<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
33-<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
34-<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
35-<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
109+<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
110+<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
111+<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
36112 <EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
37-<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
38-<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
113+<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
114+<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
115+<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
39116 <EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
40-<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
41-<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
42-<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
43-<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
117+<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
118+<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
119+<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
44120 <EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
45-<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
46-<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
121+<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
122+<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
123+<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
47124 <EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
48-<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
49-<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
50-<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
51-<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
52-<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGPSET SET DATA TYPE VARCHAR(50)</EXEC_SQL>
53-<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
125+<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
126+<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
127+<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
54128 <EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
129+<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
130+<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
131+<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN PGPUPD SET DATA TYPE VARCHAR(50)</EXEC_SQL>
55132
56133 <EXEC_SQL>ALTER TABLE GE12 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
57134 <EXEC_SQL>ALTER TABLE GE12 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
@@ -59,30 +136,67 @@
59136 <EXEC_SQL>ALTER TABLE GE15 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
60137 <EXEC_SQL>ALTER TABLE GE17 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
61138 <EXEC_SQL>ALTER TABLE GE17 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
139+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
140+<EXEC_SQL>ALTER TABLE GE18 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
62141 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
63142 <EXEC_SQL>ALTER TABLE GE20 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
143+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
144+<EXEC_SQL>ALTER TABLE GE30 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
145+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
146+<EXEC_SQL>ALTER TABLE GE31 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
147+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
148+<EXEC_SQL>ALTER TABLE GE32 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
149+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
150+<EXEC_SQL>ALTER TABLE GE33 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
151+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
152+<EXEC_SQL>ALTER TABLE GE34 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
153+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
154+<EXEC_SQL>ALTER TABLE GE36 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
155+<EXEC_SQL>ALTER TABLE GE37 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
156+<EXEC_SQL>ALTER TABLE GE37 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
157+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
158+<EXEC_SQL>ALTER TABLE GE50 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
159+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
160+<EXEC_SQL>ALTER TABLE GE51 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
161+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
162+<EXEC_SQL>ALTER TABLE GE52 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
163+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
164+<EXEC_SQL>ALTER TABLE GE53 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
165+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
166+<EXEC_SQL>ALTER TABLE GE54 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
167+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
168+<EXEC_SQL>ALTER TABLE GE55 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
169+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
170+<EXEC_SQL>ALTER TABLE GE56 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
171+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
172+<EXEC_SQL>ALTER TABLE GE70 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
173+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
174+<EXEC_SQL>ALTER TABLE GE71 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
175+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
176+<EXEC_SQL>ALTER TABLE GE72 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
64177 <EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
65-<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
178+<EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
66179 <EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
67-<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
180+<EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
181+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
182+<EXEC_SQL>ALTER TABLE GE82 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
68183 <EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
69-<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
184+<EXEC_SQL>ALTER TABLE GEA03 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
70185 <EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
71-<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
186+<EXEC_SQL>ALTER TABLE GEA04 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
72187 <EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
73-<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
188+<EXEC_SQL>ALTER TABLE GEA05 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
74189 <EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
75-<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
190+<EXEC_SQL>ALTER TABLE GEA08 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
76191 <EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
77-<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
192+<EXEC_SQL>ALTER TABLE GEA09 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
78193 <EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
79-<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
80-<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN USRUPD SET DATA TYPE VARCHAR(30)</EXEC_SQL>
194+<EXEC_SQL>ALTER TABLE GEA10 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
81195 <EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
196+<EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN USRSET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
82197
83198 <EXEC_SQL>ALTER TABLE GE80 ALTER COLUMN FILEPATH SET DATA TYPE VARCHAR(256)</EXEC_SQL>
84199 <EXEC_SQL>ALTER TABLE GE81 ALTER COLUMN FILEPATH SET DATA TYPE VARCHAR(256)</EXEC_SQL>
85200
86201 <EXEC_SQL>ALTER TABLE GEA11 ALTER COLUMN TARGET SET DATA TYPE VARCHAR(30)</EXEC_SQL>
87-
88202 </ROWSET>
--- trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/sql/install/02_INDEX/AllDropC.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/sql/install/02_INDEX/AllDropC.sql (revision 2284)
@@ -80,8 +80,6 @@
8080
8181 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ;
8282
83-DROP INDEX GE52_SA;
84-
8583 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ;
8684
8785 DROP INDEX GE53_SA;
--- trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/sql/install/02_INDEX/GE52C.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/sql/install/02_INDEX/GE52C.sql (revision 2284)
@@ -7,8 +7,3 @@
77 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ;
88
99 CREATE UNIQUE INDEX GE52_UQ ON GE52( SYSTEM_ID,LISTID,KBTEXT,CLM );
10-
11-
12-DROP INDEX GE52_SA;
13-
14-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT );
--- trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/xml/install/02_INDEX/AllDropC.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/xml/install/02_INDEX/AllDropC.xml (revision 2284)
@@ -122,9 +122,6 @@
122122 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ
123123 </EXEC_SQL>
124124 <EXEC_SQL>
125-DROP INDEX GE52_SA
126-</EXEC_SQL>
127-<EXEC_SQL>
128125 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ
129126 </EXEC_SQL>
130127 <EXEC_SQL>
--- trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/xml/install/02_INDEX/GE52C.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/FIREBIRD/xml/install/02_INDEX/GE52C.xml (revision 2284)
@@ -11,11 +11,4 @@
1111 <EXEC_SQL>
1212 CREATE UNIQUE INDEX GE52_UQ ON GE52( SYSTEM_ID,LISTID,KBTEXT,CLM )
1313 </EXEC_SQL>
14-
15-<EXEC_SQL>
16-DROP INDEX GE52_SA
17-</EXEC_SQL>
18-<EXEC_SQL>
19-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT )
20-</EXEC_SQL>
2114 </ROWSET>
--- trunk/opengionV8/uap/webapps/ge/db/ORACLE/sql/install/02_INDEX/AllDropC.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/ORACLE/sql/install/02_INDEX/AllDropC.sql (revision 2284)
@@ -80,8 +80,6 @@
8080
8181 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ;
8282
83-DROP INDEX GE52_SA;
84-
8583 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ;
8684
8785 DROP INDEX GE53_SA;
--- trunk/opengionV8/uap/webapps/ge/db/ORACLE/sql/install/02_INDEX/GE52C.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/ORACLE/sql/install/02_INDEX/GE52C.sql (revision 2284)
@@ -10,11 +10,3 @@
1010 USING INDEX TABLESPACE GEIDX01
1111 STORAGE( INITIAL 16K )
1212 ;
13-
14-
15-DROP INDEX GE52_SA;
16-
17-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT )
18-TABLESPACE GEIDX01
19-STORAGE( INITIAL 16K )
20-;
--- trunk/opengionV8/uap/webapps/ge/db/ORACLE/xml/install/02_INDEX/AllDropC.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/ORACLE/xml/install/02_INDEX/AllDropC.xml (revision 2284)
@@ -122,9 +122,6 @@
122122 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ
123123 </EXEC_SQL>
124124 <EXEC_SQL>
125-DROP INDEX GE52_SA
126-</EXEC_SQL>
127-<EXEC_SQL>
128125 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ
129126 </EXEC_SQL>
130127 <EXEC_SQL>
--- trunk/opengionV8/uap/webapps/ge/db/ORACLE/xml/install/02_INDEX/GE52C.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/ORACLE/xml/install/02_INDEX/GE52C.xml (revision 2284)
@@ -14,14 +14,4 @@
1414 STORAGE( INITIAL 16K )
1515
1616 </EXEC_SQL>
17-
18-<EXEC_SQL>
19-DROP INDEX GE52_SA
20-</EXEC_SQL>
21-<EXEC_SQL>
22-CREATE INDEX GE52_SA ON GE52( CLM,SYSTEM_ID,LISTID,KBTEXT )
23-TABLESPACE GEIDX01
24-STORAGE( INITIAL 16K )
25-
26-</EXEC_SQL>
2717 </ROWSET>
--- trunk/opengionV8/uap/webapps/ge/db/POSTGRES/sql/install/02_INDEX/AllDropC.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/POSTGRES/sql/install/02_INDEX/AllDropC.sql (revision 2284)
@@ -80,8 +80,6 @@
8080
8181 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ;
8282
83-DROP INDEX GE52_SA;
84-
8583 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ;
8684
8785 DROP INDEX GE53_SA;
--- trunk/opengionV8/uap/webapps/ge/db/POSTGRES/sql/install/02_INDEX/GE52C.sql (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/POSTGRES/sql/install/02_INDEX/GE52C.sql (revision 2284)
@@ -8,8 +8,3 @@
88 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ;
99
1010 alter table ge52 add constraint ge52_uq primary key ( system_id,listid,kbtext,clm );
11-
12-
13-DROP INDEX GE52_SA;
14-
15-create index ge52_sa on ge52( clm,system_id,listid,kbtext );
--- trunk/opengionV8/uap/webapps/ge/db/POSTGRES/xml/install/02_INDEX/AllDropC.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/POSTGRES/xml/install/02_INDEX/AllDropC.xml (revision 2284)
@@ -122,9 +122,6 @@
122122 ALTER TABLE GE52 DROP CONSTRAINT GE52_UQ
123123 </EXEC_SQL>
124124 <EXEC_SQL>
125-DROP INDEX GE52_SA
126-</EXEC_SQL>
127-<EXEC_SQL>
128125 ALTER TABLE GE53 DROP CONSTRAINT GE53_UQ
129126 </EXEC_SQL>
130127 <EXEC_SQL>
--- trunk/opengionV8/uap/webapps/ge/db/POSTGRES/xml/install/02_INDEX/GE52C.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/ge/db/POSTGRES/xml/install/02_INDEX/GE52C.xml (revision 2284)
@@ -11,11 +11,4 @@
1111 <exec_sql>
1212 alter table ge52 add constraint ge52_uq primary key ( system_id,listid,kbtext,clm )
1313 </EXEC_SQL>
14-
15-<EXEC_SQL>
16-DROP INDEX GE52_SA
17-</EXEC_SQL>
18-<exec_sql>
19-create index ge52_sa on ge52( clm,system_id,listid,kbtext )
20-</EXEC_SQL>
2114 </ROWSET>
--- trunk/opengionV8/uap/webapps/gf/doc/RELEASE-NOTES_8.txt (revision 2283)
+++ trunk/opengionV8/uap/webapps/gf/doc/RELEASE-NOTES_8.txt (revision 2284)
@@ -2,6 +2,13 @@
22 [DUMMYLINE改善(複数のﾌｫｰﾏｯﾄについて複数行に跨って縦線がﾏﾁﾏﾁあるﾊﾟﾀｰﾝ)(問合・ﾄﾗﾌﾞﾙ 43100-221109-01)]
33 hayabusa.report2.OdsSheet#getRow(int,int)
44
5+ [INDEX削除]
6+ GE52_UQ と GE52_SA の差異は項目並びが違うだけなので以下の問題があり、GE52_SAを削除
7+ ・GE52_UQ 削除 → GE52_UQ 作成 → GE52_SA 削除する際にｴﾗｰ発生(ORA-02429: 一意キーまたは主キーの保持に使用される索引は削除できません。)
8+ ・ｲﾝﾎﾟｰﾄする際にｴﾗｰ発生(ORA-20000 Unable to Set Values for Index GE52_UQ: Does Not Exist or Insufficient Priv is Raised While Executing Impdp)
9+ 帳票ﾚｲｱｳﾄﾃｰﾌﾞﾙ(GE52)
10+ GE52_SA CLM,SYSTEM_ID,LISTID,KBTEXT
11+
512 [共通項目の桁数増加(問合・ﾄﾗﾌﾞﾙ 0200009584)]
613 作成PG(PGSET)、作成親PG(PGPSET)、更新PG(PGUPD)、更新親PG(PGPUPD) X(10) → X(50)
714 全ﾃｰﾌﾞﾙが対象
--- trunk/opengionV8/uap/webapps/gf/src/org/opengion/fukurou/system/BuildNumber.java (revision 2283)
+++ trunk/opengionV8/uap/webapps/gf/src/org/opengion/fukurou/system/BuildNumber.java (revision 2284)
@@ -65,8 +65,8 @@
6565 * @og.paramLevel 9:自動設定
6666 */
6767 // public static final String BUILD_TYPE = "Release8 Builds (2022321)" ; // 20XX+通算日数
68-// public static final String BUILD_TYPE = "Release8 Builds (T1668659416)" ; // 通算秒数
69- public static final String BUILD_TYPE = "Release8 Builds (27810990)" ; // 通算分数
68+// public static final String BUILD_TYPE = "Release8 Builds (T1668665722)" ; // 通算秒数
69+ public static final String BUILD_TYPE = "Release8 Builds (27811095)" ; // 通算分数
7070
7171 /**
7272 * エンジンバージョンNo。
@@ -81,7 +81,7 @@
8181 * このエンジンのビルド時刻を設定します。
8282 * @og.paramLevel 9:自動設定
8383 */
84- public static final String TIMESTAMP = "2022/11/17 13:30:16" ;
84+ public static final String TIMESTAMP = "2022/11/17 15:15:22" ;
8585
8686 /**
8787 * 稼動しているサーバーのＯＳ情報。
@@ -126,7 +126,7 @@
126126 *
127127 * @og.paramLevel 9:自動設定
128128 */
129- public static final String BUILD_ID = "20221117133016" ;
129+ public static final String BUILD_ID = "20221117151522" ;
130130
131131 /**
132132 * デフォルトコンストラクターをprivateにして、
--- trunk/opengionV8/uap/webapps/gf/src/org/opengion/hayabusa/common/GE12.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/gf/src/org/opengion/hayabusa/common/GE12.xml (revision 2284)
@@ -3241,7 +3241,7 @@
32413241 <PARAM_ID>BUILD_TYPE</PARAM_ID>
32423242 <SEQNO>1010</SEQNO>
32433243 <TITLE>エンジンビルドタイプ。</TITLE>
3244- <PARAM>Release8 Builds (27810990)</PARAM>
3244+ <PARAM>Release8 Builds (27811095)</PARAM>
32453245 <CONTENTS>このエンジンのビルドタイプを設定します。
32463246
32473247 ※ たまたまBTIMEは、2018/11/16=25705545 で、既存のyDDD=2018320 より文字列比較で大きくなるため採用
@@ -3256,7 +3256,7 @@
32563256 <PARAM_ID>ENGINE_INFO</PARAM_ID>
32573257 <SEQNO>1020</SEQNO>
32583258 <TITLE>エンジンバージョンNo。</TITLE>
3259- <PARAM>openGion 8.4.0.0 Release8 Builds (27810990)</PARAM>
3259+ <PARAM>openGion 8.4.0.0 Release8 Builds (27811095)</PARAM>
32603260 <CONTENTS>このエンジンのバージョン番号 + ビルドタイプ を設定します。
32613261 [例： 4.0.0.0 Release4 Builds (04273)]</CONTENTS>
32623262 <PARAM_LVL>9</PARAM_LVL>
@@ -3269,7 +3269,7 @@
32693269 <PARAM_ID>TIMESTAMP</PARAM_ID>
32703270 <SEQNO>1030</SEQNO>
32713271 <TITLE>エンジンビルド時刻。</TITLE>
3272- <PARAM>2022/11/17 13:30:16</PARAM>
3272+ <PARAM>2022/11/17 15:15:22</PARAM>
32733273 <CONTENTS>このエンジンのビルド時刻を設定します。</CONTENTS>
32743274 <PARAM_LVL>9</PARAM_LVL>
32753275 <FGCRYPT>0</FGCRYPT>
@@ -3320,7 +3320,7 @@
33203320 <PARAM_ID>BUILD_ID</PARAM_ID>
33213321 <SEQNO>1070</SEQNO>
33223322 <TITLE>エンジンビルドID</TITLE>
3323- <PARAM>20221117133016</PARAM>
3323+ <PARAM>20221117151522</PARAM>
33243324 <CONTENTS>このエンジンのビルドIDを設定します。
33253325 キャッシュコントロールを行う際のキー情報として使用します。</CONTENTS>
33263326 <PARAM_LVL>9</PARAM_LVL>
--- trunk/opengionV8/uap/webapps/gf/src/org/opengion/hayabusa/common/GE12_Param_V8.xml (revision 2283)
+++ trunk/opengionV8/uap/webapps/gf/src/org/opengion/hayabusa/common/GE12_Param_V8.xml (revision 2284)
@@ -2649,7 +2649,7 @@
26492649 <fieldDoc>
26502650 <paramId>BUILD_TYPE</paramId>
26512651 <seq>1010</seq>
2652- <param>Release8 Builds (27810990)</param>
2652+ <param>Release8 Builds (27811095)</param>
26532653 <title>エンジンビルドタイプ。</title>
26542654 <contents>このエンジンのビルドタイプを設定します。
26552655
@@ -2661,7 +2661,7 @@
26612661 <fieldDoc>
26622662 <paramId>ENGINE_INFO</paramId>
26632663 <seq>1020</seq>
2664- <param>openGion 8.4.0.0 Release8 Builds (27810990)</param>
2664+ <param>openGion 8.4.0.0 Release8 Builds (27811095)</param>
26652665 <title>エンジンバージョンNo。</title>
26662666 <contents>このエンジンのバージョン番号 + ビルドタイプ を設定します。
26672667 [例： 4.0.0.0 Release4 Builds (04273)]</contents>
@@ -2671,7 +2671,7 @@
26712671 <fieldDoc>
26722672 <paramId>TIMESTAMP</paramId>
26732673 <seq>1030</seq>
2674- <param>2022/11/17 13:30:16</param>
2674+ <param>2022/11/17 15:15:22</param>
26752675 <title>エンジンビルド時刻。</title>
26762676 <contents>このエンジンのビルド時刻を設定します。</contents>
26772677 <paramLevel>9</paramLevel>
@@ -2710,7 +2710,7 @@
27102710 <fieldDoc>
27112711 <paramId>BUILD_ID</paramId>
27122712 <seq>1070</seq>
2713- <param>20221117133016</param>
2713+ <param>20221117151522</param>
27142714 <title>エンジンビルドID</title>
27152715 <contents>このエンジンのビルドIDを設定します。
27162716 キャッシュコントロールを行う際のキー情報として使用します。</contents>
Show on old repository browser