Lines Matching refs:name

59         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND name LIKE 'multi_%'";
63             $table = $row['name']; // no escaping needed, it's our own tables
82         $sql = "SELECT sql, name FROM sqlite_master
84                 AND (name LIKE 'data_%' OR name LIKE 'multi_%')";
97             $name = $table['name'];
101             $ok = $ok && $sqlite->query("ALTER TABLE $name RENAME TO temp_$name");
121             $name = $schema['tbl'];
126                 $s = sprintf('INSERT INTO data_%s SELECT *, 0 FROM temp_data_%s', $name, $name);
130                 $s = sprintf('INSERT INTO multi_%s SELECT *, 0 FROM temp_multi_%s', $name, $name);
135                 $s = sprintf('INSERT INTO data_%s SELECT *, pid FROM temp_data_%s', $name, $name);
139                 $s = sprintf('INSERT INTO multi_%s SELECT *, pid FROM temp_multi_%s', $name, $name);
144                 $s = "UPDATE data_$name SET pid = ''";
148                 $s = "UPDATE multi_$name SET pid = ''";
167                     $s = sprintf($f, $name, $colname, $colname, $colname, $colname, $colname);
175                     $s = sprintf($f, $name, $colno);
180                     $s = "UPDATE data_$name
187                     $s = "UPDATE multi_$name
199             $name = $table['name'];
200             $s = "DROP TABLE temp_$name";
208                 AND name = 'schemas'";
248             $name = $schema['tbl'];
257                 $s = 'SELECT pid, rid, rev, ' . implode(', ', $colnames) . " FROM data_$name";
265                             $sql = "UPDATE data_$name
277                 $s = "SELECT colref, pid, rid, rev, row, value FROM multi_$name";
285                             $sql = "UPDATE multi_$name
332         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND (name LIKE 'data_%' OR name LIKE 'multi_%')";
336             $table = $row['name']; // no escaping needed, it's our own tables
357         $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND (name LIKE 'data_%' OR name LIKE 'multi_%')";
361             $table = $row['name']; // no escaping needed, it's our own tables