| Age | Commit message (Collapse) | Author | Files | Lines | |
|---|---|---|---|---|---|
| 2017-06-04 | schema.sql: Set default value for mesg attachments | Malf Furious | 1 | -1/+1 | |
| Defaulting this field to the empty string since, by default, messages do not have attachments. | |||||
| 2017-06-04 | schema.sql: Rename objtype for messages | Malf Furious | 1 | -1/+1 | |
| Renamed from 'message' to 'mesg', for consistency with other naming conventions. | |||||
| 2017-05-13 | Remove mime-type field from message database schema | Malf Furious | 1 | -2/+1 | |
| Since the df.php script can detect the mime-type of files on disk, I am removing this state from the database. With 'attachName' being the only remaining field pertaining to attachments, I have simply renamed it 'attachment'. | |||||
| 2017-04-08 | Remove NULLs from database schema | Malf Furious | 1 | -14/+14 | |
| To address potential bugs in the application code, I have updated the data definition to forbid NULL values anywhere in the Scrott database. Additionally, the data type for issue due datetimes is updated to varchar since 'datetime' has issues with my desired default value. | |||||
| 2017-01-14 | Reinstate database schema file to working directory | Malf Furious | 1 | -0/+0 | |
| 2017-01-14 | Reset working directory for clean Scrott implementation | Malf Furious | 1 | -135/+174 | |
| 2016-10-22 | Deprecate application code | Malf Furious | 1 | -0/+0 | |
| Setup to perform an iteration of development focused on a simpler implementation and eliminating redundancy in design. | |||||
| 2016-05-30 | Add copyright notice to schema file | Malf Furious | 1 | -4/+14 | |
| 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 | |||||
 |
index : scrott | |
| The Secure Centralized Robust Online Ticketing Tool | malf |
| summaryrefslogtreecommitdiffstats |