SOM- Society & Organizations & Management

istanbul eu culture

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);
  • CORNERS Caucasus Project Started

    Intercult organises the CORNERS Caucasus Xpedition 27 September to 13 October 2011. 30 artists, researchers and cultural producers, from 9 European countries, travel by bus from Hopa (Turkey), through Georgia and Azerbaijan, to meet people...

    read more

  • Come together under SOM

    SOM was established by me and my partner Selen Akçalı.  Our goal is not only be a consulting company. We are planning to create projects which will bring social welfare to our society. Our wish is to create a group for interested sponsors ...

    read more

  • SOM in Exodos Festival of Contemporary Performing Arts

    Exodos Festival for Contemporary Performing Arts will take place on April 20-24 Nisan 2011 in the city of Ljublijana in Slovenia. The festival will also host the 6th Balkan Dance Platform. SOM and Contemporary Performing Arts Initiative wi...

    read more

  • SOM participates in artists meeting in Umeå

    On 24-27 February 2011, the Swedish Art and Culture organization, Intercult, gathers artists and international project “Corners” partners and for a meeting in Umeå. Umeå will be the European Capital of Culture 2014. The programme for Umeå ...

    read more

  • Istanbul Development Agency First Call Opened

    The Istanbul Development Agency launched its first call. The Agency opened twp specific calls targeting creative industries. One of the calls is targeting non-profit organizations and other one profit organizations. The ultimate aim of the ...

    read more