newfeatures:dbupdate:dbupdaterequests

Version ImplementedDetails
2.2.1.77
Could you ADD
 
Colour INT 
 
TO Division please
2.2.1.77
CREATE TABLE DocumentType(DocumentTypeID CHAR(20) PRIMARY KEY, "Description" CHAR(50), "Class" CHAR(1));
ALTER TABLE OLEDocument ADD DocumentTypeID CHAR(20);
ALTER TABLE "pears"."oledocument" ADD FOREIGN KEY "DocumentType" ( "DocumentTypeID" ) REFERENCES "pears"."DocumentType" ( "DocumentTypeID" ) ON DELETE SET NULL;
  • newfeatures/dbupdate/dbupdaterequests.txt
  • Last modified: 2017/12/01 16:35
  • by 127.0.0.1