Page Menu
Home
In-Portal Phabricator
Search
Configure Global Search
Log In
Files
F925313
upgrades.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Tue, May 20, 5:11 AM
Size
1 KB
Mime Type
text/plain
Expires
Thu, May 22, 5:11 AM (1 d, 41 m)
Engine
blob
Format
Raw Data
Handle
625417
Attached To
rMINN Modules.In-News
upgrades.sql
View Options
# ===== v 4.3.9 =====
INSERT
INTO
ImportScripts
VALUES
(
DEFAULT
,
'Articles from CSV file [In-News]'
,
''
,
'n'
,
'In-News'
,
''
,
'CSV'
,
'1'
);
# ===== v 5.0.0 =====
ALTER
TABLE
News
ADD
INDEX
(
StartDate
),
ADD
INDEX
(
Archived
);
UPDATE
Category
SET
Template
=
'/in-news/designs/section'
WHERE
Template
=
'innews/index'
;
UPDATE
Category
SET
CachedTemplate
=
'/in-news/designs/section'
WHERE
CachedTemplate
=
'innews/index'
;
UPDATE
ConfigurationValues
SET
VariableValue
=
'/in-news/designs/section'
WHERE
VariableName
=
'n_CategoryTemplate'
;
UPDATE
ConfigurationValues
SET
VariableValue
=
'in-news/designs/detail'
WHERE
VariableName
=
'n_ItemTemplate'
;
INSERT
INTO
Permissions
VALUES
(
DEFAULT
,
'in-news:articles.view'
,
11
,
1
,
1
,
0
);
INSERT
INTO
Permissions
VALUES
(
DEFAULT
,
'in-news:setting_folder.view'
,
11
,
1
,
1
,
0
);
DELETE
FROM
Permissions
WHERE
Permission
LIKE
'in-news:innews_general.%'
;
UPDATE
Phrase
SET
Module
=
'In-News'
WHERE
((
Phrase
LIKE
'%Article%'
OR
Phrase
LIKE
'%News%'
)
AND
(
Module
=
'Core'
)
AND
Phrase
NOT
IN
(
'la_ToolTip_NewSearchConfig'
,
'la_tooltip_newstylesheet'
));
UPDATE
Phrase
SET
Module
=
'In-News'
WHERE
Phrase
=
'la_title_In-News'
;
Event Timeline
Log In to Comment