SQLite Pragmas

-- Drill 23 — PRAGMAs الأساسية في SQLite — SQLite 3.x+
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;

CREATE TABLE parents (
  id INTEGER PRIMARY KEY
);

CREATE TABLE children (
  id INTEGER PRIMARY KEY,
  parent_id INTEGER NOT NULL,
  FOREIGN KEY (parent_id) REFERENCES parents(id)
);

INSERT INTO parents VALUES (1);
INSERT INTO children VALUES (10, 1);

SELECT parent_id
FROM children;