<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : cronjobs.xml
    Author     : Carlos Garcia Gomez
    Description:
        Structure for the cronjobs table.
-->
<table>
    <column>
        <name>date</name>
        <type>timestamp</type>
    </column>
    <column>
        <name>daily_exec</name>
        <type>integer</type>
        <default>0</default>
    </column>
    <column>
        <name>done</name>
        <type>boolean</type>
        <default>false</default>
    </column>
    <column>
        <name>duration</name>
        <type>double precision</type>
        <default>0</default>
    </column>
    <column>
        <name>enabled</name>
        <type>boolean</type>
        <default>true</default>
    </column>
    <column>
        <name>failed</name>
        <type>boolean</type>
        <default>false</default>
    </column>
    <column>
        <name>fails</name>
        <type>integer</type>
        <default>0</default>
    </column>
    <column>
        <name>id</name>
        <type>serial</type>
        <null>NO</null>
    </column>
    <column>
        <name>jobname</name>
        <type>character varying(50)</type>
        <null>NO</null>
    </column>
    <column>
        <name>last_duration</name>
        <type>double precision</type>
        <default>0</default>
    </column>
    <column>
        <name>pluginname</name>
        <type>character varying(50)</type>
    </column>
    <column>
        <name>running</name>
        <type>integer</type>
        <default>0</default>
    </column>
    <constraint>
        <name>cronjobs_pkey</name>
        <type>PRIMARY KEY (id)</type>
    </constraint>
</table>