/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('roles', function (Blueprint $table) {
$table->increments('id');
$table->string('name')->unique();
});
}
/**
* Run the migrations.
*/
public function up()
{
$this->schema->create('password_resets', function (Blueprint $table) {
$table->string('email')->index();
$table->string('token')->index();
$table->timestamp('created_at');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('ages', function (Blueprint $table) {
$table->increments('id');
$table->string('from');
$table->string('to');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('countries', function (Blueprint $table) {
$table->increments('id');
$table->string('code');
$table->string('name');
});
}
/**
* Do the migration
*/
public function up()
{
//Create
$this->schema->create('account_status', function ($table) {
$table->increments('id');
$table->string('value', 200);
$table->dateTime('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('notifications', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->string('body');
$table->dateTime('release_date');
$table->timestamps();
});
}
/**
* Install the extensions table.
*/
public function handle()
{
$this->schema->dropIfExists('addons_extensions');
$this->schema->create('addons_extensions', function (Blueprint $table) {
$table->increments('id');
$table->string('slug');
$table->boolean('installed')->default(0);
$table->boolean('enabled')->default(0);
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('user_roles', function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id')->unsigned()->index();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->integer('role_id')->unsigned()->index();
$table->foreign('role_id')->references('id')->on('roles')->onDelete('cascade');
});
}
/**
* Do the migration
*/
public function up()
{
$this->schema->create('posts', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->text('content');
$table->timestamps();
$table->softDeletes();
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Do the migration
*/
public function up()
{
//Create table
$this->schema->create('ci_sessions', function ($table) {
$table->string('session_id', 40);
$table->string('ip_address', 45);
$table->string('user_agent', 120);
$table->integer('last_activity')->unsigned();
$table->text('user_data');
});
}
/**
* Run the migrations.
*/
public function up()
{
$this->schema->create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password');
$table->rememberToken();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('products', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('code')->unique();
$table->string('image');
$table->string('poster');
$table->timestamps();
});
}
/**
* Do the migration
*/
public function up()
{
//Creates contents table
$this->schema->create('contents', function ($table) {
$table->increments('id');
$table->string('title');
$table->text('text');
$table->timestamps();
$table->softDeletes();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('profiles', function (Blueprint $table) {
$table->increments('id');
$table->string('image');
$table->longText('description');
$table->integer('product_id')->unsigned()->index();
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');
$table->timestamps();
});
}
/**
* Do the migration
*/
public function up()
{
$this->schema->create('likes', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('resourceable_type');
$table->string('resourceable_id');
$table->timestamps();
$table->softDeletes();
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Run migrations for tables only used for testing purposes.
*
* @return void
*/
protected function runTestMigrations()
{
include_once __DIR__ . '/../resources/migrations/create_adjustments_table.php.stub';
(new \CreateAdjustmentsTable())->up();
if (!$this->schema->hasTable('fruits')) {
$this->schema->create('fruits', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->integer('price');
});
}
}
/**
* Do the migration
*/
public function up()
{
//Create the table
$this->schema->create('account_verification_tokens', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('token', 100);
$table->enum('status', ['active', 'expired']);
$table->dateTime('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('help', function (Blueprint $table) {
$table->increments('id');
$table->string('route');
$table->string('route_parameters')->nullable();
$table->string('description')->nullable();
$table->longText('parameters')->nullable();
$table->longText('response')->nullable();
$table->longText('response_error')->nullable();
});
}
/**
* Do the migration
*/
public function up()
{
//Create user details table
$this->schema->create('user_details', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->text('hobbies');
$table->text('interests');
$table->text('about');
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Do the migration
*/
public function up()
{
//Create table
$this->schema->create('contact_messages', function ($table) {
$table->increments('id');
$table->string('first_name');
$table->string('last_name');
$table->string('email');
$table->text('message');
$table->timestamps();
$table->softDeletes();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('codes', function (Blueprint $table) {
$table->increments('id');
$table->integer('product_id')->unsigned()->index();
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');
$table->integer('user_id')->unsigned()->index()->nullable();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->string('code')->unique();
$table->boolean('status')->default(false);
$table->timestamps();
});
}
/**
* Create translations table.
*
* @param $table
* @param $foreignKey
*/
public function createTranslationsTable($table)
{
$this->schema->dropIfExists($table);
$this->schema->create($table, function (Blueprint $table) {
$table->increments('id');
$table->integer('entry_id');
$table->datetime('created_at');
$table->integer('created_by')->nullable();
$table->datetime('updated_at')->nullable();
$table->integer('updated_by')->nullable();
$table->string('locale')->index();
});
}
/**
* Do the migration
*/
public function up()
{
//Create eduction table
$this->schema->create('user_educations', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('institution_name');
$table->string('major');
$table->string('year_joined');
$table->string('year_left')->nullable();
$table->boolean('is_current');
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$this->schema->create('jobs', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('queue');
$table->longText('payload');
$table->tinyInteger('attempts')->unsigned();
$table->tinyInteger('reserved')->unsigned();
$table->unsignedInteger('reserved_at')->nullable();
$table->unsignedInteger('available_at');
$table->unsignedInteger('created_at');
$table->index(['queue', 'reserved', 'reserved_at']);
});
}
/**
* Do the migration
*/
public function up()
{
//Create user work table
$this->schema->create('user_works', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('job_title');
$table->string('company_name');
$table->dateTime('date_joined');
$table->dateTime('date_left')->nullable();
$table->boolean('is_current');
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Do the migration
*/
public function up()
{
//Create the table
$this->schema->create('users_basic_info', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('address');
$table->string('city');
$table->string('country');
$table->string('phone_number');
$table->text('emails');
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Do the migration
*/
public function up()
{
//Create the table
$this->schema->create('uom_valid_ids', function ($table) {
$table->string('id', 50);
$table->string('first_name', 100);
$table->string('last_name', 100);
$table->enum('type', ['student', 'lecturer']);
$table->timestamp('datetime')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->boolean('valide');
$table->boolean('has_account');
$table->primary('id');
});
}
/**
* Do the migration
*/
public function up()
{
//Create friends table
$this->schema->create('friends', function ($table) {
$table->increments('id');
$table->integer('user_id_1')->unsigned();
$table->integer('user_id_2')->unsigned();
$table->timestamps();
});
//Add foreign keys
$this->schema->table('friends', function ($table) {
$table->foreign('user_id_1')->references('id')->on('users');
$table->foreign('user_id_2')->references('id')->on('users');
});
}
/**
* Do the migration
*/
public function up()
{
//Create passwords table
$this->schema->create('passwords', function ($table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->string('code', 255);
$table->timestamps();
$table->softDeletes();
});
//Add foreign key to table
$this->schema->table('passwords', function ($table) {
$table->foreign('user_id')->references('id')->on('users');
});
}
/**
* Handle the event.
*
* @param AssignmentWasCreated $event
*/
public function handle(AssignmentWasCreated $event)
{
$assignment = $event->getAssignment();
$fieldType = $assignment->getFieldType();
if (!$fieldType instanceof FilesFieldType) {
return;
}
$table = $assignment->getStreamPrefix() . $assignment->getStreamSlug() . '_' . $fieldType->getField();
$this->schema->dropIfExists($table);
$this->schema->create($table, function (Blueprint $table) {
$table->integer('entry_id');
$table->integer('file_id');
$table->integer('sort_order')->nullable();
$table->primary(['entry_id', 'file_id']);
});
}