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 )

  );