Index: lams_tool_vote/db/sql/create_lams_tool_vote.sql =================================================================== diff -u -rbb9636f8038c20ea45b41680f3d822a0bc8561a5 -r7ecd286fe1e120fbdfcd958c96ad50133c4b8f13 --- lams_tool_vote/db/sql/create_lams_tool_vote.sql (.../create_lams_tool_vote.sql) (revision bb9636f8038c20ea45b41680f3d822a0bc8561a5) +++ lams_tool_vote/db/sql/create_lams_tool_vote.sql (.../create_lams_tool_vote.sql) (revision 7ecd286fe1e120fbdfcd958c96ad50133c4b8f13) @@ -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 =================================================================== diff -u -rbb9636f8038c20ea45b41680f3d822a0bc8561a5 -r7ecd286fe1e120fbdfcd958c96ad50133c4b8f13 --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101.sql (.../patch20170101.sql) (revision bb9636f8038c20ea45b41680f3d822a0bc8561a5) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101.sql (.../patch20170101.sql) (revision 7ecd286fe1e120fbdfcd958c96ad50133c4b8f13) @@ -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-------------------------