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
|
<?php
global $gBitSystem, $gUpgradeFrom, $gUpgradeTo;
$upgrades = [
'BONNIE' => [
'CLYDE' => [
[ 'RENAMETABLE' => [
'tiki_sent_newsletters' => 'tiki_newsletters_editions',
'tiki_newsletter_subscriptions' => 'tiki_mail_subscriptions',
]],
// STEP 1
[ 'DATADICT' => [
[ 'RENAMECOLUMN' => [
'tiki_newsletters' => [ '`nlId`' => '`nl_id` I4 AUTO' ],
'tiki_newsletters' => [ '`allowUserSub`' => "`allow_user_sub` C(1) default 'y'" ],
'tiki_newsletters' => [ '`allowAnySub`' => '`allow_any_sub` C(1)' ],
'tiki_newsletters' => [ '`unsubMsg`' => "`unsub_msg` C(1) default 'y'" ],
'tiki_newsletters' => [ '`validateAddr`' => "`validate_addr` C(1) default 'y'" ],
'tiki_newsletters' => [ '`lastSent`' => '`last_sent` I8' ],
'tiki_newsletters_editions' => [ '`editionId`' => '`edition_id` I4 AUTO' ],
'tiki_newsletter_subscriptions' => [ '`code`' => "`sub_code` C(36)" ],
'tiki_newsletter_subscriptions' => [ '`valid`' => "`is_valid` C(1)" ],
'tiki_newsletter_subscriptions' => [ '`subscribed`' => "`subscribed_date` I8" ],
]],
// ALTER
[ 'ALTER' => [
'tiki_newsletters' => [
'content_id' => [ '`content_id`', 'I4' ],
],
'tiki_newsletters_editions' => [
'content_id' => [ '`content_id`', 'I4' ],
'nl_content_id' => [ '`nl_content_id`', 'I4' ],
'is_draft' => [ '`is_draft`', 'C(1)' ],
],
'tiki_newsletter_subscriptions' => [
'nl_content_id' => [ '`nl_content_id`', 'I4' ],
'response_content_id' => [ '`response_content_id`', 'I4' ],
'unsubscribe_all' => [ '`unsubscribe_all`', 'C(1)' ],
'unsubscribe_date' => [ '`unsubscribe_date`', 'I8' ],
],
]],
// CREATE
[ 'CREATE' => [
]],
]],
// STEP 3
[ 'QUERY' =>
[ 'SQL92' => [
],
], ],
// STEP 6
[ 'DATADICT' => [
[ 'DROPCOLUMN' => [
'tiki_newsletters' => [ '`name`', '`description`', '`created`', '`users`', '`editions`' ],
]],
]],
],
],
'BWR1' => [
'BWR2' => [
// de-tikify tables
[ 'DATADICT' => [
[ 'RENAMETABLE' => [
'tiki_newsletters' => 'newsletters',
'tiki_newsletters_editions' => 'newsletters_editions',
'tiki_mail_subscriptions' => 'mail_subscriptions',
'tiki_mail_errors' => 'mail_errors',
'tiki_mail_mailings' => 'mail_mailings',
'tiki_mail_queue' => 'mail_queue',
]],
[ 'CREATE' => [
'mail_clickthrough' => "
user_id I4 NOTNULL,
content_id I4 NOTNULL,
clicked_url C(250) NOTNULL,
clicks I4
CONSTRAINT ', CONSTRAINT `mail_clickthrough_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`),
CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
",
]],
[ 'ALTER' => [
'mail_queue' => [
'last_read_ip' => [ '`last_read_ip`', 'VARCHAR(40)' ],
],
]],
]],
],
],
];
if( isset( $upgrades[$gUpgradeFrom][$gUpgradeTo] ) ) {
$gBitSystem->registerUpgrade( NEWSLETTERS_PKG_NAME, $upgrades[$gUpgradeFrom][$gUpgradeTo] );
}
?>
|
