Upgrade From ackerTodo v2.2
---------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:

      ALTER TABLE `tasks` 
      CHANGE `login` `login` VARCHAR( 20 ) NOT NULL,
      CHANGE `assignedby` `assignedby` VARCHAR( 20 ) NOT NULL,
      CHANGE `compby` `compby` VARCHAR( 20 ) NOT NULL; 

3.) After the above, you should be set. Just start using ackerTodo as
      you normally would.

Upgrade From ackerTodo v2.0
---------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:

      ALTER TABLE `tasks` 
      CHANGE `daily` `recurrence` 
      TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

3.) After the above, you should be set. Just start using ackerTodo as
      you normally would.

Upgrade From ackerTodo v1.66
----------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:

      CREATE TABLE `modules` (
         `name` varchar(25) NOT NULL default '',
         `enabled` tinyint(1) NOT NULL default '0',
         `version` float default NULL,
         PRIMARY KEY  (`name`)
      );

3.) After the above, you should be set. Just start using ackerTodo as
      you normally would.

Upgrade From ackerTodo v1.64
----------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:

      ALTER TABLE 'users'
         ADD 'date_format TINYINT(1)
         DEFAULT '0' NOT NULL AFTER 'language';

3.) After the above, you should be set. Just start using ackerTodo as
      you normally would.

Upgrade From ackerTodo v1.62
----------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:
      
      ALTER TABLE 'users' 
         CHANGE 'notification' 'email_notification' TINYINT(1)
         DEFAULT '1' NOT NULL;
      
3.) Run the following against your database:
      
      ALTER TABLE 'users' 
         ADD 'im_notification' TINYINT(1) 
         DEFAULT '1' NOT NULL AFTER 'email_notification';

4.) Run the following against your database:

      ALTER TABLE 'tasks' 
         CHANGE 'date' 'date' TIMESTAMP(14)
         DEFAULT '00000000000000' NOT NULL;

5.) Run the following against your database:
      
      ALTER TABLE 'tasks'  
         CHANGE 'compdate' 'compdate' TIMESTAMP(14)
         DEFAULT '00000000000000' NOT NULL;

5.) After the above, you should be set. Just start using ackerTodo as
      you normally would.

Upgrade From ackerTodo v1.54
----------------------------
1.) Replace all the old files with the new files.

2.) Run the following against your database:
      
      ALTER TABLE `users` ADD `extra` BLOB NOT NULL;

3.) Run the following against your database:
      
      CREATE TABLE `supercat_membership` (
         `supercat_id` int(11) NOT NULL default '0',
         `category_id` int(11) NOT NULL default '0',
         PRIMARY KEY  (`supercat_id`,`category_id`)
      );

4.) Run the following against your database:

      CREATE TABLE `supercats` (
         `id` int(11) unsigned NOT NULL auto_increment,
         `login` varchar(20) NOT NULL default '',
         `name` varchar(255) NOT NULL default '',
         PRIMARY KEY  (`id`)
      );

5.) Now scroll up and do the steps for: Upgrade From ackerTodo v1.62.

