Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: 20240418105121-restric-forgien-key.js

"use strict";

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.addConstraint("tblVehicles", {
      fields: ["user_id"],
      type: "foreign key",
      name: "restrict_user_fkey", // optional: give a custom name
      references: {
        table: "tblUsers",
        field: "user_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleRuns", {
      fields: ["vehicle_id"],
      type: "foreign key",
      name: "restrict_vehicle_fkey", // optional: give a custom name
      references: {
        table: "tblVehicles",
        field: "vehicle_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleRuns", {
      fields: ["lane_id"],
      type: "foreign key",
      name: "restrict_lane_fkey", // optional: give a custom name
      references: {
        table: "tblAuctionLanes",
        field: "lane_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleRuns", {
      fields: ["opportunity_id"],
      type: "foreign key",
      name: "restrict_opportunity_fkey", // optional: give a custom name
      references: {
        table: "tblOpportunities",
        field: "opportunity_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleImages", {
      fields: ["vehicle_id"],
      type: "foreign key",
      name: "restrict_imgvehicle_fkey", // optional: give a custom name
      references: {
        table: "tblVehicles",
        field: "vehicle_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblAuctionLanes", {
      fields: ["auctioneer_id"],
      type: "foreign key",
      name: "restrict_auctioneer_fkey", // optional: give a custom name
      references: {
        table: "tblAuctioneers",
        field: "auctioneer_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblAuctioneerFees", {
      fields: ["auctioneer_id"],
      type: "foreign key",
      name: "restrict_feeauctioneer_fkey", // optional: give a custom name
      references: {
        table: "tblAuctioneers",
        field: "auctioneer_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleRunFees", {
      fields: ["auctioneer_fee_id"],
      type: "foreign key",
      name: "restrict_auctioneerfee_fkey", // optional: give a custom name
      references: {
        table: "tblAuctioneerFees",
        field: "auctioneer_fee_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblAuctionLanes", {
      fields: ["auction_id"],
      type: "foreign key",
      name: "restrict_auction_fkey", // optional: give a custom name
      references: {
        table: "tblAuctions",
        field: "auction_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblOpportunities", {
      fields: ["auctioneer_id"],
      type: "foreign key",
      name: "restrict_oppauctioneer_fkey", // optional: give a custom name
      references: {
        table: "tblAuctioneers",
        field: "auctioneer_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblOpportunities", {
      fields: ["user_id"],
      type: "foreign key",
      name: "restrict_oppuser_fkey", // optional: give a custom name
      references: {
        table: "tblUsers",
        field: "user_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblUserSubAuctioneers", {
      fields: ["user_id"],
      type: "foreign key",
      name: "restrict_subuser_fkey", // optional: give a custom name
      references: {
        table: "tblUsers",
        field: "user_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblUserSubAuctioneers", {
      fields: ["auctioneer_id"],
      type: "foreign key",
      name: "restrict_subauctioneer_fkey", // optional: give a custom name
      references: {
        table: "tblAuctioneers",
        field: "auctioneer_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });

await queryInterface.addConstraint("tblVehicleRunFees", {
      fields: ["vehicle_run_id"],
      type: "foreign key",
      name: "restrict_vehiclerunfee_fkey", // optional: give a custom name
      references: {
        table: "tblVehicleRuns",
        field: "vehicle_run_id",
      },
      onDelete: "RESTRICT",
      onUpdate: "CASCADE",
    });
  },

async down(queryInterface, Sequelize) {
    await queryInterface.removeConstraint("tblVehicles", "restrict_user_fkey");

await queryInterface.removeConstraint(
      "tblVehicleRuns",
      "restrict_vehicle_fkey"
    );

await queryInterface.removeConstraint(
      "tblVehicleRuns",
      "restrict_lane_fkey"
    );

await queryInterface.removeConstraint(
      "tblVehicleRuns",
      "restrict_opportunity_fkey"
    );

await queryInterface.removeConstraint(
      "tblVehicleImages",
      "restrict_imgvehicle_fkey"
    );

await queryInterface.removeConstraint(
      "tblAuctionLanes",
      "restrict_auctioneer_fkey"
    );
    await queryInterface.removeConstraint(
      "tblAuctioneerFees",
      "restrict_feeauctioneer_fkey"
    );

await queryInterface.removeConstraint(
      "tblVehicleRunFees",
      "restrict_auctioneerfee_fkey"
    );

await queryInterface.removeConstraint(
      "tblAuctionLanes",
      "restrict_auction_fkey"
    );

await queryInterface.removeConstraint(
      "tblOpportunities",
      "restrict_oppauctioneer_fkey"
    );

await queryInterface.removeConstraint(
      "tblOpportunities",
      "restrict_oppuser_fkey"
    );

await queryInterface.removeConstraint(
      "tblUserSubAuctioneers",
      "restrict_subuser_fkey"
    );

await queryInterface.removeConstraint(
      "tblUserSubAuctioneers",
      "restrict_subauctioneer_fkey"
    );

await queryInterface.removeConstraint(
      "tblUserSubAuctioneers",
      "restrict_vehiclerunfee_fkey"
    );
  },
};

Name	Type	Actions
.git	Directory
.git.1	Directory
.git.2	Directory
.git.3	Directory
.git.4	Directory
.git.5	Directory
.git.6	Directory
.git.7	Directory
.vscode	Directory
.vscode.1	Directory
.vscode.2	Directory
.vscode.3	Directory
.well-known	Directory
.well-known.1	Directory
@LongLink	Directory
BEinsurance-crm	Directory
BEinsurance-crm.1	Directory
BEinsurance-crm.2	Directory
assets	Directory
assets.1	Directory
assets.2	Directory
assets.3	Directory
build	Directory
build.1	Directory
build.2	Directory
build.3	Directory
build.4	Directory
build.5	Directory
build.6	Directory
cgi-bin	Directory
cgi-bin.1	Directory
cgi-bin.2	Directory
config	Directory
config.1	Directory
config.10	Directory
config.11	Directory
config.12	Directory
config.13	Directory
config.2	Directory
config.3	Directory
config.4	Directory
config.5	Directory
config.6	Directory
config.7	Directory
config.8	Directory
config.9	Directory
constants	Directory
controllers	Directory
controllers.1	Directory
controllers.10	Directory
controllers.11	Directory
controllers.12	Directory
controllers.13	Directory
controllers.14	Directory
controllers.2	Directory
controllers.3	Directory
controllers.4	Directory
controllers.5	Directory
controllers.6	Directory
controllers.7	Directory
controllers.8	Directory
controllers.9	Directory
db	Directory
db.1	Directory
db.2	Directory
db.3	Directory
db.4	Directory
db.5	Directory
db.6	Directory
db.7	Directory
db.8	Directory
db.9	Directory
dist	Directory
dist.1	Directory
dist.10	Directory
dist.11	Directory
dist.12	Directory
dist.13	Directory
dist.14	Directory
dist.15	Directory
dist.16	Directory
dist.17	Directory
dist.18	Directory
dist.19	Directory
dist.2	Directory
dist.20	Directory
dist.21	Directory
dist.22	Directory
dist.23	Directory
dist.24	Directory
dist.25	Directory
dist.26	Directory
dist.27	Directory
dist.28	Directory
dist.29	Directory
dist.3	Directory
dist.30	Directory
dist.31	Directory
dist.32	Directory
dist.33	Directory
dist.34	Directory
dist.35	Directory
dist.36	Directory
dist.37	Directory
dist.38	Directory
dist.39	Directory
dist.4	Directory
dist.40	Directory
dist.41	Directory
dist.42	Directory
dist.43	Directory
dist.44	Directory
dist.45	Directory
dist.46	Directory
dist.5	Directory
dist.6	Directory
dist.7	Directory
dist.8	Directory
dist.9	Directory
docs	Directory
docs.1	Directory
docs.2	Directory
docs.3	Directory
docs.4	Directory
docs.5	Directory
docs.6	Directory
docs.7	Directory
docs.8	Directory
docs.9	Directory
elementor	Directory
errors	Directory
errors.1	Directory
errors.10	Directory
errors.11	Directory
errors.12	Directory
errors.13	Directory
errors.2	Directory
errors.3	Directory
errors.4	Directory
errors.5	Directory
errors.6	Directory
errors.7	Directory
errors.8	Directory
errors.9	Directory
exports	Directory
exports.1	Directory
exports.2	Directory
exports.3	Directory
favicon	Directory
favicon.1	Directory
favicon.2	Directory
favicon.3	Directory
files	Directory
files.1	Directory
files.2	Directory
files.3	Directory
files.4	Directory
files.5	Directory
files.6	Directory
files.7	Directory
files.8	Directory
files.9	Directory
insurcrm-script	Directory
loaders	Directory
loaders.1	Directory
loaders.10	Directory
loaders.2	Directory
loaders.3	Directory
loaders.4	Directory
loaders.5	Directory
loaders.6	Directory
loaders.7	Directory
loaders.8	Directory
loaders.9	Directory
maintenance	Directory
middlewares	Directory
middlewares.1	Directory
middlewares.10	Directory
middlewares.11	Directory
middlewares.12	Directory
middlewares.13	Directory
middlewares.2	Directory
middlewares.3	Directory
middlewares.4	Directory
middlewares.5	Directory
middlewares.6	Directory
middlewares.7	Directory
middlewares.8	Directory
middlewares.9	Directory
migrations	Directory
migrations.1	Directory
migrations.10	Directory
migrations.11	Directory
migrations.2	Directory
migrations.3	Directory
migrations.4	Directory
migrations.5	Directory
migrations.6	Directory
migrations.7	Directory
migrations.8	Directory
migrations.9	Directory
model	Directory
model.1	Directory
model.2	Directory
model.3	Directory
model.4	Directory
model.5	Directory
model.6	Directory
model.7	Directory
model.8	Directory
model.9	Directory
models	Directory
models.1	Directory
models.2	Directory
models.3	Directory
models.4	Directory
node_modules	Directory
node_modules.1	Directory
node_modules.10	Directory
node_modules.11	Directory
node_modules.2	Directory
node_modules.3	Directory
node_modules.4	Directory
node_modules.5	Directory
node_modules.6	Directory
node_modules.7	Directory
node_modules.8	Directory
node_modules.9	Directory
routes	Directory
routes.1	Directory
routes.10	Directory
routes.11	Directory
routes.12	Directory
routes.13	Directory
routes.2	Directory
routes.3	Directory
routes.4	Directory
routes.5	Directory
routes.6	Directory
routes.7	Directory
routes.8	Directory
routes.9	Directory
scripts	Directory
scripts.1	Directory
scripts.2	Directory
scripts.3	Directory
scripts.4	Directory
scripts.5	Directory
server	Directory
server.1	Directory
static	Directory
static.1	Directory
static.2	Directory
static.3	Directory
store-procedures	Directory
store-procedures.1	Directory
tests	Directory
tests.1	Directory
tests.2	Directory
tests.3	Directory
uploads	Directory
uploads.1	Directory
uploads.2	Directory
uploads.3	Directory
utils	Directory
utils.1	Directory
utils.2	Directory
utils.3	Directory
utils.4	Directory
utils.5	Directory
utils.6	Directory
utils.7	Directory
utils.8	Directory
utils.9	Directory
validations	Directory
wp-admin	Directory
ziptech-child	Directory
.babelrc	File
.babelrc.1	File
.babelrc.2	File
.babelrc.3	File
.babelrc.4	File
.env	File
.env.1	File
.env.2	File
.env.3	File
.env.4	File
.env.5	File
.env.6	File
.gitignore	File
.gitignore.1	File
.gitignore.2	File
.gitignore.3	File
.gitignore.4	File
.htaccess	File
.htaccess.1	File
.htaccess.bk	File
.maintenance	File
.maintenance.1	File
.trash_restore	File
.well-known.zip	File
1.html	File
2.html	File
20240418105121-restric-forgien-key.js	File
20240508104058-store-procedures.js	File
3.html	File
325f37c469a6ddd3c05c2473e5b89eef0253e9f2690ed3ef642b984be392db75.php	File
PulseRevenue.zip	File
PulseRevenue.zip.1	File
PulseRevenue.zip.2	File
PulseRevenue.zip.3	File
_redirects	File
_redirects.1	File
_redirects.2	File
_redirects.3	File
app.js	File
app.js.1	File
app.js.10	File
app.js.11	File
app.js.12	File
app.js.13	File
app.js.14	File
app.js.2	File
app.js.3	File
app.js.4	File
app.js.5	File
app.js.6	File
app.js.7	File
app.js.8	File
app.js.9	File
asset-manifest.json	File
asset-manifest.json.1	File
asset-manifest.json.2	File
asset-manifest.json.3	File
autocrm-backend.zip	File
autocrm-backend.zip.1	File
autocrm-backend.zip.2	File
autocrm-backend.zip.3	File
autocrm-backend.zip.4	File
build.zip	File
build.zip.1	File
build.zip.2	File
build.zip.3	File
build.zip.4	File
build.zip.5	File
business_logo-1715973463276.jpg	File
business_logo-1715973603241.jpg	File
business_logo-1715973883160.jpg	File
business_logo-1715974719843.png	File
business_logo-1715974807749.png	File
business_logo-1715974833349.png	File
business_logo-1715974944757.png	File
business_logo-1715975396868.png	File
business_logo-1715975404466.png	File
business_logo-1715975521888.png	File
business_logo-1715975933936.png	File
business_logo-1715976391474.png	File
business_logo-1715976459840.png	File
business_logo-1715977037691.png	File
business_logo-1715977129889.png	File
business_logo-1715977135871.png	File
business_logo-1715977173268.png	File
cache	File
config.zip	File
config.zip.1	File
config.zip.2	File
constants.zip	File
controllers.zip	File
controllers.zip.1	File
controllers.zip.2	File
dist.zip	File
dist.zip.1	File
dist.zip.10	File
dist.zip.11	File
dist.zip.12	File
dist.zip.13	File
dist.zip.14	File
dist.zip.15	File
dist.zip.16	File
dist.zip.17	File
dist.zip.18	File
dist.zip.19	File
dist.zip.2	File
dist.zip.20	File
dist.zip.21	File
dist.zip.22	File
dist.zip.23	File
dist.zip.24	File
dist.zip.25	File
dist.zip.26	File
dist.zip.27	File
dist.zip.28	File
dist.zip.29	File
dist.zip.3	File
dist.zip.30	File
dist.zip.31	File
dist.zip.32	File
dist.zip.33	File
dist.zip.34	File
dist.zip.35	File
dist.zip.36	File
dist.zip.37	File
dist.zip.38	File
dist.zip.39	File
dist.zip.4	File
dist.zip.40	File
dist.zip.41	File
dist.zip.42	File
dist.zip.43	File
dist.zip.5	File
dist.zip.6	File
dist.zip.7	File
dist.zip.8	File
dist.zip.9	File
elementor-3.24.3.zip	File
elementor-pro-3.24.2_activated.zip	File
es6.zip	File
imageUpload.js	File
imageUrl-1706549209177.png	File
imageUrl-1706549209185.png	File
imageUrl-1706550419349.png	File
imageUrl-1706550419379.png	File
index.html	File
index.html.1	File
index.html.2	File
index.html.3	File
index.js	File
index.js.1	File
index.js.2	File
index.js.3	File
index.js.4	File
index.js.5	File
manifest.json	File
manifest.json.1	File
manifest.json.2	File
manifest.json.3	File
models.zip	File
models.zip.1	File
nginx.config	File
package-lock.json	File
package-lock.json.1	File
package-lock.json.10	File
package-lock.json.11	File
package-lock.json.12	File
package-lock.json.2	File
package-lock.json.3	File
package-lock.json.4	File
package-lock.json.5	File
package-lock.json.6	File
package-lock.json.7	File
package-lock.json.8	File
package-lock.json.9	File
package.json	File
package.json.1	File
package.json.10	File
package.json.2	File
package.json.3	File
package.json.4	File
package.json.5	File
package.json.6	File
package.json.7	File
package.json.8	File
package.json.9	File
preview.png	File
resized-file-1727818379975.png	File
resized-file-1727824763670.jfif	File
resized-file-1727824817787.jfif	File
resized-file-1727884537709.jfif	File
resized-file-1727884555319.jfif	File
resized-file-1727884641630.jfif	File
resized-file-1727886827741.jfif	File
resized-file-1727887300123.jfif	File
resized-file-1727888751186.jpeg	File
resized-file-1727889058096.png	File
resized-file-1727889307621.jpeg	File
resized-file-1727889360869.jfif	File
resized-file-1727889390046.jfif	File
resized-file-1727889416202.jfif	File
resized-file-1727889429314.jfif	File
resized-file-1727889459754.png	File
resized-file-1727889493910.jpeg	File
resized-file-1727889532516.jfif	File
resized-file-1727892853374.jpeg	File
resized-file-1727892869337.png	File
resized-file-1727892924783.jpeg	File
resized-file-1728679490236.jpg	File
resized-file-1729611759110.jpeg	File
routes.zip	File
run-migrations.js	File
run-migrations.js.1	File
run-migrations.js.2	File
server.js	File
server.js.1	File
server.js.2	File
server.js.3	File
server.js.4	File
server.js.5	File
server.js.6	File
server.js.7	File
server.js.8	File
stripe.exe	File
stripe.exe.1	File
swagger.js	File
swagger.js.1	File
test.js	File
test.zip	File
testingcrmconfig.zip	File
uploads.zip	File
validations.zip	File