База данных на 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]