<commit_before>-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: localhost    Database: mydb
-- ------------------------------------------------------
-- Server version	5.5.42

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Abonnementer`
--

DROP TABLE IF EXISTS `Abonnementer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Abonnementer` (
  `idOdre` int(11) NOT NULL AUTO_INCREMENT,
  `Navn` varchar(45) NOT NULL,
  `Adresse` varchar(45) NOT NULL,
  `Postnummer` int(11) NOT NULL,
  `By` varchar(45) NOT NULL,
  `Betalt` int(11) NOT NULL DEFAULT '0',
  `TotalPris` decimal(6,2) NOT NULL DEFAULT '0.00',
  `Bruger_idBruger` int(11) NOT NULL,
  PRIMARY KEY (`idOdre`,`Bruger_idBruger`),
  UNIQUE KEY `idOdre_UNIQUE` (`idOdre`),
  KEY `fk_Abonnementer_Bruger1_idx` (`Bruger_idBruger`),
  CONSTRAINT `fk_Abonnementer_Bruger1` FOREIGN KEY (`Bruger_idBruger`) REFERENCES `Bruger` (`idBruger`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Abonnementer`
--

LOCK TABLES `Abonnementer` WRITE;
/*!40000 ALTER TABLE `Abonnementer` DISABLE KEYS */;
/*!40000 ALTER TABLE `Abonnementer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Bruger`
--

DROP TABLE IF EXISTS `Bruger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Bruger` (
  `idBruger` int(11) NOT NULL AUTO_INCREMENT,
  `Navn` varchar(45) NOT NULL,
  `Email` varchar(45) NOT NULL,
  `Adgangskode` varchar(45) NOT NULL,
  `Adresse` varchar(45) NOT NULL,
  `Postnummer` int(11) NOT NULL,
  `By` varchar(45) NOT NULL,
  PRIMARY KEY (`idBruger`),
  UNIQUE KEY `idBruger_UNIQUE` (`idBruger`),
  UNIQUE KEY `Email_UNIQUE` (`Email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Bruger`
--

LOCK TABLES `Bruger` WRITE;
/*!40000 ALTER TABLE `Bruger` DISABLE KEYS */;
INSERT INTO `Bruger` VALUES (1,'<NAME> P?PPP','raller799<EMAIL>','asdfasdf','Alsikemarken 69',2860,'SÃ¸borg'),(3,'<NAME>','<EMAIL>','asdfasdf','Alsikemarken 69',2860,'SÃ¸borg');
/*!40000 ALTER TABLE `Bruger` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Produkter`
--

DROP TABLE IF EXISTS `Produkter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Produkter` (
  `idProdukter` int(11) NOT NULL AUTO_INCREMENT,
  `Pakkenavn` varchar(45) NOT NULL,
  `Billede` varchar(45) DEFAULT NULL,
  `Indhold` varchar(45) NOT NULL,
  `Pris` decimal(6,2) NOT NULL,
  `Abonnementer_idOdre` int(11) NOT NULL,
  PRIMARY KEY (`idProdukter`,`Abonnementer_idOdre`),
  UNIQUE KEY `idProdukter_UNIQUE` (`idProdukter`),
  KEY `fk_Produkter_Abonnementer1_idx` (`Abonnementer_idOdre`),
  CONSTRAINT `fk_Produkter_Abonnementer1` FOREIGN KEY (`Abonnementer_idOdre`) REFERENCES `Abonnementer` (`idOdre`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Produkter`
--

LOCK TABLES `Produkter` WRITE;
/*!40000 ALTER TABLE `Produkter` DISABLE KEYS */;
/*!40000 ALTER TABLE `Produkter` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-03-30 12:53:50<commit_msg>ny db<commit_after>-- MySQL Script generated by MySQL Workbench
-- Fri Mar 31 11:21:44 2017
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

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,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`Bruger`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Bruger` (
  `idBruger` INT NOT NULL AUTO_INCREMENT,
  `Navn` VARCHAR(45) NOT NULL,
  `Email` VARCHAR(45) NOT NULL,
  `Adgangskode` VARCHAR(45) NOT NULL,
  `Adresse` VARCHAR(45) NOT NULL,
  `Postnummer` INT NOT NULL,
  `By` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`idBruger`, `Navn`, `Adresse`, `Postnummer`, `By`),
  UNIQUE INDEX `idBruger_UNIQUE` (`idBruger` ASC),
  UNIQUE INDEX `Email_UNIQUE` (`Email` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Abonnementer`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Abonnementer` (
  `idOdre` INT NOT NULL AUTO_INCREMENT,
  `Betalt` INT NOT NULL DEFAULT 0,
  `TotalPris` DECIMAL(6,2) NOT NULL DEFAULT 0,
  `Bruger_idBruger` INT NOT NULL,
  `Bruger_Navn` VARCHAR(45) NOT NULL,
  `Bruger_Adresse` VARCHAR(45) NOT NULL,
  `Bruger_Postnummer` INT NOT NULL,
  `Bruger_By` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`idOdre`, `Bruger_idBruger`, `Bruger_Navn`, `Bruger_Adresse`, `Bruger_Postnummer`, `Bruger_By`),
  UNIQUE INDEX `idOdre_UNIQUE` (`idOdre` ASC),
  INDEX `fk_Abonnementer_Bruger1_idx` (`Bruger_idBruger` ASC, `Bruger_Navn` ASC, `Bruger_Adresse` ASC, `Bruger_Postnummer` ASC, `Bruger_By` ASC),
  CONSTRAINT `fk_Abonnementer_Bruger1`
    FOREIGN KEY (`Bruger_idBruger` , `Bruger_Navn` , `Bruger_Adresse` , `Bruger_Postnummer` , `Bruger_By`)
    REFERENCES `mydb`.`Bruger` (`idBruger` , `Navn` , `Adresse` , `Postnummer` , `By`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Produkter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Produkter` (
  `idProdukter` INT NOT NULL AUTO_INCREMENT,
  `Pakkenavn` VARCHAR(45) NOT NULL,
  `Billede` VARCHAR(45) NULL,
  `Indhold` VARCHAR(45) NOT NULL,
  `Pris` DECIMAL(6,2) NOT NULL,
  `Abonnementer_idOdre` INT NOT NULL,
  PRIMARY KEY (`idProdukter`, `Abonnementer_idOdre`),
  UNIQUE INDEX `idProdukter_UNIQUE` (`idProdukter` ASC),
  INDEX `fk_Produkter_Abonnementer1_idx` (`Abonnementer_idOdre` ASC),
  CONSTRAINT `fk_Produkter_Abonnementer1`
    FOREIGN KEY (`Abonnementer_idOdre`)
    REFERENCES `mydb`.`Abonnementer` (`idOdre`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
{'fraction_non_alphanumeric': 0.2075689544579859, 'fraction_numerical': 0.042334830019243104, 'mean_word_length': 3.4881980426021877, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4747010', 'n_tokens_mistral': 3294, 'n_tokens_neox': 2943, 'n_words': 663}