Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE tv_site_chathistory
  2. (
  3.   id serial NOT NULL,
  4.   user_id integer NOT NULL,
  5.   text text NOT NULL,
  6.   symbol character varying(64) NOT NULL,
  7.   created timestamp with time zone NOT NULL,
  8.   uuid character varying(64) NOT NULL,
  9.   source text NOT NULL,
  10.   CONSTRAINT tv_site_chathistory_pkey PRIMARY KEY (id),
  11.   CONSTRAINT user_id_refs_id_42e3f024 FOREIGN KEY (user_id)
  12.       REFERENCES auth_user (id) MATCH SIMPLE
  13.       ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED
  14. )
  15. WITH (
  16.   OIDS=FALSE
  17. );
  18. ALTER TABLE tv_site_chathistory
  19.   OWNER TO postgres;
  20.  
  21. -- Index: tv_site_chathistory_created
  22.  
  23. -- DROP INDEX tv_site_chathistory_created;
  24.  
  25. CREATE INDEX tv_site_chathistory_created
  26.   ON tv_site_chathistory
  27.   USING btree
  28.   (created);
  29.  
  30. -- Index: tv_site_chathistory_symbol
  31.  
  32. -- DROP INDEX tv_site_chathistory_symbol;
  33.  
  34. CREATE INDEX tv_site_chathistory_symbol
  35.   ON tv_site_chathistory
  36.   USING btree
  37.   (symbol COLLATE pg_catalog."default");
  38.  
  39. -- Index: tv_site_chathistory_symbol_like
  40.  
  41. -- DROP INDEX tv_site_chathistory_symbol_like;
  42.  
  43. CREATE INDEX tv_site_chathistory_symbol_like
  44.   ON tv_site_chathistory
  45.   USING btree
  46.   (symbol COLLATE pg_catalog."default" varchar_pattern_ops);
  47.  
  48. -- Index: tv_site_chathistory_user_id
  49.  
  50. -- DROP INDEX tv_site_chathistory_user_id;
  51.  
  52. CREATE INDEX tv_site_chathistory_user_id
  53.   ON tv_site_chathistory
  54.   USING btree
  55.   (user_id);
  56.  
  57. -- Index: tv_site_chathistory_uuid
  58.  
  59. -- DROP INDEX tv_site_chathistory_uuid;
  60.  
  61. CREATE INDEX tv_site_chathistory_uuid
  62.   ON tv_site_chathistory
  63.   USING btree
  64.   (uuid COLLATE pg_catalog."default");
  65.  
  66. -- Index: tv_site_chathistory_uuid_like
  67.  
  68. -- DROP INDEX tv_site_chathistory_uuid_like;
  69.  
  70. CREATE INDEX tv_site_chathistory_uuid_like
  71.   ON tv_site_chathistory
  72.   USING btree
  73.   (uuid COLLATE pg_catalog."default" varchar_pattern_ops);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement