Somebody can help me ? If you run the above code in a new db named prova, the last line create then error Can't create table '.\prova\#sql-654_2e.frm' (errno: 121)
If you run the code on 4.0.17 all it is ok. Tks in advance Massimo ---------------------------------------------------------------------------- ---- CREATE TABLE RevisioniSL(SchedaLavoro CHAR(8) NOT NULL,NRev SMALLINT NOT NULL,DataRevisione DATETIME NULL,DescrizioneRev CHAR(255) NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (SchedaLavoro, NRev)) ALTER TABLE RevisioniSL ADD LIFEBELT TIMESTAMP CREATE TABLE schedelavoro(SchedaLavoro CHAR(8) NOT NULL,Articolo CHAR(19) NULL,Operazione CHAR(4) NULL,DataRilascio DATETIME NULL,Lotto CHAR(10) NULL,DataConsOfficina DATETIME NULL,DataAccettazOfficina DATETIME NULL,DataRitiro DATETIME NULL,NoteRitiro TEXT NULL,IDUSL INT NULL,IdaUltAggAS DATETIME NULL,AS400 SMALLINT NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (SchedaLavoro)) ALTER TABLE schedelavoro ADD LIFEBELT TIMESTAMP CREATE TABLE TabUbicazioneSL(IDUSL INT NOT NULL AUTO_INCREMENT,UbicazioneSL CHAR(20) NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (IDUSL)) ALTER TABLE TabUbicazioneSL ADD LIFEBELT TIMESTAMP CREATE INDEX ArtOper ON schedelavoro (Articolo, Operazione) CREATE INDEX IDUSL ON schedelavoro (IDUSL) CREATE UNIQUE INDEX UbicazioneSL ON TabUbicazioneSL (UbicazioneSL) CREATE INDEX SchedaLavoro ON RevisioniSL (SchedaLavoro) ALTER TABLE RevisioniSL ADD CONSTRAINT FOREIGN KEY (SchedaLavoro) REFERENCES schedelavoro (SchedaLavoro) ON DELETE CASCADE ALTER TABLE schedelavoro ADD CONSTRAINT FOREIGN KEY (IDUSL) REFERENCES TabUbicazioneSL (IDUSL) --------------------------------------------------------- Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel. +39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
