Ejemplos de Flarum\Database Migration::createTable en PHP

createTable() public static method

Create a table.

public static createTable ( $name, callable $definition )
$definition	callable

Ejemplo n.º 1

Archivo: 2015_02_24_000000_create_discussions_tags_table.php Proyecto: skywalker512/FlarumChina

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('discussions_tags', function (Blueprint $table) {
    $table->integer('discussion_id')->unsigned();
    $table->integer('tag_id')->unsigned();
    $table->primary(['discussion_id', 'tag_id']);
});

Ejemplo n.º 2

Archivo: 2015_09_02_000000_create_flags_table.php Proyecto: flarum/flarum-ext-flags

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('flags', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('post_id')->unsigned();
    $table->string('type');
    $table->integer('user_id')->unsigned()->nullable();
    $table->string('reason')->nullable();
    $table->string('reason_detail')->nullable();
    $table->dateTime('time');
});

Ejemplo n.º 3

Archivo: 2015_02_24_000000_create_users_groups_table.php Proyecto: flarum/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('users_groups', function (Blueprint $table) {
    $table->integer('user_id')->unsigned();
    $table->integer('group_id')->unsigned();
    $table->primary(['user_id', 'group_id']);
});

Ejemplo n.º 4

Archivo: 2015_02_24_000000_create_users_tags_table.php Proyecto: flarum/flarum-ext-tags

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('users_tags', function (Blueprint $table) {
    $table->integer('user_id')->unsigned();
    $table->integer('tag_id')->unsigned();
    $table->dateTime('read_time')->nullable();
    $table->boolean('is_hidden')->default(0);
    $table->primary(['user_id', 'tag_id']);
});

Ejemplo n.º 5

Archivo: 2015_09_15_000000_create_auth_tokens_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('auth_tokens', function (Blueprint $table) {
    $table->string('id', 100)->primary();
    $table->string('payload', 150);
    $table->timestamp('created_at');
});

Ejemplo n.º 6

Archivo: 2016_02_13_000000_create_links_table.php Proyecto: sijad/flarum-ext-links

<?php

/*
 * (c) Sajjad Hashemian <*****@*****.**>
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('links', function (Blueprint $table) {
    $table->increments('id');
    $table->string('title', 50);
    $table->string('type', 30);
    $table->string('url', 255);
    $table->integer('ref_id')->unsigned()->nullable();
    $table->integer('position')->nullable();
});

Ejemplo n.º 7

Archivo: 2015_05_11_000000_create_mentions_users_table.php Proyecto: sijad/flarum-ext-mentions

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('mentions_users', function (Blueprint $table) {
    $table->integer('post_id')->unsigned();
    $table->integer('mentions_id')->unsigned();
    $table->primary(['post_id', 'mentions_id']);
});

Ejemplo n.º 8

Archivo: 2015_02_24_000000_create_users_discussions_table.php Proyecto: flarum/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('users_discussions', function (Blueprint $table) {
    $table->integer('user_id')->unsigned();
    $table->integer('discussion_id')->unsigned();
    $table->dateTime('read_time')->nullable();
    $table->integer('read_number')->unsigned()->nullable();
    $table->primary(['user_id', 'discussion_id']);
});

Ejemplo n.º 9

Archivo: 2015_02_24_000000_create_permissions_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('permissions', function (Blueprint $table) {
    $table->integer('group_id')->unsigned();
    $table->string('permission', 100);
    $table->primary(['group_id', 'permission']);
});

Ejemplo n.º 10

Archivo: 2015_02_24_000000_create_notifications_table.php Proyecto: flarum/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('notifications', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('user_id')->unsigned();
    $table->integer('sender_id')->unsigned()->nullable();
    $table->string('type', 100);
    $table->string('subject_type', 200)->nullable();
    $table->integer('subject_id')->unsigned()->nullable();
    $table->binary('data')->nullable();
    $table->dateTime('time');
    $table->boolean('is_read')->default(0);
    $table->boolean('is_deleted')->default(0);
});

Ejemplo n.º 11

Archivo: 2015_02_24_000000_create_email_tokens_table.php Proyecto: flarum/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('email_tokens', function (Blueprint $table) {
    $table->string('id', 100)->primary();
    $table->string('email', 150);
    $table->integer('user_id')->unsigned();
    $table->timestamp('created_at');
});

Ejemplo n.º 12

Archivo: 2015_02_24_000000_create_api_keys_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('api_keys', function (Blueprint $table) {
    $table->string('id', 100)->primary();
});

Ejemplo n.º 13

Archivo: 2015_02_24_000000_create_config_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('config', function (Blueprint $table) {
    $table->string('key', 100)->primary();
    $table->binary('value')->nullable();
});

Ejemplo n.º 14

Archivo: 2016_01_14_000000_create_socialbuttons_table.php Proyecto: dav-is/flarum-socialprofile

<?php

namespace Davis\SocialProfile\Migration;

use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('socialbuttons', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('user_id')->unsigned();
    $table->longText('buttons');
});

Ejemplo n.º 15

Archivo: 2015_02_24_000000_create_discussions_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('discussions', function (Blueprint $table) {
    $table->increments('id');
    $table->string('title', 200);
    $table->integer('comments_count')->unsigned()->default(0);
    $table->integer('participants_count')->unsigned()->default(0);
    $table->integer('number_index')->unsigned()->default(0);
    $table->dateTime('start_time');
    $table->integer('start_user_id')->unsigned()->nullable();
    $table->integer('start_post_id')->unsigned()->nullable();
    $table->dateTime('last_time')->nullable();
    $table->integer('last_user_id')->unsigned()->nullable();
    $table->integer('last_post_id')->unsigned()->nullable();
    $table->integer('last_post_number')->unsigned()->nullable();
});

Ejemplo n.º 16

Archivo: 2015_02_24_000000_create_groups_table.php Proyecto: flarum/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('groups', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name_singular', 100);
    $table->string('name_plural', 100);
    $table->string('color', 20)->nullable();
    $table->string('icon', 100)->nullable();
});

Ejemplo n.º 17

Archivo: 2015_02_24_000000_create_users_table.php Proyecto: Luceos/core

<?php

/*
 * This file is part of Flarum.
 *
 * (c) Toby Zerner <*****@*****.**>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('users', function (Blueprint $table) {
    $table->increments('id');
    $table->string('username', 100)->unique();
    $table->string('email', 150)->unique();
    $table->boolean('is_activated')->default(0);
    $table->string('password', 100);
    $table->text('bio')->nullable();
    $table->string('avatar_path', 100)->nullable();
    $table->binary('preferences')->nullable();
    $table->dateTime('join_time')->nullable();
    $table->dateTime('last_seen_time')->nullable();
    $table->dateTime('read_time')->nullable();
    $table->dateTime('notification_read_time')->nullable();
    $table->integer('discussions_count')->unsigned()->default(0);
    $table->integer('comments_count')->unsigned()->default(0);
});

Ejemplo n.º 18

Archivo: 2016_04_11_182821__create_pages_table.php Proyecto: sijad/flarum-ext-pages

<?php

use Flarum\Database\Migration;
use Illuminate\Database\Schema\Blueprint;
return Migration::createTable('pages', function (Blueprint $table) {
    $table->increments('id');
    $table->string('title', 200);
    $table->string('slug', 200);
    $table->dateTime('time');
    $table->dateTime('edit_time')->nullable();
    $table->text('content')->nullable();
    $table->boolean('is_hidden')->default(0);
});