<?php if(php_sapi_name() !== 'cli') die(); include('stops.php'); include('common.php'); $pdo = new PDO('sqlite:stops_temp.db'); $pdo->query('DROP TABLE IF EXISTS stop_search'); $pdo->query('CREATE TABLE stop_search ( word VARCHAR(60), id INT )'); $pdo->beginTransaction(); $st = $pdo->prepare('INSERT INTO stop_search (word, id) VALUES (?, ?)'); foreach($stops as $id => $name) { foreach(split_stop_name($name) as $word) { $st->execute(array($word, $id)); $st->closeCursor(); } } $pdo->commit(); $pdo->query('CREATE INDEX stop_search_word ON stop_search (word COLLATE NOCASE)'); rename('stops_temp.db', 'stops.db');