/griffin-house

A youtube clone

Primary LanguagePHP

Griffin-House

A youtube clone

Database detail

📌 Database name
griffin

Tables name

  • categories
    • id
    • name
  • comments
    • id
    • posted_by
    • video_id
    • response_to
    • body
    • created_at
  • dislikes
    • id
    • username
    • commentid
    • videoid
  • likes
    • id
    • username
    • commentid
    • videoid
  • subscribers
    • id
    • user_to
    • user_from
  • thumbnails
    • id
    • video_id
    • url
    • selected
    • created_at
  • users
    • id
    • username
    • firstname
    • lastname
    • email
    • password
    • created_at
    • profile
  • videos
    • id
    • username
    • title
    • description
    • category
    • privacy
    • url
    • created_at
    • views
    • duration

This is databse detail of our project.
Some tables have created_at field and it's default value is CURRUNT_TIMESTAMP.
Make sure that the tables and fields name must same otherwise you have to refactor each and every querys and other statements.
Otherwise just import database named griffin.sql.