fork download 
  1.     CREATE TABLE `items` (
  2.     	`id`	INTEGER NOT NULL,
  3.     	`name`	VARCHAR,
  4.     	PRIMARY KEY(`id`)
  5.     );
  6.  
  7.     CREATE TABLE `prices` (
  8.     	`id`	INTEGER NOT NULL,
  9.     	`transaction_date`	DATE,
  10.     	`high_price`	INTEGER,
  11.     	`low_price`	INTEGER,
  12.     	`items_id`	INTEGER,
  13.     	PRIMARY KEY(`id`),
  14.     	FOREIGN KEY(`items_id`) REFERENCES `items`(`id`)
  15.     );
Success #stdin #stdout 0s 4528KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
https://ideone.com/y6urpx
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!