db.sql

-- create database `db_api-server`;

use `dev_db`;

drop table if exists `tb_users`;

--
-- Table structure for table `tb_users`
--

create table `tb_users`(
	`id` bigint(20) unsigned not null auto_increment,
    `username` varchar(255) not null,
    `password` varchar(255) not null,
    `createdAt` timestamp null default null,
    `updatedAt` timestamp null default null,
    `deletedAt` timestamp null default null,
    primary key(`id`),
    unique key `username`(`username`),
    key `idx_tb_users_deletedAt` (`deletedAt`)
) engine=MyISAM auto_increment=1 default charset=utf8;


--
-- Dumping data for table `tb_users`
--

lock tables `tb_users` write;
insert into `tb_users` values(0, 'admin', '$2a$10$veGcArz47VGj7l9xN7g2iuT9TF21jLI1YGXarGzvARNdnt4inC9PG','2018-05-27 16:25:33','2018-05-27 16:25:33',NULL);
unlock tables;

use dev_db;

drop table `tb_files`;

create table if not exists `tb_files`(
	`id` bigint(20) unsigned not null primary key auto_increment,
    `createdAt` timestamp null default null
    `name` varchar(255) not null,
    `key` varchar(255) not null,
    `bucket` varchar(255) not null,
    `size` int,
    `mimeType` varchar(255) not null,
)