-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathtiki_2.0to3.0.sql
77 lines (67 loc) · 3.94 KB
/
tiki_2.0to3.0.sql
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
# $Id: tiki_2.0to3.0.sql 13749 2008-07-19 23:57:28Z m_stef $
#
# If you are using Tiki 3.x or later, this script will automatically be run by the installer when it detects that your data is from pre 3.x
#
# This approach of making one .sql file per version is obsolete. The new system is explained at: http://dev.tiki.org/Database+Schema+Upgrade
#
#
#
# The following script will update a Tiki database from version 2.0 to 3.0
#
# To execute this file do the following:
#
# $ mysql -f dbname < tiki_2.0to3.0.sql
#
# where dbname is the name of your tiki database.
#
# For example, if your tiki database is named tiki (not a bad choice), type:
#
# $ mysql -f tiki < tiki_2.0to3.0.sql
#
# You may execute this command as often as you like,
# and may safely ignore any error messages that appear.
#2008-07-24 sylvieg
SET @fgcant=0;
SELECT (@fgcant:=count(*)) FROM users_permissions WHERE permName = 'tiki_p_search_categorized';
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_search_categorized', 'Can search on objects of this category', 'basic', 'category');
INSERT INTO `users_objectpermissions` (groupName, permName, objectType, objectId) SELECT groupName, 'tiki_p_search_categorized', objectType , objectId FROM `users_objectpermissions` WHERE permName = 'tiki_p_view_categorized' AND @fgcant = 0;
#2008-08-05 sylvieg
ALTER TABLE tiki_quicktags ADD UNIQUE KEY no_repeats(taglabel(50), taginsert(50), tagicon(100), tagcategory(50));
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','wiki');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','newsletters');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','trackers');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','blogs');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','calendar');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','articles');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','faqs');
INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('Deleted','--text--','pics/icons/text_strikethrough.png','forums');
#2008-08-14 sept
UPDATE `tiki_menu_options` set `url`='tiki-list_file_gallery.php' where `url`='tiki-file_galleries.php';
#2008-08-14 pkdille
UPDATE `tiki_menu_options` SET `url`='tiki-admin_include_score.php' where `url`='tiki-admin_score.php';
#2008-08-16 princessxine
CREATE TABLE `tiki_feature` (
`feature_id` mediumint(9) NOT NULL auto_increment,
`feature_name` varchar(150) NOT NULL,
`parent_id` mediumint(9) NOT NULL,
`status` varchar(12) NOT NULL default 'active',
`setting_name` varchar(50) default NULL,
`feature_type` varchar(30) NOT NULL default 'feature',
`template` varchar(50) default NULL,
`permission` varchar(50) default NULL,
`ordinal` mediumint(9) NOT NULL default '1',
`depends_on` mediumint(9) default NULL,
`keyword` varchar(20) default NULL,
`feature_count` mediumint(9) NOT NULL default '0',
`feature_path` varchar(20) NOT NULL default '0',
PRIMARY KEY (`feature_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
#2008-08-17 lphuberdeau
UPDATE tiki_menu_options SET section = 'feature_wiki_structure' WHERE optionId = 47;
#2008-08-18 lphuberdeau
CREATE TABLE tiki_schema (
patch_name VARCHAR(30) PRIMARY KEY,
install_date TIMESTAMP
) ENGINE=MyISAM;
# This file is now obsolete. To modify the database, simply add a file to the installer/schema/
# directory. For more information, see http://dev.tikiwiki.org/DatabaseSchemaUpgrade