Find Jobs
Hire Freelancers

Database updates, design review, table data initialization

$30-250 USD

进行中
已发布大约 12 年前

$30-250 USD

货到付款
Experienced PHP, MYSQL programmer/DBA. Need this done in a couple of days. MUST BE ABLE TO START IMMEDIATELY. MUST BE ABLE TO WORK WEEKENDS UNTIL WORK IS DONE. Competive will be given more consideration even if less experienced as this is not difficult work. WILL NOT PAY 100% milstone or get ripped off by ADVANCING MONEY until you demonstrate your expertise. NO EXCEPTIONS. UNTIL YOU DO SOME WORK TO DEMONSTRATE YOUR CAPABILITY AND EXPERTISE AND QUICK, RESPONSIVE WORK, NO MILESTONE WILL BE PAID OR PLACED IN ESCROW. Create a few new,small MY SQL tables (30 minutes) Update half dozen tables - add new fields (30 minutes) Update database creation SQL script including all static reference data lookup values data(30 minutes) Load a dozen tables with lookup reference data values (90 minutes) Check over current database design optimization/refractoring/redundant keys (60 minutes) Create a MY SQL schema diagram of the data (30 minutes) or Create an online schema diagram of the data (90 minutes) Our MYSQL Server is not using InnoDB engine. We would like to utilize the InnoDB database engine on out website. Changecurrent Product Table key from automatic sequence number to user specified unique primary key and related table column definition from Numeric to varchar or alpha/numeric. Datadase only has 65 tables. I don't know if MY SQL or PHPMyAdmin has the ability to ceate a visual schema diagram with an option to print or display on a HTML Page like the on you can find in MS SQL Management Studio 2008. If MY SQL can then we need to set it up. If MY SQL can't then we need to find and setup a web based schema universal database tool. An example of one is DBSchema at [login to view URL] "DbSchema is an integrated universal database tool, featuring graphical layouts, Relational Data Browser, Query Builder, SQL Editor, schema deployment and synchronization and many more. Using DbSchema you may increase the productivity of the database work and the quality of the schema design. DbSchema includes modules which are covering the complete area of the database work , from schema design, exploring the data, SQL, deploy of schema over multiple databases, teamwork, backup the schema and data, etc."
项目 ID: 1455654

关于此项目

5提案
远程项目
活跃12 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作

关于客户

UNITED STATES的国旗
Lacombe, United States
4.8
44
付款方式已验证
会员自11月 24, 2011起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。