diff options
Diffstat (limited to 'protected/data/schema.astaf.mysql.sql')
| -rw-r--r-- | protected/data/schema.astaf.mysql.sql | 62 |
1 files changed, 32 insertions, 30 deletions
diff --git a/protected/data/schema.astaf.mysql.sql b/protected/data/schema.astaf.mysql.sql index 8fc9eb3..56138ef 100644 --- a/protected/data/schema.astaf.mysql.sql +++ b/protected/data/schema.astaf.mysql.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Erstellungszeit: 15. Apr 2012 um 16:09 +-- Erstellungszeit: 24. Apr 2012 um 18:40 -- Server Version: 5.5.16 -- PHP-Version: 5.3.8 @@ -11,9 +11,10 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- --- Datenbank: `astaf_yii_dev` +-- Datenbank: `astaf` -- + -- -------------------------------------------------------- -- @@ -24,12 +25,12 @@ DROP TABLE IF EXISTS `angebot`; CREATE TABLE IF NOT EXISTS `angebot` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kategorie_id` int(11) DEFAULT NULL, - `name` varchar(80) DEFAULT NULL, - `beschreibung` text, + `name` varchar(80) CHARACTER SET latin1 DEFAULT NULL, + `beschreibung` text CHARACTER SET latin1, `published` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `angebot_FI_1` (`kategorie_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=247 ; -- -------------------------------------------------------- @@ -42,12 +43,12 @@ CREATE TABLE IF NOT EXISTS `angebot_verein` ( `angebot_id` int(11) NOT NULL, `verein_id` int(11) NOT NULL, `menge` double NOT NULL, - `einheit` varchar(20) CHARACTER SET utf8 NOT NULL, - `preis` float DEFAULT NULL, - `published` int(11) DEFAULT NULL, + `einheit` varchar(20) NOT NULL, + `preis` float NOT NULL, + `published` tinyint(1) DEFAULT NULL, PRIMARY KEY (`angebot_id`,`verein_id`,`menge`,`einheit`), KEY `angebot_verein_FI_2` (`verein_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -58,17 +59,17 @@ CREATE TABLE IF NOT EXISTS `angebot_verein` ( DROP TABLE IF EXISTS `astaf_user`; CREATE TABLE IF NOT EXISTS `astaf_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `username` varchar(128) NOT NULL, - `algorithm` varchar(128) NOT NULL DEFAULT 'sha1', - `salt` varchar(128) NOT NULL, - `password` varchar(128) NOT NULL, + `username` varchar(128) CHARACTER SET latin1 NOT NULL, + `algorithm` varchar(128) CHARACTER SET latin1 NOT NULL DEFAULT 'sha1', + `salt` varchar(128) CHARACTER SET latin1 NOT NULL, + `password` varchar(128) CHARACTER SET latin1 NOT NULL, `created_at` datetime DEFAULT NULL, `last_login` datetime DEFAULT NULL, `is_active` int(11) NOT NULL DEFAULT '1', `is_super_admin` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `sf_guard_user_username_unique` (`username`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ; -- -------------------------------------------------------- @@ -79,13 +80,13 @@ CREATE TABLE IF NOT EXISTS `astaf_user` ( DROP TABLE IF EXISTS `kategorie`; CREATE TABLE IF NOT EXISTS `kategorie` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(100) CHARACTER SET utf8 NOT NULL, - `einheiten` varchar(100) CHARACTER SET utf8 NOT NULL, + `name` varchar(100) NOT NULL, + `einheiten` varchar(100) NOT NULL, `default_menge` double DEFAULT NULL, - `default_einheit` varchar(20) CHARACTER SET utf8 NOT NULL, + `default_einheit` varchar(20) NOT NULL, `published` int(11) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -------------------------------------------------------- @@ -96,12 +97,13 @@ CREATE TABLE IF NOT EXISTS `kategorie` ( DROP TABLE IF EXISTS `standort`; CREATE TABLE IF NOT EXISTS `standort` ( `id` int(11) NOT NULL AUTO_INCREMENT, + `type` enum('Bühne','Stand') NOT NULL DEFAULT 'Stand', `name` varchar(80) DEFAULT NULL, `pos_lat` double DEFAULT NULL, `pos_long` double DEFAULT NULL, `published` int(11) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ; -- -------------------------------------------------------- @@ -113,14 +115,14 @@ DROP TABLE IF EXISTS `termin`; CREATE TABLE IF NOT EXISTS `termin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `verein_id` int(11) DEFAULT NULL, - `titel` varchar(100) DEFAULT NULL, + `titel` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `startzeit` datetime DEFAULT NULL, `endzeit` datetime DEFAULT NULL, - `beschreibung` text, + `beschreibung` text CHARACTER SET latin1, `published` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `termin_FI_1` (`verein_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=222 ; -- -------------------------------------------------------- @@ -131,15 +133,15 @@ CREATE TABLE IF NOT EXISTS `termin` ( DROP TABLE IF EXISTS `verein`; CREATE TABLE IF NOT EXISTS `verein` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, - `url` varchar(255) DEFAULT NULL, - `bild` varchar(100) DEFAULT NULL, - `email` varchar(100) DEFAULT NULL, - `slug` varchar(100) DEFAULT NULL, - `kontaktdaten` text, - `beschreibung` text, + `name` varchar(255) DEFAULT NULL, + `url` varchar(255) CHARACTER SET latin1 DEFAULT NULL, + `bild` varchar(100) CHARACTER SET latin1 DEFAULT NULL, + `email` varchar(100) CHARACTER SET latin1 DEFAULT NULL, + `slug` varchar(100) CHARACTER SET latin1 DEFAULT NULL, + `kontaktdaten` text CHARACTER SET latin1, + `beschreibung` text CHARACTER SET latin1, `standort_id` int(11) DEFAULT NULL, `published` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `verein_FI_1` (`standort_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ; |