search

kirtisingh3008 / Vehicle-Service-Management-System

The objective of the Vehicle Services is to provide better information for the users of this system for better results for their maintenance in the product details that is sales, purchases and stock.
3 stars 0 forks source link

MySQL Script to create database #1

Open blackhawkbrazil opened 8 months ago

blackhawkbrazil commented 8 months ago

Hello! Where can I find the script to create the database model for this VSMS? Can you help me find it?

Best, Joao

rumeshdezoysa commented 2 weeks ago

hi some sql part for admin login

CREATE TABLE tbladmin ( ID int(11) NOT NULL auto_increment, AdminuserName varchar(100) NOT NULL, Password varchar(100) NOT NULL, Email varchar(100) NOT NULL, Created timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (AdminuserName,ID), UNIQUE KEY ID (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO tbladmin (ID, AdminuserName, Password, Email, Created) VALUES (1, 'admin', '81dc9bdb52d04dc20036dbd8313ed055', 'rumesh@gmail.com', '2024-09-19 09:55:16');

user name : Admin Password : 1234