Update E-Tabellen ExchangeGate
Aus PPwiki
Version vom 17. Juli 2020, 09:29 Uhr von Schild (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „<pre> UPDATE E_CUSTOMER SET TIMEST = PAT_TIME.FGETTIMEST WHERE TIMEST IS NULL; ALTER TABLE E_CUSTOMER DROP PRIMARY KEY DROP INDEX; DROP INDEX E_CUSTOMER_PK; AL…“)
UPDATE E_CUSTOMER SET TIMEST = PAT_TIME.FGETTIMEST WHERE TIMEST IS NULL; ALTER TABLE E_CUSTOMER DROP PRIMARY KEY DROP INDEX; DROP INDEX E_CUSTOMER_PK; ALTER TABLE E_CUSTOMER ADD CONSTRAINT E_CUSTOMER_PK PRIMARY KEY (TIMEST); UPDATE E_EXCHANGE SET EXCHANGE_ID = PAT_TIME.FGETTIMEST WHERE EXCHANGE_ID IS NULL; ALTER TABLE E_EXCHANGE DROP PRIMARY KEY DROP INDEX; DROP INDEX E_EXCHANGE_PK; ALTER TABLE E_EXCHANGE ADD CONSTRAINT E_EXCHANGE_PK PRIMARY KEY (EXCHANGE_ID); COMMIT;