<?php
/**
 * Setup-0.1.0.php
 *
 * Tables for CMS themes
 *
 * @package     easyPage CmsTheme
 * @author      Christoffer Bubach
 * @class       Core_Plugin_Setup
 */

$db = wmvc::app()->getDb();
$tables = array(
    'theme' => array(
        'id'        => array('type' => 'primary'),
        'parent_id' => array('type' => 'integer', 'null'  => true, 'index' => true),
        'name'      => array('type' => 'string', 'length' => 100, 'null' => false),
        'module'    => array('type' => 'string', 'length' => 100, 'null' => true),
        'active'    => array('type' => 'boolean', 'default' => 1, 'null' => false),
        'type'      => array(
            'type'  => 'integer',
            'null'  => false,
            'index' => true,
        ),
        'preview'   => array('type' => 'string', 'length' => 100, 'null' => true),
        'content'   => array('type' => 'string', 'null' => true),
    ),
);
$db->schema()->createTable($tables);