Miscellany

create table american_states (    id serial primary key,    abbreviation varchar(2),    fullname varchar(80),    index(id))type=InnoDB  ;create table countries (    id serial primary key,    name varchar(300),    fedex_code varchar(50),    ufsi_code varchar(3),    number_of_orders integer DEFAULT 0,    index(id)) type=InnoDB;create table facilities (    id serial primary key,    american_state_id integer,    name varchar(100),    url_name varchar(20),    address varchar(512),    city varchar(250),    zip varchar(8),    index(american_state_id),    FOREIGN KEY(american_state_id) REFERENCES american_states(id),    index(id)) type=INNODB ;