contributor:
$Author: jreyesg $

revision:
$Revision: 1.5 $

lastmodif:
$Date: 2007/03/03 08:41:17 $

files:
features/aulawiki/aulawiki-assignments_admin.php aulawiki-assignments_admin.php
features/aulawiki/tiki-workspaces_objectpermissions.php tiki-workspaces_objectpermissions.php
features/aulawiki/tiki-workspaces_get_resource.php tiki-workspaces_get_resource.php
features/aulawiki/tiki-workspaces_roles.php tiki-workspaces_roles.php
features/aulawiki/aulawiki-view_gradebook.php aulawiki-view_gradebook.php
features/aulawiki/aulawiki-view_gradebook_xml.php aulawiki-view_gradebook_xml.php
features/aulawiki/tiki-workspaces_view_module.php tiki-workspaces_view_module.php
features/aulawiki/tiki-workspaces_view_structure.php tiki-workspaces_view_structure.php
features/aulawiki/tiki-workspaces_admin.php tiki-workspaces_admin.php 
features/aulawiki/tiki-workspaces_desktop.php tiki-workspaces_desktop.php
features/aulawiki/tiki-workspaces_modules.php tiki-workspaces_modules.php
features/aulawiki/tiki-workspaces_types.php tiki-workspaces_types.php
features/aulawiki/tiki-workspaces_types_resources.php tiki-workspaces_types_resources.php
features/aulawiki/tiki-workspaces_types_roles.php tiki-workspaces_types_roles.php
features/aulawiki/tiki-workspaces_assigned_modules.php tiki-workspaces_assigned_modules.php
features/aulawiki/images/workspaces/key.gif images/workspaces/key.gif
features/aulawiki/images/workspaces/edu_survey.gif images/workspaces/edu_survey.gif
features/aulawiki/images/workspaces/edu_tracker.gif images/workspaces/edu_tracker.gif
features/aulawiki/images/workspaces/edu_sheet.gif images/workspaces/edu_sheet.gif
features/aulawiki/images/workspaces/config.gif images/workspaces/config.gif
features/aulawiki/images/workspaces/copy.gif images/workspaces/copy.gif
features/aulawiki/images/workspaces/delete.gif images/workspaces/delete.gif
features/aulawiki/images/workspaces/degrada.gif images/workspaces/degrada.gif
features/aulawiki/images/workspaces/degrada2.gif images/workspaces/degrada2.gif
features/aulawiki/images/workspaces/degrada2gris.gif images/workspaces/degrada2gris.gif
features/aulawiki/images/workspaces/degrada2verde.gif images/workspaces/degrada2verde.gif
features/aulawiki/images/workspaces/degrada3.gif images/workspaces/degrada3.gif
features/aulawiki/images/workspaces/edu_article.gif images/workspaces/edu_article.gif
features/aulawiki/images/aulawiki/edu_assignments.gif images/aulawiki/edu_assignments.gif
features/aulawiki/images/workspaces/edu_blog.gif images/workspaces/edu_blog.gif
features/aulawiki/images/workspaces/edu_calendar.gif images/workspaces/edu_calendar.gif
features/aulawiki/images/workspaces/edu_faq.gif images/workspaces/edu_faq.gif
features/aulawiki/images/workspaces/edu_filegallery.gif images/workspaces/edu_filegallery.gif
features/aulawiki/images/workspaces/edu_folder.png images/workspaces/edu_folder.png
features/aulawiki/images/workspaces/edu_folder_closed.png images/workspaces/edu_folder_closed.png
features/aulawiki/images/workspaces/edu_folder_dim.png images/workspaces/edu_folder_dim.png
features/aulawiki/images/workspaces/edu_folder_open.png images/workspaces/edu_folder_open.png
features/aulawiki/images/workspaces/edu_forum.gif images/workspaces/edu_forum.gif
features/aulawiki/images/workspaces/edu_group.gif images/workspaces/edu_group.gif
features/aulawiki/images/workspaces/edu_group.jpg images/workspaces/edu_group.jpg
features/aulawiki/images/workspaces/edu_group_add.gif images/workspaces/edu_group_add.gif
features/aulawiki/images/workspaces/edu_group_new.gif images/workspaces/edu_group_new.gif
features/aulawiki/images/workspaces/edu_group_remove.gif images/workspaces/edu_group_remove.gif
features/aulawiki/images/workspaces/edu_imagegallery.gif images/workspaces/edu_imagegallery.gif
features/aulawiki/images/workspaces/edu_nav_down.gif images/workspaces/edu_nav_down.gif
features/aulawiki/images/workspaces/edu_nav_left.gif images/workspaces/edu_nav_left.gif
features/aulawiki/images/workspaces/edu_nav_right.gif images/workspaces/edu_nav_right.gif
features/aulawiki/images/workspaces/edu_nav_up.gif images/workspaces/edu_nav_up.gif
features/aulawiki/images/workspaces/edu_paste.gif images/workspaces/edu_paste.gif
features/aulawiki/images/workspaces/edu_quiz.gif images/workspaces/edu_quiz.gif
features/aulawiki/images/workspaces/edu_stop.gif images/workspaces/edu_stop.gif
features/aulawiki/images/workspaces/edu_structure.gif images/workspaces/edu_structure.gif
features/aulawiki/images/workspaces/edu_user_new.gif images/workspaces/edu_user_new.gif
features/aulawiki/images/workspaces/edu_wikipage.gif images/workspaces/edu_wikipage.gif
features/aulawiki/images/workspaces/edu_workspace.gif images/workspaces/edu_workspace.gif
features/aulawiki/images/workspaces/edu_workspace.png images/workspaces/edu_workspace.png
features/aulawiki/images/workspaces/edu_workspaceActive.png images/workspaces/edu_workspaceActive.png
features/aulawiki/images/workspaces/edu_workspaceActiveFOLDER.png images/workspaces/edu_workspaceActiveFOLDER.png
features/aulawiki/images/workspaces/edu_workspaceFOLDER.png images/workspaces/edu_workspaceFOLDER.png
features/aulawiki/images/workspaces/edu_workspaceInactive.png images/workspaces/edu_workspaceInactive.png
features/aulawiki/images/workspaces/edu_workspaces.png images/workspaces/edu_workspaces.png
features/aulawiki/images/workspaces/edu_workspace_grey.png images/workspaces/edu_workspace_grey.png
features/aulawiki/images/workspaces/edu_workspace_inactive.png images/workspaces/edu_workspace_inactive.png
features/aulawiki/images/workspaces/user_blue.gif images/workspaces/user_blue.gif
features/aulawiki/images/workspaces/user_red.gif images/workspaces/user_red.gif
features/aulawiki/images/workspaces/page.gif images/workspaces/page.gif
features/aulawiki/images/workspaces/pageNueva.gif images/workspaces/pageNueva.gif
features/aulawiki/images/workspaces/edu_zones.png images/workspaces/edu_zones.png
features/aulawiki/images/workspaces/edu_zones_add.png images/workspaces/edu_zones_add.png
features/aulawiki/images/workspaces/edu_zones_edit.png images/workspaces/edu_zones_edit.png
features/aulawiki/images/workspaces/edu_zones_remove.png images/workspaces/edu_zones_remove.png
features/aulawiki/images/workspaces/module.png images/workspaces/module.png
features/aulawiki/images/workspaces/module_add.png images/workspaces/module_add.png
features/aulawiki/images/workspaces/module_edit.png images/workspaces/module_edit.png
features/aulawiki/images/workspaces/module_remove.png images/workspaces/module_remove.png
features/aulawiki/images/workspaces/redarrow.gif images/workspaces/redarrow.gif
features/aulawiki/images/workspaces/grayarrow.gif images/workspaces/grayarrow.gif
features/aulawiki/images/workspaces/info.png images/workspaces/info.png
features/aulawiki/images/workspaces/edu_role.gif images/workspaces/edu_role.gif
features/aulawiki/lib/aulawiki/assignmentslib.php lib/aulawiki/assignmentslib.php
features/aulawiki/lib/workspaces/resourceslib.php lib/workspaces/resourceslib.php
features/aulawiki/lib/workspaces/userlib.php lib/workspaces/userlib.php
features/aulawiki/lib/aulawiki/periodslib.php lib/aulawiki/periodslib.php
features/aulawiki/lib/workspaces/printlib.php lib/workspaces/printlib.php
features/aulawiki/lib/workspaces/roleslib.php lib/workspaces/roleslib.php
features/aulawiki/lib/workspaces/workspacelib.php lib/workspaces/workspacelib.php
features/aulawiki/lib/workspaces/workspacemoduleslib.php lib/workspaces/workspacemoduleslib.php
features/aulawiki/lib/workspaces/typeslib.php lib/workspaces/typeslib.php
features/aulawiki/lib/smarty_tiki/function.edumenu.php lib/smarty_tiki/function.edumenu.php
features/aulawiki/lib/smarty_tiki/block.tiki_workspaces_module.php lib/smarty_tiki/block.tiki_workspaces_module.php
features/aulawiki/lib/smarty_tiki/block.ws_help.php lib/smarty_tiki/block.ws_help.php
features/aulawiki/lib/smarty_tiki/function.workspaces_menu.php lib/smarty_tiki/function.workspaces_menu.php
features/aulawiki/styles/workspaces.css styles/workspaces.css
features/aulawiki/templates/tiki-workspaces_blog.tpl templates/tiki-workspaces_blog.tpl
features/aulawiki/templates/tiki-workspaces_objectpermissions.tpl templates/tiki-workspaces_objectpermissions.tpl
features/aulawiki/templates/aulawiki-assignments_admin.tpl templates/aulawiki-assignments_admin.tpl
features/aulawiki/templates/tiki-workspaces_copy_to_clipboard.tpl templates/tiki-workspaces_copy_to_clipboard.tpl
features/aulawiki/templates/tiki-workspaces_help.tpl templates/tiki-workspaces_help.tpl
features/aulawiki/templates/tiki-workspaces_list_resources.tpl templates/tiki-workspaces_list_resources.tpl
features/aulawiki/templates/tiki-workspaces_module.tpl templates/tiki-workspaces_module.tpl
features/aulawiki/templates/tiki-workspaces_module_error.tpl templates/tiki-workspaces_module_error.tpl
features/aulawiki/templates/tiki-workspaces_menu.tpl templates/tiki-workspaces_menu.tpl
features/aulawiki/templates/tiki-workspaces_print.tpl templates/tiki-workspaces_print.tpl
features/aulawiki/templates/tiki-workspaces_print_page.tpl templates/tiki-workspaces_print_page.tpl
features/aulawiki/templates/tiki-workspaces_resource_types.tpl templates/tiki-workspaces_resource_types.tpl
features/aulawiki/templates/tiki-workspaces_roles.tpl templates/tiki-workspaces_roles.tpl
features/aulawiki/templates/tiki-workspaces_structure_tree.tpl templates/tiki-workspaces_structure_tree.tpl
features/aulawiki/templates/aulawiki-view_gradebook.tpl templates/aulawiki-view_gradebook.tpl
features/aulawiki/templates/aulawiki-view_gradebook_xml.tpl templates/aulawiki-view_gradebook_xml.tpl
features/aulawiki/templates/tiki-workspaces_view_module.tpl templates/tiki-workspaces_view_module.tpl
features/aulawiki/templates/tiki-workspaces_admin.tpl templates/tiki-workspaces_admin.tpl
features/aulawiki/templates/tiki-workspaces_desktop.tpl templates/tiki-workspaces_desktop.tpl
features/aulawiki/templates/tiki-workspaces_types.tpl templates/tiki-workspaces_types.tpl
features/aulawiki/templates/tiki-workspaces_types_resources.tpl templates/tiki-workspaces_types_resources.tpl
features/aulawiki/templates/tiki-workspaces_types_roles.tpl templates/tiki-workspaces_types_roles.tpl
features/aulawiki/templates/tiki-workspaces_zones.tpl templates/tiki-workspaces_zones.tpl
features/aulawiki/templates/tiki-workspaces_assigned_modules.tpl templates/tiki-workspaces_assigned_modules.tpl
features/aulawiki/templates/modules/mod-workspaces_assistant.tpl templates/modules/mod-workspaces_assistant.tpl
features/aulawiki/templates/modules/mod-aulawiki_assignments.tpl templates/modules/mod-aulawiki_assignments.tpl
features/aulawiki/templates/modules/mod-workspaces_break.tpl templates/modules/mod-workspaces_break.tpl
features/aulawiki/templates/modules/mod-workspaces_calendar.tpl templates/modules/mod-workspaces_calendar.tpl
features/aulawiki/templates/modules/mod-workspaces_calendar.tpl.nocache templates/modules/mod-workspaces_calendar.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_childs.tpl templates/modules/mod-workspaces_childs.tpl
features/aulawiki/templates/modules/mod-workspaces_clipboard.tpl templates/modules/mod-workspaces_clipboard.tpl
features/aulawiki/templates/modules/mod-workspaces_clipboard.tpl.nocache templates/modules/mod-workspaces_clipboard.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_last_blog_posts.tpl templates/modules/mod-workspaces_last_blog_posts.tpl
features/aulawiki/templates/modules/mod-workspaces_last_blog_posts.tpl.nocache templates/modules/mod-workspaces_last_blog_posts.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_last_files.tpl templates/modules/mod-workspaces_last_files.tpl
features/aulawiki/templates/modules/mod-workspaces_last_image.tpl templates/modules/mod-workspaces_last_image.tpl
features/aulawiki/templates/modules/mod-workspaces_list_resources.tpl templates/modules/mod-workspaces_list_resources.tpl
features/aulawiki/templates/modules/mod-workspaces_my.tpl templates/modules/mod-workspaces_my.tpl
features/aulawiki/templates/modules/mod-workspaces_my.tpl.nocache templates/modules/mod-workspaces_my.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_resources.tpl templates/modules/mod-workspaces_resources.tpl
features/aulawiki/templates/modules/mod-workspaces_resources.tpl.nocache templates/modules/mod-workspaces_resources.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_user_groups.tpl templates/modules/mod-workspaces_user_groups.tpl
features/aulawiki/templates/modules/mod-workspaces_user_groups.tpl.nocache templates/modules/mod-workspaces_user_groups.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_owner.tpl templates/modules/mod-workspaces_owner.tpl
features/aulawiki/templates/modules/mod-workspaces_owner.tpl.nocache templates/modules/mod-workspaces_owner.tpl.nocache
features/aulawiki/templates/modules/mod-workspaces_viewpage.tpl templates/modules/mod-workspaces_viewpage.tpl
features/aulawiki/templates/modules/mod-workspaces_viewstructure.tpl templates/modules/mod-workspaces_viewstructure.tpl
features/aulawiki/templates/modules/mod-aulawiki_view_assignment.tpl templates/modules/mod-aulawiki_view_assignment.tpl
features/aulawiki/templates/modules/mod-workspaces_who_is_there.tpl templates/modules/mod-workspaces_who_is_there.tpl
features/aulawiki/templates/modules/mod-workspaces_who_is_there.tpl.nocache templates/modules/mod-workspaces_who_is_there.tpl.nocache
features/aulawiki/templates/styles/workspaces/index.php templates/styles/workspaces/index.php
features/aulawiki/templates/styles/workspaces/module.tpl templates/styles/workspaces/module.tpl
features/aulawiki/templates/styles/workspaces/tiki-show_page.tpl templates/styles/workspaces/tiki-show_page.tpl
features/aulawiki/templates/styles/workspaces/tiki-user_edumenu.tpl templates/styles/workspaces/tiki-user_edumenu.tpl
features/aulawiki/templates/styles/workspaces/tiki-user_information.tpl templates/styles/workspaces/tiki-user_information.tpl
features/aulawiki/templates/styles/workspaces/tiki-user_menu.tpl templates/styles/workspaces/tiki-user_menu.tpl
features/aulawiki/templates/styles/workspaces/tiki-user_preferences.tpl templates/styles/workspaces/tiki-user_preferences.tpl
features/aulawiki/templates/styles/workspaces/modules/index.php templates/styles/workspaces/modules/index.php
features/aulawiki/templates/styles/workspaces/modules/mod-application_menu.tpl templates/styles/workspaces/modules/mod-application_menu.tpl
features/aulawiki/modules/mod-aulawiki_assignments.php modules/mod-aulawiki_assignments.php
features/aulawiki/modules/mod-workspaces_calendar.php modules/mod-workspaces_calendar.php
features/aulawiki/modules/mod-workspaces_childs.php modules/mod-workspaces_childs.php
features/aulawiki/modules/mod-workspaces_clipboard.php modules/mod-workspaces_clipboard.php
features/aulawiki/modules/mod-workspaces_last_blog_posts.php modules/mod-workspaces_last_blog_posts.php
features/aulawiki/modules/mod-workspaces_last_files.php modules/mod-workspaces_last_files.php
features/aulawiki/modules/mod-workspaces_last_image.php modules/mod-workspaces_last_image.php
features/aulawiki/modules/mod-workspaces_list_resources.php modules/mod-workspaces_list_resources.php
features/aulawiki/modules/mod-workspaces_my.php modules/mod-workspaces_my.php
features/aulawiki/modules/mod-workspaces_resources.php modules/mod-workspaces_resources.php
features/aulawiki/modules/mod-workspaces_user_groups.php modules/mod-workspaces_user_groups.php
features/aulawiki/modules/mod-workspaces_owner.php modules/mod-workspaces_owner.php
features/aulawiki/modules/mod-workspaces_viewpage.php modules/mod-workspaces_viewpage.php
features/aulawiki/modules/mod-workspaces_viewstructure.php modules/mod-workspaces_viewstructure.php
features/aulawiki/modules/mod-aulawiki_view_assignment.php modules/mod-aulawiki_view_assignment.php
features/aulawiki/modules/mod-workspaces_who_is_there.php modules/mod-workspaces_who_is_there.php
features/aulawiki/modules/conf/modconf-workspaces_calendar.php modules/conf/modconf-workspaces_calendar.php
features/aulawiki/modules/conf/modconf-workspaces_childs.php modules/conf/modconf-workspaces_childs.php
features/aulawiki/modules/conf/modconf-workspaces_clipboard.php modules/conf/modconf-workspaces_clipboard.php
features/aulawiki/modules/conf/modconf-workspaces_last_blog_posts.php modules/conf/modconf-workspaces_last_blog_posts.php
features/aulawiki/modules/conf/modconf-workspaces_last_files.php modules/conf/modconf-workspaces_last_files.php
features/aulawiki/modules/conf/modconf-workspaces_last_image.php modules/conf/modconf-workspaces_last_image.php
features/aulawiki/modules/conf/modconf-workspaces_list_resources.php modules/conf/modconf-workspaces_list_resources.php
features/aulawiki/modules/conf/modconf-workspaces_resources.php modules/conf/modconf-workspaces_resources.php
features/aulawiki/modules/conf/modconf-workspaces_user_groups.php modules/conf/modconf-workspaces_user_groups.php
features/aulawiki/modules/conf/modconf-workspaces_owner.php modules/conf/modconf-workspaces_owner.php
features/aulawiki/modules/conf/modconf-workspaces_viewpage.php modules/conf/modconf-workspaces_viewpage.php
features/aulawiki/modules/conf/modconf-workspaces_viewstructure.php modules/conf/modconf-workspaces_viewstructure.php

