База данных на SQL SERVER "Магазин вocтoчных cладocтeй"
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
TABASE [Auto] SET QUOTED_IDENTIFIER OFF DATABASE [Auto] SET RECURSIVE_TRIGGERS OFF DATABASE [Auto] SET DISABLE_BROKER DATABASE [Auto] SET AUTO_UPDATE_STATISTICS_ASYNC OFF DATABASE [Auto] SET DATE_CORRELATION_OPTIMIZATION OFF DATABASE [Auto] SET TRUSTWORTHY OFF DATABASE [Auto] SET ALLOW_SNAPSHOT_ISOLATION OFF DATABASE [Auto] SET PARAMETERIZATION SIMPLE DATABASE [Auto] SET READ_COMMITTED_SNAPSHOT OFF DATABASE [Auto] SET HONOR_BROKER_PRIORITY OFF DATABASE [Auto] SET READ_WRITE DATABASE [Auto] SET RECOVERY SIMPLE DATABASE [Auto] SET MULTI_USER DATABASE [Auto] SET PAGE_VERIFY CHECKSUM DATABASE [Auto] SET DB_CHAINING OFF [Auto]
/****** Object: Role [ADMIN] Script Date: 06/03/2011 00:02:59 ******/ROLE [ADMIN] AUTHORIZATION [dbo]
/****** Object: Role [GOST] Script Date: 06/03/2011 00:02:59 ******/ROLE [GOST] AUTHORIZATION [dbo]
/****** Object: Table [dbo].[town] Script Date: 06/03/2011 00:02:58 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONANSI_PADDING ONTABLE [dbo].[town](
[town_id] [int] IDENTITY(1,1) NOT NULL,
[town_name] [varchar](50) NULL,
CONSTRAINT [PK_town] PRIMARY KEY CLUSTERED
(
[town_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]ANSI_PADDING OFF
/****** Object: Table [dbo].[driver] Script Date: 06/03/2011 00:02:58 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONANSI_PADDING ONTABLE [dbo].[driver](
[driver_id] [int] IDENTITY(1,1) NOT NULL,
[driver_fio] [varchar](50) NULL,
CONSTRAINT [PK_driver] PRIMARY KEY CLUSTERED
(
[driver_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]ANSI_PADDING OFF
/****** Object: Table [dbo].[route] Script Date: 06/03/2011 00:02:58 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONANSI_PADDING ONTABLE [dbo].[route](
[route_id] [int] IDENTITY(1,1) NOT NULL,
[time_in] [varchar](10) NULL,
[time_out] [varchar](10) NULL,
[bus_id] [int] NULL,
[town_id] [int] NULL,
[station_id] [int] NULL,
CONSTRAINT [PK_route] PRIMARY KEY CLUSTERED
(
[route_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]ANSI_PADDING OFF
/****** Object: Table [dbo].[bus] Script Date: 06/03/2011 00:02:58 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONANSI_PADDING ONTABLE [dbo].[bus](
[bus_id] [int] IDENTITY(1,1) NOT NULL,
[gos_number] [varchar](10) NULL,
[bus_name] [varchar](50) NULL,
[driver_id] [int] NULL,
CONSTRAINT [PK_bus] PRIMARY KEY CLUSTERED
(
[bus_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]ANSI_PADDING OFF
/****** Object: Table [dbo].[station] Script Date: 06/03/2011 00:02:58 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONANSI_PADDING ONTABLE [dbo].[station](
[station_id] [int] IDENTITY(1,1) NOT NULL,
[station_name] [varchar](50) NULL,
CONSTRAINT [PK_station] PRIMARY KEY CLUSTERED
(
[station_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]ANSI_PADDING OFF
/****** Object: View [dbo].[ROUTE_VIEW] Script Date: 06/03/2011 00:02:59 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ONVIEW [dbo].[ROUTE_VIEW]dbo.route.route_id, dbo.route.time_in, dbo.route.time_out, dbo.station.station_name, dbo.town.town_name, dbo.bus.gos_number, dbo.bus.bus_name,
dbo.route.bus_id, dbo.route.town_id, dbo.route.station_iddbo.route INNER JOIN
dbo.station ON dbo.route.station_id = dbo.station.station_id INNER JOIN
dbo.town ON dbo.route.town_id = dbo.town.town_id INNER JOIN
dbo.bus ON dbo.route.bus_id = dbo.bus.bus_id
/****** Object: StoredProcedure [dbo].[GET_ROUTES_BY_TOWN] Script Date: 06/03/2011 00:02:54 ******/ANSI_NULLS ONQUOTED_IDENTIFIER ON
- =============================================
- Author:
- Create date:
- Description:
- =============================================PROCEDURE [dbo].[GET_ROUTES_BY_TOWN]
@TOWN_ID int
- SET NOCOUNT ON added to prevent extra result sets from
- interfering with SELECT statements.NOCOUNT ON;
-- Insert statements for procedure heretime_in, time_out, station_name, gos_number, bus_name
from ROUTE_VIEW where town_id = @TOWN_ID
/****** Object: ForeignKey [FK_bus_driver] Script Date: 06/03/2011 00:02:58 ******/TABLE [dbo].[bus] WITH CHECK ADD CONSTRAINT [FK_bus_driver] FOREIGN KEY([driver_id])[dbo].[driver] ([driver_id])TABLE [dbo].[bus] CHECK CONSTRAINT [FK_bus_driver]
/****** Object: ForeignKey [FK_route_bus] Script Date: 06/03/2011 00:02:58 ******/TABLE [dbo].[route] WITH CHECK ADD CONSTRAINT [FK_route_bus] FOREIGN KEY([bus_id])[dbo].[bus] ([bus_id])TABLE [dbo].[route] CHECK CONSTRAINT [FK_route_bus]
/****** Object: ForeignKey [FK_route_station] Script Date: 06/03/2011 00:02:58 ******/TABLE [dbo].[route] WITH CHECK ADD CONSTRAINT [FK_route_station] FOREIGN KEY([station_id])[dbo].[station] ([station_id])TABLE [dbo].[route] CHECK CONSTRAINT [FK_route_station]
/****** Object: ForeignKey [FK_route_town] Script Date: 06/03/2011 00:02:58 ******/TABLE [dbo].[route] WITH CHECK ADD CONSTRAINT [FK_route_town] FOREIGN KEY([town_id])[dbo].[town] ([town_id])TABLE [dbo].[route] CHECK CONSTRAINT [FK_route_town]