? ??? ?????? ???? ??? ??? ??:
# ----------------------- ---- ------------------
#
# ??? ??? ?? '???'
#
CREATE TABLE ???(
author_id int (6) DEFAULT '0' NOT NULL auto_increment,
first_name varchar(20) ???? NOT NULL,
last_name varchar(20) NOT NULL,
?? varchar(100) ???? NOT NULL,
zipcode varchar(10) NOT NULL,
Telephone varchar(10) NOT NULL,
email varchar(50) NOT NULL,
comment varchar(255) NOT NULL,
PRIMARY KEY(author_id) ,
KEY first_name(??),
KEY last_name(?),
KEY ??(??),
KEY zipcode(????),
KEY ???(???)
);
#---------------------------------- -- --------
#
# ??? ??? 'books'? ????
#
CREATE TABLE books (
books_id int(6) DEFAULT '0' NOT NULL auto_increment,
books_name varchar(100) ???? NOT NULL,
Publisher_id varchar(6) NOT NULL,
date_pub datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
type varchar( 6) NOT NULL,
??? varchar(4) NOT NULL,
?? float(6,2) DEFAULT '0.00' NOT NULL,
??? varchar(255) ???? NOT NULL,
ISBN varchar (25) NOT NULL,
PRIMARY KEY (books_id),
KEY ?? (books_name),
KEY ??? (publisher_id),
KEY date_pub (date_pub),
KEY ?? ( ??) ,
KEY ???(???),
KEY ??(??),
KEY ISBN(ISBN)
)
# ------------ -- ----------------
#
# ??? ??? 'books_author'? ??
#
CREATE TABLE books_author (
id int(6) DEFAULT '0' NOT NULL auto_increment,
books_id varchar(6) NOT NULL,
author_id varchar (6) NOT NULL,
author_type varchar(6) NOT NULL,
PRIMARY KEY (id)
); -- ----------------
#
# 'publisher'? ????? ??
#
CREATE TABLE ???(
???_id int(6) DEFAULT '0' NOT NULL auto_increment,
???_?? varchar(100) ???? NOT NULL,
?? varchar( 100) NOT NULL,
???? varchar(10) NOT NULL,
?? varchar(10) NOT NULL,
telefax varchar(10) NOT NULL,
??? varchar(50) NOT NULL,
PRIMARY KEY(publisher_id),
KEY ??(publisher_name),
KEY ??(??),
KEY ???(email)
);
? ??? ??? ?? ???? ?? ?? ?????? ???? ??? ?? ???? ??? ?? ????? ?? ?? ?????(1)? ???? ???, PHP ????? ??? ?? ????? ??? ??? ????.