<?php

$tables = array(

'users_users' => "
  user_id I4 PRIMARY,
  content_id I4,
  email C(200),
  login C(40),
  real_name C(64),
  user_password C(32),
  provpass C(32),
  default_group_id I4,
  last_login I8,
  current_login I8,
  registration_date I8 NOTNULL,
  challenge C(32),
  pass_due I8,
  hash C(32),
  created I8,
  avatar_attachment_id I4,
  portrait_attachment_id I4,
  logo_attachment_id I4
",
/* chicken-and-egg constraint dependencies: Liberty needs user_id, Users needs liberty
  CONSTRAINT	', CONSTRAINT `users_avatar_attach_ref` FOREIGN KEY (`avatar_attachment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_attachments` (`attachment_id`)
				 , CONSTRAINT `users_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)
				 , CONSTRAINT `users_portrait_attach_ref` FOREIGN KEY (`portrait_attachment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_attachments` (`attachment_id`)
				 , CONSTRAINT `users_logo_attach_ref` FOREIGN KEY (`logo_attachment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_attachments` (`attachment_id`)' */

'users_favorites_map' => "
  favorite_content_id I4 PRIMARY,
  user_id I4 PRIMARY,
  map_position I4
  CONSTRAINT ', CONSTRAINT `users_fav_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",
// another chicken and egg thing.
//  				 , CONSTRAINT `users_fav_con_ref` FOREIGN KEY (`favorite_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'

'users_permissions' => "
  perm_name C(30) PRIMARY,
  perm_desc C(250),
  perm_level C(80),
  package C(100)
",

'users_groups' => "
  group_id I4 PRIMARY,
  user_id I4 NOTNULL,
  group_name C(30),
  is_default C(1),
  group_desc C(255),
  group_home C(255)
  CONSTRAINT ', CONSTRAINT `users_groups_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

'users_groups_inclusion' => "
  group_id I4 PRIMARY,
  include_group_id I4 PRIMARY
",

'users_group_permissions' => "
  group_id I4 PRIMARY,
  perm_name C(30) PRIMARY,
  perm_value C(1) default ''
  CONSTRAINT ', CONSTRAINT `users_group_perm_group_ref` FOREIGN KEY (`group_id`) REFERENCES `".BIT_DB_PREFIX."users_groups` (`group_id`)
  				, CONSTRAINT `users_group_perm_perm_ref` FOREIGN KEY (`perm_name`) REFERENCES `".BIT_DB_PREFIX."users_permissions` (`perm_name`)'
",

'users_object_permissions' => "
  group_id I4 PRIMARY,
  perm_name C(30) PRIMARY,
  object_type C(20) PRIMARY,
  object_id I4 PRIMARY
  CONSTRAINT   ', CONSTRAINT `users_object_perm_group_ref` FOREIGN KEY (`group_id`) REFERENCES `".BIT_DB_PREFIX."users_groups` (`group_id`)
                , CONSTRAINT `users_object_perm_perm_ref` FOREIGN KEY (`perm_name`) REFERENCES `".BIT_DB_PREFIX."users_permissions` (`perm_name`)'
",

'users_groups_map' => "
  user_id I4 PRIMARY,
  group_id I4 PRIMARY
  CONSTRAINT ', CONSTRAINT `users_groups_map_group_ref` FOREIGN KEY (`group_id`) REFERENCES `".BIT_DB_PREFIX."users_groups` (`group_id`)
  				, CONSTRAINT `users_groups_map_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

'users_cnxn' => "
  user_id I4,
  cookie C(64),
  ip C(16),
  last_get I8,
  connect_time I8,
  get_count I8,
  user_agent C(128),
  current_view X
  CONSTRAINT ', CONSTRAINT `users_cnxn_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

'users_semaphores' => "
	sem_name C(250) PRIMARY,
	user_id I4 NOTNULL,
	created I8
",

'users_watches' => "
  user_id I4 PRIMARY,
  event C(40) PRIMARY,
  object C(120) PRIMARY,
  hash C(32),
  title C(250),
  watch_type C(200),
  url C(250),
  email C(200)
  CONSTRAINT ', CONSTRAINT `users_watches_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

);

global $gBitInstaller;

