|
|
|
|
|
insert into M_CODE values('G55QUIPINFO','中心-G55设备运行情况',1,2);
|
|
|
insert into M_CODE values('G55SATINFO', '中心-G55站级情况', 1, 2);
|
|
|
insert into M_CODE values('G55UPERNOTICE', '中心-G55上级通知' ,1, 2);
|
|
|
|
|
|
|
|
|
insert into CMS_PRMIS_TABLE values(2024, 'G55监控中心值班记录', 2000 ,'CenterMg/MC_G55DutyRecordMg.aspx', 2010, 3 ,7, NULL, NULL, NULL, NULL)
|
|
|
|
|
|
CREATE TABLE [dbo].[MC_G55TOLLCLT](
|
|
|
[SEQNO] [int] NOT NULL,
|
|
|
[ROADNO] [int] NOT NULL,
|
|
|
[STANO] [int] NOT NULL,
|
|
|
[DUTYLEADER1] [varchar](40) NULL,
|
|
|
[DUTYLEADER2] [varchar](40) NULL,
|
|
|
[DUTYJKMAN] [varchar](40) NULL,
|
|
|
[INTOLLCLTMAN] [varchar](200) NULL,
|
|
|
[OUTTOLLCLTMAN] [varchar](200) NULL,
|
|
|
[UNUSER1] [int] NULL,
|
|
|
[UNUSER2] [varchar](50) NULL,
|
|
|
[UNUSER3] [varchar](50) NULL,
|
|
|
CONSTRAINT [PK_MC_G55TOLLCLT] PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[SEQNO] ASC,
|
|
|
[ROADNO] ASC,
|
|
|
[STANO] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[MC_G55DUTYRECORD] Script Date: 03/29/2019 09:58:51 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[MC_G55DUTYRECORD](
|
|
|
[AREANO] [int] NOT NULL,
|
|
|
[ROADNO] [int] NOT NULL,
|
|
|
[STANO] [int] NOT NULL,
|
|
|
[SEQNO] [int] NOT NULL,
|
|
|
[MAKEDATE] [datetime] NOT NULL,
|
|
|
[MTJKMAN] [varchar](40) NULL,
|
|
|
[JDJKMAN] [varchar](40) NULL,
|
|
|
[CLASSNO] [int] NULL,
|
|
|
[DUTYLEADER] [varchar](20) NULL,
|
|
|
[DT] [datetime] NULL,
|
|
|
[SUPERNOTICE] [varchar](800) NULL,
|
|
|
[QUIPINFO] [varchar](200) NULL,
|
|
|
[STANOINFO] [varchar](200) NULL,
|
|
|
[RETURNMAN] [varchar](40) NULL,
|
|
|
[RETURNDT] [datetime] NULL,
|
|
|
[UPDATEMAN] [varchar](20) NULL,
|
|
|
[UPDATEDT] [datetime] NULL,
|
|
|
[UNUSER1] [int] NULL,
|
|
|
[UNUSER2] [varchar](50) NULL,
|
|
|
[UNUSER3] [varchar](50) NULL,
|
|
|
CONSTRAINT [PK_MC_G55DUTYRECORD] PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[AREANO] ASC,
|
|
|
[ROADNO] ASC,
|
|
|
[STANO] ASC,
|
|
|
[SEQNO] ASC,
|
|
|
[MAKEDATE] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|