Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS "city" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "postal_code" TEXT)
  2. 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)
  3. CREATE TABLE IF NOT EXISTS "street" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "id_zone" INTEGER)
  4. CREATE TABLE IF NOT EXISTS "vehicle" ("id" INTEGER PRIMARY KEY NOT NULL, "name" TEXT, "registration" TEXT UNIQUE, "image_name" TEXT)
  5. 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