foreach( array_keys( $tables ) AS $tableName ) {
	$gBitInstaller->registerSchemaTable( USERS_PKG_NAME, $tableName, $tables[$tableName], TRUE );
}

$indices = array (
	'users_users_email_idx' => array( 'table' => 'users_users', 'cols' => 'email', 'opts' => array('UNIQUE') ),
	'users_users_login_idx' => array( 'table' => 'users_users', 'cols' => 'login', 'opts' => array('UNIQUE') ),
	'users_users_avatar_atment_idx' => array( 'table' => 'users_users', 'cols' => 'avatar_attachment_id', 'opts' => NULL ),
	'users_groups_user_idx' => array( 'table' => 'users_groups', 'cols' => 'user_id', 'opts' => NULL ),
	'users_groups_user_name_idx' => array( 'table' => 'users_groups', 'cols' => 'user_id,group_name', 'opts' => array('UNIQUE') ),
	'users_group_perm_group_idx' => array( 'table' => 'users_group_permissions', 'cols' => 'group_id', 'opts' => NULL ),
	'users_group_perm_perm_idx' => array( 'table' => 'users_group_permissions', 'cols' => 'perm_name', 'opts' => NULL ),
	'users_object_perm_group_idx' =>  array( 'table' => 'users_object_permissions', 'cols' => 'group_id', 'opts' => NULL ),
	'users_object_perm_perm_idx' => array( 'table' => 'users_object_permissions', 'cols' => 'perm_name', 'opts' => NULL ),
	'users_object_perm_object_idx' => array( 'table' => 'users_object_permissions', 'cols' => 'object_id', 'opts' => NULL ),
	'users_groups_map_user_idx' => array( 'table' => 'users_groups_map', 'cols' => 'user_id', 'opts' => NULL ),
	'users_groups_map_group_idx' => array( 'table' => 'users_groups_map', 'cols' => 'group_id', 'opts' => NULL ),
	'users_fav_con_idx' => array( 'table' => 'users_favorites_map', 'cols' => 'favorite_content_id', 'opts' => NULL ),
	'users_fav_user_idx' => array( 'table' => 'users_favorites_map', 'cols' => 'user_id', 'opts' => NULL )
);


$gBitInstaller->registerSchemaIndexes( USERS_PKG_NAME, $indices );

$gBitInstaller->registerPackageInfo( USERS_PKG_NAME, array(
	'description' => "The users package contains all user information and gives you the possiblity to assign permissions to groups of users.",
	'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>',
	'version' => '0.1',
	'state' => 'experimental',
	'dependencies' => '',
) );

// ### Sequences
$sequences = array (
	'users_users_user_id_seq' => array( 'start' => 2 ),
	'users_groups_id_seq' => array( 'start' => 4 )
);
$gBitInstaller->registerSchemaSequences( USERS_PKG_NAME, $sequences );

