gm.db

CREATE TABLE notes (id integer primary key not null, uid int, supid int, notiz text, wann text);

CREATE TABLE proddetails (id integer primary key not null, pid tinyint, ekg float, vkg float, offen bool, leerg float, vollg float, bestellg int);

CREATE TABLE prodkat (id integer primary key not null, name char(50), sort tinyint);

CREATE TABLE produkte (id integer primary key not null, name char(50), kat tinyint);

CREATE TABLE users (id integer primary key not null, uname char(20), pass char(20), vname char(20), nname char(20), level int, mail char(50), handy char(20), bday date, job char(50), bar bool, cloth bool, run bool, lsk bool, loan float, male bool, state bool);

INSERT INTO proddetails(id, pid, ekg, vkg, offen, leerg, vollg, bestellg) VALUES ('1', '1', '0,33', '0,33', 'false', '', '', '24');
INSERT INTO proddetails(id, pid, ekg, vkg, offen, leerg, vollg, bestellg) VALUES ('2', '2', '1,0', '0,33', 'true', '', '', '6');
INSERT INTO proddetails(id, pid, ekg, vkg, offen, leerg, vollg, bestellg) VALUES ('3', '3', '0,2', '0,2', 'false', '', '', '24');
INSERT INTO proddetails(id, pid, ekg, vkg, offen, leerg, vollg, bestellg) VALUES ('4', '4', '0,2', '0,2', 'false', '', '', '24');
INSERT INTO prodkat(id, name, sort) VALUES ('1', 'Bier', '1');
INSERT INTO prodkat(id, name, sort) VALUES ('2', 'AFG', '2');
INSERT INTO prodkat(id, name, sort) VALUES ('3', 'Wein', '3');
INSERT INTO prodkat(id, name, sort) VALUES ('4', 'Spirituosen', '4');
INSERT INTO prodkat(id, name, sort) VALUES ('5', 'VK-Flaschen', '5');
INSERT INTO produkte(id, name, kat) VALUES ('1', 'Becks Pils', '1');
INSERT INTO produkte(id, name, kat) VALUES ('2', 'Wachenheimer Bergkloster', '3');
INSERT INTO produkte(id, name, kat) VALUES ('3', 'Coca Cola', '2');
INSERT INTO produkte(id, name, kat) VALUES ('4', 'Fanta', '2');
INSERT INTO users(id, uname, pass, vname, nname, level, mail, handy, bday, job, bar, cloth, run, lsk, loan, male, state) VALUES ('1', 'nalamar', '123456', 'Jan', 'Rothe', '99', '[email protected]', '0173/2758138', '22.06.1982', 'selbstaending', 'true', 'false', 'false', 'false', '8.5', 'true', 'true');
INSERT INTO users(id, uname, pass, vname, nname, level, mail, handy, bday, job, bar, cloth, run, lsk, loan, male, state) VALUES ('2', 'peter', '123456', 'Peter', 'Lustig', '10', '[email protected]', '0173/123456', '22.06.1982', 'selbstaending', 'false', 'true', 'false', 'false', '8.5', 'true', 'true');
INSERT INTO users(id, uname, pass, vname, nname, level, mail, handy, bday, job, bar, cloth, run, lsk, loan, male, state) VALUES ('3', 'Böhme', '123456', 'Nadine', 'Böhme', '10', '[email protected]', '01721234567', '2000-01-01', 'Kellner', 'true', 'false', 'false', 'false', '6.0', 'false', 'true');