Index: lams_tool_vote/db/sql/create_lams_tool_vote.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/create_lams_tool_vote.sql,v diff -u -r1.31.2.1 -r1.31.2.2 --- lams_tool_vote/db/sql/create_lams_tool_vote.sql 27 Feb 2017 22:36:00 -0000 1.31.2.1 +++ lams_tool_vote/db/sql/create_lams_tool_vote.sql 2 Mar 2017 14:02:33 -0000 1.31.2.2 @@ -5,8 +5,8 @@ , instructions TEXT , creation_date DATETIME , update_date DATETIME - , maxNominationCount VARCHAR(20) NOT NULL DEFAULT 1 - , minNominationCount VARCHAR(20) NOT NULL DEFAULT 1 + , maxNominationCount SMALLINT NOT NULL DEFAULT 1 + , minNominationCount SMALLINT 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 Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/Attic/patch20170101.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101.sql 27 Feb 2017 22:35:11 -0000 1.1.2.1 +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101.sql 2 Mar 2017 14:02:33 -0000 1.1.2.2 @@ -4,6 +4,9 @@ ----------------------Put all sql statements below here------------------------- -- LDEV-4180 +ALTER TABLE tl_lavote11_content MODIFY COLUMN maxNominationCount SMALLINT NOT NULL DEFAULT 1, + MODIFY COLUMN minNominationCount SMALLINT NOT NULL DEFAULT 1; + UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lavote11'; ----------------------Put all sql statements above here-------------------------