Skip to content
Permalink
47fde6a8a0
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

GPS-Tracking-of-On-Campus-Walking-Project/API/db/init_sqlite.sql

Go to file
 
 
Cannot retrieve contributors at this time
14 lines (14 sloc) 377 Bytes
Raw Blame
BEGIN TRANSACTION;
DROP TABLE IF EXISTS `location_data`;
CREATE TABLE IF NOT EXISTS `location_data` (
`uuid` TEXT NOT NULL PRIMARY KEY UNIQUE,
`uid` TEXT NOT NULL,
`latitude` REAL NOT NULL,
`longitude` REAL NOT NULL,
`accuracy` REAL NOT NULL,
`speed` REAL NOT NULL,
`heading` REAL NOT NULL,
`altitude` REAL NOT NULL,
`timestamp` TEXT NOT NULL
);
COMMIT;