Added a new database format and sqlite support. Also moved db-convert to a module.

1 files changed, 61 insertions, 16 deletions

diff --git a/data/example.conf b/data/example.conf
index b9a37a275..b29e56280 100644
--- a/data/example.conf
+++ b/data/example.conf
@@ -1032,11 +1032,29 @@ dns
  */
 
 /*
- * db_plain
+ * [DEPRECATED] db_old
  *
- * This is the default flatfile database format.
+ * This is the old binary database format from late Anope 1.7.x, Anope 1.8.x, and
+ * early Anope 1.9.x. This module only loads these databases, and will NOT save them.
+ * You should only use this to upgrade old databases to a newer database format by loading
+ * other database modules in addition to this one, which will be used when saving databases.
+ */
+#module { name = "db_old" }
+db_old
+{
+	/*
+	 * This is the encryption type used by the databases. This must be set correctly or
+	 * your passwords will not work. Valid options are: md5, oldmd5, sha1, and plain.
+	 */
+	#hash = "md5"
+}
+
+/*
+ * [DEPRECATED] db_plain
+ *
+ * This is the flatfile database format from Anope-1.9.2 to Anope-1.9.5.
  */
-module { name = "db_plain" }
+#module { name = "db_plain" }
 db_plain
 {
 	/*
@@ -1046,25 +1064,52 @@ db_plain
 }
 
 /*
- * db_mysql and db_mysql_live
+ * db_flatfile
+ *
+ * This is the default flatfile database format.
+ */
+module { name = "db_flatfile" }
+db_flatfile
+{
+	/*
+	 * The database name db_flatfile should use
+	 */
+	database = "anope.db"
+}
+
+/*
+ * db_sql
+ *
+ * This module allows saving and loading databases using one of the SQL engines.
+ */
+#module { name = "db_sql" }
+db_sql
+{
+	/*
+	 * The SQL service db_sql should use, these are configured in modules.conf.
+	 * For MySQL, this should probably be mysql/main.
+	 */
+	engine = "sqlite/main"
+}
+
+/*
+ * db_sql_live_read, db_sql_live_write
  *
- * Enables (live) MySQL support. 
+ * Enables (live) SQL support. 
  *
- * The db_mysql_live module is an extension to db_mysql, and should only be used if
- * db_mysql is being used. This module pulls data in real time from SQL as it is
- * requested by the core as a result of someone executing commands.
+ * The db_sql_live modules are an extension to db_sql, and should only be used if
+ * db_sql is being used.
  *
- * This effectively allows you to edit your database and have it be immediately
- * reflected back in Anope.
+ * The db_sql_live_read module pulls data in real time from
+ * SQL as it is needed by the core.
+ * At this time this three main tables: ChannelInfo, NickAlias, and NickCore.
  *
- * At this time db_mysql_live only supports pulling data in real time from the three
- * main tables: anope_cs_info, anope_ns_alias, and anope_ns_core.
+ * The db_sql_live_write module writes data to SQL in real time as it is modified by
+ * the core.
  *
- * db_mysql provides the command operserv/sqlsync, which is used for importing other database
- * methods into MySQL.
  */
-#module { name = "db_mysql" }
-#module { name = "db_mysql_live" }
+#module { name = "db_sql_live_read" }
+#module { name = "db_sql_live_write" }
 
 /*
  * [REQUIRED] Encryption modules.