/sql/Table/printers.sql

 1-- Table: printers
 2
 3-- DROP TABLE printers;
 4
 5CREATE TABLE printers
 6(
 7  id serial NOT NULL,
 8  mandat_id integer NOT NULL,
 9  printer_name character varying(255) NOT NULL,
10  date_created timestamp with time zone NOT NULL DEFAULT now(),
11  descr text,
12  ip_adress inet,
13  CONSTRAINT printers_pkey PRIMARY KEY (id),
14  CONSTRAINT "FK_mandat" FOREIGN KEY (mandat_id)
15      REFERENCES printers_mandat (id) MATCH SIMPLE
16      ON UPDATE NO ACTION ON DELETE NO ACTION
17)
18WITH (OIDS=FALSE);
19ALTER TABLE printers OWNER TO postgres;
20
21-- Index: "FKI_mandat"
22
23-- DROP INDEX "FKI_mandat";
24
25CREATE INDEX "FKI_mandat"
26  ON printers
27  USING btree
28  (mandat_id);