Lines Matching refs:tableName
83 $tableName = $itemType . 's'; variable
84 $tableNameOld = $tableName . '_old';
87 echo "Upgrading '$tableName'\n";
90 $row = $pdo->query("SELECT * FROM $tableName LIMIT 1")->fetch();
94 echo "No records were found in the '$tableName' table.\n";
102 $pdo->exec("RENAME TABLE $tableName TO $tableNameOld");
139 $pdo->exec("ALTER TABLE $tableName RENAME TO $tableNameOld");
175 echo "Creation of 2.0 $tableName table is complete\n";
181 echo "The 'synctoken' field already exists in the $tableName table.\n";
183 echo "the $tableName table alone\n";
190 … $pdo->exec("ALTER TABLE $tableName ADD synctoken INT(11) UNSIGNED NOT NULL DEFAULT '1'");
191 $pdo->exec("ALTER TABLE $tableName DROP ctag");
192 $pdo->exec("UPDATE $tableName SET synctoken = '1'");
195 $pdo->exec("ALTER TABLE $tableName ADD synctoken integer");
196 $pdo->exec("UPDATE $tableName SET synctoken = '1'");
203 echo "Upgraded '$tableName' to 2.0 schema.\n";