l3:serveri:registracija_reginfo_sql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
l3:serveri:registracija_reginfo_sql [2017/04/09 15:25] – milanol3:serveri:registracija_reginfo_sql [2017/04/09 17:31] (current) – milano
Line 5: Line 5:
 <code> <code>
 SELECT md5(random()::text || clock_timestamp()::text)::uuid SELECT md5(random()::text || clock_timestamp()::text)::uuid
 +</code>
  
 +DDL:
 +
 +<code>
 CREATE TABLE RegInfo ( CREATE TABLE RegInfo (
 mel_id UUID NOT NULL, mel_id UUID NOT NULL,
 PRIMARY KEY(mel_id), PRIMARY KEY(mel_id),
-version VARCHAR(20),+version VARCHAR(50),
 distrib VARCHAR(20), distrib VARCHAR(20),
 lic_to VARCHAR(255), lic_to VARCHAR(255),
Line 18: Line 22:
 lic_to_ema VARCHAR(50), lic_to_ema VARCHAR(50),
 lic_to_ip VARCHAR(30), 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, next_date TIMESTAMP,
 expiry_date TIMESTAMP, expiry_date TIMESTAMP,
-status INTEGER DEFAULT 50,+status INTEGER DEFAULT 40,
 stat_entcount INTEGER, stat_entcount INTEGER,
 stat_entities VARCHAR(255), stat_entities VARCHAR(255),
  • l3/serveri/registracija_reginfo_sql.1491751559.txt.gz
  • Last modified: 2017/04/09 15:25
  • by milano