Lines Matching refs:sql

59         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND name LIKE 'multi_%'";
60         $tables = $sqlite->queryAll($sql);
64             $sql = "ALTER TABLE $table ADD COLUMN latest INT DEFAULT 1";
65             $sqlite->query($sql);
82         $sql = "SELECT sql, name FROM sqlite_master
85         $tables = $sqlite->queryAll($sql);
88         $sql = "SELECT MAX(id) AS id, tbl, islookup FROM schemas
91         $schemas = $sqlite->queryAll($sql);
98             $sql = $table['sql'];
104             $sql = preg_replace('/pid (\w* ?NOT NULL|\w* ?PRIMARY KEY)/', 'pid TEXT DEFAULT ""', $sql);
108             $sql = preg_replace('/(PRIMARY KEY ?\([^\)]+?)(\))/', ' rid INTEGER, $1, rid $2', $sql, -1, $cnt);
111                 $sql = str_replace(')', ', rid INTEGER, PRIMARY KEY(pid,rid) )', $sql);
115             $ok = $ok && $sqlite->query($sql);
206         $sql = "SELECT sql FROM sqlite_master
209         $t = $sqlite->queryAll($sql);
210         $sql = $t[0]['sql'];
211         $sql = str_replace('islookup INTEGER,', '', $sql);
218         $ok = $ok && $sqlite->query($sql);
239         $sql = "SELECT MAX(id) AS id, tbl FROM schemas
242         $schemas = $sqlite->queryAll($sql);
265                             $sql = "UPDATE data_$name
271                             $ok = $ok && $sqlite->query($sql, $params);
285                             $sql = "UPDATE multi_$name
293                             $ok = $ok && $sqlite->query($sql, $params);
313         $sql = 'DROP TABLE IF EXISTS temp_schemas';
314         $ok = $ok && $sqlite->query($sql);
332         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND (name LIKE 'data_%' OR name LIKE 'multi_%')";
333         $tables = $sqlite->queryAll($sql);
337             $sql = "ALTER TABLE $table ADD COLUMN published INT DEFAULT NULL";
338             $ok = $ok && $sqlite->query($sql);
357         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND (name LIKE 'data_%' OR name LIKE 'multi_%')";
358         $tables = $sqlite->queryAll($sql);
362             $sql = "CREATE INDEX idx_$table" . "_latest ON $table(latest);";
363             $ok = $ok && $sqlite->query($sql);
364             $sql = "CREATE INDEX idx_$table" . "_published ON $table(published);";
365             $ok = $ok && $sqlite->query($sql);