Advertisement
mbratanov

Untitled

Dec 5th, 2024
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. CREATE TABLE Diary(id INTEGER PRIMARY KEY AUTOINCREMENT, DATE TEXT NULL, description TEXT NULL);
  2.  
  3. CREATE TABLE Food (Id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NULL, brand TEXT NULL, quantity REAL NULL, units REAL NULL, calories REAL NULL, protein REAL NULL, carbs REAL NULL, sugars REAL NULL, fat REAL NULL, saturates REAL NULL, fiber REAL NULL, sodium REAL NULL, serving_desc TEXT NULL, serving_size REAL NULL);
  4. CREATE TABLE sqlite_sequence(name,seq);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement