forked from ebhomengo/niki
13 lines
615 B
MySQL
13 lines
615 B
MySQL
|
-- +migrate Up
|
||
|
|
CREATE TABLE `refer_times` (
|
||
|
|
`id` INT PRIMARY KEY AUTO_INCREMENT,
|
||
|
|
`duration` VARCHAR(191) NOT NULL,
|
||
|
|
`status` ENUM('active','inactive') NOT NULL DEFAULT 'active',
|
||
|
|
|
||
|
|
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
`deleted_at` TIMESTAMP
|
||
|
|
);
|
||
|
|
|
||
|
|
-- +migrate Down
|
||
|
|
DROP TABLE `refer_times`;
|