[sql] test
Viewer
- CREATE DATABASE `ab` CHARACTER SET armscii8 COLLATE armscii8_bin;
- CREATE TABLE admin(adminsno INT,username VARCHAR(20), password VARCHAR(20));
- CREATE TABLE Drivers(Did INT, Dname VARCHAR(20), DOB DATE, Gender CHAR(4),
- License_no VARCHAR(20),Phone VARCHAR(15),Address VARCHAR(40),
- Vechno VARCHAR(20),Veh_name VARCHAR(30),Ftype INT, wtype INT);
- CREATE TABLE ftype(S_no INT, Fuel_type VARCHAR(20));
- CREATE TABLE wtype( S_no INT, Wheeler_type VARCHAR(10));
- CREATE TABLE orders (osno INT, userid INT,did INT ,routeid INT,price INT,
- paymentmethod INT,dateofservice TIMESTAMP);
- CREATE TABLE paymentmthd(sno INT, ways VARCHAR(20));
- CREATE TABLE Routes(RouteNO INT,Routename VARCHAR(50),Distance INT);
- CREATE TABLE users (userid INT, name VARCHAR(20), dob DATE, email VARCHAR(20),
- phone VARCHAR(15),address VARCHAR(50),upassword VARCHAR(20));
Editor
You can edit this paste and save as new: