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
|
<?php
$tables = array(
'tiki_calendar_categories' => "
cal_cat_id I4 AUTO PRIMARY,
calendar_id I4 NOTNULL,
name C(160) NOTNULL
",
'tiki_calendar_items' => "
calitem_id I4 AUTO PRIMARY,
calendar_id I4 NOTNULL,
start_time I8 NOTNULL,
end_time I8 NOTNULL,
location_id I4,
category_id I4,
priority C(1) NOTNULL DEFAULT '1',
status C(1) NOTNULL DEFAULT '0',
url C(255),
lang C(2) NOTNULL default 'en',
name C(255) NOTNULL,
description B,
user_id I4,
created I8 NOTNULL,
lastmodif I8 NOTNULL
",
'tiki_calendar_locations' => "
calloc_id I4 AUTO PRIMARY,
calendar_id I4 NOTNULL,
name C(160) NOTNULL,
description X
",
'tiki_calendar_roles' => "
calitem_id I4 NOTNULL PRIMARY,
user_id I4 NOTNULL PRIMARY,
role C(1) NOTNULL DEFAULT '0'
",
'tiki_calendars' => "
calendar_id I4 AUTO PRIMARY,
name C(80) NOTNULL,
description C(255),
user_id I4 NOTNULL,
customlocations C(1) NOTNULL DEFAULT 'n',
customcategories C(1) NOTNULL DEFAULT 'n',
customlanguages C(1) NOTNULL DEFAULT 'n',
custompriorities C(1) NOTNULL DEFAULT 'n',
customparticipants C(1) NOTNULL DEFAULT 'n',
created I8 NOTNULL,
lastmodif I8 NOTNULL
"
);
global $gBitInstaller;
$gBitInstaller->makePackageHomeable('calendar');
foreach( array_keys( $tables ) AS $tableName ) {
$gBitInstaller->registerSchemaTable( CALENDAR_PKG_NAME, $tableName, $tables[$tableName] );
}
// ### Indexes
$indices = array (
'tiki_calendar_categories_idx' => array( 'table' => 'tiki_calendar_categories', 'cols' => 'calendar_id,name', 'opts' => NULL ),
'tiki_calendar_items_idx' => array( 'table' => 'tiki_calendar_items', 'cols' => 'calendar_id', 'opts' => NULL ),
'tiki_calendar_locations_idx' => array( 'table' => 'tiki_calendar_locations', 'cols' => 'name', 'opts' => NULL )
);
$gBitInstaller->registerSchemaIndexes( CALENDAR_PKG_NAME, $indices );
$gBitInstaller->registerPackageInfo( CALENDAR_PKG_NAME, array(
'description' => "Calendar package to display bitweaver entries by date, and set events",
'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>',
) );
// ### Defaults
// ### Default User Permissions
$gBitInstaller->registerUserPermissions( CALENDAR_PKG_NAME, array(
array('bit_p_view_calendar', 'Can browse the calendar', 'basic', CALENDAR_PKG_NAME),
array('bit_p_change_events', 'Can change events in the calendar', 'registered', CALENDAR_PKG_NAME),
array('bit_p_add_events', 'Can add events in the calendar', 'registered', CALENDAR_PKG_NAME),
array('bit_p_admin_calendar', 'Can create/admin calendars', 'admin', CALENDAR_PKG_NAME)
) );
// ### Default Preferences
$gBitInstaller->registerPreferences( CALENDAR_PKG_NAME, array(
// array ('kernel', 'feature_jscalendar', 'n'),
array (CALENDAR_PKG_NAME, 'calendar_blogs', 'y'),
array (CALENDAR_PKG_NAME, 'calendar_users', 'y'),
array (CALENDAR_PKG_NAME, 'calendar_wiki', 'y')
) );
?>
|
