Commits

dianmora committed 292edca

Fixed updated installation scripts. ENCUESTAME-504

Comments (0)

Files changed (3)

encuestame-business/src/main/java/org/encuestame/business/service/PollService.java

             pollDomain.setPublish(Boolean.TRUE);
            
             if (hashtags.size() > 0) {
-            	//http://issues.encuestame.org/browse/ENCUESTAME-504
-            	//pollDomain.getHashTags().addAll(retrieveListOfHashTags(hashtags));	
+            	//http://issues.encuestame.org/browse/ENCUESTAME-504 
+            	pollDomain.getHashTags().addAll(retrieveListOfHashTags(hashtags));	
             } 
             log.debug("poll list answer=>" + answers.length);
             // Add answers

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

 --
 -- Constraints for table `poll_hashtags`
 --
-ALTER TABLE `poll_hashtags`
-  ADD CONSTRAINT `FK9D199EA761842F44` FOREIGN KEY (`poll_id`) REFERENCES `surveys` (`sid`),
+ALTER TABLE `poll_hashtags` 
   ADD CONSTRAINT `FK9D199EA7DA98FFE1` FOREIGN KEY (`hastag_id`) REFERENCES `hash_tags` (`hash_tag_id`),
   ADD CONSTRAINT `FK9D199EA7F0ED6769` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`poll_id`);
 

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

   `hastag_id` bigint(20) NOT NULL,
   PRIMARY KEY (`poll_id`,`hastag_id`),
   KEY `FK9D199EA7DA98FFE1` (`hastag_id`),
-  KEY `FK9D199EA7F0ED6769` (`poll_id`),
-  KEY `FK9D199EA761842F44` (`poll_id`)
+  KEY `FK9D199EA7F0ED6769` (`poll_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --