Update E-Tabellen ExchangeGate

Aus PPwiki
Version vom 17. Juli 2020, 10: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…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche
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;