Add db_sql:prefix allow prefixing all anope tables similarly, and changed db_sql to update the databases incrementally instead of one big flush

1 files changed, 9 insertions, 4 deletions

diff --git a/data/example.conf b/data/example.conf
index e27067e9a..3b8fc6628 100644
--- a/data/example.conf
+++ b/data/example.conf
@@ -1091,11 +1091,10 @@ db_flatfile
  * db_sql
  *
  * This module allows saving and loading databases using one of the SQL engines.
- * This module does not use any real time reading or writing to SQL. Changes to
- * the SQL tables not done by Anope will have no effect and will be overwritten.
+ * This module loads the databases once on startup, then incrementally updates
+ * objects in the database as they are changed within Anope in real time. Changes
+ * to the SQL tables not done by Anope will have no effect and will be overwritten.
  *
- * WARNING: This module will delete every table in the database it uses. Be sure
- * to put Anope in its own separate database.
  */
 #module { name = "db_sql" }
 
@@ -1116,6 +1115,12 @@ db_sql
 	 * For MySQL, this should probably be mysql/main.
 	 */
 	engine = "sqlite/main"
+
+	/*
+	 * An optional prefix to prepended to the name of each created table.
+	 * Do not use the same prefix for other programs.
+	 */
+	#prefix = "anope_db_"
 }
 
 /*