--
-- Host: localhost    Database: ray
---------------------------------------------------------

--
-- Table structure for table `BIOLIFE`
--

CREATE TABLE BIOLIFE (
  Species_No int(11) NOT NULL PRIMARY KEY,
  Category varchar(30) default NULL,
  Common_Name varchar(40) default NULL,
  Species_Name varchar(80) default NULL,
  Length_cm decimal(8,2) default NULL,
  Length_in decimal(8,2) default NULL,
  Notes blob,
  Graphic_id varchar(20) default NULL,
  Graphic_file varchar(20) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `BIOLIFE`
--


INSERT INTO BIOLIFE VALUES (90020,'Triggerfish','Clown Triggerfish','Ballistoides conspicillum',50.00,19.68,'Also known as the big spotted triggerfish.  Inhabits outer reef areas and feeds upon crustaceans and mollusks by crushing them with powerful teeth.  They are voracious eaters, and divers report seeing the clown triggerfish devour beds of pearl oysters.<P> Do not eat this fish.  According to an 1878 account, \"the poisonous flesh acts primarily upon the nervous tissue of the stomach, occasioning violent spasms of that organ, and shortly afterwards all the muscles of the body.  The frame becomes rocked with spasms, the tongue thickened, the eye fixed, the breathing laborious, and the patient expires in a paroxysm of extreme suffering.\"<P> Not edible.<P> Range is Indo-Pacific and East Africa to Somoa.','','1.GIF');
INSERT INTO BIOLIFE VALUES (90030,'Snapper','Red Emperor','Lutjanus sebae',60.00,23.62,'Called seaperch in Australia.  Inhabits the areas around lagoon coral reefs and sandy bottoms.<P> The red emperor is a valuable food fish and considered a great sporting fish that fights with fury when hooked.  The flesh of an old fish is just as tender to eat as that of the very young.<P> Range is from the Indo-Pacific to East Africa.','','2.GIF');
INSERT INTO BIOLIFE VALUES (90050,'Wrasse','Giant Maori Wrasse','Cheilinus undulatus',229.00,90.15,'This is the largest of all the wrasse.  It is found in dense reef areas, feeding on a wide variety of mollusks, fishes, sea urchins, crustaceans, and other invertebrates. In spite of its immense size, divers find it a very wary fish.<P> Edibility is considered poor.<P> Range is the Indo-Pacific and the Red Sea.','','3.GIF');
INSERT INTO BIOLIFE VALUES (90070,'Angelfish','Blue Angelfish','Pomacanthus nauarchus',30.00,11.81,'Habitat is around boulders, caves, coral ledges and crevices in shallow waters.  Swims alone or in groups.<P> Its color changes dramatically from juvenile to adult.  The mature adult fish can startle divers by producing a powerful drumming or thumping sound intended to warn off predators.<P> Edibility is good.<P> Range is the entire Indo-Pacific region.','','5.GIF');
INSERT INTO BIOLIFE VALUES (90080,'Cod','Lunartail Rockcod','Variola louti',80.00,31.49,'Also known as the coronation trout.  It is found around coral reefs from shallow to very deep waters.  Feeds primarily on small fishes.<P> Although this rockcod is considered a good game and food fish, the large ones may contain a toxin and should not be eaten.  There is no way to discern whether the fish contains toxin.<P> Range is the Indo-Pacific and the Red Sea.','','5.GIF');
INSERT INTO BIOLIFE VALUES (90090,'Scorpionfish','Firefish','Pterois volitans',38.00,14.96,'Also known as the turkeyfish.  Inhabits reef caves and crevices.  The firefish is usually stationary during the day, but feeds actively at night.  Favorite foods are crustaceans.<P> The dorsal spines of the firefish are needle-like and contain venom.  They can inflict an extremely painful wound.<P> Edibility is poor.<P> Range is from Western Australia to Malaysia.','','6.GIF');
INSERT INTO BIOLIFE VALUES (90100,'Butterflyfish','Ornate Butterflyfish','Chaetodon Ornatissimus',19.00,7.48,'Normally seen in pairs around dense coral areas from very shallow to moderate depths.  The butterflyfish feeds mainly on coral polyps and anemones.<P> Edibility is poor.<P> Range is Indo-Pacific from Sri Lanka to Polynesia.','','7.GIF');
INSERT INTO BIOLIFE VALUES (90110,'Shark','Swell Shark','Cephaloscyllium ventriosum',102.00,40.15,'Inhabits shallow reef caves and crevices and kelp beds along the coast and offshore islands.  This shark feeds at night on fishes and crustaceans and is totally harmless to divers.<P> For defense, the swell shark inflates its stomach with water to tightly lodge itself in a reef crevice.  <P> Edibility is poor.<P> Range is from Monterey Bay to Acapulco.  Also found in Chile.','','8.GIF');
INSERT INTO BIOLIFE VALUES (90120,'Ray','Bat Ray','Myliobatis californica',56.00,22.04,'Also know as the grinder ray because of its flat grinding teeth used to crush its meal of crustaceans or invertebrates.  Inhabits bays, sloughs, and kelp beds with sandy bottoms.<P> The bat ray digs up food with its wings and snout, and will even bite off overhanging ledges to get at prey.  It hunts singly or in groups.  When resting, it buries itself in sand with just the eyes protruding.<P> Edibility is poor.<P> Range is from Oregon to the Gulf of California.','','9.GIF');
INSERT INTO BIOLIFE VALUES (90130,'Eel','California Moray','Gymnothorax mordax',150.00,59.05,'This fish hides in a shallow-water lair with just its head protruding during the day.  At night it feeds on octopuses, crustaceans, and small fish close by.<P> If caught, it will bite anything nearby with its large fang-like teeth.  Divers can be bitten by a moray eel when sticking their hands into crevices or holes in search of lobster or abalone.<P> Edibility is good.<P> Range is from Southern California to Southern Baja.','','10.GIF');
INSERT INTO BIOLIFE VALUES (90140,'Cod','Lingcod','Ophiodon elongatus',150.00,59.05,'Widely found from near the shore to very deep waters.  Young fish stay on sand or mud bottoms of bays and inshore areas.  The lingcod is a voracious predator, eating many different fishes and octopuses.<P> This fish changes color when stressed.  The flesh color also changes, from a greenish hue when caught to white when cooked.<P> Edibility is good; Lingcod is a popular sport and commercial fish.<P> Range is Alaska to Northern Baja California.','','11.GIF');
INSERT INTO BIOLIFE VALUES (90150,'Sculpin','Cabezon','Scorpaenichthys marmoratus',99.00,38.97,'Often called the great marbled sculpin.  Found over rocky or shell-encrusted bottoms from shallow to moderately deep waters.  It feeds primarily on crustaceans and mollusks.<P> The male cabezon will not budge while guarding its nest and can even be touched by divers.<P> Edibility is good; the flesh is bluish-green but turns white when cooked.  The eggs of the cabezon are poisonous.<P> Range is from Alaska to Central Baja.','','12.GIF');
INSERT INTO BIOLIFE VALUES (90160,'Spadefish','Atlantic Spadefish','Chaetodiperus faber',90.00,35.43,'Found in mid-water areas around reefs, wrecks and bridges.  The tiny, all-black juveniles drift motionless in the shallows, looking like leaves and pods of mangrove.<P> Edibility is good.<P> Range is Bermuda, New England to Brazil, and the Gulf of Mexico.','','13.GIF');
INSERT INTO BIOLIFE VALUES (90170,'Shark','Nurse Shark','Ginglymostoma cirratum',400.00,157.48,'Frequently found under rock or reef ledges.  Carnivorous with well-developed organs for scent and vibration detection.<P> Like all sharks, the nurse shark has a skeleton of cartilage rather than bone.  Instead of scales, its body is covered with tiny razor-sharp denticles.  The teeth are specialized forms of denticles.  Sharks must continually swim or will slowly sink because they have no air bladder.<P> Edibility is poor.<P> Range is from Rhode Island to Brazil, including the Gulf of Mexico.','','14.GIF');
INSERT INTO BIOLIFE VALUES (90180,'Ray','Spotted Eagle Ray','Aetobatus narinari',200.00,78.74,'Found in reef areas and sandy bottoms.  The spotted eagle ray has a poisonous spine on its tail and incredibly powerful jaws to crush oysters, clams, and numerous crustaceans.  Divers report large schools during breeding season.<P> This ray is an active swimmer and often leaps into the air.  The slapping sound it makes on the water is thought to mark a territory.<P> Edibility is poor.<P> Range is throughout the tropics.','','15.GIF');
INSERT INTO BIOLIFE VALUES (90190,'Snapper','Yellowtail Snapper','Ocyurus chrysurus',75.00,29.52,'Prefers to congregate in loose groups in the open water above reef areas.  Has well-developed teeth and usually feeds at night on small fishes, crustaceans, and plankton.<P> The yellowtail snapper repeatedly snaps its jaws after it has been caught.  Divers have been injured by these fish.<P> This is an excellent game fish with tenacious fighting ability and tasty flesh.<P> Range is Bermuda, New England to Brazil, and the Gulf of Mexico.','','16.GIF');
INSERT INTO BIOLIFE VALUES (90200,'Parrotfish','Redband Parrotfish','Sparisoma Aurofrenatum',28.00,11.02,'Inhabits reef areas.  The parrotfish\'s teeth are fused together, enabling them to scrape away hard coral outer skeletons to get at polyps inside.  These fish are thought to be a major factor in reef recycling.<P> Occasionally a female will change sex, increase in size, and take on a distinct appearance  as a terminal-phase male.  This is usually done to replace a missing male.<P> Edibility is poor. <P> Range is Bermuda and Florida to Brazil.','','17.GIF');
INSERT INTO BIOLIFE VALUES (90210,'Barracuda','Great Barracuda','Sphyraena barracuda',150.00,59.05,'Young barracuda live in inshore seagrass beds, while adults range from inshore channels to the open ocean.  The barracuda feeds on a wide variety of fishes.<P> It frequently drifts just below the surface and is known to approach divers at very close range.  The long underslung jaw with its very sharp teeth can be disconcerting.  Attacks on humans have reportedly been in cloudy water when the victim is wearing bright diving gear or attempting to spear the fish.<P> Edibility is good for small specimens, but  large barracuda can carry a fatal toxin.  There is no visible way to tell if the fish is harmful to eat.<P> Range is worldwide.','','18.GIF');
INSERT INTO BIOLIFE VALUES (90220,'Grunt','French Grunt','Haemulon flavolineatum',30.00,11.81,'The French grunt drifts in large groups in sheltered reef areas during the day.  It forages nearby for other fish at night.<P> The fish produces a grunt-like sound by grinding teeth located in the throat.  The sound is amplified by the adjacent swim bladder.  During territorial skirmishes, male grunts will face and push each other with open mouths.<P> Edibility is excellent.<P> Range is Bermuda, South Carolina to Brazil, and the Gulf of Mexico.','','19.GIF');
INSERT INTO BIOLIFE VALUES (90230,'Snapper','Dog Snapper','Lutjanus jocu',90.00,35.43,'This fish is named for its elongated canine teeth at the front of the upper jaw.  It is solitary and wary and stays in the deep reef or submerged wreck areas.  Not very common anywhere.<P> Edibility is good if the fish is small.  However, a large dog snapper may contain a fatal toxin.  These fish repeatedly snap their jaws shut after removal from a hook or net.<P> Range is New England to Brazil and the Gulf of Mexico.','','20.GIF');
INSERT INTO BIOLIFE VALUES (90240,'Grouper','Nassau Grouper','Epinephelus striatus',91.00,35.82,'Found around shallow coral reefs and seagrass beds, feeding mainly on fishes.<P> This is the most friendly of all groupers.  If offered food, it will return again and again, looking for more. <P> As a defense, the Nassau grouper can change colors to blend perfectly into any background, from white to solid black.<P> Range is Bermuda, North Carolina to Brazil, and the Gulf of Mexico.','','dummy.GIF');
INSERT INTO BIOLIFE VALUES (90250,'Wrasse','Bluehead Wrasse','Thalassoma bifasciatum',15.00,5.90,'Found in coral reefs, rocky flats, reef sand, and seagrass habitats.  This is one of the most successful \"cleaner fish\" in the tropical West Atlantic.  It feeds on the parasites of other fish, who come to the wrasse to be cleaned.<P> Most bluehead wrasses are yellow.  The head of the terminal-phase male (about 4% of the population) is blue.<P> Edibility is poor.<P> Range is large, including both sides of the Atlantic, Bermuda, Bahamas, and Florida to Curacao, plus the Gulf of Mexico.','','dummy.GIF');
INSERT INTO BIOLIFE VALUES (90260,'Jack','Yellow Jack','Gnathanodon speciousus',90.00,35.43,'Inhabits reef and mid-water areas, feeding on invertebrates and small fishes.  The adult is one of the few jacks without teeth.<P> The young fish seek out larger predators, such as sharks, for protection.  Divers have reported young jacks wanting to join up with them!<P> Edibility is excellent.<P> Range is Indo-Pacific and Southern California to Panama.','','dummy.GIF');
INSERT INTO BIOLIFE VALUES (90270,'Surfperch','Redtail Surfperch','Amphistichus rhodoterus',40.00,15.74,'Inhabits exposed sandy shorelines to shallow depths.  Feeds on sand-dwelling crustaceans and mollusks.<P> While almost all other marine fishes fertilize and scatter large numbers of eggs outside the body, the surfperch nourishes offspring inside the ovary and spawns them live and sexually active into the surf.<P> A favorite sport fish for surf anglers.  Edibility is very good.<P> Range is from Vancouver Island to Central California.','','dummy.GIF');
INSERT INTO BIOLIFE VALUES (90280,'Croaker','White Sea Bass','Atractoscion nobilis',150.00,59.05,'Schools are found over rocky bottoms and around kelp forest canopies.  Not a true bass, this is the largest of the croakers on the Pacific Coast.  It feeds in mid-water on squid, anchovies, and sardines.  <P> Croakers make a remarkable \"boop-boop-boop\" sound, and submarine commanders discovered they could hide the sound of their engines behind the racket.  <P> The large calcareous \"earstones\" in this fish\'s inner ear canals were considered good luck charms by early Europeans and were used by American Indians in jewelry.<P> Excellent edibility if you can find one.  White sea bass were heavily fished in the 1950s but are now rarely caught.<P> Range is from Alaska to Southern Baja.','','25.GIF');
INSERT INTO BIOLIFE VALUES (90290,'Greenling','Rock Greenling','Hexagrammos lagocephalus',60.00,23.62,'Inhabits rocky areas along shallow exposed coast line.<P> Greenlings can change their color to blend with the surrounding sunlit rock and seaweed.  Their scales are very rough and give the body a sandpaper-like texture.<P> An 1886 description of a greenling comes from naturalist J.K. Lord.  He was overcome by its beauty, and said \"its sides...rival in beauty many a tropical flower...[and are] adorned with colors not only conspicuous for their brilliancy, but grouped and blended in a manner one sees only represented in the plumage of a bird, the wing of a butterfly, or the petals of an orchid...red, blue, orange, and green are so mingled that the only thing I can think of as a comparison is a floating flower bed, and even the gardener\'s art, in grouping, is but a bungle contrasted with nature\'s painting.\"<P> Edibility is good.<P> Range is from the Bering Sea to Southern California.','','26.GIF');
INSERT INTO BIOLIFE VALUES (90300,'Wrasse','Senorita','Oxyjulis californica',25.00,9.84,'Found almost everywhere by divers, this fish lives either in schools or alone.  It is a voracious eater that feeds constantly.  It is also a very successful \"cleaner fish\", and a single Senorita may be surrounded by dozens of fishes waiting to be cleaned of parasites.  Divers report them teaming up to clean a large sea bass or Mola.<P> This fish does not reverse sex as most wrasses do.  When disturbed, it burrows in the bottom sediment.  It also sleeps there with its head protruding from the sand.<P> Edibility is poor.<P> Range is Northern California to Central Baja.','','27.GIF');
INSERT INTO BIOLIFE VALUES (90310,'Smelt','Surf Smelt','Hypomesus pretiosus',25.00,9.84,'Also called the day smelt because of the timing of its spawning runs.  Inhabits the surf line, feeding on small fishes and invertebrates.  <P> Surf smelt ride a wave onto the beach, lay and fertilize their eggs, and catch a return wave to the sea.  The fry hatch approximately two weeks later during high tide. <P> This fish is a favorite among surf anglers.  Edibility is good.<P> Range is from Alaska to Southern California.','','28.GIF');

--
-- Table structure for table `BIOSITE`
--

CREATE TABLE BIOSITE (
  Species_No int(11) NOT NULL,
  Site_No int(11) NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `BIOSITE`
--


INSERT INTO BIOSITE VALUES (90020,2001);
INSERT INTO BIOSITE VALUES (90020,2002);
INSERT INTO BIOSITE VALUES (90020,2003);
INSERT INTO BIOSITE VALUES (90020,2004);
INSERT INTO BIOSITE VALUES (90020,2005);
INSERT INTO BIOSITE VALUES (90020,6001);
INSERT INTO BIOSITE VALUES (90020,6003);
INSERT INTO BIOSITE VALUES (90020,6004);
INSERT INTO BIOSITE VALUES (90020,6005);
INSERT INTO BIOSITE VALUES (90030,2001);
INSERT INTO BIOSITE VALUES (90030,2002);
INSERT INTO BIOSITE VALUES (90030,2003);
INSERT INTO BIOSITE VALUES (90030,2004);
INSERT INTO BIOSITE VALUES (90030,2005);
INSERT INTO BIOSITE VALUES (90030,6001);
INSERT INTO BIOSITE VALUES (90030,6003);
INSERT INTO BIOSITE VALUES (90030,6004);
INSERT INTO BIOSITE VALUES (90030,6005);
INSERT INTO BIOSITE VALUES (90050,2001);
INSERT INTO BIOSITE VALUES (90050,2002);
INSERT INTO BIOSITE VALUES (90050,2003);
INSERT INTO BIOSITE VALUES (90050,2004);
INSERT INTO BIOSITE VALUES (90050,2005);
INSERT INTO BIOSITE VALUES (90050,6001);
INSERT INTO BIOSITE VALUES (90050,6003);
INSERT INTO BIOSITE VALUES (90050,6004);
INSERT INTO BIOSITE VALUES (90050,6005);
INSERT INTO BIOSITE VALUES (90070,2001);
INSERT INTO BIOSITE VALUES (90070,2002);
INSERT INTO BIOSITE VALUES (90070,2003);
INSERT INTO BIOSITE VALUES (90070,2004);
INSERT INTO BIOSITE VALUES (90070,2005);
INSERT INTO BIOSITE VALUES (90070,6001);
INSERT INTO BIOSITE VALUES (90070,6003);
INSERT INTO BIOSITE VALUES (90070,6004);
INSERT INTO BIOSITE VALUES (90070,6005);
INSERT INTO BIOSITE VALUES (90080,2001);
INSERT INTO BIOSITE VALUES (90080,2002);
INSERT INTO BIOSITE VALUES (90080,2003);
INSERT INTO BIOSITE VALUES (90080,2004);
INSERT INTO BIOSITE VALUES (90080,2005);
INSERT INTO BIOSITE VALUES (90080,6001);
INSERT INTO BIOSITE VALUES (90080,6003);
INSERT INTO BIOSITE VALUES (90080,6004);
INSERT INTO BIOSITE VALUES (90080,6005);
INSERT INTO BIOSITE VALUES (90090,2001);
INSERT INTO BIOSITE VALUES (90090,2002);
INSERT INTO BIOSITE VALUES (90090,2003);
INSERT INTO BIOSITE VALUES (90090,2004);
INSERT INTO BIOSITE VALUES (90090,2005);
INSERT INTO BIOSITE VALUES (90090,6001);
INSERT INTO BIOSITE VALUES (90090,6003);
INSERT INTO BIOSITE VALUES (90090,6004);
INSERT INTO BIOSITE VALUES (90090,6005);
INSERT INTO BIOSITE VALUES (90100,2001);
INSERT INTO BIOSITE VALUES (90100,2002);
INSERT INTO BIOSITE VALUES (90100,2003);
INSERT INTO BIOSITE VALUES (90100,2004);
INSERT INTO BIOSITE VALUES (90100,2005);
INSERT INTO BIOSITE VALUES (90100,6001);
INSERT INTO BIOSITE VALUES (90100,6003);
INSERT INTO BIOSITE VALUES (90100,6004);
INSERT INTO BIOSITE VALUES (90100,6005);
INSERT INTO BIOSITE VALUES (90110,3001);
INSERT INTO BIOSITE VALUES (90110,3002);
INSERT INTO BIOSITE VALUES (90110,3003);
INSERT INTO BIOSITE VALUES (90110,3004);
INSERT INTO BIOSITE VALUES (90110,3006);
INSERT INTO BIOSITE VALUES (90110,4001);
INSERT INTO BIOSITE VALUES (90110,4002);
INSERT INTO BIOSITE VALUES (90110,4003);
INSERT INTO BIOSITE VALUES (90110,4004);
INSERT INTO BIOSITE VALUES (90110,4005);
INSERT INTO BIOSITE VALUES (90110,4006);
INSERT INTO BIOSITE VALUES (90110,4007);
INSERT INTO BIOSITE VALUES (90110,4008);
INSERT INTO BIOSITE VALUES (90120,3001);
INSERT INTO BIOSITE VALUES (90120,3002);
INSERT INTO BIOSITE VALUES (90120,3003);
INSERT INTO BIOSITE VALUES (90120,3004);
INSERT INTO BIOSITE VALUES (90120,3006);
INSERT INTO BIOSITE VALUES (90120,4001);
INSERT INTO BIOSITE VALUES (90120,4002);
INSERT INTO BIOSITE VALUES (90120,4003);
INSERT INTO BIOSITE VALUES (90120,4004);
INSERT INTO BIOSITE VALUES (90120,4005);
INSERT INTO BIOSITE VALUES (90120,4006);
INSERT INTO BIOSITE VALUES (90120,4007);
INSERT INTO BIOSITE VALUES (90120,4008);
INSERT INTO BIOSITE VALUES (90130,3001);
INSERT INTO BIOSITE VALUES (90130,3002);
INSERT INTO BIOSITE VALUES (90130,3003);
INSERT INTO BIOSITE VALUES (90130,3004);
INSERT INTO BIOSITE VALUES (90130,3006);
INSERT INTO BIOSITE VALUES (90130,4001);
INSERT INTO BIOSITE VALUES (90130,4002);
INSERT INTO BIOSITE VALUES (90130,4003);
INSERT INTO BIOSITE VALUES (90130,4004);
INSERT INTO BIOSITE VALUES (90130,4005);
INSERT INTO BIOSITE VALUES (90130,4006);
INSERT INTO BIOSITE VALUES (90130,4007);
INSERT INTO BIOSITE VALUES (90130,4008);
INSERT INTO BIOSITE VALUES (90140,3001);
INSERT INTO BIOSITE VALUES (90140,3002);
INSERT INTO BIOSITE VALUES (90140,3003);
INSERT INTO BIOSITE VALUES (90140,3004);
INSERT INTO BIOSITE VALUES (90140,3006);
INSERT INTO BIOSITE VALUES (90140,4001);
INSERT INTO BIOSITE VALUES (90140,4002);
INSERT INTO BIOSITE VALUES (90140,4003);
INSERT INTO BIOSITE VALUES (90140,4004);
INSERT INTO BIOSITE VALUES (90140,4005);
INSERT INTO BIOSITE VALUES (90140,4006);
INSERT INTO BIOSITE VALUES (90140,4007);
INSERT INTO BIOSITE VALUES (90140,4008);
INSERT INTO BIOSITE VALUES (90150,3001);
INSERT INTO BIOSITE VALUES (90150,3002);
INSERT INTO BIOSITE VALUES (90150,3003);
INSERT INTO BIOSITE VALUES (90150,3004);
INSERT INTO BIOSITE VALUES (90150,3006);
INSERT INTO BIOSITE VALUES (90150,4001);
INSERT INTO BIOSITE VALUES (90150,4002);
INSERT INTO BIOSITE VALUES (90150,4003);
INSERT INTO BIOSITE VALUES (90150,4004);
INSERT INTO BIOSITE VALUES (90150,4005);
INSERT INTO BIOSITE VALUES (90150,4006);
INSERT INTO BIOSITE VALUES (90150,4007);
INSERT INTO BIOSITE VALUES (90150,4008);
INSERT INTO BIOSITE VALUES (90160,5001);
INSERT INTO BIOSITE VALUES (90160,5002);
INSERT INTO BIOSITE VALUES (90160,5003);
INSERT INTO BIOSITE VALUES (90160,5004);
INSERT INTO BIOSITE VALUES (90160,5005);
INSERT INTO BIOSITE VALUES (90160,5006);
INSERT INTO BIOSITE VALUES (90160,7001);
INSERT INTO BIOSITE VALUES (90160,7002);
INSERT INTO BIOSITE VALUES (90160,7003);
INSERT INTO BIOSITE VALUES (90160,7004);
INSERT INTO BIOSITE VALUES (90160,7005);
INSERT INTO BIOSITE VALUES (90160,7006);
INSERT INTO BIOSITE VALUES (90160,7007);
INSERT INTO BIOSITE VALUES (90160,7008);
INSERT INTO BIOSITE VALUES (90170,5001);
INSERT INTO BIOSITE VALUES (90170,5002);
INSERT INTO BIOSITE VALUES (90170,5003);
INSERT INTO BIOSITE VALUES (90170,5004);
INSERT INTO BIOSITE VALUES (90170,5005);
INSERT INTO BIOSITE VALUES (90170,5006);
INSERT INTO BIOSITE VALUES (90170,7001);
INSERT INTO BIOSITE VALUES (90170,7002);
INSERT INTO BIOSITE VALUES (90170,7003);
INSERT INTO BIOSITE VALUES (90170,7004);
INSERT INTO BIOSITE VALUES (90170,7005);
INSERT INTO BIOSITE VALUES (90170,7006);
INSERT INTO BIOSITE VALUES (90170,7007);
INSERT INTO BIOSITE VALUES (90170,7008);
INSERT INTO BIOSITE VALUES (90180,5001);
INSERT INTO BIOSITE VALUES (90180,5002);
INSERT INTO BIOSITE VALUES (90180,5003);
INSERT INTO BIOSITE VALUES (90180,5004);
INSERT INTO BIOSITE VALUES (90180,5005);
INSERT INTO BIOSITE VALUES (90180,5006);
INSERT INTO BIOSITE VALUES (90180,7001);
INSERT INTO BIOSITE VALUES (90180,7002);
INSERT INTO BIOSITE VALUES (90180,7003);
INSERT INTO BIOSITE VALUES (90180,7004);
INSERT INTO BIOSITE VALUES (90180,7005);
INSERT INTO BIOSITE VALUES (90180,7006);
INSERT INTO BIOSITE VALUES (90180,7007);
INSERT INTO BIOSITE VALUES (90180,7008);
INSERT INTO BIOSITE VALUES (90190,1001);
INSERT INTO BIOSITE VALUES (90190,1002);
INSERT INTO BIOSITE VALUES (90190,1003);
INSERT INTO BIOSITE VALUES (90190,1004);
INSERT INTO BIOSITE VALUES (90190,1005);
INSERT INTO BIOSITE VALUES (90190,5001);
INSERT INTO BIOSITE VALUES (90190,5002);
INSERT INTO BIOSITE VALUES (90190,5003);
INSERT INTO BIOSITE VALUES (90190,5004);
INSERT INTO BIOSITE VALUES (90190,5005);
INSERT INTO BIOSITE VALUES (90190,5006);
INSERT INTO BIOSITE VALUES (90200,1001);
INSERT INTO BIOSITE VALUES (90200,1002);
INSERT INTO BIOSITE VALUES (90200,1003);
INSERT INTO BIOSITE VALUES (90200,1004);
INSERT INTO BIOSITE VALUES (90200,1005);
INSERT INTO BIOSITE VALUES (90200,5001);
INSERT INTO BIOSITE VALUES (90200,5002);
INSERT INTO BIOSITE VALUES (90200,5003);
INSERT INTO BIOSITE VALUES (90200,5004);
INSERT INTO BIOSITE VALUES (90200,5005);
INSERT INTO BIOSITE VALUES (90200,5006);
INSERT INTO BIOSITE VALUES (90210,1001);
INSERT INTO BIOSITE VALUES (90210,1002);
INSERT INTO BIOSITE VALUES (90210,1003);
INSERT INTO BIOSITE VALUES (90210,1004);
INSERT INTO BIOSITE VALUES (90210,1005);
INSERT INTO BIOSITE VALUES (90210,5001);
INSERT INTO BIOSITE VALUES (90210,5002);
INSERT INTO BIOSITE VALUES (90210,5003);
INSERT INTO BIOSITE VALUES (90210,5004);
INSERT INTO BIOSITE VALUES (90210,5005);
INSERT INTO BIOSITE VALUES (90210,5006);
INSERT INTO BIOSITE VALUES (90220,1001);
INSERT INTO BIOSITE VALUES (90220,1002);
INSERT INTO BIOSITE VALUES (90220,1003);
INSERT INTO BIOSITE VALUES (90220,1004);
INSERT INTO BIOSITE VALUES (90220,1005);
INSERT INTO BIOSITE VALUES (90220,5001);
INSERT INTO BIOSITE VALUES (90220,5002);
INSERT INTO BIOSITE VALUES (90220,5003);
INSERT INTO BIOSITE VALUES (90220,5004);
INSERT INTO BIOSITE VALUES (90220,5005);
INSERT INTO BIOSITE VALUES (90220,5006);
INSERT INTO BIOSITE VALUES (90230,1001);
INSERT INTO BIOSITE VALUES (90230,1002);
INSERT INTO BIOSITE VALUES (90230,1003);
INSERT INTO BIOSITE VALUES (90230,1004);
INSERT INTO BIOSITE VALUES (90230,1005);
INSERT INTO BIOSITE VALUES (90230,5001);
INSERT INTO BIOSITE VALUES (90230,5002);
INSERT INTO BIOSITE VALUES (90230,5003);
INSERT INTO BIOSITE VALUES (90230,5004);
INSERT INTO BIOSITE VALUES (90230,5005);
INSERT INTO BIOSITE VALUES (90230,5006);
INSERT INTO BIOSITE VALUES (90240,1001);
INSERT INTO BIOSITE VALUES (90240,1002);
INSERT INTO BIOSITE VALUES (90240,1003);
INSERT INTO BIOSITE VALUES (90240,1004);
INSERT INTO BIOSITE VALUES (90240,1005);
INSERT INTO BIOSITE VALUES (90240,5001);
INSERT INTO BIOSITE VALUES (90240,5002);
INSERT INTO BIOSITE VALUES (90240,5003);
INSERT INTO BIOSITE VALUES (90240,5004);
INSERT INTO BIOSITE VALUES (90240,5005);
INSERT INTO BIOSITE VALUES (90240,5006);
INSERT INTO BIOSITE VALUES (90250,1001);
INSERT INTO BIOSITE VALUES (90250,1002);
INSERT INTO BIOSITE VALUES (90250,1003);
INSERT INTO BIOSITE VALUES (90250,1004);
INSERT INTO BIOSITE VALUES (90250,1005);
INSERT INTO BIOSITE VALUES (90250,5001);
INSERT INTO BIOSITE VALUES (90250,5002);
INSERT INTO BIOSITE VALUES (90250,5003);
INSERT INTO BIOSITE VALUES (90250,5004);
INSERT INTO BIOSITE VALUES (90250,5005);
INSERT INTO BIOSITE VALUES (90250,5006);
INSERT INTO BIOSITE VALUES (90260,3001);
INSERT INTO BIOSITE VALUES (90260,3002);
INSERT INTO BIOSITE VALUES (90260,3003);
INSERT INTO BIOSITE VALUES (90260,3004);
INSERT INTO BIOSITE VALUES (90260,3006);
INSERT INTO BIOSITE VALUES (90260,4001);
INSERT INTO BIOSITE VALUES (90260,4002);
INSERT INTO BIOSITE VALUES (90260,4003);
INSERT INTO BIOSITE VALUES (90260,4004);
INSERT INTO BIOSITE VALUES (90260,4006);
INSERT INTO BIOSITE VALUES (90260,4007);
INSERT INTO BIOSITE VALUES (90260,4008);
INSERT INTO BIOSITE VALUES (90270,3001);
INSERT INTO BIOSITE VALUES (90270,3002);
INSERT INTO BIOSITE VALUES (90270,3003);
INSERT INTO BIOSITE VALUES (90270,3004);
INSERT INTO BIOSITE VALUES (90270,3006);
INSERT INTO BIOSITE VALUES (90270,4001);
INSERT INTO BIOSITE VALUES (90270,4002);
INSERT INTO BIOSITE VALUES (90270,4003);
INSERT INTO BIOSITE VALUES (90270,4004);
INSERT INTO BIOSITE VALUES (90270,4005);
INSERT INTO BIOSITE VALUES (90270,4006);
INSERT INTO BIOSITE VALUES (90270,4007);
INSERT INTO BIOSITE VALUES (90270,4008);
INSERT INTO BIOSITE VALUES (90280,3001);
INSERT INTO BIOSITE VALUES (90280,3002);
INSERT INTO BIOSITE VALUES (90280,3003);
INSERT INTO BIOSITE VALUES (90280,3004);
INSERT INTO BIOSITE VALUES (90280,3006);
INSERT INTO BIOSITE VALUES (90280,4001);
INSERT INTO BIOSITE VALUES (90280,4002);
INSERT INTO BIOSITE VALUES (90280,4003);
INSERT INTO BIOSITE VALUES (90280,4004);
INSERT INTO BIOSITE VALUES (90280,4005);
INSERT INTO BIOSITE VALUES (90280,4006);
INSERT INTO BIOSITE VALUES (90280,4007);
INSERT INTO BIOSITE VALUES (90280,4008);
INSERT INTO BIOSITE VALUES (90290,3001);
INSERT INTO BIOSITE VALUES (90290,3002);
INSERT INTO BIOSITE VALUES (90290,3003);
INSERT INTO BIOSITE VALUES (90290,3004);
INSERT INTO BIOSITE VALUES (90290,3006);
INSERT INTO BIOSITE VALUES (90290,4001);
INSERT INTO BIOSITE VALUES (90290,4002);
INSERT INTO BIOSITE VALUES (90290,4003);
INSERT INTO BIOSITE VALUES (90290,4004);
INSERT INTO BIOSITE VALUES (90290,4005);
INSERT INTO BIOSITE VALUES (90290,4006);
INSERT INTO BIOSITE VALUES (90290,4007);
INSERT INTO BIOSITE VALUES (90290,4008);
INSERT INTO BIOSITE VALUES (90300,3001);
INSERT INTO BIOSITE VALUES (90300,3002);
INSERT INTO BIOSITE VALUES (90300,3003);
INSERT INTO BIOSITE VALUES (90300,3004);
INSERT INTO BIOSITE VALUES (90300,3006);
INSERT INTO BIOSITE VALUES (90300,4001);
INSERT INTO BIOSITE VALUES (90300,4002);
INSERT INTO BIOSITE VALUES (90300,4003);
INSERT INTO BIOSITE VALUES (90300,4004);
INSERT INTO BIOSITE VALUES (90300,4005);
INSERT INTO BIOSITE VALUES (90300,4006);
INSERT INTO BIOSITE VALUES (90300,4007);
INSERT INTO BIOSITE VALUES (90300,4008);
INSERT INTO BIOSITE VALUES (90310,3001);
INSERT INTO BIOSITE VALUES (90310,3002);
INSERT INTO BIOSITE VALUES (90310,3003);
INSERT INTO BIOSITE VALUES (90310,3004);
INSERT INTO BIOSITE VALUES (90310,3006);
INSERT INTO BIOSITE VALUES (90310,4001);
INSERT INTO BIOSITE VALUES (90310,4002);
INSERT INTO BIOSITE VALUES (90310,4003);
INSERT INTO BIOSITE VALUES (90310,4004);
INSERT INTO BIOSITE VALUES (90310,4005);
INSERT INTO BIOSITE VALUES (90310,4006);
INSERT INTO BIOSITE VALUES (90310,4007);
INSERT INTO BIOSITE VALUES (90310,4008);

--
-- Table structure for table `DEST`
--

CREATE TABLE DEST (
  Destination_No int(11) NOT NULL PRIMARY KEY,
  Destination_Name varchar(60) default NULL,
  Avg_Temp_F decimal(8,2) default NULL,
  Avg_Temp_C decimal(8,2) default NULL,
  Spring_Temp_F decimal(8,2) default NULL,
  Spring_Temp_C decimal(8,2) default NULL,
  Summer_Temp_F decimal(8,2) default NULL,
  Summer_Temp_C decimal(8,2) default NULL,
  Fall_Temp_F decimal(8,2) default NULL,
  Fall_Temp_C decimal(8,2) default NULL,
  Winter_Temp_F decimal(8,2) default NULL,
  Winter_Temp_C decimal(8,2) default NULL,
  Accomodations varchar(40) default NULL,
  Night_Life varchar(40) default NULL,
  Body_of_Water varchar(40) default NULL,
  Travel_Cost decimal(8,2) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `DEST`
--


INSERT INTO DEST VALUES (1,'Cozumel',78.00,25.55,76.00,24.44,84.00,28.88,78.00,25.55,74.00,23.33,'Cheap','Sleepy','Caribbean',1000.00);
INSERT INTO DEST VALUES (2,'Great Barrier Reef',80.00,26.66,76.00,24.44,84.00,28.88,78.00,25.55,76.00,24.44,'Moderate','Pleasant','Coral Sea',5000.00);
INSERT INTO DEST VALUES (3,'Monterey',60.00,15.55,62.00,16.66,64.00,17.77,64.00,17.77,58.00,14.44,'Expensive','Wild','Pacific',4000.00);
INSERT INTO DEST VALUES (4,'Santa Barbara',75.00,23.88,73.00,22.77,78.00,25.55,72.00,22.22,70.00,21.11,'Expensive','Wild','Pacific',3000.00);
INSERT INTO DEST VALUES (5,'Florida',77.00,25.00,75.00,23.88,85.00,29.44,78.00,25.55,70.00,21.11,'Moderate','Pleasant','Caribbean',3000.00);
INSERT INTO DEST VALUES (6,'Fiji',75.00,23.88,76.00,24.44,80.00,26.66,74.00,23.33,70.00,21.11,'Expensive','Sleepy','South Pacific',5000.00);
INSERT INTO DEST VALUES (7,'New Jersey',57.00,13.88,57.00,13.89,60.00,15.55,58.00,14.44,53.00,11.66,'Expensive','Pleasant','Atlantic',2000.00);
INSERT INTO DEST VALUES (8,'Catalina',75,23.889,73,22.777,78,25.556,72,22.222,70,21.111,'Moderate','Pleasant','Pacific',1500.00);
--
-- Table structure for table `DIVECUST`
--

CREATE TABLE DIVECUST (
  Customer_No int(11) NOT NULL PRIMARY KEY,
  Name varchar(100) default NULL,
  Street varchar(100) default NULL,
  City varchar(50) default NULL,
  State_Prov varchar(30) default NULL,
  Zip_Postal_Code varchar(20) default NULL,
  Country varchar(30) default NULL,
  Phone varchar(20) default NULL,
  First_Contact date default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `DIVECUST`
--


INSERT INTO DIVECUST VALUES (6969,'Sven Schiro','1800 North Point Drive','San Francisco','CA','94232','U.S.A.','(415) 555-8290','1991-03-22');
INSERT INTO DIVECUST VALUES (6800,'Tony Rees','19 Maple Avenue','Cambridge','MA','21382','U.S.A.','(617) 555-9822','1991-02-27');
INSERT INTO DIVECUST VALUES (6532,'Jerry Orona','423 Peachtree Road','Atherton','CA','94322','U.S.A.','(415) 555-8872','1991-03-02');
INSERT INTO DIVECUST VALUES (5926,'Valerie O\'Brien','3945 Tasso','Washington','DC','20032','U.S.A.','(202) 555-2322','1991-01-20');
INSERT INTO DIVECUST VALUES (5719,'Marcus Selby','110 E. Hanover Avenue','Birmingham','MI','48011','U.S.A.','(601) 555-8645','1991-02-16');
INSERT INTO DIVECUST VALUES (5510,'Ken Soule','58 Sansome Street','Aurora','CO','89022','U.S.A.','(303) 555-6695','1991-02-05');
INSERT INTO DIVECUST VALUES (4175,'Karen Ng','2134 Elmhill Pike','Klamath Falls','OR','97603','U.S.A.','(503) 555-4700','1991-03-20');
INSERT INTO DIVECUST VALUES (4158,'Keith Lucas','56 South Euclid','Chicago','IL','60542','U.S.A.','(312) 555-4310','1991-03-17');
INSERT INTO DIVECUST VALUES (3684,'Lowell Lutz','915 E. Fesler','Dallas','TX','75043','U.S.A.','(214) 555-2722','1991-02-15');
INSERT INTO DIVECUST VALUES (3333,'Charles Sekaron','110 East Park Avenue, Box 8','Miller','SD','57362','U.S.A.','(613) 555-4333','1991-03-16');
INSERT INTO DIVECUST VALUES (3154,'Tanya Kulesa','505 S. Flower, Mail Stop 48943','New York','NY','10032','U.S.A.','(212) 555-6750','1991-01-30');
INSERT INTO DIVECUST VALUES (2589,'Hiram Marley','7233 Mill Run Drive','San Francisco','CA','94123','U.S.A.','(415) 555-6430','1991-02-18');
INSERT INTO DIVECUST VALUES (2306,'Kim Lopez','14134 Nottingham Lane','Honolulu','HI','96826','U.S.A.','(808) 555-5050','1991-01-29');
INSERT INTO DIVECUST VALUES (2001,'Mary Rioux','1701 Gateway Blvd. #385','Pueblo','CO','81002','U.S.A.','(719) 555-2010','1991-03-15');
INSERT INTO DIVECUST VALUES (1969,'David Burgett','320 Montgomery Street','Seattle','WA','98105','U.S.A.','(206) 555-7580','1991-03-12');
INSERT INTO DIVECUST VALUES (1913,'Phillip Davoust','123 First Street','Berkeley','CA','94704','U.S.A.','(415) 555-9184','1991-03-09');
INSERT INTO DIVECUST VALUES (1909,'Stephen Bredenburg','559 N.E. 167 Place','Indianapolis','IN','46241','U.S.A.','(317) 555-3644','1991-01-05');
INSERT INTO DIVECUST VALUES (1481,'Barbara Wright','6344 W. Freeway','San Francisco','CA','95031','U.S.A.','(415) 555-4321','1991-02-02');
INSERT INTO DIVECUST VALUES (1480,'Louis Jazdzewski','2501 O\'Connor','New Orleans','LA','60332','U.S.A.','(902) 555-8888','1991-01-29');
INSERT INTO DIVECUST VALUES (7008,'Richard Denning','One Hamilton Plaza','Topeka','KS','66104','U.S.A.','(913) 555-7381','1991-03-09');
INSERT INTO DIVECUST VALUES (7332,'Lauri Tanksley','575 Easton Avenue','Albuquerque','NM','87234','U.S.A.','(505) 555-2800','1991-04-02');
INSERT INTO DIVECUST VALUES (7700,'Michael Leblanc','4210 Johnson Drive','Bel Air','CA','90026','U.S.A.','(213) 555-4390','1991-01-20');
INSERT INTO DIVECUST VALUES (8585,'Bruce Fowler','5489 Kingsway','Tiburon','CA','97992','U.S.A.','(213) 555-7270','1991-04-02');
INSERT INTO DIVECUST VALUES (8765,'Lorraine Vega','517 Trace Creek Drive','San Francisco','CA','94332','U.S.A.','(415) 555-8761','1991-04-03');
INSERT INTO DIVECUST VALUES (8952,'Amanda Gentry','405 Five Farms Lane','Oxon Hill','MD','29902','U.S.A.','(301) 555-3172','1991-04-04');
INSERT INTO DIVECUST VALUES (9004,'Jan Hooverson','43439 Caithness Drive','Palm Springs','FL','32382','U.S.A.','(305) 555-3735','1991-04-08');

--
-- Table structure for table `DIVEITEM`
--

CREATE TABLE DIVEITEM (
  Order_No int(11) NOT NULL,
  Item_No int(11) NOT NULL,
  Rental_Sale varchar(10) default NULL,
  Qty int(11) default NULL,
  Line_Note varchar(200) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `DIVEITEM`
--


INSERT INTO DIVEITEM VALUES (307,90010,'Rental',4,'');
INSERT INTO DIVEITEM VALUES (307,90020,'Rental',1,'This is our most popular mask.');
INSERT INTO DIVEITEM VALUES (307,90021,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (307,90030,'Rental',2,'These are our best selling fins.');
INSERT INTO DIVEITEM VALUES (307,90051,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (310,90011,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (310,90045,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (310,90059,'Rental',1,'A good weight belt for beginners.');
INSERT INTO DIVEITEM VALUES (310,90074,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (310,90078,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (313,90127,'Sale',1,'Holds 10 cubic feet of cargo.');
INSERT INTO DIVEITEM VALUES (314,90072,'Rental',3,'');
INSERT INTO DIVEITEM VALUES (314,90094,'Rental',3,'');
INSERT INTO DIVEITEM VALUES (314,90100,'Rental',3,'');
INSERT INTO DIVEITEM VALUES (317,90012,'Sale',2,'');
INSERT INTO DIVEITEM VALUES (317,90022,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (317,90033,'Sale',2,'A long-lasting and comfortable fin.');
INSERT INTO DIVEITEM VALUES (317,90056,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (317,90117,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (320,90020,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90030,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90075,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90096,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90101,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90109,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90113,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (320,90122,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (325,90041,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (325,90058,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (325,90063,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (325,90110,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (326,90011,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (326,90024,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (326,90031,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (326,90050,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (327,90020,'Rental',4,'');
INSERT INTO DIVEITEM VALUES (327,90030,'Rental',4,'');
INSERT INTO DIVEITEM VALUES (327,90126,'Sale',1,'Holds 5 cubic feet of cargo');
INSERT INTO DIVEITEM VALUES (329,90124,'Sale',1,'Comes with lifetime warranty');
INSERT INTO DIVEITEM VALUES (330,90040,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (330,90054,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (330,90085,'Rental',1,'Fits men 6\'2\'\' to 6\'7\'\'');
INSERT INTO DIVEITEM VALUES (330,90088,'Rental',1,'Fits women 5\'2\'\' to 5\'4\'\'');
INSERT INTO DIVEITEM VALUES (331,90012,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (331,90025,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (331,90032,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (333,90043,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (333,90051,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (333,90058,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (333,90115,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (333,90122,'Sale',2,'');
INSERT INTO DIVEITEM VALUES (336,90117,'Sale',5,'');
INSERT INTO DIVEITEM VALUES (336,90118,'Sale',5,'');
INSERT INTO DIVEITEM VALUES (337,90116,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (337,90127,'Sale',1,'');
INSERT INTO DIVEITEM VALUES (338,90045,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (338,90078,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (338,90099,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (339,90065,'Rental',7,'');
INSERT INTO DIVEITEM VALUES (339,90074,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (339,90077,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (339,90094,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (339,90095,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (339,90102,'Rental',6,'');
INSERT INTO DIVEITEM VALUES (339,90107,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (340,90010,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (340,90020,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (340,90030,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (340,90056,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (340,90059,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (340,90061,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (341,90011,'Sale',2,'');
INSERT INTO DIVEITEM VALUES (341,90031,'Sale',2,'');
INSERT INTO DIVEITEM VALUES (342,90024,'Rental',4,'');
INSERT INTO DIVEITEM VALUES (342,90050,'Rental',4,'');
INSERT INTO DIVEITEM VALUES (343,90111,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (343,90114,'Rental',2,'');
INSERT INTO DIVEITEM VALUES (343,90115,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (345,90085,'Rental',1,'');
INSERT INTO DIVEITEM VALUES (345,90096,'Rental',1,'');

--
-- Table structure for table `DIVESTOK`
--

CREATE TABLE DIVESTOK (
  Item_No int(11) NOT NULL PRIMARY KEY,
  Description varchar(255) default NULL,
  Equipment_Class varchar(255) default NULL,
  On_Hand int(11) default NULL,
  Reorder_Point int(11) default NULL,
  Cost decimal(8,2) default NULL,
  Sale_Price decimal(8,2) default NULL,
  Rental_Price decimal(8,2) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `DIVESTOK`
--


INSERT INTO DIVESTOK VALUES (90010,'Shotgun 2 Snorkel - Clear','Snorkel',12,2,18.00,30.00,2.00);
INSERT INTO DIVESTOK VALUES (90011,'Shotgun 2 Snorkel - Red','Snorkel',12,2,18.00,30.00,2.00);
INSERT INTO DIVESTOK VALUES (90012,'Shotgun 2 Snorkel - Teal','Snorkel',11,2,18.00,30.00,2.00);
INSERT INTO DIVESTOK VALUES (90020,'Tri-Vent Mask - Clear','Mask',14,2,62.50,100.00,5.00);
INSERT INTO DIVESTOK VALUES (90021,'Tri-Vent Mask - Red','Mask',10,2,62.50,100.00,5.00);
INSERT INTO DIVESTOK VALUES (90022,'Tri-Vent Mask - Teal','Mask',14,2,62.50,100.00,7.00);
INSERT INTO DIVESTOK VALUES (90023,'Quad Vision Mask - Clear','Mask',11,2,48.25,80.00,7.00);
INSERT INTO DIVESTOK VALUES (90024,'Quad Vision Mask - Red','Mask',13,2,48.25,80.00,7.00);
INSERT INTO DIVESTOK VALUES (90025,'Quad Vision Mask - Teal','Mask',10,2,48.25,80.00,10.00);
INSERT INTO DIVESTOK VALUES (90030,'Sea Wing Fins - Clear','Fins',12,2,60.00,100.00,12.00);
INSERT INTO DIVESTOK VALUES (90031,'Sea Wing Fins - Red','Fins',11,2,60.00,100.00,12.00);
INSERT INTO DIVESTOK VALUES (90032,'Sea Wing Fins - Teal','Fins',12,2,60.00,100.00,12.00);
INSERT INTO DIVESTOK VALUES (90033,'Jet Fin - Black','Fins',14,2,30.00,60.00,10.00);
INSERT INTO DIVESTOK VALUES (90040,'D350 Second Stage','Regulator',11,1,162.50,270.00,20.00);
INSERT INTO DIVESTOK VALUES (90041,'G250 Second Stage','Regulator',13,1,144.50,240.00,20.00);
INSERT INTO DIVESTOK VALUES (90042,'G200 Second Stage','Regulator',12,1,105.25,175.00,20.00);
INSERT INTO DIVESTOK VALUES (90043,'MK10 First Stage','Regulator',11,1,104.50,175.00,30.00);
INSERT INTO DIVESTOK VALUES (90044,'MK200 First Stage','Regulator',12,1,65.00,105.00,30.00);
INSERT INTO DIVESTOK VALUES (90045,'5500 RX Octopus','Regulator',12,1,126.00,180.00,35.00);
INSERT INTO DIVESTOK VALUES (90050,'Stabilizing Jacket - Red','Buoyancy',14,2,168.50,280.00,20.00);
INSERT INTO DIVESTOK VALUES (90051,'Stabilizing Jacket - Blue','Buoyancy',13,2,168.50,280.00,20.00);
INSERT INTO DIVESTOK VALUES (90052,'Stabilizing Jacket - Teal','Buoyancy',10,2,168.50,280.00,20.00);
INSERT INTO DIVESTOK VALUES (90053,'Front Adjustable Jacket - Red','Buoyancy',10,1,168.50,280.00,25.00);
INSERT INTO DIVESTOK VALUES (90054,'Front Adjustable Jacket - Blue','Buoyancy',11,1,168.50,280.00,25.00);
INSERT INTO DIVESTOK VALUES (90055,'Front Adjustable Jacket - Teal','Buoyancy',11,1,168.50,280.00,25.00);
INSERT INTO DIVESTOK VALUES (90056,'Snorkeling Vest - Red','Buoyancy',12,1,55.00,90.00,15.00);
INSERT INTO DIVESTOK VALUES (90057,'Power Inflator','Buoyancy',11,1,42.50,75.00,30.00);
INSERT INTO DIVESTOK VALUES (90058,'Mesh Weight Belt','Buoyancy',13,2,24.50,36.00,0.00);
INSERT INTO DIVESTOK VALUES (90059,'Quick Release Weight Belt','Buoyancy',15,2,8.75,15.00,0.00);
INSERT INTO DIVESTOK VALUES (90060,'71.4cf Chromemoly Tank',' Shorty',0,11,1.00,227.50,325.00);
INSERT INTO DIVESTOK VALUES (90061,'71.4cf Chromemoly Tank',' Slim',0,10,1.00,227.50,325.00);
INSERT INTO DIVESTOK VALUES (90062,'95.1cf Chromemoly Tank','Tank',11,1,262.50,375.00,20.00);
INSERT INTO DIVESTOK VALUES (90063,'Tank Ball Valve','Tank',11,1,55.00,95.00,0.00);
INSERT INTO DIVESTOK VALUES (90064,'Tank K Valve','Tank',12,2,42.00,70.00,0.00);
INSERT INTO DIVESTOK VALUES (90065,'Back Pack Assembly','Tank',12,1,64.50,100.00,10.00);
INSERT INTO DIVESTOK VALUES (90070,'Jacket & Farmer John-Men\'s S','Suit',10,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90071,'Jacket & Farmer John-Men\'s M','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90072,'Jacket & Farmer John-Men\'s ML','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90073,'Jacket & Farmer John-Men\'s L','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90074,'Jacket & Farmer John-Men\'s XL','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90075,'Jacket & Farmer John-Men\'s XXL','Suit',10,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90076,'Jacket & Farmer John-Wm\'s XS','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90077,'Jacket & Farmer John-Wm\'s S','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90078,'Jacket & Farmer John-Wm\'s M','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90079,'Jacket & Farmer John-Wm\'s L','Suit',10,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90080,'Jacket & Farmer John-Wm\'s XL','Suit',11,1,175.00,250.00,25.00);
INSERT INTO DIVESTOK VALUES (90081,'Short Sleeve Shorty-Men\'s S','Suit',10,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90082,'Short Sleeve Shorty-Men\'s M','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90083,'Short Sleeve Shorty-Men\'s ML','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90084,'Short Sleeve Shorty-Men\'s L','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90085,'Short Sleeve Shorty-Men\'s XL','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90086,'Short Sleeve Shorty-Men\'s XXL','Suit',10,0,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90087,'Short Sleeve Shorty-Wm\'s XS','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90088,'Short Sleeve Shorty-Wm\'s S','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90089,'Short Sleeve Shorty-Wm\'s M','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90090,'Short Sleeve Shorty-Wm\'s L','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90091,'Short Sleeve Shorty-Wm\'s XL','Suit',11,1,136.50,195.00,20.00);
INSERT INTO DIVESTOK VALUES (90092,'Hood - XS','Suit',11,1,17.50,25.00,5.00);
INSERT INTO DIVESTOK VALUES (90093,'Hood - S','Suit',11,1,17.50,25.00,5.00);
INSERT INTO DIVESTOK VALUES (90094,'Hood - M','Suit',11,1,17.50,25.00,5.00);
INSERT INTO DIVESTOK VALUES (90095,'Hood - L','Suit',11,1,17.50,25.00,5.00);
INSERT INTO DIVESTOK VALUES (90096,'Hood - XL','Suit',11,1,17.50,25.00,5.00);
INSERT INTO DIVESTOK VALUES (90097,'Gloves - XS','Suit',11,1,10.50,15.00,5.00);
INSERT INTO DIVESTOK VALUES (90098,'Gloves - S','Suit',11,1,10.50,15.00,5.00);
INSERT INTO DIVESTOK VALUES (90099,'Gloves - M','Suit',11,1,10.50,15.00,5.00);
INSERT INTO DIVESTOK VALUES (90100,'Gloves - L','Suit',11,1,10.50,15.00,5.00);
INSERT INTO DIVESTOK VALUES (90101,'Gloves - XL','Suit',11,1,10.50,15.00,5.00);
INSERT INTO DIVESTOK VALUES (90102,'Boots - 5','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90103,'Boots - 6','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90104,'Boots - 7','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90105,'Boots - 8','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90106,'Boots - 9','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90107,'Boots - 10','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90108,'Boots - 11','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90109,'Boots - 12','Suit',11,1,21.00,30.00,5.00);
INSERT INTO DIVESTOK VALUES (90110,'Analog Console (SPG','Depth)',0,12,1.00,112.00,210.00);
INSERT INTO DIVESTOK VALUES (90111,'Digital Console (SPG',' Depth)',0,12,1.00,252.50,420.00);
INSERT INTO DIVESTOK VALUES (90112,'Temperature Gauge','Instrument',11,1,20.00,34.00,5.00);
INSERT INTO DIVESTOK VALUES (90113,'Depth Gauge','Instrument',12,1,51.00,85.00,10.00);
INSERT INTO DIVESTOK VALUES (90114,'Submersible Pressure Gauge','Instrument',12,1,62.50,105.00,5.00);
INSERT INTO DIVESTOK VALUES (90115,'Dive Computer','Instrument',11,1,400.00,650.00,35.00);
INSERT INTO DIVESTOK VALUES (90116,'Compass','Instrument',14,2,54.00,65.00,5.00);
INSERT INTO DIVESTOK VALUES (90117,'Titanium Watch - Men\'s','Instrument',11,1,320.50,550.00,30.00);
INSERT INTO DIVESTOK VALUES (90118,'Titanium Watch - Wm\'s','Instrument',11,1,215.00,360.00,30.00);
INSERT INTO DIVESTOK VALUES (90120,'Titanium Knife - Medium','Accessory',15,2,90.00,150.00,10.00);
INSERT INTO DIVESTOK VALUES (90121,'Titanium Knife - Large','Accessory',14,2,95.50,160.00,10.00);
INSERT INTO DIVESTOK VALUES (90122,'Safety Knife','Accessory',16,2,22.50,45.00,10.00);
INSERT INTO DIVESTOK VALUES (90123,'Flashlight - Red','Accessory',13,1,41.00,65.00,5.00);
INSERT INTO DIVESTOK VALUES (90124,'Flashlight - Blue','Accessory',14,1,41.00,65.00,5.00);
INSERT INTO DIVESTOK VALUES (90125,'Flashlight - Teal','Accessory',10,1,41.00,65.00,5.00);
INSERT INTO DIVESTOK VALUES (90126,'Gear Bag - Black','Accessory',11,1,45.50,90.00,5.00);
INSERT INTO DIVESTOK VALUES (90127,'Jumbo Gear Bag - Black','Accessory',11,1,60.00,110.00,5.00);

--
-- Table structure for table `SHIPVIA`
--

CREATE TABLE SHIPVIA (
  Ship_Via varchar(255) NOT NULL PRIMARY KEY,
  Ship_Cost int(11) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `SHIPVIA`
--


INSERT INTO SHIPVIA VALUES ('DHL',8);
INSERT INTO SHIPVIA VALUES ('Emery',11);
INSERT INTO SHIPVIA VALUES ('FedEx',12);
INSERT INTO SHIPVIA VALUES ('UPS',10);
INSERT INTO SHIPVIA VALUES ('US Mail',6);
INSERT INTO SHIPVIA VALUES ('Walk In',0);

--
-- Table structure for table `SHIPWRCK`
--

CREATE TABLE SHIPWRCK (
  Ship_Name varchar(30) NOT NULL PRIMARY KEY,
  Site_No int(11) default NULL,
  Category varchar(40) default NULL,
  Type varchar(20) default NULL,
  Interest varchar(30) default NULL,
  Tonnage decimal(8,2) default NULL,
  Length_ft decimal(8,2) default NULL,
  Length_m decimal(8,2) default NULL,
  Beam_ft decimal(8,2) default NULL,
  Beam_m decimal(8,2) default NULL,
  Cause varchar(20) default NULL,
  Date_Sunk date default NULL,
  Comments blob,
  Passengers_Crew int(11) default NULL,
  Survivors int(11) default NULL,
  Condition varchar(30) default NULL,
  GraphicPic varchar(100) default NULL,
  GraphicFile varchar(50) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `SHIPWRCK`
--


INSERT INTO SHIPWRCK VALUES ('Valiant',4003,'Passenger','Luxury Motor Yacht','Treasure',444.00,162.40,49.49,26.00,7.92,'Fire','1930-12-17','The Valiant was a 162-foot luxury motor yacht built in 1926 at an estimated cost of $750,000.  Owned by West Coast Buick distributor Charles S. Howard of San Francisco, she featured a 14- knot cruising speed and 5500-mile range.  Although the Valiant was the first American ship to feature a double hull for storage, stability, and safety, this wasn\'t enough to save her. <P>The yacht was anchored off Catalina Island, and dinner preparations were in progress when all lights went out.  The gas generator\'s fuel tank was dry, so a crew member opened a valve to refill the tank, restarted the engine, and left.  The tank overflowed and gasoline flooded the engine room.  A tremendous explosion set the entire midships ablaze. <P>The Valiant burned for three days, fueled by 8000 gallons of diesel fuel.  She went down with a reported $75,000 in cash and gems.',25,25,'Intact','','valiant2.gif');
INSERT INTO SHIPWRCK VALUES ('USS Moody',4006,'Military','WWI Destroyer','Treasure',1308.00,314.00,95.70,31.00,9.44,'Deliberate','1933-01-01','The Moody was a WWI Clemson-class destroyer commissioned in 1919.  She was very fast at over 34 knots and heavily armed with four four-inch guns, one three-inch gun, and 12 torpedo tubes.  After being used as a training vessel all over the world, she was decommissioned in 1930 in San Diego. <P>Her next and final role was in the movies.  MGM Studios acquired her for the picture \"Hell Below,\" where she played the part of an enemy mine layer destroyed by a Navy submarine.  The Moody\'s hull was cut in half amidships and temporarily stitched together with steel cable.  Timed explosions and controlled sinking made her a star.  The scene was so dramatic, it was borrowed by the documentary series \"Victory at Sea.\"',0,0,'Intact','','moody2.jpg');
INSERT INTO SHIPWRCK VALUES ('Tolten',7008,'Commercial','Freighter','Fixture',1858.00,280.00,85.34,43.00,13.10,'Military','1942-03-13','The SS Lotta was one of five steamers the Chilean government commandeered from Denmark.  After the Chileans agreed to pay for the use and any damage to these ships, they renamed SS Lotta the Tolten and used her to transport nitrates to the United States and tires, iron, and steel back to Chile. <P>Chile was one of several South American republics not to declare war on Germany.  In return, safe passage was promised Chilean ships in their trade with the United States, if they did not travel with Allied convoys or blacked out. <P>A U.S. Naval Patrol Services boat stopped the Tolten along the New Jersey coast and ordered her lights out.  A short time later she was torpedoed by the German submarine U-404 and sank within six minutes.  The only survivor was thrown clear of the ship and picked up after clinging to a life raft for 12 hours.',28,1,'Intact','','tolten-lotta.jpg');
INSERT INTO SHIPWRCK VALUES ('Star of Scotland',4002,'Passenger','British Q-boat','Treasure',1250.00,263.00,80.16,35.00,10.66,'Weather','1942-01-22','The Star of Scotland\'s history is colorful from the onset.  She was christened HMS Mistletoe and launched in 1918 as a Q-boat in England\'s Royal Navy.  Her task was to lure enemy submarines into thinking they were stalking a slow freighter.  When the U-boat captain would surface to shell the seemingly helpless vessel, facade deck structures and bulwarks fell away to reveal heavy deck guns and depth charge racks and throwers!  Disguised and highly trained British crews were very effective against the marauding submarines. <P>After the war, the 263-foot ship performed survey and freighter duties along the Pacific Coast under the names Chiapas and La Playa de Ensenada.  In 1933 she appeared in Santa Monica Bay offering \"dolls, drinks, and dice\" on \"Cruises to Nowhere\" under the names City of Panama, Star of Hollywood, and Texas.  Huge profits, scandal, and eventually murder ended this segment of her history. <P>In the late 1930s, she was turned into a fishing barge and deluxe dining and dancing facility and renamed the Star of Scotland.  But in the fall of 1941, long overdue for a haulout, the Star began leaking from the constant pounding of shore boats against her hull. <P>Because her propellers had been removed, she couldn\'t get to an available shipyard, and only minor repairs were made to keep her afloat.  It wasn\'t enough.  In January 1942, ocean swells caused additional leaks below decks.  Pumps held back the incoming water until a major storm provided the fatal blow, and the Star of Scotland sank in less than two minutes.',5,4,'Broken','','Scotlnd2.gif');
INSERT INTO SHIPWRCK VALUES ('R.P. Resor',7006,'Commercial','Oil Tanker','Treasure',7450.00,435.00,132.58,66.80,20.36,'Military','1942-02-28','The oil freighter R.P. Resor, owned by the Standard Oil Company of New Jersey, was launched in 1935 from Kearney, New Jersey, and the waters off New Jersey are her final resting place. <P>In February 1942, the ship set off from Baytown, Texas, with a cargo of nearly 79,000 barrels of fuel oil.  She was headed for Fall River, Massachusetts.  Following wartime procedure, she sailed unescorted on a zigzag course with all lights off.  The seaman on watch spotted two running lights in the distance and assumed they belonged to a local fishing boat.  The Resor changed course to clear the boat, and a few minutes later torpedoes struck.  The enemy submarine had tricked the tanker into turning broadside, providing an easy target! <P>Fire spread quickly across the sea, and flames spread hundreds of feet into the air.  The departing submarine could now easily be seen as she motored off in search of another Allied victim.  Many sailors made it to life boats, but they were never found.  Three hundred pounds of tar covered the body of one of the only two survivors. <P>The Resor drifted and burned for two days before sinking--within five miles of the New Jersey shore.',50,2,'Broken','','rp_resor_1.jpg');
INSERT INTO SHIPWRCK VALUES ('Mohawk',7004,'Passenger','Ocean Liner','Treasure',8140.00,402.00,122.52,54.00,16.45,'Collision','1935-01-25','The passenger ship Mohawk was launched by the Newport News Shipbuilding and Drydock Company in 1925.  The Ward Line used her in the popular Havana, Cuba, run with stops in Progreso and Vera Cruz, Mexico.  She was pressed into service after the Ward Line lost two previous passenger liners to grounding and fire. <P>Her last cruise departed from Lower Manhattan on a cold January afternoon in 1935, heading due south toward Cuba.  She lagged along the New Jersey coast for a compass calibration and was overtaken by the much slower Norwegian tanker Talisman.  Suddenly, the Mohawk turned and veered across the tanker\'s course.  The Talisman\'s bow plunged deeply into the Mohawk\'s port side, creating a huge gash in the liner\'s hull.  Taking on water and listing badly, she sank in less than an hour. <P>The Mohawk name is not a lucky one.  In 1925 the Clyde Liner Mohawk caught fire and sank in Delaware Bay.  Her replacement (also named Mohawk) collided with the Old Dominion steamer Jefferson in heavy fog.  A Coast Guard cutter named Mohawk was previously rammed by a tramp steamer and sunk off the New Jersey Coast in 1917.  Despite all this, the new Coast Guard cutter Mohawk was under construction in 1935 to patrol the very waters where the Ward Line ship was lost.',163,118,'Scattered','','mohawk__1.gif');
INSERT INTO SHIPWRCK VALUES ('Great Isaac',7002,'Commercial','Seagoing Tug','Fixture',1117.00,185.00,56.38,37.00,11.27,'Collision','1947-04-16','The Great Isaac was a huge V-4 class seagoing tug and salvage vessel named after the 152-foot high lighthouse on Great Isaac Island near Grand Bahama.  The 185-foot tug was launched in 1944 from Boston, Massachusetts.  Although she was built to tow concrete oil barges, this task never materialized.  During wartime she had a platform-mounted, three-inch, anti-aircraft bow gun and two 50-caliber machine guns aft of the flying bridge, along with the Navy personnel to operate them. <P>The Great Isaac was towing the Liberty Ship Thomas M. Coolly from Norfolk, Virginia, to New York in dense fog when she was rammed by the Norwegian freighter Bandeirante.  The bow of the freighter plunged six feet into the Great Isaac\'s engine room, and she sank immediately.',27,27,'Intact','','great_isaac.jpg');
INSERT INTO SHIPWRCK VALUES ('Lizzie D',7001,'Commercial','Tug/Rumrunner','Treasure',122.00,84.00,25.60,21.00,6.40,'Unknown','1922-10-19','Launched in 1907 from Philadelphia, Pennsylvania, the steel-hulled Lizzie D began life as a coastal tug.  Her job description changed to \"rum running\" when the National Prohibition Act passed in 1919.  Demand for alcohol soared, and many vessels were pressed into smuggling service. <P>Rum running was a popular method of importing illegal whiskey.  These vessels would steam offshore, take a load of liquor from a larger ship, and return to sell the cargo at a large profit to Rum Row operators.  The 84-foot Lizzie D sank during one of these excursions in the fall of 1922.  The cause of the tragedy was never determined.',8,0,'Intact','','Lizzie_d.gif');
INSERT INTO SHIPWRCK VALUES ('Gosford',4001,'Commercial','Barque Rigged Sail','Fixture',2250.00,280.00,85.34,42.00,12.80,'Fire','1893-11-24','The Gosford was a steel-hulled, four-masted, barque rigged sailing ship completed in Scotland in December 1891.  She was on her second voyage with a consignment of soft coal to heat the homes of San Francisco when her cargo spontaneously combusted. <P>For several days, the crew moved tons of coal by hand and bravely fought the fire as the hull glowed bright red.  The steam schooner Casper provided a tow to safe anchorage in Cojo Bay south of Point Conception.  Several other ships arrived on the scene but even with their assistance, the fire could not be quenched.  Five days after it started, the fire began to die down, causing the hull plates to cool and cracks to open along all the seams.  The sea rushed in and the Gosford went down.',0,0,'Intact','','gosford2a.gif');
INSERT INTO SHIPWRCK VALUES ('F.S.Loop',4004,'Commercial','Steam Schooner','Machinery',794.00,193.00,58.82,39.00,11.88,'Deliberate','1947-01-01','The F.S. Loop was a three-masted wooden schooner built in 1907 in Coos Bay, Oregon, by Kruse & Banks Shipbuilding.  She had a colorful career, described by commercial diver E.R. Cross in a 1956 issue of Water World magazine.  \"Her 41-year life,\" he wrote, \"had been alternately chapters of accidents and illustrations of misadventure.  Strandings, shifting cargoes of lumber, near capsizings, broken masts, shredded sails from the storms she had bested, and men lost overboard forever to the relentless sea had been her lot.  Yet she had sailed on, living a long and prosperous life compared to the average life of a seagoing vessel.\" <P>The Loop sank in the Los Angeles harbor in 1945.  Because she was a hazard for other ships, attempts were made to float the Loop and tow her to a deep-water grave.  She was resistant and ultimately sank three times, the final time just outside the harbor\'s breakwater.  Cross was hired to dynamite her in 1948.',0,0,'Scattered','','fsloop.jpg');
INSERT INTO SHIPWRCK VALUES ('Delaware',7007,'Commercial','Steam Freighter','Treasure',1646.00,252.00,76.80,37.00,11.27,'Fire','1898-07-09','The Delaware, built in 1880, was a wooden-hulled, coal-fired steam freighter.  She was owned by W.P. Clyde & Company out of Philadelphia, Pennsylvania, at the time of sinking.  <P>A raging fire began spreading below the decks when the Delaware was about 10 miles east of Barnegat, New Jersey.  Crew members quickly determined there was no hope of containment and launched distress rockets as the wooden steamer headed westward toward land.  About two miles offshore, the fire broke through the decks and lit up the night sky.  An orderly evacuation into four lifeboats saved all aboard. <P>The tugboat W.S. Chapman was dispatched in hopes of salvage.  She arrived to find the Delaware still afloat, even though the entire hull had burned to the water line.  The Delaware finally sank near Bayhead, New Jersey, during the tow northward.',66,66,'Broken','','delaware_1.jpg');

INSERT INTO SHIPWRCK VALUES ('Ningpo',8000,'Commercial','Chinese Junk','Fixture',291,138,42.0624,22,6.0756,'Beached and Burned',6/6/1938,'Laying under a few feet of water in Catalina Harbor is the wreck of the Ningpo. Built in 1753, the Ningpo spent 159 years in the Yellow Seas engaging in crimes such as smuggling, slave trading, mutiny, and piracy. While the number of people that have been killed aboard the vessel will never be known, it is said that 158 heads have rolled on the decks of the Ningpo. <P> The Ningpo was launched in 1753 in the city of Fu Chau as a 3-masted, 291 ton junk named the Kin Tai Foong. The 138 foot long junk was said to be the \"fastest and best equipped vessel afloat in Chinese waters,\" and it wasn\'t long before the merchant trader turned into a smuggler and a slaver. Her first battle was during the rebellion against the Emperor in 1796 and according to Della Phillips\' article, it was just the beginning of long series of events that would follow: <P>1806 Seized for smuggling and piracy<P>1814 Captured and set on fire at Nanking<P>1823 Seized for smuggling silk and opium<P>1834 Confiscated by the British under Lord Napier for smuggling and for carrying slave girls to Canton<P>1841 Captured by the Chinese government and used for seven years as a prison ship for pirates and smugglers. During this time, the Chinese government found some of the prisoners too expensive to feed, and reportedly ordered 158 of them beheaded.<P>1861 Seized by rebels in Taiping and converted into a transport because of her size and speed. Retaken by \"Chinese\" Gordon, in command of the English Imperial forces against the Taiping rebel. Gordon changed her name to Ningpo meaning \"calm waves\" or \"peaceful waves\" and after the city of the same name.<P>1861 Wrecked in a typhoon.<P>pre-1884 The vessel preyed on tourists in Hong Kong. Passengers were taken of board for a few days\' cruise. The unsuspecting passengers would then be robbed and set ashore. The British vessel H.M.S. Calliope captured the Ningpo imprisoned the 60 crewmembers, and sold the vessel in Hong Kong.<P>1911 Captured by rebels in the battle of Hankow and sold to Americans for $50,000. 1912 Wrecked in a typhoon on June 12.  Wrecked again in a typhoon September 26 off Kyushi, with the loss of the sails and use of the rudder. Crew mutinied and refused to work. Four men rowed the vessel 320 miles back to port. Once in port, the crew were taken in arms. On December 22 of the same year, a new crew sailed the repaired Ningpo7,000 miles in 55 days to San Pedro.<P>1913 Towed to Venice Beach for display. In April, the junk was towed down to San Diego, and in October she was towed back to San Pedro. In November, the Ningpo wrecked off Dead Man\'s Island. While being dry-docked and repaired in Long Beach, a small silver plate was found behind one of the \"eyes\" of the ship. The plate had inscriptions on it that were translated to say \"The eye of the dragon is bright and colorful.\" Put on display at Long Beach.<P>1915 Towed to San Diego and put on display.<P>Circa 1917 Towed to Catalina Harbor for display.<P>1938 Burned (possibly for a movie) in Catalina Harbor.',0,0,'Burned out','','Ningo56.jpg');

--
-- Table structure for table `SITES`
--

CREATE TABLE SITES (
  Site_No int(11) NOT NULL PRIMARY KEY,
  Destination_No decimal(8,2) default NULL,
  Site_Name varchar(40) default NULL,
  Site_Highlight varchar(30) default NULL,
  Site_Notes blob,
  Distance_from_Town_m decimal(8,2) default NULL,
  Distance_from_Town_km decimal(8,2) default NULL,
  Depth_ft decimal(8,2) default NULL,
  Depth_m decimal(8,2) default NULL,
  Visibility_ft decimal(8,2) default NULL,
  Visibility_m decimal(8,2) default NULL,
  Currents varchar(30) default NULL,
  Skill_Level varchar(20) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `SITES`
--


INSERT INTO SITES VALUES (7008,7.00,'Tolten','Shipwrecks','',16.00,25.74,95.00,28.95,60.00,18.28,'Mild','Intermediate');
INSERT INTO SITES VALUES (7007,7.00,'Delaware','Shipwrecks','',1.50,2.41,70.00,21.33,50.00,15.24,'None','Intermediate');
INSERT INTO SITES VALUES (7006,7.00,'R.P. Resor','Shipwrecks','',32.00,51.49,130.00,39.62,80.00,24.38,'Mild','Advanced');
INSERT INTO SITES VALUES (7005,7.00,'Stolt Dagali','Shipwrecks','',18.00,28.96,130.00,39.62,60.00,18.28,'Mild','Advanced');
INSERT INTO SITES VALUES (7004,7.00,'Mohawk','Shipwrecks','',6.50,10.46,80.00,24.38,40.00,12.19,'Mild','Beginning');
INSERT INTO SITES VALUES (7003,7.00,'Pinta','Shipwrecks','',5.00,8.04,90.00,27.43,30.00,9.14,'Mild','Advanced');
INSERT INTO SITES VALUES (7002,7.00,'Great Isaac','Shipwrecks','',9.80,15.77,90.00,27.43,60.00,18.28,'Mild','Intermediate');
INSERT INTO SITES VALUES (7001,7.00,'Lizzie D','Shipwrecks','',8.00,12.87,80.00,24.38,70.00,21.33,'Mild','Intermediate');
INSERT INTO SITES VALUES (6005,6.00,'Arc de Triumphe','Pinnacle','',15.00,24.14,80.00,24.38,150.00,45.72,'None','Intermediate');
INSERT INTO SITES VALUES (6004,6.00,'Cutter Passage','Reef','',40.00,64.37,90.00,27.43,150.00,45.72,'Strong','Advanced');
INSERT INTO SITES VALUES (6003,6.00,'Yellow Wall','Marine Life','',65.00,104.60,70.00,21.33,125.00,38.10,'None','Intermediate');
INSERT INTO SITES VALUES (6001,6.00,'The W','Reef','',15.00,24.14,60.00,18.28,150.00,45.72,'None','Beginning');
INSERT INTO SITES VALUES (5006,5.00,'Davis Ledge','Marine Life','',4.00,6.43,25.00,7.62,60.00,18.28,'None','Beginning');
INSERT INTO SITES VALUES (5005,5.00,'Crocker Valley','Reef','',5.00,8.04,105.00,32.00,90.00,27.43,'None','Intermediate');
INSERT INTO SITES VALUES (5004,5.00,'French Reef','Caves','',1.00,1.60,30.00,9.14,60.00,18.28,'None','Beginning');
INSERT INTO SITES VALUES (5003,5.00,'Conch Wall','Reef','',3.00,4.82,100.00,30.48,90.00,27.43,'Mild','Intermediate');
INSERT INTO SITES VALUES (5002,5.00,'Coffin\'s Patch','Reef','',2.00,3.21,25.00,7.62,80.00,24.38,'None','Beginning');
INSERT INTO SITES VALUES (5001,5.00,'Middle Sambo','Marine Life','',1.00,1.60,25.00,7.62,90.00,27.43,'None','Beginning');
INSERT INTO SITES VALUES (4008,4.00,'Palos Verdes','Shipwrecks','',0.75,1.20,70.00,21.33,15.00,4.57,'Surge','Intermediate');
INSERT INTO SITES VALUES (4007,4.00,'San Clemente Island','Shipwrecks','',50.00,80.46,80.00,24.38,50.00,15.24,'None','Intermediate');
INSERT INTO SITES VALUES (4006,4.00,'USS Moody','Shipwrecks','',8.00,12.87,130.00,39.62,30.00,9.14,'Mild','Advanced');
INSERT INTO SITES VALUES (4005,4.00,'Scorpion Anchorage','Shipwrecks','',0.50,0.80,60.00,18.28,50.00,15.24,'Mild','Beginning');
INSERT INTO SITES VALUES (4004,4.00,'Los Angeles Harbor','Shipwrecks','',1.00,1.60,75.00,22.86,20.00,6.09,'Strong','Advanced');
INSERT INTO SITES VALUES (4003,4.00,'Descanso Bay','Shipwrecks','',0.10,0.16,90.00,27.43,40.00,12.19,'None','Beginning');
INSERT INTO SITES VALUES (4002,4.00,'Santa Monica Bay','Shipwrecks','',2.00,3.21,70.00,21.33,30.00,9.14,'Mild','Beginning');
INSERT INTO SITES VALUES (4001,4.00,'Cojo Bay','Shipwrecks','',1.00,1.60,40.00,12.19,60.00,18.28,'None','Beginning');
INSERT INTO SITES VALUES (3006,3.00,'Carmel River Beach','Marine Life','',2.00,3.21,40.00,12.19,40.00,12.19,'Surge','Intermediate');
INSERT INTO SITES VALUES (3004,3.00,'Monastery Beach','Marine Life','',3.00,4.82,50.00,15.24,40.00,12.19,'Surge','Beginning');
INSERT INTO SITES VALUES (3003,3.00,'Pinnacles','Pinnacle','',1.00,1.60,60.00,18.28,50.00,15.24,'Mild','Beginning');
INSERT INTO SITES VALUES (3002,3.00,'Macabee Beach','Marine Life','',0.10,0.16,40.00,12.19,40.00,12.19,'None','Beginning');
INSERT INTO SITES VALUES (3001,3.00,'Point Lobos','Marine Life','',3.00,4.82,60.00,18.28,75.00,22.86,'None','Beginning');
INSERT INTO SITES VALUES (2005,2.00,'Watanabe','Marine Life','',130.00,209.21,150.00,45.72,200.00,60.96,'None','Intermediate');
INSERT INTO SITES VALUES (2004,2.00,'Wheeler Reef','Marine Life','',30.00,48.28,50.00,15.24,125.00,38.10,'Mild','Beginning');
INSERT INTO SITES VALUES (2003,2.00,'Butterfly Bay','Caves','',20.00,32.18,70.00,21.33,70.00,21.33,'None','Advanced');
INSERT INTO SITES VALUES (2002,2.00,'Cod Hole','Fish','',45.00,72.42,50.00,15.24,150.00,45.72,'Mild','Beginning');
INSERT INTO SITES VALUES (2001,2.00,'Heron Island','Reef','',50.00,80.46,90.00,27.43,150.00,45.72,'Mild','Intermediate');
INSERT INTO SITES VALUES (1005,1.00,'Yocab Reef','Reef','',6.00,9.65,50.00,15.24,100.00,30.48,'Mild','Beginning');
INSERT INTO SITES VALUES (1004,1.00,'Punta Sur','Reef','',13.00,20.92,120.00,36.57,175.00,53.34,'Strong','Advanced');
INSERT INTO SITES VALUES (1003,1.00,'Chancanab Reef','Reef','',4.00,6.43,60.00,18.28,100.00,30.48,'Mild','Beginning');
INSERT INTO SITES VALUES (1002,1.00,'Santa Rosa Reef','Reef','',8.00,12.87,80.00,24.38,150.00,45.72,'Strong','Intermediate');
INSERT INTO SITES VALUES (1001,1.00,'Palancar Reef','Reef','',10.00,16.09,100.00,30.48,150.00,45.72,'Strong','Intermediate');
INSERT INTO SITES VALUES (8000,8.00,'Ning Po','Shipwrecks','',1,1.609344,5,1.524,30,9.144,'Mild','Beginning');