Thank you guys for this, it works like a charm, very good job!.
merali780: I have actually implemented your version cause I like the BD aproach better. Looking at the changes I see what it seems like an error to me:
I have followed your 'Read me.txt' and point number 3 says:
3) ALTER TABLE ost_config ADD COLUMN default_sec_state_id int(10);
Looking at the 'ost_config' table I see this:
mysql> SELECT * FROM ost_config;
+----+-----------+-------------------------+-------+---------------------+----------------------+
| id | namespace | key | value | updated | default_sec_state_id |
+----+-----------+-------------------------+-------+---------------------+----------------------+
| 1 | core | isonline | 1 | 2013-11-04 17 | NULL |
| 2 | core | enable_daylight_saving | 1 | 2013-11-04 17 | NULL |
| 3 | core | staff_ip_binding | 1 | 2013-11-04 17 | NULL |
| 4 | core | staff_max_logins | 6 | 2013-11-04 17 | NULL |
| 5 | core | staff_login_timeout | 2 | 2013-11-04 17 | NULL |
| 6 | core | staff_session_timeout | 200 | 2013-11-04 17 | NULL |
| 95 | core | landing_page_id | 3 | 2013-11-04 17 | NULL |
| 96 | core | offline_page_id | 1 | 2013-11-04 17 | NULL |
| 97 | core | thank-you_page_id | 2 | 2013-11-04 17 | NULL |
+----+-----------+-------------------------+-------+---------------------+----------------------+
I think you wanted to create a new entry in the table, not a new column and therefore point number 3 should read something like:
INSERT INTO ost_config (namespace,key,value) VALUES ('core','default_sec_state_id', '1' );
Am I right in my assumption?
Cheers!,
Fred.