xrSHrLdv

1-- phpMyAdmin SQL Dump
2-- version 5.1.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: 192.168.0.16
6-- Generation Time: Jul 15, 2021 at 05:32 PM
7-- Server version: 10.5.11-MariaDB
8-- PHP Version: 7.4.16
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- Database: `ftn_conference`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `ft_participation_fees`
28--
29
30DROP TABLE IF EXISTS `ft_participation_fees`;
31CREATE TABLE `ft_participation_fees` (
32  `id` int(11) NOT NULL,
33  `conference_id` int(11) DEFAULT NULL,
34  `name` varchar(255) DEFAULT NULL,
35  `description` text DEFAULT NULL,
36  `amount` float(8,2) DEFAULT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39--
40-- Dumping data for table `ft_participation_fees`
41--
42
43INSERT INTO `ft_participation_fees` (`id`, `conference_id`, `name`, `description`, `amount`) VALUES
44(1, 5, 'Full rate conference or author registration', 'Conference, exhibition, lunches, Welcome Reception, Gala Dinner and proceedings included  - Possibility to upload one paper', NULL),
45(2, 5, 'EPE/IEEE member, EPE Council, EPE-PEMC Council Member conference or author registration', 'Conference, exhibition, lunches, Welcome Reception, Gala Dinner and proceedings included - Possibility to upload one paper', NULL),
46(3, 5, 'IEEE Life Member', 'Conference, exhibition, lunches, Welcome Reception, Gala Dinner and proceedings included - Possibility to upload one paper', NULL),
47(4, 5, 'Discount country, conference or author registration', 'Conference, exhibition, lunches, Welcome Reception, Gala Dinner and proceedings included - Possibility to upload one paper', NULL),
48(5, 5, 'Student, conference or author registration', 'Conference, exhibition, lunches, Welcome Reception, Gala Dinner and proceedings included - Possibility to upload one paper', NULL),
49(6, 5, 'Student, conference registration (not for authors)', 'Conference, exhibition, lunches, Welcome Reception and proceedings included –  Gala Dinner NOT included', NULL),
50(7, 5, 'Student & EPE/IEEE/IET member, conference registration (not for authors)', 'Conference, exhibition, lunches, Welcome Reception and proceedings included - Gala Dinner NOT included', NULL),
51(8, 5, 'One registration fee for all tutorials', NULL, NULL),
52(9, 5, 'Extra Welcome Reception', 'Access to the exhibition included', NULL),
53(10, 5, 'Extra Gala Dinner', NULL, NULL),
54(11, 5, 'Extra Proceedings', NULL, NULL),
55(12, 7, 'Regular conference registration', NULL, NULL),
56(13, 7, 'Student conference registration', NULL, NULL),
57(14, 9, 'Full Registration Fee', NULL, 250.00),
58(15, 9, 'IEEE Member AND International Programme Committee Members', NULL, 200.00),
59(16, 9, 'IEEE Members', NULL, 225.00),
60(17, 9, 'International Programme Committee Members', NULL, 225.00),
61(18, 13, 'Full Registration Fee', NULL, 15000.00),
62(19, 13, 'Student with Paper', NULL, 10000.00),
63(20, 13, 'Student without Paper', NULL, 5000.00),
64(21, 12, 'Full participant', '', 44080.00),
65(22, 12, 'Student (reduced)', '', 35960.00),
66(23, 16, 'Full Registration Fee', '', 25000.00),
67(24, 15, 'Full Registration Fee', '', 25000.00),
68(25, 15, 'International Programme Committee Members', '', 22500.00),
69(26, 15, 'IEEE Members', '', 22500.00),
70(27, 15, 'Master and PH.D. students', '', 20000.00),
71(28, 16, 'International Programme Committee Members', '', 22500.00),
72(29, 16, 'IEEE Members', '', 22500.00),
73(30, 16, 'Master and PH.D. students', '', 20000.00),
74(31, 15, 'IEEE Members AND Programme Committee Members', '', 20000.00),
75(32, 16, 'IEEE Members AND Programme Committee Members', '', 20000.00),
76(33, 18, 'Regular participant, regular registration fee (after May 10th, 2016)', '', 43750.00),
77(34, 18, 'Student participant, regular registration fee (after May 10th, 2016)', '', 37500.00),
78(35, 18, 'TYPES + EUTypes meeting (for approved CA15123 EUTypes participants only)', '', 31250.00),
79(36, 23, 'IEEE Member', '', 60000.00),
80(37, 23, 'Non-Member', '', 72500.00),
81(38, 23, 'IEEE Life Member', '', 33750.00),
82(39, 23, 'Student Member', '', 33750.00),
83(40, 23, 'Student Non-Member', '', 60000.00),
84(41, 23, 'Extra Ticket for Excursion', '', 3750.00),
85(42, 23, 'Extra Ticket for Banquet', '', 3750.00),
86(43, 20, 'Paper Author - per paper', NULL, 22500.00),
87(44, 20, 'Participant Without Paper', NULL, 18000.00),
88(45, 20, 'Ph.D./M.Sc. Student Papers - copy of Index is required', NULL, 11250.00),
89(46, 20, 'Accompaning person', NULL, 7500.00),
90(47, 19, 'IEEE or EPE Member', 'Full Registration Fee', 28125.00),
91(48, 19, 'International Programme Committee Member', 'Full Registration Fee', 28125.00),
92(49, 19, 'Non-Member', 'Full Registration Fee', 31250.00),
93(50, 19, 'Student Member', 'Full Registration Fee', 23437.00),
94(51, 21, 'IEEE or EPE Member', 'Early bid registration fee', 22500.00),
95(52, 21, 'International Programme Committee Member', 'Early bid registration fee', 22500.00),
96(53, 21, 'Non-Member', 'Early bid registration fee', 25000.00),
97(54, 21, 'Student Member', 'Early bid registration fee', 18750.00),
98(55, 19, 'None', 'For case you want to order tutorial only', 0.00),
99(56, 19, 'Tutorial 1 - Dr Petar. J. Grbovic: \"Power Converters for Energy Storage Applications\"', '', 6250.00),
100(57, 19, 'Tutorial 2 - Prof. Drazen Dujic Mr. Marko Mogorovic: \"High Power Medium Frequency Transformer Design Optimization\"', NULL, 6250.00),
101(58, 19, 'Tutorial 3 - Prof. Jose A. Cobos \"Differential Power\"', NULL, 6250.00),
102(59, 19, 'Tutorial 4 - doc. dr Boris Dumnic, doc. dr Dragan Milicevic, M.Sc Bane Popadic - \"A comprehensive study of photovoltaic power plant operation and maintenance - from concept to profitability\"', NULL, 6250.00),
103(60, 28, 'IEEE Member (*) (1)', 'Registration fee for Eurocon 2019.', 50400.00),
104(61, 28, 'IEEE Life(*)/Student Member (**) (1)(2)', 'Registration fee for Eurocon 2019.', 38400.00),
105(62, 28, 'Non IEEE members (*)', 'Registration fee for Eurocon 2019.', 60000.00),
106(63, 28, 'Students NON members of IEEE (**) (2)', 'Registration fee for Eurocon 2019. ', 44400.00),
107(64, 28, 'Accompanying person (***)', 'Registration fee for Eurocon 2019. ', 31200.00),
108(65, 28, 'Additional paper fee', 'Registration fee for Eurocon 2019. ', 18000.00),
109(66, 28, 'Additional pages (****)', 'Registration fee for Eurocon 2019. ', 0.00),
110(67, 28, 'Choose your Conference registration', 'Registration fee for Eurocon 2019. ', 0.00),
111(68, 28, 'Additional pages: 1', 'Registration fee for Eurocon 2019. ', 12000.00),
112(69, 28, 'Additional pages: 2', 'Registration fee for Eurocon 2019. ', 24000.00),
113(70, 28, 'Additional pages: 3', 'Registration fee for Eurocon 2019. ', 36000.00),
114(71, 28, 'Additional pages: 4', 'Registration fee for Eurocon 2019. ', 48000.00),
115(72, 28, 'Additional pages: 5', 'Registration fee for Eurocon 2019. ', 60000.00),
116(73, 28, 'Additional pages: 6', 'Registration fee for Eurocon 2019. ', 72000.00),
117(74, 26, 'IEEE or EPE Member', 'Full Registration Fee', 30000.00),
118(75, 26, 'International Programme Committee Member', 'Full Registration Fee', 30000.00),
119(76, 26, 'Non-Member', 'Full Registration Fee', 30000.00),
120(77, 26, 'Student Member', 'Full Registration Fee', 30000.00),
121(78, 26, 'None', 'For case you want to order tutorial only', 0.00),
122(79, 26, 'Tutorial 1 - Darko Vracar, Brusa Elektronik (München) GmbH, Munich, Germany', '', 6000.00),
123(80, 26, 'Accompanying person', NULL, 6000.00),
124(81, 27, 'IEEE or EPE Member', 'Early bid registration fee', 21600.00),
125(82, 27, 'International Programme Committee Member', 'Early bid registration fee', 21600.00),
126(83, 27, 'Non-Member', 'Early bid registration fee', 24000.00),
127(84, 27, 'Student Member', 'Early bid registration fee', 18000.00),
128(85, 27, 'Accompanying person', NULL, 6000.00),
129(86, 26, 'Tutorial 2 - Prof. Drazen Dujic, Mr. Stefan Milovanovic Power Electronics Laboratory - PEL, Swiss Federal Institute of Technology - EPFL, Lausanne, Switzerland', '', 6000.00),
130(87, 31, 'Regular non-IEEE member', '', 12000.00),
131(88, 31, 'Regular IEEE member', '', 9600.00),
132(89, 31, 'Student non-IEEE member', '', 7200.00),
133(90, 31, 'Student IEEE member', '', 6000.00),
134(91, 31, 'Accompanying person', '', 0.00),
135(92, 32, 'Regular', '', 76700.00),
136(93, 32, 'Online participation (regular & student/retired)', '', 39000.00),
137(94, 32, 'Student/Retired', '', 59000.00),
138(95, 32, 'Student/Retired (online participation)', '', 23600.00),
139(96, 32, 'Guest', '', 23600.00),
140(97, 32, 'Welcome Reception, August 30, 2020', '', 0.00),
141(98, 32, 'Lunch, August 31, 2020', '', 0.00),
142(99, 32, 'Novi Sad city guided tour, August 31, 2020', '', 0.00),
143(100, 32, 'Lunch, September 1, 2020', NULL, 0.00),
144(101, 32, 'Gala Dinner, September 1, 2020', NULL, 0.00),
145(102, 32, 'Lunch, September 2, 2020', NULL, 0.00),
146(103, 32, 'Wine Tour, September 2, 2020', NULL, 0.00),
147(104, 32, 'Industry tour, September 3, 2020', NULL, 0.00),
148(106, 32, 'One-day online participation', NULL, 17700.00),
149(107, 34, 'Registration Fee, Hybrid', NULL, 25960.00),
150(109, 34, 'Accompanying persons fee (social events only), Hybrid', NULL, 5900.00),
151(110, 34, 'International Programme Committee Members, Hybrid', NULL, 23364.00),
152(111, 34, 'IEEE (IES, IAS, PELS) or EPE Members, Hybrid', NULL, 23364.00),
153(112, 34, 'Student paper, Hybrid', NULL, 19470.00),
154(113, 34, 'Registration Fee, Virtual', NULL, 12980.00),
155(115, 34, 'International Programme Committee Members, Virtual', NULL, 11682.00),
156(116, 34, 'IEEE (IES, IAS, PELS) or EPE Members, Virtual', NULL, 11682.00),
157(117, 34, 'Student paper, Virtual', NULL, 9735.00),
158(118, 34, 'Tutorial 1, Hybrid - AI-Assisted Condition and Health Monitoring in Power Electronics, Hybrid', NULL, 9440.00),
159(119, 34, 'Tutorial 2, Hybrid - Design Challenges for high-performance GaN based converters in multi-MHz applications\r\n', NULL, 9440.00),
160(120, 34, 'Tutorial 1, Virtual - AI-Assisted Condition and Health Monitoring in Power Electronics, Hybrid', NULL, 5900.00),
161(121, 34, 'Tutorial 2, Virtual - Design Challenges for high-performance GaN based converters in multi-MHz applications\r\n', NULL, 5900.00),
162(122, 34, 'None', 'For case you want to order tutorial only', 0.00),
163(123, 35, 'Registration Fee, Hybrid', NULL, 24000.00),
164(124, 35, 'Accompanying persons fee (social events only), Hybrid', NULL, 6000.00),
165(125, 35, 'International Programme Committee Members, Hybrid', NULL, 21600.00),
166(126, 35, 'IEEE (IES, IAS, PELS) or EPE Members, Hybrid', NULL, 21600.00),
167(127, 35, 'Student paper, Hybrid', NULL, 18000.00),
168(128, 35, 'Registration Fee, Virtual', NULL, 13200.00),
169(129, 35, 'International Programme Committee Members, Virtual', NULL, 11880.00),
170(130, 35, 'IEEE (IES, IAS, PELS) or EPE Members, Virtual', NULL, 11880.00),
171(131, 35, 'Student paper, Virtual', NULL, 9900.00),
172(132, 35, 'Tutorial 1, Hybrid - AI-Assisted Condition and Health Monitoring in Power Electronics, Hybrid', NULL, 9600.00),
173(133, 35, 'Tutorial 2, Hybrid - Design Challenges for high-performance GaN based converters in multi-MHz applications\r\n', NULL, 9600.00),
174(134, 35, 'Tutorial 1, Virtual - AI-Assisted Condition and Health Monitoring in Power Electronics, Hybrid', NULL, 6000.00),
175(135, 35, 'Tutorial 2, Virtual - Design Challenges for high-performance GaN based converters in multi-MHz applications\r\n', NULL, 6000.00),
176(136, 35, 'Samo ucesce', 'For case you want to order tutorial only', 0.00);
177
178--
179-- Indexes for dumped tables
180--
181
182--
183-- Indexes for table `ft_participation_fees`
184--
185ALTER TABLE `ft_participation_fees`
186  ADD PRIMARY KEY (`id`),
187  ADD KEY `conference_id` (`conference_id`);
188
189--
190-- AUTO_INCREMENT for dumped tables
191--
192
193--
194-- AUTO_INCREMENT for table `ft_participation_fees`
195--
196ALTER TABLE `ft_participation_fees`
197  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;
198COMMIT;
199
200/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
201/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
202/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;