    <h3>/home/bparcsg/public_html/new/install/sql_dump/installation_new.sql düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/new/install/sql_dump/installation_new.sql">
        <textarea name="content" style="width:100%;height:400px;">DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;calendar`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(10) unsigned NOT NULL DEFAULT '0',
  `event_date` date NULL DEFAULT NULL,
  `event_time` time NOT NULL,
  `slot` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 - initial, 0 - middle',
  `unique_key` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `notification_sent` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;events`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;events` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `category_id` int(10) NOT NULL DEFAULT '0',
  `location_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(70) CHARACTER SET utf8 NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8 NOT NULL,
  `participant_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `locations_id` (`location_id`),
  KEY `participant_id` (`participant_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;events_categories`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;events_categories` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `color` varchar(7) CHARACTER SET utf8 NOT NULL DEFAULT '#000000',
  `duration` varchar(3) CHARACTER SET latin1 NOT NULL,
  `show_in_filter` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `duration` (`duration`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;events_locations`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;events_locations` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `show_in_filter` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;events_participants`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;events_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(10) NOT NULL DEFAULT '0',
  `participant_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`),
  KEY `participant_id` (`participant_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

DROP TABLE IF EXISTS `&lt;DB_PREFIX&gt;participants`;
CREATE TABLE IF NOT EXISTS `&lt;DB_PREFIX&gt;participants` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/new/install/sql_dump">← Geri</a>