Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE priority
- (
- id integer NOT NULL,
- updated_by_id integer,
- created_by_id integer,
- title character varying(50) NOT NULL,
- updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- CONSTRAINT priority_pkey PRIMARY KEY (id ),
- CONSTRAINT fk_62a6dc27896dbbde FOREIGN KEY (updated_by_id)
- REFERENCES fos_user (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_62a6dc27b03a8386 FOREIGN KEY (created_by_id)
- REFERENCES fos_user (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE priority
- OWNER TO sd4;
- -- Index: idx_62a6dc272b36786b
- -- DROP INDEX idx_62a6dc272b36786b;
- CREATE INDEX idx_62a6dc272b36786b
- ON priority
- USING btree
- (title COLLATE pg_catalog."default" );
- -- Index: idx_62a6dc27896dbbde
- -- DROP INDEX idx_62a6dc27896dbbde;
- CREATE INDEX idx_62a6dc27896dbbde
- ON priority
- USING btree
- (updated_by_id );
- -- Index: idx_62a6dc27b03a8386
- -- DROP INDEX idx_62a6dc27b03a8386;
- CREATE INDEX idx_62a6dc27b03a8386
- ON priority
- USING btree
- (created_by_id );
- -- Index: idx_62a6dc27b23db7b8
- -- DROP INDEX idx_62a6dc27b23db7b8;
- CREATE INDEX idx_62a6dc27b23db7b8
- ON priority
- USING btree
- (created );
- -- Index: idx_62a6dc27c69b96f7
- -- DROP INDEX idx_62a6dc27c69b96f7;
- CREATE INDEX idx_62a6dc27c69b96f7
- ON priority
- USING btree
- (updated );
- -- Index: idx_62a6dc27eb3b4e33
- -- DROP INDEX idx_62a6dc27eb3b4e33;
- CREATE INDEX idx_62a6dc27eb3b4e33
- ON priority
- USING btree
- (deleted );
Advertisement
Add Comment
Please, Sign In to add comment