Commits

dianmora committed a43dc4e

Fixed postgres installation. ENCUESTAME-512

  • Participants
  • Parent commits e28a9d6

Comments (0)

Files changed (2)

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

 
 ALTER TABLE ONLY questions
     ADD CONSTRAINT fk95c5414d39e97991 FOREIGN KEY (section_ssid) REFERENCES survey_section(ssid);
-
-
---
--- TOC entry 2181 (class 2606 OID 100149)
--- Dependencies: 2059 1669 1672
--- Name: fk95c5414d84133d82; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-
-
---
--- TOC entry 2162 (class 2606 OID 100054)
--- Dependencies: 2083 1682 1658
--- Name: fk9d199ea761842f44; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY poll_hashtags
-    ADD CONSTRAINT fk9d199ea761842f44 FOREIGN KEY (poll_id) REFERENCES surveys(sid);
-
-
+     
 --
 -- TOC entry 2160 (class 2606 OID 100044)
 -- Dependencies: 1652 2011 1658
 ALTER TABLE ONLY survey_temporal_result ADD CONSTRAINT FK7867CF551153812 FOREIGN KEY (survey_sid) REFERENCES surveys;
 ALTER TABLE ONLY question_preferences ADD CONSTRAINT FKD540D01F46BF7A1C FOREIGN KEY (question_qid) REFERENCES questions;
 
+
+ALTER TABLE ONLY hash_tags_ranking 
+  ADD CONSTRAINT FK71DECDA119AA125 FOREIGN KEY (hashTag_hash_tag_id) REFERENCES hash_tags (hash_tag_id);
+
 -- Completed on 2011-11-30 21:40:42 CET
 
 --

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

 
 CREATE TABLE poll_result (
     poll_resultid bigint NOT NULL,
-    ip_address character varying(255) NOT NULL,
+    ipAddress character varying(255) NOT NULL,
     votation_date timestamp without time zone NOT NULL,
     q_answer_id bigint NOT NULL,
     poll_id bigint NOT NULL
    preference  character varying(255),
    question_qid bigint,
    preference_value character varying(255)
-);
+);
+ 
+CREATE TABLE hash_tags_ranking (
+   rank_id bigint NOT NULL,
+   average real,
+   ranking_updated timestamp without time zone, 
+   hashTag_hash_tag_id bigint);