CREATE TABLE `lifeform` ( `lifeform_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(11) DEFAULT NULL, `genus` varchar(10) DEFAULT NULL, `species` varchar(14) DEFAULT NULL, `population` int(11) DEFAULT NULL, `wikipedia_url` varchar(49) DEFAULT NULL, `description` varchar(63) DEFAULT NULL, `image_filename` varchar(29) DEFAULT NULL, PRIMARY KEY (`lifeform_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1; INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('1','house cat','Felis','domesticus','5','http://en.wikipedia.org/wiki/Cats','','GEDC0658.JPG'); INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('2','White Oak','Quercus','alba','0','http://en.wikipedia.org/wiki/White_oak','Nice big eastern oak tree.','240px-Ancient_Oak.jpg'); INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('3','human','Homo','sapiens','2','http://en.wikipedia.org/wiki/Humans','Humans!','ditch.jpg'); INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('4','chicken','Gallus','gallus','0','http://en.wikipedia.org/wiki/Chickens','Descended from the Jungle Fowl of southeast Asia.','de_blue_hen_chicken.jpg'); INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('5','hedgehog','Atelerix','albiventris','0','http://en.wikipedia.org/wiki/Hedgehog','Spiny little bastards.','hh.jpg'); INSERT INTO gus_demo.lifeform(`lifeform_id`,`name`,`genus`,`species`,`population`,`wikipedia_url`,`description`,`image_filename`) VALUES('6','dog','Canis','familiaris','0','http://en.wikipedia.org/wiki/Dogs','Domesticated a shitload of years ago.','sun_eleanor.jpg');