CLEANUP: moved more statistics into the sortable table

[e-DoKo.git] / create_database.sql

diff --git a/create_database.sql b/create_database.sql
index 339c3371d30f07d0d1efdb03a95635120f38feed..e9577c9dc2fc58ce9dabd5d89e5141207bd73dcd 100644 (file)
--- a/create_database.sql
+++ b/create_database.sql
@@ -1,3 +1,22 @@
+/* Copyright 2006, 2007, 2008, 2009, 2010 Arun Persaud <arun@nubati.net>
+ *
+ *   This file is part of e-DoKo.
+ *
+ *   e-DoKo is free software: you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation, either version 3 of the License, or
+ *   (at your option) any later version.
+ *
+ *   e-DoKo is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with e-DoKo.  If not, see <http://www.gnu.org/licenses/>.
+ *
+ */
+
 -- MySQL dump 10.9
 --
 -- Host: localhost    Database: doko
@@ -244,7 +263,7 @@ CREATE TABLE `Card_Exchange` (
 
 
 /*!40000 ALTER TABLE `Hand_Card` DISABLE KEYS */;
-LOCK TABLES `Hand_Card` WRITE;
+LOCK TABLES `Card_Exchange` WRITE;
 UNLOCK TABLES;
 /*!40000 ALTER TABLE `Hand_Card` ENABLE KEYS */;
 
@@ -465,3 +484,15 @@ create table user_openids (
   user_id int not null,
   index (user_id)
 );
+
+DROP TABLE IF EXISTS `digest_email`;
+create table digest_email (
+  `id` int(11) NOT NULL auto_increment,
+  `email` varchar(255) default null,
+  `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `content` text,
+  UNIQUE KEY `id` (`id`),
+  index (email)
+);
+
+