Guest User

priority table and indexes

a guest
Apr 2nd, 2013
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. CREATE TABLE priority
  2. (
  3. id integer NOT NULL,
  4. updated_by_id integer,
  5. created_by_id integer,
  6. title character varying(50) NOT NULL,
  7. updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  8. created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  9. deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  10. CONSTRAINT priority_pkey PRIMARY KEY (id ),
  11. CONSTRAINT fk_62a6dc27896dbbde FOREIGN KEY (updated_by_id)
  12. REFERENCES fos_user (id) MATCH SIMPLE
  13. ON UPDATE NO ACTION ON DELETE NO ACTION,
  14. CONSTRAINT fk_62a6dc27b03a8386 FOREIGN KEY (created_by_id)
  15. REFERENCES fos_user (id) MATCH SIMPLE
  16. ON UPDATE NO ACTION ON DELETE NO ACTION
  17. )
  18. WITH (
  19. OIDS=FALSE
  20. );
  21. ALTER TABLE priority
  22. OWNER TO sd4;
  23.  
  24. -- Index: idx_62a6dc272b36786b
  25.  
  26. -- DROP INDEX idx_62a6dc272b36786b;
  27.  
  28. CREATE INDEX idx_62a6dc272b36786b
  29. ON priority
  30. USING btree
  31. (title COLLATE pg_catalog."default" );
  32.  
  33. -- Index: idx_62a6dc27896dbbde
  34.  
  35. -- DROP INDEX idx_62a6dc27896dbbde;
  36.  
  37. CREATE INDEX idx_62a6dc27896dbbde
  38. ON priority
  39. USING btree
  40. (updated_by_id );
  41.  
  42. -- Index: idx_62a6dc27b03a8386
  43.  
  44. -- DROP INDEX idx_62a6dc27b03a8386;
  45.  
  46. CREATE INDEX idx_62a6dc27b03a8386
  47. ON priority
  48. USING btree
  49. (created_by_id );
  50.  
  51. -- Index: idx_62a6dc27b23db7b8
  52.  
  53. -- DROP INDEX idx_62a6dc27b23db7b8;
  54.  
  55. CREATE INDEX idx_62a6dc27b23db7b8
  56. ON priority
  57. USING btree
  58. (created );
  59.  
  60. -- Index: idx_62a6dc27c69b96f7
  61.  
  62. -- DROP INDEX idx_62a6dc27c69b96f7;
  63.  
  64. CREATE INDEX idx_62a6dc27c69b96f7
  65. ON priority
  66. USING btree
  67. (updated );
  68.  
  69. -- Index: idx_62a6dc27eb3b4e33
  70.  
  71. -- DROP INDEX idx_62a6dc27eb3b4e33;
  72.  
  73. CREATE INDEX idx_62a6dc27eb3b4e33
  74. ON priority
  75. USING btree
  76. (deleted );
Advertisement
Add Comment
Please, Sign In to add comment