-- ///////////////////////////////////////////////////////////
-- // PROJECTOR                                             //
-- //-------------------------------------------------------//
-- // Version : 8.6.0                                       //
-- // Date : 2020-06-22                                     //
-- ///////////////////////////////////////////////////////////

ALTER TABLE ${prefix}accessprofile MODIFY idAccessScopeRead int(12) COMMENT '12';
ALTER TABLE ${prefix}accessprofile MODIFY idAccessScopeCreate int(12) COMMENT '12';
ALTER TABLE ${prefix}accessprofile MODIFY idAccessScopeUpdate int(12) COMMENT '12';
ALTER TABLE ${prefix}accessprofile MODIFY idAccessScopeDelete int(12) COMMENT '12';
ALTER TABLE ${prefix}accessprofile MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}accessprofile MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}accessright MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}accessright MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}accessright MODIFY idAccessProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}accessscope MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}accessscope MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}accessscope MODIFY isSpecific int(1) unsigned DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}accessscopespecific MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}accessscopespecific MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY idActionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY idEfficiency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}action MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY isPrivate int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}action MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idActivityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activity MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activity MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activity MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activity MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY isPlanningActivity int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activity MODIFY idComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activity MODIFY fixPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activityprice MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activityprice MODIFY idActivityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activityprice MODIFY subcontractor int(1) COMMENT '1';
ALTER TABLE ${prefix}activityprice MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}activityprice MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activityprice MODIFY idTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}activityprice MODIFY isRef int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}activityprice MODIFY pct int(3) COMMENT '3';
ALTER TABLE ${prefix}activityprice MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY rate int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}affectation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}affectation MODIFY idRole int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idResourceSelect int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}affectation MODIFY hideAffectation int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}affectation MODIFY idResourceTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}alert MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}alert MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}alert MODIFY idIndicatorValue int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}alert MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}alert MODIFY readFlag int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}alert MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}approver MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}approver MODIFY idAffectable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}approver MODIFY approved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}approver MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}approver MODIFY disapproved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}asset MODIFY idAssetType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idAffectable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idAsset int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idLocation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idBrand int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idModel int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY idAssetCategory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}asset MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}asset MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}asset MODIFY warantyDurationM int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}asset MODIFY depreciationDurationY int(4) unsigned COMMENT '4';
ALTER TABLE ${prefix}asset MODIFY needInsurance int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assetcategory MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}assetcategory MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY rate int(3) unsigned DEFAULT 100 COMMENT '3';
ALTER TABLE ${prefix}assignment MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY idRole int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY isNotImputable int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY optional int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY isResourceTeam int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY uniqueResource int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY supportedAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY supportedResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignment MODIFY hasSupport int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignment MODIFY isManual int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignmentrecurring MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignmentrecurring MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignmentrecurring MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignmentrecurring MODIFY day int(3) COMMENT '3';
ALTER TABLE ${prefix}assignmentselection MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignmentselection MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}assignmentselection MODIFY userSelected int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}assignmentselection MODIFY selected int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}attachment MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}attachment MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}attachment MODIFY idPrivacy int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}attachment MODIFY idTeam int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}audit MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}audit MODIFY requestRefreshParam int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}audit MODIFY requestDisconnection int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}audit MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}audit MODIFY requestRefreshProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}audit MODIFY durationSeconds int(10) unsigned DEFAULT 0 COMMENT '10';
ALTER TABLE ${prefix}auditsummary MODIFY numberSessions int(10) COMMENT '10';
ALTER TABLE ${prefix}baseline MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}baseline MODIFY baselineNumber int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}baseline MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}baseline MODIFY idTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}baseline MODIFY idPrivacy int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}baseline MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}bill MODIFY idBillType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}bill MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}bill MODIFY billId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}bill MODIFY idActivityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY paymentDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}bill MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idDeliveryMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}bill MODIFY paymentsCount int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}bill MODIFY commandAmountPct int(3) unsigned DEFAULT 100 COMMENT '3';
ALTER TABLE ${prefix}bill MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY line int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}billline MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY idTerm int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY idActivityPrice int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY idMeasureUnit int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY extra int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}billline MODIFY idCatalog int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}billline MODIFY idBillLine int(12) COMMENT '12';
ALTER TABLE ${prefix}brand MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY idBudgetType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idBudgetOrientation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idBudgetCategory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idBudget int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idSponsor int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budget MODIFY isUnderConstruction int(1) unsigned DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY handled int(1) unsigned DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}budget MODIFY elementary int(1) unsigned DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}budgetcategory MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}budgetcategory MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}budgetelement MODIFY year int(4) unsigned COMMENT '4';
ALTER TABLE ${prefix}budgetelement MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budgetelement MODIFY topId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budgetelement MODIFY topRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}budgetelement MODIFY idle int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}budgetelement MODIFY elementary int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}budgetelement MODIFY progress int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}budgetorientation MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}budgetorientation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}businessfeature MODIFY idProduct int(12) COMMENT '12';
ALTER TABLE ${prefix}businessfeature MODIFY idUser int(12) COMMENT '12';
ALTER TABLE ${prefix}businessfeature MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendar MODIFY isOffDay int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendar MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendar MODIFY idCalendarDefinition int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}calendarbankoffdays MODIFY idCalendarDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}calendarbankoffdays MODIFY month int(2) COMMENT '2';
ALTER TABLE ${prefix}calendarbankoffdays MODIFY day int(2) COMMENT '2';
ALTER TABLE ${prefix}calendarbankoffdays MODIFY easterDay int(2) COMMENT '2';
ALTER TABLE ${prefix}calendardefinition MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}calendardefinition MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek0 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek1 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek2 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek3 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek4 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek5 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}calendardefinition MODIFY dayOfWeek6 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY idCallForTenderType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY fixValue int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY idComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}callfortender MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}callfortender MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}catalog MODIFY idCatalogType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}catalog MODIFY idMeasureUnit int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}catalog MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}catalog MODIFY idProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}catalog MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}category MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}category MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idBusinessFeature int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idChangeRequestType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idRunStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY idTargetProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idTargetComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idUrgency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idFeasibility int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY idRiskLevel int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}changerequest MODIFY approved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}changerequest MODIFY idAffectable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklist MODIFY idChecklistDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklist MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklist MODIFY checkCount int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}checklistable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistdefinition MODIFY idChecklistable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklistdefinition MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklistdefinition MODIFY lineCount int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}checklistdefinition MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistdefinitionline MODIFY idChecklistDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklistdefinitionline MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}checklistdefinitionline MODIFY exclusive int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY idChecklist int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklistline MODIFY idChecklistDefinitionLine int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}checklistline MODIFY value01 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY value02 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY value03 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY value04 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY value05 int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}checklistline MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}client MODIFY paymentDelay int(3) COMMENT '3';
ALTER TABLE ${prefix}client MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}client MODIFY idClientType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}client MODIFY paymentDelayEndOfMonth int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}client MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idClientContractType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY initialContractTerm int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}clientcontract MODIFY idUnitDurationContract int(12) unsigned DEFAULT 2 COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY noticePeriod int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}clientcontract MODIFY idUnitDurationNotice int(12) unsigned DEFAULT 2 COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY periodicityContract int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}clientcontract MODIFY periodicityBill int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}clientcontract MODIFY idRenewal int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idContactContract int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY sla int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}clientcontract MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}clientcontract MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}clientcontract MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}clientcontract MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}clientcontract MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}collapsed MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}columnselector MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}columnselector MODIFY hidden int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}columnselector MODIFY sortOrder int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}columnselector MODIFY widthPct int(3) COMMENT '3';
ALTER TABLE ${prefix}command MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idCommandType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}command MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}command MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}command MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}command MODIFY idActivityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idDeliveryMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}command MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}context MODIFY idContextType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}context MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}context MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}contexttype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}copyable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}copyable MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}copyable MODIFY idDefaultCopyable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}criticality MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}criticality MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}criticality MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}cronautosendreport MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}cronautosendreport MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}cronautosendreport MODIFY idReceiver int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}cronautosendreport MODIFY idle int(1) COMMENT '1';
ALTER TABLE ${prefix}cronexecution MODIFY idle int(1) COMMENT '1';
ALTER TABLE ${prefix}customearnedrulesofemploymentcontracttype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}customearnedrulesofemploymentcontracttype MODIFY idEmploymentContractType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}customearnedrulesofemploymentcontracttype MODIFY idLeaveType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}datacloning MODIFY idRequestor int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}datacloning MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}datacloning MODIFY idOrigin int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}datacloning MODIFY isRequestedDelete int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}datacloning MODIFY isActive int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}datacloning MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}decision MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}decision MODIFY idDecisionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}decision MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}decision MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}decision MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}decision MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}decision MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}decision MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delay MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delay MODIFY idUrgency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delay MODIFY idDelayUnit int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delay MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delay MODIFY idProject int(12) COMMENT '12';
ALTER TABLE ${prefix}delay MODIFY isProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delayunit MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}delayunit MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}deliverable MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY idDeliverableType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY impactDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}deliverable MODIFY idDeliverableWeight int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY idDeliverableStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}deliverable MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverablestatus MODIFY value int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}deliverablestatus MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}deliverablestatus MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}deliverableweight MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}deliverableweight MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}deliverableweight MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delivery MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idDeliveryType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY impactDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}delivery MODIFY idDeliverableWeight int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idDeliverableStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delivery MODIFY idProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}delivery MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delivery MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delivery MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}delivery MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}deliverymode MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}deliverymode MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}dependable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}dependable MODIFY idDefaultDependable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}dependency MODIFY predecessorId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}dependency MODIFY predecessorRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}dependency MODIFY successorId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}dependency MODIFY successorRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}dependency MODIFY dependencyDelay int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}document MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idDocumentType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idDocumentDirectory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idVersioningType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY version int(3) COMMENT '3';
ALTER TABLE ${prefix}document MODIFY revision int(3) COMMENT '3';
ALTER TABLE ${prefix}document MODIFY draft int(3) COMMENT '3';
ALTER TABLE ${prefix}document MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idDocumentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idDocumentVersionRef int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idAuthor int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY locked int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}document MODIFY idLocker int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}document MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}document MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}document MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentdirectory MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentdirectory MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentdirectory MODIFY idDocumentDirectory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentdirectory MODIFY idDocumentType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentdirectory MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}documentversion MODIFY version int(3) COMMENT '3';
ALTER TABLE ${prefix}documentversion MODIFY revision int(3) COMMENT '3';
ALTER TABLE ${prefix}documentversion MODIFY draft int(3) COMMENT '3';
ALTER TABLE ${prefix}documentversion MODIFY idDocument int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentversion MODIFY idAuthor int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentversion MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}documentversion MODIFY isRef int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}documentversion MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}documentversion MODIFY approved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}documentversion MODIFY disapproved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}efficiency MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}efficiency MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}emailtemplate MODIFY idMailable int(12) COMMENT '12';
ALTER TABLE ${prefix}emailtemplate MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}emailtemplate MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveearned MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveearned MODIFY idEmployee int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveearned MODIFY idLeaveType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveearned MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idLeaveType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idEmployee int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY submitted int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY rejected int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY accepted int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY statusOutOfWorkflow int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeeleaveperiod MODIFY statusSetLeaveChange int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employeesmanaged MODIFY idEmployeeManager int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeesmanaged MODIFY idEmployee int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employeesmanaged MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employmentcontract MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idEmployee int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idEmploymentContractType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idEmploymentContractEndReason int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employmentcontract MODIFY idTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontract MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontractendreason MODIFY final int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employmentcontractendreason MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employmentcontracttype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}employmentcontracttype MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontracttype MODIFY idWorkflow int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontracttype MODIFY idManagementType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}employmentcontracttype MODIFY isDefault int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}eventformail MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}eventformail MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}expense MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idExpenseType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY idDocument int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY idDeliveryMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY idResponsible int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY paymentDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expense MODIFY isCalculated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expense MODIFY idBudgetItem int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expensedetail MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expensedetail MODIFY idExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expensedetail MODIFY idExpenseDetailType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}expensedetail MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expensedetailtype MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}expensedetailtype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expensedetailtype MODIFY individual int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}expensedetailtype MODIFY project int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}extrahiddenfield MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}extrareadonlyfield MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}extrarequiredfield MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favorite MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favorite MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favorite MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favorite MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}favorite MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}favoriteparameter MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favoriteparameter MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}favoriteparameter MODIFY idFavorite int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}feasibility MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}feasibility MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}filter MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}filter MODIFY isShared int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}filter MODIFY isDynamic int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}filter MODIFY sortOrder int(12) COMMENT '12';
ALTER TABLE ${prefix}filtercriteria MODIFY idFilter int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}filtercriteria MODIFY isDynamic int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}filtercriteria MODIFY orOperator int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}globalview MODIFY objectId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}globalview MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}globalview MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}globalview MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}globalview MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}habilitation MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}habilitation MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}habilitation MODIFY allowAccess int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}habilitationother MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}habilitationreport MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}habilitationreport MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}habilitationreport MODIFY allowAccess int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}health MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}health MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}history MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}history MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}history MODIFY isWorkHistory int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}historyarchive MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}historyarchive MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}historyarchive MODIFY isWorkHistory int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}importable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}importlog MODIFY importTodo int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importDone int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importDoneCreated int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importDoneModified int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importDoneUnchanged int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importRejected int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importRejectedInvalid int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY importRejectedError int(6) COMMENT '6';
ALTER TABLE ${prefix}importlog MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicator MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}indicator MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorableindicator MODIFY idIndicatorable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatorableindicator MODIFY idIndicator int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatorableindicator MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY idIndicatorable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY idIndicator int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY idWarningDelayUnit int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY idAlertDelayUnit int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToUser int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToResource int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToContact int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToLeader int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToOther int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToUser int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToResource int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToContact int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToLeader int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToAssigned int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToManager int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToAssigned int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToManager int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToSubscribers int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToSubscribers int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY idProject int(12) COMMENT '12';
ALTER TABLE ${prefix}indicatordefinition MODIFY isProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToProjectIncludingParentProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToProjectIncludingParentProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY mailToAccountable int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatordefinition MODIFY alertToAccountable int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorvalue MODIFY refId int(10) unsigned COMMENT '10';
ALTER TABLE ${prefix}indicatorvalue MODIFY idIndicatorDefinition int(10) unsigned COMMENT '10';
ALTER TABLE ${prefix}indicatorvalue MODIFY warningSent int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorvalue MODIFY alertSent int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorvalue MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorvalue MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}indicatorvalue MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY allowAttach int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}inputmailboxticket MODIFY sizeAttachment int(6) unsigned DEFAULT 5 COMMENT '6';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idTicketType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idAffectable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idTicket int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY totalInputTicket int(12) unsigned DEFAULT 0 COMMENT '12';
ALTER TABLE ${prefix}inputmailboxticket MODIFY failedRead int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}inputmailboxticket MODIFY failedMessage int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}inputmailboxticket MODIFY limitOfInputPerHour int(6) unsigned DEFAULT 0 COMMENT '6';
ALTER TABLE ${prefix}inputmailboxticket MODIFY limitOfHistory int(6) unsigned DEFAULT 0 COMMENT '6';
ALTER TABLE ${prefix}inputmailboxticket MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}inputmailboxhistory MODIFY idInputMailbox int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}interventioncapacity MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}interventionmode MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}interventionmode MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}issue MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idIssueType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}issue MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}issue MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}issue MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}issue MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}job MODIFY idJoblistDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}job MODIFY idJobDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}job MODIFY value int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}job MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}job MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}jobdefinition MODIFY idJoblistDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}jobdefinition MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}jobdefinition MODIFY daysBeforeWarning int(3) COMMENT '3';
ALTER TABLE ${prefix}joblistdefinition MODIFY idChecklistable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}joblistdefinition MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}joblistdefinition MODIFY lineCount int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}joblistdefinition MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}kanban MODIFY idUser int(12) COMMENT '12';
ALTER TABLE ${prefix}kanban MODIFY isShared int(1) COMMENT '1';
ALTER TABLE ${prefix}kpidefinition MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}kpihistory MODIFY idKpiDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}kpihistory MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}kpihistory MODIFY refDone int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}kpithreshold MODIFY idKpiDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}kpivalue MODIFY idKpiDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}kpivalue MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}kpivalue MODIFY refDone int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}language MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}language MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetype MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}leavetype MODIFY idWorkflow int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}leavetype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY idEmploymentContractType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY idLeaveType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY periodDuration int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY isIntegerQuotity int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY earnedPeriod int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY isUnpayedAllowed int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY isJustifiable int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY isAnticipated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY validityDuration int(5) unsigned DEFAULT 12 COMMENT '5';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY nbDaysAfterNowLeaveDemandIsAllowed int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}leavetypeofemploymentcontracttype MODIFY nbDaysBeforeNowLeaveDemandIsAllowed int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}likelihood MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}likelihood MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}likelihood MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}likelihood MODIFY valuePct int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}link MODIFY ref1Id int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}link MODIFY ref2Id int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}link MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}linkable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}linkable MODIFY idDefaultLinkable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}list MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}list MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}livemeeting MODIFY idMeeting int(12) COMMENT '12';
ALTER TABLE ${prefix}location MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}location MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}mail MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mail MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mail MODIFY refType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mail MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mail MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mail MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}mailable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}mailtosend MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mailtosend MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mailtosend MODIFY idEmailTemplate int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}mailtosend MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}measureunit MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}measureunit MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}meeting MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idMeetingType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}meeting MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}meeting MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}meeting MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY idPeriodicMeeting int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}meeting MODIFY isPeriodic int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}meeting MODIFY periodicOccurence int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}meeting MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}menu MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}menu MODIFY sortOrder int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}menu MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}menu MODIFY isAdminMenu int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}menu MODIFY isLeavesSystemMenu int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}menucustom MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}menucustom MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}menucustom MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}menuselector MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}message MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}message MODIFY idMessageType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}message MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}message MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}message MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}message MODIFY showOnLogin int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}messagelegal MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}messagelegal MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}messagelegalfollowup MODIFY idMessageLegal int(12) COMMENT '12';
ALTER TABLE ${prefix}messagelegalfollowup MODIFY idUser int(12) COMMENT '12';
ALTER TABLE ${prefix}messagelegalfollowup MODIFY accepted int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}milestone MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}milestone MODIFY idMilestoneType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}milestone MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}milestone MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}milestone MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}model MODIFY idAssetType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}model MODIFY idBrand int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}model MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}module MODIFY sortOrder int(5) COMMENT '5';
ALTER TABLE ${prefix}module MODIFY idModule int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}module MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}module MODIFY active int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}modulemenu MODIFY idModule int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}modulemenu MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}modulemenu MODIFY hidden int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}modulemenu MODIFY active int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}modulereport MODIFY idModule int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}modulereport MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}modulereport MODIFY hidden int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}modulereport MODIFY active int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}note MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}note MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}note MODIFY idPrivacy int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}note MODIFY idTeam int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}note MODIFY fromEmail int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}note MODIFY idProject int(12) COMMENT '12';
ALTER TABLE ${prefix}note MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}note MODIFY idNote int(12) COMMENT '12';
ALTER TABLE ${prefix}note MODIFY replyLevel int(12) DEFAULT 0 COMMENT '12';
ALTER TABLE ${prefix}notifiable MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notification MODIFY idNotificationDefinition int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idNotifiable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idNotificationType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY idStatusNotification int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY notifiedObjectId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notification MODIFY sendEmail int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notification MODIFY emailSent int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notification MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY idNotifiable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notificationdefinition MODIFY idMenu int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notificationdefinition MODIFY idNotificationType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}notificationdefinition MODIFY sendEmail int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY everyDay int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY everyWeek int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY everyMonth int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY everyYear int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}notificationdefinition MODIFY fixedDay int(5) COMMENT '5';
ALTER TABLE ${prefix}notificationdefinition MODIFY fixedMonth int(5) COMMENT '5';
ALTER TABLE ${prefix}notificationdefinition MODIFY notificationNbRepeatsBefore int(5) COMMENT '5';
ALTER TABLE ${prefix}notificationdefinition MODIFY notificationGenerateBefore int(5) COMMENT '5';
ALTER TABLE ${prefix}notificationdefinition MODIFY notificationGenerateBeforeInMin int(5) COMMENT '5';
ALTER TABLE ${prefix}notificationdefinition MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}opportunity MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idOpportunityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idSeverity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idLikelihood int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}opportunity MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}opportunity MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}opportunity MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}opportunity MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}organization MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}organization MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}organization MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}organization MODIFY idOrganizationType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}organization MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}organization MODIFY alertOverPct int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}organization MODIFY warningOverPct int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}organization MODIFY okUnderPct int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}origin MODIFY originId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}origin MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}origin MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}originable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}otherclient MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}otherclient MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}otherclient MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}otherversion MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}otherversion MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}otherversion MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}overallprogress MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}overallprogress MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}parameter MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}parameter MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idPaymentMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}payment MODIFY idPaymentType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}payment MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}paymentdelay MODIFY days int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}paymentdelay MODIFY endOfMonth int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}paymentdelay MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}paymentdelay MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}paymentmode MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}paymentmode MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}periodicity MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}periodicity MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}periodicmeeting MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY idMeetingType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityTimes int(3) COMMENT '3';
ALTER TABLE ${prefix}periodicmeeting MODIFY idPeriodicity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityDailyFrequency int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityWeeklyFrequency int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityWeeklyDay int(1) COMMENT '1';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityMonthlyDayFrequency int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityMonthlyDayDay int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityMonthlyWeekFrequency int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityMonthlyWeekNumber int(1) COMMENT '1';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityMonthlyWeekDay int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityYearlyDay int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityYearlyMonth int(2) COMMENT '2';
ALTER TABLE ${prefix}periodicmeeting MODIFY periodicityOpenDays int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}periodicmeeting MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}periodicmeeting MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedwork MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedwork MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedwork MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedwork MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedwork MODIFY idLeave int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedwork MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedwork MODIFY isManual int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY idBaseline int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY isRealWork int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedworkbaseline MODIFY isManual int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY inputUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idInterventionMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idWork int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plannedworkmanual MODIFY idPlannedWork int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY initialDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelement MODIFY validatedDuration int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}planningelement MODIFY plannedDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelement MODIFY realDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelement MODIFY topId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY topRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY priority int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}planningelement MODIFY idle int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY elementary int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY idPlanningMode int(12) COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY idBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY progress int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}planningelement MODIFY expectedProgress int(6) unsigned DEFAULT 0 COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY validatedCalculated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY marginWorkPct int(6) COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY marginCostPct int(6) COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY validatedExpenseCalculated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY needReplan int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY organizationInherited int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY organizationElementary int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY isOnCriticalPath int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY isManualProgress int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY indivisibility int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY fixPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelement MODIFY unitToDeliver int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY unitToRealise int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY unitRealised int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY unitLeft int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelement MODIFY idProgressMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelement MODIFY idWeightMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idBaseline int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY initialDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelementbaseline MODIFY validatedDuration int(5) unsigned COMMENT '5';
ALTER TABLE ${prefix}planningelementbaseline MODIFY plannedDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelementbaseline MODIFY realDuration int(5) COMMENT '5';
ALTER TABLE ${prefix}planningelementbaseline MODIFY topId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY topRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY priority int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idle int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY elementary int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idPlanningMode int(12) COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY progress int(3) unsigned DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}planningelementbaseline MODIFY expectedProgress int(6) unsigned DEFAULT 0 COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY validatedCalculated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY marginWorkPct int(6) COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY marginCostPct int(6) COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY validatedExpenseCalculated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY needReplan int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY isOnCriticalPath int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY isGlobal int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY isManualProgress int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY surbooked int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY indivisibility int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY fixPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningelementbaseline MODIFY unitToDeliver int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY unitToRealise int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY unitRealised int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY unitLeft int(6) unsigned COMMENT '6';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idProgressMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementbaseline MODIFY idWeightMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementextension MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementextension MODIFY topId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningelementextension MODIFY topRefId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}planningmode MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}planningmode MODIFY mandatoryStartDate int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningmode MODIFY mandatoryEndDate int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningmode MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}planningmode MODIFY mandatoryDuration int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plugin MODIFY isDeployed int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plugin MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}pluginbutton MODIFY idPlugin int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}pluginbutton MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}plugintriggeredevent MODIFY idPlugin int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}plugintriggeredevent MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}predefinedaction MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idActionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY initialDueDateDelay int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}predefinedaction MODIFY actualDueDateDelay int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}predefinedaction MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY idEfficiency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedaction MODIFY isPrivate int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}predefinedaction MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}predefinedsituation MODIFY idSituationable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedsituation MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedsituation MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}predefinedsituation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}predefinedtext MODIFY idTextable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedtext MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}predefinedtext MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}priority MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}priority MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}priority MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}privacy MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}privacy MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}product MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}product MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idProductType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idComponentType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}product MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productasset MODIFY idAsset int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productasset MODIFY idProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productasset MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productcontext MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productcontext MODIFY idContext int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productcontext MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productcontext MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}productlanguage MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productlanguage MODIFY idLanguage int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productlanguage MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productlanguage MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}productproject MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productproject MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productproject MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}productstructure MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productstructure MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productstructure MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productstructure MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}productversionstructure MODIFY idProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productversionstructure MODIFY idComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productversionstructure MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}productversionstructure MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}profile MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}profile MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}progressmode MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}progressmode MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idClient int(12) COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY paymentDelay int(3) COMMENT '3';
ALTER TABLE ${prefix}project MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idProjectType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idHealth int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY fixPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idOverallProgress int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idQuality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idTrend int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idSponsor int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY isUnderConstruction int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY organizationInherited int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}project MODIFY organizationElementary int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}project MODIFY idCategory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}project MODIFY handled int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY excludeFromGlobalPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY fixPerimeter int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}project MODIFY isLeaveMngProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}projecthistory MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY refIdExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY idResourceExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY refIdIncome int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY idResourceIncome int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}projectsituation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}provider MODIFY idProviderType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}provider MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}provider MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY idProviderBillType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY evaluationRank int(3) COMMENT '3';
ALTER TABLE ${prefix}providerbill MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY paymentsCount int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}providerbill MODIFY paymentDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerbill MODIFY idProjectExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerbill MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idProviderOrderType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY evaluationRank int(3) COMMENT '3';
ALTER TABLE ${prefix}providerorder MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerorder MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerorder MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerorder MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerorder MODIFY idProjectExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerorder MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idProviderBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idProviderTerm int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idPaymentMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}providerpayment MODIFY idProviderPaymentType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerpayment MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY done int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}providerterm MODIFY idle int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}providerterm MODIFY idProviderOrder int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY idProviderBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY idProjectExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}providerterm MODIFY isBilled int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}providerterm MODIFY isPaid int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}quality MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}quality MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}question MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}question MODIFY idQuestionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}question MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}question MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}question MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}question MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}question MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}question MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}question MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}quotation MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idQuotationType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}quotation MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}quotation MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}quotation MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}quotation MODIFY idActivityType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idPaymentDelay int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idDeliveryMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idLikelihood int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}quotation MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}recipient MODIFY taxFree int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}recipient MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}referencable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}renewal MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}renewal MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY idReportCategory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}report MODIFY sortOrder int(5) COMMENT '5';
ALTER TABLE ${prefix}report MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasCsv int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasView int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasPrint int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasPdf int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasToday int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasFavorite int(1) DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasWord int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}report MODIFY hasExcel int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}reportcategory MODIFY sortOrder int(5) COMMENT '5';
ALTER TABLE ${prefix}reportcategory MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}reportparameter MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}reportparameter MODIFY sortOrder int(5) COMMENT '5';
ALTER TABLE ${prefix}reportparameter MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}reportparameter MODIFY multiple int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idRequirementType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idRequirement int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY idTargetProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idUrgency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idFeasibility int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idRiskLevel int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY countPassed int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countFailed int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countBlocked int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countPlanned int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countLinked int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countIssues int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY countTotal int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}requirement MODIFY idRunStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY locked int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY idLocker int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}requirement MODIFY idBusinessFeature int(12) COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idTargetComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}requirement MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resolution MODIFY solved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resolution MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}resolution MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY idProfile int(12) COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY isResource int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY isUser int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY locked int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY idTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY isContact int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY idClient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY idRole int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY idRecipient int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY isLdap int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY loginTry int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}resource MODIFY idCalendarDefinition int(12) unsigned DEFAULT 1 COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY dontReceiveTeamMails int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY idOrganization int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY idLanguage int(12) COMMENT '12';
ALTER TABLE ${prefix}resource MODIFY isResourceTeam int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY isEmployee int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY isLeaveManager int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY subcontractor int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resource MODIFY student int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resourcecapacity MODIFY idResource int(12) COMMENT '12';
ALTER TABLE ${prefix}resourcecapacity MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resourcecost MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourcecost MODIFY idRole int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourcecost MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resourceincompatible MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourceincompatible MODIFY idIncompatible int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourcesupport MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourcesupport MODIFY idSupport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourcesupport MODIFY rate int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}resourcesurbooking MODIFY idResource int(12) COMMENT '12';
ALTER TABLE ${prefix}resourcesurbooking MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}resourceteamaffectation MODIFY idResourceTeam int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourceteamaffectation MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}resourceteamaffectation MODIFY rate int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}resourceteamaffectation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}restrictlist MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}restrictlist MODIFY showAll int(1) COMMENT '1';
ALTER TABLE ${prefix}restrictlist MODIFY showStarted int(1) COMMENT '1';
ALTER TABLE ${prefix}restrictlist MODIFY showDelivered int(1) COMMENT '1';
ALTER TABLE ${prefix}restrictlist MODIFY showInService int(1) COMMENT '1';
ALTER TABLE ${prefix}restricttype MODIFY idProjectType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}restricttype MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}restricttype MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}restricttype MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idRiskType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idSeverity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idLikelihood int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}risk MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}risk MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}risk MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}risk MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}risklevel MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}risklevel MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}role MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}role MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}rulableforempcontracttype MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}runstatus MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}runstatus MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}severity MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}severity MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}severity MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}situation MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}situation MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}situation MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}situation MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}situation MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}situationable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}sla MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}sla MODIFY idTicketType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}sla MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setDoneStatus int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setIdleStatus int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}status MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}status MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setHandledStatus int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY isCopyStatus int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setCancelledStatus int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setIntoserviceStatus int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setSubmittedLeave int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setAcceptedLeave int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY setRejectedLeave int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}status MODIFY fixPlanning int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}statusmail MODIFY idMailable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}statusmail MODIFY mailToUser int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToResource int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToContact int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToLeader int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToOther int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idEventForMail int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}statusmail MODIFY mailToManager int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToAssigned int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}statusmail MODIFY mailToSubscribers int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToProjectIncludingParentProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idProject int(12) COMMENT '12';
ALTER TABLE ${prefix}statusmail MODIFY isProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY mailToAccountable int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}statusmail MODIFY idEmailTemplate int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}subscription MODIFY idAffectable int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}subscription MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}subscription MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}subscription MODIFY isAutoSub int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}suppliercontract MODIFY idSupplierContractType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY initialContractTerm int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}suppliercontract MODIFY idUnitDurationContract int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY noticePeriod int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}suppliercontract MODIFY idUnitDurationNotice int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY periodicityContract int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}suppliercontract MODIFY periodicityBill int(5) unsigned DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}suppliercontract MODIFY idRenewal int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY idContactContract int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY sla int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}suppliercontract MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}suppliercontract MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}suppliercontract MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}suppliercontract MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}suppliercontract MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}team MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}team MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tempupdate MODIFY refId int(12) COMMENT '12';
ALTER TABLE ${prefix}tempupdate MODIFY idOther int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idTenderType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idCallForTender int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idTenderStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idProvider int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY evaluationRank int(3) COMMENT '3';
ALTER TABLE ${prefix}tender MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tender MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tender MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tender MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tender MODIFY idProjectExpense int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tender MODIFY idSituation int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tenderevaluation MODIFY idTenderEvaluationCriteria int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tenderevaluation MODIFY idTender int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tenderevaluationcriteria MODIFY idCallForTender int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}tenderevaluationcriteria MODIFY criteriaMaxValue int(3) unsigned DEFAULT 10 COMMENT '3';
ALTER TABLE ${prefix}tenderevaluationcriteria MODIFY criteriaCoef int(3) unsigned DEFAULT 1 COMMENT '3';
ALTER TABLE ${prefix}tenderstatus MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}tenderstatus MODIFY isWaiting int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tenderstatus MODIFY isReceived int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tenderstatus MODIFY isNotSelect int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tenderstatus MODIFY isSelected int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}tenderstatus MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}term MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}term MODIFY idle int(1) unsigned COMMENT '1';
ALTER TABLE ${prefix}term MODIFY idBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}term MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}term MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}term MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcase MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idTestCaseType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idContext1 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idContext2 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idContext3 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idTestCase int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcase MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcase MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcase MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY sessionCount int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testcase MODIFY runCount int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testcase MODIFY idRunStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcase MODIFY idBusinessFeature int(12) COMMENT '12';
ALTER TABLE ${prefix}testcase MODIFY idComponentVersion int(12) COMMENT '12';
ALTER TABLE ${prefix}testcaserun MODIFY idTestCase int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcaserun MODIFY idTestSession int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcaserun MODIFY idRunStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcaserun MODIFY idTicket int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testcaserun MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testcaserun MODIFY sortOrder int(3) DEFAULT 0 COMMENT '3';
ALTER TABLE ${prefix}testsession MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idTestSessionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testsession MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testsession MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}testsession MODIFY countPassed int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY countFailed int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY countBlocked int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY countTotal int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY countIssues int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY countPlanned int(5) DEFAULT 0 COMMENT '5';
ALTER TABLE ${prefix}testsession MODIFY idRunStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idTestSession int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}testsession MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}textable MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idTicketType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idCriticality int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idUrgency int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idPriority int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY handled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idTargetProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idOriginalProductVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idTicket int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idContext1 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idContext2 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idContext3 int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY cancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idComponent int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idOriginalComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idTargetComponentVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idResolution int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY solved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idBusinessFeature int(12) COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY delayReadOnly int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY isRegression int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}ticket MODIFY idAccountable int(12) COMMENT '12';
ALTER TABLE ${prefix}ticket MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}today MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}today MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}today MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}today MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}todayparameter MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}todayparameter MODIFY idReport int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}todayparameter MODIFY idToday int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}trend MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}trend MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}type MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY idWorkflow int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}type MODIFY mandatoryDescription int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY mandatoryResultOnDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY mandatoryResourceOnHandled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockHandled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockIdle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockCancelled int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY showInFlash int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY idPlanningMode int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}type MODIFY mandatoryResolutionOnDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockSolved int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY idCategory int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}type MODIFY lockNoLeftOnDone int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY priority int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}type MODIFY lockIntoservice int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY lockUseOnlyForCC int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY isLeadProject int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}type MODIFY canHaveSubActivity int(1) unsigned DEFAULT 1 COMMENT '1';
ALTER TABLE ${prefix}unitcontract MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}unitcontract MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}urgency MODIFY value int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}urgency MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}urgency MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}version MODIFY idProduct int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY idContact int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}version MODIFY isEis int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}version MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY idVersionType int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY isStarted int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}version MODIFY isDelivered int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}version MODIFY idStatus int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}version MODIFY idMilestone int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncompatibility MODIFY idVersionA int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncompatibility MODIFY idVersionB int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncompatibility MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncompatibility MODIFY idle int(1) DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}versioncontext MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncontext MODIFY idContext int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncontext MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versioncontext MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}versionlanguage MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versionlanguage MODIFY idLanguage int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versionlanguage MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versionlanguage MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}versionproject MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versionproject MODIFY idVersion int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}versionproject MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}visibilityscope MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}visibilityscope MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}weightmode MODIFY sortOrder int(3) unsigned COMMENT '3';
ALTER TABLE ${prefix}weightmode MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}work MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY idAssignment int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY idBill int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY idWorkElement int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY idLeave int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY inputUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}work MODIFY isManual int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workelement MODIFY refId int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workelement MODIFY done int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workelement MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workelement MODIFY ongoing int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workelement MODIFY idUser int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workelement MODIFY idActivity int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workelement MODIFY idProject int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflow MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workflow MODIFY sortOrder int(3) COMMENT '3';
ALTER TABLE ${prefix}workflow MODIFY isLeaveWorkflow int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workflowprofile MODIFY idWorkflow int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowprofile MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowprofile MODIFY checked int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workflowstatus MODIFY idWorkflow int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowstatus MODIFY idStatusFrom int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowstatus MODIFY idStatusTo int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowstatus MODIFY idProfile int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workflowstatus MODIFY allowed int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workperiod MODIFY idResource int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workperiod MODIFY submitted int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workperiod MODIFY validated int(1) unsigned DEFAULT 0 COMMENT '1';
ALTER TABLE ${prefix}workperiod MODIFY idLocker int(12) unsigned COMMENT '12';
ALTER TABLE ${prefix}workperiod MODIFY idle int(1) unsigned DEFAULT 0 COMMENT '1';
