TP5创建动态数据表

            $sql = " CREATE TABLE IF NOT EXISTS `$table_name` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int (11) DEFAULT NULL COMMENT 'user_id',
`url` VARCHAR (255) DEFAULT '' COMMENT '地址',
`params` text (0) DEFAULT '' ,
`response` text (0) DEFAULT '' ,
`created_at` VARCHAR (45) NOT NULL COMMENT '时间',
`type` VARCHAR (45) NOT NULL  COMMENT '类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='表';";
           Db::execute($sql);

转载于:https://www.cnblogs.com/ali1012/p/10637047.html