Rearrange files

1 files changed, 0 insertions, 44 deletions

diff --git a/csci4131/hw6/strap012_hw6/create_contacts_table.js b/csci4131/hw6/strap012_hw6/create_contacts_table.js
deleted file mode 100644
index bcad389..0000000
--- a/csci4131/hw6/strap012_hw6/create_contacts_table.js
+++ /dev/null
@@ -1,44 +0,0 @@
-/*
-TO DO:
------
-READ ALL COMMENTS AND REPLACE VALUES ACCORDINGLY
-*/
-
-const mysql = require("mysql");
-
-const dbCon = mysql.createConnection({
-    host: "cse-mysql-classes-01.cse.umn.edu",
-    user: "C4131S21U83",               // replace with the database user provided to you
-    password: "6919",                  // replace with the database password provided to you
-    database: "C4131S21U83",           // replace with the database user provided to you
-    port: 3306
-});
-
-console.log("Attempting database connection");
-dbCon.connect(function (err) {
-    if (err) {
-        throw err;
-    }
-    console.log("Connected to database!");
-
-    const sql = `CREATE TABLE tbl_contacts (
-        contact_id   INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-        name         VARCHAR(30),
-        category     VARCHAR(40),
-        location     VARCHAR(300),
-        contact_info VARCHAR(200),
-        email        VARCHAR(30),
-        website      VARCHAR(300),
-        website_url  VARCHAR(300)
-    )`;
-
-    console.log("Attempting to create table: tbl_contacts");
-    dbCon.query(sql, function (err, result) {
-        if (err) {
-            throw err;
-        }
-        console.log("Table tbl_accounts created");
-    });
-
-    dbCon.end();
-});