@nyffels/mynodeorm
Advanced tools
Comparing version 1.0.0-alpha119 to 1.0.0-alpha120
@@ -171,4 +171,4 @@ #! /usr/bin/env node | ||
} | ||
columnSql.push(`INDEX \`fk_${key.table}_${key.column}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${key.table}_${key.column}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
} | ||
@@ -380,4 +380,4 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`; | ||
} | ||
lines.push(`ADD INDEX \`fk_${key.table}_${key.column}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
lines.push(`ADD CONSTRAINT \`fk_${key.table}_${key.column}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
lines.push(`ADD INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
lines.push(`ADD CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
} | ||
@@ -384,0 +384,0 @@ } |
@@ -113,4 +113,4 @@ import path from "node:path"; | ||
} | ||
columnSql.push(`INDEX \`fk_${key.table}_${key.column}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${key.table}_${key.column}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
} | ||
@@ -207,4 +207,4 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`; | ||
} | ||
columnSql.push(`INDEX \`fk_${key.table}_${key.column}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${key.table}_${key.column}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
columnSql.push(`INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
columnSql.push(`CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
} | ||
@@ -422,4 +422,4 @@ const sql = `CREATE TABLE ${table}(${columnSql.join(', ')});`; | ||
} | ||
lines.push(`ADD INDEX \`fk_${key.table}_${key.column}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
lines.push(`ADD CONSTRAINT \`fk_${key.table}_${key.column}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
lines.push(`ADD INDEX \`fk_${table}_${key.sourceColumn}_idx\` (\`${key.sourceColumn}\` ASC) VISIBLE`); | ||
lines.push(`ADD CONSTRAINT \`fk_${table}_${key.sourceColumn}\` FOREIGN KEY (\`${key.sourceColumn}\`) REFERENCES \`${key.table}\` (\`${key.column}\`) ON DELETE ${onDeleteAction} ON UPDATE ${onUpdateAction}`); | ||
} | ||
@@ -426,0 +426,0 @@ } |
{ | ||
"name": "@nyffels/mynodeorm", | ||
"version": "1.0.0-alpha119", | ||
"version": "1.0.0-alpha120", | ||
"description": "A full-fledged ORM framework for NodeJS and MySQL with develop friendly code aimed to handle database migrations, MySQL Query builder / helper and property mapping.", | ||
@@ -5,0 +5,0 @@ "private": false, |
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
189592