【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供YellowPages_MySQL.sql参考,解决您在YellowPages_MySQL.sql学习中工作中的难题,参考学习。
-- YellowPages_MySQL.sql
drop table if exists categories;
drop table if exists items;
drop table if exists users;
create table users
(
user_id integer auto_increment primary key,
user_login varchar(15) not null,
user_password varchar(15) not null,
user_level int not null default 0,
name varchar(50) not null,
email varchar(30),
unique (user_login)
);
insert into users (user_login, user_pass
word, name, user_level) values ('admin','admin','Admin',3);
insert into users (user_login, user_password, name, user_level) values ('guest','guest','Guest',1);
CREATE TABLE categories (
category_id int auto_increment primary key,
name varchar(50) NULL,
par_category_id int NULL
);
insert into categories (name, par_category_id) values ('Automotive', null);
insert into categories (name, par_category_id) values ('Community', null);
insert into categories (name, par_category_id) values ('Computers and Internet', null);
insert into categories (name, par_category_id) values ('Education and Instruction', null);
insert into categories (name, par_category_id) values ('Entertainment and Arts', null);
insert into categories (name, par_category_id) values ('Food and Dining', null);
insert into categories (name, par_category_id) values ('Health and Medicine', null);
insert into categories (name, par_category_id) values ('Home and Garden', null);
insert into categories (name, par_category_id) values ('Legal and Financial', null);
insert into categories (name, par_category_id) values ('Accessories', 1);
insert into categories (name, par_category_id) values ('Auto Wrecking', 1);
insert into categories (name, par_category_id) values ('Dealers', 1);
insert into categories (name, par_category_id) values ('Motorcycles', 1);
insert into categories (name, par_category_id) values ('Racing', 1);
insert into categories (name, par_category_id) values ('Rental', 1);
insert into categories (name, par_category_id) values ('Tires', 1);
insert into categories (name, par_category_id) values ('Animal and Humane Societies', 2);
insert into categories (name, par_category_id) values ('Children and Youth', 2);
insert into categories (name, par_category_id) values ('Disabilities', 2);
insert into categories (name, par_category_id) values ('Government', 2);
insert into categories (name, par_category_id) values ('Housing', 2);
insert into categories (name, par_category_id) values ('Libraries', 2);
insert into categories (name, par_category_id) values ('Post Offices', 2);
insert into categories (name, par_category_id) values ('Religion', 2);
insert into categories (name, par_category_id) values ('Communications and Networking', 3);
insert into categories (name, par_category_id) values ('Computer Graphics', 3);
insert into categories (name, par_category_id) values ('Computer Rental', 3);
insert into categories (name, par_category_id) values ('Computer Service and Repair', 3);
insert into categories (name, par_category_id) values ('Computer Training', 3);
insert into categories (name, par_category_id) values ('Desktop Publishing', 3);
insert into categories (name, par_category_id) values ('Software', 3);
insert into categories (name, par_category_id) values ('Colleges and Universities', 4);
insert into categories (name, par_category_id) values ('K-12', 4);
insert into categories (name, par_category_id) values ('Language', 4);
insert into categories (name, par_category_id) values ('Preschools', 4);
insert into categories (name, par_category_id) values ('Tutoring', 4);
insert into categories (name, par_category_id) values ('Bars, Pubs, and Clubs', 5);
insert into categories (name, par_category_id) values ('Dance', 5);
insert into categories (name, par_category_id) values ('Entertainers', 5);
insert into categories (name, par_category_id) values ('Movies and Film', 5);
insert into categories (name, par_category_id) values ('Museums and Galleries', 5);
insert into categories (name, par_category_id) values ('Music', 5);
insert into categories (name, par_category_id) values ('Tickets', 5);
insert into categories (name, par_category_id) values ('Video', 5);
insert into categories (name, par_category_id) values ('Beverages', 6);
insert into categories (name, par_category_id) values ('Candy and Sweets', 6);
insert into categor