From e3957bd6dead1564d7c0cccbd45716795efa2008 Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
Date: Sat, 4 Sep 2010 18:01:03 +0200
Subject: DB-Schema/Characters: Store game_event_save.next_start as unix
 timestamp and remove runtime typecasts for this field.

--HG--
branch : trunk
---
 sql/base/characters_database.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/base/characters_database.sql')

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 591e15ff14c..a03fbddb23b 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1213,7 +1213,7 @@ DROP TABLE IF EXISTS `game_event_save`;
 CREATE TABLE `game_event_save` (
   `event_id` mediumint(8) unsigned NOT NULL,
   `state` tinyint(3) unsigned NOT NULL default '1',
-  `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `next_start` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY  (`event_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
-- 
cgit v1.2.3

