-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Hoszt: localhost:3306
-- Létrehozás ideje: 2016. Jún 15. 18:16
-- Szerver verzió: 5.1.73-cll
-- PHP verzió: 5.4.31

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 */;

--
-- Adatbázis: `leopoly_new`
--

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `schools`
--

CREATE TABLE IF NOT EXISTS `schools` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`contact_email` varchar(255) NOT NULL,
`contact_name` varchar(255) NOT NULL,
`cover_image` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`activated_at` datetime DEFAULT NULL,
`valid_until` datetime DEFAULT NULL,
`created_by` bigint(20) NOT NULL,
`user_limit` int(10) NOT NULL DEFAULT '20',
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- A tábla adatainak kiíratása `schools`
--

INSERT INTO `schools` (`id`, `name`, `city`, `slug`, `contact_email`, `contact_name`, `cover_image`, `created_at`, `is_active`, `activated_at`, `valid_until`, `created_by`, `user_limit`) VALUES
(39, 'Progressive Arts Alliance', 'Cleveland', 'cleveland-progressive-arts-alliance', 'Ben@paalive.org', '', NULL, '2016-01-11 11:36:33', 1, '2016-01-11 11:36:49', '2016-07-09 11:36:49', 13, 20),
(33, 'Eötvös József Gimnázium', 'Tata', 'tata-eotvos-jozsef-gimnazium', '', '', '33701f9cd4.jpg', '2015-09-02 13:49:09', 1, '2015-09-02 13:49:53', '2016-02-29 13:49:53', 13, 20),
(37, 'CTRL-P', 'Taipei', 'taipei-ctrl-p', 'leo.chen@ctrlp.tw', 'Leo Chen', NULL, '2015-12-04 15:18:37', 1, '2015-12-04 15:18:47', '2016-06-01 15:18:47', 13, 20),
(35, 'Hogwarts', 'UK', 'uk-hogwarts', 'danielandrassy@gmail.com', 'daniel', '35de449b05..png', '2015-11-13 09:30:01', 1, '2015-11-13 09:30:26', '2016-05-11 09:30:26', 13, 20),
(36, 'Toljuk school', '', 'toljuk-school', '', '', NULL, '2015-11-13 12:28:21', 1, '2015-11-13 12:28:46', '2016-05-11 12:28:46', 19413, 20),
(12, 'St. Paul Academy and Summit School', 'Minnesota', 'minnesota-st-paul-academy-and-summit-school', 'tbrass@spa.edu', 'Tami Brass', 'school_42a20867.jpg', '2014-11-10 10:07:45', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5830, 20),
(41, 'Hickman Elementary', 'San Diego', 'san-diego-hickman-elementary', 'debert@sand.net', 'Dave Ebert', NULL, '2016-04-12 12:35:49', 1, '2016-04-12 12:36:02', '2016-10-09 12:36:02', 13, 20),
(11, 'Harrow College', 'Harrow', 'harrow-harrow-college', 'jwischhusen@harrow.ac.uk', 'jwischhusen', 'school_57041af4.jpg', '2014-10-10 15:51:47', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 16467, 20),
(40, 'Westview Hills Middle School', 'Illinois', 'illinois-westview-hills-middle-school', '', 'jwolfgolbach@maercker.org', NULL, '2016-01-13 14:00:39', 1, '2016-01-13 14:01:03', '2016-07-11 14:01:03', 13, 20),
(16, 'Savanna Oaks Middle School', 'Fitchburg', 'fitchburg-savanna-oaks-middle-school', 'devereaf@verona.k12.wi.us', 'Frank Devereaux', '166b01313d.jpg', '2014-12-01 13:54:47', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(17, 'Science and Arts Academy', 'Des Plaines', 'des-plaines-science-and-arts-academy', 'jrising@scienceandartsacademy.org', 'Jennifer Rising', NULL, '2014-12-17 14:45:00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 17191, 20),
(18, 'Glen Crest Middle School', 'Glen Ellyn', 'glen-ellyn-glen-crest-middle-school', 'rstachon@ccsd89.org', 'Rich Stachon', '1866b97d60.jpg', '2015-01-09 10:55:08', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(19, 'MKMCF MA CHAN DUEN HEY MEMORIAL COLLEGE', 'Hong Kong', 'hong-kong-mkmcf-ma-chan-duen-hey-memorial-college', 'wkl@mcdhmc.edu.hk', 'Mr Wong Ka Lun', '196ef1a8aa.jpg', '2015-01-09 11:26:31', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(20, 'Springfield School', 'Portsmouth', 'portsmouth-springfield-school', 'adam.ricketts@springfield.uk.net', 'Adam Ricketts', '20660365dc.jpg', '2015-01-09 12:15:31', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(21, 'West-MEC (Western Maricopa Education Center)', 'Glendale', 'glendale-west-mec-western-maricopa-education-center', 'chris.cook@west-mec.org', 'Chris Cook', '219bab3a6f.jpg', '2015-01-09 12:29:39', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(22, 'Estes Elementary', 'Owensboro', 'owensboro-estes-elementary', 'ryan.williams@owensboro.kyschools.us', 'Ryan Williams', '22e5df8fc9.jpg', '2015-01-14 15:02:57', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(23, 'Whitby School', 'Greenwich', 'greenwich-whitby-school', 'perry@whitbyschool.org ', 'Leslie G. Perry', '233b161ebf.jpg', '2015-01-14 15:20:45', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(24, 'Colgate University', 'Hamilton', 'hamilton-colgate-university', 'kplynch@colgate.edu', 'Kevin Lynch', '244083f989.jpg', '2015-01-14 15:28:58', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(25, 'Good Counsel Academy', 'White Plains', 'white-plains-good-counsel-academy', 'kplynch@colgate.edu', 'Lara Lee', '25cb6fd0af.jpg', '2015-01-14 15:44:05', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(26, 'Lin-Wood High School', 'us', 'lin-wood-high-school', 'dwebster@lin-wood.org', 'David Webster', '26e2fd383b.jpg', '2015-01-30 10:04:14', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(38, '3DHUBS', '', '3dhubs-training-ground', '', '', '38351609aa..jpg', '2015-12-16 10:18:36', 1, '2015-12-16 10:19:50', '2016-06-13 10:19:50', 13, 20),
(28, 'The Fessenden School', 'West Newton', 'west-newton-the-fessenden-school', 'kfogarty@fessenden.org', ' Kimberly Fogarty', '283ad65b55.jpg', '2015-02-25 09:34:36', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20),
(29, 'Briarwood Elementary School', 'Renton, W', 'renton-w-briarwood-elementary-school', 'jonathanferrell@smsd.org', 'Jonathan Ferrell', '29b9b431ab.jpg', '2015-03-11 09:41:22', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 20);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_groups`
--

CREATE TABLE IF NOT EXISTS `school_groups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`school_id` bigint(20) NOT NULL,
`cover_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`description` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;

--
-- A tábla adatainak kiíratása `school_groups`
--

INSERT INTO `school_groups` (`id`, `name`, `school_id`, `cover_image`, `description`) VALUES
(1, 'Sales', 1, NULL, ''),
(2, 'IT', 1, 'group_2bb7b268e.jpg', ''),
(3, 'Other', 1, 'group_38babcc08.jpg', ''),
(4, 'Gryffindor', 8, 'group_4739102bc.jpg', ''),
(5, 'Hufflepuff', 8, 'group_5c526876a.jpg', ''),
(6, 'Sales', 9, NULL, ''),
(7, 'IT ', 9, NULL, ''),
(9, 'Teszt', 8, 'group_98cd4ed28.jpg', ''),
(10, 'ize', 9, NULL, ''),
(11, 'ssssss', 6, 'group_11af2a67f3.jpg', ''),
(12, 'Osztály 1.', 13, 'group_12b6f341cd.jpg', ''),
(14, 'SPA - Class 1.', 12, 'group_1449a597fc.jpg', ''),
(15, 'Harrow Class 1.', 11, 'group_159b363148.jpg', ''),
(16, 'Informatika szakkör', 13, NULL, ''),
(17, 'Osztály 1. STG', 15, 'group_173b71da8b.jpg', ''),
(18, 'SOMS - Group 1', 16, 'group_18d431d65f.jpg', ''),
(19, 'Glen Crest - Class 1.', 18, 'group_19015d27df.jpg', ''),
(20, 'Class 1.', 19, 'group_20c4fb044c.jpg', ''),
(21, 'Class 1. - Springfield', 20, 'group_214e759162.jpg', ''),
(23, 'Class 1 - MEC', 21, 'group_2320264f98.jpg', ''),
(24, 'Estes Class', 22, 'group_241cfe3250.jpg', ''),
(26, 'Whitby 5th grade', 23, 'group_265aaa971d.jpg', ''),
(29, 'Clogate Class', 24, 'group_2966894c05.jpg', ''),
(28, 'Whitby 6th grade', 23, 'group_287eeef3cb.jpg', ''),
(30, 'Good Counsel Class', 25, 'group_30ec19a9c5.jpg', ''),
(31, 'WEECP', 23, NULL, ''),
(32, 'Class 1', 26, 'group_329949f0d7.jpg', ''),
(33, 'zGroup Class', 27, 'group_33203d696b.jpg', ''),
(34, 'Class Nr 1.', 28, 'group_348d3ed4ae.jpg', ''),
(35, 'Class 1.', 29, NULL, ''),
(36, 'Test', 30, 'group_36e74ca414.jpg', ''),
(37, 'TEST2', 30, NULL, ''),
(38, '4. B osztaly', 31, NULL, ''),
(39, 'Teszt101', 32, 'group_391ccc7997.jpg', ''),
(40, '12. D Osztály', 33, 'group_40b8d60b08.jpg', ''),
(41, 'Default group', 0, NULL, ''),
(42, 'Default group', 0, NULL, ''),
(43, 'Default group', 0, NULL, ''),
(44, 'Default group', 0, NULL, ''),
(45, 'Default group', 0, NULL, ''),
(46, 'Default group', 0, NULL, ''),
(47, 'Default group', 0, NULL, ''),
(48, 'Default group', 0, NULL, ''),
(49, 'Default group', 0, NULL, ''),
(50, 'Default group', 0, NULL, ''),
(51, 'Default group', 0, NULL, ''),
(52, 'Default group', 0, NULL, ''),
(53, 'Default group', 0, NULL, ''),
(54, 'Default group', 0, NULL, ''),
(55, 'Default group', 0, NULL, ''),
(56, 'Default group', 0, NULL, ''),
(57, 'Default group', 0, NULL, ''),
(58, 'Default group', 0, NULL, ''),
(59, 'Default group', 0, NULL, ''),
(60, 'Default group', 0, NULL, ''),
(61, 'Default group', 0, NULL, ''),
(62, 'Default group', 0, NULL, ''),
(63, 'Default group', 0, NULL, ''),
(64, 'Default group', 0, NULL, ''),
(65, 'Default group', 0, NULL, ''),
(66, 'Default group', 0, NULL, ''),
(88, 'Default group', 0, NULL, ''),
(68, 'Default group', 0, NULL, ''),
(69, 'Default group', 0, NULL, ''),
(70, 'Default group', 0, NULL, ''),
(71, 'Default group', 0, NULL, ''),
(90, 'Default group', 0, NULL, ''),
(73, 'Default group', 0, NULL, ''),
(74, 'Default group', 0, NULL, ''),
(75, 'Default group', 0, NULL, ''),
(76, 'Default group', 0, NULL, ''),
(77, 'Default group', 0, NULL, ''),
(78, 'Default group', 0, NULL, ''),
(79, 'Default group', 0, NULL, ''),
(80, 'Default group', 0, NULL, ''),
(89, 'Default group', 0, NULL, ''),
(82, 'Default group', 34, NULL, ''),
(83, '1.', 34, NULL, ''),
(84, '2.', 34, NULL, ''),
(85, '3.', 34, NULL, ''),
(86, '4.', 34, NULL, ''),
(87, '5.', 34, NULL, ''),
(91, 'Gryffindor', 35, 'group_91734c9d87.jpg', ''),
(92, 'Syltherin', 35, 'group_92fa479955.jpg', ''),
(93, 'Default group', 36, NULL, ''),
(94, 'Default group', 37, NULL, ''),
(95, 'Default group 2', 37, NULL, ''),
(96, 'Group I.', 38, NULL, ''),
(97, 'Group II.', 38, NULL, ''),
(98, 'Mound', 39, NULL, ''),
(99, 'MRW', 39, NULL, ''),
(100, 'Dunbar', 39, NULL, ''),
(101, 'WVille', 39, NULL, ''),
(102, 'Hannah Gibbons', 39, NULL, ''),
(103, 'Orchard', 39, NULL, ''),
(104, 'Design & Modeling', 40, NULL, ''),
(105, 'E-period', 40, NULL, ''),
(106, 'Default group', 0, NULL, ''),
(107, 'Default group', 0, NULL, ''),
(108, 'Grade 5', 41, NULL, ''),
(109, 'Kinder', 41, NULL, ''),
(110, 'Grade 1', 41, NULL, ''),
(111, 'Grade 2', 41, NULL, ''),
(112, 'Grade 3', 41, NULL, ''),
(113, 'Grade 4', 41, NULL, ''),
(114, 'Staff', 41, NULL, '');

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_group_apps`
--

CREATE TABLE IF NOT EXISTS `school_group_apps` (
`group_id` bigint(20) NOT NULL,
`app_id` bigint(20) NOT NULL,
PRIMARY KEY (`app_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- A tábla adatainak kiíratása `school_group_apps`
--

INSERT INTO `school_group_apps` (`group_id`, `app_id`) VALUES
(4, 26);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_group_collections`
--

CREATE TABLE IF NOT EXISTS `school_group_collections` (
`group_id` bigint(20) NOT NULL,
`collection_id` bigint(20) NOT NULL,
PRIMARY KEY (`collection_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_group_members`
--

CREATE TABLE IF NOT EXISTS `school_group_members` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`group_id` bigint(20) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=199 ;

--
-- A tábla adatainak kiíratása `school_group_members`
--

INSERT INTO `school_group_members` (`id`, `user_id`, `group_id`, `email`) VALUES
(1, 10, 3, ''),
(2, 67, 2, ''),
(3, 15826, 3, ''),
(4, 9, 1, ''),
(5, 44, 1, ''),
(6, 4710, 3, ''),
(7, 42, 3, ''),
(8, 4715, 3, ''),
(9, 36, 2, ''),
(10, 18, 2, ''),
(11, 528, 3, ''),
(12, 16401, 2, ''),
(13, 16421, 5, ''),
(14, 16420, 4, ''),
(15, 16424, 4, ''),
(16, 16423, 4, ''),
(17, 16422, 5, ''),
(18, 8739, 4, ''),
(19, 13, 9, ''),
(20, 16495, 4, ''),
(21, 49, 9, ''),
(22, 2, 7, ''),
(23, 3, 6, ''),
(24, 16506, 7, ''),
(25, 9, 4, ''),
(26, 13, 12, ''),
(27, 9, 12, ''),
(28, 16591, 16, ''),
(29, 16414, 16, ''),
(30, 16578, 16, ''),
(31, 13, 17, ''),
(32, 16758, 17, ''),
(33, 6849, 18, ''),
(34, 16975, 18, ''),
(35, 37, 20, ''),
(36, 13, 21, ''),
(37, 13, 20, ''),
(38, 13, 19, ''),
(39, 13, 23, ''),
(40, 17332, 23, ''),
(41, 17288, 20, ''),
(42, 17313, 19, ''),
(43, 16080, 20, ''),
(44, 17373, 21, ''),
(45, 17382, 24, ''),
(46, 17396, 26, ''),
(47, 17364, 29, ''),
(48, 17397, 30, ''),
(49, 17396, 28, ''),
(50, 17434, 29, ''),
(51, 16080, 6, ''),
(52, 16080, 7, ''),
(53, 16080, 10, ''),
(54, 17551, 28, ''),
(55, 17556, 28, ''),
(56, 17555, 28, ''),
(57, 17326, 32, ''),
(58, 17721, 33, ''),
(59, 17713, 33, ''),
(60, 17737, 34, ''),
(62, 0, 4, 'tesztl@iodigit.info'),
(63, 1, 9, ''),
(64, 1, 12, ''),
(65, 1, 17, ''),
(66, 1, 21, ''),
(67, 1, 20, ''),
(68, 1, 19, ''),
(69, 1, 23, ''),
(70, 17866, 35, ''),
(71, 0, 35, ''),
(76, 17523, 36, ''),
(77, 19380, 36, ''),
(78, 19379, 36, ''),
(79, 19379, 37, ''),
(80, 19422, 38, ''),
(82, 19422, 39, ''),
(83, 19423, 39, ''),
(84, 15879, 19, ''),
(92, 35, 40, ''),
(86, 13, 40, ''),
(87, 37, 40, ''),
(94, 19422, 40, ''),
(89, 19423, 40, ''),
(91, 17523, 40, ''),
(93, 0, 40, 'zsuzsanna.toronyi@leopoly.com'),
(95, 0, 40, 'leopolyedu@gmail.com'),
(96, 0, 40, 'leopolyedu@gmail.com'),
(101, 18754, 40, ''),
(100, 0, 40, 'gabor.klausz@leonar3do.com'),
(99, 19679, 40, ''),
(107, 19904, 86, ''),
(106, 19902, 83, ''),
(105, 19413, 40, ''),
(108, 19904, 87, ''),
(109, 20069, 40, ''),
(110, 20069, 72, ''),
(111, 20068, 40, ''),
(112, 20068, 72, ''),
(113, 0, 40, ''),
(114, 0, 72, ''),
(115, 20068, 40, ''),
(116, 20068, 72, ''),
(120, 19902, 82, 'edutest1@freemail.hu'),
(121, 19902, 83, 'edutest1@freemail.hu'),
(122, 19903, 82, 'edutest2@freemail.hu'),
(123, 19903, 83, 'edutest2@freemail.hu'),
(124, 19903, 86, 'edutest2@freemail.hu'),
(125, 19903, 87, 'edutest2@freemail.hu'),
(126, 19904, 86, 'edutest3@freemail.hu'),
(127, 19904, 87, 'edutest3@freemail.hu'),
(128, 0, 82, 'edutest4@freemail.hu'),
(129, 0, 83, 'edutest4@freemail.hu'),
(130, 0, 84, 'edutest4@freemail.hu'),
(131, 0, 82, 'edutest5@freemail.hu'),
(132, 0, 83, 'edutest5@freemail.hu'),
(133, 0, 84, 'edutest5@freemail.hu'),
(134, 0, 82, 'edutest4@freemail.hu'),
(135, 0, 83, 'edutest4@freemail.hu'),
(136, 0, 84, 'edutest4@freemail.hu'),
(137, 0, 82, 'edutest5@freemail.hu'),
(138, 0, 83, 'edutest5@freemail.hu'),
(139, 0, 84, 'edutest5@freemail.hu'),
(140, 20068, 91, ''),
(141, 20069, 91, ''),
(149, 19413, 91, 'david.gergely@leopoly.com'),
(143, 20070, 92, ''),
(145, 19679, 93, 'd007dav@gmail.com'),
(146, 19413, 93, 'david.gergely@leopoly.com'),
(148, 19902, 93, 'edutest1@freemail.hu'),
(150, 19413, 92, 'david.gergely@leopoly.com'),
(151, 20068, 94, 'edudiak@freemail.hu'),
(152, 19413, 94, 'david.gergely@leopoly.com'),
(153, 19413, 95, 'david.gergely@leopoly.com'),
(154, 20296, 94, ''),
(155, 20296, 95, ''),
(156, 20069, 96, 'edutanar@freemail.hu'),
(157, 20069, 97, 'edutanar@freemail.hu'),
(158, 35, 96, 'roland.manyai@leonar3do.com'),
(159, 35, 97, 'roland.manyai@leonar3do.com'),
(160, 4710, 91, 'henriett.zsohar@leonar3do.com'),
(161, 35, 91, 'roland.manyai@leonar3do.com'),
(162, 20435, 98, 'Ben@paalive.org'),
(163, 20435, 99, 'Ben@paalive.org'),
(164, 20435, 100, 'Ben@paalive.org'),
(165, 20435, 101, 'Ben@paalive.org'),
(166, 20435, 102, 'Ben@paalive.org'),
(167, 20435, 103, 'Ben@paalive.org'),
(168, 20445, 0, ''),
(169, 20445, 104, 'jwolfgolbach@maercker.org'),
(170, 20445, 105, 'jwolfgolbach@maercker.org'),
(171, 20569, 102, ''),
(172, 20585, 102, ''),
(173, 20584, 102, ''),
(174, 20583, 102, ''),
(175, 20581, 102, ''),
(176, 20578, 102, ''),
(177, 0, 102, 'jamespolk241@yahoo.com'),
(178, 20576, 102, ''),
(179, 20579, 102, ''),
(180, 0, 102, 'ziaraward@gmail.com'),
(181, 20580, 102, ''),
(182, 0, 102, 'chansegucciman@gmail.com'),
(183, 0, 102, ''),
(184, 20435, 98, 'Ben@paalive.org'),
(185, 20435, 99, 'Ben@paalive.org'),
(186, 20435, 100, 'Ben@paalive.org'),
(187, 20435, 101, 'Ben@paalive.org'),
(188, 20435, 102, 'Ben@paalive.org'),
(189, 20435, 103, 'Ben@paalive.org'),
(190, 20435, 98, 'Ben@paalive.org'),
(191, 20435, 99, 'Ben@paalive.org'),
(192, 20435, 100, 'Ben@paalive.org'),
(193, 20435, 101, 'Ben@paalive.org'),
(194, 20435, 102, 'Ben@paalive.org'),
(195, 20435, 103, 'Ben@paalive.org'),
(196, 20069, 108, 'edutanar@freemail.hu'),
(197, 21026, 108, 'ebert5150@gmail.com'),
(198, 0, 114, 'aherron@sandi.net');

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_group_objects`
--

CREATE TABLE IF NOT EXISTS `school_group_objects` (
`group_id` bigint(20) NOT NULL,
`object_id` bigint(20) NOT NULL,
PRIMARY KEY (`object_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- A tábla adatainak kiíratása `school_group_objects`
--

INSERT INTO `school_group_objects` (`group_id`, `object_id`) VALUES
(4, 19848),
(4, 19849),
(4, 19851),
(4, 19932),
(9, 19934),
(4, 19951),
(5, 19960),
(9, 19960),
(7, 19999),
(5, 20047),
(7, 20047),
(9, 20098),
(5, 20176),
(9, 20182),
(4, 20184),
(7, 20189),
(7, 20190),
(9, 20190),
(9, 20218),
(9, 20220),
(9, 20221),
(3, 30398),
(3, 30431),
(3, 30532),
(3, 30533),
(3, 30534),
(3, 30535),
(3, 30538),
(3, 30539),
(3, 30540),
(3, 30541),
(3, 30545),
(3, 30547),
(3, 30560),
(3, 30562),
(3, 30563),
(3, 30564),
(3, 30575),
(3, 30576),
(3, 30577),
(3, 30578),
(5, 30581),
(3, 30592),
(3, 30604),
(4, 30626),
(7, 30954),
(9, 30979),
(9, 31018),
(9, 31019),
(12, 31061),
(9, 31062),
(12, 31063),
(17, 31099),
(6, 31180),
(4, 31182),
(10, 31182),
(4, 32453),
(9, 32453),
(19, 32497),
(20, 32497),
(21, 32497),
(23, 32497),
(4, 32527),
(5, 32544),
(9, 32696),
(10, 32696),
(10, 32803),
(33, 33201),
(5, 33301),
(23, 33464),
(33, 33643),
(4, 34551),
(7, 34701),
(39, 37006),
(39, 37008),
(39, 37009),
(91, 37032),
(19, 37198),
(40, 37199),
(40, 37281),
(40, 37747),
(40, 37749),
(93, 38292),
(91, 38363),
(91, 38366),
(91, 38367),
(93, 38370),
(91, 38372),
(91, 38373),
(91, 38593),
(91, 38594),
(94, 38642),
(94, 38643),
(96, 38762),
(91, 38789),
(93, 38791),
(96, 38792),
(96, 38797),
(91, 38886),
(91, 38894),
(105, 39134),
(108, 39893),
(108, 39897),
(108, 39899),
(108, 39900),
(108, 39902),
(108, 39948);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_members`
--

CREATE TABLE IF NOT EXISTS `school_members` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`school_id` bigint(20) NOT NULL,
`role` varchar(255) NOT NULL DEFAULT 'student',
`email` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=187 ;

--
-- A tábla adatainak kiíratása `school_members`
--

INSERT INTO `school_members` (`id`, `user_id`, `school_id`, `role`, `email`) VALUES
(1, 1, 1, 'admin', ''),
(2, 10, 1, 'student', ''),
(3, 67, 1, 'student', ''),
(4, 15826, 1, 'student', ''),
(5, 528, 1, 'student', ''),
(6, 13, 1, 'student', ''),
(7, 18, 1, 'student', ''),
(8, 36, 1, 'student', ''),
(9, 4715, 1, 'student', ''),
(10, 42, 1, 'student', ''),
(11, 4710, 1, 'student', ''),
(12, 44, 1, 'student', ''),
(13, 9, 1, 'student', ''),
(14, 16401, 1, 'student', ''),
(15, 16420, 8, 'student', ''),
(16, 16421, 8, 'student', ''),
(17, 16422, 8, 'student', ''),
(18, 16423, 8, 'student', ''),
(19, 16424, 8, 'student', ''),
(20, 16425, 8, 'student', ''),
(21, 1, 8, 'admin', ''),
(22, 15826, 8, 'admin', ''),
(23, 35, 8, 'admin', ''),
(24, 49, 8, 'admin', ''),
(25, 16080, 8, 'admin', ''),
(26, 2, 9, 'admin', ''),
(27, 15240, 9, 'admin', ''),
(28, 15826, 9, 'admin', ''),
(29, 15240, 8, 'admin', ''),
(30, 9, 13, 'student', ''),
(31, 13, 9, 'admin', ''),
(32, 10, 8, 'admin', ''),
(33, 16495, 8, 'student', ''),
(34, 3, 9, 'student', ''),
(35, 16506, 9, 'student', ''),
(36, 16079, 8, 'admin', ''),
(37, 16467, 10, 'admin', ''),
(38, 13, 10, 'admin', ''),
(39, 13, 13, 'admin', ''),
(40, 13, 11, 'admin', ''),
(41, 13, 12, 'admin', ''),
(42, 9, 8, 'student', ''),
(43, 16591, 13, 'student', ''),
(44, 16578, 13, 'student', ''),
(45, 13, 15, 'admin', ''),
(46, 16758, 15, 'admin', ''),
(47, 6849, 16, 'admin', ''),
(48, 16975, 16, 'student', ''),
(49, 13, 17, 'admin', ''),
(50, 13, 18, 'admin', ''),
(51, 13, 19, 'admin', ''),
(52, 37, 19, 'student', ''),
(53, 13, 20, 'admin', ''),
(54, 13, 21, 'admin', ''),
(55, 17332, 21, 'admin', ''),
(56, 17288, 19, 'admin', ''),
(57, 17313, 18, 'admin', ''),
(58, 17373, 20, 'admin', ''),
(59, 37, 15, 'student', ''),
(60, 17382, 22, 'admin', ''),
(61, 17396, 23, 'admin', ''),
(62, 17364, 24, 'admin', ''),
(63, 17397, 25, 'admin', ''),
(64, 17434, 24, 'admin', ''),
(65, 16080, 9, 'admin', ''),
(66, 17551, 23, 'student', ''),
(67, 17556, 23, 'student', ''),
(68, 17555, 23, 'student', ''),
(69, 17326, 26, 'admin', ''),
(70, 17721, 27, 'admin', ''),
(71, 17713, 27, 'admin', ''),
(72, 17737, 28, 'admin', ''),
(74, 0, 8, 'student', 'tesztl@iodigit.info'),
(76, 17866, 29, 'admin', ''),
(82, 17523, 30, 'student', ''),
(83, 19380, 30, 'student', ''),
(85, 19379, 30, 'student', ''),
(87, 19422, 31, 'admin', ''),
(90, 19422, 32, 'admin', ''),
(92, 19423, 32, 'student', ''),
(94, 15879, 18, 'admin', ''),
(152, 20068, 37, 'student', ''),
(146, 20069, 35, 'admin', ''),
(144, 20068, 35, 'student', ''),
(102, 0, 33, 'student', 'zsuzsanna.toronyi@leopoly.com'),
(105, 0, 33, 'student', 'leopolyedu@gmail.com'),
(107, 0, 18, 'student', 'istvan@symplanet.com'),
(110, 0, 33, 'admin', 'gabor.klausz@leonar3do.com'),
(142, 0, 34, 'student', 'edutest4@freemail.hu'),
(143, 0, 34, 'student', 'edutest5@freemail.hu'),
(138, 19903, 34, 'student', ''),
(130, 0, 33, 'student', ''),
(137, 19902, 34, 'admin', ''),
(139, 19904, 34, 'student', ''),
(128, 20069, 33, 'student', ''),
(131, 20068, 33, 'student', ''),
(148, 20070, 35, 'student', ''),
(151, 19902, 36, 'student', ''),
(153, 20296, 37, 'student', ''),
(155, 20069, 38, 'admin', ''),
(157, 35, 38, 'admin', ''),
(158, 4710, 35, 'student', ''),
(160, 35, 35, 'admin', ''),
(165, 20445, 40, 'admin', ''),
(186, 0, 41, 'student', 'aherron@sandi.net'),
(185, 21026, 41, 'admin', ''),
(172, 0, 39, 'student', 'jamespolk241@yahoo.com'),
(183, 20069, 41, 'admin', ''),
(181, 20435, 39, 'admin', ''),
(175, 0, 39, 'student', 'ziaraward@gmail.com'),
(178, 0, 39, 'student', ''),
(177, 0, 39, 'student', 'chansegucciman@gmail.com');

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_task`
--

CREATE TABLE IF NOT EXISTS `school_task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`app_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`main_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`school_id` bigint(20) DEFAULT NULL,
`group_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=57 ;

--
-- A tábla adatainak kiíratása `school_task`
--

INSERT INTO `school_task` (`id`, `name`, `slug`, `app_name`, `description`, `main_image`, `school_id`, `group_id`) VALUES
(4, 'ftgedfg', '', '', 'ddfdf', 'default.jpg', 30, NULL),
(2, 'Test task valami ', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam nisl lacus, vulputate sit amet nunc vel, pellentesque mattis libero. Maecenas sed fringilla dolor. Aenean nec nunc sit amet tortor aliquam mollis. In finibus sodales porta. Mauris finibus augue et odio convallis, vitae lacinia libero finibus. Integer vestibulum ex non metus porta hendrerit. Cras ac mauris non nisl tincidunt luctus eu at orci. Duis ac vestibulum lorem, non accumsan felis. Nunc id egestas lorem, in molestie tortor. Mauris interdum malesuada orci, at fermentum magna semper vel. Sed ex nisi, pretium vel nisl et, pellentesque finibus libero. Nullam eget turpis quam. Etiam ornare augue dapibus consectetur vehicula. Nulla facilisi.\r\n\r\nSed et sapien in mauris ullamcorper consequat nec a lectus. Mauris hendrerit aliquet turpis sed placerat. Sed sollicitudin pharetra laoreet. Quisque at sapien fringilla, euismod massa id, venenatis enim. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nunc tempor sed risus et vestibulum. Phasellus nibh nibh, varius ac fermentum vitae, condimentum quis est. Pellentesque fringilla felis tincidunt consequat pellentesque.\r\n\r\n', 'default.jpg', 21, 0),
(5, 'Test task', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eleifend vel dui sit amet aliquam. Quisque quis metus sed nisl elementum aliquam. Pellentesque sed turpis est. Nam euismod pretium varius. Quisque ante nulla, tempor imperdiet quam eu, condimentum volutpat quam. Pellentesque sed nisl ac tellus vestibulum convallis. Suspendisse pellentesque leo ullamcorper, tincidunt arcu non, tempor ex.\r\n', 'task_5c742156a.jpg', 18, 0),
(6, 'Sziasztok Bocikák', '', '', 'Ezt vedd be ha tudod', 'task_6dc16ee64.jpg', 32, NULL),
(7, 'Na és ezt beveszed?', '', '', 'MŰKÖDJÉL MÁR!', 'task_720148f0b.jpg', 32, NULL),
(8, 'Another test task', '', '', 'tag your weird creature', 'default.jpg', 18, NULL),
(9, 'Rajzolj almát a gömbből', '', '', 'Formázd át és színezd ki a gömböt', 'task_91670bbb1.jpg', 33, 0),
(23, '11', '', '', '1', 'default.jpg', 36, 0),
(17, 'Ring ring', '', '', '', 'task_17b95e214d..png', 36, 0),
(34, 'Make your unique pendant!', '', '', '1. Browse among the templates and choose your favorite\r\n\r\n2. Change its color\r\n\r\n3. Select *Picture* and upload a black and white or colorful PNG logo.\r\n\r\n4. Engrave or emboss your logo\r\n\r\n5. Add some words if you feel like!\r\n\r\nWant to vary the colors between the different depth and height of the engraved and embossed parts?\r\nDuring the FDM printing process you can change the color by switching different colored filaments. This way, you will get different colors layer by layer.\r\n', 'task_347ba07ee5..png', 35, 0),
(14, '1', '', '', 'Talán jó lesz?', 'default.jpg', 34, 0),
(24, 'Default Task', '', '', '', 'default.jpg', 37, NULL),
(25, 'Default Task', '', '', 'Create your very own, unique Gift Box part!\r\nJust click on a model to start!', 'default.jpg', 37, 0),
(26, 'Create a pear!', '', '', 'First, click on the sphere and start sculpting to form the pear. The two most important sculpting tools you going to need for this task are the push&full and flatten tools.\r\n\r\nIf you are satisfied with your work, click on the color brush and colorize! \r\n\r\nEXTRA: Try to create a lovely face for your little pear', 'task_26df4a90aa..png', 38, 0),
(27, 'Come up with your own gift box! I.', '', '', 'Make your choice and select your favorit box template!\r\n1. You will start with the formshifter tool. Form the shape by only playing with sliders.\r\n2. Swich to PATTERN or TEXT and decorate your model as you wish\r\n3. Color it up!', 'task_27e38182e4..png', 38, 0),
(28, 'Formálj körtét', '', '', '', 'task_28b3b058f2..png', 33, 0),
(32, 'Create a pear!', '', '', '1. First, click on the sphere and start sculpting to form the pear. The two most important sculpting tools you going to need for this task are the push&full and flatten tools.\r\n\r\n2. If you are satisfied with your work, click on the color brush and colorize! \r\n\r\n3. EXTRA: Try to create a lovely face for your little pear', 'task_32ab698e9d..png', 35, 0),
(33, 'Come up with your own gift box!', '', '', 'Make your choice and select your favorit box template!\r\n\r\n1. You will start with the formshifter tool. Form the shape by only playing with sliders.\r\n\r\n2. Swich to PATTERN or TEXT and decorate your model as you wish\r\n\r\n3. Color it up!', 'task_335735b5d7..png', 35, 0),
(35, 'Renovate Venus de Milo', '', '', 'Improve, renovate Venus de Milo, the ancient Greek statue and one of the most famous works of ancient Greek sculpture.\r\n\r\nYou will have to use all the sculpting tools in order to create suitable arms. Try to start with the pull&push tools, and adjust with the edge-tool. \r\n\r\nIf you are done with the shaping, try to reimagine the clothes in different colors then try to realize what you have in mind.\r\n\r\nThese short demo videos can help you start:\r\n\r\n- Sculpting: https://www.youtube.com/watch?v=C7S4gn0tENQ\r\n\r\n- Painting (From 0:39): https://www.youtube.com/watch?v=H9gI4HCNnnI', 'task_354bdb2bf4..png', 35, 0),
(42, 'Create a pear!', '', '', '1. First, click on the sphere and start sculpting to form the pear. The two most important sculpting tools you going to need for this task are the push&full and flatten tools.\r\n\r\n2. If you are satisfied with your work, click on the color brush and colorize! \r\n\r\n3. EXTRA: Try to create a lovely face for your little pear', 'task_32ab698e9d..png', 39, 0),
(55, 'Make your unique pendant!', '', '', '1. Browse among the templates and choose your favorite\r\n\r\n2. Change its color\r\n\r\n3. Select *Picture* and upload a black and white or colorful PNG logo.\r\n\r\n4. Engrave or emboss your logo\r\n\r\n5. Add some words if you feel like!\r\n\r\nWant to vary the colors between the different depth and height of the engraved and embossed parts?\r\nDuring the FDM printing process you can change the color by switching different colored filaments. This way, you will get different colors layer by layer.\r\n', 'task_347ba07ee5..png', 41, 0),
(53, 'Create a pear!', '', '', '1. First, click on the sphere and start sculpting to form the pear. The two most important sculpting tools you going to need for this task are the push&full and flatten tools.\r\n\r\n2. If you are satisfied with your work, click on the color brush and colorize! \r\n\r\n3. EXTRA: Try to create a lovely face for your little pear', 'task_32ab698e9d..png', 41, 0),
(54, 'Come up with your own gift box!', '', '', 'Make your choice and select your favorit box template!\r\n\r\n1. You will start with the formshifter tool. Form the shape by only playing with sliders.\r\n\r\n2. Swich to PATTERN or TEXT and decorate your model as you wish\r\n\r\n3. Color it up!', 'task_335735b5d7..png', 41, 0),
(52, 'Paint a Hero', '', '', 'Select the pre-made human figure and explore with the paint tools to create a cool costume for the character!\r\n\r\nDon\\''t be afraid to edit and sculpt the figure to adjust to your needs!', 'default.jpg', 39, NULL),
(51, 'Paint a Head', '', '', 'Try to paint this head realistically. Think about different colors and skin tones. Are eyeballs actually white, or are they more of an off-white color. Etc.\r\n\r\nAfter painting the head realistically, try to come up with some good color combinations and designs for a superhero mask. At this stage try editing the form of the head to be closer to a superhero.', 'default.jpg', 39, NULL),
(46, 'Create a pear!', '', '', '1. First, click on the sphere and start sculpting to form the pear. The two most important sculpting tools you going to need for this task are the push&full and flatten tools.\r\n\r\n2. If you are satisfied with your work, click on the color brush and colorize! \r\n\r\n3. EXTRA: Try to create a lovely face for your little pear', 'task_32ab698e9d..png', 40, 0),
(47, 'Come up with your own gift box!', '', '', 'Make your choice and select your favorit box template!\r\n\r\n1. You will start with the formshifter tool. Form the shape by only playing with sliders.\r\n\r\n2. Swich to PATTERN or TEXT and decorate your model as you wish\r\n\r\n3. Color it up!', 'task_335735b5d7..png', 40, 0),
(48, 'Make your unique pendant!', '', '', '1. Browse among the templates and choose your favorite\r\n\r\n2. Change its color\r\n\r\n3. Select *Picture* and upload a black and white or colorful PNG logo.\r\n\r\n4. Engrave or emboss your logo\r\n\r\n5. Add some words if you feel like!\r\n\r\nWant to vary the colors between the different depth and height of the engraved and embossed parts?\r\nDuring the FDM printing process you can change the color by switching different colored filaments. This way, you will get different colors layer by layer.\r\n', 'task_347ba07ee5..png', 40, 0),
(49, 'Renovate Venus de Milo', '', '', 'Improve, renovate Venus de Milo, the ancient Greek statue and one of the most famous works of ancient Greek sculpture.\r\n\r\nYou will have to use all the sculpting tools in order to create suitable arms. Try to start with the pull&push tools, and adjust with the edge-tool. \r\n\r\nIf you are done with the shaping, try to reimagine the clothes in different colors then try to realize what you have in mind.\r\n\r\nThese short demo videos can help you start:\r\n\r\n- Sculpting: https://www.youtube.com/watch?v=C7S4gn0tENQ\r\n\r\n- Painting (From 0:39): https://www.youtube.com/watch?v=H9gI4HCNnnI', 'task_354bdb2bf4..png', 40, 0),
(50, 'Create A Head ', '', '', 'Try your best to sculpt a head from a sphere! Think about the different shapes that make up the head while you are using Leopoly to sculpt. ', 'default.jpg', 39, 0);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_task_group`
--

CREATE TABLE IF NOT EXISTS `school_task_group` (
`task_id` bigint(20) NOT NULL,
`group_id` bigint(20) NOT NULL,
PRIMARY KEY (`task_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- A tábla adatainak kiíratása `school_task_group`
--

INSERT INTO `school_task_group` (`task_id`, `group_id`) VALUES
(0, 93),
(2, 23),
(4, 36),
(4, 37),
(5, 19),
(6, 39),
(7, 39),
(8, 19),
(9, 40),
(14, 82),
(17, 93),
(23, 93),
(25, 94),
(25, 95),
(26, 96),
(26, 97),
(27, 96),
(27, 97),
(28, 40),
(32, 91),
(32, 92),
(33, 91),
(33, 92),
(34, 91),
(34, 92),
(35, 91),
(35, 92),
(42, 98),
(42, 99),
(42, 100),
(42, 101),
(42, 102),
(42, 103),
(46, 104),
(46, 105),
(47, 104),
(47, 105),
(48, 104),
(48, 105),
(49, 104),
(49, 105),
(50, 102),
(51, 102),
(52, 102),
(53, 108),
(54, 108),
(55, 108);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_task_object`
--

CREATE TABLE IF NOT EXISTS `school_task_object` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`task_id` int(11) NOT NULL,
`object_id` bigint(20) NOT NULL,
`app_slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`mode` text COLLATE utf8_unicode_ci NOT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `task_id` (`task_id`),
KEY `object_id` (`object_id`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=343 ;

--
-- A tábla adatainak kiíratása `school_task_object`
--

INSERT INTO `school_task_object` (`id`, `task_id`, `object_id`, `app_slug`, `mode`, `group_id`) VALUES
(39, 6, 33539, 'scratch-v02', '', NULL),
(38, 5, 36845, 'scratch-v02', '', NULL),
(37, 4, 33509, 'candle-holder', '', NULL),
(36, 2, 33509, 'candle-holder', '', NULL),
(35, 2, 36863, 'scratch-v02', '', NULL),
(40, 7, 33538, 'scratch-v02', '', NULL),
(41, 8, 15677, 'pettag', '', NULL),
(58, 9, 34715, 'funnyfriend', '', NULL),
(78, 17, 37768, 'scratch-v02', '', NULL),
(57, 9, 34714, 'funnyfriend', '', NULL),
(56, 9, 34717, 'funnyfriend', '', NULL),
(55, 9, 33509, 'scratch-v02', '', NULL),
(77, 17, 38050, 'HolidayRings', '', NULL),
(65, 14, 36918, 'DeskNamePlate', '', NULL),
(240, 34, 33822, 'pendant', 'pendant', NULL),
(239, 34, 33902, 'pendant', 'pendant', NULL),
(238, 34, 33824, 'pendant', 'pendant', NULL),
(237, 34, 33818, 'pendant', 'pendant', NULL),
(236, 34, 33819, 'pendant', 'pendant', NULL),
(165, 25, 37028, 'HolidayGiftBox', 'HolidayGiftBox', NULL),
(164, 25, 37022, 'HolidayGiftBox', 'HolidayGiftBox', NULL),
(163, 25, 38257, 'HolidayGiftBox', 'HolidayGiftBox', NULL),
(100, 9, 38452, 'scratch-v02', '', NULL),
(101, 9, 38446, 'scratch-v02', '', NULL),
(241, 34, 33823, 'pendant', 'pendant', NULL),
(159, 23, 37187, 'Under30mins', 'engraveonly', NULL),
(158, 23, 38237, 'Under30mins', 'pendant', NULL),
(155, 0, 37187, 'Under30mins', 'engraveonly', NULL),
(154, 0, 38237, 'Under30mins', 'pendant', NULL),
(169, 26, 33509, 'scratch-v02', '', NULL),
(177, 27, 37032, 'GiftBox', 'paintengravedeform', NULL),
(176, 27, 37030, 'GiftBox', 'paintengravedeform', NULL),
(175, 27, 37028, 'GiftBox', 'paintengravedeform', NULL),
(174, 27, 38257, 'GiftBox', 'paintengravedeform', NULL),
(179, 28, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(190, 32, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(188, 33, 37032, 'GiftBox', 'paintengravedeform', NULL),
(187, 33, 37028, 'GiftBox', 'paintengravedeform', NULL),
(186, 33, 38257, 'GiftBox', 'paintengravedeform', NULL),
(235, 34, 33820, 'pendant', 'pendant', NULL),
(234, 34, 33827, 'pendant', 'pendant', NULL),
(233, 34, 33903, 'pendant', 'pendant', NULL),
(232, 35, 38893, 'scratch-v02', '', NULL),
(242, 0, 37767, 'scratch-v02', '', NULL),
(272, 42, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(335, 55, 33824, 'pendant', 'pendant', NULL),
(336, 55, 33818, 'pendant', 'pendant', NULL),
(333, 55, 33822, 'pendant', 'pendant', NULL),
(334, 55, 33902, 'pendant', 'pendant', NULL),
(332, 54, 38257, 'GiftBox', 'paintengravedeform', NULL),
(331, 54, 37028, 'GiftBox', 'paintengravedeform', NULL),
(330, 54, 37032, 'GiftBox', 'paintengravedeform', NULL),
(329, 53, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(328, 52, 33806, 'Start From Scratch', 'scratchsculpt', NULL),
(327, 51, 33805, 'Start From Scratch', 'scratchsculpt', NULL),
(273, 46, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(323, 47, 37030, 'GiftBox', 'paintengravedeform', NULL),
(322, 47, 37028, 'GiftBox', 'paintengravedeform', NULL),
(321, 47, 37026, 'GiftBox', 'paintengravedeform', NULL),
(320, 47, 37024, 'GiftBox', 'paintengravedeform', NULL),
(319, 47, 37022, 'GiftBox', 'paintengravedeform', NULL),
(318, 47, 38257, 'GiftBox', 'paintengravedeform', NULL),
(317, 47, 37033, 'GiftBox', 'paintengrave', NULL),
(316, 47, 36989, 'GiftBox', 'paintengrave', NULL),
(315, 47, 36991, 'GiftBox', 'paintengrave', NULL),
(292, 48, 33903, 'pendant', 'pendant', NULL),
(293, 48, 33827, 'pendant', 'pendant', NULL),
(294, 48, 33820, 'pendant', 'pendant', NULL),
(295, 48, 33819, 'pendant', 'pendant', NULL),
(296, 48, 33818, 'pendant', 'pendant', NULL),
(297, 48, 33824, 'pendant', 'pendant', NULL),
(298, 48, 33902, 'pendant', 'pendant', NULL),
(299, 48, 33822, 'pendant', 'pendant', NULL),
(300, 48, 33823, 'pendant', 'pendant', NULL),
(301, 49, 38893, 'scratch-v02', '', NULL),
(324, 47, 37032, 'GiftBox', 'paintengravedeform', NULL),
(326, 50, 33509, 'Start From Scratch', 'scratchsculpt', NULL),
(337, 55, 33819, 'pendant', 'pendant', NULL),
(338, 55, 33823, 'pendant', 'pendant', NULL),
(339, 55, 33820, 'pendant', 'pendant', NULL),
(340, 55, 33827, 'pendant', 'pendant', NULL),
(341, 55, 33903, 'pendant', 'pendant', NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_task_solution`
--

CREATE TABLE IF NOT EXISTS `school_task_solution` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`task_id` int(11) NOT NULL,
`object_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`rating` int(11) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `task_id` (`task_id`),
KEY `object_id` (`object_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;

--
-- A tábla adatainak kiíratása `school_task_solution`
--

INSERT INTO `school_task_solution` (`id`, `task_id`, `object_id`, `user_id`, `rating`, `comment`) VALUES
(1, 8, 37198, 1, 0, ''),
(2, 9, 37199, 17523, 5, 'Nagyszerű munkát végeztél fiam!'),
(4, 9, 37700, 13, 0, ''),
(5, 9, 37746, 19413, 0, ''),
(8, 14, 37957, 19679, 0, ''),
(9, 14, 37958, 19902, 0, ''),
(15, 17, 38292, 19413, 0, ''),
(31, 35, 38894, 20068, 0, ''),
(18, 17, 38370, 19902, 0, ''),
(30, 34, 38886, 20069, 4, 'Great job!'),
(24, 25, 38642, 13, 0, ''),
(25, 25, 38643, 20068, 0, ''),
(26, 26, 38762, 20069, 0, ''),
(27, 23, 38791, 19413, 0, ''),
(28, 27, 38792, 13, 0, ''),
(29, 27, 38797, 20069, 0, '');

/*!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 */;

-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Gép: localhost:3306
-- Létrehozás ideje: 2016. Jún 24. 15:35
-- Kiszolgáló verziója: 5.5.42
-- PHP verzió: 5.3.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Adatbázis: `leopoly`
--

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `school_comment`
--

CREATE TABLE `school_comment` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexek a kiírt táblákhoz
--

--
-- A tábla indexei `school_comment`
--
ALTER TABLE `school_comment`
ADD PRIMARY KEY (`id`);

--
-- A kiírt táblák AUTO_INCREMENT értéke
--

--
-- AUTO_INCREMENT a táblához `school_comment`
--
ALTER TABLE `school_comment`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `school_comment` ADD `group_id` INT NOT NULL AFTER `user_id`;

ALTER TABLE `school_comment` ADD `comment` TEXT NOT NULL AFTER `group_id`;