Changeset 347d768 in network-game

Timestamp:

Nov 10, 2014, 1:29:12 AM (10 years ago)

Author:

Dmitry Portnoy <dmp1488@…>

Branches:

master

Children:

426fb84, ace001a

Parents:

7fa452f

Message:

Add time_finished to the gameHistory table, switch the order of blue_score and red_score columns, and fix a foreign key name

File:

• server/dbmod.txt (modified) (1 diff)

server/dbmod.txt

@@ -20 +20 @@
    user_id INT NOT NULL,
    user_team INT NOT NULL,
+   blue_score INT NOT NULL,
    red_score INT NOT NULL,
-   blue_score INT NOT NULL,
+   time_finished INT unsigned NOT NULL,
    PRIMARY KEY (id),
    CONSTRAINT fk_users FOREIGN KEY
-   fki_users (user_id)
+   fk_users (user_id)
    REFERENCES users (id)
    ON DELETE CASCADE