Commit Graph

22 Commits

Author SHA1 Message Date
0b7f362c80 install/create.sql fix errors 2025-03-26 11:26:26 +01:00
Milan
61405a2644 install/create.sql: new index for events 2024-07-26 21:33:49 +02:00
Milan
976355e901 fixup! create.sql, migrate.sql: limit username length to 100 2024-03-17 20:45:54 +01:00
Milan
a1ca1daeb2 create.sql, migrate.sql: limit username length to 100 2023-09-23 09:23:48 +02:00
Milan
1709694d8e studios: remove google_calendar field 2023-03-22 00:09:26 +01:00
Milan
2c0bf5887b uac.pm: add admin permission
admin permission is no more dependent on the name
of the role, but can be assigned to any role.
Users assigned to admin role have all permissions.
2023-03-22 00:07:11 +01:00
Milan
979377c31d help-texts: add
users with permission edit_help_texts are allowed to select edit help
texts from menu and enter texts for all event fields. Other users will
see help texts as tooltips. This allows to provide help to users
depending on your workflow. help texts are saved by project and studio.
2023-03-21 15:16:10 +01:00
Milan
f4c69f6191 drop unused column user_series.active 2023-03-20 05:42:41 +01:00
Milan
b84ce1f60a create.sql: fresh update with some basic entries
A fresh basic database export with mysql8.
This comes with a basic setup containing a
project, a studio, a series, roles, time assignments.
2023-02-19 23:13:38 +01:00
Johannes Kuhfuss
9d93791cfe fix some insert statements in create.sql (JKU, 2023-02-15) 2023-02-18 23:26:02 +01:00
Milan
873d546e13 category: remove
as not used for a long time by now
2021-04-11 13:13:00 +02:00
Milan
15708d951b calendar.js: save selected day start time
set the day start time to the last selecved value for each studio
the user is assigned to.
2021-04-11 13:10:42 +02:00
Milan
7ffc6914b9 audio-recordings.cgi: set upload status
on uploading and audio processing the status is updated
2021-04-11 13:10:42 +02:00
Milan
ef84ca07a3 copying events: save user selection
On copying events from another studio selection will be saved.
The next time one wants to copy saved presets are preselected.
This simplifies to frequently rebroadcast shows from another project.
2021-04-11 13:10:42 +02:00
Milan
5dbe801a11 install/create.sql: full schema dump
remove delta migrate.sql
2021-04-11 13:10:42 +02:00
Milan
a7828b52d9 user sessions: use database instead of filesystem
User sessions will be stored in database and not in files anymore.
CGI::Session is not used anymore for this purpose.  The new module
user_sessions.pm provides functions on new database table user_sessions.
2020-11-14 21:06:22 +01:00
Milan
eaaea81ed4 set default project and studio at user settings 2018-10-14 00:05:04 +02:00
Milan
aadf3fd06e add user password reset, add series image switch, add image licences, redesign exclude filters 2018-03-17 13:14:13 +01:00
Milan
6222e2a63f add draft status to events 2018-01-25 20:50:44 +01:00
Milan
459d36b7c7 only update selected recording entries, set timestamp on creating and modifying 2018-01-18 16:28:34 +01:00
Milan
7b43d7a807 add playout section 2018-01-14 18:47:32 +01:00
Milan
69e5d0e4c6 copy current state of medienstaatsvertrag.org, to be verified 2017-12-18 10:58:50 +01:00