davetroy / inaugreport-iphone

Inauguration report app for iPhone

This URL has Read+Write access

inaugreport-iphone / inaugreportdb.sqlite
100644 31 lines (31 sloc) 4.096 kb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
SQLite format 3@ + PatablePostPostCREATE TABLE `Post` (
  `ID` integer primary key,
  `WP_POST_ID` text,
  `DEVICE_ID` text,
  `TITLE` text,
  `DESCRIPTION` text,
  `THUMBNAIL` blob,
  `LAT` real,
  `LON` real,
  'ALT' real,
  'H_ACCURACY' real,
  'V_ACCURACY' real,
  'MANUALOVERRIDE' integer,
  'TIME_CREATED' real,
  'TIME_PICTURE' real,
  'TIME_MODIFIED' real,
  'UPLOAD_STATUS' integer
)utablePostImagePostImageCREATE TABLE `PostImage` (
  `ID` integer primary key,
  `POSTID` integer,
  `IMAGE` blob,
  'TIME_PICTURE' real
) tableLatLonLatLonCREATE TABLE `LatLon` (
  `ID` integer primary key,
  `DEVICE_ID` varchar(50) NOT NULL,
  `POST_ID` varchar(50) default NULL,
  `LAT` float NOT NULL,
  `LON` float NOT NULL,
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  'synced' boolean
) 12abcdABC12abcdTRUE