summaryrefslogtreecommitdiffstats
path: root/schema.sql (follow)
AgeCommit message (Collapse)AuthorFilesLines
2016-01-30Modify database schema and semantics for user objectsMalf Furious1-2/+1
When user objects are initially created they need to hold a NULL owner value (since users are self-owning objects and prior to db insertion their own guid is not known). Also, the timeUpdated field will no longer hold special meaning for user objects and is now going to be treated as consistent with the rest of the data model.
2016-01-28Add admin field to user tableMalf Furious1-0/+1
User accounts now have a field to denote whether they are site administrators. The first account created during app initial configuration is an admin automatically.
2015-11-20+ Defined setting table for system-wide administrator settingsM1-0/+8
2015-11-20* Moved the `unread` value of messages out into a new table so that this ↵M1-1/+8
value can now be user-specific
2015-11-20+ Declaired types for system log levels. they will be encapsulated in ↵M1-1/+7
Message-type objects
2015-11-20+ Defined schema for message tableM1-1/+13
2015-11-20+ Defined schema for extern-user objectM1-0/+13
2015-11-19* Data schema errataM1-0/+7
2015-11-19+ Defined initial issue object in schemaM1-1/+16
2015-11-19* Refactored stage table into new data modelM1-15/+7
2015-11-19* Refactored pad table into new core data modelM1-12/+10
2015-11-19* Reworked core datamodel -- now using a common main table for holding ALL ↵M1-24/+30
objects (and their common attributes). Additional, supplemental tables may be employed to maintain data attributes which are specific to a given object type
2015-11-18* Draft definitions for pad and stage schemasM1-0/+24
2015-11-18+ Defined group tableM1-10/+8
2015-11-18+ Defined membership association tableM1-1/+8
2015-11-18+ Defined schema for backend users tableM1-0/+63
! Devised an initial concept for Scrott object permissions system