mysql --version
mysql -u root -p
SHOW DATABASES;
CREATE DATABASE `order`;
SHOW DATABASES;
USE order;
CREATE TABLE products (
product_ID int(6) NOT NULL AUTO_INCREMENT,
p_name varchar(100) NOT NULL,
p_opt decimal(7,2) NULL default '0.00',
p_info varchar(100) NOT NULL,
p_status tinyint(1) NOT NULL,
PRIMARY KEY (product_ID));
CREATE TABLE clients (
client_ID int(6) NOT NULL AUTO_INCREMENT,
с_name_company varchar(100) NOT NULL,
c_phone varchar(12) NULL,
c_address varchar(100) NULL,
c_name varchar(20) NOT NULL,
c_middlename varchar(20) NOT NULL,
c_surname varchar(20) NOT NULL,
PRIMARY KEY (client_ID));
CREATE TABLE deals (
deal_ID int(6) NOT NULL AUTO_INCREMENT,
deal_product_ID int(6) NOT NULL default '0',
deal_client_ID int(6) NOT NULL default '0',
deal_number int(6) NULL default '0',
deal_time datetime NOT NULL,
PRIMARY KEY (deal_ID),
FOREIGN KEY (deal_product_ID) REFERENCES products(product_ID) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (deal_client_ID) REFERENCES clients(client_ID) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE delivery (
delivery_ID int(6) NOT NULL AUTO_INCREMENT,
delivery_deal__ID int(6) NOT NULL default '0',
delivery_method varchar(100) NOT NULL,
delivery_type varchar(100) NOT NULL,
delivery_cost decimal(7,2) NOT NULL default '0.00',
PRIMARY KEY (delivery_ID),
FOREIGN KEY (delivery_deal__ID) REFERENCES deals(deal_ID) ON DELETE CASCADE ON UPDATE CASCADE);
SHOW DATABASES;
USE order;
SHOW TABLES;
mysql -u root -p
SHOW DATABASES;
CREATE DATABASE `order`;
SHOW DATABASES;
USE order;
CREATE TABLE products (
product_ID int(6) NOT NULL AUTO_INCREMENT,
p_name varchar(100) NOT NULL,
p_opt decimal(7,2) NULL default '0.00',
p_info varchar(100) NOT NULL,
p_status tinyint(1) NOT NULL,
PRIMARY KEY (product_ID));
CREATE TABLE clients (
client_ID int(6) NOT NULL AUTO_INCREMENT,
с_name_company varchar(100) NOT NULL,
c_phone varchar(12) NULL,
c_address varchar(100) NULL,
c_name varchar(20) NOT NULL,
c_middlename varchar(20) NOT NULL,
c_surname varchar(20) NOT NULL,
PRIMARY KEY (client_ID));
CREATE TABLE deals (
deal_ID int(6) NOT NULL AUTO_INCREMENT,
deal_product_ID int(6) NOT NULL default '0',
deal_client_ID int(6) NOT NULL default '0',
deal_number int(6) NULL default '0',
deal_time datetime NOT NULL,
PRIMARY KEY (deal_ID),
FOREIGN KEY (deal_product_ID) REFERENCES products(product_ID) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (deal_client_ID) REFERENCES clients(client_ID) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE delivery (
delivery_ID int(6) NOT NULL AUTO_INCREMENT,
delivery_deal__ID int(6) NOT NULL default '0',
delivery_method varchar(100) NOT NULL,
delivery_type varchar(100) NOT NULL,
delivery_cost decimal(7,2) NOT NULL default '0.00',
PRIMARY KEY (delivery_ID),
FOREIGN KEY (delivery_deal__ID) REFERENCES deals(deal_ID) ON DELETE CASCADE ON UPDATE CASCADE);
SHOW DATABASES;
USE order;
SHOW TABLES;
Соседние файлы в папке Схемы и SQL код