| -- Upgrade: schema_version 10 to 11 |
| -- |
| |
| ALTER TABLE accounts ADD use_flash_clipboard CHAR(1); |
| UPDATE accounts SET use_flash_clipboard = 'Y'; |
| ALTER TABLE accounts ALTER COLUMN use_flash_clipboard SET DEFAULT 'N'; |
| ALTER TABLE accounts ALTER COLUMN use_flash_clipboard SET NOT NULL; |
| |
| ALTER TABLE accounts ADD maximum_page_size SMALLINT; |
| UPDATE accounts SET maximum_page_size = 25; |
| ALTER TABLE accounts ALTER COLUMN maximum_page_size SET DEFAULT 0; |
| ALTER TABLE accounts ALTER COLUMN maximum_page_size SET NOT NULL; |
| |
| UPDATE schema_version SET version_nbr = 11; |