· 8 years ago · Jun 10, 2018, 02:42 AM
1<?php
2 $db = new PDO('sqlite:ai.db');
3 $db->exec('
4 CREATE TABLE IF NOT EXISTS
5 phrases
6 (
7 `word` INTEGER,
8 `left` INTEGER,
9 `right` INTEGER,
10 PRIMARY KEY (`word`, `left`, `right`)
11 );
12 ');
13 $db->exec('
14 CREATE TABLE IF NOT EXISTS
15 words
16 (
17 `id` INTEGER PRIMARY KEY ASC,
18 `word` VARCHAR(45) NOT NULL
19 );
20 ');