   UNIQUE KEY (userid, matchid)
 );
 
-CREATE TABLE IF NOT EXISTS team (
+CREATE TABLE IF NOT EXISTS teams (
   id INTEGER UNSIGNED NOT NULL,
   longname VARCHAR(255) NOT NULL,
   shortname VARCHAR(255),


INSERT INTO user (id, name, email, password) VALUES (1, 'admin', 'grisuji@gmx.de','21232f297a57a5a743894a0e4a801fc3');

CREATE TABLE IF NOT EXISTS tip (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  userid INTEGER UNSIGNED NOT NULL,
  matchid INTEGER UNSIGNED NOT NULL,

  PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS matchs (
  id INTEGER UNSIGNED NOT NULL,
  league VARCHAR(255) NOT NULL,
  saison VARCHAR(255) NOT NULL,
  groupid INTEGER UNSIGNED NOT NULL,
  date_time DATETIME,
  team1id INTEGER UNSIGNED NOT NULL,
