--
-- Selected TOC Entries:
--
\connect - bellon
--
-- TOC Entry ID 2 (OID 188382)
--
-- Name: etalverif Type: TABLE Owner: bellon
--

CREATE TABLE "etalverif" (
	"nodossier" character varying(30),
	"noappareil" integer,
	"nocertif" character varying(14) NOT NULL,
	"etal_verif" boolean,
	"proceduremet" character varying(15),
	"operateur" integer,
	"lieu" character varying(5),
	"datedeb" date,
	"datefin" date,
	"temperature" real,
	"hygrometrie" real,
	"pression" real,
	"temperature_inc" real,
	"hygrometrie_inc" real,
	"pression_inc" real,
	"etalons" text[],
	"documentgenere" boolean,
	"datedocument" date,
	"referencemaquette" character varying(20),
	"urldocument" character varying(60),
	"datecreat" timestamp with time zone DEFAULT now(),
	"datemodif" timestamp with time zone DEFAULT now(),
	"opersource" character varying(6) DEFAULT "current_user"(),
	"phrase" integer
);

--
-- TOC Entry ID 3 (OID 188382)
--
-- Name: etalverif Type: ACL Owner: 
--

REVOKE ALL on "etalverif" from PUBLIC;
GRANT SELECT on "etalverif" to PUBLIC;
GRANT ALL on "etalverif" to "bellon";
GRANT ALL on "etalverif" to "manceau";
GRANT ALL on "etalverif" to GROUP "metradmin";

--
-- Data for TOC Entry ID 5 (OID 188382)
--
-- Name: etalverif Type: TABLE DATA Owner: bellon
--


COPY "etalverif"  FROM stdin;
\N	\N		\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2001-09-06 13:04:46+02	2001-09-06 13:04:46+02	mancea	1
\.
--
-- TOC Entry ID 4 (OID 188382)
--
-- Name: "etalverif_pkey" Type: INDEX Owner: bellon
--

CREATE UNIQUE INDEX "etalverif_pkey" on "etalverif" using btree ( "nocertif" "varchar_ops" );