• Home
• de.alpharogroup
• events.system
• 3.0.0
• source code
• updateEnumFields.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

dll.updateEnumFields.sql Maven / Gradle / Ivy

alter table contactmethods drop column contactmethod;    
alter table contactmethods add contactmethod contactmethodType;

alter table events drop column difficulty;    
alter table events add difficulty difficultyType;

alter table events drop column eventtype;    
alter table events add eventtype eventlocationType;

alter table user_data drop column gender;    
alter table user_data add gender genderType;

alter table messages drop column state;    
alter table messages add state messageStateType;

alter table messages drop column messagetype;    
alter table messages add messagetype messageTypeType;

alter table event_ratings drop column visibility;    
alter table event_ratings add visibility visibilityType;

alter table appointments drop column rhythm;    
alter table appointments add rhythm rhythmType;

alter table userevents drop column relationtype;    
alter table userevents add relationtype relationTypeType;