Skeleton

Introduction

Skeleton is a database schema builder, designed to manipulate your database structure and tables.

Creating tables

In order to create a new table, you must first set the table name you want to create with the $db->table() method.

Example

$db->table('new_table');

Now, you must create columns for your table. The first method we are going to use is the $db->createColumn(). The parameters for this method are:

name
The name of the column you want to create.

type
The SQL data type for the column you are creating. Must be a valid type supported by your current MySQL version.

size
An optional maximum data length for the column you are creating.

default
An optional default value for this column in new rows.

Example

$db->table('new_table')
    ->createColumn('username', 'VARCHAR', 255)
    ->createColumn('password', 'VARCHAR', 255);

The second method to use while creating columns is the $db->createNullableColumn(). Unlike the previous one, this method creates a column that accepts NULL values. Parameters are the same.

Example

$db->table('new_table')
    ->createColumn('username', 'VARCHAR', 255)
    ->createColumn('password', 'VARCHAR', 255)
    ->createNullableColumn('email', 'VARCHAR', 255);

Documentation session under development... Contribute!