Index: lams_tool_vote/db/sql/create_lams_tool_vote.sql
===================================================================
diff -u -rca5c456ac4f608121a4e398a675463e1842daccf -r076f681daa99d0471dea9b1f166e5e68e44413ca
--- lams_tool_vote/db/sql/create_lams_tool_vote.sql	(.../create_lams_tool_vote.sql)	(revision ca5c456ac4f608121a4e398a675463e1842daccf)
+++ lams_tool_vote/db/sql/create_lams_tool_vote.sql	(.../create_lams_tool_vote.sql)	(revision 076f681daa99d0471dea9b1f166e5e68e44413ca)
@@ -1,98 +1,98 @@
-CREATE TABLE tl_lavote11_content (
-       uid BIGINT(20) NOT NULL AUTO_INCREMENT
-     , content_id BIGINT(20) NOT NULL
-     , title TEXT
-     , instructions TEXT
-     , creation_date DATETIME
-     , update_date DATETIME
-     , maxNominationCount VARCHAR(20) NOT NULL DEFAULT '1'
-     , allowText TINYINT(1) NOT NULL DEFAULT 0
-     , reflect TINYINT(1) NOT NULL DEFAULT 0
-     , created_by BIGINT(20) NOT NULL DEFAULT 0
-     , run_offline TINYINT(1) NOT NULL DEFAULT 0
-     , define_later TINYINT(1) NOT NULL DEFAULT 0
-     , offline_instructions TEXT
-     , online_instructions TEXT
-     , content_in_use TINYINT(1) NOT NULL DEFAULT 0
-     , lock_on_finish TINYINT(1) NOT NULL DEFAULT 1
-     , retries TINYINT(1) NOT NULL DEFAULT 0
-     , reflectionSubject TEXT
-     , PRIMARY KEY (uid)
-)TYPE=InnoDB;
-
-CREATE TABLE tl_lavote11_session (
-       uid BIGINT(20) NOT NULL AUTO_INCREMENT
-     , vote_session_id BIGINT(20) NOT NULL
-     , session_start_date DATETIME
-     , session_end_date DATETIME
-     , session_name VARCHAR(100)
-     , session_status VARCHAR(100)
-     , vote_content_id BIGINT(20) NOT NULL
-     , UNIQUE UQ_tl_lamc11_session_1 (vote_session_id)
-     , PRIMARY KEY (uid)
-     , INDEX (vote_content_id)
-     , CONSTRAINT FK_tl_lavote11_session_1 FOREIGN KEY (vote_content_id)
-                  REFERENCES tl_lavote11_content (uid)
-)TYPE=InnoDB;
-
-CREATE TABLE tl_lavote11_usr (
-       uid BIGINT(20) NOT NULL AUTO_INCREMENT
-     , user_id BIGINT(20) NOT NULL
-     , vote_session_id BIGINT(20) NOT NULL
-     , username VARCHAR(255)
-     , fullname VARCHAR(255)
-     , responseFinalised TINYINT(1) NOT NULL DEFAULT 0
-     , finalScreenRequested TINYINT(1) NOT NULL DEFAULT 0
-     , PRIMARY KEY (uid)
-     , INDEX (vote_session_id)
-     , CONSTRAINT FK_tl_lavote11_usr_1 FOREIGN KEY (vote_session_id)
-                  REFERENCES tl_lavote11_session (uid)
-)TYPE=InnoDB;
-
-CREATE TABLE tl_lavote11_nomination_content (
-       uid BIGINT(20) NOT NULL AUTO_INCREMENT
-     , nomination TEXT
-     , display_order INT(5)
-     , vote_content_id BIGINT(20) NOT NULL
-     , PRIMARY KEY (uid)
-     , INDEX (vote_content_id)
-     , CONSTRAINT FK_tl_lavote11_nomination_content_1 FOREIGN KEY (vote_content_id)
-                  REFERENCES tl_lavote11_content (uid)
-)TYPE=InnoDB;
-
-CREATE TABLE tl_lavote11_usr_attempt (
-       uid BIGINT(20) NOT NULL AUTO_INCREMENT
-     , que_usr_id BIGINT(20) NOT NULL
-     , vote_nomination_content_id BIGINT(20) NOT NULL
-     , attempt_time DATETIME
-     , time_zone VARCHAR(255)
-     , userEntry VARCHAR(255)
-     , singleUserEntry TINYINT(1) NOT NULL DEFAULT 0
-     , visible TINYINT(1) NOT NULL DEFAULT 1
-     , PRIMARY KEY (uid)
-     , INDEX (que_usr_id)
-     , CONSTRAINT FK_tl_lavote11_usr_attempt_2 FOREIGN KEY (que_usr_id)
-                  REFERENCES tl_lavote11_usr (uid)
-     , INDEX (vote_nomination_content_id)
-     , CONSTRAINT FK_tl_lavote11_usr_attempt_3 FOREIGN KEY (vote_nomination_content_id)
-                  REFERENCES tl_lavote11_nomination_content (uid)
-)TYPE=InnoDB;
-
-CREATE TABLE tl_lavote11_uploadedfile (
-       submissionId BIGINT(20) NOT NULL AUTO_INCREMENT
-     , uuid VARCHAR(255) NOT NULL
-     , isOnline_File TINYINT(1) NOT NULL
-     , filename VARCHAR(255) NOT NULL
-     , vote_content_id BIGINT(20) NOT NULL
-     , PRIMARY KEY (submissionId)
-     , INDEX (vote_content_id)
-     , CONSTRAINT FK_tablex_111 FOREIGN KEY (vote_content_id)
-                  REFERENCES tl_lavote11_content (uid)
-)TYPE=InnoDB;
-
-
-INSERT INTO tl_lavote11_content(uid, content_id , title , instructions , creation_date , created_by , run_offline , define_later, offline_instructions, online_instructions, content_in_use, retries, lock_on_finish) VALUES (1, ${default_content_id} ,'Voting','Instructions', NOW(), 1,0, 0, '','', 0, 0, 0);
-
-INSERT INTO tl_lavote11_nomination_content  (uid,nomination, display_order, vote_content_id) VALUES (1, 'Sample Nomination 1', 1, 1);
-INSERT INTO tl_lavote11_nomination_content  (uid,nomination, display_order, vote_content_id) VALUES (2, 'Sample Nomination 2', 2, 1);
-
+CREATE TABLE tl_lavote11_content (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , content_id BIGINT(20) NOT NULL
+     , title TEXT
+     , instructions TEXT
+     , creation_date DATETIME
+     , update_date DATETIME
+     , maxNominationCount VARCHAR(20) NOT NULL DEFAULT '1'
+     , allowText TINYINT(1) NOT NULL DEFAULT 0
+     , reflect TINYINT(1) NOT NULL DEFAULT 0
+     , created_by BIGINT(20) NOT NULL DEFAULT 0
+     , run_offline TINYINT(1) NOT NULL DEFAULT 0
+     , define_later TINYINT(1) NOT NULL DEFAULT 0
+     , offline_instructions TEXT
+     , online_instructions TEXT
+     , content_in_use TINYINT(1) NOT NULL DEFAULT 0
+     , lock_on_finish TINYINT(1) NOT NULL DEFAULT 1
+     , retries TINYINT(1) NOT NULL DEFAULT 0
+     , reflectionSubject TEXT
+     , PRIMARY KEY (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE tl_lavote11_session (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , vote_session_id BIGINT(20) NOT NULL
+     , session_start_date DATETIME
+     , session_end_date DATETIME
+     , session_name VARCHAR(100)
+     , session_status VARCHAR(100)
+     , vote_content_id BIGINT(20) NOT NULL
+     , UNIQUE UQ_tl_lamc11_session_1 (vote_session_id)
+     , PRIMARY KEY (uid)
+     , INDEX (vote_content_id)
+     , CONSTRAINT FK_tl_lavote11_session_1 FOREIGN KEY (vote_content_id)
+                  REFERENCES tl_lavote11_content (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE tl_lavote11_usr (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , user_id BIGINT(20) NOT NULL
+     , vote_session_id BIGINT(20) NOT NULL
+     , username VARCHAR(255)
+     , fullname VARCHAR(255)
+     , responseFinalised TINYINT(1) NOT NULL DEFAULT 0
+     , finalScreenRequested TINYINT(1) NOT NULL DEFAULT 0
+     , PRIMARY KEY (uid)
+     , INDEX (vote_session_id)
+     , CONSTRAINT FK_tl_lavote11_usr_1 FOREIGN KEY (vote_session_id)
+                  REFERENCES tl_lavote11_session (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE tl_lavote11_nomination_content (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , nomination TEXT
+     , display_order INT(5)
+     , vote_content_id BIGINT(20) NOT NULL
+     , PRIMARY KEY (uid)
+     , INDEX (vote_content_id)
+     , CONSTRAINT FK_tl_lavote11_nomination_content_1 FOREIGN KEY (vote_content_id)
+                  REFERENCES tl_lavote11_content (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE tl_lavote11_usr_attempt (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , que_usr_id BIGINT(20) NOT NULL
+     , vote_nomination_content_id BIGINT(20) NOT NULL
+     , attempt_time DATETIME
+     , time_zone VARCHAR(255)
+     , userEntry VARCHAR(255)
+     , singleUserEntry TINYINT(1) NOT NULL DEFAULT 0
+     , visible TINYINT(1) NOT NULL DEFAULT 1
+     , PRIMARY KEY (uid)
+     , INDEX (que_usr_id)
+     , CONSTRAINT FK_tl_lavote11_usr_attempt_2 FOREIGN KEY (que_usr_id)
+                  REFERENCES tl_lavote11_usr (uid)
+     , INDEX (vote_nomination_content_id)
+     , CONSTRAINT FK_tl_lavote11_usr_attempt_3 FOREIGN KEY (vote_nomination_content_id)
+                  REFERENCES tl_lavote11_nomination_content (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE tl_lavote11_uploadedfile (
+       submissionId BIGINT(20) NOT NULL AUTO_INCREMENT
+     , uuid VARCHAR(255) NOT NULL
+     , isOnline_File TINYINT(1) NOT NULL
+     , filename VARCHAR(255) NOT NULL
+     , vote_content_id BIGINT(20) NOT NULL
+     , PRIMARY KEY (submissionId)
+     , INDEX (vote_content_id)
+     , CONSTRAINT FK_tablex_111 FOREIGN KEY (vote_content_id)
+                  REFERENCES tl_lavote11_content (uid)
+)TYPE=InnoDB;
+
+
+INSERT INTO tl_lavote11_content(uid, content_id , title , instructions , creation_date , created_by , run_offline , define_later, offline_instructions, online_instructions, content_in_use, retries, lock_on_finish) VALUES (1, ${default_content_id} ,'Voting','Instructions', NOW(), 1,0, 0, '','', 0, 0, 0);
+
+INSERT INTO tl_lavote11_nomination_content  (uid,nomination, display_order, vote_content_id) VALUES (1, 'Sample Nomination 1', 1, 1);
+INSERT INTO tl_lavote11_nomination_content  (uid,nomination, display_order, vote_content_id) VALUES (2, 'Sample Nomination 2', 2, 1);
+
Index: lams_tool_vote/db/sql/drop_lams_tool_vote.sql
===================================================================
diff -u -rae28185f07883077586773f760d1bde953e2d9bf -r076f681daa99d0471dea9b1f166e5e68e44413ca
--- lams_tool_vote/db/sql/drop_lams_tool_vote.sql	(.../drop_lams_tool_vote.sql)	(revision ae28185f07883077586773f760d1bde953e2d9bf)
+++ lams_tool_vote/db/sql/drop_lams_tool_vote.sql	(.../drop_lams_tool_vote.sql)	(revision 076f681daa99d0471dea9b1f166e5e68e44413ca)
@@ -1,14 +1,14 @@
-
-DROP TABLE tl_lavote11_uploadedfile;
-DROP TABLE tl_lavote11_usr_attempt;
-DROP TABLE tl_lavote11_nomination_content;
-DROP TABLE tl_lavote11_usr;
-DROP TABLE tl_lavote11_session;
-DROP TABLE tl_lavote11_content;
-
-
-
-
-
-
-
+
+DROP TABLE tl_lavote11_uploadedfile;
+DROP TABLE tl_lavote11_usr_attempt;
+DROP TABLE tl_lavote11_nomination_content;
+DROP TABLE tl_lavote11_usr;
+DROP TABLE tl_lavote11_session;
+DROP TABLE tl_lavote11_content;
+
+
+
+
+
+
+