Skip to content

Instantly share code, notes, and snippets.

@deuterium7
Last active August 18, 2017 08:12
Show Gist options
  • Save deuterium7/4c6e70c79c0c79b1c654060e43fee024 to your computer and use it in GitHub Desktop.
Save deuterium7/4c6e70c79c0c79b1c654060e43fee024 to your computer and use it in GitHub Desktop.
Zabornyi Alex

Музыкальный портал


Модули:

  • Админка (Admin)
  • Описание исполнетелей (Pages)
  • Форум (Forum)

  • Таблицы БД:

  • users (id, login, password, date_registration, answers[countable])
  • performers (id, name, genres, country, date_create, members_old, members_now, biography)
  • topics (id, performer_id, answers_id)
  • answers (id, user_id, likes[countable | default = "visible: true", -5 = "visible: false"], description)

  • Actions

    Admin:

  • selectAll($tablename)
  • selectOne($tablename, $id)
  • insertOne($tablename, $id, $set)
  • updateOne($tablename, $id, $set)
  • deleteAll($tablename)
  • deleteOne($tablename, $id)
  • Pages:

  • viewPerformers()
  • viewPerform($id)
  • Forum:

  • viewTopics()
  • viewTopic($id)
  • Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment