<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateAdminTables extends Migration
{
/**
* {@inheritdoc}
*/
public function getConnection()
{
return config('admin.database.connection') ?: config('database.default');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(config('admin.database.users_table'), function (Blueprint $table) {
$table->increments('id');
$table->string('username', 190)->unique();
$table->string('password', 60);
$table->string('name');
$table->string('email',100)->nullable();
$table->string('avatar')->nullable();
$table->bigInteger('autoflg')->default(0)->nullable();
$table->string('token', 255)->nullable();
$table->string('oid', 255)->nullable();
$table->string('remember_token', 100)->nullable();
$table->timestamps();
});
Schema::create(config('admin.database.roles_table'), function (Blueprint $table) {
$table->increments('id');
$table->string('name', 50)->unique();
$table->string('slug', 50)->unique();
$table->timestamps();
});
Schema::create(config('admin.database.permissions_table'), function (Blueprint $table) {
$table->increments('id');
$table->string('name', 50)->unique();
$table->string('slug', 50)->unique();
$table->string('http_method')->nullable();
$table->text('http_path')->nullable();
$table->timestamps();
});
Schema::create(config('admin.database.menu_table'), function (Blueprint $table) {
$table->increments('id');
$table->integer('parent_id')->default(0);
$table->integer('order')->default(0);
$table->string('title', 50);
$table->string('icon', 50);
$table->string('uri', 50)->nullable();
$table->string('permission')->nullable();
$table->timestamps();
});
Schema::create(config('admin.database.role_users_table'), function (Blueprint $table) {
$table->integer('role_id');
$table->integer('user_id');
$table->index(['role_id', 'user_id']);
$table->timestamps();
});
Schema::create(config('admin.database.role_permissions_table'), function (Blueprint $table) {
$table->integer('role_id');
$table->integer('permission_id');
$table->index(['role_id', 'permission_id']);
$table->timestamps();
});
Schema::create(config('admin.database.user_permissions_table'), function (Blueprint $table) {
$table->integer('user_id');
$table->integer('permission_id');
$table->index(['user_id', 'permission_id']);
$table->timestamps();
});
Schema::create(config('admin.database.role_menu_table'), function (Blueprint $table) {
$table->integer('role_id');
$table->integer('menu_id');
$table->index(['role_id', 'menu_id']);
$table->timestamps();
});
Schema::create(config('admin.database.operation_log_table'), function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id');
$table->string('path');
$table->string('method', 10);
$table->string('ip');
$table->text('input');
$table->index('user_id');
$table->timestamps();
});
Schema::create(config('admin.database.wbsdb_articles_table'), function (Blueprint $table) {
$table->increments('id');
$table->string('title', 255);
$table->string('flag', 30)->nullable();
$table->integer('parent_id')->default(0);
$table->string('keyword',255)->nullable();
$table->string('description',255)->nullable();
$table->text('content')->nullable();
$table->integer('hits')->default(50)->nullable();
$table->integer('favs')->default(0)->nullable();
$table->integer('status')->default(1)->nullable();
$table->string('conver',255)->nullable();
$table->integer('author_id')->default(1)->nullable();
$table->index(['parent_id', 'hits', 'status','author_id']);
$table->date('created_date')->nullable();
$table->timestamps();
$table->timestamp('deleted_at')->nullable();
});
Schema::create(config('admin.database.wbsdb_asks_table'), function (Blueprint $table) {
$table->increments('id');
$table->integer('parent_id')->default(0);
$table->integer('level')->default(0)->nullable();
$table->string('title', 255);
$table->string('thumb',255)->nullable();
$table->integer('hits')->default(50)->nullable();
$table->integer('comments')->default(0)->nullable();
$table->mediumText('content')->nullable();
$table->integer('quesid')->default(0)->nullable();
$table->integer('author_id')->default(0)->nullable();
$table->integer('hidden')->default(0)->nullable();
$table->integer('status')->default(1)->nullable();
$table->index(['parent_id', 'hits', 'status','author_id','quesid']);
$table->timestamps();
});
Schema::create(config('admin.database.wbsdb_categories_table'), function (Blueprint $table) {
$table->increments('id');
$table->integer('parent_id')->default(0)->nullable();
$table->integer('order')->default(1)->nullable();
$table->string('typename', 60);
$table->string('typedir', 30);
$table->string('title', 255)->nullable();
$table->string('keyword',255)->nullable();
$table->string('description',255)->nullable();
$table->text('content')->nullable();
$table->integer('mid')->default(1)->nullable();
$table->integer('status')->default(1)->nullable();
$table->integer('author_id')->default(0)->nullable();
$table->index(['parent_id', 'order', 'status','author_id','mid']);
$table->timestamps();
$table->timestamp('deleted_at')->nullable();
});
Schema::create(config('admin.database.wbsdb_companys_table'), function (Blueprint $table) {
$table->increments('id');
$table->string('combrand', 100)->unique();
$table->string('purl', 30);
$table->string('comname', 120);
$table->bigInteger('level')->default(0)->nullable();
$table->integer('status')->default(1)->nullable();
$table->bigInteger('vip')->default(0)->nullable();
$table->string('type', 100)->nullable();
$table->bigInteger('catid')->default(0)->nullable();
$table->bigInteger('parent_id')->default(0)->nullable();
$table->bigInteger('province')->default(0)->nullable();
$table->bigInteger('city')->default(0)->nullable();
$table->bigInteger('district')->default(0)->nullable();
$table->string('mode', 100)->nullable();
$table->bigInteger('capital')->default(0)->nullable();
$table->string('size', 100)->nullable();
$table->string('regyear', 30)->nullable();
$table->string('business', 255)->nullable();
$table->string('telephone', 50)->nullable();
$table->string('fax', 50)->nullable();
$table->string('mail', 50)->nullable();
$table->string('address', 255)->nullable();
$table->string('imagesarr'
没有合适的资源?快使用搜索试试~ 我知道了~
管理系统系列--laravel-admin码的B2B电子商务行业门户网站管理系统(前后端).zip
共266个文件
php:224个
jpg:15个
gitignore:12个
需积分: 5 0 下载量 86 浏览量
2024-02-25
23:25:15
上传
评论
收藏 1.62MB ZIP 举报
温馨提示
管理系统系列--laravel-admin码的B2B电子商务行业门户网站管理系统(前后端)
资源推荐
资源详情
资源评论
收起资源包目录
管理系统系列--laravel-admin码的B2B电子商务行业门户网站管理系统(前后端).zip (266个子文件)
artisan 2KB
default.css 4KB
.env.example 521B
.gitattributes 111B
.gitignore 138B
.gitignore 103B
.gitignore 23B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 14B
.gitignore 9B
10.jpg 343KB
14.jpg 300KB
11.jpg 287KB
15.jpg 272KB
12.jpg 238KB
13.jpg 168KB
1.jpg 96KB
4.jpg 68KB
2.jpg 63KB
5.jpg 56KB
3.jpg 54KB
7.jpg 46KB
9.jpg 46KB
6.jpg 44KB
8.jpg 43KB
bootstrap.js 2KB
app.js 607B
webpack.mix.js 549B
composer.json 2KB
package.json 1KB
composer.lock 249KB
README.md 126B
2016_01_04_173148_create_admin_tables.php 20KB
admin.php 13KB
PostController.php 12KB
app.php 9KB
index.blade.php 9KB
index.blade.php 9KB
Pcommon.php 8KB
_form.blade.php 8KB
ArticleController.php 8KB
CompanyDataController.php 7KB
session.php 7KB
info.blade.php 7KB
info.blade.php 7KB
validation.php 6KB
CompanyController.php 6KB
login.blade.php 5KB
SellController.php 5KB
admin.php 5KB
admin.php 5KB
admin.php 5KB
admin.php 5KB
CategorieController.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
web.php 4KB
admin.php 4KB
main.blade.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
admin.php 4KB
mail.php 4KB
MallController.php 4KB
mall_main.blade.php 4KB
main.blade.php 4KB
database.php 4KB
SellController.php 4KB
admin.php 4KB
PhotoController.php 4KB
NewController.php 4KB
info.blade.php 4KB
message.blade.php 3KB
register.blade.php 3KB
AskController.php 3KB
admin.php 3KB
CompanyController.php 3KB
app.blade.php 3KB
admin.php 3KB
reset.blade.php 3KB
auth.php 3KB
QuestionController.php 3KB
login.blade.php 3KB
list.blade.php 3KB
AutoArticleController.php 3KB
cate.blade.php 3KB
list.blade.php 3KB
共 266 条
- 1
- 2
- 3
资源评论
Kwan的解忧杂货铺
- 粉丝: 2w+
- 资源: 3699
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功