Lines Matching refs:tables
51 * Add a latest column to all existing multi tables
60 $tables = $sqlite->queryAll($sql);
62 foreach ($tables as $row) {
63 $table = $row['name']; // no escaping needed, it's our own tables
81 // get tables and their SQL definitions
85 $tables = $sqlite->queryAll($sql);
95 // Step 1: move original data to temporary tables and create new ones with modified schemas
96 foreach ($tables as $table) {
106 // add rid and new primary key to regular tables
109 // add rid and new primary key to lookup tables
119 // Step 2: transfer data back from original tables (temp_*)
197 // Step 3: delete temp_* tables
198 foreach ($tables as $table) {
256 // data_ tables
276 // multi_ tables
322 * Add "published" column to all existing tables
333 $tables = $sqlite->queryAll($sql);
335 foreach ($tables as $row) {
336 $table = $row['name']; // no escaping needed, it's our own tables
358 $tables = $sqlite->queryAll($sql);
360 foreach ($tables as $row) {
361 $table = $row['name']; // no escaping needed, it's our own tables