Guest User

task status table and indexes

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