- $r = true;
-
- $sql_rows = [];
- foreach ($structure["fields"] AS $fieldname => $origin) {
- if (is_string($origin)) {
- $sql_rows[] = $origin . " AS `" . DBA::escape($fieldname) . "`";
- } elseif (is_array($origin) && (sizeof($origin) == 2)) {
- $sql_rows[] = "`" . DBA::escape($origin[0]) . "`.`" . DBA::escape($origin[1]) . "` AS `" . DBA::escape($fieldname) . "`";
- }
- }
-
- $sql = sprintf("DROP VIEW IF EXISTS `%s`", DBA::escape($name));
-
- if ($verbose) {
- echo $sql . ";\n";
- }
-
- if ($action) {
- DBA::e($sql);
- }
-
- $sql = sprintf("CREATE VIEW `%s` AS SELECT \n\t", DBA::escape($name)) .
- implode(",\n\t", $sql_rows) . "\n\t" . $structure['query'];
-
- if ($verbose) {
- echo $sql . ";\n";
- }
+ $status = DBA::selectFirst('INFORMATION_SCHEMA.TABLES', ['TABLE_TYPE'],
+ ['TABLE_SCHEMA' => DBA::databaseName(), 'TABLE_NAME' => $table]);