
SOM is a young, dynamic and innovative company offering a problem-solving approach. SOM has a simple philosophy: bringing together relevant people for community involvement projects.
-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 16, 2010 at 09:12 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `Som`
--
-- --------------------------------------------------------
--
-- Table structure for table `_Class`
--
DROP TABLE IF EXISTS `_Class`;
CREATE TABLE IF NOT EXISTS `_Class` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(63) collate utf8_turkish_ci NOT NULL default '',
`friendlyName` varchar(63) collate utf8_turkish_ci NOT NULL default '',
`representingPropertyId` int(11) NOT NULL default '0',
`customGrid` text collate utf8_turkish_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=15 ;
--
-- Dumping data for table `_Class`
--
INSERT INTO `_Class` (`id`, `name`, `friendlyName`, `representingPropertyId`, `customGrid`) VALUES
(1, 'Admin', 'Admin', 2, NULL),
(2, '_Class', '_Class', 65, 'O:8:"stdClass":1:{s:7:"columns";a:7:{i:0;s:2:"id";i:1;s:4:"name";i:2;s:12:"friendlyName";i:3;s:22:"representingPropertyId";i:4;s:20:"representingProperty";i:5;s:10:"_Propertys";i:6;O:8:"stdClass":6:{s:9:"fieldName";s:7:"#custom";s:6:"header";s:11:"grid editor";s:8:"typeName";s:8:"READONLY";s:8:"function";s:19:"displayCustomEditor";s:16:"functionIsMethod";s:1:"1";s:8:"isCustom";s:1:"1";}}}'),
(3, '_Menu', '_Menu', 74, NULL),
(4, '_Property', '_Property', 81, 'O:8:"stdClass":1:{s:7:"columns";a:10:{i:0;s:2:"id";i:1;s:4:"name";i:2;s:12:"friendlyName";i:3;s:6:"_class";i:4;s:13:"isSearchField";i:5;s:12:"isGridColumn";i:6;s:10:"isEditable";i:7;s:9:"isVisible";i:8;s:12:"multiElement";i:9;O:8:"stdClass":6:{s:9:"fieldName";s:7:"#custom";s:6:"header";s:8:"typeInfo";s:8:"typeName";s:8:"READONLY";s:8:"function";s:11:"getTypeInfo";s:16:"functionIsMethod";s:1:"1";s:8:"isCustom";s:1:"1";}}}'),
(5, 'Content', 'Content', 7, NULL),
(14, 'InfoForm', 'InfoForm', 114, NULL),
(7, 'Institution', 'Institution', 31, NULL),
(8, 'Member', 'Member', 35, NULL),
(9, 'Navigation', 'Navigation', 43, NULL),
(10, 'Newsletter', 'Newsletter', 51, NULL),
(11, 'Page', 'Page', 55, NULL),
(12, 'Sector', 'Sector', 61, NULL),
(13, 'Partnership', 'Partnership', 110, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `_Menu`
--
DROP TABLE IF EXISTS `_Menu`;
CREATE TABLE IF NOT EXISTS `_Menu` (
`id` int(11) NOT NULL auto_increment,
`parentId` int(11) default NULL,
`title` varchar(128) collate utf8_turkish_ci NOT NULL default '',
`tooltip` varchar(255) collate utf8_turkish_ci default NULL,
`url` varchar(255) collate utf8_turkish_ci NOT NULL default '',
`viewOrder` int(11) NOT NULL default '0',
`icon` varchar(255) collate utf8_turkish_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=17 ;
--
-- Dumping data for table `_Menu`
--
INSERT INTO `_Menu` (`id`, `parentId`, `title`, `tooltip`, `url`, `viewOrder`, `icon`) VALUES
(1, NULL, 'Developer', NULL, '', 1, NULL),
(2, 1, 'Classes', NULL, 'index.php?a=core.edit.edit&class=_Class', 1, NULL),
(3, 1, 'Menu', NULL, 'index.php?a=core.menu.menu', 3, NULL),
(4, 1, 'props', NULL, '?a=core.edit.edit&class=_Property', 2, NULL),
(5, NULL, 'İçerik', NULL, '?a=core.edit.edit&class=Content', 2, NULL),
(7, NULL, 'Page', NULL, '?a=core.edit.edit&class=Page', 1, NULL),
(9, NULL, 'E-bülten', NULL, '', 2, NULL),
(10, 9, 'Üyeler', NULL, '?a=core.edit.edit&class=Member', 1, NULL),
(11, 9, 'XLS çıkışı', NULL, '?a=custom.exportMembers.exportMembers', 3, NULL),
(12, NULL, 'Info Form', NULL, '', 3, NULL),
(13, 12, 'Kurumlar', NULL, '?a=core.edit.edit&class=Institution', 4, NULL),
(14, 12, 'Sektörler', NULL, '?a=core.edit.edit&class=Sector', 1, NULL),
(15, 12, 'Cevaplar', NULL, '?a=core.edit.edit&class=InfoForm', 1, NULL),
(16, 9, 'Ebülten İçerik', NULL, '?a=core.edit.edit&class=Newsletter', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `_Property`
--
DROP TABLE IF EXISTS `_Property`;
CREATE TABLE IF NOT EXISTS `_Property` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(63) collate utf8_turkish_ci NOT NULL default '',
`friendlyName` varchar(63) collate utf8_turkish_ci NOT NULL default '',
`_classId` int(11) NOT NULL default '0',
`viewOrder` int(11) NOT NULL default '0',
`isSearchField` tinyint(1) NOT NULL default '1',
`isGridColumn` tinyint(1) NOT NULL default '1',
`isEditable` tinyint(1) NOT NULL default '1',
`isVisible` tinyint(1) NOT NULL default '1',
`multiElement` enum('select','radio') collate utf8_turkish_ci NOT NULL default 'select',
`typeInfo` text collate utf8_turkish_ci,
PRIMARY KEY (`id`),
KEY `_classId` (`_classId`,`viewOrder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=128 ;
--
-- Dumping data for table `_Property`
--
INSERT INTO `_Property` (`id`, `name`, `friendlyName`, `_classId`, `viewOrder`, `isSearchField`, `isGridColumn`, `isEditable`, `isVisible`, `multiElement`, `typeInfo`) VALUES
(1, 'id', 'id', 1, 0, 1, 1, 1, 0, 'select', NULL),
(2, 'email', 'email', 1, 0, 1, 1, 1, 1, 'select', NULL),
(3, 'password', 'password', 1, 0, 1, 1, 1, 1, 'select', NULL),
(4, 'isDeveloper', 'isDeveloper', 1, 0, 1, 1, 1, 1, 'select', NULL),
(5, 'id', 'id', 5, 0, 1, 1, 1, 0, 'select', NULL),
(6, 'dateTime', 'dateTime', 5, 0, 1, 1, 1, 1, 'select', NULL),
(7, 'title', 'title', 5, 0, 1, 1, 1, 1, 'select', NULL),
(8, 'titleEn', 'titleEn', 5, 0, 1, 1, 1, 1, 'select', NULL),
(10, 'content', 'content', 5, 0, 1, 1, 1, 1, 'select', '{"name":"webContentEditor","data":null}'),
(126, 'message', 'message', 14, 120, 1, 1, 1, 1, 'select', NULL),
(127, 'dateTime', 'dateTime', 14, 5, 1, 1, 1, 1, 'select', NULL),
(11, 'contentEn', 'contentEn', 5, 0, 1, 1, 1, 1, 'select', '{"name":"webContentEditor","data":null}'),
(124, 'sectorId', 'sectorId', 14, 0, 1, 1, 1, 0, 'select', NULL),
(125, 'sector', 'sector', 14, 70, 1, 1, 1, 1, 'select', NULL),
(111, 'listImage', 'listImage', 5, 0, 1, 1, 1, 1, 'select', '{"name":"singleImageEditor","data":{"path":"media","maxW":120,"maxH":120,"crop":"center"}}'),
(14, 'parentNavigationId', 'parentNavigationId', 5, 0, 1, 1, 1, 0, 'select', NULL),
(15, 'parentNavigation', 'parentNavigation', 5, 0, 1, 1, 1, 1, 'select', NULL),
(123, 'institutionUrl', 'institutionUrl', 14, 110, 1, 1, 1, 1, 'select', NULL),
(122, 'institutionType', 'institutionType', 14, 60, 1, 1, 1, 1, 'select', NULL),
(121, 'institutionTypeId', 'institutionTypeId', 14, 0, 1, 1, 1, 0, 'select', NULL),
(120, 'institutionName', 'institutionName', 14, 50, 1, 1, 1, 1, 'select', NULL),
(119, 'country', 'country', 14, 80, 1, 1, 1, 1, 'select', NULL),
(118, 'city', 'city', 14, 90, 1, 1, 1, 1, 'select', NULL),
(117, 'telephone', 'telephone', 14, 100, 1, 1, 1, 1, 'select', NULL),
(116, 'eMail', 'eMail', 14, 30, 1, 1, 1, 1, 'select', NULL),
(115, 'lastName', 'lastName', 14, 20, 1, 1, 1, 1, 'select', NULL),
(114, 'name', 'name', 14, 10, 1, 1, 1, 1, 'select', NULL),
(30, 'id', 'id', 7, 0, 1, 1, 1, 0, 'select', NULL),
(31, 'title', 'title', 7, 0, 1, 1, 1, 1, 'select', NULL),
(32, 'titleEn', 'titleEn', 7, 0, 1, 1, 1, 1, 'select', NULL),
(33, 'infoForms', 'infoForms', 7, 0, 1, 1, 1, 0, 'select', NULL),
(34, 'id', 'id', 8, 0, 1, 1, 1, 0, 'select', NULL),
(35, 'name', 'name', 8, 0, 1, 1, 1, 1, 'select', NULL),
(36, 'lastName', 'lastName', 8, 0, 1, 1, 1, 1, 'select', NULL),
(37, 'eMail', 'eMail', 8, 0, 1, 1, 1, 1, 'select', NULL),
(38, 'confirmed', 'confirmed', 8, 0, 1, 1, 1, 1, 'select', NULL),
(39, 'key', 'key', 8, 0, 1, 1, 1, 0, 'select', NULL),
(40, 'id', 'id', 9, 0, 1, 1, 1, 0, 'select', NULL),
(41, 'parentNavigationId', 'parentNavigationId', 9, 0, 1, 1, 1, 0, 'select', NULL),
(42, 'parentNavigation', 'parentNavigation', 9, 0, 1, 1, 1, 1, 'select', NULL),
(43, 'title', 'title', 9, 0, 1, 1, 1, 1, 'select', NULL),
(44, 'titleEn', 'titleEn', 9, 0, 1, 1, 1, 1, 'select', NULL),
(45, 'viewOrder', 'viewOrder', 9, 0, 1, 1, 1, 1, 'select', NULL),
(46, 'isList', 'isList', 9, 0, 1, 1, 1, 1, 'select', NULL),
(47, 'contents', 'contents', 9, 0, 1, 1, 1, 1, 'select', NULL),
(48, 'navigations', 'navigations', 9, 0, 1, 1, 1, 1, 'select', NULL),
(49, 'id', 'id', 10, 0, 1, 1, 1, 0, 'select', NULL),
(50, 'dateTime', 'dateTime', 10, 0, 1, 1, 1, 1, 'select', NULL),
(51, 'title', 'title', 10, 0, 1, 1, 1, 1, 'select', NULL),
(52, 'content', 'content', 10, 0, 1, 1, 1, 1, 'select', '{"name":"webContentEditor","data":null}'),
(53, 'language', 'language', 10, 0, 1, 1, 1, 1, 'select', NULL),
(54, 'id', 'id', 11, 0, 1, 1, 1, 0, 'select', NULL),
(55, 'title', 'title', 11, 0, 1, 1, 1, 1, 'select', NULL),
(56, 'titleEn', 'titleEn', 11, 0, 1, 1, 1, 1, 'select', NULL),
(57, 'content', 'content', 11, 0, 1, 1, 1, 1, 'select', '{"name":"webContentEditor","data":null}'),
(58, 'contentEn', 'contentEn', 11, 0, 1, 1, 1, 1, 'select', '{"name":"webContentEditor","data":null}'),
(59, 'image', 'image', 11, 0, 1, 1, 1, 0, 'select', '{"name":"singleImageEditor","data":{"path":"media"}}'),
(60, 'id', 'id', 12, 0, 1, 1, 1, 0, 'select', NULL),
(61, 'title', 'title', 12, 0, 1, 1, 1, 1, 'select', NULL),
(62, 'titleEn', 'titleEn', 12, 0, 1, 1, 1, 1, 'select', NULL),
(63, 'infoForms', 'infoForms', 12, 0, 1, 1, 1, 0, 'select', NULL),
(64, 'id', 'id', 2, 0, 1, 1, 1, 0, 'select', NULL),
(65, 'name', 'name', 2, 0, 1, 1, 1, 1, 'select', NULL),
(66, 'friendlyName', 'friendlyName', 2, 0, 1, 1, 1, 1, 'select', NULL),
(67, 'representingPropertyId', 'representingPropertyId', 2, 0, 1, 1, 1, 0, 'select', NULL),
(68, 'representingProperty', 'representingProperty', 2, 0, 1, 1, 1, 1, 'select', NULL),
(69, 'customGrid', 'customGrid', 2, 0, 1, 1, 1, 1, 'select', NULL),
(70, '_Propertys', '_Propertys', 2, 0, 1, 1, 1, 1, 'select', NULL),
(71, 'id', 'id', 3, 0, 1, 1, 1, 0, 'select', NULL),
(72, 'parentId', 'parentId', 3, 0, 1, 1, 1, 0, 'select', NULL),
(73, 'parent', 'parent', 3, 0, 1, 1, 1, 1, 'select', NULL),
(74, 'title', 'title', 3, 0, 1, 1, 1, 1, 'select', NULL),
(75, 'tooltip', 'tooltip', 3, 0, 1, 1, 1, 1, 'select', NULL),
(76, 'url', 'url', 3, 0, 1, 1, 1, 1, 'select', NULL),
(77, 'viewOrder', 'viewOrder', 3, 0, 1, 1, 1, 1, 'select', NULL),
(78, 'icon', 'icon', 3, 0, 1, 1, 1, 1, 'select', NULL),
(79, '_Menus', '_Menus', 3, 0, 1, 1, 1, 1, 'select', NULL),
(80, 'id', 'id', 4, 0, 1, 1, 1, 0, 'select', NULL),
(81, 'name', 'name', 4, 0, 1, 1, 1, 1, 'select', NULL),
(82, 'friendlyName', 'friendlyName', 4, 0, 1, 1, 1, 1, 'select', NULL),
(83, '_classId', '_classId', 4, 0, 1, 1, 1, 0, 'select', NULL),
(84, '_class', '_class', 4, 0, 1, 1, 1, 1, 'select', NULL),
(85, 'viewOrder', 'viewOrder', 4, 0, 1, 1, 1, 1, 'select', NULL),
(86, 'isSearchField', 'isSearchField', 4, 0, 1, 1, 1, 1, 'select', NULL),
(87, 'isGridColumn', 'isGridColumn', 4, 0, 1, 1, 1, 1, 'select', NULL),
(88, 'isEditable', 'isEditable', 4, 0, 1, 1, 1, 1, 'select', NULL),
(89, 'isVisible', 'isVisible', 4, 0, 1, 1, 1, 1, 'select', NULL),
(90, 'multiElement', 'multiElement', 4, 0, 1, 1, 1, 1, 'select', NULL),
(91, 'typeInfo', 'typeInfo', 4, 0, 1, 1, 1, 1, 'select', NULL),
(92, '_Classes', '_Classes', 4, 0, 1, 1, 1, 1, 'select', NULL),
(93, 'slug', 'slug', 5, 0, 1, 1, 1, 1, 'select', NULL),
(94, 'slugEn', 'slugEn', 5, 0, 1, 1, 1, 1, 'select', NULL),
(95, 'slug', 'slug', 9, 0, 1, 1, 1, 1, 'select', NULL),
(96, 'slugEN', 'slugEN', 9, 0, 1, 1, 1, 1, 'select', NULL),
(112, 'id', 'id', 14, 0, 1, 1, 1, 0, 'select', NULL),
(113, 'senderType', 'senderType', 14, 40, 1, 1, 1, 1, 'select', NULL),
(101, 'viewOrder', 'viewOrder', 7, 0, 1, 1, 1, 0, 'select', NULL),
(102, 'viewOrder', 'viewOrder', 12, 0, 1, 1, 1, 0, 'select', NULL),
(103, 'language', 'language', 8, 0, 1, 1, 1, 1, 'select', NULL),
(104, 'id', 'id', 13, 0, 1, 1, 1, 0, 'select', NULL),
(105, 'image', 'image', 13, 0, 1, 1, 1, 1, 'select', NULL),
(106, 'nameTr', 'nameTr', 13, 0, 1, 1, 1, 1, 'select', NULL),
(107, 'nameEn', 'nameEn', 13, 0, 1, 1, 1, 1, 'select', NULL),
(108, 'link', 'link', 13, 0, 1, 1, 1, 1, 'select', NULL),
(109, 'viewOrder', 'viewOrder', 13, 0, 1, 1, 1, 1, 'select', NULL),
(110, 'name', 'name', 13, 0, 1, 1, 1, 1, 'select', NULL);