Changeset 9457aed


Ignore:
Timestamp:
03/19/13 21:00:01 (10 years ago)
Author:
Philipp Spitzer <philipp@…>
Branches:
master, qt5
Children:
4ca8bdc
Parents:
a1e348c
Message:

Added comments to the SQL statements (back in October).

Location:
src
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • src/dbschema000to001.sql

    ra1e348c r9457aed  
    1616        venue VARCHAR,
    1717        city VARCHAR,
    18         start INTEGER NOT NULL, -- timestamp (Unix Epoch)
    19         end INTEGER NOT NULL,   -- timestamp (Unix Epoch)
     18        start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
     19        end INTEGER NOT NULL,   -- timezone-less timestamp (Unix Epoch)
    2020        day_change INTEGER,
    2121        timeslot_duration INTEGER,

  • src/dbschema001.sql

    ra1e348c r9457aed  
    77        venue VARCHAR,
    88        city VARCHAR,
    9         start INTEGER NOT NULL, -- timestamp (Unix Epoch)
    10         end INTEGER NOT NULL,   -- timestamp (Unix Epoch)
     9        start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
     10        end INTEGER NOT NULL,   -- timezone-less timestamp (Unix Epoch)
    1111        day_change INTEGER,
    1212        timeslot_duration INTEGER,
    … …  
    4040        xid_conference INTEGER NOT NULL REFERENCES conference(id),
    4141        id INTEGER NOT NULL,
    42         start INTEGER NOT NULL,
     42        start INTEGER NOT NULL,    -- timezone-less timestamp (Unix Epoch)
    4343        duration INTEGER NOT NULL, -- duration of the event in seconds
    4444        xid_track INTEGER NOT NULL REFERENCES track(id),
Note: See TracChangeset for help on using the changeset viewer.