Changeset fb894b4 in network-game for server/dbmod.txt

Timestamp:

Oct 17, 2014, 1:10:56 AM (10 years ago)

Author:

Dmitry Portnoy <dmp1488@…>

Branches:

master

Children:

84754c0

Parents:

81c4e8a

Message:

Change server exe name and clean up the db schema

File:

• server/dbmod.txt (modified) (2 diffs)

server/dbmod.txt

@@ -1 +1 @@
 SQL statements for creating the db tables are stored here
 
-CREATE TABLE users( 
-   id INT NOT NULL AUTO_INCREMENT,
-   wins INT NOT NULL DEFAULT 0,
-   losses INT NOT NULL DEFAULT 0
-);
-
-CREATE TABLE `users` (
+CREATE TABLE users (
    id INT NOT NULL AUTO_INCREMENT,
    name varchar(64) NOT NULL,
@@ -19 +13 @@
    PRIMARY KEY (id),
    UNIQUE KEY name (name)
-}
+);