MS-SQL work, 1 module to create and a couple to edit

Summary

The site is for an existing job vacancy company that connects business with those seeking employment. They all ready have some software that runs on their computers, but they now want something web based where people can register and add vacancies as well as apply for jobs.

We are handling the theme design, and various other parts but the following things are still needed:

1. MS-SQL Support

The hard work has already been done - http://groups.drupal.org/node/1953 - but the views and faceted search modules need copying across.

2. Users Module Modification

There is another table with the module must use, with different column names but the same content, baring IsAdmin which must be set as 1 if the user role is "Admin" and vica versa. Registration must be on two pages; one for employers and one for job seekers (perhaps modify http://drupal.org/project/registration_role ).

3. Ability to add companies

They still use the user module, just with a different role. They must, however, use an existing table containing
columns such as userid, company name, contact details, created by and when, updated by and when, active/inactive, perhaps by modification of a profile module?

4. New Module Content Type - Advert

The current database contains a few tables requesting employment details (e.g. salary, benefits..), and how much it cost to place and for how long. Must be sortable with faceted search and views.