Contents

Openall_time_applet::DB_SCHEMA = {
  "tables" => {
    "Option" => {
      "columns" => [
        {"name" => "id", "type" => "int", "autoincr" => true, "primarykey" => true},
        {"name" => "title", "type" => "varchar"},
        {"name" => "value", "type" => "text"}
      ]
    },
    "Organisation" => {
      "columns" => [
        {"name" => "id", "type" => "int", "autoincr" => true, "primarykey" => true},
        {"name" => "openall_uid", "type" => "int"},
        {"name" => "name", "type" => "varchar"}
      ],
      "indexes" => [
        "openall_uid"
      ]
    },
    "Task" => {
      "columns" => [
        {"name" => "id", "type" => "int", "autoincr" => true, "primarykey" => true},
        {"name" => "openall_uid", "type" => "int"},
        {"name" => "organisation_id", "type" => "int"},
        {"name" => "title", "type" => "varchar"}
      ],
      "indexes" => [
        "openall_uid",
        "organisation_id",
      ]
    },
    "Timelog" => {
      "columns" => [
        {"name" => "id", "type" => "int", "autoincr" => true, "primarykey" => true},
        {"name" => "openall_uid", "type" => "int"},
        {"name" => "task_id", "type" => "int"},
        {"name" => "time", "type" => "int"},
        {"name" => "time_transport", "type" => "int"},
        {"name" => "descr", "type" => "text"},
        {"name" => "sync_need", "type" => "enum", "maxlength" => "'0','1'", "default" => 0},
        {"name" => "sync_last", "type" => "datetime"}
      ],
      "indexes" => [
        "openall_uid",
        "task_id"
      ]
    },
    "Worktime" => {
      "columns" => [
        {"name" => "id", "type" => "int", "autoincr" => true, "primarykey" => true},
        {"name" => "openall_uid", "type" => "int"},
        {"name" => "task_id", "type" => "int"},
        {"name" => "timestamp", "type" => "datetime"},
        {"name" => "worktime", "type" => "int"},
        {"name" => "transporttime", "type" => "int"},
        {"name" => "comment", "type" => "text"}
      ]
    }
  }
}

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
openall_time_applet-0.0.5	conf/db_schema.rb
openall_time_applet-0.0.4	conf/db_schema.rb
openall_time_applet-0.0.3	conf/db_schema.rb