/* Opret statistik tabel */
DROP TABLE IF EXISTS `statistiktabel`;
CREATE TABLE statistiktabel (
    ID INT(20) NOT NULL,
    varenummer VARCHAR(100) NOT NULL,
    profit INT(10),
    Antalsolgt INT(20) NOT NULL,
    samletprofit INT(20),
    PRIMARY KEY (ID),
    CONSTRAINT fk_Perstatistiktabel FOREIGN KEY (varenummer) REFERENCES varetabel(varenummer)
)   ENGINE = innoDB;


____________________________________________________________________________________________________________________

/* Opret vare tabel */
DROP TABLE IF EXISTS `varetabel`;
CREATE TABLE varetabel (
    varenummer VARCHAR(100) NOT NULL PRIMARY KEY,
    varegruppe INT(20) NOT NULL,
    varenavn VARCHAR(50) NOT NULL,
    stk INT(5) NOT NULL



) ENGINE = innoDB;

/* Indsæt værdier i vare tabel */
INSERT INTO
    varetabel (varenummer, varegruppe, varenavn, stk)
VALUES
        ('80800721-0001-4',100,'SPEEDO END+ SBRF AM, BLACK 4',17),
        ('80800721-0001-6',100,'SPEEDO END+ SBRF AM, BLACK 6',10),
        ('80800721-0001-7',100,'SPEEDO END+ SBRF AM, BLACK 7',20),
        ('80800721-0001-8',100,'SPEEDO END+ SBRF AM, BLACK 8',50),
        ('80800726-0001-36',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 36',40),
        ('80800726-0001-38',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 38',22),
        ('80800726-0001-40',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 40',21),
        ('80800726-0001-42',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 42',7),
        ('80800726-0001-44',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 44',40),
        ('80800726-0001-46',100,'SPEEDO END+ MDLT 1PCE AF, BLACK 46',23),
        ('80800728-0001-116',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 116',67),
        ('80800728-0001-128',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 128',12),
        ('80800728-0001-140',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 140',6),
        ('80800728-0001-152',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 152',4),
        ('80800728-0001-164',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 164',3),
        ('80800728-0001-176',100,'SPEEDO END+ MDLT 1PCE JF, BLACK 176',2)