scrott - The Secure Centralized Robust Online Ticketing Tool

Age	Commit message (Collapse)	Author	Files	Lines
2016-02-07	Fix typeo from 89341dc13fd30bed744e052aa5f82deb4d4a5b93	Malf Furious	1	-1/+1

2016-02-07	Add fields to Issue object	Malf Furious	1	-0/+2
	This adds attributes to an issue: due date (optional datetime) tags (space separated string of words to help categorize issues (again, optional))
2016-02-07	Use only a single object type for log messages	Malf Furious	1	-5/+1
	Eliminate redunancy in the data model by using just one object type to denote 'log' instead of parent object specfic types (eg: log-user, log-group, log-pad, ....). This is a redundancy because the type of the parent can be quired simply by following the log entry's parent ptr and assessing its type value.
2016-01-30	Modify database schema and semantics for user objects	Malf Furious	1	-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-28	Add admin field to user table	Malf Furious	1	-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 settings	M	1	-0/+8

2015-11-20	* Moved the `unread` value of messages out into a new table so that this ↵	M	1	-1/+8
	value can now be user-specific
2015-11-20	+ Declaired types for system log levels. they will be encapsulated in ↵	M	1	-1/+7
	Message-type objects
2015-11-20	+ Defined schema for message table	M	1	-1/+13

2015-11-20	+ Defined schema for extern-user object	M	1	-0/+13

2015-11-19	* Data schema errata	M	1	-0/+7

2015-11-19	+ Defined initial issue object in schema	M	1	-1/+16

2015-11-19	* Refactored stage table into new data model	M	1	-15/+7

2015-11-19	* Refactored pad table into new core data model	M	1	-12/+10

2015-11-19	* Reworked core datamodel -- now using a common main table for holding ALL ↵	M	1	-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 schemas	M	1	-0/+24

2015-11-18	+ Defined group table	M	1	-10/+8

2015-11-18	+ Defined membership association table	M	1	-1/+8

2015-11-18	+ Defined schema for backend users table	M	1	-0/+63
	! Devised an initial concept for Scrott object permissions system