CREATE TABLE "BIOLIFE"
(
"SPECIES NO" FLOAT NOT NULL, /* number (chave primária)*/
"CATEGORY" VARCHAR(15), /* alpha */
"COMMON_NAME" VARCHAR(30), /* alpha */
"SPECIES NAME" VARCHAR(40), /* alpha */
"LENGTH (CM)" FLOAT, /* number */
"LENGTH_IN" FLOAT, /* number */
"NOTES" BLOB SUB_TYPE 1, /* memo */
"GRAPHIC" BLOB /* graphic */
);
ALTER TABLE "BIOLIFE" ADD CONSTRAINT "BIOLIFE_PRIMARY" PRIMARY KEY ("SPECIES NO");
/* Registros Importados de biolife.DB */
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90020', 'Triggerfish', 'Clown Triggerfish', 'Ballistoides conspicillum', '50', '19,6850393700787', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90030', 'Snapper', 'Red Emperor', 'Lutjanus sebae', '60', '23,6220472440945', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90050', 'Wrasse', 'Giant Maori Wrasse', 'Cheilinus undulatus', '229', '90,1574803149606', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90070', 'Angelfish', 'Blue Angelfish', 'Pomacanthus nauarchus', '30', '11,8110236220472', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90080', 'Cod', 'Lunartail Rockcod', 'Variola louti', '80', '31,496062992126', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90090', 'Scorpionfish', 'Firefish', 'Pterois volitans', '38', '14,9606299212598', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90100', 'Butterflyfish', 'Ornate Butterflyfish', 'Chaetodon Ornatissimus', '19', '7,48031496062992', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90110', 'Shark', 'Swell Shark', 'Cephaloscyllium ventriosum', '102', '40,1574803149606', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90120', 'Ray', 'Bat Ray', 'Myliobatis californica', '56', '22,0472440944882', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90130', 'Eel', 'California Moray', 'Gymnothorax mordax', '150', '59,0551181102362', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90140', 'Cod', 'Lingcod', 'Ophiodon elongatus', '150', '59,0551181102362', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90150', 'Sculpin', 'Cabezon', 'Scorpaenichthys marmoratus', '99', '38,9763779527559', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90160', 'Spadefish', 'Atlantic Spadefish', 'Chaetodiperus faber', '90', '35,4330708661417', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90170', 'Shark', 'Nurse Shark', 'Ginglymostoma cirratum', '400', '157,48031496063', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90180', 'Ray', 'Spotted Eagle Ray', 'Aetobatus narinari', '200', '78,740157480315', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90190', 'Snapper', 'Yellowtail Snapper', 'Ocyurus chrysurus', '75', '29,5275590551181', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90200', 'Parrotfish', 'Redband Parrotfish', 'Sparisoma Aurofrenatum', '28', '11,0236220472441', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90210', 'Barracuda', 'Great Barracuda', 'Sphyraena barracuda', '150', '59,0551181102362', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90220', 'Grunt', 'French Grunt', 'Haemulon flavolineatum', '30', '11,8110236220472', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90230', 'Snapper', 'Dog Snapper', 'Lutjanus jocu', '90', '35,4330708661417', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90240', 'Grouper', 'Nassau Grouper', 'Epinephelus striatus', '91', '35,8267716535433', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90250', 'Wrasse', 'Bluehead Wrasse', 'Thalassoma bifasciatum', '15', '5,90551181102362', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90260', 'Jack', 'Yellow Jack', 'Gnathanodon speciousus', '90', '35,4330708661417', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90270', 'Surfperch', 'Redtail Surfperch', 'Amphistichus rhodoterus', '40', '15,748031496063', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90280', 'Croaker', 'White Sea Bass', 'Atractoscion nobilis', '150', '59,0551181102362', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90290', 'Greenling', 'Rock Greenling', 'Hexagrammos lagocephalus', '60', '23,6220472440945', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90300', 'Wrasse', 'Senorita', 'Oxyjulis californica', '25', '9,84251968503937', NULL, NULL );
INSERT INTO "BIOLIFE" ("SPECIES NO", "CATEGORY", "COMMON_NAME", "SPECIES NAME", "LENGTH (CM)", "LENGTH_IN", "NOTES", "GRAPHIC" ) VALUES ('90310', 'Smelt', 'Surf Smelt', 'Hypomesus pretiosus', '25', '9,84251968503937', NULL, NULL ); |
FAQ
Pesquisar
Membros
Grupos
Registrar
Perfil
Entrar e ver Mensagens Particulares
Entrar
