1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143
| USE [Gest_Seq]
GO
/****** Object: Table [dbo].[Sequence] Script Date: 10/10/2014 11:32:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Sequence](
[sq_IdSeq] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[sq_IdMode] [varchar](10) NOT NULL,
[me_IdMetier] [int] NOT NULL,
[ml_IdMateriel] [int] NOT NULL,
[ll_IdLogiciel] [int] NOT NULL,
[sq_Label] [varchar](60) NOT NULL,
[sq_Observation] [varchar](200) NULL,
[sq_PathSequence] [varchar](255) NULL,
CONSTRAINT [PK_SEQUENCE] PRIMARY KEY NONCLUSTERED
(
[sq_IdSeq] ASC,
[sq_IdMode] ASC,
[me_IdMetier] ASC,
[ml_IdMateriel] ASC,
[ll_IdLogiciel] ASC,
[sq_Label] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [PK2_SEQUENCE] UNIQUE NONCLUSTERED
(
[sq_IdSeq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Sequence] WITH NOCHECK ADD CONSTRAINT [FK_SEQUENCE_LOGICIEL] FOREIGN KEY([ll_IdLogiciel])
REFERENCES [dbo].[Logiciel] ([ll_IdLogiciel])
ON UPDATE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Sequence] CHECK CONSTRAINT [FK_SEQUENCE_LOGICIEL]
GO
ALTER TABLE [dbo].[Sequence] WITH NOCHECK ADD CONSTRAINT [FK_SEQUENCE_MATERIEL] FOREIGN KEY([ml_IdMateriel])
REFERENCES [dbo].[Materiel] ([ml_IdMateriel])
ON UPDATE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Sequence] CHECK CONSTRAINT [FK_SEQUENCE_MATERIEL]
GO
ALTER TABLE [dbo].[Sequence] WITH NOCHECK ADD CONSTRAINT [FK_SEQUENCE_METIER] FOREIGN KEY([me_IdMetier])
REFERENCES [dbo].[Metier] ([me_IdMetier])
ON UPDATE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Sequence] CHECK CONSTRAINT [FK_SEQUENCE_METIER]
GO
ALTER TABLE [dbo].[Sequence] WITH NOCHECK ADD CONSTRAINT [FK_SEQUENCE_MODE] FOREIGN KEY([sq_IdMode])
REFERENCES [dbo].[Mode] ([mo_IdMode])
ON UPDATE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Sequence] CHECK CONSTRAINT [FK_SEQUENCE_MODE]
GO
USE [Gest_Seq]
GO
/****** Object: Index [PK3_SEQUENCE] Script Date: 10/10/2014 11:33:03 ******/
CREATE UNIQUE NONCLUSTERED INDEX [PK3_SEQUENCE] ON [dbo].[Sequence]
(
[sq_IdMode] ASC,
[me_IdMetier] ASC,
[ml_IdMateriel] ASC,
[ll_IdLogiciel] ASC,
[sq_Label] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
USE [Gest_Seq]
GO
/****** Object: Index [PK2_SEQUENCE] Script Date: 10/10/2014 11:33:21 ******/
ALTER TABLE [dbo].[Sequence] ADD CONSTRAINT [PK2_SEQUENCE] UNIQUE NONCLUSTERED
(
[sq_IdSeq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
USE [Gest_Seq]
GO
/****** Object: Index [_dta_index_Sequence_c_6] Script Date: 10/10/2014 11:33:42 ******/
CREATE CLUSTERED INDEX [_dta_index_Sequence_c_6] ON [dbo].[Sequence]
(
[ml_IdMateriel] ASC,
[ll_IdLogiciel] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
USE [Gest_Seq]
GO
/****** Object: Index [_dta_index_Sequence_6_37575172__K4_K2_K5_K3_K1] Script Date: 10/10/2014 11:34:23 ******/
CREATE NONCLUSTERED INDEX [_dta_index_Sequence_6_37575172__K4_K2_K5_K3_K1] ON [dbo].[Sequence]
(
[ml_IdMateriel] ASC,
[sq_IdMode] ASC,
[ll_IdLogiciel] ASC,
[me_IdMetier] ASC,
[sq_IdSeq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
USE [Gest_Seq]
GO
/****** Object: Index [_dta_index_Sequence_6_37575172__K2_K3_K4_K5_K1] Script Date: 10/10/2014 11:34:36 ******/
CREATE NONCLUSTERED INDEX [_dta_index_Sequence_6_37575172__K2_K3_K4_K5_K1] ON [dbo].[Sequence]
(
[sq_IdMode] ASC,
[me_IdMetier] ASC,
[ml_IdMateriel] ASC,
[ll_IdLogiciel] ASC,
[sq_IdSeq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO |
Partager