Created by
Philippe Casgrain
| #!/bin/bash
DATABASE="daylight-tests.sqlite"
if [ -e "$DATABASE" ]
then
echo "$DATABASE exists, nothing to do"
exit 0
fi
echo "Creating $DATABASE"
sqlite3 "$DATABASE" <<!
CREATE TABLE locations(location_id integer PRIMARY KEY, name text NOT NULL, timezone text NOT NULL, sort_order integer UNIQUE);
INSERT INTO locations(name, timezone, sort_order) VALUES('Aylmer', 'America/Montreal', 1);
INSERT INTO locations(name, timezone, sort_order) VALUES('Montréal', 'America/Montreal', 2);
INSERT INTO locations(name, timezone, sort_order) VALUES('Toronto', 'America/Toronto', 3);
INSERT INTO locations(name, timezone, sort_order) VALUES('San Francisco', 'America/Los_Angeles', 4);
!
|