lunch-poll-legacy

Lunch Poll Legacy -- poll colleagues where to have lunch
Log | Files | Refs | README | LICENSE

mittag.sql (675B)

      1 CREATE TABLE restaurant (
      2   id            INTEGER PRIMARY KEY,
      3   name          TEXT,
      4   url           TEXT,
      5   category      TEXT,
      6   address       TEXT,
      7   days_open     INT(3) DEFAULT 0
      8 );
      9 
     10 INSERT INTO restaurant VALUES
     11   (NULL, 'Restaurant 1', 'http://restaurant-1.com/', '10-bistro', 'DE', 127),
     12   (NULL, 'Restaurant 2', 'http://restaurant-2.com/', '10-bistro', 'DE', 28);
     13 
     14 CREATE TABLE vote (
     15   id            INTEGER PRIMARY KEY,
     16   voter         TEXT,
     17   date          TEXT,
     18   restaurant_id INTEGER
     19 );
     20 
     21 CREATE TABLE comment (
     22   id            INTEGER PRIMARY KEY,
     23   name          TEXT,
     24   comment       TEXT,
     25   date          DATE,
     26   valid_from    DATE,
     27   valid_until   DATE
     28 );