set @old_unique_checks=@@unique_checks, unique_checks=0

C:\Users\mknadmin\Desktop\mod153\blumenparadies_pk.sql
April 21, 2010 2:26 PM
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb`;
-- ------------------------------------------------------ Table `mydb`.`tblBestellungspositionen`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblBestellungspositionen` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblBestellungspositionen` (
`idBestellungspositionen` INT NOT NULL ,
`Stueckzahl` INT NULL ,
`Lieferzeitpunkt` DATETIME NULL ,
`Lieferstatus` ENUM('besteht','storniert') NULL ,
`Bestellpreis` DECIMAL(2) NULL ,
`Produktname` VARCHAR(255) NULL ,
`Produktbezeichnung` TEXT NULL ,
PRIMARY KEY (`idBestellungspositionen`) )
ENGINE = InnoDB;
-- ------------------------------------------------------ Table `mydb`.`tblKundendaten`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblKundendaten` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblKundendaten` (
`idKundendaten` INT NOT NULL ,
`Name` VARCHAR(255) NULL ,
`Vorname` VARCHAR(255) NULL ,
`Adresse` VARCHAR(255) NULL ,
`PLZ` INT NULL ,
`Ort` VARCHAR(255) NULL ,
`Email` VARCHAR(255) NULL ,
PRIMARY KEY (`idKundendaten`) )
ENGINE = InnoDB;
-- ------------------------------------------------------ Table `mydb`.`tblInventar`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblInventar` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblInventar` (
`idInventar` INT NOT NULL ,
`Produktname` VARCHAR(255) NULL ,
`Produktbezeichnung` TEXT NULL ,
`Produktpreis` DECIMAL(2) NULL ,
PRIMARY KEY (`idInventar`) )
ENGINE = InnoDB;
-- ------------------------------------------------------ Table `mydb`.`tblWarenkorb`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblWarenkorb` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblWarenkorb` (
`idWarenkorb` INT NOT NULL ,
`SessionID` VARCHAR(45) NULL COMMENT 'MD5 Hash' ,
PRIMARY KEY (`idWarenkorb`) )
ENGINE = InnoDB;
-1-
C:\Users\mknadmin\Desktop\mod153\blumenparadies_pk.sql
April 21, 2010 2:26 PM
-- ------------------------------------------------------ Table `mydb`.`tblWarenpositionen`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblWarenpositionen` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblWarenpositionen` (
`idWarenpositionen` INT NOT NULL ,
PRIMARY KEY (`idWarenpositionen`) )
ENGINE = InnoDB;
-- ------------------------------------------------------ Table `mydb`.`tblBestellung`
-- ----------------------------------------------------DROP TABLE IF EXISTS `mydb`.`tblBestellung` ;
CREATE TABLE IF NOT EXISTS `mydb`.`tblBestellung` (
`idBestellung` INT NOT NULL ,
PRIMARY KEY (`idBestellung`) )
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-2-