1 files changed, 12 insertions, 0 deletions
diff --git a/mayor-orig/update/pre003042-1-mayor_login.sql b/mayor-orig/update/pre003042-1-mayor_login.sql
new file mode 100644
index 00000000..471b654f
--- /dev/null
+++ b/mayor-orig/update/pre003042-1-mayor_login.sql
@@ -0,0 +1,12 @@
+CREATE TABLE `loginLog_a` (
+  `logId` int(10) unsigned NOT NULL,
+  `policy` varchar(10) NOT NULL DEFAULT 'private',
+  `userAccount` varchar(50) DEFAULT NULL,
+  `ip` varchar(15) DEFAULT NULL,
+  `dt` datetime DEFAULT NULL,
+  `flag` tinyint(3) unsigned DEFAULT NULL
+) ENGINE=ARCHIVE DEFAULT CHARSET=utf8;
+INSERT INTO loginLog_a SELECT * FROM loginLog WHERE dt<CURDATE() - INTERVAL 1 DAY;
+DELETE FROM loginLog WHERE dt<CURDATE() - INTERVAL 1 DAY;
+alter table loginLog ADD INDEX IDX_puf (policy,userAccount,flag);
+alter table loginLog ADD INDEX IDX_pudf (policy,userAccount,dt,flag);