Skip to content

members

Jump to bottom
jo-narae edited this page Jul 27, 2019 · 2 revisions 
CREATE TABLE `members` (
  `code` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `id` VARCHAR(255) UNIQUE NOT NULL,
  `password` TEXT NOT NULL,
  `token` TEXT DEFAULT NULL,
  `type` VARCHAR(30) DEFAULT NULL,
  `nickname` VARCHAR(255) DEFAULT NULL,
  `level` SMALLINT DEFAULT NULL,
  `created_at` DATETIME DEFAULT NULL,
  `updated_at` DATETIME DEFAULT NULL,
  `deleted_at` DATETIME DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Clone this wiki locally