From 3eb71d1ca10d4dc4b06ef84eaa410862ce8d7df9 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Tue, 11 Mar 2008 22:21:09 -0700 Subject: 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 --- create_database.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'create_database.sql') diff --git a/create_database.sql b/create_database.sql index e863f53..4c74191 100644 --- a/create_database.sql +++ b/create_database.sql @@ -62,6 +62,30 @@ LOCK TABLES `Comment` WRITE; 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` -- -- cgit v1.2.3-18-g5258