TikiWiki Mod details : features-aulawiki

Back to list
This public repository lists the mods packages available from tikiwiki.org server. It's used by tikiwiki admins to update features that are not included in the public release of Tikiwiki. see TikiMods page on tw.o

features : aulawiki

authorjreyes (SF: jreyesg)
changelog0.1 initial package
0.2 fixed some bugs
0.3 fixed some bugs
0.4 TikiWiki 1.10 support
0.5 support to new Tiki resources
0.6 AulaWiki Workspaces renamed to Tiki Workspaces
0.7 fixed some bugs
0.8 fixed some bugs
1.6 updated to work on Tiki 2.x
1.7.0 new permission scheme. Works on tw 3.0
1.7.1 fixed some bugs, deleted some disturbing local tpl (tiki-user_menu.tpl, templates/styles/modules/mod-application_menu.tpl), and fixed display on tiki 2.x and 3.x through patching workspaces.css
1.7.2 group admin by non-admins is done. CRSF ticket when deleting a workspace fixed. Working without major issues with current Tiki 3 branch (LTS)
1.7.3 deleted outdated module.tpl and tiki-show_page.tpl so that default (and updated) ones in Tiki are used
contributorjreyesg
descriptionAulaWiki offers team collaboration environments (workspaces), allowing you to manage sets of Tiki resources in an easy way. See: http://doc.tikiwiki.org/Mod+AulaWiki
filesaulawiki-assignments_admin.php
tiki-workspaces_objectpermissions.php
tiki-workspaces_get_resource.php
tiki-workspaces_roles.php
aulawiki-view_gradebook.php
aulawiki-view_gradebook_xml.php
tiki-workspaces_view_module.php
tiki-workspaces_view_structure.php
tiki-workspaces_admin.php
tiki-workspaces_desktop.php
tiki-workspaces_modules.php
tiki-workspaces_types.php
tiki-workspaces_types_resources.php
tiki-workspaces_types_roles.php
tiki-workspaces_assigned_modules.php
images/workspaces/key.gif
images/workspaces/edu_survey.gif
images/workspaces/edu_tracker.gif
images/workspaces/edu_sheet.gif
images/workspaces/config.gif
images/workspaces/copy.gif
images/workspaces/delete.gif
images/workspaces/degrada.gif
images/workspaces/degrada2.gif
images/workspaces/degrada2gris.gif
images/workspaces/degrada2verde.gif
images/workspaces/degrada3.gif
images/workspaces/edu_article.gif
images/aulawiki/edu_assignments.gif
images/workspaces/edu_blog.gif
images/workspaces/edu_calendar.gif
images/workspaces/edu_faq.gif
images/workspaces/edu_filegallery.gif
images/workspaces/edu_folder.png
images/workspaces/edu_folder_closed.png
images/workspaces/edu_folder_dim.png
images/workspaces/edu_folder_open.png
images/workspaces/edu_forum.gif
images/workspaces/edu_group.gif
images/workspaces/edu_group.jpg
images/workspaces/edu_group_add.gif
images/workspaces/edu_group_new.gif
images/workspaces/edu_group_remove.gif
images/workspaces/edu_imagegallery.gif
images/workspaces/edu_nav_down.gif
images/workspaces/edu_nav_left.gif
images/workspaces/edu_nav_right.gif
images/workspaces/edu_nav_up.gif
images/workspaces/edu_paste.gif
images/workspaces/edu_quiz.gif
images/workspaces/edu_stop.gif
images/workspaces/edu_structure.gif
images/workspaces/edu_user_new.gif
images/workspaces/edu_wikipage.gif
images/workspaces/edu_workspace.gif
images/workspaces/edu_workspace.png
images/workspaces/edu_workspaceActive.png
images/workspaces/edu_workspaceActiveFOLDER.png
images/workspaces/edu_workspaceFOLDER.png
images/workspaces/edu_workspaceInactive.png
images/workspaces/edu_workspaces.png
images/workspaces/edu_workspace_grey.png
images/workspaces/edu_workspace_inactive.png
images/workspaces/user_blue.gif
images/workspaces/user_red.gif
images/workspaces/page.gif
images/workspaces/pageNueva.gif
images/workspaces/edu_zones.png
images/workspaces/edu_zones_add.png
images/workspaces/edu_zones_edit.png
images/workspaces/edu_zones_remove.png
images/workspaces/module.png
images/workspaces/module_add.png
images/workspaces/module_edit.png
images/workspaces/module_remove.png
images/workspaces/redarrow.gif
images/workspaces/grayarrow.gif
images/workspaces/info.png
images/workspaces/edu_role.gif
lib/aulawiki/assignmentslib.php
lib/workspaces/resourceslib.php
lib/workspaces/userlib.php
lib/aulawiki/periodslib.php
lib/workspaces/printlib.php
lib/workspaces/roleslib.php
lib/workspaces/workspacelib.php
lib/workspaces/workspacemoduleslib.php
lib/workspaces/typeslib.php
lib/smarty_tiki/function.edumenu.php
lib/smarty_tiki/block.tiki_workspaces_module.php
lib/smarty_tiki/block.ws_help.php
lib/smarty_tiki/function.workspaces_menu.php
styles/workspaces.css
styles/workspaces/index.php
styles/workspaces/options/index.php
styles/workspaces/options/wider_left_column.css
templates/tiki-workspaces_blog.tpl
templates/tiki-workspaces_objectpermissions.tpl
templates/aulawiki-assignments_admin.tpl
templates/tiki-workspaces_copy_to_clipboard.tpl
templates/tiki-workspaces_help.tpl
templates/tiki-workspaces_list_resources.tpl
templates/tiki-workspaces_module.tpl
templates/tiki-workspaces_module_error.tpl
templates/tiki-workspaces_menu.tpl
templates/tiki-workspaces_print.tpl
templates/tiki-workspaces_print_page.tpl
templates/tiki-workspaces_resource_types.tpl
templates/tiki-workspaces_roles.tpl
templates/tiki-workspaces_structure_tree.tpl
templates/aulawiki-view_gradebook.tpl
templates/aulawiki-view_gradebook_xml.tpl
templates/tiki-workspaces_view_module.tpl
templates/tiki-workspaces_admin.tpl
templates/tiki-workspaces_desktop.tpl
templates/tiki-workspaces_types.tpl
templates/tiki-workspaces_types_resources.tpl
templates/tiki-workspaces_types_roles.tpl
templates/tiki-workspaces_zones.tpl
templates/tiki-workspaces_assigned_modules.tpl
templates/modules/mod-workspaces_assistant.tpl
templates/modules/mod-aulawiki_assignments.tpl
templates/modules/mod-workspaces_break.tpl
templates/modules/mod-workspaces_calendar.tpl
templates/modules/mod-workspaces_calendar.tpl.nocache
templates/modules/mod-workspaces_childs.tpl
templates/modules/mod-workspaces_clipboard.tpl
templates/modules/mod-workspaces_clipboard.tpl.nocache
templates/modules/mod-workspaces_last_blog_posts.tpl
templates/modules/mod-workspaces_last_blog_posts.tpl.nocache
templates/modules/mod-workspaces_last_files.tpl
templates/modules/mod-workspaces_last_image.tpl
templates/modules/mod-workspaces_list_resources.tpl
templates/modules/mod-workspaces_my.tpl
templates/modules/mod-workspaces_my.tpl.nocache
templates/modules/mod-workspaces_resources.tpl
templates/modules/mod-workspaces_resources.tpl.nocache
templates/modules/mod-workspaces_user_groups.tpl
templates/modules/mod-workspaces_user_groups.tpl.nocache
templates/modules/mod-workspaces_owner.tpl
templates/modules/mod-workspaces_owner.tpl.nocache
templates/modules/mod-workspaces_viewpage.tpl
templates/modules/mod-workspaces_viewstructure.tpl
templates/modules/mod-aulawiki_view_assignment.tpl
templates/modules/mod-workspaces_who_is_there.tpl
templates/modules/mod-workspaces_who_is_there.tpl.nocache
templates/styles/workspaces/index.php
templates/styles/workspaces/tiki-user_edumenu.tpl
templates/styles/workspaces/tiki-user_information.tpl
templates/styles/workspaces/tiki-user_preferences.tpl
modules/mod-aulawiki_assignments.php
modules/mod-workspaces_calendar.php
modules/mod-workspaces_childs.php
modules/mod-workspaces_clipboard.php
modules/mod-workspaces_last_blog_posts.php
modules/mod-workspaces_last_files.php
modules/mod-workspaces_last_image.php
modules/mod-workspaces_list_resources.php
modules/mod-workspaces_my.php
modules/mod-workspaces_resources.php
modules/mod-workspaces_user_groups.php
modules/mod-workspaces_owner.php
modules/mod-workspaces_viewpage.php
modules/mod-workspaces_viewstructure.php
modules/mod-aulawiki_view_assignment.php
modules/mod-workspaces_who_is_there.php
modules/conf/modconf-workspaces_calendar.php
modules/conf/modconf-workspaces_childs.php
modules/conf/modconf-workspaces_clipboard.php
modules/conf/modconf-workspaces_last_blog_posts.php
modules/conf/modconf-workspaces_last_files.php
modules/conf/modconf-workspaces_last_image.php
modules/conf/modconf-workspaces_list_resources.php
modules/conf/modconf-workspaces_resources.php
modules/conf/modconf-workspaces_user_groups.php
modules/conf/modconf-workspaces_owner.php
modules/conf/modconf-workspaces_viewpage.php
modules/conf/modconf-workspaces_viewstructure.php
lastmodif2009-11-27 10:11:22
licenceGNU/LGPL
modnamefeatures-aulawiki
nameaulawiki
revision1.7.3
sql_installDROP TABLE IF EXISTS `tiki_workspace_role_wstype`;
DROP TABLE IF EXISTS `tiki_workspace_roles`;
DROP TABLE IF EXISTS `tiki_workspaces`;
DROP TABLE IF EXISTS `tiki_workspace_modules`;
DROP TABLE IF EXISTS `tiki_workspace_types`;
DROP TABLE IF EXISTS `tiki_workspace_zones`;
DROP TABLE IF EXISTS `aulawiki_assignment`;
DROP TABLE IF EXISTS `aulawiki_gradebook`;
DROP TABLE IF EXISTS `aulawiki_period`;
DROP TABLE IF EXISTS `aulawiki_period_type`;
CREATE TABLE `tiki_workspace_role_wstype` (`roleName` varchar(250) NOT NULL default '0',`typeId` int(14) NOT NULL default '0',`wstypePermGroup` varchar(250) default NULL, PRIMARY KEY (`typeId`,`roleName`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_roles` (`name` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`permgroup` varchar(250) default NULL,`description` varchar(250) NOT NULL default '', PRIMARY KEY (`name`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspaces` (`workspaceId` int(14) NOT NULL auto_increment, `code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(250) default '',`created` int(14) default '0',`startDate` int(14) default '0',`endDate` int(14) default '0',`closed` char(1) NOT NULL default 'y',`type` int(14) NOT NULL default '0',`parentId` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`owner` varchar(100) default '',`isuserws` char(1) NOT NULL default '',`hide` char(1) NOT NULL default '',`categoryId` int(12) NOT NULL default '0', PRIMARY KEY (`workspaceId`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_modules` (`moduleId` int(10) NOT NULL auto_increment,`name` varchar(200) NOT NULL default '',`position` char(1) default NULL,`ord` int(4) default NULL,`zoneId` int(11) NOT NULL default '0',`title` varchar(255) default NULL,`cache_time` int(14) default NULL,`rows` int(4) default NULL,`params` text,`groups` text,`style_data` varchar(150) default NULL,`style_title` varchar(150) default NULL, `uid` varchar(100) NOT NULL default '', PRIMARY KEY (`moduleId`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_types` (`wstypeId` int(14) NOT NULL auto_increment,`code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`menuid` int(8) NOT NULL default '0',`resources` text NOT NULL,`userwstype` int(14) NOT NULL default '0',`hide` char(1) NOT NULL default '',`active` char(1) NOT NULL default '', PRIMARY KEY (`wstypeId`)) TYPE=MyISAM;
CREATE TABLE tiki_workspace_zones (`zoneId` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`workspaceId` int(14) NOT NULL,`type` varchar(100) NOT NULL default '',`ord` int(4) NOT NULL default '0',`uid` varchar(100) NOT NULL default '', PRIMARY KEY (`zoneId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_assignment` (`assignmentId` int(14) NOT NULL auto_increment,`workspaceId` int(14) NOT NULL default '0',`periodId` int(14) NOT NULL default '0',`gradeWeight` int(5) NOT NULL default '0',`name` varchar(150) NOT NULL default '',`description` varchar(250) NOT NULL default '',`wikipage` varchar(100) NOT NULL default '',`createdby` varchar(100) NOT NULL default '',`creationDate` int(14) NOT NULL default '0',`startDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`type` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0', PRIMARY KEY (`assignmentId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_gradebook` (`assignmentId` int(14) NOT NULL default '0',`userId` varchar(100) NOT NULL default '',`comment` varchar(250) NOT NULL default '',`grade` int(4) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE `aulawiki_period` (`periodId` int(5) NOT NULL auto_increment,`periodTypeId` int(5) default '0',`name` varchar(100) NOT NULL default '',`description` varchar(100) default '',`startDate` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`gradeWeight` int(14) NOT NULL default '50', PRIMARY KEY (`periodId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_period_type` (`periodTypeId` int(14) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(250) NOT NULL default '', PRIMARY KEY (`periodTypeId`)) TYPE=MyISAM;
DELETE FROM tiki_menu_options WHERE url LIKE '%aulawiki%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%';
DELETE FROM tiki_menu_options WHERE url LIKE '%workspaces%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%workspace%';
DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%';
DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%';
DELETE FROM `tiki_preferences` WHERE name = 'feature_aulawiki';
DELETE FROM `tiki_preferences` WHERE name = 'feature_workspaces';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_user_assigned_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%workspaces%';
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Teacher', '2fd99c1c873d19ee003a5bde9b832607', 'RolePerms-Teacher', 'Teacher');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Student', '9d94a9b153bc6e7a162262b109ce3829', 'RolePerms-Student', 'Student');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Owner', 'cf658411eca2e230d90276c5a0235a1b', 'RolePerms-Owner', 'Portfolio owner');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Registered', 'a671a29eef794f7423ae567f7d964d42', 'Registered', 'Registered users');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Anonymous', '77f08d9b1ee1a29d11aabefbeca5d1e5', 'Anonymous', 'Anonymous users');
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Teacher';
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Student';
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Owner';
DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPTeacher';
DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPStudent';
DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPOwner';
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Teacher', 'Teacher role permissions template');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Student', 'Student role permissions template');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Owner', 'Owner role permissions template');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPTeacher', 'Teacher role group');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPStudent', 'Student role group');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPOwner', 'Owner role group');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments','NULL');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_admin_workspace','Can admin workspaces','admin','workspace','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_create_workspace_resour','Can create new workspace resources','editors','workspace','');
INSERT INTO tiki_menus (menuId, name, description, type, icon) VALUES (100,'Workspace menu','Sample workspace menu','d', '');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Workspaces','./tiki-workspaces_admin.php',1020,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Workspaces','./tiki-workspaces_admin.php',1022,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Workspace Types','./tiki-workspaces_types.php',1024,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Roles','./tiki-workspaces_roles.php',1026,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Users/Groups','./tiki-workspaces_view_module.php?module=workspaces_user_groups',10,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Resources','./tiki-workspaces_view_module.php?module=workspaces_resources',52,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Blogs list','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=blog',60,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Img galeries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=image gallery',70,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','File galleries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=file gallery',71,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Wiki Pages','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=wiki page',72,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Forums','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=forum',73,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Calendars','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=calendar',74,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','History','./tiki-workspaces_get_resource.php?name=History',80,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Gradebook','./aulawiki-view_gradebook.php',1,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Assignments','./aulawiki-assignments_admin.php',41,'','','');
INSERT INTO tiki_preferences (name,value) VALUES ( 'feature_workspaces', 'y');
INSERT INTO tiki_workspace_types VALUES ('1','PORTFOLIO','Portfolio','','f6dfa6643939c4887a68710a5b8c27b5','100','a:2:{i:0;a:3:{s:4:"name";s:6:"MyBlog";s:4:"desc";s:7:"My Blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:19:"Home portfolio page";s:4:"type";s:9:"wiki page";}}','0','n','y');
INSERT INTO tiki_workspace_types VALUES ('2','COURSE','Course','Sample course type','bcff9b0c6b65e3d060685650d3e6b6e1','100','a:5:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:16:"Home course page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:2;a:3:{s:4:"name";s:5:"Files";s:4:"desc";s:12:"Course files";s:4:"type";s:12:"file gallery";}i:3;a:3:{s:4:"name";s:6:"Images";s:4:"desc";s:13:"Course images";s:4:"type";s:13:"image gallery";}i:4;a:3:{s:4:"name";s:5:"Forum";s:4:"desc";s:12:"Course forum";s:4:"type";s:5:"forum";}}','3','n','y');
INSERT INTO tiki_workspace_types VALUES ('3','PERSONAL','Personal workspace type','Sample personal workspace','dcd9e72f70d04fa9399db80a3fa056d8','100','a:2:{i:0;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:18:"Personal home page";s:4:"type";s:9:"wiki page";}}','0','y','y');
INSERT INTO tiki_workspace_types VALUES ('4','FOLDER','Folder','','9e39b5e9a566a61ce60417a9429ff0f0','0','a:1:{i:0;s:8:"wikipage";}','0','','y');
INSERT INTO tiki_workspace_types VALUES ('5','GROUP','Student group','','b4a6f4eef0d1e1111d568b50195b45e0','100','a:2:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:15:"Group home page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:10:"Group blog";s:4:"type";s:4:"blog";}}','0','y','y');
INSERT INTO tiki_workspace_zones VALUES (1,'main','main zone',1,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c39');
INSERT INTO tiki_workspace_zones VALUES (2,'main','main zone',2,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c40');
INSERT INTO tiki_workspace_zones VALUES (3,'main','main zone',3,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c41');
INSERT INTO tiki_workspace_zones VALUES (5,'main','main zone',5,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c43');
INSERT INTO tiki_workspace_modules VALUES ('1','workspaces_last_blog_posts','2','3',1,'My Blog','0','0','name=%WSCODE%-MyBlog','','','','68809e75ced4d1f52bec9eb73bc32cdc');
INSERT INTO tiki_workspace_modules VALUES ('2','workspaces_viewpage','1','1',1,'Portfolio Home','0','0','name=%WSCODE%-Home','','','','6ac0bc2518a0c836de87662defbada90');
INSERT INTO tiki_workspace_modules VALUES ('3','workspaces_who_is_there','2','1',2,'Course users','0','0','','','','','cbbbb0122cb4aca6c83859cda85bdecd');
INSERT INTO tiki_workspace_modules VALUES ('5','workspaces_last_blog_posts','1','3',2,'Course History','0','0','name=%WSCODE%-History&maxPosts=3&showBar=n','','','','da1d338b0fb3d87256341b4154ba96c5');
INSERT INTO tiki_workspace_modules VALUES ('6','workspaces_viewpage','2','1',3,'Home page','0','0','name=%WSCODE%-Home','','','','1f1b76a1f4dff160d31ae36a11170ede');
INSERT INTO tiki_workspace_modules VALUES ('7','workspaces_last_blog_posts','2','5',3,'History','0','0','name=%WSCODE%-History','','','','ae744c4a52b38e5386c99ddc43edc8be');
INSERT INTO tiki_workspace_modules VALUES ('9','workspaces_last_files','3','11',2,'Course files','0','0','name=%WSCODE%-Files&maxFiles=3&showBar=y&','','','','ce32d51600a7f6b3f999be9ec467c5d7');
INSERT INTO tiki_workspace_modules VALUES ('10','workspaces_break','1','5',2,'','0','0','','','','','781330d16d490e7a88237e2aa1983ce1');
INSERT INTO tiki_workspace_modules VALUES ('19','workspaces_break','2','2',1,'','0','0','','','','','b0678bf202e5b4417bb6fdcae969626e');
INSERT INTO tiki_workspace_modules VALUES ('17','workspaces_last_image','3','15',2,'Images','0','0','name=%WSCODE%-Images&maxImages=3&showBar=y&','','','','f73d1e5f2a56721284d38eba1da56de0');
INSERT INTO tiki_workspace_modules VALUES ('15','workspaces_calendar','2','6',2,'Course calendar','0','0','','','','','7126d03da3815b92f80feef1e8598ddb');
INSERT INTO tiki_workspace_modules VALUES ('14','workspaces_childs','2','5',2,'Child workspaces','0','0','','','','','e4604c1cea8879a11425ebcae8aab4d1');
INSERT INTO tiki_workspace_modules VALUES ('16','workspaces_viewpage','1','10',2,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','a91e337ce2b81ce208523635e1471faa');
INSERT INTO tiki_workspace_modules VALUES ('22','workspaces_owner','1','1',3,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','017e28f378066a9c8c6d2a66f435f3cd');
INSERT INTO tiki_workspace_modules VALUES ('20','workspaces_owner','2','1',1,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','b162f68536c92a270150ae475bd8308f');
INSERT INTO tiki_workspace_modules VALUES ('28','workspaces_viewpage','1','1',5,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','40ca0c9474d974dba3e73ff3fc9db3a7');
INSERT INTO tiki_workspace_modules VALUES ('29','workspaces_last_blog_posts','1','2',5,'Blog','0','0','name=%WSCODE%-History&maxPosts=5&showBar=y&','','','','a8fa9590762ec2cceee9934378631b3b');
INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','1','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Student','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','3','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','3','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','5','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Student','5','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Registered','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Anonymous','2','');
INSERT INTO tiki_modules (name,position,ord,cache_time,groups) VALUES ('workspaces_assistant','r',9,0,'a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}');
sql_removeDELETE FROM tiki_menu_options WHERE url LIKE '%aulawiki%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%';
DELETE FROM tiki_menu_options WHERE url LIKE '%workspaces%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%workspace%';
DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%';
DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%';
DELETE FROM `tiki_preferences` WHERE name = 'feature_aulawiki';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_user_assigned_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%workspaces%';
DROP TABLE IF EXISTS `aulawiki_assignment`;
DROP TABLE IF EXISTS `aulawiki_gradebook`;
DROP TABLE IF EXISTS `aulawiki_period`;
DROP TABLE IF EXISTS `aulawiki_period_type`;
DROP TABLE IF EXISTS `tiki_workspace_role_wstype`;
DROP TABLE IF EXISTS `tiki_workspace_roles`;
DROP TABLE IF EXISTS `tiki_workspaces`;
DROP TABLE IF EXISTS `tiki_workspace_modules`;
DROP TABLE IF EXISTS `tiki_workspace_types`;
DROP TABLE IF EXISTS `tiki_workspace_zones`;
sql_upgradeDELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%';
DELETE FROM `users_grouppermissions` WHERE `permName`='tiki_p_admin_workspaces_roles';
ALTER TABLE tiki_workspace_types CHANGE `id` `wstypeId` int(14) NOT NULL auto_increment;
DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1020;
Array
Array
typefeatures
version3.0