diff --git a/server/src/scripts/create-metadata-table.js b/server/src/scripts/create-metadata-table.js index 7bd141c4c..bec586bb9 100644 --- a/server/src/scripts/create-metadata-table.js +++ b/server/src/scripts/create-metadata-table.js @@ -1,22 +1,22 @@ // @flow import { dbQuery, SQL } from '../database/database'; import { main } from './utils'; async function createTable() { await dbQuery(SQL` CREATE TABLE IF NOT EXISTS metadata ( name varchar(255) NOT NULL, - data varchar(255), + data varchar(255) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; `); } async function addNameIndex() { await dbQuery(SQL` ALTER TABLE metadata ADD PRIMARY KEY (name); `); } main([createTable, addNameIndex]);