Core/Instances: Implemented hourly instance limit: players are limited to entering 5 instances per hour (account wide limit)

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/2011_01_24_0_characters_account_instance_times.sql b/sql/updates/2011_01_24_0_characters_account_instance_times.sql
new file mode 100644
index 00000000000..72cde260a51
--- /dev/null
+++ b/sql/updates/2011_01_24_0_characters_account_instance_times.sql
@@ -0,0 +1,10 @@
+--
+-- Table structure for table `account_instance_times`
+--
+DROP TABLE IF EXISTS `account_instance_times`;
+CREATE TABLE `account_instance_times` (
+  `accountId` int(10) unsigned NOT NULL,
+  `instanceId` int(10) unsigned NOT NULL DEFAULT '0',
+  `releaseTime` bigint(20) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`accountId`,`instanceId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;