Dump
application/octet-stream
CREATE TABLE "menus" ( "cod_ute" int2 NOT NULL, "menuname" character(18), "title" character(60)); CREATE TABLE "menuitems" ( "cod_ute" int2 NOT NULL, "imenuname" character(18), "itemnum" int4, "mtext" character(60), "mtype" character, "progname" character(60), "img_open" character(60), "img_close" character(60)); CREATE TABLE "allarmi" ( "cod_allarme" int2 NOT NULL, "des_allarme" character(40) NOT NULL, "tipo_allarme" int4 NOT NULL, "delta_time" character(6), "rif_date" character(50) NOT NULL, "end_date" character(50), "azione" character(60) NOT NULL); CREATE TABLE "chiamate" ( "n_chiam" int4 NOT NULL, "cod_com" int2 NOT NULL, "contatto" character(40) NOT NULL, "probl" character(80) NOT NULL, "data_aper" datetime NOT NULL, "dta_primo_cont" datetime, "data_ult" datetime NOT NULL, "codaperchiam" int2, "codchiuschiam" int2, "severita" int2 NOT NULL, "telefono" character(20), "e_mail" character(30)); CREATE TABLE "chiamatedet" ( "n_chiam" int4 NOT NULL, "coda" int2 NOT NULL, "cod_ese" int2 NOT NULL, "stato_chiamata" int2 NOT NULL, "elapsed" character(6), "data_ult" datetime NOT NULL); CREATE TABLE "clienti" ( "cod_societa" int2 NOT NULL, "rag_soc" character(35) NOT NULL, "rag_abb" character(10), "rag_soc_up" character(35), "colleg_cn" character(12), "indirizzo" character(40), "cap" character(5), "citta" character(20), "provincia" character(2), "cli_telef" character(11), "cli_telef2" character(11), "cli_telex" character(11), "cli_fax" character(11), "cli_respon" character(30), "email" character(40), "fatt_dir" character, "attivo" character NOT NULL); CREATE TABLE "code" ( "cod_coda" int2 NOT NULL, "des_coda" character(40) NOT NULL); CREATE TABLE "commesse" ( "cod_com" int2 NOT NULL, "cod_soc_com" int2 NOT NULL, "cod_soc_cli" int2 NOT NULL, "datacom" date, "datain" date, "dataout" date, "datasca" date, "tipo" character, "prevore" int4, "descrizione" character(150) NOT NULL, "priorita" int2, "stato" character NOT NULL); CREATE TABLE "esecutori" ( "cod_ese" int2 NOT NULL, "cognome" character(20) NOT NULL, "nome" character(20) NOT NULL, "titolo" int2, "cod_fis" character(20), "piva" character(20), "luona" character(15), "provna" character(2), "dana" date, "sesso" character, "telefono" character(15), "daincol" date, "daendcol" date, "indirizzo" character(35), "cap" character(5), "citta" character(20), "provincia" character(2), "costora" money, "prezzora" money, "costo_sg" money, "cab" character(6), "abi" character(5), "num_conto" character(11), "posta_a" character(30), "gest_chia" character, "attivo" character NOT NULL, "logname" character(20) NOT NULL, "coda" int2); CREATE TABLE "numerachiamate" ( "cod_azi" int2 NOT NULL, "num_chiamata" int4 NOT NULL); CREATE TABLE "stato_chiamata" ( "cod_stato" int2 NOT NULL, "des_stato" character(60) NOT NULL, "cod_stato_succ" int2, "flag_stato" character NOT NULL); CREATE TABLE "tabaperchiam" ( "codaperchiam" int2 NOT NULL, "desaperchiam" character(40) NOT NULL); CREATE TABLE "tabchiuschiam" ( "codchiuschiam" int2 NOT NULL, "deschiuschiam" character(40) NOT NULL); CREATE TABLE "tabcontratti" ( "tipo_contratto" int2 NOT NULL, "des_contratto" character(40) NOT NULL, "tempo_intervento" int2 NOT NULL); CREATE TABLE "tabseverita" ( "codseverita" int2 NOT NULL, "desseverita" character(40) NOT NULL, "colore" character(20)); CREATE TABLE "tabtitoli" ( "cod_titolo" int4 NOT NULL, "desc_tit" character(20) NOT NULL); COPY "menus" FROM stdin; 1 JCusCare Help Desk 1 Entita Entita 1 Tabelle Tabelle 1 HelpDesk HelpDesk 1 Report Gestione statistiche \. COPY "menuitems" FROM stdin; 1 JCusCare 1 Tabelle M Tabelle default.gif default.gif 1 JCusCare 2 Entita M Entita default.gif default.gif 1 JCusCare 3 HelpDesk M HelpDesk default.gif default.gif 1 Tabelle 1 Stato chiamata P ListaStatoCall default.gif default.gif 1 Entita 3 Code P ListaCode default.gif default.gif 1 Entita 4 Collaboratori P ListaEsecutori default.gif default.gif 1 Tabelle 2 Motivo apertura P ListaApertura default.gif default.gif 1 Tabelle 3 Motivo chiusura P ListaChiusura default.gif default.gif 1 Entita 1 Clienti P ListaClienti default.gif default.gif 1 Entita 2 Contratti P ListaCommesse default.gif default.gif 1 HelpDesk 2 Help Desk P ListaChiamate default.gif default.gif 1 Tabelle 4 Severita P ListaSeverita default.gif default.gif 1 Tabelle 5 Tipologie contratti P ListaTipoContratti default.gif default.gif 1 Entita 5 Allarmi P ListaAllarmi default.gif default.gif 1 HelpDesk 1 Situazione Code P StatoCode default.gif default.gif 1 JCusCare 4 Report M Report default.gif default.gif 1 Report 1 Tempi attesa P default.gif default.gif 1 Report 2 Distribuzione delle chiamate P default.gif default.gif \. COPY "allarmi" FROM stdin; 1 Allarme giallo 0 00:02 Data apertura Data primo contatto color yellow \. COPY "chiamate" FROM stdin; 1 1 Tizio macchina guasta 1999-03-03 18:05:00-01 \N 1999-03-03 18:06:05.69-01 1 \N 1 113 \N \. COPY "chiamatedet" FROM stdin; 1 40 106 10 00:00 1999-03-03 18:06:05.69-01 \. COPY "clienti" FROM stdin; 1 Cliente 1 Cliente 1 \N \N \N \N \N \N \N \N \N \N \N \N S S \. COPY "code" FROM stdin; 5 Generic 10 Network 20 Sysadmin 30 DB admin 40 Applications \. COPY "commesse" FROM stdin; 1 0 1 \N \N \N \N C \N Contratto uno \N O \. COPY "esecutori" FROM stdin; 106 Frullani Pierluigi 3 \N \N \N \N \N M \N \N \N \N \N \N \N \N \N \N \N \N \N pigi@frumar.it S S pigi 40 \. COPY "numerachiamate" FROM stdin; 1 1 \. COPY "stato_chiamata" FROM stdin; 10 Catalogata- Dispatched \N O 20 Assegnata 30 N 30 In attesa di informazioni dal cliente 30 N 40 In attesa di conferma dal cliente 50 N 15 Accettata 20 N 50 Chiusa \N C 60 Sospesa \N S \. COPY "tabaperchiam" FROM stdin; 1 Apertura \. COPY "tabchiuschiam" FROM stdin; 1 Chiusura \. COPY "tabcontratti" FROM stdin; 0 Fisso 0 1 Silver 16 5 Gold 8 10 Platinum 0 \. COPY "tabseverita" FROM stdin; 1 C.FERMO red 2 MEDIO yellow 3 NON GRAVE normal 4 Richiesta in valutazione normal 5 Normale pink \. COPY "tabtitoli" FROM stdin; 2 PERITO 1 INGEGNERE 3 PROGRAMMATORE 4 RAGIONIERE 5 DOTTORE \. CREATE UNIQUE INDEX "menus01" on "menus" using btree ( "cod_ute" "int2_ops", "menuname" "bpchar_ops" ); CREATE INDEX "menuitems01" on "menuitems" using btree ( "cod_ute" "int2_ops", "imenuname" "bpchar_ops" ); CREATE UNIQUE INDEX "allarmi01" on "allarmi" using btree ( "cod_allarme" "int2_ops" ); CREATE UNIQUE INDEX "chiamate01" on "chiamate" using btree ( "n_chiam" "int4_ops" ); CREATE INDEX "chiamdet01" on "chiamatedet" using btree ( "n_chiam" "int4_ops" ); CREATE INDEX "chiamdet02" on "chiamatedet" using btree ( "data_ult" "datetime_ops" ); CREATE INDEX "clienti01" on "clienti" using btree ( "rag_soc" "bpchar_ops" ); CREATE INDEX "clienti02" on "clienti" using btree ( "colleg_cn" "bpchar_ops" ); CREATE UNIQUE INDEX "code01" on "code" using btree ( "cod_coda" "int2_ops" ); CREATE UNIQUE INDEX "commesse01" on "commesse" using btree ( "cod_com" "int2_ops" ); CREATE UNIQUE INDEX "esecutori01" on "esecutori" using btree ( "cod_ese" "int2_ops" ); CREATE UNIQUE INDEX "numerachiamate01" on "numerachiamate" using btree ( "cod_azi" "int2_ops" ); CREATE UNIQUE INDEX "numerachiamate02" on "numerachiamate" using btree ( "num_chiamata" "int4_ops" ); CREATE UNIQUE INDEX "stato_chiamata01" on "stato_chiamata" using btree ( "cod_stato" "int2_ops" ); CREATE UNIQUE INDEX "tabaperchiam01" on "tabaperchiam" using btree ( "codaperchiam" "int2_ops" ); CREATE UNIQUE INDEX "tabchiuschiam01" on "tabchiuschiam" using btree ( "codchiuschiam" "int2_ops" ); CREATE UNIQUE INDEX "tabcontratti01" on "tabcontratti" using btree ( "tipo_contratto" "int2_ops" ); CREATE UNIQUE INDEX "tabseverita01" on "tabseverita" using btree ( "codseverita" "int2_ops" ); CREATE UNIQUE INDEX "tabtitoli01" on "tabtitoli" using btree ( "cod_titolo" "int4_ops" );