<?php
global $gBitInstaller;

$tables = [


'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),
  provpass_expires I8,
  default_role_id I4,
  last_login I8,
  current_login I8,
  registration_date I8 NOTNULL,
  registration_ip C(32) NOTNULL,
  challenge C(32),
  pass_due I8,
  hash C(32),
  created I8,
  avatar_attachment_id I4,
  portrait_attachment_id I4,
  logo_attachment_id I4
  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`)
			  , CONSTRAINT `users_fav_con_ref` FOREIGN KEY (`favorite_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
",

'users_auth_map' => "
  user_id I4 PRIMARY,
  provider C(64) PRIMARY,
  provider_identifier C(64) NOTNULL,
  
  last_login I8,
  profile_json X
",

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

'users_roles' => "
  role_id I4 PRIMARY,
  user_id I4 NOTNULL,
  role_name C(30),
  is_default C(1),
  role_desc C(255),
  role_home C(255),
  is_public C(1),
  after_registration_page C(255)
  CONSTRAINT ', CONSTRAINT `users_roles_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

'users_role_permissions' => "
  role_id I4 PRIMARY,
  perm_name C(30) PRIMARY,
  perm_value C(1) default ''
  CONSTRAINT ', CONSTRAINT `users_role_perm_role_ref` FOREIGN KEY (`role_id`) REFERENCES `".BIT_DB_PREFIX."users_roles` (`role_id`)
 				, CONSTRAINT `users_role_perm_perm_ref` FOREIGN KEY (`perm_name`) REFERENCES `".BIT_DB_PREFIX."users_permissions` (`perm_name`)'
",

'users_roles_map' => "
  user_id I4 PRIMARY,
  role_id I4 PRIMARY
  CONSTRAINT ', CONSTRAINT `users_roles_map_role_ref` FOREIGN KEY (`role_id`) REFERENCES `".BIT_DB_PREFIX."users_roles` (`role_id`)
  				, CONSTRAINT `users_roles_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(39),
  last_get I8,
  connect_time I8,
  get_count I8,
  user_agent C(128),
  assume_user_id I4,
  current_view X
  CONSTRAINT ', CONSTRAINT `users_cnxn_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

'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`)'
",

];

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

// ### Default Preferences
$gBitInstaller->registerPreferences( USERS_PKG_NAME, [
	[ USERS_PKG_NAME, 'user_class', 'RolePermUser' ],
] );

