CREATE TABLE [dbo].[Cancel_Service] (
[id_service] [int] IDENTITY (100, 1) NOT NULL ,
[date_cont] [varchar] (50) NOT NULL ,
[time_cont] [varchar] (50) NOT NULL ,
[id_cust] [int] NOT NULL ,
[family_cust] [varchar] (50) NOT NULL ,
[target] [varchar] (50) NOT NULL ,
[date_r] [varchar] (50) NOT NULL ,
[time_b] [varchar] (50) NOT NULL ,
[rise] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CarAgency] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Customer] (
[id] [int] IDENTITY (12, 1) NOT NULL ,
[family] [varchar] (50) NOT NULL ,
[date] [varchar] (50) NOT NULL ,
[tell] [nchar] (11) NOT NULL ,
[tell2] [nchar] (11) NULL ,
[address] [varchar] (100) NOT NULL ,
[due] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Driver] (
[id] [int] NOT NULL ,
[littel_name] [varchar] (50) NOT NULL ,
[family] [varchar] (50) NOT NULL ,
[na_id] [varchar] (50) NULL ,
[tahol] [varchar] (50) NOT NULL ,
[tell] [varchar] (50) NULL ,
[car] [varchar] (50) NOT NULL ,
[color_car] [varchar] (50) NOT NULL ,
[model_car] [varchar] (50) NULL ,
[pelak_car] [varchar] (50) NULL ,
[porsant] [int] NOT NULL ,
[mob] [nchar] (11) NOT NULL ,
[etebar] [int] NULL ,
[date] [nchar] (10) NOT NULL ,
[addrees] [varchar] (80) NOT NULL ,
[due] [real] NULL ,
[time_job] [nchar] (10) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Login] (
[Username] [varchar] (50) NOT NULL ,
[Password] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Money_IN] (
[id] [int] IDENTITY (1, 100) NOT NULL ,
[id_driver] [int] NOT NULL ,
[name_driver] [varchar] (50) NOT NULL ,
[money] [int] NOT NULL ,
[date] [nchar] (10) NOT NULL ,
[time] [nchar] (10) NOT NULL ,
[tozihat] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Queue_Driver] (
[id] [int] NOT NULL ,
[name] [nvarchar] (50) NOT NULL ,
[car] [nvarchar] (50) NOT NULL ,
[Time_in] [nvarchar] (20) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[reg_SendService] (
[id_service] [int] NOT NULL ,
[date_raft] [nchar] (10) NOT NULL ,
[time_raft] [nchar] (10) NOT NULL ,
[id_cust] [int] NOT NULL ,
[name_cust] [varchar] (50) NOT NULL ,
[id_driver] [int] NOT NULL ,
[name_driver] [varchar] (50) NOT NULL ,
[date_end] [nchar] (10) NOT NULL ,
[time_end] [nchar] (10) NOT NULL ,
[due_driver] [real] NOT NULL ,
[price] [bigint] NOT NULL ,
[target] [varchar] (50) NOT NULL ,
[Type] [varchar] (25) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Reserv] (
[id_customer] [int] NOT NULL ,
[date] [varchar] (50) NOT NULL ,
[time] [varchar] (50) NOT NULL ,
[id_service] [varchar] (50) NOT NULL ,
[target] [nvarchar] (50) NOT NULL ,
[tell] [nvarchar] (50) NOT NULL ,
[date_send] [nvarchar] (50) NOT NULL ,
[time_send] [nvarchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Send_Service] (
[id_service] [int] IDENTITY (109, 1) NOT NULL ,
[id_Driver] [int] NOT NULL ,
[id_Customer] [int] NULL ,
[Name_Custumer] [varchar] (50) NOT NULL ,
[Name_Driver] [varchar] (50) NOT NULL ,
[time_service] [nchar] (10) NOT NULL ,
[Date_Service] [nchar] (10) NOT NULL ,
[Target] [nchar] (25) NOT NULL ,
[Type] [nvarchar] (25) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[sysdiagrams] (
[name] [sysname] NOT NULL ,
[principal_id] [int] NOT NULL ,
[diagram_id] [int] IDENTITY (1, 1) NOT NULL ,
[version] [int] NULL ,
[definition] [varbinary] (-1) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Wait] (
[id_service] [int] NOT NULL ,
[id_cust] [int] NOT NULL ,
[name_cust] [nvarchar] (50) NOT NULL ,
[tell_cust] [nvarchar] (50) NOT NULL ,
[date] [nvarchar] (50) NOT NULL ,
[time] [nvarchar] (50) NOT NULL ,
[target] [nchar] (10) NOT NULL ,
[address] [nvarchar] (0) NOT NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION dbo.fn_diagramobjects()
RETURNS int
WITH EXECUTE AS N'dbo'
AS
BEGIN
declare @id_upgraddiagrams int
declare @id_sysdiagrams int
declare @id_helpdiagrams int
declare @id_helpdiagramdefinition int
declare @id_creatediagram int
declare @id_renamediagram int
declare @id_alterdiagram int
declare @id_dropdiagram int
declare @InstalledObjects int
select @InstalledObjects = 0
select @id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),
@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),
@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),
@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),
@id_creatediagram = object_id(N'dbo.sp_creatediagram'),
@id_renamediagram = object_id(N'dbo.sp_renamediagram'),
@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'),
@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')
if @id_upgraddiagrams is not null
select @InstalledObjects = @InstalledObjects + 1
if @id_sysdiagrams is not null
select @InstalledObjects = @InstalledObjects + 2
if @id_helpdiagrams is not null
select @InstalledObjects = @InstalledObjects + 4
if @id_helpdiagramdefinition is not null
select @InstalledObjects = @InstalledObjects + 8
if @id_creatediagram is not null
select @InstalledObjects = @InstalledObjects + 16
if @id_renamediagram is not null
select @InstalledObjects = @InstalledObjects + 32
if @id_alterdiagram is not null
select @InstalledObjects = @InstalledObjects + 64
if @id_dropdiagram is not null
select @InstalledObjects = @InstalledObjects + 128
return @InstalledObjects
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
نوشته شده توسط محمد باقری نسب
قوانین ایجاد تاپیک در تالار
پاسخ با نقل قول