Differences

This shows you the differences between two versions of the page.

--- l3:serveri:registracija_reginfo_sql [2017/04/09 15:22] – milano
+++ l3:serveri:registracija_reginfo_sql [2017/04/09 17:31] (current) – milano
@@ Line 6: / Line 6: @@
 SELECT md5(random()::text || clock_timestamp()::text)::uuid
 </code>
+DDL:
 <code>
 CREATE TABLE RegInfo (
 mel_id UUID NOT NULL,
 PRIMARY KEY(mel_id),
-version VARCHAR(20),
+version VARCHAR(50),
 distrib VARCHAR(20),
 lic_to VARCHAR(255),
@@ Line 19: / Line 22: @@
 lic_to_ema VARCHAR(50),
 lic_to_ip VARCHAR(30),
-reg_date TIMESTAMP DEFAULT CURRENT_DATE,
+reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-refresh_date TIMESTAMP DEFAULT CURRENT_DATE,
+refresh_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 next_date TIMESTAMP,
 expiry_date TIMESTAMP,
-status INTEGER DEFAULT 50,
+status INTEGER DEFAULT 40,
 stat_entcount INTEGER,
 stat_entities VARCHAR(255),
@@ Line 46: / Line 49: @@
 COMMENT ON COLUMN reginfo.expiry_date IS 'Datum i vreme isteka licence';
 COMMENT ON COLUMN reginfo.status IS 'Status licence: 10 - revoked, 20 - read only, 30 - granted warning, 40 - granted processing, 50 - granted';
-COMMENT ON COLUMN reginfo.stat_entities IS 'Statistika - broj registrovanih firmi u Balans bazi kod klijenta';
+COMMENT ON COLUMN reginfo.stat_entcount IS 'Statistika - broj registrovanih firmi u Balans bazi kod klijenta';
+COMMENT ON COLUMN reginfo.stat_entities IS 'Spisak početnih slova firmi registrovanih u Balans bazi odvojen zarezom';
 COMMENT ON COLUMN reginfo.stat_modules IS 'Aktivni dodatni moduli u bazama korisnika';
 COMMENT ON COLUMN reginfo.stat_maxsize IS 'Maksimalna veličina među aktivnim bazama izražena u MB';