Online Suche im Handbuch

58.3 Tabelle 1a

CREATE TABLE contact (
  uid SMALLINT NOT NULL AUTO_INCREMENT,
  first_name CHAR(20),
  middle_initial CHAR(1),
  last_name CHAR(30),
  address_1 VARCHAR(100),
  address_2 VARCHAR(100),
  country VARCHAR(30),
  state CHAR(2),
  home_phone VARCHAR(30),
  work_phone VARCHAR(30),
  work_fax VARCHAR(30),
  cell_phone VARCHAR(30),
  email_normal VARCHAR(70),
  email_urgent VARCHAR(70),
  birthday CHAR(11),
  URL VARCHAR(80),
  PRIMARY KEY(uid),
  KEY(last_name,first_name),
  KEY(state),
  KEY(work_phone)
);

Online Suche im Handbuch