【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-jcatalog_ddl.sql,希望本篇文章对您学习有所帮助。
CREATE DATABASE catalog;
USE catalog;
CREATE TABLE IF NOT EXISTS category (
id int(10) primary key auto_increment,
name varchar(50) not null,
description varchar(255));
CREATE TABLE IF NOT EXISTS product (
id varchar(20) primary key,
name varchar(50) not null,
price decimal(8, 2),
width decimal(8, 2),
height decimal(8, 2),
description longtext);
CREATE TABLE IF NOT EXISTS product_category (
product_id varchar(20) not null,
category_id int(10) not null);
CREATE TABLE IF NOT EXISTS user (
username varchar(20) primary key,
pass
word varchar(20) not null);
ALTER TABLE product_category ADD primary key (product_id, category_id);
ALTER TABLE product_category ADD FOREIGN KEY (productid)
REFERENCES product(id)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
ALTER TABLE product_category ADD FOREIGN KEY (categoryid)
REFERENCES category(id)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
COMMIT;