Comments
Sort by recent activity
Hi,
thank you for the promptly reply and sorry for the inconvinience. There is one mismatch from actual databases in the scripts I have provided before. Old database has index, but no primary key. Please try new scripts.
+++ SCHEMA of the database to be modified
CREATE TABLE AUDIT_ACTIONS
(
NCDACTION numeric(18, 0) NOT NULL ,
ACTIONNAME varchar (120)
)
create unique index IX_AUDIT_ACTIONS on dbo.AUDIT_ACTIONS
(NCDACTION)
/* NO PRIMARY KEY BEFORE
ALTER TABLE AUDIT_ACTIONS ADD CONSTRAINT PK_AUDIT_ACTIONS PRIMARY KEY CLUSTERED (NCDACTION)
*/
CREATE TABLE LOGGED_EVENT
(
NCDEVENT numeric(18,0) IDENTITY (1, 1) NOT NULL ,
NCDACTION numeric(18, 0) NOT NULL ,
EVENTDATETIME datetime NOT NULL ,
NCDUSER numeric(18, 0) NOT NULL ,
COMMENT varchar (1000)
)
ALTER TABLE LOGGED_EVENT ADD CONSTRAINT PK_LOGGED_EVENT PRIMARY KEY CLUSTERED (NCDEVENT)
ALTER TABLE LOGGED_EVENT ADD CONSTRAINT FK_LOGGED_E_REFERENCE_AUDIT_AC FOREIGN KEY (NCDACTION) REFERENCES AUDIT_ACTIONS (NCDACTION)
+++ SCHEMA of the new reference database
CREATE TABLE AUDIT_ACTIONS
(
NCDACTION numeric(18, 0) NOT NULL ,
ACTIONNAME varchar (120)
)
/* NO INDEX ANYMORE
create unique index IX_AUDIT_ACTIONS on dbo.AUDIT_ACTIONS
(NCDACTION)
*/
ALTER TABLE AUDIT_ACTIONS ADD CONSTRAINT PK_AUDIT_ACTIONS PRIMARY KEY CLUSTERED (NCDACTION)
CREATE TABLE LOGGED_EVENT
(
NCDEVENT numeric(18, 0) IDENTITY (1, 1) NOT NULL ,
NCDACTION numeric(18, 0) NOT NULL ,
EVENTDATETIME datetime NOT NULL ,
NCDUSER numeric(18, 0) NOT NULL ,
COMMENT varchar (1000)
)
ALTER TABLE LOGGED_EVENT ADD CONSTRAINT PK_LOGGED_EVENT PRIMARY KEY CLUSTERED (NCDEVENT)
ALTER TABLE LOGGED_EVENT ADD CONSTRAINT FK_LOGGED_E_REFERENCE_AUDIT_AC FOREIGN KEY (NCDACTION) REFERENCES AUDIT_ACTIONS (NCDACTION) / comments
Hi,
thank you for the promptly reply and sorry for the inconvinience. There is one mismatch from actual databases in the scripts I have provided before. Old database has index, but no primary key. ...