16 lines
649 B
JavaScript
16 lines
649 B
JavaScript
import { AppData } from "../../data/app-data";
|
|
import dbHandler from "../db-handler";
|
|
import MariaDBQuoteGen from "./mariadb-quote-gen";
|
|
export default async function createDBManagerTable({ db_schema, config, }) {
|
|
let sql = ``;
|
|
sql += `CREATE TABLE IF NOT EXISTS ${MariaDBQuoteGen(AppData["DbSchemaManagerTableName"])} (\n`;
|
|
sql += ` table_name VARCHAR(255) NOT NULL PRIMARY KEY,\n`;
|
|
sql += ` created_at BIGINT NOT NULL,\n`;
|
|
sql += ` updated_at BIGINT NOT NULL\n`;
|
|
sql += `) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci\n`;
|
|
await dbHandler({
|
|
query: sql,
|
|
config,
|
|
});
|
|
}
|