Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
l3:serveri:registracija_reginfo_sql [2017/04/09 12:02] – created milano | l3:serveri:registracija_reginfo_sql [2017/04/09 17:31] (current) – milano | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== SQL za kreiranje tabele RegInfo ====== | ====== SQL za kreiranje tabele RegInfo ====== | ||
- | CREATE TABLE RegInfo (\\ | + | Jedinstveni UUID u pg može se dobiti sledećom komandom: |
- | mel_id | + | |
- | PRIMARY KEY(mel_id), | + | < |
- | version | + | SELECT md5(random():: |
- | distrib | + | </ |
- | lic_to | + | |
- | lic_to_pib | + | DDL: |
- | lic_to_addr | + | |
- | lic_to_reg | + | < |
- | lic_to_tel | + | CREATE TABLE RegInfo ( |
- | lic_to_ema | + | mel_id |
- | lic_to_ip | + | PRIMARY KEY(mel_id), |
- | reg_date | + | version VARCHAR(50), |
- | refresh_date | + | distrib VARCHAR(20), |
- | next_date | + | lic_to VARCHAR(255), |
- | expiry_date | + | lic_to_pib VARCHAR(30), |
- | status | + | lic_to_addr VARCHAR(255), |
- | stat_entities | + | lic_to_reg VARCHAR(3), |
- | stat_modules | + | lic_to_tel VARCHAR(20), |
- | stat_maxsize | + | lic_to_ema VARCHAR(50), |
- | )\\ | + | lic_to_ip VARCHAR(30), |
+ | reg_date TIMESTAMP DEFAULT | ||
+ | refresh_date TIMESTAMP DEFAULT | ||
+ | next_date TIMESTAMP, | ||
+ | expiry_date TIMESTAMP, | ||
+ | status INTEGER DEFAULT | ||
+ | stat_entcount | ||
+ | stat_entities VARCHAR(255), | ||
+ | stat_modules VARCHAR(255), | ||
+ | stat_maxsize DOUBLE PRECISION | ||
+ | ) | ||
WITH (oids = false); | WITH (oids = false); | ||
- | COMMENT ON COLUMN reginfo.mel_id IS ' | + | COMMENT ON COLUMN reginfo.mel_id IS ' |
- | COMMENT ON COLUMN reginfo.version IS ' | + | COMMENT ON COLUMN reginfo.version IS ' |
- | COMMENT ON COLUMN reginfo.distrib IS ' | + | COMMENT ON COLUMN reginfo.distrib IS ' |
- | COMMENT ON COLUMN reginfo.lic_to IS 'Naziv firme, nosioca licence'; | + | COMMENT ON COLUMN reginfo.lic_to IS 'Naziv firme, nosioca licence'; |
- | COMMENT ON COLUMN reginfo.lic_to_pib IS ' | + | COMMENT ON COLUMN reginfo.lic_to_pib IS ' |
- | COMMENT ON COLUMN reginfo.lic_to_addr IS ' | + | COMMENT ON COLUMN reginfo.lic_to_addr IS ' |
- | COMMENT ON COLUMN reginfo.lic_to_reg IS ' | + | COMMENT ON COLUMN reginfo.lic_to_reg IS ' |
- | COMMENT ON COLUMN reginfo.lic_to_tel IS ' | + | COMMENT ON COLUMN reginfo.lic_to_tel IS ' |
- | COMMENT ON COLUMN reginfo.lic_to_ema IS 'Email na koji se šalju zahtevi za registraciju'; | + | COMMENT ON COLUMN reginfo.lic_to_ema IS 'Email na koji se šalju zahtevi za registraciju'; |
- | COMMENT ON COLUMN reginfo.lic_to_ip IS 'IP adresa sa koje je stigao zahtev'; | + | COMMENT ON COLUMN reginfo.lic_to_ip IS 'IP adresa sa koje je stigao zahtev'; |
- | COMMENT ON COLUMN reginfo.reg_date IS 'Datum i vreme registracije'; | + | COMMENT ON COLUMN reginfo.reg_date IS 'Datum i vreme registracije'; |
- | COMMENT ON COLUMN reginfo.refresh_date IS 'Datum i vreme poslednjeg obnavljanja podataka o registraciji'; | + | COMMENT ON COLUMN reginfo.refresh_date IS 'Datum i vreme poslednjeg obnavljanja podataka o registraciji'; |
- | COMMENT ON COLUMN reginfo.next_date IS 'Datum i vreme sledećeg ciklusa osvežavanja registracije'; | + | 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.expiry_date IS 'Datum i vreme isteka licence'; |
- | COMMENT ON COLUMN reginfo.status IS ' | + | COMMENT ON COLUMN reginfo.status IS ' |
- | COMMENT ON COLUMN reginfo.stat_entities | + | COMMENT ON COLUMN reginfo.stat_entcount |
- | COMMENT ON COLUMN reginfo.stat_modules IS ' | + | COMMENT ON COLUMN reginfo.stat_entities IS ' |
+ | COMMENT ON COLUMN reginfo.stat_modules IS ' | ||
COMMENT ON COLUMN reginfo.stat_maxsize IS ' | COMMENT ON COLUMN reginfo.stat_maxsize IS ' | ||
+ | </ | ||