Lines Matching refs:schemas
87 // get latest versions of schemas with islookup property
88 $sql = "SELECT MAX(id) AS id, tbl, islookup FROM schemas
91 $schemas = $sqlite->queryAll($sql);
95 // Step 1: move original data to temporary tables and create new ones with modified schemas
120 foreach ($schemas as $schema) {
205 // Step 4: remove islookup in schemas table
208 AND name = 'schemas'";
213 $s = 'ALTER TABLE schemas RENAME TO temp_schemas';
221 $s = 'INSERT INTO schemas SELECT id, tbl, ts, user, comment, config FROM temp_schemas';
239 $sql = "SELECT MAX(id) AS id, tbl FROM schemas
242 $schemas = $sqlite->queryAll($sql);
246 foreach ($schemas as $schema) {