Regarding commit 436 - new settings.ordering attribute

[Cosmin Mendrea]

Hi, guys & girls!

I've added an attribute called ordering to table settings. If you were up to date, just run the following query to add the new attribute & set the correct ordering values:

ALTER TABLE `settings` ADD COLUMN `ordering` INTEGER UNSIGNED NOT NULL AFTER `value`;

set @ordering := 0;
update settings set ordering = @ordering := @ordering + 1 where category_id = 1;

set @ordering := 0;
update settings set ordering = @ordering := @ordering + 1 where category_id = 2;

set @ordering := 0;
update settings set ordering = @ordering := @ordering + 1 where category_id = 3;

set @ordering := 0;
update settings set ordering = @ordering := @ordering + 1 where category_id = 4;

set @ordering := 0;
update settings set ordering = @ordering := @ordering + 1 where category_id = 5;

update settings set ordering = 7 where name = "report_post_after";
update settings set ordering = 8 where name = "post_notify_on";
update settings set ordering = 4 where name = "captcha_enable_on_post_page";
update settings set ordering = 5 where name = "captcha_enable_on_apply_page";
update settings set ordering = 6 where name = "captcha_enable_on_contact_page";

Cosmin

[Filip Chereches-Tosa]

Hi Cosmin,

will this ordering be available in the default .sql?

---
Filip Cherecheș-Toșa

Making things happen
filipcte.com

[Cosmin Mendrea]

Hi!

Sure, it's already in SVN, in this revision ;) I've sent these SQL statements so that you can upgrade your existing test database without the need to create a new one and import the entire jobberbase.sql file

Cosmin