class Knjappserver
  DATABASE_SCHEMA = {
    "tables" => {
      "Log" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "text_value_id", "type" => "bigint"},
          {"name" => "date_saved", "type" => "datetime"},
          {"name" => "get_keys_data_id", "type" => "bigint"},
          {"name" => "get_values_data_id", "type" => "bigint"},
          {"name" => "post_keys_data_id", "type" => "bigint"},
          {"name" => "post_values_data_id", "type" => "bigint"},
          {"name" => "cookie_keys_data_id", "type" => "bigint"},
          {"name" => "cookie_values_data_id", "type" => "bigint"},
          {"name" => "meta_keys_data_id", "type" => "bigint"},
          {"name" => "meta_values_data_id", "type" => "bigint"},
          {"name" => "session_keys_data_id", "type" => "bigint"},
          {"name" => "session_values_data_id", "type" => "bigint"},
          {"name" => "tag_data_id", "type" => "bigint"},
          {"name" => "comment_data_id", "type" => "bigint"}
        ],
        "indexes" => [
          {"name" => "text_value_id", "columns" => ["text_value_id"]},
          {"name" => "tag_data_id", "columns" => ["tag_data_id"]},
          {"name" => "comment_data_id", "columns" => ["comment_data_id"]}
        ]
      },
      "Log_access" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "session_id", "type" => "bigint"},
          {"name" => "date_request", "type" => "datetime"},
          {"name" => "ip_data_id", "type" => "bigint"},
          {"name" => "get_keys_data_id", "type" => "bigint"},
          {"name" => "get_values_data_id", "type" => "bigint"},
          {"name" => "post_keys_data_id", "type" => "bigint"},
          {"name" => "post_values_data_id", "type" => "bigint"},
          {"name" => "cookie_keys_data_id", "type" => "bigint"},
          {"name" => "cookie_values_data_id", "type" => "bigint"},
          {"name" => "meta_keys_data_id", "type" => "bigint"},
          {"name" => "meta_values_data_id", "type" => "bigint"}
        ],
        "indexes" =>  [
          {"name" => "session_id", "columns" => ["session_id"]},
          {"name" => "date_request", "columns" => ["date_request"]}
        ]
      },
      "Log_data" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "id_hash", "type" => "varchar"}
        ],
        "indexes" => [
          {"name" => "id_hash", "columns" => ["id_hash"]}
        ]
      },
      "Log_data_link" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "no", "type" => "int"},
          {"name" => "data_id", "type" => "bigint"},
          {"name" => "value_id", "type" => "bigint"}
        ],
        "indexes" => [
          {"name" => "data_id", "columns" => ["data_id"]},
          {"name" => "value_id", "columns" => ["value_id"]}
        ]
      },
      "Log_data_value" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "value", "type" => "text"}
        ]
      },
      "Log_link" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "log_id", "type" => "bigint"},
          {"name" => "object_class_value_id", "type" => "bigint"},
          {"name" => "object_id", "type" => "bigint"}
        ],
        "indexes" => [
          {"name" => "log_id", "columns" => ["log_id"]},
          {"name" => "object_id", "columns" => ["object_id"]},
          {"name" => "object_class_value_id", "columns" => ["object_class_value_id"]},
          {"name" => "object_lookup", "columns" => ["object_class_value_id", "object_id"]},
          {"name" => "log_lookup", "columns" => ["object_class_value_id", "object_id", "log_id"]}
        ]
      },
      "Session" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "idhash", "type" => "varchar"},
          {"name" => "sess_data", "type" => "text"},
          {"name" => "date_added", "type" => "datetime"},
          {"name" => "date_lastused", "type" => "datetime", "on_created" => proc{|d| d["db"].query("UPDATE Session SET date_lastused = '#{Knj::Datet.new.dbstr}'")}},
          {"name" => "ip", "type" => "varchar", "maxlength" => 15},
          {"name" => "user_agent", "type" => "text"},
          {"name" => "remember", "type" => "enum", "maxlength" => "'0','1'", "default" => 0, "comment" => "If the session should be remembered or not."}
        ],
        "indexes" => [
          {"name" => "date_added", "columns" => ["date_added"]},
          {"name" => "idhash", "columns" => ["idhash"]}
        ],
        "renames" => ["sessions"]
      },
      "Translation" => {
        "columns" => [
          {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
          {"name" => "object_class", "type" => "varchar", "maxlength" => 50},
          {"name" => "object_id", "type" => "bigint"},
          {"name" => "key", "type" => "varchar", "maxlength" => 50},
          {"name" => "locale", "type" => "varchar", "maxlength" => 5},
          {"name" => "value", "type" => "text"}
        ],
        "indexes" => [
          {"name" => "lookup", "columns" => ["object_class", "object_id", "key", "locale"]}
        ],
        "indexes_remove" => {
          "object_class" => true
        }
      }
    }
  }
end