【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“YellowPages_MSSQL.sql”一文,供大家参考学习!
-- YellowPages_MSSQL.
sql if exists (select * from sysobjects where id = object_id(N'categories') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table categories
GO
if exists (select * from sysobjects where id = object_id(N'items') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table items
GO
if exists (select * from sysobjects where id = object_id(N'users') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table users
GO
create table users
(
user_id integer identity 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)
)
GO
insert into users (user_login, user_pass
word, name, user_level) values ('admin','admin','Admin',3)
GO
insert into users (user_login, user_password, name, user_level) values ('guest','guest','Guest',1)
GO
CREATE TABLE categories (
category_id int IDENTITY primary key,
name varchar(50) NULL,
par_category_id int NULL
)
go
insert into categories (name, par_category_id) values ('Automotive', null)
GO
insert into categories (name, par_category_id) values ('Community', null)
GO
insert into categories (name, par_category_id) values ('Computers and Internet', null)
GO
insert into categories (name, par_category_id) values ('Education and Instruction', null)
GO
insert into categories (name, par_category_id) values ('Entertainment and Arts', null)
GO
insert into categories (name, par_category_id) values ('Food and Dining', null)
GO
insert into categories (name, par_category_id) values ('Health and Medicine', null)
GO
insert into categories (name, par_category_id) values ('Home and Garden', null)
GO
insert into categories (name, par_category_id) values ('Legal and Financial', null)
GO
insert into categories (name, par_category_id) values ('Accessories', 1)
GO
insert into categories (name, par_category_id) values ('Auto Wrecking', 1)
GO
insert into categories (name, par_category_id) values ('Dealers', 1)
GO
insert into categories (name, par_category_id) values ('Motorcycles', 1)
GO
insert into categories (name, par_category_id) values ('Racing', 1)
GO
insert into categories (name, par_category_id) values ('Rental', 1)
GO
insert into categories (name, par_category_id) values ('Tires', 1)
GO
insert into categories (name, par_category_id) values ('Animal and Humane Societies', 2)
GO
insert into categories (name, par_category_id) values ('Children and Youth', 2)
GO
insert into categories (name, par_category_id) values ('Disabilities', 2)
GO
insert into categories (name, par_category_id) values ('Government', 2)
GO
insert into categories (name, par_category_id) values ('Housing', 2)
GO
insert into categories (name, par_category_id) values ('Libraries', 2)
GO
insert into categories (name, par_category_id) values ('Post Offices', 2)
GO
insert into categories (name, par_category_id) values ('Religion', 2)
GO
insert into categories (name, par_category_id) values ('Communications and Networking', 3)
GO
insert into categories (name, par_category_id) values ('Computer Graphics', 3)
GO
insert into categories (name, par_category_id) values ('Computer Rental', 3)
GO
insert into categories (name, par_category_id) values ('Computer Service and Repair', 3)
GO
insert into categories (name, par_category_id) values ('Computer Training', 3)
GO
insert into categories (name, par_category_id) values ('Desktop Publishing', 3)
GO
insert into categories (name, par_category_id) values ('Software', 3)
GO
insert into categories (name, par_category_id) values ('Colleges and Universities', 4)
GO
insert into categories (name, par_category_id) values ('K-12', 4)
GO
insert into categories (name, par_category_id) values ('Language', 4)
GO
insert into categories (name, par_category_id) values ('Preschools', 4)
GO
insert into categories (name, par_category_id) values ('Tutoring', 4)
GO
insert into categories (name, par_category_id) values ('Bars, Pubs, and Clubs', 5)
GO
insert into categories (name, par_category_id) values ('Dance', 5)
GO
insert into categories (name, par_category_id) values ('Entertainers', 5)
GO
insert into categories (name, par_category_id) values ('Movies and Film', 5)
GO
insert into categories (name, par_category_id) values ('Museums and Galleries', 5)
GO
insert into categories (name,