[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[21012] branches/experimental/kaltura_integration_two/ db

[<nag...@us...>]

Revision: 21012
          http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=21012&view=rev
Author:   nagendra016
Date:     2009-08-20 20:49:57 +0000 (Thu, 20 Aug 2009)

Log Message:
-----------
menus , menu options and perms into db

Modified Paths:
--------------
    branches/experimental/kaltura_integration_two/db/tiki-4.0-mysql.sql
    branches/experimental/kaltura_integration_two/db/tiki-4.0-mysqli.sql
    branches/experimental/kaltura_integration_two/db/tiki-4.0-pgsql.sql
    branches/experimental/kaltura_integration_two/db/tiki-4.0-sqlite.sql
    branches/experimental/kaltura_integration_two/db/tiki.sql

Modified: branches/experimental/kaltura_integration_two/db/tiki-4.0-mysql.sql
===================================================================
--- branches/experimental/kaltura_integration_two/db/tiki-4.0-mysql.sql	2009-08-20 20:17:00 UTC (rev 21011)
+++ branches/experimental/kaltura_integration_two/db/tiki-4.0-mysql.sql	2009-08-20 20:49:57 UTC (rev 21012)
@@ -1537,6 +1537,12 @@
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_faq_comments','tiki_p_admin','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contribution','tiki-admin_contribution.php',1265,'feature_contribution','tiki_p_admin_contribution','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 1275, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 1276, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 1277, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', 'Registered', 0);
 
 
 
@@ -2972,8 +2978,15 @@
 
 INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_trigger_transition', 'Can trigger the transition between two states', 'admin', 'transition', NULL, 'feature_group_transition,feature_category_transition');
 
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_admin_kaltura', 'Can admin kaltura feature', 'admin', 'kaltura', 'y', 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_upload_videos', 'Can upload video on kaltura server', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_edit_videos', 'Can edit information of kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_remix_videos', 'Can create kaltura remix video', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_delete_videos', 'Can delete kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_download_videos', 'Can download kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_list_videos', 'Can list kaltura entries', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_view_videos', 'Can view kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
 
-
 DROP TABLE IF EXISTS `users_usergroups`;
 CREATE TABLE `users_usergroups` (
   `userId` int(8) NOT NULL default '0',

Modified: branches/experimental/kaltura_integration_two/db/tiki-4.0-mysqli.sql
===================================================================
--- branches/experimental/kaltura_integration_two/db/tiki-4.0-mysqli.sql	2009-08-20 20:17:00 UTC (rev 21011)
+++ branches/experimental/kaltura_integration_two/db/tiki-4.0-mysqli.sql	2009-08-20 20:49:57 UTC (rev 21012)
@@ -1538,10 +1538,16 @@
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_faq_comments','tiki_p_admin','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contribution','tiki-admin_contribution.php',1265,'feature_contribution','tiki_p_admin_contribution','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
- 
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 1275, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 1276, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 1277, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', 'Registered', 0);
 
 
 
+
 DROP TABLE IF EXISTS `tiki_menus`;
 CREATE TABLE `tiki_menus` (
   `menuId` int(8) NOT NULL auto_increment,
@@ -2974,8 +2980,17 @@
 
 INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_trigger_transition', 'Can trigger the transition between two states', 'admin', 'transition', NULL, 'feature_group_transition,feature_category_transition');
 
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_admin_kaltura', 'Can admin kaltura feature', 'admin', 'kaltura', 'y', 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_upload_videos', 'Can upload video on kaltura server', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_edit_videos', 'Can edit information of kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_remix_videos', 'Can create kaltura remix video', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_delete_videos', 'Can delete kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_download_videos', 'Can download kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_list_videos', 'Can list kaltura entries', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_view_videos', 'Can view kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
 
 
+
 DROP TABLE IF EXISTS `users_usergroups`;
 CREATE TABLE `users_usergroups` (
   `userId` int(8) NOT NULL default '0',

Modified: branches/experimental/kaltura_integration_two/db/tiki-4.0-pgsql.sql
===================================================================
--- branches/experimental/kaltura_integration_two/db/tiki-4.0-pgsql.sql	2009-08-20 20:17:00 UTC (rev 21011)
+++ branches/experimental/kaltura_integration_two/db/tiki-4.0-pgsql.sql	2009-08-20 20:49:57 UTC (rev 21012)
@@ -1907,9 +1907,17 @@
 
 INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
 
+INSERT INTO "tiki_menu_options" ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 1275, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
 
+INSERT INTO "tiki_menu_options" ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 1276, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
 
+INSERT INTO "tiki_menu_options" ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 1277, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', 'Registered', 0);
 
+
+
 DROP TABLE IF EXISTS "tiki_menus";
 
 CREATE TABLE "tiki_menus" (
@@ -3771,9 +3779,16 @@
 
 INSERT INTO "users_permissions" ("permName","permDesc","level","type","admin","feature_check") VALUES ('tiki_p_trigger_transition', 'Can trigger the transition between two states', 'admin', 'transition', NULL, 'feature_group_transition,feature_category_transition');
 
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_admin_kaltura', 'Can admin kaltura feature', 'admin', 'kaltura', 'y', 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_upload_videos', 'Can upload video on kaltura server', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_edit_videos', 'Can edit information of kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_remix_videos', 'Can create kaltura remix video', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_delete_videos', 'Can delete kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_download_videos', 'Can download kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_list_videos', 'Can list kaltura entries', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_view_videos', 'Can view kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
 
 
-
 DROP TABLE IF EXISTS "users_usergroups";
 
 CREATE TABLE "users_usergroups" (

Modified: branches/experimental/kaltura_integration_two/db/tiki-4.0-sqlite.sql
===================================================================
--- branches/experimental/kaltura_integration_two/db/tiki-4.0-sqlite.sql	2009-08-20 20:17:00 UTC (rev 21011)
+++ branches/experimental/kaltura_integration_two/db/tiki-4.0-sqlite.sql	2009-08-20 20:49:57 UTC (rev 21012)
@@ -1917,9 +1917,17 @@
 
 INSERT INTO "," ("menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
 
+INSERT INTO "," ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 1275, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
 
+INSERT INTO "," ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 1276, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
 
+INSERT INTO "," ("menuId", "type", "name", "url", "position", "section", "perm", "groupname", "userlevel") VALUES
+(42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 1277, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', 'Registered', 0);
 
+
+
 DROP TABLE IF EXISTS 'tiki_menus';
 
 CREATE TABLE tiki_menus (
@@ -3783,6 +3791,14 @@
 
 INSERT INTO "," ("permName","permDesc","level","type","admin","feature_check") VALUES ('tiki_p_trigger_transition', 'Can trigger the transition between two states', 'admin', 'transition', NULL, 'feature_group_transition,feature_category_transition');
 
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_admin_kaltura', 'Can admin kaltura feature', 'admin', 'kaltura', 'y', 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_upload_videos', 'Can upload video on kaltura server', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_edit_videos', 'Can edit information of kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_remix_videos', 'Can create kaltura remix video', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_delete_videos', 'Can delete kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_download_videos', 'Can download kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_list_videos', 'Can list kaltura entries', 'registered', 'kaltura', NULL, 'feature_kaltura');
+INSERT INTO "," ("permName", "permDesc", "level", "type", "admin", "feature_check") VALUES('tiki_p_view_videos', 'Can view kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura');
 
 
 

Modified: branches/experimental/kaltura_integration_two/db/tiki.sql
===================================================================
--- branches/experimental/kaltura_integration_two/db/tiki.sql	2009-08-20 20:17:00 UTC (rev 21011)
+++ branches/experimental/kaltura_integration_two/db/tiki.sql	2009-08-20 20:49:57 UTC (rev 21012)
@@ -1533,9 +1533,19 @@
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_faq_comments','tiki_p_admin','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contribution','tiki-admin_contribution.php',1265,'feature_contribution','tiki_p_admin_contribution','',0);
 INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces','tiki-admin.php?page=workspaces',1270,'feature_workspaces','tiki_p_admin','',0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 1275, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 1276, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', 'Registered', 0);
+INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES
+(42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 1277, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', 'Registered', 0);
 
 
 
+
 DROP TABLE IF EXISTS `tiki_menus`;
 CREATE TABLE `tiki_menus` (
   `menuId` int(8) NOT NULL auto_increment,
@@ -3565,14 +3575,4 @@
 	KEY `transition_lookup` (`type`, `from`)
 ) ENGINE=MyISAM;
 
-DROP TABLE IF EXISTS `tiki_videos`;
-CREATE TABLE IF NOT EXISTS `tiki_videos` (
-  `videoId` int(14) NOT NULL auto_increment,
-  `galleryId` int(14) NOT NULL default '0',
-  `entryId` varchar(20) NOT NULL default '',
-  `creator` varchar(200) default '',
-  `last_user` varchar(200) default NULL,
-  PRIMARY KEY  (`videoId`),
-  KEY `galleryId` (`galleryId`)
-) ENGINE=MyISAM;
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.