I require a MySQL database to be filled with data from [url removed, login to view], and will be required to update the data with the Winter 2014 timetable in a couple of weeks (should be found here in a week or so: [url removed, login to view]).
I am offering £[url removed, login to view] for each timetable for a total of £25, to be carried out over a few weeks. Partial payment of £[url removed, login to view] will be awarded once I have received the database for the Summer 2014 timetable.
The other £[url removed, login to view] payment will be made when the database for the Winter 2014 timetable is completed; I will notify the project winner when the Winter 2014 timetable becomes available as I will require work to start immediately.
The database structure is simple, and the project winner is strongly advised to use MySQL Workbench unless they have a better method of adding the required data.
I have completed the first three rows of the 'bus11' timetable, with the structure as shown here: [url removed, login to view]
The 'then at these mins past each hour' columns should be completed in a '-:[MINUTE]' format, while the others should be entered normally.
The columns 'weekdays', 'saturdays', 'sundays', 'bankholidays', 'schooldays', and 'nightbus' should be left blank as I will update these myself.
Each route should have a different table, with the format 'bus[route number]', following the same format as the 'bus11' table.