anon clicks

- changed plans and simply added a variable called "fromanon" to each
  team that tracks anonymous clicks

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();