sqlite3 cachesdb.sql

CREATE TABLE cache ('pk' INTEGER PRIMARY KEY, 'name' TEXT, 'wayPointCode' CHAR(32), 'lat' DOUBLE, 'lon' DOUBLE, 'time' REAL, 'url' TEXT, 'found' INTEGER, 'available' INTEGER, 'archived' INTEGER, 'placedBy' TEXT, 'ownerId' INTEGER, 'type' INTEGER, 'containerSize' INTEGER, 'difficulty' INTEGER, 'terrain' INTEGER, 'country' CHAR(32), 'state' CHAR(32), 'shortDesc' TEXT, 'longDesc' TEXT, 'hints' TEXT, 'logTblName' CHAR(32), 'travelBugTblName' CHAR(32), 'userMajorCategory' INTEGER, 'userMinorCategory' INTEGER);
INSERT INTO cache(name, wayPointCode, lat, lon, time, url, found, available, archived, placedBy, ownerID, type, containerSize, difficulty, terrain, country, state, shortDesc, longDesc, hints, logTblName, travelBugTblName, userMajorCategory, userMinorCategory) VALUES ('Transmitting Signal', 'GC1D5CX', 40.653833, -112.019667, 1166832000, 'http://www.geocaching.com/seek/cache_details.aspx?guid=0920c563-a36d-49cc-8e64-324ccf6d3bb1', 0, 1, 0, 'peregrinater', 1679913, 0, 0, 2, 1, 'United States', 'Utah', '', 'It only has a logbook and 1 very small item in it. You can park within 20 feet of it. Good luck!', '', 'GC1D5CXLogs', 'GC1D5CXBugs', 0, 0);

CREATE TABLE GC1D5XLogs ('pk' INTEGER PRIMARY KEY, 'date' REAL, 'logId' INTEGER, 'type' INTEGER, 'finderId' INTEGER, 'finderName' CHAR(32), 'text' TEXT);
INSERT INTO GC1D5XLogs(date, logId, type, finderId, finderName, text) VALUES (1166832000, 1, 0, 1, 'brussell', 'TFTF!');

CREATE TABLE GC1D5XBugs ('pk' INTEGER PRIMARY KEY, 'name' TEXT, 'id' INTEGER, 'ref' CHAR(32));
INSERT INTO GC1D5XBugs(name, id, ref) VALUES('EagleCoin', 12312321, 'aoe234');