astaf mysql schema

5 files changed, 145 insertions, 56 deletions

diff --git a/protected/data/devdata.astaf.mysql.sql b/protected/data/devdata.astaf.mysql.sql
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/protected/data/devdata.astaf.mysql.sql
diff --git a/protected/data/schema.astaf.mysql.sql b/protected/data/schema.astaf.mysql.sql
new file mode 100644
index 0000000..8fc9eb3
--- /dev/null
+++ b/protected/data/schema.astaf.mysql.sql
@@ -0,0 +1,145 @@
+-- phpMyAdmin SQL Dump
+-- version 3.4.5
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Erstellungszeit: 15. Apr 2012 um 16:09
+-- Server Version: 5.5.16
+-- PHP-Version: 5.3.8
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00:00";
+
+--
+-- Datenbank: `astaf_yii_dev`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `angebot`
+--
+
+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,
+  `published` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `angebot_FI_1` (`kategorie_id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `angebot_verein`
+--
+
+DROP TABLE IF EXISTS `angebot_verein`;
+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,
+  PRIMARY KEY (`angebot_id`,`verein_id`,`menge`,`einheit`),
+  KEY `angebot_verein_FI_2` (`verein_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `astaf_user`
+--
+
+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,
+  `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 ;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `kategorie`
+--
+
+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,
+  `default_menge` double DEFAULT NULL,
+  `default_einheit` varchar(20) CHARACTER SET utf8 NOT NULL,
+  `published` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `standort`
+--
+
+DROP TABLE IF EXISTS `standort`;
+CREATE TABLE IF NOT EXISTS `standort` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `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 ;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `termin`
+--
+
+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,
+  `startzeit` datetime DEFAULT NULL,
+  `endzeit` datetime DEFAULT NULL,
+  `beschreibung` text,
+  `published` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `termin_FI_1` (`verein_id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `verein`
+--
+
+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,
+  `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 ;
diff --git a/protected/data/schema.mysql.sql b/protected/data/schema.mysql.sql
deleted file mode 100644
index 32788bd..0000000
--- a/protected/data/schema.mysql.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-CREATE TABLE tbl_user (
-    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
-    username VARCHAR(128) NOT NULL,
-    password VARCHAR(128) NOT NULL,
-    email VARCHAR(128) NOT NULL
-);
-
-INSERT INTO tbl_user (username, password, email) VALUES ('test1', 'pass1', 'test1@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test2', 'pass2', 'test2@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test3', 'pass3', 'test3@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test4', 'pass4', 'test4@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test5', 'pass5', 'test5@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test6', 'pass6', 'test6@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test7', 'pass7', 'test7@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test8', 'pass8', 'test8@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test9', 'pass9', 'test9@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test10', 'pass10', 'test10@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test11', 'pass11', 'test11@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test12', 'pass12', 'test12@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test13', 'pass13', 'test13@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test14', 'pass14', 'test14@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test15', 'pass15', 'test15@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test16', 'pass16', 'test16@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test17', 'pass17', 'test17@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test18', 'pass18', 'test18@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test19', 'pass19', 'test19@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test20', 'pass20', 'test20@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test21', 'pass21', 'test21@example.com');
diff --git a/protected/data/schema.sqlite.sql b/protected/data/schema.sqlite.sql
deleted file mode 100644
index e5e0830..0000000
--- a/protected/data/schema.sqlite.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-CREATE TABLE tbl_user (
-    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-    username VARCHAR(128) NOT NULL,
-    password VARCHAR(128) NOT NULL,
-    email VARCHAR(128) NOT NULL
-);
-
-INSERT INTO tbl_user (username, password, email) VALUES ('test1', 'pass1', 'test1@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test2', 'pass2', 'test2@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test3', 'pass3', 'test3@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test4', 'pass4', 'test4@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test5', 'pass5', 'test5@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test6', 'pass6', 'test6@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test7', 'pass7', 'test7@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test8', 'pass8', 'test8@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test9', 'pass9', 'test9@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test10', 'pass10', 'test10@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test11', 'pass11', 'test11@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test12', 'pass12', 'test12@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test13', 'pass13', 'test13@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test14', 'pass14', 'test14@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test15', 'pass15', 'test15@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test16', 'pass16', 'test16@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test17', 'pass17', 'test17@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test18', 'pass18', 'test18@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test19', 'pass19', 'test19@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test20', 'pass20', 'test20@example.com');
-INSERT INTO tbl_user (username, password, email) VALUES ('test21', 'pass21', 'test21@example.com');
diff --git a/protected/data/testdrive.db b/protected/data/testdrive.db
deleted file mode 100644
index 0672b21..0000000
--- a/protected/data/testdrive.db
+++ /dev/null