PageRenderTime 13ms CodeModel.GetById 1ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

/sql/Table/printers.sql

http://cupsfilter.googlecode.com/
SQL | 28 lines | 19 code | 5 blank | 4 comment | 0 complexity | 296e5cb75905b69d95dc4a79ecf260b6 MD5 | raw file
 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);