USE internationaliser;
/**
 * tasks, bundles or translation items, units of work that can be assigned.
 */
DROP TABLE IF EXISTS tasks;
CREATE TABLE tasks  (
  /**
   * an id for this task
   */
  uniqueTaskID INTEGER NOT NULL AUTO_INCREMENT,
  /**
   * short name for task to show in columns, unique??
   */
  taskName VARCHAR( 10 ),
  /**
   * Description of what the task entails.
   * Used to select the task from a list.
   * Details are in the taskItemRecords and assignments.
   */
  description VARCHAR( 100 ),
  PRIMARY KEY( uniqueTaskID )
  );