table("ticket", ["signed" => false, "collation" => "utf8mb4_general_ci"]) ->addColumn("location_id", "integer", ["signed" => false]) ->addColumn("creator_user_id", "integer", ["signed" => false]) ->addColumn("assigned_user_id", "integer", ["signed" => false, "null" => true]) ->addColumn("subject", "string") ->addColumn("contact_name", "string", ["null" => true]) ->addColumn("status", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "default" => "0"]) ->addColumn("priority", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "default" => "2"]) ->addColumn("rating", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "null" => true]) ->addColumn("dts_due", "datetime", ["null" => true]) ->addColumn("dts_created", "datetime") ->addColumn("dts_updated", "datetime", ["null" => true]) ->addColumn("dts_deleted", "datetime", ["null" => true]) ->addForeignKey("location_id", "location", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->addForeignKey("creator_user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->addForeignKey("assigned_user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->create(); } }