update stored schema to reflect what is actually in use.

diff --git a/database.sql b/database.sql
index 800d4bb4d1fdcd9916afe2edaf6d396f030748e9..5a2fe7e139ddb43d2f347bfeb0988e6e9567dddd 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.5.32, for Linux (i686)\r
+-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (i386)\r
 --\r
--- Host: localhost    Database: bncbot\r
+-- Host: localhost    Database: rizonbnc\r
 -- ------------------------------------------------------\r
--- Server version       5.5.32\r
+-- Server version       5.1.73-log\r
 \r
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r
@@ -26,7 +26,9 @@ SET character_set_client = utf8;
 /*!50001 CREATE TABLE `bnc_lastseen` (\r
   `user_id` tinyint NOT NULL,\r
   `event_time` tinyint NOT NULL,\r
-  `event_type` tinyint NOT NULL\r
+  `event_type` tinyint NOT NULL,\r
+  `ip` tinyint NOT NULL,\r
+  `was_last_client` tinyint NOT NULL\r
 ) ENGINE=MyISAM */;\r
 SET character_set_client = @saved_cs_client;\r
 \r
@@ -92,7 +94,7 @@ CREATE TABLE `bncbot_conn_log` (
   `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'The time the connection event was generated.',\r
   `event_type` enum('attach','detach') CHARACTER SET ascii NOT NULL,\r
   `ip` int(10) unsigned NOT NULL COMMENT 'The IP (in long format) that generated the connection event.',\r
-  `was_last_client` bit(1) NOT NULL DEFAULT 0 COMMENT 'Whether or not this detach was the user''s last client. This field has no bearing on attach events.',\r
+  `was_last_client` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Whether or not this detach was the user''s last client. This field has no bearing on attach events.',\r
   KEY `user_id` (`user_id`),\r
   KEY `ip` (`ip`),\r
   KEY `user_id_time` (`user_id`,`event_time`)\r
@@ -211,12 +213,12 @@ CREATE TABLE `bncbot_users` (
 /*!50001 SET @saved_cs_client          = @@character_set_client */;\r
 /*!50001 SET @saved_cs_results         = @@character_set_results */;\r
 /*!50001 SET @saved_col_connection     = @@collation_connection */;\r
-/*!50001 SET character_set_client      = utf8 */;\r
-/*!50001 SET character_set_results     = utf8 */;\r
-/*!50001 SET collation_connection      = utf8_general_ci */;\r
+/*!50001 SET character_set_client      = latin1 */;\r
+/*!50001 SET character_set_results     = latin1 */;\r
+/*!50001 SET collation_connection      = latin1_swedish_ci */;\r
 /*!50001 CREATE ALGORITHM=UNDEFINED */\r
-/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */\r
-/*!50001 VIEW `bnc_lastseen` AS select `a`.`user_id` AS `user_id`,`a`.`event_time` AS `event_time`,`b`.`event_type` AS `event_type` from (`bnc_user_last_conn_event_time` `a` left join `bncbot_conn_log` `b` on(((`b`.`user_id` = `a`.`user_id`) and (`b`.`event_time` = `a`.`event_time`)))) */;\r
+/*!50013 DEFINER=`rizonbnc`@`localhost` SQL SECURITY DEFINER */\r
+/*!50001 VIEW `bnc_lastseen` AS select `a`.`user_id` AS `user_id`,`a`.`event_time` AS `event_time`,`b`.`event_type` AS `event_type`,`b`.`ip` AS `ip`,`b`.`was_last_client` AS `was_last_client` from (`bnc_user_last_conn_event_time` `a` left join `bncbot_conn_log` `b` on(((`b`.`user_id` = `a`.`user_id`) and (`b`.`event_time` = `a`.`event_time`)))) */;\r
 /*!50001 SET character_set_client      = @saved_cs_client */;\r
 /*!50001 SET character_set_results     = @saved_cs_results */;\r
 /*!50001 SET collation_connection      = @saved_col_connection */;\r
@@ -234,7 +236,7 @@ CREATE TABLE `bncbot_users` (
 /*!50001 SET character_set_results     = utf8 */;\r
 /*!50001 SET collation_connection      = utf8_general_ci */;\r
 /*!50001 CREATE ALGORITHM=UNDEFINED */\r
-/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */\r
+/*!50013 DEFINER=`rizonbnc`@`localhost` SQL SECURITY DEFINER */\r
 /*!50001 VIEW `bnc_user_last_conn_event_time` AS select `bncbot_conn_log`.`user_id` AS `user_id`,max(`bncbot_conn_log`.`event_time`) AS `event_time` from `bncbot_conn_log` group by `bncbot_conn_log`.`user_id` */;\r
 /*!50001 SET character_set_client      = @saved_cs_client */;\r
 /*!50001 SET character_set_results     = @saved_cs_results */;\r
@@ -249,4 +251,4 @@ CREATE TABLE `bncbot_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\r
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\r
 \r
--- Dump completed on 2013-10-24  1:24:51
\ No newline at end of file
+-- Dump completed on 2014-10-20 19:26:32
\ No newline at end of file