viewvc.cgi/registar/.shema.sql.swp

b0VIM 5.8Ç%;Áéravilovdpavlinusic1~ravilov/sif/shema.sql3210#"! Utpÿgadw'gÿì×»¥{iWC.ýÏÃÀ¿§_D)õ
Ü
Ã
¥

v
_
K
7

ùìÚÈ¶ª§¦nc`_F-"íâßÞÆ¢pebaL3(%$
ß
¼
°

¬

|
Z
7

î     É     ¨                    i     D     !     þÕ²i\A+('&);   fax CHAR VARYING(15)   telefon CHAR VARYING(15),      razno TEXT,    ulica_i_broj CHAR VARYING(50) NOT NULL,        zip CHAR VARYING(10) NOT NULL, mjesto CHAR VARYING(30) NOT NULL,      zastupnistvo CHAR VARYING(50) NOT NULL,        drzava CHAR VARYING(30) NOT NULL,      naziv CHAR VARYING(100) NOT NULL,      sifra INTEGER NOT NULL PRIMARY KEY,CREATE TABLE proizvodjaci ();    zip CHAR VARYING(10) NOT NULL  grad CHAR VARYING(20) NOT NULL,        spos_broj CHAR VARYING(7) NOT NULL,    npos_broj CHAR VARYING(7) NOT NULL,    pos_broj CHAR VARYING(7) NOT NULL,     centar CHAR VARYING(20) NOT NULL,      naziv CHAR VARYING(30) NOT NULL,       broj INTEGER NOT NULL,CREATE TABLE zupanije ();     razno TEXT     naziv CHAR VARYING(100) NOT NULL,      sifra CHAR VARYING(20) PRIMARY KEY NOT NULL,CREATE TABLE atk_inn ();        opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE droga ();       opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE vozac ();       opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE dojencad ();    opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE trudnoca ();    opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE list_fond ();   opis TEXT      sifra INTEGER NOT NULL,CREATE TABLE nacin_izdavanja ();     oprez TEXT     indikacije TEXT,       djelovanje TEXT,       glav_razno TEXT,       razno TEXT,    sif_med INTEGER NOT NULL,      cijena CHAR VARYING(16) NOT NULL,      sif_droga INTEGER,     sif_vozac INTEGER,     sif_dojencad INTEGER,  sif_trudnoca INTEGER,  sif_list_fond INTEGER, sif_nacin_izdavanja INTEGER,   sastav_2 TEXT NOT NULL,        sastav_1 TEXT NOT NULL,        pakovanje TEXT NOT NULL,       sif_proizvodjac INTEGER,       sif_inn CHAR VARYING(20),      sif_atk CHAR VARYING(20),      naziv CHAR VARYING(100) NOT NULL,      sifra INTEGER NOT NULL PRIMARY KEY,CREATE TABLE lijekovi ();        naziv TEXT     sifra CHAR VARYING(20) NOT NULL PRIMARY KEY,CREATE TABLE vodeca (DROP TABLE proizvodjaci;DROP TABLE zupanije;DROP TABLE atk_inn;DROP TABLE droga;DROP TABLE vozac;DROP TABLE dojencad;DROP TABLE trudnoca;DROP TABLE list_fond;DROP TABLE nacin_izdavanja;DROP TABLE lijekovi;DROP TABLE vodeca;
1	b0VIM 5.8Ç%;Áéravilovdpavlinusic1~ravilov/sif/shema.sql3210#"! Utpÿgadw'gÿì×»¥{iWC.ýÏÃÀ¿§_D)õ
2	Ü
3	Ã
4	¥
5
6	v
7	_
8	K
9	7
10
11	ùìÚÈ¶ª§¦nc`_F-"íâßÞÆ¢pebaL3(%$
12	ß
13	¼
14	°
15
16	¬
17
18	\|
19	Z
20	7
21
22	î É ¨ i D ! þÕ²i\A+('&); fax CHAR VARYING(15) telefon CHAR VARYING(15), razno TEXT, ulica_i_broj CHAR VARYING(50) NOT NULL, zip CHAR VARYING(10) NOT NULL, mjesto CHAR VARYING(30) NOT NULL, zastupnistvo CHAR VARYING(50) NOT NULL, drzava CHAR VARYING(30) NOT NULL, naziv CHAR VARYING(100) NOT NULL, sifra INTEGER NOT NULL PRIMARY KEY,CREATE TABLE proizvodjaci (); zip CHAR VARYING(10) NOT NULL grad CHAR VARYING(20) NOT NULL, spos_broj CHAR VARYING(7) NOT NULL, npos_broj CHAR VARYING(7) NOT NULL, pos_broj CHAR VARYING(7) NOT NULL, centar CHAR VARYING(20) NOT NULL, naziv CHAR VARYING(30) NOT NULL, broj INTEGER NOT NULL,CREATE TABLE zupanije (); razno TEXT naziv CHAR VARYING(100) NOT NULL, sifra CHAR VARYING(20) PRIMARY KEY NOT NULL,CREATE TABLE atk_inn (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE droga (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE vozac (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE dojencad (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE trudnoca (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE list_fond (); opis TEXT sifra INTEGER NOT NULL,CREATE TABLE nacin_izdavanja (); oprez TEXT indikacije TEXT, djelovanje TEXT, glav_razno TEXT, razno TEXT, sif_med INTEGER NOT NULL, cijena CHAR VARYING(16) NOT NULL, sif_droga INTEGER, sif_vozac INTEGER, sif_dojencad INTEGER, sif_trudnoca INTEGER, sif_list_fond INTEGER, sif_nacin_izdavanja INTEGER, sastav_2 TEXT NOT NULL, sastav_1 TEXT NOT NULL, pakovanje TEXT NOT NULL, sif_proizvodjac INTEGER, sif_inn CHAR VARYING(20), sif_atk CHAR VARYING(20), naziv CHAR VARYING(100) NOT NULL, sifra INTEGER NOT NULL PRIMARY KEY,CREATE TABLE lijekovi (); naziv TEXT sifra CHAR VARYING(20) NOT NULL PRIMARY KEY,CREATE TABLE vodeca (DROP TABLE proizvodjaci;DROP TABLE zupanije;DROP TABLE atk_inn;DROP TABLE droga;DROP TABLE vozac;DROP TABLE dojencad;DROP TABLE trudnoca;DROP TABLE list_fond;DROP TABLE nacin_izdavanja;DROP TABLE lijekovi;DROP TABLE vodeca;