IP : 18.191.41.113Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
impress/
../
seo/
../
qcart/
../
uikit/
../
egroup/
egroup.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `egw_admin_remote` --
CREATE TABLE `egw_admin_remote` ( `remote_id` int(11) NOT NULL AUTO_INCREMENT, `remote_name` varchar(64) NOT NULL, `remote_hash` varchar(32) CHARACTER SET ascii NOT NULL, `remote_url` varchar(128) CHARACTER SET ascii NOT NULL, `remote_domain` varchar(64) CHARACTER SET ascii NOT NULL, PRIMARY KEY (`remote_id`), UNIQUE KEY `egw_admin_remote_name` (`remote_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `egw_applications` --
CREATE TABLE `egw_applications` ( `app_id` int(11) NOT NULL AUTO_INCREMENT, `app_name` varchar(16) CHARACTER SET ascii NOT NULL, `app_enabled` int(11) NOT NULL, `app_order` int(11) NOT NULL, `app_tables` varchar(8192) CHARACTER SET ascii NOT NULL, `app_version` varchar(20) CHARACTER SET ascii NOT NULL DEFAULT '0.0', `app_icon` varchar(128) CHARACTER SET ascii DEFAULT NULL, `app_icon_app` varchar(16) CHARACTER SET ascii DEFAULT NULL, `app_index` varchar(128) CHARACTER SET ascii DEFAULT NULL, PRIMARY KEY (`app_id`), UNIQUE KEY `egw_applications_name` (`app_name`), KEY `egw_applications_enabled_order` (`app_enabled`,`app_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
-- -- Dumping data for table `egw_applications` --
CREATE TABLE `egw_async` ( `async_id` varchar(64) CHARACTER SET ascii NOT NULL, `async_next` int(11) NOT NULL, `async_times` varchar(255) CHARACTER SET ascii NOT NULL, `async_method` varchar(80) CHARACTER SET ascii NOT NULL, `async_data` varchar(8192) NOT NULL, `async_account_id` int(11) NOT NULL DEFAULT '0', `async_auto_id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`async_auto_id`), UNIQUE KEY `egw_async_id` (`async_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
CREATE TABLE `egw_config` ( `config_app` varchar(16) CHARACTER SET ascii NOT NULL, `config_name` varchar(32) CHARACTER SET ascii NOT NULL, `config_value` text, PRIMARY KEY (`config_app`,`config_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `egw_links` ( `link_id` int(11) NOT NULL AUTO_INCREMENT, `link_app1` varchar(16) CHARACTER SET ascii NOT NULL, `link_id1` varchar(64) CHARACTER SET ascii NOT NULL, `link_app2` varchar(16) CHARACTER SET ascii NOT NULL, `link_id2` varchar(64) CHARACTER SET ascii NOT NULL, `link_remark` varchar(100) DEFAULT NULL, `link_lastmod` bigint(20) NOT NULL, `link_owner` int(11) NOT NULL, `deleted` datetime DEFAULT NULL, PRIMARY KEY (`link_id`), KEY `egw_links_deleted` (`deleted`), KEY `egw_links_app1_id1_lastmod` (`link_app1`,`link_id1`,`link_lastmod`), KEY `egw_links_app2_id2_lastmod` (`link_app2`,`link_id2`,`link_lastmod`), KEY `egw_links_app1_app2_id1_id2` (`link_app1`,`link_app2`,`link_id1`,`link_id2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `egw_openid_auth_codes` --
CREATE TABLE `egw_openid_auth_codes` ( `auth_code_id` int(11) NOT NULL AUTO_INCREMENT, `auth_code_identifier` varchar(128) CHARACTER SET ascii NOT NULL, `account_id` int(11) NOT NULL, `client_id` int(11) NOT NULL, `auth_code_expiration` datetime DEFAULT NULL, `auth_code_redirect_uri` varchar(255) CHARACTER SET ascii NOT NULL, `auth_code_revoked` tinyint(4) NOT NULL DEFAULT '0', `auth_code_created` datetime NOT NULL, `auth_code_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `auth_code_ip` varchar(48) CHARACTER SET ascii DEFAULT NULL, `auth_code_user_agent` varchar(255) CHARACTER SET ascii DEFAULT NULL, `auth_code_nonce` varchar(255) CHARACTER SET ascii DEFAULT NULL, PRIMARY KEY (`auth_code_id`), KEY `egw_openid_auth_codes_account_id` (`account_id`), KEY `egw_openid_auth_codes_client_id` (`client_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `egw_smallpart_comments` --
CREATE TABLE `egw_smallpart_comments` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `video_id` int(11) NOT NULL, `comment_starttime` int(11) DEFAULT '0', `comment_stoptime` int(11) DEFAULT '0', `comment_color` varchar(6) CHARACTER SET ascii DEFAULT NULL, `comment_deleted` tinyint(4) NOT NULL DEFAULT '0', `comment_added` varchar(16384) NOT NULL, `comment_history` text, `comment_related_to` int(11) DEFAULT NULL, `comment_info_alert` varchar(2048) DEFAULT NULL, `comment_marked` text, `comment_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `comment_created` datetime DEFAULT NULL, `comment_cat` varchar(2048) DEFAULT NULL, PRIMARY KEY (`comment_id`), KEY `egw_smallpart_comments_course_id` (`course_id`), KEY `egw_smallpart_comments_video_id` (`video_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
-- -- Dumping data for table `egw_smallpart_comments` --
INSERT INTO `egw_smallpart_comments` VALUES (1, 1, 24, 1, 13, 13, 'ffffff', 0, '["Transparenz des Overlays kann gesteuert werden und muss je nach Zielsetzung höher oder niedriger sein."]', NULL, NULL, '', '[{"x":11.25,"y":68.89,"c":"ffffff"},{"x":13.75,"y":68.89,"c":"ffffff"},{"x":16.25,"y":68.89,"c":"ffffff"},{"x":10,"y":71.11,"c":"ffffff"},{"x":16.25,"y":71.11,"c":"ffffff"},{"x":16.25,"y":75.56,"c":"ffffff"},{"x":15,"y":80,"c":"ffffff"},{"x":13.75,"y":82.22,"c":"ffffff"}]', '[[regtime]]', NULL, NULL), (2, 1, 24, 1, 20, 20, 'ff0000', 0, '["Verlust des Triggers bei zu schnellen Bewegungen. Du solltest hier langsamer in der Demonstration sein. Man sieht aber auch wie schnell sich das System wieder \\"einklinkt\\"","Christoph[24]","Verlust des Triggers lässt sich unabhängig von der Bewegungsgeschwindigkeit bei zu starkem Kippen nicht vermeiden, da das Bild nicht mehr erkannt werden kann, wenn es optisch nur noch ein Strich ist."]', '["","Christoph[24]","Verlust des Triggers bei zu schnellen Bewegungen. Du solltest hier langsamer in der Demonstartion sein. Man sieht aber auch wie schnell sich das System wieder \\"einklinkt\\""]', NULL, '', NULL, '[[regtime]]', NULL, NULL), (3, 1, 24, 1, 32, 32, 'ffffff', 0, '["Hier sucht die Kamera, man kann es am pulsierenden Symbol erkennen.","Test[71]","Ein \\"n\\" zu viel."]', '["Christoph[24]","Hier sucht die Kammera, mann kann es am pulsierenden Symbol erkennen.","Christoph[24]","Hier sucht die Kammera, man kann es am pulsierenden Symbol erkennen."]', NULL, '', '[{"x":45,"y":33.33,"c":"ff0000"},{"x":52.5,"y":33.33,"c":"ff0000"},{"x":58.75,"y":42.22,"c":"ff0000"},{"x":40,"y":48.89,"c":"ff0000"},{"x":58.75,"y":57.78,"c":"ff0000"},{"x":43.75,"y":62.22,"c":"ff0000"},{"x":50,"y":66.67,"c":"ff0000"}]', '[[regtime]]', NULL, NULL), (4, 1, 24, 1, 50, 50, '00ff00', 0, '["Transparenz kann geregelt werden in der App."]', NULL, NULL, '', NULL, '[[regtime]]', NULL, NULL), (5, 1, 24, 1, 61, 61, '00ff00', 0, '["Die Triggererkennung kann Seiten unterscheiden."]', NULL, NULL, '', NULL, '[[regtime]]', NULL, NULL), (6, 1, 24, 1, 73, 73, '00ff00', 0, '["Durch den Wechsel werden kleine Veränderungen gut sichtbar,"]', NULL, NULL, '', '[{"x":41.25,"y":66.67,"c":"ff0000"},{"x":42.5,"y":66.67,"c":"ff0000"},{"x":43.75,"y":66.67,"c":"ff0000"},{"x":40,"y":68.89,"c":"ff0000"},{"x":41.25,"y":68.89,"c":"ff0000"},{"x":45,"y":68.89,"c":"ff0000"},{"x":40,"y":71.11,"c":"ff0000"},{"x":45,"y":71.11,"c":"ff0000"},{"x":40,"y":73.33,"c":"ff0000"},{"x":45,"y":73.33,"c":"ff0000"},{"x":41.25,"y":75.56,"c":"ff0000"},{"x":43.75,"y":75.56,"c":"ff0000"},{"x":42.5,"y":77.78,"c":"ff0000"}]', '[[regtime]]', NULL, NULL), (7, 1, 24, 1, 84, 84, 'ffffff', 0, '["Verlust von grauer Substanz."]', NULL, NULL, '', '[{"x":53.75,"y":35.56,"c":"ff0000"},{"x":63.75,"y":42.22,"c":"ff0000"},{"x":31.25,"y":46.67,"c":"ff0000"},{"x":67.5,"y":51.11,"c":"ff0000"},{"x":31.25,"y":77.78,"c":"ff0000"},{"x":36.25,"y":82.22,"c":"ff0000"}]', '[[regtime]]', NULL, NULL), (8, 1, 24, 1, 94, 94, 'ff0000', 0, '["Ab hierf könnte man kürzen!",null,"Da ist ein \\"f\\" zu viel ..."]', NULL, NULL, '', NULL, '[[regtime]]', NULL, NULL), (9, 1, 24, 1, 8, 8, 'ffffff', 0, '["Warum nimmst Du das in die Hand?","Christoph[24]","Nun ja, ich möcht die dynamichen Fähigkeiten zeigen.","Christoph[24]","ein \\"s\\" zu wenig"]', '["Warum nimmstg Du das indie HAnd?","Warum nimmst Du das in die HAnd?"]', NULL, '', NULL, '[[regtime]]', NULL, NULL), (10, 1, 24, 1, 10, 10, 'ffffff', 0, '[""]', NULL, NULL, '', '[{"x":40,"y":48.89,"c":"ff0000"},{"x":42.5,"y":48.89,"c":"ff0000"},{"x":38.75,"y":51.11,"c":"ff0000"},{"x":38.75,"y":55.56,"c":"ff0000"},{"x":45,"y":55.56,"c":"ff0000"},{"x":41.25,"y":57.78,"c":"ff0000"},{"x":45,"y":57.78,"c":"ff0000"}]', '[[regtime]]', NULL, NULL), (11, 1, 71, 1, 42, 42, 'ff0000', 0, '["Testuser neuer Kommentar\\nDein Kommentar enthält keine Frage, somit ist er beantwortet, ich setze ihn auf grün\\nMir fehlt aber, desahlb setze ich noch mal auf Rot!","Christoph[24]","Beim Retweet ist die Farbe nicht änderbar, ggf. geht das für Dozierende ... ist aber eine größere Änderung."]', '["Test[71]","Testuser neuer kommentar","Christoph[24]","Testuser neuer Kommentar","Christoph[24]","Testuser neuer Kommentar\\nDein Kommentar enthält keine Frage, somit ist er beantwortet, ich setze ihn auf grün"]', NULL, '', NULL, '[[regtime]]', NULL, NULL), (12, 1, 5, 1, 14, 14, 'ffffff', 0, '["Ralf''s Kommentar mit Markierung ;)"]', '["Ralf''s Kommentar mit Markierung","Ralf''s Kommentar mit Markierung ;)","Ralf''s Kommentar mit Markierung"]', NULL, '', '[{"x":63.75,"y":75.56,"c":"ffffff"},{"x":65,"y":75.56,"c":"ffffff"},{"x":66.25,"y":75.56,"c":"ffffff"},{"x":70,"y":75.56,"c":"ffffff"},{"x":73.75,"y":75.56,"c":"ffffff"},{"x":78.75,"y":75.56,"c":"ffffff"},{"x":80,"y":75.56,"c":"ffffff"},{"x":81.25,"y":75.56,"c":"ffffff"},{"x":63.75,"y":77.78,"c":"ffffff"},{"x":66.25,"y":77.78,"c":"ffffff"},{"x":68.75,"y":77.78,"c":"ffffff"},{"x":71.25,"y":77.78,"c":"ffffff"},{"x":73.75,"y":77.78,"c":"ffffff"},{"x":78.75,"y":77.78,"c":"ffffff"},{"x":63.75,"y":80,"c":"ffffff"},{"x":65,"y":80,"c":"ffffff"},{"x":66.25,"y":80,"c":"ffffff"},{"x":68.75,"y":80,"c":"ffffff"},{"x":71.25,"y":80,"c":"ffffff"},{"x":73.75,"y":80,"c":"ffffff"},{"x":78.75,"y":80,"c":"ffffff"},{"x":63.75,"y":82.22,"c":"ffffff"},{"x":65,"y":82.22,"c":"ffffff"},{"x":68.75,"y":82.22,"c":"ffffff"},{"x":70,"y":82.22,"c":"ffffff"},{"x":71.25,"y":82.22,"c":"ffffff"},{"x":73.75,"y":82.22,"c":"ffffff"},{"x":78.75,"y":82.22,"c":"ffffff"},{"x":80,"y":82.22,"c":"ffffff"},{"x":63.75,"y":84.44,"c":"ffffff"},{"x":66.25,"y":84.44,"c":"ffffff"},{"x":68.75,"y":84.44,"c":"ffffff"},{"x":71.25,"y":84.44,"c":"ffffff"},{"x":73.75,"y":84.44,"c":"ffffff"},{"x":78.75,"y":84.44,"c":"ffffff"},{"x":63.75,"y":86.67,"c":"ffffff"},{"x":66.25,"y":86.67,"c":"ffffff"},{"x":68.75,"y":86.67,"c":"ffffff"},{"x":71.25,"y":86.67,"c":"ffffff"},{"x":73.75,"y":86.67,"c":"ffffff"},{"x":75,"y":86.67,"c":"ffffff"},{"x":76.25,"y":86.67,"c":"ffffff"},{"x":78.75,"y":86.67,"c":"ffffff"}]', '[[regtime]]', NULL, NULL);
-- -- Table structure for table `egw_smallpart_videos` --
CREATE TABLE `egw_smallpart_videos` ( `video_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `video_name` varchar(255) NOT NULL, `video_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `video_question` varchar(4096) DEFAULT NULL, `video_hash` varchar(64) CHARACTER SET ascii DEFAULT NULL, `video_url` varchar(255) CHARACTER SET ascii DEFAULT NULL, `video_type` varchar(8) CHARACTER SET ascii NOT NULL DEFAULT 'mp4', `video_options` tinyint(4) DEFAULT '0', `video_published` tinyint(4) NOT NULL DEFAULT '1', `video_published_start` datetime DEFAULT NULL, `video_published_end` datetime DEFAULT NULL, `video_test_duration` smallint(6) DEFAULT NULL, `video_test_options` tinyint(4) NOT NULL DEFAULT '0', `video_test_display` tinyint(4) NOT NULL DEFAULT '0', `video_limit_access` varchar(1024) CHARACTER SET ascii DEFAULT NULL, PRIMARY KEY (`video_id`), KEY `egw_smallpart_videos_course_id` (`course_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `egw_smallpart_videos` --
INSERT INTO `egw_smallpart_videos` VALUES (1, 1, 'Brain Slices.mp4', '[[regtime]]', 'Hier kann eine Aufgabe für die User angelegt werden. Z.B. Rückfragen zum Stoff ...', NULL, '[[relativeurl]]/smallpart/setup/brain-slices.mp4', 'mp4', 0, 1, NULL, NULL, NULL, 0, 0, NULL);
-- -- Table structure for table `egw_zpush_settings` --
CREATE TABLE `egw_zpush_settings` ( `key_name` varchar(50) CHARACTER SET ascii NOT NULL, `key_value` varchar(50) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`key_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -- Table structure for table `egw_zpush_users` --
CREATE TABLE `egw_zpush_users` ( `username` varchar(50) NOT NULL, `device_id` varchar(50) CHARACTER SET ascii NOT NULL, UNIQUE KEY `egw_zpush_users_username_device_id` (`username`,`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;