Revision: 4035
Author: btongminh
Date: 2007-08-13 19:10:17 +0000 (Mon, 13 Aug 2007)
Log Message:
-----------
SQL table layout.
Modified Paths:
--------------
trunk/pywikipedia/delinker.txt
Modified: trunk/pywikipedia/delinker.txt
===================================================================
--- trunk/pywikipedia/delinker.txt 2007-08-13 15:05:15 UTC (rev 4034)
+++ trunk/pywikipedia/delinker.txt 2007-08-13 19:10:17 UTC (rev 4035)
@@ -64,7 +64,7 @@
First setup the dictionary ''CommonsDelinker'', by adding to the config:
CommonsDelinker = {}
-==== General settings ====
+=== General settings ===
* ''timeout = 60'': A general timeout, used for fetching the log and
other
timeouts. Set to 60 for medium sized wikis, such as English Wikipedia,
and 60-120 for smaller wikis such as German Wikipedia. Note that during
@@ -88,7 +88,7 @@
GLOBALLY WITHOUT CONSULTING BRYAN AND SIEBRAND. Thank you.
* ''no_sysop = True'': Disable delinking as sysop.
-==== Delinker settings ====
+=== Delinker settings ===
Those variables only need to be set if the delinker is enabled.
* ''delink_wait = 600'': The time to wait after deletion before the image
is
delinked.
@@ -96,7 +96,7 @@
summary, the file is not delinked.
* ''summary_cache = 3600'': Time before on-wiki settings are updated.
-==== Replacer settings ====
+=== Replacer settings ===
Those variables only need to be set if the replacer is enabled.
* ''replace_template = "replace image"'': The template for to
command
replacement.
@@ -107,7 +107,7 @@
* ''disallowed_replacements = [(r'\.png$', r'\.svg$')]'':
List of regular expressions
of refused replacements.
-==== SQL settings ====
+=== SQL settings ===
* ''sql_engine = "mysql"'': Database engine to use. Currently
supported:
MySQL. Support for sqlite3 is planned. The Global delinker requires MySQL.
* ''sql_config = {\
@@ -121,6 +121,31 @@
* ''replacer_table = "database.replacer"'': The database.table
for the
replacer. Only required if the replacer is activated.
+==== SQL table layout ====
+<code lang="sql">
+CREATE TABLE delinker (
+ timestamp CHAR(14),
+ img VARBINARY(255),
+ wiki VARBINARY(255),
+ page_title VARBINARY(255),
+ namespace INT,
+ status ENUM('ok', 'skipped', 'failed'),
+ newimg VARBINARY(255)
+);
+CREATE TABLE replacer (
+ id INT NOT NULL AUTO_INCREMENT,
+ timestamp VARBINARY(14),
+ old_image VARBINARY(255),
+ new_image VARBINARY(255),
+ status ENUM('pending', 'ok', 'refused', 'done'),
+ user VARBINARY(255),
+ comment VARBINARY(255),
+
+ PRIMARY KEY(id),
+ INDEX(status)
+);
+</code>
+
==== Edit and debugging settings ====
* ''save_diff = False'': Save all changes to a diff. Create a directory
diff/
before running.