/**
* 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.
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->increments('id');
$table->integer('account_id', false, true);
$table->foreign('account_id', 'post_to_account')->references('id')->on('accounts')->onDelete('cascade');
$table->integer('user_id', false, true);
$table->foreign('user_id', 'post_to_user')->references('id')->on('users')->onDelete('cascade');
$table->timestamps();
});
Schema::create('post_translations', function (Blueprint $table) {
$table->increments('id');
$table->integer('post_id', false, true);
$table->foreign('post_id', 'post_translation_to_post')->references('id')->on('posts')->onDelete('cascade');
$table->string('locale');
$table->string('title');
$table->text('content');
$table->text('cached_content');
$table->text('cached_extract');
$table->date('publish_at')->nullable()->index();
$table->timestamps();
});
//install the module itself.
$module = Module::create(['namespace' => 'blog', 'nl' => ['name' => 'Blog'], 'en' => ['name' => 'Blog'], 'fr' => ['name' => 'Blog'], 'de' => ['name' => 'Blog']]);
$module->routes()->save(new ModuleRoute(['name' => 'store.blog.index', 'nl' => ['title' => 'blog overview'], 'en' => ['title' => 'blog overview'], 'fr' => ['title' => 'blog overview'], 'de' => ['title' => 'blog overview']]));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('pages', function (Blueprint $table) {
$table->increments('id');
$table->integer('account_id', false, true);
$table->foreign('account_id', 'page_to_account')->references('id')->on('accounts')->onDelete('cascade');
$table->integer('parent_id', false, true)->nullable();
$table->foreign('parent_id', 'page_to_parent_page')->references('id')->on('pages')->onDelete('cascade');
$table->integer('user_id', false, true);
$table->foreign('user_id', 'page_to_user')->references('id')->on('users')->onDelete('cascade');
$table->smallInteger('sort');
$table->timestamps();
});
Schema::create('page_translations', function (Blueprint $table) {
$table->increments('id');
$table->integer('page_id', false, true);
$table->foreign('page_id', 'page_translation_to_page')->references('id')->on('pages')->onDelete('cascade');
$table->string('locale');
$table->string('title');
$table->text('content');
$table->text('cached_content');
$table->text('cached_extract');
$table->boolean('published');
$table->timestamps();
});
//install the module itself.
$module = Module::create(['namespace' => 'pages', 'nl' => ['name' => 'Pages'], 'en' => ['name' => 'Pages'], 'fr' => ['name' => 'Pages'], 'de' => ['name' => 'Pages']]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('portfolio_projects', function (Blueprint $table) {
$table->increments('id');
$table->integer('account_id', false, true);
$table->foreign('account_id', 'project_to_account')->references('id')->on('accounts')->onDelete('cascade');
$table->integer('client_id', false, true)->nullable();
$table->foreign('client_id', 'project_to_client')->references('id')->on('account_clients')->onDelete('cascade');
$table->date('date')->nullable();
$table->string('website');
$table->timestamps();
});
//install the module itself.
$module = Module::create(['namespace' => 'portfolio', 'nl' => ['name' => 'Portfolio'], 'en' => ['name' => 'Portfolio'], 'fr' => ['name' => 'Portfolio'], 'de' => ['name' => 'Portfolio']]);
$module->routes()->save(new ModuleRoute(['name' => 'store.portfolio.index', 'nl' => ['title' => 'portfolio overview'], 'en' => ['title' => 'portfolio overview'], 'fr' => ['title' => 'portfolio overview'], 'de' => ['title' => 'portfolio overview']]));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('contact_address', function (Blueprint $table) {
$table->increments('id');
$table->integer('owner_id', false, true);
$table->string('owner_type');
$table->string('firstname');
$table->string('lastname');
$table->string('street');
$table->string('box', 30);
$table->string('postcode');
$table->string('city');
$table->string('latitude');
$table->string('longitude');
$table->integer('country_id', false, true);
$table->foreign('country_id', 'contact_address_to_country')->references('id')->on('country');
$table->timestamps();
});
//install the module itself.
$module = Module::create(['namespace' => 'contact', 'nl' => ['name' => 'Contact'], 'en' => ['name' => 'Contact'], 'fr' => ['name' => 'Contact'], 'de' => ['name' => 'Contact']]);
$module->routes()->save(new ModuleRoute(['name' => 'store.contact.index', 'nl' => ['title' => 'contact'], 'en' => ['title' => 'contact'], 'fr' => ['title' => 'contact'], 'de' => ['title' => 'contact']]));
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$module = Module::create(['namespace' => 'shop', 'nl' => ['name' => 'Shop'], 'en' => ['name' => 'Shop'], 'fr' => ['name' => 'Shop'], 'de' => ['name' => 'Shop']]);
$module->routes()->save(new ModuleRoute(['name' => 'store.shop.index', 'nl' => ['title' => 'shopping home page'], 'fr' => ['title' => 'shopping home page'], 'en' => ['title' => 'shopping home page'], 'de' => ['title' => 'shopping home page']]));
}
/**
* Run the migrations.
*/
public function up()
{
//install the module itself.
$module = Module::create(['namespace' => 'marketing', 'nl' => ['name' => 'Marketing'], 'en' => ['name' => 'Marketing'], 'fr' => ['name' => 'Marketing'], 'de' => ['name' => 'Marketing']]);
}
