//
常用的数据库表设计,后续陆续添加吧,代码是laravel的migration。懒得换成sql了。
一,用户表
//start
Schema::create('users', function (Blueprint $table) {
$table->id();
$table->string('name')->nullable();
$table->string('nickname')->nullable();
$table->string('avatar')->nullable()->comment('头像');
$table->string('email')->nullable();
$table->timestamp('email_verified_at')->nullable();
$table->string('phone')->nullable();
$table->timestamp('phone_verified_at')->nullable();
$table->string('password');
$table->tinyInteger('vip')->default(0)->nullable()->comment('vip登记,0为不是vip,然后123');
$table->timestamp('vip_time')->nullable()->comment('会员到期时间');
$table->tinyInteger('fenxiao')->default(1)->nullable()->comment('分销等级,默认1,系统应该设置最高分销等级,一般默认3');
$table->string('price')->default(0)->nullable()->comment('余额');
$table->string('integral')->default(0)->nullable()->comment('积分');
$table->tinyInteger('state')->default(0)->comment('0未审核,1已审核');
$table->tinyInteger('is_admin')->default('0')->comment('0不是后台,1后台人员');
$table->string('register_ip')->default('')->comment('注册ip');
$table->string('last_ip')->default('')->comment('上次登陆ip');
$table->rememberToken();
$table->timestamps();
});
//over
二,栏目表
//
Schema::create('category', function (Blueprint $table) {
$table->id();
$table->string('title')->comment('栏目标题');
$table->string('ftitle')->nullable()->comment('栏目副标题');
$table->text('info')->nullable()->comment('栏目简介');
$table->mediumText('content')->nullable()->comment('content');
$table->string('thumb')->nullable()->comment('缩略图');
$table->string('banner')->nullable()->comment('栏目banner');
$table->integer('parent_id')->comment('上级栏目');
$table->tinyInteger('sort')->nullable()->comment('排序');
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->string('type')->nullable()->comment('栏目类型,case,article,page,img,imgs,');
$table->string('seotitle')->nullable()->comment('seo title');
$table->string('keywords')->nullable()->comment('keywords');
$table->string('description')->nullable()->comment('description');
$table->string('view')->nullable()->comment('模板文件名');
$table->string('external_links')->nullable()->comment('外部链接');
$table->softDeletes(); //软删除
$table->timestamps();
});
//
三,文章表
//
Schema::create('article', function (Blueprint $table) {
$table->id();
$table->string('title')->comment('文章标题');
$table->string('ftitle')->nullable()->comment('文章副标题');
$table->string('thumb','500')->nullable()->comment('缩略图');
$table->string('imgs','3000')->nullable()->comment('图集');
$table->integer('category_id')->nullable()->comment('所属栏目');
$table->integer('user_id')->nullable()->comment('用户id');
$table->text('info')->nullable()->comment('简介');
$table->mediumText('content')->nullable()->comment('content');
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->string('is_comment')->default('on')->nullable()->comment('off-不允许,on-允许评论');
$table->tinyInteger('sort')->default(100)->nullable()->comment('排序');
$table->tinyInteger('tuijian')->default(0)->nullable()->comment('推荐');
$table->tinyInteger('toutiao')->default(0)->nullable()->comment('头条');
$table->string('seotitle')->nullable()->comment('seo title');
$table->string('keywords')->nullable()->comment('keywords');
$table->string('description')->nullable()->comment('description');
$table->softDeletes(); //软删除
$table->timestamps();
});
//
四,tag表
//
Schema::create('tag', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('slug')->nullable();
$table->string('keywords',500)->nullable();
$table->string('description',500)->nullable();
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->timestamps();
});
Schema::create('article_tag', function (Blueprint $table) {
$table->id();
$table->integer('tag_id');
$table->integer('article_id');
$table->timestamps();
});
//
五,评论表
//
Schema::create('commont', function (Blueprint $table) {
$table->id();
$table->tinyInteger('user_id')->comment('会员id');
$table->tinyInteger('article_id')->nullable()->comment('文章id');
$table->tinyInteger('good_id')->nullable()->comment('商品id');
$table->string('parent_id')->nullable()->default(0)->comment('回复谁的');
$table->string('content',1000)->comment('回复的主体内容');
$table->string('re_mark',1000)->nullable()->comment('管理员回复的内容');
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->softDeletes(); //软删除
$table->timestamps();
});
//
六,友情链接
//
Schema::create('link', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('url','500')->nullable();
$table->tinyInteger('sort')->nullable();
$table->tinyInteger('type')->nullable()->comment('链接分类,0都显示,1文字,2图片,');
$table->string('logo','500')->nullable()->comment('网站标志');
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->dateTime('overtime')->nullable()->comment('过期时间');
$table->timestamps();
});
//
七,网站site表
//
Schema::create('site', function (Blueprint $table) {
$table->id();
$table->string('key_name');
$table->string('value',1000);
$table->timestamps();
});
//
八,文件表
//
Schema::create('files', function (Blueprint $table) {
$table->id();
$table->string('state')->default('on')->nullable()->comment('状态,off关闭,on正常');
$table->string('location',500)->nullable()->comment('文件位置');
$table->string('type')->nullable()->comment('文件类型,img图片,');
$table->timestamps();
});
//
九,后台栏目表
//
Schema::create('admin_menus', function (Blueprint $table) {
$table->id();
$table->string('name')->comment('后台栏目,中文名称');
$table->string('css')->nullable()->comment('本栏目样式');
$table->string('url')->nullable()->comment('连接地址,也可以是外链,如果有,就用url,如果米有,就用route');
$table->string('route')->nullable()->comment('route名,也是permission的名称,添加一个栏目,就需要laravel-permission也添加一个permission。');
$table->integer('parent_id')->comment('上级栏目');
$table->string('info')->nullable()->comment('简介');
$table->integer('sort')->nullable()->comment('排序');
$table->string('state')->nullable()->comment('on,off,null');
$table->string('pinlei')->nullable()->comment('相同品类的栏目,如果相同,上级栏目展开,如果不是顶级栏目,品类自动跟随上级栏目');
$table->timestamps();
});
//