Skip to content

Instantly share code, notes, and snippets.

@dapi

dapi/epg.rb

Created July 22, 2020 06:30
Show Gist options
  • Save dapi/e09b5e2267714317a11112edb66989b2 to your computer and use it in GitHub Desktop.
Save dapi/e09b5e2267714317a11112edb66989b2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
epg.rb
create_table "epg", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
t.timestamp "timestart"
t.timestamp "timestop"
t.string "title", limit: 256
t.text "desc"
t.integer "epg_id"
t.date "date"
t.boolean "cdnvideo", default: false
t.integer "rating", limit: 2
t.integer "director_id"
t.integer "year", limit: 2
t.string "time_zone", default: "UTC+03:00", null: false
t.index ["date"], name: "date"
t.index ["epg_id", "timestart", "timestop"], name: "epg_tst_tsp"
t.index ["epg_id"], name: "epg_id"
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment