X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=blobdiff_plain;f=maintenance%2Ftables.sql;h=254ed3875764d7af9992f3f5c125c08a9db99663;hp=dac222ffcd931145b1cc24a3b942ed50e84c26f0;hb=c05b8b7c473a7dd9c832f91366c45cb8a35c2df2;hpb=2b14cc0096de48b4863ea7daee55951701f6dc99 diff --git a/maintenance/tables.sql b/maintenance/tables.sql index dac222ffcd..254ed38757 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -228,7 +228,7 @@ CREATE INDEX /*i*/un_user_ip ON /*_*/user_newtalk (user_ip); -- User preferences and perhaps other fun stuff. :) -- Replaces the old user.user_options blob, with a couple nice properties: -- --- 1) We only store non-default settings, so changes to the defauls +-- 1) We only store non-default settings, so changes to the defaults -- are now reflected for everybody, not just new accounts. -- 2) We can more easily do bulk lookups, statistics, or modifications of -- saved options since it's a sane table structure. @@ -1683,7 +1683,7 @@ CREATE TABLE /*_*/job ( -- Any other parameters to the command -- Stored as a PHP serialized array, or an empty string if there are no parameters - job_params blob NOT NULL, + job_params mediumblob NOT NULL, -- Random, non-unique, number used for job acquisition (for lock concurrency) job_random integer unsigned NOT NULL default 0,