← Back to branch summary

~xibo-maintainers/xibo/tempel

« back to all changes in this revision

Viewing changes to install/database/61.sql

  • Committer: Dan Garner
  • Date: 2015-08-11 09:29:02 UTC
  • mto: This revision was merged to the branch mainline in revision 453.
  • Revision ID: git-v1:a86fb4369b7395c13367577d23b14c0ab4528c1a
Transitions fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
install/database/61.sql
 
1
TRUNCATE TABLE `help`;
 
2
 
 
3
INSERT INTO `help` (`HelpID`, `Topic`, `Category`, `Link`) VALUES
 
4
(1, 'Layout', 'General', 'manual/content/layout/overview.php'),
 
5
(2, 'Content', 'General', 'manual/content/content/types.php'),
 
6
(4, 'Schedule', 'General', 'manual/content/schedule/schedule_calendar.php'),
 
7
(5, 'Group', 'General', 'manual/content/users/groups.php'),
 
8
(6, 'Admin', 'General', 'manual/content/admin/settings.php'),
 
9
(7, 'Report', 'General', 'manual/content/admin/advanced.php'),
 
10
(8, 'Dashboard', 'General', 'manual/content/dashboard/dashboard.php'),
 
11
(9, 'User', 'General', 'manual/content/users/users.php'),
 
12
(10, 'Display', 'General', 'manual/content/admin/displays.php'),
 
13
(11, 'DisplayGroup', 'General', 'manual/content/admin/displays.php#Display_Group'),
 
14
(12, 'Layout', 'Add', 'manual/content/layout/addlayout.php'),
 
15
(13, 'Layout', 'Background', 'manual/content/layout/layoutdesigner.php#Background'),
 
16
(14, 'Content', 'Assign', 'manual/content/content/types.php'),
 
17
(15, 'Layout', 'RegionOptions', 'manual/content/layout/addregion.php'),
 
18
(16, 'Content', 'AddtoLibrary', 'manual/content/content/adding.php'),
 
19
(17, 'Display', 'Edit', 'manual/content/admin/displays.php#Display_Edit'),
 
20
(18, 'Display', 'Delete', 'manual/content/admin/displays.php#Display_Delete'),
 
21
(19, 'Displays', 'Groups', 'manual/content/admin/displays.php#Display_Group'),
 
22
(20, 'UserGroup', 'Add', 'manual/content/users/groups.php#Adding_Group'),
 
23
(21, 'User', 'Add', 'manual/content/users/users.php#Adding_User'),
 
24
(22, 'User', 'Delete', 'manual/content/users/users.php#Delete_User'),
 
25
(23, 'Content', 'Config', 'manual/content/admin/settings.php#Content'),
 
26
(24, 'LayoutMedia', 'Permissions', 'manual/content/layout/addlayout.php#Layout_Permission'),
 
27
(25, 'Region', 'Permissions', 'manual/content/layout/addregion.php#Region_Permissions'),
 
28
(26, 'Library', 'Assign', 'manual/content/layout/assigncontent.php#Add_From_Library'),
 
29
(27, 'Media', 'Delete', 'manual/content/content/types.php'),
 
30
(28, 'DisplayGroup', 'Add', 'manual/content/admin/displays.php#Display_Group'),
 
31
(29, 'DisplayGroup', 'Edit', 'manual/content/admin/displays.php#Display_Group'),
 
32
(30, 'DisplayGroup', 'Delete', 'manual/content/admin/displays.php#Display_Group'),
 
33
(31, 'DisplayGroup', 'Members', 'manual/content/admin/displays.php#Group_Members'),
 
34
(32, 'DisplayGroup', 'Permissions', 'manual/content/users/user_permissions.php'),
 
35
(34, 'Schedule', 'ScheduleNow', 'manual/content/schedule/schedule_now.php'),
 
36
(35, 'Layout', 'Delete', 'manual/content/layout/addlayout.php#Delete_Layout'),
 
37
(36, 'Layout', 'Copy', 'manual/content/layout/addlayout.php#Copy_Layout'),
 
38
(37, 'Schedule', 'Edit', 'manual/content/schedule/schedule_calendar.php'),
 
39
(38, 'Schedule', 'Add', 'manual/content/schedule/schedule_calendar.php'),
 
40
(39, 'Layout', 'Permissions', 'manual/content/layout/addregion.php#Region_Permissions'),
 
41
(40, 'Display', 'MediaInventory', 'manual/content/admin/displays.php#Media_Inventory'),
 
