#Nodejs ExpressJS API with Json Web Token And Sequelize ORM. #Using sequelize-auto to migrate

#Start app npm start #Sequelize auto migration from db table to models syntax sudo sequelize-auto -o "./models" -d [dbname] -h localhost -u [dbusername] -p [dbp] -x [dbpassword] -e [typeofdb] Ex: sudo sequelize-auto -o "./models" -d shengui -h localhost -u root -p 3306 -x root1234 -e mysql

#Script Mysql Add cash_user table ALTER TABLE users ENGINE = 'InnoDB'; CREATE TABLE IF NOT EXISTS cash_users ( ID int(11) NOT NULL AUTO_INCREMENT, userId int(11) DEFAULT NULL, userName varchar(64) DEFAULT NULL, password varchar(255) DEFAULT NULL, email varchar(64) DEFAULT NULL, phoneNumber varchar(64) DEFAULT NULL, cash int(11) DEFAULT NULL, totalUsedCash int(11) DEFAULT NULL, zen int(11) DEFAULT NULL, createdDate datetime DEFAULT NULL, creator varchar(50) DEFAULT NULL, updatedDate datetime DEFAULT NULL, updater varchar(50) DEFAULT NULL, PRIMARY KEY (ID) USING BTREE, KEY userId (userId) USING BTREE, CONSTRAINT cash_users_ibfk_1 FOREIGN KEY (userId) REFERENCES users (ID) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=latin1; ; #admin table CREATE TABLE IF NOT EXISTS admin ( id int(11) NOT NULL AUTO_INCREMENT, userName varchar(100) NOT NULL, password varchar(100) NOT NULL, createAt datetime DEFAULT NULL, updatedAt datetime DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; #notice table CREATE TABLE IF NOT EXISTS notice ( id int(11) NOT NULL AUTO_INCREMENT, title text NOT NULL, content longtext NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, author int(11) NOT NULL, type varchar(50) NOT NULL, status varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#Store procedure addCashUser CREATE PROCEDURE addCashUser( IN userId INT, IN userName VARCHAR(50), IN password VARCHAR(255), IN email VARCHAR(50), IN phoneNumber VARCHAR(50) ) BEGIN INSERT INTO cash_users(userId,userName,PASSWORD,email,phoneNumber,cash,zen,totalUsedCash,createdDate) VALUES (userId,userName,PASSWORD,email,phoneNumber,0,0,0,CURRENT_TIMESTAMP); END//

#Start mysql service ubuntu service mysql start

#Release note 02/09/2020 Database script external

USE shengui; CREATE TABLE IF NOT EXISTS admin ( id int(11) NOT NULL AUTO_INCREMENT, userName varchar(100) NOT NULL, password varchar(100) NOT NULL, createAt datetime DEFAULT NULL, updatedAt datetime DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=LATIN1;

CREATE TABLE IF NOT EXISTS notice ( id int(11) NOT NULL AUTO_INCREMENT, title text NOT NULL, content longtext NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, author int(11) NOT NULL, type varchar(50) NOT NULL, status varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=LATIN1;

INSERT INTO notice (id, title, content, createdAt, updatedAt, author, type, status) VALUES (1, 'Welcome new comers', 'Welcome new comers', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'news', NULL), (2, 'FULL 9004', 'https://bitly.com/Client-9004-2', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'download', NULL), (3, 'Welcome new comers', 'Welcome new comers', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'update', NULL); /*!40000 ALTER TABLE notice ENABLE KEYS */;

fuser -k 4040/tcp