Ferreteria/sql/event notes: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==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....") |
mNo edit summary |
||
| Line 3: | Line 3: | ||
** No record is created if there aren't any notes to record. This allows large text capacity for occasional notes. | ** No record is created if there aren't any notes to record. This allows large text capacity for occasional notes. | ||
==History== | ==History== | ||
* '''2017- | * '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]] | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `event_notes` ( | <mysql>CREATE TABLE `event_notes` ( | ||
Revision as of 22:48, 6 February 2017
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
- 2017-02-06 Adapting the good bits from VbzCart/tables/event log
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>