X hits on this document

138 views

0 shares

0 downloads

0 comments

31 / 70

CREATE TABLE `animals` (

 `id` int(11) NOT NULL auto_increment,

 `name` varchar(35) NOT NULL,

 `email` varchar(40) default NULL,

 `fav_beer` enum('Guiness','Pabst','Redhook','Chimay')

     default 'Pabst',

 `species_id` int(11) default NULL,

 `created_at` datetime default NULL,

 `updated_at` datetime default NULL,

 `password` varchar(25) character set latin1 collate

    latin1_bin NOT NULL,

 PRIMARY KEY  (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Primary Keys

CREATE TABLE `species` (  `id` int(11) NOT NULL auto_increment,  `name` varchar(255),  PRIMARY KEY  (`id`), ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

Document info
Document views138
Page views138
Page last viewedSat Dec 03 05:04:29 UTC 2016
Pages70
Paragraphs654
Words2352

Comments