Paste Search Dynamic
Create table if not exists
  1. create table IF not exists users(
  2.     id integer not null primary key auto_increment,
  3.     email text not null,
  4.     password text not null,
  5.     verification_code text not null
  6. );
  7.  
  8. create table IF not exists devices(
  9.     id integer not null primary key auto_increment,
  10.     user_id integer not null,
  11.     browser_info text not null,
  12.     browser_token text not null,
  13.     last_login datetime not null,
  14.     last_login_location text not null,
  15.  
  16.     constraint fk_devices_user_id foreign KEY (user_id) references users(id)
Parsed in 0.005 seconds