diff options
author | Arun Persaud <arun@nubati.net> | 2008-03-11 22:21:09 -0700 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2008-03-11 22:21:09 -0700 |
commit | 3eb71d1ca10d4dc4b06ef84eaa410862ce8d7df9 (patch) | |
tree | 38c8b54eedd2f71864c20faa2d4403511f8eba4d /create_database.sql | |
parent | cdee8a3e86f57ac0ace7fad8612b0b809b9d08a4 (diff) | |
download | e-DoKo-3eb71d1ca10d4dc4b06ef84eaa410862ce8d7df9.tar.gz e-DoKo-3eb71d1ca10d4dc4b06ef84eaa410862ce8d7df9.tar.bz2 e-DoKo-3eb71d1ca10d4dc4b06ef84eaa410862ce8d7df9.zip |
NEW FEATURE: Ability to add personal notes for each game
In case a player is involed in too many games it can get quite confusing with
whom your playing, etc. so now the player can add notes on the side that only
show up on his/her screen.
Signed-off-by: Arun Persaud <arun@nubati.net>
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql index e863f53..4c74191 100644 --- a/create_database.sql +++ b/create_database.sql @@ -63,6 +63,30 @@ UNLOCK TABLES; /*!40000 ALTER TABLE `Comment` ENABLE KEYS */; -- +-- Table structure for table `Notes` +-- + +DROP TABLE IF EXISTS `Notes`; +CREATE TABLE `Notes` ( + `mod_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `create_date` timestamp NOT NULL default '0000-00-00 00:00:00', + `id` int(11) NOT NULL auto_increment, + `user_id` int(11) default NULL, + `game_id` int(11) default NULL, + `comment` text, + UNIQUE KEY `id` (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `Notes` +-- + +/*!40000 ALTER TABLE `Notes` DISABLE KEYS */; +LOCK TABLES `Notes` WRITE; +UNLOCK TABLES; +/*!40000 ALTER TABLE `Notes` ENABLE KEYS */; + +-- -- Table structure for table `Game` -- |