PHP WebSeed\Database SchemaBuilder Examples

Example #1

File: user.table.php Project: vitodtagliente/webseed

<?php

use WebSeed\Database\Schema;
use WebSeed\Database\SchemaBuilder;
if (!Schema::exists('user')) {
    Schema::create(function () {
        $table = new SchemaBuilder('user');
        $table->add('id', 'int');
        $table->increments('id');
        $table->add('username', 'varchar(30)', 'not null');
        $table->add('password', 'varchar(50)', 'not null');
        $table->unique('username');
        $table->add('name', 'varchar(30)');
        $table->add('surname', 'varchar(30)');
        $table->add('email', 'varchar(30)', 'not null');
        $table->add('borndate', 'date');
        $table->add('city', 'varchar(20)');
        $table->add('address', 'varchar(30)');
        $table->add('cap', 'varchar(10)');
        $table->primary('id');
        return $table;
    });
    $user = new User();
    $user->username = '******';
    $user->password = md5('admin');
    $user->email = '*****@*****.**';
    $user->save();
}

Example #2

File: schema.template.php Project: vitodtagliente/webseed

<?php

use WebSeed\Database\Schema;
use WebSeed\Database\SchemaBuilder;
if (!Schema::exists('schemaname')) {
    Schema::create(function () {
        $table = new SchemaBuilder('schemaname');
        $table->add('id', 'int');
        $table->increments('id');
        $table->add('field', 'varchar(30)', 'not null');
        $table->primary('id');
        return $table;
    });
}