// ### Default Permissions
$gBitInstaller->registerUserPermissions( USERS_PKG_NAME, [
	[ 'p_users_assign_role_perms', 'Can assign permissions to personal roles', 'editors', USERS_PKG_NAME ],
	[ 'p_users_assign_role_members', 'Can assign users to personal roles', 'registered', USERS_PKG_NAME ],
	[ 'p_users_role_subroles', 'Can include other roles in roles', 'editors', USERS_PKG_NAME ],
	[ 'p_users_create_personal_roles', 'Can create personal user roles', 'editors', USERS_PKG_NAME ],

	//Various other non-role kruft

	//array('p_tidbits_upload_userfiles', 'Can upload personal files', 'registered', USERS_PKG_NAME),
	//array('p_tidbits_configure_modules', 'Can configure modules', 'registered', USERS_PKG_NAME),
	//array('p_tidbits_cache_bookmarks', 'Can cache user bookmarks', 'admin', USERS_PKG_NAME),
	//array('p_tidbits_use_usermenu', 'Can create items in personal menu', 'registered', USERS_PKG_NAME),
	//array('p_tidbits_use_tasks', 'Can use tasks', 'registered', USERS_PKG_NAME),
	//array('p_tidbits_custom_home_theme', 'Can modify user homepage theme', 'editors', USERS_PKG_NAME),
	//array('p_tidbits_custom_home_layout', 'Can modify user homepage layout', 'editors', USERS_PKG_NAME),
	//array('p_tidbits_use_custom_css', 'Can create custom style sheets', 'editors', USERS_PKG_NAME),

	//array(USERS_PKG_NAME,'users_webserverauth','n'),
	//array(USERS_PKG_NAME,'users_auth_create_user_auth','n'),
	//array(USERS_PKG_NAME,'users_auth_create_gBitDbUser','n'),
	//array(USERS_PKG_NAME,'users_ldap_adminpass',''),
	//array(USERS_PKG_NAME,'users_ldap_adminuser',''),
	//array(USERS_PKG_NAME,'users_ldap_basedn',''),
	//array(USERS_PKG_NAME,'users_ldap_groupattr','cn'),
	//array(USERS_PKG_NAME,'users_ldap_groupdn',''),
	//array(USERS_PKG_NAME,'users_ldap_groupoc','groupOfUniqueNames'),
	//array(USERS_PKG_NAME,'users_ldap_host','localhost'),
	//array(USERS_PKG_NAME,'users_ldap_memberattr','uniqueMember'),
	//array(USERS_PKG_NAME,'users_ldap_memberisdn','n'),
	//array(USERS_PKG_NAME,'users_ldap_port','389'),
	//array(USERS_PKG_NAME,'users_ldap_scope','sub'),
	//array(USERS_PKG_NAME,'users_ldap_userattr','uid'),
	//array(USERS_PKG_NAME,'users_ldap_userdn',''),
	//array(USERS_PKG_NAME,'users_ldap_useroc','inetOrgPerson'),
	//array(USERS_PKG_NAME,'users_auth_skip_admin','y'),
	//array(USERS_PKG_NAME,'user_files','n'),
	//array(USERS_PKG_NAME,'site_show_all_modules_always','y'),
	//array(USERS_PKG_NAME,'users_userfiles_quota','30'),
	//array(USERS_PKG_NAME,'users_uf_use_db','y'),
	//array(USERS_PKG_NAME,'uf_use_dir',''),
	//array(USERS_PKG_NAME,'feature_tasks','n'),
	//array(USERS_PKG_NAME,'usermenu','n'),
] );

$team_indices = [
	'users_roles_user_idx' 		=> [ 'table' => 'users_roles', 'cols' => 'user_id', 'opts' => null ],
	'users_roles_user_name_idx' => [ 'table' => 'users_roles', 'cols' => 'user_id,role_name', 'opts' => [ 'UNIQUE' ] ],
	'users_role_perm_role_idx' 	=> [ 'table' => 'users_role_permissions', 'cols' => 'role_id', 'opts' => null ],
	'users_role_perm_perm_idx' 	=> [ 'table' => 'users_role_permissions', 'cols' => 'perm_name', 'opts' => null ],
	'users_roles_map_user_idx' 	=> [ 'table' => 'users_roles_map', 'cols' => 'user_id', 'opts' => null ],
	'users_roles_map_role_idx' 	=> [ 'table' => 'users_roles_map', 'cols' => 'role_id', 'opts' => null ],
];

$indices = [ ...$team_indices,
	'users_users_email_idx'         => [ 'table' => 'users_users', 'cols' => 'email', 'opts' => [ 'UNIQUE' ] ],
	'users_auth_user_idx'           => [ 'table' => 'users_auth_map', 'cols' => 'user_id', 'opts' => null ],
	'users_auth_provider_ident_idx' => [ 'table' => 'users_auth_map', 'cols' => 'provider,provider_identifier', 'opts' => [ 'UNIQUE' ] ],
	'users_users_login_idx'         => [ 'table' => 'users_users', 'cols' => 'login', 'opts' => [ 'UNIQUE' ] ],
	'users_users_avatar_atment_idx' => [ 'table' => 'users_users', 'cols' => 'avatar_attachment_id', 'opts' => null ],
	'users_fav_con_idx'             => [ 'table' => 'users_favorites_map', 'cols' => 'favorite_content_id', 'opts' => null ],
	'users_fav_user_idx'            => [ 'table' => 'users_favorites_map', 'cols' => 'user_id', 'opts' => null ],
];
$gBitInstaller->registerSchemaIndexes( USERS_PKG_NAME, $indices );