// ### Default Preferences
$gBitInstaller->registerPreferences( USERS_PKG_NAME, array(
	//array(USERS_PKG_NAME,'webserverauth','n'),
	//array(USERS_PKG_NAME,'auth_create_user_auth','n'),
	//array(USERS_PKG_NAME,'auth_create_gBitDbUser','n'),
	//array(USERS_PKG_NAME,'auth_ldap_adminpass',''),
	//array(USERS_PKG_NAME,'auth_ldap_adminuser',''),
	//array(USERS_PKG_NAME,'auth_ldap_basedn',''),
	array(USERS_PKG_NAME,'auth_ldap_groupattr','cn'),
	//array(USERS_PKG_NAME,'auth_ldap_groupdn',''),
	array(USERS_PKG_NAME,'auth_ldap_groupoc','groupOfUniqueNames'),
	array(USERS_PKG_NAME,'auth_ldap_host','localhost'),
	array(USERS_PKG_NAME,'auth_ldap_memberattr','uniqueMember'),
	//array(USERS_PKG_NAME,'auth_ldap_memberisdn','n'),
	array(USERS_PKG_NAME,'auth_ldap_port','389'),
	array(USERS_PKG_NAME,'auth_ldap_scope','sub'),
	array(USERS_PKG_NAME,'auth_ldap_userattr','uid'),
	//array(USERS_PKG_NAME,'auth_ldap_userdn',''),
	array(USERS_PKG_NAME,'auth_ldap_useroc','inetOrgPerson'),
	array(USERS_PKG_NAME,'auth_method','tiki'),
	array(USERS_PKG_NAME,'auth_skip_admin','y'),
	array(USERS_PKG_NAME,'allow_register','y'),
	//array(USERS_PKG_NAME,'user_files','n'),
	array(USERS_PKG_NAME,'forgot_pass','y'),
	//array(USERS_PKG_NAME,'eponymous_groups','n'),
	array(USERS_PKG_NAME,'modallgroups','y'),
	//array(USERS_PKG_NAME,'pass_chr_num','n'),
	array(USERS_PKG_NAME,'pass_due','999'),
	//array(USERS_PKG_NAME,'register_passcode',''),
	array(USERS_PKG_NAME,'rememberme','disabled'),
	array(USERS_PKG_NAME,'remembertime','7200'),
	//array(USERS_PKG_NAME,'rnd_num_reg','n'),
	array(USERS_PKG_NAME,'userfiles_quota','30'),
	array(USERS_PKG_NAME,'uf_use_db','y'),
	//array(USERS_PKG_NAME,'uf_use_dir',''),
	//array(USERS_PKG_NAME,'use_register_passcode','n'),
	//array(USERS_PKG_NAME,'validate_user','n'),
	//array(USERS_PKG_NAME,'validate_email','n'),
	array(USERS_PKG_NAME,'min_pass_length','4'),
	//array(USERS_PKG_NAME,'clear_passwords','n'),
	//array(USERS_PKG_NAME,'custom_home','n'),
	//array(USERS_PKG_NAME,'user_bookmarks','n'),
	//array(USERS_PKG_NAME,'feature_tasks','n'),
	//array(USERS_PKG_NAME,'usermenu','n'),
	array(USERS_PKG_NAME,'users_preferences','y'),
	array(USERS_PKG_NAME,'display_name','real_name'),
	array(USERS_PKG_NAME,'change_language','y'),
	array(USERS_PKG_NAME,'case_sensitive_login','y'),
	//array(USERS_PKG_NAME, 'user_watches','n'),
) );

// ### Default Permissions
$gBitInstaller->registerUserPermissions( USERS_PKG_NAME, array(
	//array('bit_p_userfiles', 'Can upload personal files', 'registered', USERS_PKG_NAME),
	array('bit_p_user_group_perms', 'Can assign permissions to personal groups', 'editors', USERS_PKG_NAME),
	array('bit_p_user_group_members', 'Can assign users to personal groups', 'registered', USERS_PKG_NAME),
	array('bit_p_user_group_subgroups', 'Can include other groups in groups', 'editors', USERS_PKG_NAME),
	//array('bit_p_create_bookmarks', 'Can create user bookmarksche user bookmarks', 'registered', USERS_PKG_NAME),
	//array('bit_p_configure_modules', 'Can configure modules', 'registered', USERS_PKG_NAME),
	//array('bit_p_cache_bookmarks', 'Can cache user bookmarks', 'admin', USERS_PKG_NAME),
	//array('bit_p_usermenu', 'Can create items in personal menu', 'registered', USERS_PKG_NAME),
	//array('bit_p_tasks', 'Can use tasks', 'registered', USERS_PKG_NAME),
	array('bit_p_admin_users', 'Can edit the information for other users', 'admin', USERS_PKG_NAME),
	//array('bit_p_view_tabs_and_tools', 'Can view tab and tool links', 'basic', USERS_PKG_NAME),
	//array('bit_p_custom_home_theme', 'Can modify user homepage theme', 'editors', USERS_PKG_NAME),
	//array('bit_p_custom_home_layout', 'Can modify user homepage layout', 'editors', USERS_PKG_NAME),
	//array('bit_p_custom_css', 'Can create custom style sheets', 'editors', USERS_PKG_NAME),
	array('bit_p_create_personal_groups', 'Can create personal user groups', 'editors', USERS_PKG_NAME),
	array('bit_p_view_user_list', 'Can view list of registered users', 'registered', USERS_PKG_NAME),
	array('bit_p_view_user_homepage', 'Can view personalized homepages', 'basic', USERS_PKG_NAME),
	array('bit_p_edit_user_homepage', 'Can create and display a personalized homepage', 'registered', USERS_PKG_NAME),
) );

?>