20171205.sql 584 B

12345678910111213
  1. CREATE TABLE `payment` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `user_id` int(11) NOT NULL,
  4. `pay_way` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付类型',
  5. `money` int(11) NOT NULL DEFAULT '0' COMMENT '充值金额,单位分',
  6. `status` int(11) NOT NULL DEFAULT '1' COMMENT '充值状态:1-成功',
  7. `created_at` datetime NOT NULL,
  8. `updated_at` datetime NOT NULL,
  9. PRIMARY KEY (`id`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  11. ALTER TABLE `user` ADD `remember_token` VARCHAR(256) NULL DEFAULT '' AFTER `status`;