skantravels/services/tourist-service/migrations/V1__create_favorites_table.sql

8 lines
131 B
MySQL
Raw Permalink Normal View History

CREATE TABLE favorites (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id TEXT NOT NULL,
lat REAL NOT NULL,
lng REAL NOT NULL
);