Prize amount increased: Urgent - Stored procedures to create test data in database

I need to create random test data in database.

For the following tables, just create manually around 20-30 test records, with pertinent values (not really important, just to look ok - remember, it's test data) :

ReservationStatus

Facilities

RoomTypes

For the following tables you need to create a stored procedure, with naming convention and parameter as in rnd_GenerateApplications. They will receive a number and will generate that number of record in related table:

Cards

Guests

HostServers

HouseHolds

HouseholdGuests

KPILogging

Reservations

RoomAvailabilities

Users

For address fields, just select random address from Addresses

For names, just select random first / last from FirstNames, LastNames

For other names / strings, you can also select randoms an combine from first / last names or field values from Addreess (see rnd_SelectAddress)

The result database should have:

Test data (about 20-30 records each) in:

ReservationStatus

Facilities

RoomTypes

Stored procs:

rnd_GenerateCards

rnd_GenerateGuests

rnd_GenerateHostServers

rnd_GenerateHouseHolds

rnd_GenerateHouseholdGuests

rnd_GenerateKPILogging

rnd_GenerateReservations

rnd_GenerateRoomAvailabilities

rnd_GenerateUsers

Database backup can be downloaded from

[url removed, login to view]

I will prize the first participant that provides the db with stored procs an test data.

## Deliverables

* * *This broadcast message was sent to all bidders on Tuesday Mar 13, 2012 10:12:57 AM:

Hi, Please correct the link to download file (posted at the end of message) from [url removed, login to view] to [url removed, login to view] Thank you

* * *This broadcast message was sent to all bidders on Wednesday Mar 14, 2012 5:32:32 PM:

I will pay extra 15$ as bonus payment to contest winner. Good luck

* * *This broadcast message was sent to all bidders on Wednesday Mar 14, 2012 5:37:14 PM:

To all participants:

I included the promised bonus in contest prize, so it's official now - the current prize is 45$.

Thank you.

* * *This broadcast message was sent to all bidders on Friday Mar 16, 2012 7:48:38 AM:

I'm got not deliverable yet, so I' , still waiting for for another 24 hrs.

This should be an easy task, just a bunch of inserts.

I hope someone can really make it.

Thanks

MySQL SQL

Nº du projet : #2721201

À propos du projet