Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS "city" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "postal_code" TEXT)
- CREATE TABLE IF NOT EXISTS "zone" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT UNIQUE, "price" REAL, "sms_code" TEXT UNIQUE, "color" TEXT, "id_city" INTEGER)
- CREATE TABLE IF NOT EXISTS "street" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "id_zone" INTEGER)
- CREATE TABLE IF NOT EXISTS "vehicle" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "registration" TEXT UNIQUE, "image_name" TEXT)
- CREATE TABLE IF NOT EXISTS "receipt" ("id" INTEGER PRIMARY KEY NOT NULL, "start_time" TEXT, "end_time" TEXT, "date" TEXT, "car_id" INTEGER, "zone_id" INTEGER)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement