Create MYSQL Create queries from source code that has INSERT/UPDATE/DELETE/ETC
$10-15 USD
処理中
投稿日: 14年以上前
$10-15 USD
完了時にお支払い
I have lost my MYSQL install/create file to create all the database tables that are needed... Basicly, I have two files with about 200-300 MYSQL queries that have INSERT/UPDATE/DELETE/SELECT.. Alot are the same, but basically what I want you to do is get all the table values for each table found and make MYSQL create queries for me. [login to view URL]( "INSERT INTO widgets(server_id,data,received_date) VALUES(%u,'%s', unix_timestamp())", In this example, the table is WIDGETS, and the table values are server_id,data, and received_data.. there may be another queries with: [login to view URL]( "INSERT INTO widgets(server_id,data,received_date,final_data) VALUES(%u,'%s', unix_timestamp(),fdata)", Which means final_data will have to be added to that top query, you get me? Basicly find all the queries that are used, use the table names that are found, and find all the values used for each table, and give me MYSQL create functions. Try to aim for if its TEXT/INTEGER/ETC ... for unix_timestamp, use TEXT. So for the above example might be something like "CREATE TABLE widgets server_id INT, data TEXT, recieved_date TEXT, final_data TEXT)" ^^ Or however it is used to create! Depending on if thats all there is (you might find more fields for widgets in other areas, but there are only TWO files to look in.) For auto_increment, or keys, do not spend to much time on this unless you know. I will tell you however server_id for example IS auto_increment. but thats normally the case for IDS. Overall this is a very SMALL job. Thanks!
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
MYSQL, Windows