DPHtQ3St

1CREATE TABLE IF NOT EXISTS `users` (
2    `id`               BIGINT(20) NOT NULL AUTO_INCREMENT,
3    `email`            VARCHAR(255) NOT NULL DEFAULT '',
4    `password`         VARCHAR(255) NOT NULL DEFAULT '',
5    `country_code`     CHAR(4) NOT NULL DEFAULT '',
6    `industry`         VARCHAR(255) NOT NULL DEFAULT '',
7    `company_size`     VARCHAR(255) NOT NULL DEFAULT '',
8    `company_name`     VARCHAR(255) NOT NULL DEFAULT '',
9    `last_name`        VARCHAR(255) NOT NULL DEFAULT '',
10    `first_name`       VARCHAR(255) NOT NULL DEFAULT '',
11    `newsletter`       TINYINT(1) NOT NULL DEFAULT 0,
12    `company_website`  VARCHAR(255) NOT NULL DEFAULT '',
13    `job_title`        VARCHAR(255) NOT NULL DEFAULT '',
14    `profile_picture`  VARCHAR(255) NOT NULL DEFAULT '',
15    `verified`         TINYINT(1) NOT NULL DEFAULT 0,
16    `p_updated_time`   INT NOT NULL DEFAULT 0,
17    `created`          TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
18    `updated`          TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
19    PRIMARY KEY (`id`),
20    UNIQUE KEY (`email`)
21)ENGINE = InnoDB DEFAULT CHARSET=UTF8;