Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Files
F9125670
13.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
967 B
Subscribers
None
13.sql
View Options
insert
into
dbversion
(
version
,
release
,
description
)
values
(
13
,
now
(),
'Work In Progress'
);
-- comments for columns of table dbversion
comment
on
column
dbversion
.
version
is
'SQL schema version'
;
comment
on
column
dbversion
.
release
is
'Version deployment timestamp'
;
comment
on
column
dbversion
.
description
is
'Version description'
;
-- comments for columns of table task
comment
on
column
task
.
id
is
'Task Identifier'
;
comment
on
column
task
.
type
is
'References task_type table'
;
comment
on
column
task
.
status
is
'Task status (''next_run_not_scheduled'', ''next_run_scheduled'', ''completed'', ''disabled'')'
;
-- comments for columns of table task_run
comment
on
column
task_run
.
id
is
'Task run identifier'
;
comment
on
column
task_run
.
task
is
'References task table'
;
comment
on
column
task_run
.
scheduled
is
'Scheduled run time for task'
;
comment
on
column
task_run
.
started
is
'Task starting time'
;
comment
on
column
task_run
.
ended
is
'Task ending time'
;
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Sat, Jun 21, 9:11 PM (4 w, 22 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3285850
Attached To
rDSCH Scheduling utilities
Event Timeline
Log In to Comment