aboutsummaryrefslogtreecommitdiffstats
path: root/OLD/csci4131/hw7/create_contacts_table.js
diff options
context:
space:
mode:
Diffstat (limited to 'OLD/csci4131/hw7/create_contacts_table.js')
-rw-r--r--OLD/csci4131/hw7/create_contacts_table.js44
1 files changed, 0 insertions, 44 deletions
diff --git a/OLD/csci4131/hw7/create_contacts_table.js b/OLD/csci4131/hw7/create_contacts_table.js
deleted file mode 100644
index bcad389..0000000
--- a/OLD/csci4131/hw7/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();
-});