- Database setup

- Database schema
- Database dev data
- config for new database setup
- Update in AngebotVerein
- Update in Speis&Trank
- Update in Verein
- Update in Kategorie

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 ;