1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
|
<?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' ],
]);
|
