11 Commits (mike/prizebot)

Author	SHA1	Message	Date
Mike Lang	e00e716927	schema: Require role.email always be lowercase ... Otherwise it will silently fail to match in the application.	3 weeks ago
Mike Lang	a65cc6dcfe	schema: Fix check constraints on template crop/location	3 weeks ago
Mike Lang	befe9448cb	Fix trailing comma in schema	3 weeks ago
Christopher Usher	e0fc1eaf08	Refactor get_thumbnail and other fixes and improvments	3 weeks ago
Christopher Usher	70c8afe779	Switching thrimshim over to store thumbnail templates in the database	3 weeks ago
Christopher Usher	4c4e1fa85f	convert editors table to roles table	3 weeks ago
ZeldaZach	c378a1e4ab	Add Audit Logging for several endpoints ... - Use transactions for DB commits to avoid audit-less logs Endpoints Supported: - Manual Link - Reset Row - Update Row	2 months ago
Mike Lang	fd78ff288e	fix bugs in postgres schema from earlier changes	2 months ago
Mike Lang	23ad78d592	Record in database when end time is "--" ... We need this so that reverse sync reproduces these values correctly. To handle this in the database, we have a composite type (dashed: boolean, value: timestamp). Value is always valid and is equivalent to the old timestamp column, but must be equal to start_time if dashed is true. The only place we directly reference this column outside sheetsync is thrimshim, where we always consider the value only.	3 months ago
Mike Lang	69bfa79e24	Make video transition durations floats, not intervals ... Almost all code was already expecting this.	3 months ago
Mike Lang	227be23cab	postgres setup: split schema into its own file ... This is more convenient for development since it's a standalone file that you can apply without using the script, it also means we get syntax highlighting.	3 months ago