42
(41, 'User', 'ChangePassword', 'manual/content/dashboard/navbar.php#Navigation_Top'),
 
43
(42, 'Schedule', 'Delete', 'manual/content/schedule/schedule_event.htm'),
 
44
(43, 'Layout', 'Edit', 'manual/content/layout/addlayout.php#Edit_Layout'),
 
45
(44, 'Media', 'Permissions', 'manual/content/users/user_permissions.php'),
 
46
(45, 'Display', 'DefaultLayout', 'manual/content/admin/displays.php'),
 
47
(46, 'UserGroup', 'Edit', 'manual/content/users/groups.php#Edit_Group'),
 
48
(47, 'UserGroup', 'Members', 'manual/content/users/groups.php#Group_Member'),
 
49
(48, 'User', 'PageSecurity', 'manual/content/users/menu_page_security.php#Page_Security'),
 
50
(49, 'User', 'MenuSecurity', 'manual/content/users/menu_page_security.php#Menu_Security'),
 
51
(50, 'UserGroup', 'Delete', 'manual/content/users/groups.php#Delete_Group'),
 
52
(51, 'User', 'Edit', 'manual/content/users/users.php#Edit_User'),
 
53
(52, 'User', 'Applications', 'manual/content/users/menu_page_security.php'),
 
54
(53, 'User', 'SetHomepage', 'manual/content/dashboard/dashboard.php#Media_Dashboard'),
 
55
(54, 'DataSet', 'General', 'manual/content/layout/content_datasets.php'),
 
56
(55, 'DataSet', 'Add', 'manual/content/layout/content_datasets.php#Create_Dataset'),
 
57
(56, 'DataSet', 'Edit', 'manual/content/layout/content_datasets.php#Create_Dataset'),
 
58
(57, 'DataSet', 'Delete', 'manual/content/layout/content_datasets.php#Create_Dataset'),
 
59
(58, 'DataSet', 'AddColumn', 'manual/content/layout/content_datasets.php#Dataset_Column'),
 
60
(59, 'DataSet', 'EditColumn', 'manual/content/layout/content_datasets.php#Dataset_Column'),
 
61
(60, 'DataSet', 'DeleteColumn', 'manual/content/layout/content_datasets.php#Dataset_Column'),
 
62
(61, 'DataSet', 'Data', 'manual/content/layout/content_datasets.php#Dataset_Row'),
 
63
(62, 'DataSet', 'Permissions', 'manual/content/users/user_permissions.php'),
 
64
(63, 'Fault', 'General', 'manual/content/admin/advanced.php'),
 
65
(64, 'Report', 'General', 'manual/content/admin/advanced.php'),
 
66
(65, 'Stats', 'General', 'manual/content/admin/displays.php#Display_Statistic'),
 
67
(66, 'Resolution', 'General', 'manual/content/templates/template_resolution.php'),
 
68
(67, 'Template', 'General', 'manual/content/templates/overview.php'),
 
69
(68, 'Services', 'Register', 'manual/content/admin/api.php'),
 
70
(69, 'OAuth', 'General', 'manual/content/admin/api.php'),
 
71
(70, 'Services', 'Log', 'manual/content/admin/advanced.php'),
 
72
(71, 'Module', 'Edit', 'manual/content/admin/modules.php'),
 
73
(72, 'Module', 'General', 'manual/content/admin/modules.php'),
 
74
(73, 'Campaign', 'General', 'manual/content/layout/campaign_layout.php'),
 
75
(74, 'License', 'General', 'manual/content/license/licenses.php'),
 
76
(75, 'DataSet', 'ViewColumns', 'manual/content/layout/content_datasets.php#Dataset_Column'),
 
77
(76, 'Campaign', 'Permissions', 'manual/content/layout/addlayout.php#Layout_Permission'),
 
78
(77, 'Transition', 'Edit', 'manual/content/transitions/transitions.php#Edit');
 
79
 
 
80
ALTER TABLE  `menuitem` ADD  `External` TINYINT NOT NULL DEFAULT '0';
 
81
 
 
82
UPDATE `menuitem` SET External = 1 WHERE Class = 'help_button' AND PageID = (SELECT PageID FROM `pages` WHERE name = 'manual');
 
83
 
 
84
UPDATE `version` SET `app_ver` = '1.5.0', `XmdsVersion` = 3;
 
85
UPDATE `setting` SET `value` = 0 WHERE `setting` = 'PHONE_HOME_DATE';
 
86
UPDATE `version` SET `DBVersion` = '61';