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.