github.com/EngineerKamesh/gofullstack@v0.0.0-20180609171605-d41341d7d4ee/volume3/section4/gopherface/config/gopherfacedb.sql (about)

     1  /* *****************************************************************************
     2  // Setup preferences
     3  // ****************************************************************************/
     4  SET NAMES utf8 COLLATE 'utf8_unicode_ci';
     5  SET time_zone = '-07:00';
     6  SET CHARACTER SET utf8;
     7  
     8  /* *****************************************************************************
     9  // Remove database (if it already exists)
    10  // ****************************************************************************/
    11  DROP DATABASE IF EXISTS gopherfacedb;
    12  
    13  /* *****************************************************************************
    14  // Create new database
    15  // ****************************************************************************/
    16  CREATE DATABASE gopherfacedb DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
    17  USE gopherfacedb;
    18  
    19  /* *****************************************************************************
    20  // Create the table(s)
    21  // ****************************************************************************/
    22  CREATE TABLE user (
    23      id TINYINT(1) UNSIGNED NOT NULL AUTO_INCREMENT,
    24  	username VARCHAR(18) NOT NULL,
    25  	uuid VARCHAR(64) NOT NULL,
    26      first_name VARCHAR(64) NOT NULL,
    27      last_name VARCHAR(64) NOT NULL,
    28      password_hash CHAR(64) NOT NULL,
    29      email VARCHAR(255) NOT NULL,
    30      created_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    31      updated_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    32  	UNIQUE (username),
    33      PRIMARY KEY (id)
    34  );