Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: Terry Swiers Reported On: 1/22/2010 For: Version 2.03 Build 7 |
CREATE DATABASE "RI" PATH 'C:\Temp\RI' CREATE TABLE "TestPK" ( "StockCode" VARCHAR(20) COLLATE "UNI", CONSTRAINT "PrimaryKey" PRIMARY KEY ("StockCode") ) VERSION 1.00 INDEX PAGE SIZE 8192 BLOB BLOCK SIZE 1024 PUBLISH BLOCK SIZE 1024 PUBLISH COMPRESSION 0 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768 MAX PUBLISH BUFFER SIZE 32768 CREATE TABLE "TestFK" ( "Container" VARCHAR(20) COLLATE "UNI", "StockCode" VARCHAR(20) COLLATE "UNI" ) VERSION 1.00 INDEX PAGE SIZE 8192 BLOB BLOCK SIZE 1024 PUBLISH BLOCK SIZE 1024 PUBLISH COMPRESSION 0 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768 MAX PUBLISH BUFFER SIZE 32768 F5 ALTER TABLE "TestFK" ADD CONSTRAINT "Container" FOREIGN KEY ("Container") REFERENCES "TestPK" ("StockCode") ON UPDATE NO ACTION ON DELETE RESTRICT F5 ALTER TABLE "TestFK" ADD CONSTRAINT "StockCode" FOREIGN KEY ("StockCode") REFERENCES "TestPK" ("StockCode") ON UPDATE NO ACTION ON DELETE RESTRICT F5 ALTER TABLE "TestFK" DROP CONSTRAINT "Container"
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |