\connect template1
select datdba into table tmp_pg_shadow       from pg_database where datname = 'template1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
root	0	t	t	t	t	\N	\N
uox	1003	f	t	f	t		\N
tanis	1000	f	t	f	t	tanis	\N
\.
\connect template1 postgres
create database radiusd;
\connect radiusd postgres
CREATE SEQUENCE "login_id_seq" start 2593 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('login_id_seq');
CREATE SEQUENCE "clienti_id_seq" start 1783 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('clienti_id_seq');
CREATE SEQUENCE "fatture_id_seq" start 1784 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('fatture_id_seq');
CREATE SEQUENCE "oggetti_id_seq" start 3 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "pagamenti_id_seq" start 7 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tipicontratti_id_seq" start 31 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "vocifatture_id_seq" start 3083 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('vocifatture_id_seq');
CREATE TABLE "users" (
	"pass" character varying(16),
	"username" character varying(8));
CREATE TABLE "logs" (
	"bwin" int4,
	"bwout" int4,
	"name" character varying(32),
	"start" datetime,
	"stop" datetime);
CREATE TABLE "loginBACKUP" (
	"ID" int4,
	"IDC" int4,
	"Login" character varying(50),
	"Nota" text,
	"Attivazione" datetime,
	"Disattivazione" datetime,
	"Importo_pagato" float8,
	"Demo" character,
	"Lasciare" character,
	"Notalasciare" character varying(50),
	"Tipo" character varying(100),
	"Disattivato" character,
	"Fatturato" character);
CREATE TABLE "pgadmin_sys" (
	"id" int2 DEFAULT '1',
	"tracking" "char" DEFAULT 'N',
	"version" float4 DEFAULT '1.0');
CREATE TABLE "pgadmin_log" (
	"event_date" date,
	"username" name,
	"version" float4,
	"query" text);
CREATE TABLE "login" (
	"id" int4 DEFAULT nextval('login_id_seq') NOT NULL,
	"idc" int4,
	"login" character varying(50),
	"nota" text,
	"attivazione" datetime,
	"disattivazione" datetime,
	"importo_pagato" float8,
	"demo" int2,
	"lasciare" int2,
	"notalasciare" character varying(50),
	"tipo" character varying(100),
	"disattivato" int2,
	"fatturato" int2,
	"numeroc" character varying(50),
	"datanascita" datetime,
	"tipodoc" character varying(20),
	"numerodoc" character varying(30),
	"nemail" int2,
	"costoemail" float8,
	"email2" character varying(20),
	"email3" character varying(20),
	"email4" character varying(20),
	"email5" character varying(20),
	"kwebc" int2,
	"kwebnc" int2,
	"costoweb" float8);
CREATE TABLE "clienti" (
	"id" int4 DEFAULT nextval('clienti_id_seq') NOT NULL,
	"idcliente" character varying(50),
	"nome" character varying(50),
	"ditta" character varying(50),
	"indirizzo" character varying(254),
	"partitaiva" character varying(20),
	"tel" character varying(50),
	"nota" text);
CREATE TABLE "fatture" (
	"id" int4 DEFAULT nextval('fatture_id_seq') NOT NULL,
	"numerof" character varying(50),
	"data" datetime,
	"idc" int4,
	"pagamento" character varying(50),
	"condizioni" character varying(100),
	"oggetto" character varying(254),
	"iva" int2);
CREATE TABLE "oggetti" (
	"id" int4 DEFAULT nextval('oggetti_id_seq') NOT NULL,
	"oggetto" character varying(50));
CREATE TABLE "pagamenti" (
	"id" int4 DEFAULT nextval('pagamenti_id_seq') NOT NULL,
	"paga" character varying(50));
CREATE TABLE "tipicontratti" (
	"id" int4 DEFAULT nextval('tipicontratti_id_seq') NOT NULL,
	"tipo" character varying(254),
	"importo" float8);
CREATE TABLE "vocifatture" (
	"id" int4 DEFAULT nextval('vocifatture_id_seq') NOT NULL,
	"idfattura" int4,
	"quantita" int4,
	"descrizione" character varying(254),
	"importo" float8,
	"totale" float8);
CREATE FUNCTION "msaccessbool" (bool,int4 ) RETURNS bool AS '-' LANGUAGE 'INTERNAL';
CREATE FUNCTION "bool2int" (bool ) RETURNS int2 AS 'SELECT int2(-1) WHERE $1 UNION SELECT int2(0) WHERE
 NOT $1' LANGUAGE 'SQL';