Silverpeas » Silverpeas Core

Correction réalisée dans le script SQL de création des tables pour MS SQL Server. Pour corriger le problème sur une base de données qui a déjà effectué le script de migration (dbBuilder), il est nécessaire d’exécuter le script SQL suivant:

DROP TABLE dbo.PdcClassification_PdcPosition
GO

DROP TABLE dbo.PdcPosition_PdcAxisValue
GO

DROP TABLE [dbo].[PdcClassification]
GO

DROP TABLE dbo.PdcPosition
GO

create table PdcClassification (
  id numeric(19,0) IDENTITY(1,1) not null,
  contentId varchar(255),
  instanceId varchar(255) not null,
  modifiable numeric(1,0) not null,
  nodeId varchar(255),
  primary key (id)
)
GO

create table PdcPosition (
  id numeric(19,0) IDENTITY(1,1) not null,
  primary key (id)
)
GO

create table PdcClassification_PdcPosition (
  PdcClassification_id numeric(19,0) not null,
  positions_id numeric(19,0) not null,
  primary key (PdcClassification_id, positions_id),
  unique (positions_id)
)
GO

create table PdcPosition_PdcAxisValue (
  PdcPosition_id numeric(19,0) not null,
  axisValues_valueId numeric(19,0) not null,
  axisValues_axisId numeric(19,0) not null,
  primary key (PdcPosition_id, axisValues_valueId, axisValues_axisId)
)
GO

create index IDX_PdcClassification_InstanceId on PdcClassification(instanceId);
GO
create index IDX_PdcClassification_ContentId on PdcClassification(contentId);
go

alter table PdcClassification_PdcPosition 
  add constraint FK_PdcClassification_PdcPosition_PositionId
  foreign key (positions_id) 
  references PdcPosition;
GO
alter table PdcClassification_PdcPosition 
  add constraint FK_PdcClassification_PdcPosition_PositionId_PdcClassificationId
  foreign key (PdcClassification_id) 
  references PdcClassification;
GO
alter table PdcPosition_PdcAxisValue 
  add constraint FK_PdcPosition_PdcAxisValue_AxisValuesId
  foreign key (axisValues_valueId, axisValues_axisId) 
  references PdcAxisValue;
GO
alter table PdcPosition_PdcAxisValue 
  add constraint FK_PdcPosition_PdcAxisValue_PdcPositionId
  foreign key (PdcPosition_id) 
  references PdcPosition;
GO