<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateAdminUpload extends Migration { public function up() { Schema::create('admin_upload', function (Blueprint $Y2RbY) { $Y2RbY->increments('id'); $Y2RbY->timestamps(); $Y2RbY->integer('userId')->nullable()->comment('用户ID'); $Y2RbY->string('category', 10)->nullable()->comment('大类'); $Y2RbY->integer('dataId')->nullable()->comment('文件ID'); $Y2RbY->integer('uploadCategoryId')->nullable()->comment('分类ID'); $Y2RbY->index(array('uploadCategoryId')); $Y2RbY->index(array('userId', 'category')); }); Schema::create('admin_upload_category', function (Blueprint $Y2RbY) { $Y2RbY->increments('id'); $Y2RbY->timestamps(); $Y2RbY->integer('userId')->nullable()->comment('用户ID'); $Y2RbY->string('category', 10)->nullable()->comment('大类'); $Y2RbY->integer('pid')->nullable()->comment('上级分类'); $Y2RbY->integer('sort')->nullable()->comment('排序'); $Y2RbY->string('title', 50)->nullable()->comment('名称'); $Y2RbY->index(array('userId', 'category')); }); } public function down() { } }