55 |
godina text, |
godina text, |
56 |
id int4, |
id int4, |
57 |
date_lupdate date default 'now', |
date_lupdate date default 'now', |
58 |
primary key(sif_radnika) |
primary key(sif_radnika,id) |
59 |
); |
); |
60 |
|
|
61 |
create table o_meni ( |
create table o_meni ( |
80 |
sifra text not null, |
sifra text not null, |
81 |
opis text, |
opis text, |
82 |
language varchar(2) not null default 'HR', /* RA: */ |
language varchar(2) not null default 'HR', /* RA: */ |
83 |
primary key(sifra) |
primary key (sifra, language) |
84 |
); |
); |
85 |
|
|
86 |
/* MULTILINGUAL */ |
/* MULTILINGUAL */ |
199 |
language varchar(2) not null default 'HR', /* RA: */ |
language varchar(2) not null default 'HR', /* RA: */ |
200 |
primary key (sifra) |
primary key (sifra) |
201 |
); |
); |
202 |
|
|
203 |
|
create table patenti ( |
204 |
|
sifra int4 not null, |
205 |
|
sif_radnika varchar(7) not null, |
206 |
|
autori varchar(100) not null, |
207 |
|
naziv varchar(60) not null, |
208 |
|
godina varchar(4), |
209 |
|
zastita varchar(50), |
210 |
|
na_snazi boolean, |
211 |
|
drzave varchar(100), |
212 |
|
komentar text |
213 |
|
); |