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
|
<?php
$tables = [
'blog_posts' => "
post_id I4 PRIMARY,
content_id I4 NOTNULL,
publish_date I4,
expire_date I4,
trackbacks_to X,
trackbacks_from X
CONSTRAINT '
, CONSTRAINT `blog_posts_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
",
'blogs' => "
blog_id I4 PRIMARY,
content_id I4 NOTNULL,
is_public C(1),
max_posts I4,
activity decimal(4,2),
use_find C(1),
use_title C(1),
add_date C(1),
add_poster C(1),
allow_comments C(1)
CONSTRAINT ', CONSTRAINT `blogs_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
",
'blogs_posts_map' => "
post_content_id I4 NOTNULL,
blog_content_id I4 NOTNULL,
date_added I4,
crosspost_note X
CONSTRAINT ', CONSTRAINT `blogs_posts_map_post_ref` FOREIGN KEY (`post_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)
, CONSTRAINT `blogs_posts_map_blog_ref` FOREIGN KEY (`blog_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
",
];
global $gBitInstaller;
foreach( array_keys( $tables ) AS $tableName ) {
$gBitInstaller->registerSchemaTable( BLOGS_PKG_NAME, $tableName, $tables[$tableName] );
}
$gBitInstaller->registerPackageInfo( BLOGS_PKG_NAME, [
'description' => "A Blog is a web based journal or diary.",
'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>',
] );
// ### Indexes
$indices = [
'blog_posts_post_id_idx' => [ 'table' => 'blog_posts', 'cols' => 'post_id', 'opts' => null ],
'blogs_content_id_idx' => [ 'table' => 'blogs', 'cols' => 'content_id', 'opts' => [ 'UNIQUE' ] ],
'blog_posts_content_id_idx' => [ 'table' => 'blog_posts', 'cols' => 'content_id', 'opts' => [ 'UNIQUE' ] ],
];
/** @TODO - SPIDERR - following seems to cause time _decrease_ cause bigint on postgres. need more investigation
* 'blog_posts_created_idx' => [ 'table' => 'blog_posts', 'cols' => 'created', 'opts' => null ],
**/
$gBitInstaller->registerSchemaIndexes( BLOGS_PKG_NAME, $indices );
// ### Sequences
$sequences = [
'blogs_blog_id_seq' => [ 'start' => 1 ],
'blog_posts_post_id_seq' => [ 'start' => 1 ],
];
$gBitInstaller->registerSchemaSequences( BLOGS_PKG_NAME, $sequences );
// ### Default UserPermissions
$gBitInstaller->registerUserPermissions( BLOGS_PKG_NAME, [
[ 'p_blogs_create', 'Can create a blog', 'registered', BLOGS_PKG_NAME ],
[ 'p_blogs_create_is_public', 'Can create a public blog', 'editors', BLOGS_PKG_NAME ],
[ 'p_blogs_post', 'Can create a blog post', 'registered', BLOGS_PKG_NAME ],
[ 'p_blogs_update', 'Can update blogs and blog posts', 'editors', BLOGS_PKG_NAME ],
[ 'p_blogs_send_post', 'Can email a blog post', 'registered', BLOGS_PKG_NAME ],
[ 'p_blogs_admin', 'Can admin blogs', 'editors', BLOGS_PKG_NAME ],
[ 'p_blogs_view', 'Can read blogs', 'basic', BLOGS_PKG_NAME ],
[ 'p_blog_posts_read_future', 'Can view future dated posts', 'editors', BLOGS_PKG_NAME ],
[ 'p_blog_posts_read_expired', 'Can view expired posts', 'editors', BLOGS_PKG_NAME ],
] );
// ### Default Preferences
$gBitInstaller->registerPreferences( BLOGS_PKG_NAME, [
[ BLOGS_PKG_NAME, 'blog_list_activity','y'],
[ BLOGS_PKG_NAME, 'blog_list_created','y'],
[ BLOGS_PKG_NAME, 'blog_list_description','y'],
[ BLOGS_PKG_NAME, 'blog_list_lastmodif','y'],
[ BLOGS_PKG_NAME, 'blog_list_order','created_desc'],
[ BLOGS_PKG_NAME, 'blog_list_posts','y'],
[ BLOGS_PKG_NAME, 'blog_list_title','y'],
[ BLOGS_PKG_NAME, 'blog_list_user','n'],
[ BLOGS_PKG_NAME, 'blog_list_visits','y'],
[ BLOGS_PKG_NAME, 'blog_categ','n'],
[ BLOGS_PKG_NAME, 'blog_parent_categ',0],
[ BLOGS_PKG_NAME, 'blog_posts_comments','n'],
[ BLOGS_PKG_NAME, 'blog_rankings','y'],
[ BLOGS_PKG_NAME, 'blog_list_user_as', 'text'],
[ BLOGS_PKG_NAME, 'blog_posts_description_length', '500'],
[ BLOGS_PKG_NAME, 'blog_posts_max_list','10'],
] );
// ### User Preferences Set In This Package
/** These are mentioned here for reference to understand how the package works
* They are not to be configured here!
*
* user_blog_posts_use_title, default y lets the user toggle to use a typed title for their posts or automatically use a date
* user_blog_posts_allow_comments, default y lets a user toggle comments on their blog posts
* user_blog_description_inc, default n lets a user include their personal page at the top of their blog
* blog_posts_autosplit, default n automatically uses two fields for editing posts
*
* @todo need an admin pref to override allow_comments option
* @todo need an admin pref to override description option
*
**/
if(defined('RSS_PKG_NAME')) {
$gBitInstaller->registerPreferences( BLOGS_PKG_NAME, [
[ RSS_PKG_NAME, BLOGS_PKG_NAME.'_rss', 'y' ],
]);
}
// ### Register content types
$gBitInstaller->registerContentObjects( BLOGS_PKG_NAME, [
'BitBlog'=>BLOGS_PKG_CLASS_PATH.'BitBlog.php',
'BitBlogPost'=>BLOGS_PKG_CLASS_PATH.'BitBlogPost.php',
] );
// Requirements
$gBitInstaller->registerRequirements( BLOGS_PKG_NAME, [
'liberty' => [ 'min' => '5.0.0' ],
] );
|
