All pastes #590214 Raw Edit

Anonymous

public text v1 · immutable
#590214 ·published 2007-06-26 12:57 UTC
rendered paste body
CREATE TABLE animals (
             grp ENUM('fish','mammal','bird') NOT NULL,
             id MEDIUMINT NOT NULL AUTO_INCREMENT,
             name CHAR(30) NOT NULL,
             PRIMARY KEY (grp,id)
             );