public function up()
{
$t = $this->createTable('ansel_sharesng', array('autoincrementKey' => 'share_id'));
$t->column('share_name', 'string', array('limit' => 255, 'null' => false));
$t->column('share_owner', 'string', array('limit' => 255));
$t->column('share_flags', 'integer', array('default' => 0, 'null' => false));
$t->column('share_parents', 'text');
$t->column('perm_creator_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_creator_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_creator_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_creator_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_default_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_default_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_default_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_default_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_guest_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_guest_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_guest_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_guest_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false));
$t->column('attribute_name', 'string', array('limit' => 255, 'null' => false));
$t->column('attribute_desc', 'string', array('limit' => 255));
$t->column('attribute_default', 'integer');
$t->column('attribute_default_type', 'string', array('limit' => 6));
$t->column('attribute_default_prettythumb', 'text');
$t->column('attribute_style', 'text');
$t->column('attribute_last_modified', 'integer');
$t->column('attribute_date_created', 'integer');
$t->column('attribute_images', 'integer', array('null' => false, 'default' => 0));
$t->column('attribute_has_subgalleries', 'integer', array('null' => false, 'default' => 0));
$t->column('attribute_slug', 'string', array('limit' => 255));
$t->column('attribute_age', 'integer', array('null' => false, 'default' => 0));
$t->column('attribute_download', 'string', array('limit' => 255));
$t->column('attribute_passwd', 'string', array('limit' => 255));
$t->column('attribute_faces', 'integer', array('null' => false, 'default' => 0));
$t->column('attribute_view_mode', 'string', array('limit' => 255, 'default' => 'Normal', 'null' => false));
$t->end();
$this->addIndex('ansel_sharesng', array('share_name'));
$this->addIndex('ansel_sharesng', array('share_owner'));
$this->addIndex('ansel_sharesng', array('perm_creator_' . Horde_Perms::SHOW));
$this->addIndex('ansel_sharesng', array('perm_creator_' . Horde_Perms::READ));
$this->addIndex('ansel_sharesng', array('perm_creator_' . Horde_Perms::EDIT));
$this->addIndex('ansel_sharesng', array('perm_creator_' . Horde_Perms::DELETE));
$this->addIndex('ansel_sharesng', array('perm_default_' . Horde_Perms::SHOW));
$this->addIndex('ansel_sharesng', array('perm_default_' . Horde_Perms::READ));
$this->addIndex('ansel_sharesng', array('perm_default_' . Horde_Perms::EDIT));
$this->addIndex('ansel_sharesng', array('perm_default_' . Horde_Perms::DELETE));
$this->addIndex('ansel_sharesng', array('perm_guest_' . Horde_Perms::SHOW));
$this->addIndex('ansel_sharesng', array('perm_guest_' . Horde_Perms::READ));
$this->addIndex('ansel_sharesng', array('perm_guest_' . Horde_Perms::EDIT));
$this->addIndex('ansel_sharesng', array('perm_guest_' . Horde_Perms::DELETE));
$t = $this->createTable('ansel_sharesng_groups', array('autoincrementKey' => false));
$t->column('share_id', 'integer', array('null' => false));
$t->column('group_uid', 'string', array('limit' => 255, 'null' => false));
$t->column('perm_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false));
$t->end();
$this->addIndex('ansel_sharesng_groups', array('share_id'));
$this->addIndex('ansel_sharesng_groups', array('group_uid'));
$this->addIndex('ansel_sharesng_groups', array('perm_' . Horde_Perms::SHOW));
$this->addIndex('ansel_sharesng_groups', array('perm_' . Horde_Perms::READ));
$this->addIndex('ansel_sharesng_groups', array('perm_' . Horde_Perms::EDIT));
$this->addIndex('ansel_sharesng_groups', array('perm_' . Horde_Perms::DELETE));
$t = $this->createTable('ansel_sharesng_users', array('autoincrementKey' => false));
$t->column('share_id', 'integer', array('null' => false));
$t->column('user_uid', 'string', array('limit' => 255, 'null' => false));
$t->column('perm_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false));
$t->column('perm_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false));
$t->end();
$this->addIndex('ansel_sharesng_users', array('share_id'));
$this->addIndex('ansel_sharesng_users', array('user_uid'));
$this->addIndex('ansel_sharesng_users', array('perm_' . Horde_Perms::SHOW));
$this->addIndex('ansel_sharesng_users', array('perm_' . Horde_Perms::READ));
$this->addIndex('ansel_sharesng_users', array('perm_' . Horde_Perms::EDIT));
$this->addIndex('ansel_sharesng_users', array('perm_' . Horde_Perms::DELETE));
$this->dataUp();
}
