Location: PHPKode > projects > TikiPro Web Framework > tikipro/fisheye/admin/schema_inc.php
<?php

$tables = array(

'tiki_fisheye_gallery' => "
  gallery_id I4 PRIMARY,		
  content_id I4,
  rows_per_page I4,
  cols_per_page I4,
  thumbnail_size C(32),
  preview_content_id I4
",

'tiki_fisheye_gallery_image_map' => "
	gallery_content_id I4 NOTNULL,
	item_content_id I4 NOTNULL,
	position I4
",

'tiki_fisheye_image' => "
  image_id I4 PRIMARY,
  content_id I4 NOTNULL,
  photo_date I8,
  width I4,
  height I4
",
/*
'tiki_fisheye_image_exif' => "
  content_id I4 PRIMARY,
  exif_title C(250),
  exif_data X
",
*/
'tiki_thumbnail_queue' => "
  content_id I4 PRIMARY,
  queue_date I8 NOTNULL,
  begin_date I8,
  end_date I8,
  resize_original integer
"

);

global $gTikiInstaller;

$gTikiInstaller->makePackageHomeable('fisheye');

foreach( array_keys( $tables ) AS $tableName ) {
	$gTikiInstaller->registerSchemaTable( FISHEYE_PKG_NAME, $tableName, $tables[$tableName] );
}

$indices = array (
	'tiki_fisheye_gallery_id_idx' => array( 'table' => 'tiki_fisheye_gallery', 'cols' => 'gallery_id', 'opts' => NULL ),
	'tiki_fisheye_image_id_idx' => array( 'table' => 'tiki_fisheye_image', 'cols' => 'image_id', 'opts' => NULL )
);
$gTikiInstaller->registerSchemaIndexes( FISHEYE_PKG_NAME, $indices );

$gTikiInstaller->registerPackageInfo( FISHEYE_PKG_NAME, array(
	'description' => "FishEye is a package for creating image galleries",
	'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>'
) );

// ### Sequences
$sequences = array (
	'tiki_fisheye_gallery_id_seq' => array( 'start' => 1 )
);
$gTikiInstaller->registerSchemaSequences( FISHEYE_PKG_NAME, $sequences );

// ### Default Preferences
$gTikiInstaller->registerPreferences( FISHEYE_PKG_NAME, array(
	array( FISHEYE_PKG_NAME, 'fisheye_list_title','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_list_created','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_list_user','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_list_hits','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_list_thumbnail','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_list_title','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_list_description','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_list_image_titles','y'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_default_rows_per_page','5'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_default_cols_per_page','3'),
	array( FISHEYE_PKG_NAME, 'fisheye_gallery_default_thumbnail_size','small'),
	array( FISHEYE_PKG_NAME, 'fisheye_image_list_description',''),
	array( FISHEYE_PKG_NAME, 'fisheye_image_default_thumbnail_size',''),
	array( FISHEYE_PKG_NAME, 'fisheye_menu_text','Image Galleries'),
	)
);

// ### Default User Permissions
$gTikiInstaller->registerUserPermissions( FISHEYE_PKG_NAME, array(
	array('tiki_p_view_fisheye', 'Can view image galleries', 'basic', 'fisheye'),
	array('tiki_p_create_fisheye', 'Can create an image gallery', 'registered', 'fisheye'),
	array('tiki_p_edit_fisheye', 'Can edit image gallery', 'registered', 'fisheye'),
	array('tiki_p_upload_fisheye', 'Can upload images to gallery', 'registered', 'fisheye'),
	array('tiki_p_admin_fisheye', 'Can admin image galleries', 'editors', 'fisheye')
) );

?>
Return current item: TikiPro Web Framework