private function migrateTables() { Schema::create('users', function ($table) { $table->increments('id'); $table->string('username'); $table->timestamps(); }); Schema::create('posts', function ($table) { $table->integer('user_id')->unsigned()->nullable(); $table->increments('id'); $table->string('title'); $table->text('description'); $table->timestamps(); $table->foreign('user_id')->references('id')->on('users')->onUpdate('restrict')->onDelete('set null'); }); Schema::create('revisions', function ($table) { $table->increments('id'); $table->string('revisionable_type'); $table->integer('revisionable_id'); $table->integer('user_id')->nullable(); $table->string('key'); $table->text('old_value')->nullable(); $table->text('new_value')->nullable(); $table->timestamps(); $table->index(['revisionable_id', 'revisionable_type']); }); }
public function createSchema() { if (!DbSchema::hasTable('sessions')) { try { DbSchema::create('sessions', function ($table) { $table->string('id')->unique(); $table->longText('payload'); $table->integer('last_activity'); }); } catch (QueryException $e) { } } $exec = $this->getSystemSchemas(); $builder = new DbUtils(); foreach ($exec as $data) { // Creates the schema if (!method_exists($data, 'get')) { break; } $schemaArray = $data->get(); if (!is_array($schemaArray)) { break; } foreach ($schemaArray as $table => $columns) { $builder->build_table($table, $columns); } } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('articles', function (Blueprint $table) { $table->increments('id'); $table->unsignedInteger('category_id')->index(); $table->string('title')->index(); $table->string('alias')->index(); $table->string('author_alias')->nullable()->index(); $table->string('blade_template')->nullable(); $table->text('body')->nullable(); $table->dateTime('publish_up')->nullable(); $table->dateTime('publish_down')->nullable(); $table->text('parameters')->nullable(); $table->unsignedInteger('order')->default(1); $table->integer('hits')->default(0); $table->boolean('published')->default(false)->index(); $table->boolean('authenticated')->default(false); $table->boolean('featured')->default(false); $table->string('authorization', 20)->default('can'); $table->unsignedInteger('created_by')->nullable()->index(); $table->unsignedInteger('updated_by')->nullable()->index(); $table->timestamps(); $table->foreign('category_id')->references('id')->on('categories'); }); Schema::create('article_permission', function (Blueprint $table) { $table->unsignedInteger('article_id')->index(); $table->unsignedInteger('permission_id')->index(); $table->foreign('article_id')->references('id')->on('articles')->onDelete('cascade'); $table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade'); }); }
public function up() { Schema::create('addresses', function (Blueprint $table) { $table->increments('id'); $table->morphs('addressable'); $table->integer('country_id')->unsigned()->index(); $table->string('organization')->nullable(); $table->string('name_prefix'); $table->string('name_suffix')->nullable(); $table->string('first_name'); $table->string('last_name'); $table->string('street'); $table->string('building_number')->nullable(); $table->string('building_flat')->nullable(); $table->string('city'); $table->string('city_prefix')->nullable(); $table->string('city_suffix')->nullable(); $table->string('state')->nullable(); $table->string('state_code')->nullable(); $table->string('postcode'); $table->string('phone')->nullable(); $table->float('lat')->nullable(); $table->float('lng')->nullable(); foreach (config('addressable.flags', []) as $flag) { $table->boolean('is_' . $flag)->default(false)->index(); } $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email')->unique(); $table->string('password'); $table->boolean('active'); $table->boolean('banned'); $table->string('register_ip'); $table->string('country_code'); $table->string('locale'); $table->string('activation_key'); $table->boolean('su'); $table->rememberToken(); $table->timestamps(); }); $user = \Laralum::newUser(); $user->name = env('USER_NAME', 'admin'); $user->email = env('USER_EMAIL', '*****@*****.**'); $user->password = bcrypt(env('USER_PASSWORD', 'admin123')); $user->active = true; $user->banned = false; $user->register_ip = ""; $user->country_code = env('USER_COUNTRY_CODE', 'ES'); $user->locale = env('USER_LOCALE', 'en'); $user->activation_key = str_random(25); $user->su = true; $user->save(); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('attachments', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('path'); $table->string('extension', 20); $table->integer('uploaded_to'); $table->boolean('external'); $table->integer('order'); $table->integer('created_by'); $table->integer('updated_by'); $table->index('uploaded_to'); $table->timestamps(); }); // Get roles with permissions we need to change $adminRoleId = DB::table('roles')->where('system_name', '=', 'admin')->first()->id; // Create & attach new entity permissions $ops = ['Create All', 'Create Own', 'Update All', 'Update Own', 'Delete All', 'Delete Own']; $entity = 'Attachment'; foreach ($ops as $op) { $permissionId = DB::table('role_permissions')->insertGetId(['name' => strtolower($entity) . '-' . strtolower(str_replace(' ', '-', $op)), 'display_name' => $op . ' ' . $entity . 's', 'created_at' => \Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => \Carbon\Carbon::now()->toDateTimeString()]); DB::table('permission_role')->insert(['role_id' => $adminRoleId, 'permission_id' => $permissionId]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('oauth_grants', function (Blueprint $t) { $t->string('id', 40)->primary(); $t->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('notification_types', function (Blueprint $table) { $table->increments('id'); $table->string('type'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create($this->getTableName(), function (Blueprint $table) { $table->string('id', 191); $table->text('value')->nullable(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('profesor', function (Blueprint $table) { $table->integer('pro_tipo'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('site_visits', function (Blueprint $table) { $table->increments('id'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('posts', function (Blueprint $table) { $table->engine = 'InnoDB'; $table->increments('id'); $table->integer('user_id')->unsigned(); $table->string('title', 191); $table->string('slug', 191)->unique(); $table->string('type', 10); $table->string('media', 191); $table->string('thumbnail', 191); $table->string('featured', 191); $table->boolean('safe')->default(true); $table->boolean('resized')->default(false); $table->boolean('reported')->default(false); $table->string('source', 191)->nullable(); // Cache fields $table->integer('reports')->default(0)->unsigned(); $table->integer('comments')->default(0)->unsigned(); $table->integer('likes')->default(0)->unsigned(); $table->integer('dislikes')->default(0)->unsigned(); $table->integer('points')->default(0); $table->timestamps(); $table->softDeletes(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('categories', function (Blueprint $table) { $table->increments('id'); $table->string('name'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('roles', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('label')->nullable(); $table->text('description')->nullable(); $table->nullableTimestamps(); }); Schema::create('permissions', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('label')->nullable(); $table->text('description')->nullable(); $table->nullableTimestamps(); }); Schema::create('permission_role', function (Blueprint $table) { $table->integer('permission_id')->unsigned(); $table->integer('role_id')->unsigned(); $table->foreign('permission_id')->references('id')->on('permissions')->onDelete('cascade'); $table->foreign('role_id')->references('id')->on('roles')->onDelete('cascade'); $table->primary(['permission_id', 'role_id']); }); Schema::create('role_user', function (Blueprint $table) { $table->integer('role_id')->unsigned(); $table->integer('user_id')->unsigned(); $table->foreign('role_id')->references('id')->on('roles')->onDelete('cascade'); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->primary(['role_id', 'user_id']); }); }
/** * Run the migrations. */ public function up() { Schema::create('comments', function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->text('message'); $t->string('commentable_type'); $t->integer('commentable_id'); $t->integer('author_id'); $t->timestamps(); $t->integer('project_id'); $t->string('attachment')->nullable(); $t->string('line_code')->nullable(); $t->string('commit_id')->nullable(); $t->boolean('system')->default(false); $t->text('st_diff')->nullable(); $t->integer('updated_by_id')->nullable(); $t->boolean('is_award')->default(false); $t->softDeletes(); $t->index('author_id'); $t->index('commit_id'); $t->index(['created_at', 'id']); $t->index('created_at'); $t->index('is_award'); $t->index('line_code'); $t->index(['commentable_id', 'commentable_type']); $t->index('commentable_type'); $t->index(['project_id', 'commentable_type']); $t->index('project_id'); $t->index('updated_at'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->integer('idUser'); $table->string('firstname'); $table->string('name'); $table->string('email')->unique(); $table->string('phone'); $table->string('fixphone'); $table->string('street'); $table->integer('codePostal'); $table->string('town'); $table->string('country'); $table->date('birthday'); $table->string('statut'); $table->integer('idGie'); $table->integer('idGaec'); $table->float('tauxHoraire'); $table->string('type'); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('administradors', function (Blueprint $table) { $table->integer('adm_tipo'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('administrator_user', function (Blueprint $table) { $table->increments('id'); $table->string('status_instance')->default('active'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('picture_types', function (Blueprint $table) { $table->increments('id'); $table->string('type_name'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('account_teams', function (Blueprint $table) { $table->increments('id'); $table->integer('account_id', false, true); $table->foreign('account_id', 'teams_to_accounts')->references('id')->on('accounts')->onDelete('cascade'); $table->timestamps(); }); Schema::create('account_teams_translations', function (Blueprint $table) { $table->increments('id'); $table->integer('team_id', false, true); $table->foreign('team_id', 'translations_to_teams')->references('id')->on('account_teams')->onDelete('cascade'); $table->string('locale', 5); $table->string('name'); $table->text('description'); $table->timestamps(); }); Schema::create('account_team_memberships', function (Blueprint $table) { $table->integer('team_id', false, true); $table->foreign('team_id', 'team_membership_to_team')->references('id')->on('account_teams')->onDelete('cascade'); $table->integer('membership_id', false, true); $table->foreign('membership_id', 'team_membership_to_membership')->references('id')->on('account_memberships')->onDelete('cascade'); $table->timestamps(); }); //install the module itself. $module = Module::create(['namespace' => 'team', 'nl' => ['name' => 'Team'], 'en' => ['name' => 'Team'], 'fr' => ['name' => 'Team'], 'de' => ['name' => 'Team']]); $module->routes()->save(new ModuleRoute(['name' => 'store.team.index', 'nl' => ['title' => 'team'], 'en' => ['title' => 'team'], 'fr' => ['title' => 'team'], 'de' => ['title' => 'team']])); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('laravel_sms', function (Blueprint $table) { $table->increments('id'); //to:用于存储手机号 $table->string('to')->default(''); //temp_id:存储模板标记,用于存储任何第三方服务商提供的短信模板标记/id $table->string('temp_id')->default(''); //data:模板短信的模板数据,建议json格式 $table->string('data')->default(''); //content:内容 $table->string('content')->default(''); //voice_code:语言验证码code $table->string('voice_code')->default(''); //发送失败次数 $table->mediumInteger('fail_times')->default(0); //最后一次发送失败时间 $table->integer('last_fail_time')->unsigned()->default(0); //发送成功时的时间 $table->integer('sent_time')->unsigned()->default(0); //代理器使用日志,记录每个代理器的发送状态,可用于排错 $table->text('result_info'); $table->timestamps(); $table->softDeletes(); $table->engine = 'InnoDB'; //说明 //1:temp_id和data用于发送模板短信。 //2:content用于直接发送短信内容,不使用模板。 //3:voice_code用于存储语言验证码code。 }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('entities', function (Blueprint $table) { $table->string('name')->unique()->primary(); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('user_role', function ($t) { $t->integer('user_id')->unsigned(); $t->integer('role_id')->unsigned(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('settings', function (Blueprint $table) { $table->string('key')->unique(); $table->string('value'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('services', function (Blueprint $table) { $table->increments('idService'); $table->string('LibelleService'); }); }
public static function setUpBeforeClass() { if (!isset(self::$app)) { self::$app = AppFactory::create(); } if (!Schema::hasTable('users')) { Schema::create('users', function ($table) { $table->increments('id'); $table->string('name'); }); } DB::insert('insert into users (name) values (?)', array('Test User')); if (!Schema::hasTable('posts')) { Schema::create('posts', function ($table) { $table->increments('id'); $table->string('title'); $table->integer('created_by')->unsigned()->nullable(); $table->integer('updated_by')->unsigned()->nullable(); $table->integer('deleted_by')->unsigned()->nullable(); $table->timestamps(); $table->timestamp('deleted_at')->nullable(); $table->foreign('created_by')->references('id')->on('users'); $table->foreign('updated_by')->references('id')->on('users'); $table->foreign('deleted_by')->references('id')->on('users'); }); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('media', function (Blueprint $table) { $table->increments('id'); $table->string('disk', 32); $table->string('directory'); $table->string('filename'); $table->string('extension', 32); $table->string('mime_type', 128); $table->string('aggregate_type', 32); $table->integer('size')->unsigned(); $table->timestamps(); $table->index(['disk', 'directory']); $table->unique(['disk', 'directory', 'filename', 'extension']); $table->index('aggregate_type'); }); Schema::create('mediables', function (Blueprint $table) { $table->integer('media_id')->unsigned(); $table->string('mediable_type'); $table->integer('mediable_id')->unsigned(); $table->string('tag'); $table->integer('order')->unsigned(); $table->primary(['media_id', 'mediable_type', 'mediable_id', 'tag']); $table->index(['mediable_id', 'mediable_type']); $table->index('tag'); $table->index('order'); $table->foreign('media_id')->references('id')->on('media')->onDelete('cascade'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('nota_docentes', function (Blueprint $table) { $table->increments('id'); $table->integer('id_cursante')->unsigned(); $table->integer('id_docente')->unsigned(); $table->integer('materia_id')->unsigned(); $table->integer('ua_id')->unsigned(); $table->integer('indicador1'); $table->integer('indicador2'); $table->integer('indicador3'); $table->integer('indicador4'); $table->integer('indicador5'); $table->integer('indicador6'); $table->integer('indicador7'); $table->integer('indicador8'); $table->integer('indicador9'); $table->integer('indicador10'); $table->integer('indicador11'); $table->integer('indicador12'); $table->integer('indicador13'); $table->integer('indicador14'); $table->integer('indicador15'); $table->integer('indicador16'); $table->integer('indicador17'); $table->integer('indicador18'); $table->integer('indicador19'); $table->integer('indicador20'); $table->timestamps(); $table->foreign('materia_id')->references('id')->on('materias')->onDelete('restrict')->onUpdate('cascade'); $table->foreign('ua_id')->references('id')->on('unidad_academicas')->onDelete('restrict')->onUpdate('cascade'); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('languages', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->string('short_two'); $table->string('short_three'); $table->timestamps(); }); Schema::create('groups', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('group_id')->nullable()->comment('Refer to self for multidimensional groups'); $table->timestamps(); }); Schema::create('names', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('group_id'); $table->timestamps(); }); Schema::create('values', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('language_id'); $table->integer('name_id'); $table->timestamps(); }); }
public function up() { Schema::create('Competitor', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('surname'); $table->integer('userId')->unsigned(); $table->integer('clubId')->unsigned(); $table->string('picture'); $table->timestamps(); $table->foreign('userId')->references('id')->on('Users')->onDelete('cascade'); $table->foreign('clubId')->references('id')->on('Club')->onDelete('cascade'); // // $table->foreign('shiaiCategoryId') // ->references('id') // ->on('ShiaiCategory') // ->onDelete('cascade'); // // // $table->foreign('tournamentId') // ->references('id') // ->on('Tournament') // ->onDelete('cascade'); }); }