q2XzL1sC

1DROP TABLE IF EXISTS `user`;
2
3CREATE TABLE `user` (
4  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
5  `name` VARCHAR(50) NOT NULL DEFAULT '',
6  `email` VARCHAR(100) NOT NULL DEFAULT '',
7  `password` CHAR(60) NOT NULL DEFAULT '', /* Use PHP's password_hash() */
8  `display_name` VARCHAR(191) NOT NULL DEFAULT '',
9  `url` VARCHAR(191) NOT NULL DEFAULT '',
10  `registered_at` DATETIME NULL DEFAULT NULL,
11  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
12  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
13  PRIMARY KEY (`id`),
14  UNIQUE INDEX (`name`),
15  UNIQUE INDEX (`email`)
16) ENGINE=InnoDB;