File manager - Edit - /var/www/order.cmtc.ac.th/cmtc_booking.sql
Back
-- Database: cmtc_booking CREATE TABLE admin ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL ); INSERT INTO admin (username, password) VALUES ('admin', '1234'); CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), price DECIMAL(10,2), stock INT DEFAULT 0, img1 VARCHAR(255), img2 VARCHAR(255) ); CREATE TABLE orders ( id INT AUTO_INCREMENT PRIMARY KEY, booking_no VARCHAR(50), fullname VARCHAR(255), phone VARCHAR(50), address TEXT, zipcode VARCHAR(10), receive_method VARCHAR(255), total DECIMAL(10,2), status VARCHAR(100), slip VARCHAR(255), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE order_items ( id INT AUTO_INCREMENT PRIMARY KEY, order_id INT, product_id INT, qty INT, price DECIMAL(10,2) );
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.41 |
proxy
|
phpinfo
|
Settings