Configuration:

author:
jreyes (SF: jreyesg )

licence:
GNU/LGPL

Description: 
AulaWiki offers team collaboration environments (workspaces), allowing you to manage sets of Tiki resources in an easy way.

Changelog:
0.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

sql-install:
DROP TABLE IF EXISTS `tiki_workspace_role_wstype`;
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;
DROP TABLE IF EXISTS `tiki_workspace_roles`;
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;
DROP TABLE IF EXISTS `tiki_workspaces`;
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;
DROP TABLE IF EXISTS `tiki_workspace_modules`;
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;
DROP TABLE IF EXISTS `tiki_workspace_types`;
CREATE TABLE `tiki_workspace_types` (`id` 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  (`id`)) TYPE=MyISAM; 
DROP TABLE IF EXISTS `tiki_workspace_zones`;
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;
DROP TABLE IF EXISTS `aulawiki_assignment`;
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;
DROP TABLE IF EXISTS `aulawiki_gradebook`;
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;
DROP TABLE IF EXISTS `aulawiki_period`;
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;
DROP TABLE IF EXISTS `aulawiki_period_type`;
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';
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_permissions VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments');
INSERT INTO users_permissions VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace');
INSERT INTO users_permissions VALUES ('tiki_p_admin_workspace','Can admin workspaces','admin','workspace');
INSERT INTO users_permissions VALUES ('tiki_p_create_workspace_resour','Can create new workspace resources','editors','workspace');
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_menus VALUES (100,'Workspace menu','Sample workspace menu','d');
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','');


