1.? Modify MySQL DB (Win 2003 server) to change the structure of the database, and migrate all data in DB to the new structure.
2.? Convert existing perl scripts to PHP.? The perl scripts currently download data, parse it and input the data into the MySQL DB.
## Deliverables
The? tasks are:
1.? Create a new MySQL DB with the following structure.? Can be modified if you think there is a better way...
Table = storm_data
Storm name (text)
Storm id (number and text...? AL022008)
Advisory Record number (primary key and indexed)
Advisory number (22, or 22A)
Agency (NHC, JTWC etc….)
Advisory date/time (date/time)
Category (text 2 char....? H2, H5 etc..)
Eye diameter (integer... max 2 digits)
Pressure (integer ... max 5 digits)
Direction (integer ... max 3 digits)
Speed (integer ... max 2 digits)
FA text (blob)
PA text (blob)
CD text (blob)
WW text (blob) (coastal watch warning data)
Table = storm_positions
Advisory record number (relates back to storm_data table) (foreign key and indexed)????
Position Date/Time (date/time)
Forecast hour (00, 12, 24 etc…)
Lat (real ... 24.3, -24.3 etc...)
Lon (real ... 128.5, -128.5)
Wind (integer ... max 3 digits)
Gust (integer ... max 3 digits)
12ft seas NE (integer ... max 3 digits)..Null if no value for all below
12ft seas SE (integer ... max 3 digits)
12ft seas SW (integer ... max 3 digits)
12ft seas NW (integer ... max 3 digits)
34kt Radius NE (integer ... max 3 digits)
34kt Radius SE (integer ... max 3 digits)
34kt Radius SW (integer ... max 3 digits)
34kt Radius NW (integer ... max 3 digits)
50kt Radius NE (integer ... max 3 digits)
50kt Radius SE (integer ... max 3 digits)
50kt Radius SW (integer ... max 3 digits)
50kt Radius NW (integer ... max 3 digits)
64kt Radius NE (integer ... max 3 digits)
64kt Radius SE (integer ... max 3 digits)
64kt Radius SW (integer ... max 3 digits)
64kt Radius NW (integer ... max 3 digits)
Task #2.
Modify the existing Perl scripts to use PHP and work with the new database structure.? Some background info on the scripts...
By design, the set of scripts should download data from 2 locations. (National Hurricane Center (NHC) and the Joint Typhoon Warning Center (JTWC)? ).? After downloading the data, another script will process the data and send it to parsers that extract the needed info to be databased.
Task #3
Modify the PHP scripts? to work with new DB structure
Taks #4
Export existing data in database to new database.
See attached file for existing scripts that need to be converted to PHP and modified to new DB Structure.? DB schema included.
Please let me know if you have any questions.
Thanks!
Bryan