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
|
<?php
class InitPersonalNotifications extends Migration
{
function description()
{
return 'inserts two tables for personal notifications';
}
function up()
{
$db = DBManager::get();
$db->exec("
CREATE TABLE IF NOT EXISTS `personal_notifications` (
`personal_notification_id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(512) NOT NULL DEFAULT '',
`text` text NOT NULL,
`avatar` varchar(256) NOT NULL DEFAULT '',
`html_id` varchar(64) NOT NULL DEFAULT '',
`mkdate` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`personal_notification_id`)
) ENGINE=MyISAM;");
$db->exec("
CREATE TABLE IF NOT EXISTS `personal_notifications_user` (
`personal_notification_id` int(10) unsigned NOT NULL,
`user_id` binary(32) NOT NULL,
`seen` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`personal_notification_id`,`user_id`),
KEY `user_id` (`user_id`,`seen`)
) ENGINE=MyISAM");
$db->exec("
INSERT IGNORE INTO `config`
(`config_id`, `parent_id`, `field`, `value`, `is_default`,
`type`, `range`, `section`, `position`, `mkdate`, `chdate`,
`description`, `comment`, `message_template`)
VALUES
(MD5('PERSONAL_NOTIFICATIONS_ACTIVATED'), '', 'PERSONAL_NOTIFICATIONS_ACTIVATED', 1, '1', 'boolean', 'global', 'privacy', '0', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 'Sollen persönliche Benachrichtigungen aktiviert sein?', '', '')
");
}
function down()
{
$db = DBManager::get();
$db->exec("DROP TABLE IF EXISTS `personal_notifications` ");
$db->exec("DROP TABLE IF EXISTS `personal_notifications_user` ");
$db->exec("DELETE FROM `config` WHERE `field` = 'PERSONAL_NOTIFICATIONS_ACTIVATED'");
}
}
|