sql-remove:
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_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-upgrade:
:0.6
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%';
DROP TABLE IF EXISTS `tiki_workspace_zones`;
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;
INSERT INTO tiki_workspace_zones (`zoneId`) SELECT DISTINCT `workspaceId` FROM `aulawiki_workspace_modules` WHERE type='workspace type';
UPDATE tiki_workspace_zones SET name='main',description='main zone',workspaceId=zoneId,type='workspace type',ord=1,uid=zoneId;
INSERT INTO tiki_workspace_zones (`zoneId`) SELECT DISTINCT `workspaceId`*1000 FROM `aulawiki_workspace_modules` WHERE type='workspace';
UPDATE tiki_workspace_zones SET name='main',description='main zone',workspaceId=zoneId/1000,type='workspace',ord=1,uid=zoneId where zoneId>1000;        
ALTER TABLE `aulawiki_workspace_modules` ADD `zoneId` int(14); 
ALTER TABLE `aulawiki_workspace_modules` ADD `style_data` varchar(150); 
ALTER TABLE `aulawiki_workspace_modules` ADD `style_title` varchar(100); 
UPDATE `aulawiki_workspace_modules` SET `zoneId`=workspaceId WHERE `type`='workspace type';
UPDATE `aulawiki_workspace_modules` SET `zoneId`=workspaceId*1000 WHERE `type`='workspace';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_assistant' WHERE `name`='aulawiki_assistant';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_calendar' WHERE `name`='aulawiki_calendar';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_childs' WHERE `name`='aulawiki_child_workspaces';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_last_blog_posts' WHERE `name`='aulawiki_last_blog_posts';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_last_files' WHERE `name`='aulawiki_last_files';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_last_image' WHERE `name`='aulawiki_last_image';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_list_resources' WHERE `name`='aulawiki_list_resources';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_resources' WHERE `name`='aulawiki_resources';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_user_groups' WHERE `name`='aulawiki_user_groups';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_viewpage' WHERE `name`='aulawiki_viewpage';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_viewstructure' WHERE `name`='aulawiki_viewstructure';
UPDATE `aulawiki_workspace_modules` SET `name`='workspaces_who_is_there' WHERE `name`='aulawiki_who_is_there';
ALTER TABLE `aulawiki_roles` ADD `permgroup` varchar(100);
ALTER TABLE `aulawiki_roles` DROP `levels`;
UPDATE `aulawiki_roles` SET permgroup=CONCAT('RolePerms-',name);   
INSERT INTO `users_groups` (`groupName`,`groupDesc`) SELECT CONCAT('RolePerms-',`name`),CONCAT(`name`,' role permissions template') FROM `aulawiki_roles`;
ALTER TABLE `aulawiki_role_wstype` ADD `wstypePermGroup` varchar(100); 
UPDATE `aulawiki_workspace_modules` SET position='1' where position='l';
UPDATE `aulawiki_workspace_modules` SET position='2' where position='r';
RENAME TABLE `aulawiki_workspace_modules` TO `tiki_workspace_modules`;
RENAME TABLE `aulawiki_role_wstype` TO `tiki_workspace_role_wstype`;
RENAME TABLE `aulawiki_roles` TO `tiki_workspace_roles`;
RENAME TABLE `aulawiki_workspace` TO `tiki_workspaces`;
RENAME TABLE `aulawiki_workspace_types` TO `tiki_workspace_types`;
INSERT INTO `tiki_workspace_roles` VALUES ('Registered', 'a671a29eef794f7423ae567f7d964d42', 'Registered', 'Registered users');
INSERT INTO `tiki_workspace_roles` VALUES ('Anonymous', '77f08d9b1ee1a29d11aabefbeca5d1e5', 'Anonymous', 'Anonymous users');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Workspaces','./tiki-workspaces.php',1020,'','tiki_p_admin_workspaces','');
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_workspaces','');
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_workspaces_types','');
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_workspaces_roles','');
INSERT INTO tiki_menus VALUES (100,'Workspace menu','Sample workspace menu','d');
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 users_permissions VALUES ('tiki_p_admin_workspaces_types','Can admin workspace types','admin','workspaces');
INSERT INTO users_permissions VALUES ('tiki_p_admin_workspaces_roles','Can admin roles','admin','workspaces');
INSERT INTO users_permissions VALUES ('tiki_p_admin_workspaces','Can admin workspaces','admin','workspaces');
INSERT INTO users_permissions VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments');
INSERT INTO users_permissions VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments');
INSERT INTO users_permissions VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace');
INSERT INTO users_permissions VALUES ('tiki_p_admin_workspace','Can admin a workspace','admin','workspace');
INSERT INTO users_permissions VALUES ('tiki_p_create_workspace_resources','Can create new workspace resources','editors','workspace');
UPDATE `tiki_modules` SET `name`='workspaces_clipboard' WHERE `name`='aulawiki_clipboard';
UPDATE `tiki_modules` SET `name`='workspaces_my' WHERE `name`='aulawiki_myworkspaces';
UPDATE `tiki_modules` SET `name`='workspaces_assistant' WHERE `name`='aulawiki_assistant';
UPDATE `tiki_user_assigned_modules` SET `name`='workspaces_clipboard' WHERE `name`='aulawiki_clipboard';
UPDATE `tiki_user_assigned_modules` SET `name`='workspaces_my' WHERE `name`='aulawiki_myworkspaces';
UPDATE `tiki_user_assigned_modules` SET `name`='workspaces_assistant' WHERE `name`='aulawiki_assistant';
UPDATE `tiki_preferences` SET `value`='workspaces.css' WHERE `value`='aulawiki.css';
:0.7
DELETE FROM `users_grouppermissions` WHERE `permName`='tiki_p_admin_workspaces_types';
DELETE FROM `users_grouppermissions` WHERE `permName`='tiki_p_admin_workspaces_roles';
UPDATE `users_grouppermissions` SET `permName`='tiki_p_admin_workspace' WHERE `permName`='tiki_p_admin_workspaces';
DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%';
DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%';
INSERT INTO `users_permissions` VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments');
INSERT INTO `users_permissions` VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments');
INSERT INTO `users_permissions` VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments');
INSERT INTO `users_permissions` VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments');
INSERT INTO `users_permissions` VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments');
INSERT INTO `users_permissions` VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace');
INSERT INTO `users_permissions` VALUES ('tiki_p_admin_workspace','Can admin workspaces','admin','workspace');
INSERT INTO `users_permissions` VALUES ('tiki_p_create_workspace_resour','Can create new workspace resources','editors','workspace');
:0.8
UPDATE `tiki_workspace_types` SET `resources`='a:0:{}' WHERE `resources`='a:1:{i:0;s:8:"wikipage";}';
:1.1
DELETE FROM `users_grouppermissions` WHERE `permName`='tiki_p_admin_workspaces';
DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1020;
DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1022;
DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1024;
DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1026;
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','');
