aboutsummaryrefslogtreecommitdiffstats
path: root/csci4131/hw6/strap012_hw6/create_accounts_table.js
diff options
context:
space:
mode:
Diffstat (limited to 'csci4131/hw6/strap012_hw6/create_accounts_table.js')
-rw-r--r--csci4131/hw6/strap012_hw6/create_accounts_table.js41
1 files changed, 0 insertions, 41 deletions
diff --git a/csci4131/hw6/strap012_hw6/create_accounts_table.js b/csci4131/hw6/strap012_hw6/create_accounts_table.js
deleted file mode 100644
index 61b2602..0000000
--- a/csci4131/hw6/strap012_hw6/create_accounts_table.js
+++ /dev/null
@@ -1,41 +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_accounts (
- acc_id INT NOT NULL AUTO_INCREMENT,
- acc_name VARCHAR(20),
- acc_login VARCHAR(20),
- acc_password VARCHAR(200),
- PRIMARY KEY (acc_id)
- )`;
-
- console.log("Attempting to create table: tbl_accounts");
- dbCon.query(sql, function (err, result) {
- if (err) {
- throw err;
- }
- console.log("Table tbl_accounts created");
- });
-
- dbCon.end();
-});