Skip to content

Instantly share code, notes, and snippets.

@aikar
Created August 24, 2010 16:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aikar/547865 to your computer and use it in GitHub Desktop.
Save aikar/547865 to your computer and use it in GitHub Desktop.
<?php
$db = new PDO('sqlite:ai.db');
$db->exec('
CREATE TABLE IF NOT EXISTS
phrases
(
`word` INTEGER,
`left` INTEGER,
`right` INTEGER,
PRIMARY KEY (`word`, `left`, `right`)
);
');
$db->exec('
CREATE TABLE IF NOT EXISTS
words
(
`id` INTEGER PRIMARY KEY ASC,
`word` VARCHAR(45) NOT NULL
);
');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment