<?php
// removed image data (replaced with storage_id ref)
// removed hash, state
// removed isfloat (?)
// removed size, topic_name (replaced with topic_id)
// replaced type_name with article_type_id

$tables = [
	'article_status' => "
		status_id	I4 PRIMARY,
		status_name C(64)
	",

	'article_types'  => "
		article_type_id I4 PRIMARY,
		type_name C(50),
		use_ratings C(1),
		show_pre_publ C(1),
		show_post_expire C(1) DEFAULT 'y',
		heading_only C(1),
		allow_comments C(1) DEFAULT 'n',
		show_image C(1) DEFAULT 'y',
		show_avatar C(1),
		show_author C(1) DEFAULT 'y',
		show_pubdate C(1) DEFAULT 'y',
		show_expdate C(1),
		show_reads C(1) DEFAULT 'y',
		show_size C(1) DEFAULT 'y',
		creator_edit C(1),
		comment_can_rate_article C(1)
	",

	'article_topics' => "
		topic_id I4 PRIMARY,
		topic_name C(40),
		has_topic_image C(1),
		active_topic C(1),
		created I8
	",

	'articles'       => "
		article_id I4 PRIMARY,
		content_id I4 NOTNULL,
		description X,
		author_name C(250),
		publish_date I4,
		expire_date I4,
		article_type_id I4,
		topic_id I4,
		rating F,
		status_id I4
		CONSTRAINT ', CONSTRAINT `articles_content_ref` FOREIGN KEY (`content_id`) REFERENCES `" . BIT_DB_PREFIX . "liberty_content` (`content_id`)
					, CONSTRAINT `articles_topic_ref` FOREIGN KEY (`topic_id`) REFERENCES `" . BIT_DB_PREFIX . "article_topics` (`topic_id`)
					, CONSTRAINT `articles_type_ref` FOREIGN KEY (`article_type_id`) REFERENCES `" . BIT_DB_PREFIX . "article_types` (`article_type_id`)
					, CONSTRAINT `articles_status` FOREIGN KEY (`status_id`) REFERENCES `" . BIT_DB_PREFIX . "article_status` (`status_id`)'
	",
];

global $gBitInstaller;

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

$gBitInstaller->registerPackageInfo( ARTICLES_PKG_NAME, [
	'description' => "This package manages news articles to create a slashdot-like news site.",
	'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>',
] );

// these sequences are automatically generated, but Firebird and MSSQL prefers they exist
// Starting the numbering off at 5 for types to allow room for the INSERTs later.
$sequences = [
	'articles_topics_id_seq'  => [ 'start' => 1 ],
	'article_types_id_seq'    => [ 'start' => 5 ],
	'articles_article_id_seq' => [ 'start' => 1 ],
];
$gBitInstaller->registerSchemaSequences( ARTICLES_PKG_NAME, $sequences );

// $indices = array();
// $gBitInstaller->registerSchemaIndexes( ARTICLES_PKG_NAME, $indices );

$gBitInstaller->registerSchemaDefault( ARTICLES_PKG_NAME, [
	"INSERT INTO `" . BIT_DB_PREFIX . "article_types` (`article_type_id`, `type_name`) VALUES (1, 'Article')",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_types` (`article_type_id`, `type_name`, `use_ratings`) VALUES (2, 'Review','y')",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_types` (`article_type_id`, `type_name`, `show_post_expire`) VALUES (3, 'Event','n')",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_types` (`article_type_id`, `type_name`, `show_post_expire`,`heading_only`,`allow_comments`) VALUES (4, 'Classified','n','y','n')",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_status` (`status_id`, `status_name`) VALUES (  0, 'Denied') ",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_status` (`status_id`, `status_name`) VALUES (100, 'Draft') ",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_status` (`status_id`, `status_name`) VALUES (200, 'Pending Approval') ",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_status` (`status_id`, `status_name`) VALUES (300, 'Approved') ",
	"INSERT INTO `" . BIT_DB_PREFIX . "article_status` (`status_id`, `status_name`) VALUES (400, 'Retired') ",
] );

// ### Default UserPermissions
$gBitInstaller->registerUserPermissions( ARTICLES_PKG_NAME, [
	[ 'p_articles_update', 'Can update articles', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_remove', 'Can remove articles', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_read', 'Can read articles', 'basic', ARTICLES_PKG_NAME ],
	[ 'p_articles_read_history', 'Can read article history', 'registered', ARTICLES_PKG_NAME ],
	[ 'p_articles_submit', 'Can submit articles', 'basic', ARTICLES_PKG_NAME ],
	[ 'p_articles_update_submission', 'Can update submissions', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_remove_submission', 'Can remove submissions', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_approve_submission', 'Can approve submissions', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_send', 'Can send articles to other sites', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_sendme', 'Can send articles to this site', 'registered', ARTICLES_PKG_NAME ],
	[ 'p_articles_auto_approve', 'Submited articles automatically approved', 'editors', ARTICLES_PKG_NAME ],
	[ 'p_articles_admin', 'Can admin the articles package', 'editors', ARTICLES_PKG_NAME ],
] );

// ### Default Preferences
$gBitInstaller->registerPreferences( ARTICLES_PKG_NAME, [
	[ ARTICLES_PKG_NAME, 'articles_attachments', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_author', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_date', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_img', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_reads', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_size', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_title', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_topic', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_type', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_list_expire', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_max_list', '10' ],
	[ ARTICLES_PKG_NAME, 'articles_rankings', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_submissions', 'y' ],
	[ ARTICLES_PKG_NAME, 'articles_description_length', '500' ],
	[ ARTICLES_PKG_NAME, 'articles_date_threshold', 'week' ],
] );

if( defined( 'RSS_PKG_NAME' )) {
	$gBitInstaller->registerPreferences( ARTICLES_PKG_NAME, [
		[ RSS_PKG_NAME, ARTICLES_PKG_NAME . '_rss', 'y' ],
	]);
}

// ### Register content types
$gBitInstaller->registerContentObjects( ARTICLES_PKG_NAME, [
	'BitArticle' => ARTICLES_PKG_CLASS_PATH . 'BitArticle.php',
]);

// Requirements
$gBitInstaller->registerRequirements( ARTICLES_PKG_NAME, [
	'liberty' => [ 'min' => '5.0.0' ],
]);