Convert/Update old MySQL to new MySQL. Map using MySQL Workshop.

Hi. I am an experienced .net developer and sysDBA. In you example we need only changes quotes and primary index definition: create table accounts ( id int primary key auto_increment, type enum ( 'daily', 'monthly', 'yearly' ) not null, billingStatus enum ( 'unpaid', 'paid', 'error' ) not null, creationDate dateTime not null, disciplineExpiration dateTime default '0000-00-00 00:00:00' not null, billingDate date not null, loginNameID int not null, password char(16) not null, rights enum ( 'normal', 'guide' ) not null, status enum ( 'normal', 'disabled' ) not null, productOrderID int not null, validationTime dateTime not null, unique loginNameIdx ( loginNameID ), key namePassIdx ( loginNameID, password ), key billingIdx ( billingDate ), key creationIdx ( creationDate ), key billingStatusIdx ( billingStatus ), key productOrderKey ( productOrderID ), key validationTimeKey ( validationTime ) ) How big code for you database?

hi, I have experience in sql, I can help you with this, tell me the more info about error.