begin;
create table `leads` (
    `id`        integer auto_increment not null primary key,
    `created`   timestamp default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `firstname` varchar(48)   not null,
    `lastname`  varchar(48)   not null,
    `email`     varchar(128)  not null,
    `phone`     varchar(24)   not null,
    `address`   varchar(128)  not null,
    `city`      varchar(128)  not null,
    `state`     varchar(48)   not null,
    `zip`       varchar(16)   not null,
    `comments`  text          not null,
    `source`    varchar(36)   not null,
    `medium`    varchar(36)   not null,
    `campaign`  varchar(36)   not null,
    `keywords`  varchar(128)   not null
);
commit;