@directus/schema - npm Package Compare versions

dist/dialects/mysql.js

		@@ -80,3 +80,3 @@ "use strict";
		switch (_c.label) {
		case 0: return [4 /yield/, this.knex.raw("\n\t\t\tSELECT\n\t\t\t\tTABLE_NAME as table_name,\n\t\t\t\tCOLUMN_NAME as column_name,\n\t\t\t\tCOLUMN_DEFAULT as default_value,\n\t\t\t\tIS_NULLABLE as is_nullable,\n\t\t\t\tDATA_TYPE as data_type,\n\t\t\t\tCOLUMN_KEY as column_key,\n\t\t\t\tEXTRA as extra\n\t\t\tFROM\n\t\t\t\tINFORMATION_SCHEMA.COLUMNS\n\t\t\tWHERE\n\t\t\t\ttable_schema = ?;\n\t\t\t", [this.knex.client.database()])];
		case 0: return [4 /yield/, this.knex.raw("\n\t\t\tSELECT\n\t\t\t\tC.TABLE_NAME as table_name,\n\t\t\t\tC.COLUMN_NAME as column_name,\n\t\t\t\tC.COLUMN_DEFAULT as default_value,\n\t\t\t\tC.IS_NULLABLE as is_nullable,\n\t\t\t\tC.DATA_TYPE as data_type,\n\t\t\t\tC.COLUMN_KEY as column_key,\n\t\t\t\tC.EXTRA as extra\n\t\t\tFROM\n\t\t\t\tINFORMATION_SCHEMA.COLUMNS AS C\n\t\t\tLEFT JOIN\n\t\t\t\tINFORMATION_SCHEMA.TABLES AS T ON C.TABLE_NAME = T.TABLE_NAME\n\t\t\tWHERE\n\t\t\t\tT.TABLE_TYPE = 'BASE TABLE' AND\n\t\t\t\tT.TABLE_SCHEMA = ?;\n\t\t\t", [this.knex.client.database()])];
		case 1:
		@@ -83,0 +83,0 @@ columns = _c.sent();

package.json

		{
		"name": "@directus/schema",
		"version": "9.0.0-rc.49",
		"version": "9.0.0-rc.50",
		"description": "Utility for extracting information about existing DB schema",
		@@ -50,3 +50,3 @@ "main": "dist/index.js",
		},
		"gitHead": "b17f3e0911f2e8b9a393df351b30ccab1a655afb"
		"gitHead": "42507ae52f03423321b117f57fcb7374266cdb65"
		}

src/dialects/mysql.ts

		@@ -10,13 +10,16 @@ import KnexMySQL from 'knex-schema-inspector/dist/dialects/mysql';
		SELECT
		TABLE_NAME as table_name,
		COLUMN_NAME as column_name,
		COLUMN_DEFAULT as default_value,
		IS_NULLABLE as is_nullable,
		DATA_TYPE as data_type,
		COLUMN_KEY as column_key,
		EXTRA as extra
		C.TABLE_NAME as table_name,
		C.COLUMN_NAME as column_name,
		C.COLUMN_DEFAULT as default_value,
		C.IS_NULLABLE as is_nullable,
		C.DATA_TYPE as data_type,
		C.COLUMN_KEY as column_key,
		C.EXTRA as extra
		FROM
		INFORMATION_SCHEMA.COLUMNS
		INFORMATION_SCHEMA.COLUMNS AS C
		LEFT JOIN
		INFORMATION_SCHEMA.TABLES AS T ON C.TABLE_NAME = T.TABLE_NAME
		WHERE
		table_schema = ?;
		T.TABLE_TYPE = 'BASE TABLE' AND
		T.TABLE_SCHEMA = ?;
		`,
		@@ -23,0 +26,0 @@ [this.knex.client.database()]

New alerts