Differences

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

--- l3:serveri:registracija_reginfo_sql [2017/04/09 12:12] – milano
+++ l3:serveri:registracija_reginfo_sql [2017/04/09 17:31] (current) – milano
@@ Line 1: / Line 1: @@
 ====== SQL za kreiranje tabele RegInfo ======
+Jedinstveni UUID u pg može se dobiti sledećom komandom:
+<code>
+SELECT md5(random()::text || clock_timestamp()::text)::uuid
+</code>
+DDL:
 <code>
@@ Line 5: / Line 13: @@
 mel_id UUID NOT NULL,
 PRIMARY KEY(mel_id),
-version VARCHAR(20),
+version VARCHAR(50),
 distrib VARCHAR(20),
 lic_to VARCHAR(255),
@@ Line 14: / 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 30,
+status INTEGER DEFAULT 40,
-stat_entities INTEGER,
+stat_entcount INTEGER,
+stat_entities VARCHAR(255),
 stat_modules VARCHAR(255),
 stat_maxsize DOUBLE PRECISION
@@ Line 39: / Line 48: @@
 COMMENT ON COLUMN reginfo.next_date IS 'Datum i vreme sledećeg ciklusa osvežavanja registracije';
 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';
+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';