From: <jr...@us...> - 2006-08-10 18:23:07
|
Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv10170/db Modified Files: tiki_1.9to1.10.sql Log Message: AulaWiki renamed to Workspaces Index: tiki_1.9to1.10.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki_1.9to1.10.sql,v retrieving revision 1.94 retrieving revision 1.95 diff -u -d -r1.94 -r1.95 --- tiki_1.9to1.10.sql 3 Aug 2006 15:41:45 -0000 1.94 +++ tiki_1.9to1.10.sql 10 Aug 2006 18:23:02 -0000 1.95 @@ -584,4 +584,149 @@ INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_crypt_passwords','tikihash'); #2006-07-28 mkalbere ALTER TABLE `tiki_sent_newsletters` ADD `datatxt` longblob AFTER data; -ALTER TABLE `tiki_newsletters` ADD `allowTxt` varchar(1); \ No newline at end of file +ALTER TABLE `tiki_newsletters` ADD `allowTxt` varchar(1); + + +# -------------------------------------------------------- + + +# Table structure for workspaces tables +# +# Creation: Aug 10, 2006 - jreyesg +# Last update: Aug 10, 2006 - jreyesg +# +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, + `type` varchar(50) NOT NULL default '', + `workspaceId` int(14) 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; + +INSERT INTO `tiki_workspace_roles` VALUES ('Teacher', '2fd99c1c873d19ee003a5bde9b832607', 'RolePerms-Teacher', 'Teacher'); +INSERT INTO `tiki_workspace_roles` VALUES ('Student', '9d94a9b153bc6e7a162262b109ce3829', 'RolePerms-Student', 'Student'); +INSERT INTO `tiki_workspace_roles` VALUES ('Owner', 'cf658411eca2e230d90276c5a0235a1b', 'RolePerms-Owner', 'Portfolio owner'); +INSERT INTO `tiki_workspace_roles` VALUES ('Registered', 'a671a29eef794f7423ae567f7d964d42', 'Registered', 'Registered users'); +INSERT INTO `tiki_workspace_roles` VALUES ('Anonymous', '77f08d9b1ee1a29d11aabefbeca5d1e5', 'Anonymous', 'Anonymous users'); +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 ('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 ('tiki_p_admin_assignments','Can admin assignments','admin','assignments'); +INSERT INTO users_permissions VALUES ('tiki_p_view_assignments','Can view assignments','basic','assignments'); +INSERT INTO users_permissions VALUES ('tiki_p_edit_assignments','Can edit existing assignments','editors','assignments'); +INSERT INTO users_permissions VALUES ('tiki_p_create_assignments','Can create new assignments','editors','assignments'); +INSERT INTO users_permissions VALUES ('tiki_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'); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Workspaces','./tiki-workspaces.php',1500,'','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',1515,'','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',1510,'','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',1505,'','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_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_modules VALUES ('1','workspaces_last_blog_posts','2','3','workspace type','1','My Blog','0','0','name=%WSCODE%-MyBlog','','','','68809e75ced4d1f52bec9eb73bc32cdc'); +INSERT INTO tiki_workspace_modules VALUES ('2','workspaces_viewpage','1','1','workspace type','1','Portfolio Home','0','0','name=%WSCODE%-Home','','','','6ac0bc2518a0c836de87662defbada90'); +INSERT INTO tiki_workspace_modules VALUES ('3','workspaces_who_is_there','2','1','workspace type','2','Course users','0','0','','','','','cbbbb0122cb4aca6c83859cda85bdecd'); +INSERT INTO tiki_workspace_modules VALUES ('5','workspaces_last_blog_posts','1','3','workspace type','2','Course History','0','0','name=%WSCODE%-History&maxPosts=3&showBar=n','','','','da1d338b0fb3d87256341b4154ba96c5'); +INSERT INTO tiki_workspace_modules VALUES ('6','workspaces_viewpage','2','1','workspace type','3','Home page','0','0','name=%WSCODE%-Home','','','','1f1b76a1f4dff160d31ae36a11170ede'); +INSERT INTO tiki_workspace_modules VALUES ('7','workspaces_last_blog_posts','2','5','workspace type','3','History','0','0','name=%WSCODE%-History','','','','ae744c4a52b38e5386c99ddc43edc8be'); +INSERT INTO tiki_workspace_modules VALUES ('9','workspaces_last_files','3','11','workspace type','2','Course files','0','0','name=%WSCODE%-Files&maxFiles=3&showBar=y&','','','','ce32d51600a7f6b3f999be9ec467c5d7'); +INSERT INTO tiki_workspace_modules VALUES ('10','workspaces_break','1','5','workspace type','2','','0','0','','','','','781330d16d490e7a88237e2aa1983ce1'); +INSERT INTO tiki_workspace_modules VALUES ('19','workspaces_break','2','2','workspace type','1','','0','0','','','','','b0678bf202e5b4417bb6fdcae969626e'); +INSERT INTO tiki_workspace_modules VALUES ('17','workspaces_last_image','3','15','workspace type','2','Images','0','0','name=%WSCODE%-Images&maxImages=3&showBar=y&','','','','f73d1e5f2a56721284d38eba1da56de0'); +INSERT INTO tiki_workspace_modules VALUES ('15','workspaces_calendar','2','6','workspace type','2','Course calendar','0','0','','','','','7126d03da3815b92f80feef1e8598ddb'); +INSERT INTO tiki_workspace_modules VALUES ('14','workspaces_childs','2','5','workspace type','2','Child workspaces','0','0','','','','','e4604c1cea8879a11425ebcae8aab4d1'); +INSERT INTO tiki_workspace_modules VALUES ('16','workspaces_viewpage','1','10','workspace type','2','View page','0','0','name=%WSCODE%-Home&showBar=y','','','','a91e337ce2b81ce208523635e1471faa'); +INSERT INTO tiki_workspace_modules VALUES ('22','workspaces_owner','1','1','workspace type','3','Workspace owner','0','0','showName=y&showWorkspaces=y','','','','017e28f378066a9c8c6d2a66f435f3cd'); +INSERT INTO tiki_workspace_modules VALUES ('20','workspaces_owner','2','1','workspace type','1','Workspace owner','0','0','showName=y&showWorkspaces=y','','','','b162f68536c92a270150ae475bd8308f'); +INSERT INTO tiki_workspace_modules VALUES ('28','workspaces_viewpage','1','1','workspace type','5','View page','0','0','name=%WSCODE%-Home&showBar=y','','','','40ca0c9474d974dba3e73ff3fc9db3a7'); +INSERT INTO tiki_workspace_modules VALUES ('29','workspaces_last_blog_posts','1','2','workspace type','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',''); \ No newline at end of file |