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

$10-30 USD

Awarded

Posted

about 8 years ago

$10-30 USD

Paid on delivery

I have some old MySQL code that needs to be updated to the newest format without losing functionality. This might be some trial and error, but all original code is available and untouched. No more than an hour or two of work.

MySQL

SQL

Project ID: 9615249

About the project

4 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average $28 USD for this job

@drobyshev

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?

$25 USD in 1 day