diff options
Diffstat (limited to 'backend/index.php')
| -rw-r--r-- | backend/index.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/index.php b/backend/index.php index dc97812..844e0f8 100644 --- a/backend/index.php +++ b/backend/index.php @@ -15,13 +15,13 @@ try { }; /* +*/ $query = $pdo->prepare("DROP TABLE `hitlerclicker`.`stats`"); $query->execute(); $query = $pdo->prepare("DROP TABLE `hitlerclicker`.`users`"); $query->execute(); -*/ -$query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`stats` ( `team` VARCHAR(256) NOT NULL DEFAULT uuid() , `clicks` INT(128) unsigned zerofill NOT NULL DEFAULT '0', PRIMARY KEY (`team`) ) ENGINE = InnoDB;"); +$query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`stats` ( `team` VARCHAR(256) NOT NULL DEFAULT uuid() , `clicks` INT(128) unsigned NOT NULL DEFAULT '0' , `fromanon` INT(128) unsigned NOT NULL DEFAULT '0' , PRIMARY KEY (`team`) ) ENGINE = InnoDB;"); $query->execute(); $query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`users` ( `name` VARCHAR(256) NOT NULL DEFAULT uuid() , `password` VARCHAR(256) NOT NULL , `token` VARCHAR(256) NOT NULL DEFAULT uuid() , `team` VARCHAR(256) NOT NULL DEFAULT 'axis' , `clicks` INT(128) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`name`) ) ENGINE = InnoDB;"); $query->execute(); |