1. Juan Carlos Picado Herrera
  2. encuestame

Commits

dianmora  committed e28a9d6

Updated script ENCUESTAME-513

  • Participants
  • Parent commits d3e2027
  • Branches master

Comments (0)

Files changed (2)

File encuestame-business/src/main/resources/org/encuestame/business/sqlscripts/postgres/install/alter.sql

View file
     ADD CONSTRAINT fk30df40953c854b FOREIGN KEY (tweetpoll_tweet_poll_id) REFERENCES tweetpoll(tweet_poll_id);
 
 
+ALTER TABLE ONLY hits 
+	ADD CONSTRAINT FK30DF40369F8B2C FOREIGN KEY (userAccount_uid) REFERENCES userAccount(uid);
 --
 -- TOC entry 2155 (class 2606 OID 100019)
 -- Dependencies: 1669 1656 2047

File encuestame-business/src/main/resources/org/encuestame/business/sqlscripts/postgres/install/tables.sql

View file
     hits_ip_address character varying(100) NOT NULL,
     hashtag_hash_tag_id bigint,
     poll_poll_id bigint,
+	hit_category integer NOT NULL,
     survey_sid bigint,
-    tweetpoll_tweet_poll_id bigint
+    tweetpoll_tweet_poll_id bigint,
+	userAccount_uid bigint
+
 );