$constraints = [
	'users_auth_map' => [ 'users_auth_user_ref' => 'FOREIGN KEY (`user_id`) REFERENCES `' . BIT_DB_PREFIX . 'users_users` (`user_id`)' ],
];
foreach( array_keys( $constraints ) as $tableName ) {
	$gBitInstaller->registerSchemaConstraints( USERS_PKG_NAME, $tableName, $constraints[$tableName] );
}

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

// ### Sequences

$sequences = [
	'users_users_user_id_seq' => [ 'start' => 2 ],
	'users_roles_id_seq'      => [ 'start' => 4 ],
];
$gBitInstaller->registerSchemaSequences( USERS_PKG_NAME, $sequences );

// ### Default Preferences
$gBitInstaller->registerPreferences( USERS_PKG_NAME, [
	[ USERS_PKG_NAME, 'users_auth_method', 'tiki' ],
	[ USERS_PKG_NAME, 'users_allow_register', 'y' ],
	[ USERS_PKG_NAME, 'users_forgot_pass', 'y' ],
	//array(USERS_PKG_NAME,'users_eponymous_groups','n'),
	//array(USERS_PKG_NAME,'users_pass_chr_num','n'),
	[ USERS_PKG_NAME, 'users_pass_due', '999' ],
	//array(USERS_PKG_NAME,'users_register_passcode',''),
	[ USERS_PKG_NAME, 'users_remember_me', 'y' ],
	[ USERS_PKG_NAME, 'users_remember_time', '86400' ],
	//array(USERS_PKG_NAME,'users_random_number_reg','n'),
	//array(USERS_PKG_NAME,'users_register_passcode','n'),
	//array(USERS_PKG_NAME,'users_validate_user','n'),
	//array(USERS_PKG_NAME,'users_validate_email','n'),
	[ USERS_PKG_NAME, 'users_min_pass_length', '4' ],
	//array(USERS_PKG_NAME,'users_custom_home','n'),
	//array(USERS_PKG_NAME,'user_bookmarks','n'),
	[ USERS_PKG_NAME, 'users_preferences', 'y' ],
	[ USERS_PKG_NAME, 'users_display_name', 'real_name' ],
	[ USERS_PKG_NAME, 'users_change_language', 'y' ],
	[ USERS_PKG_NAME, 'users_case_sensitive_login', 'y' ],
	//array(USERS_PKG_NAME, 'users_watches','n'),
] );

// ### Default Permissions
$gBitInstaller->registerUserPermissions( USERS_PKG_NAME, [
	[ 'p_users_create_bookmarks', 'Can create user bookmarksche user bookmarks', 'registered', USERS_PKG_NAME ],
	[ 'p_users_admin', 'Can edit the information for other users', 'admin', USERS_PKG_NAME ],
	[ 'p_users_view_icons_and_tools', 'Can view tab and tool links', 'basic', USERS_PKG_NAME ],
	[ 'p_users_view_user_list', 'Can view list of registered users', 'editors', USERS_PKG_NAME ],
	[ 'p_users_view_user_homepage', 'Can view personalized homepages', 'basic', USERS_PKG_NAME ],
	[ 'p_users_edit_user_homepage', 'Can create and display a personalized homepage', 'editors', USERS_PKG_NAME ],
	[ 'p_users_bypass_captcha', 'Can bypass spam validation mechanisms', 'registered', USERS_PKG_NAME ],
] );

// Package Requirements
$gBitInstaller->registerRequirements( USERS_PKG_NAME, [
	'liberty'   => [ 'min' => '5.0.0' ],
	'kernel'    => [ 'min' => '5.0.0' ],
	'themes'    => [ 'min' => '5.0.0' ],
	'languages' => [ 'min' => '5.0.0' ],
]);