Ferreteria/sql/event notes

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

About

  • Purpose: base table for notes entered manually (e.g. edit summary) when the event was initiated
    • No record is created if there aren't any notes to record. This allows large text capacity for occasional notes.

History

SQL

<mysql>CREATE TABLE `event_notes` (

   ID_Event     INT  NOT NULL COMMENT "event.ID of parent event",
   Notes        TEXT NOT NULL COMMENT "manually-entered notes",
 PRIMARY KEY (`ID_Event`)

) ENGINE = InnoDB;</mysql>