SHARE
TWEET

Untitled

a guest Aug 23rd, 2019 77 in 3 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. INSERT INTO DOCUMENT_MODEL (COUNTRY, DOCUMENT_TYPE, MRZ_TYPE, METADATA_ID, HAS_OCR, HAS_VALIDATIONS, PAGE_COUNT, MIN_CONFIDENCE, MIN_CONFIDENCE_WARNING, UPDATED_BY, UPDATED_AT, ID)
  3.   VALUES ('CZE', 'ID_CARD', 'TD2', 'a5eb2505-1113-4ca4-b970-3427852693a6', 1, 1, 2, 0.6, 0.8, 'softec/admin', CURRENT_TIMESTAMP, seq_document_model.NEXTVAL );
  4.  
  5. ALTER TABLE DOCUMENT_MODEL
  6. ADD DOCUMENT_VERSION CHAR(2) NULL;
  7.  
  8. UPDATE DOCUMENT_MODEL
  9. SET DOCUMENT_VERSION = 'v1'
  10. WHERE 1 = 1;
  11.  
  12. ALTER TABLE DOCUMENT_MODEL
  13. ALTER COLUMN DOCUMENT_VERSION CHAR(2) NOT NULL;
  14.  
  15. UPDATE DOCUMENT_MODEL
  16. SET DOCUMENT_VERSION = 'v2'
  17. WHERE METADATA_ID = 'a5eb2505-1113-4ca4-b970-3427852693a6'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top