INSERT INTO `mm_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'User\\CompanyEventHistory\\', 'Company Individuals Event History', '1200');


DROP TABLE IF EXISTS `mm_EventSubtype`;
-- --------------------------------------------------------

--
-- Структура таблиці `mm_EventSubtype`
--

CREATE TABLE IF NOT EXISTS `mm_EventSubtype` (
  `id` char(16) NOT NULL,
  `typeId` char(16) NOT NULL,
  `title` varchar(32) NOT NULL,
  `sorter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп даних таблиці `mm_EventSubtype`
--

INSERT INTO `mm_EventSubtype` (`id`, `typeId`, `title`, `sorter`) VALUES
('arcFlash', 'workshop', 'Arc Flash', 0),
('competentPerson', 'workshop', 'Competent Person', 1),
('confinedSpace', 'workshop', 'Confined Space', 2),
('crossTraining', 'workshop', 'Cross Training', 3),
('customerService', 'workshop', 'Customer Service', 4),
('excavation', 'workshop', 'Excavation', 5),
('firstLineSupervi', 'workshop', 'FirstLine Supervision', 6),
('gas', 'workshop', 'Gas', 7),
('generation', 'workshop', 'Generation', 8),
('hazard', 'workshop', 'Hazard', 9),
('legal', 'workshop', 'Legal', 10),
('legislative', 'conference', 'Legislative', 0),
('lineman', 'workshop', 'Lineman', 11),
('locating', 'workshop', 'Locating', 12),
('lossControl', 'workshop', 'Loss Control', 13),
('maintenance', 'workshop', 'Maintenance', 14),
('meter', 'workshop', 'Meter', 15),
('nesc', 'workshop', 'NESC', 16),
('overhead', 'workshop', 'Overhead', 17),
('pmug', 'workshop', 'PMUG', 18),
('poleClimbing', 'workshop', 'Pole Climbing', 19),
('regional', 'workshop', 'Regional', 20),
('substation', 'workshop', 'Substation', 21),
('summer', 'conference', 'Summer', 1),
('telecom', 'workshop', 'Telecom', 22),
('to', 'conference', 'T&O Conference', 2),
('transformer', 'workshop', 'Transformer', 23),
('underground', 'workshop', 'Underground', 24),
('water', 'workshop', 'Water', 25);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mm_EventSubtype`
--
ALTER TABLE `mm_EventSubtype`
 ADD PRIMARY KEY (`id`), ADD KEY `typeId` (`typeId`);

--
-- Обмеження зовнішнього ключа збережених таблиць
--

--
-- Обмеження зовнішнього ключа таблиці `mm_EventSubtype`
--
ALTER TABLE `mm_EventSubtype`
ADD CONSTRAINT `mm_EventSubtype_ibfk_1` FOREIGN KEY (`typeId`) REFERENCES `mm_EventType` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
