From: Bill O. <ve...@us...> - 2008-03-20 20:53:59
|
Update of /cvsroot/firebird/firebird/VulcanJ/ddl/nist In directory sc8-pr-cvs17.sourceforge.net:/tmp/cvs-serv10585/ddl/nist Modified Files: cdr004.sql Log Message: occasional sync of vulcan test ware Index: cdr004.sql =================================================================== RCS file: /cvsroot/firebird/firebird/VulcanJ/ddl/nist/cdr004.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -b -U3 -r1.1 -r1.2 --- cdr004.sql 11 Nov 2005 04:17:59 -0000 1.1 +++ cdr004.sql 20 Mar 2008 20:53:59 -0000 1.2 @@ -2,7 +2,7 @@ CREATE DATABASE 'test.fdb' DEFAULT CHARACTER SET ISO8859_1; CREATE TABLE STAFF11 (EMPNUM CHAR(3) NOT NULL PRIMARY KEY, EMPNAME CHAR(20), GRADE DECIMAL(4), CITY CHAR(15), CHECK (GRADE NOT IN (5,22) AND EMPNAME NOT LIKE 'T%')); - INSERT INTO STAFF11VALUES('E1','Thomas',0,'Deale'); + INSERT INTO STAFF11 VALUES('E1','Thomas',0,'Deale'); INSERT INTO STAFF11 VALUES('E2','Tom',22,'Newyork'); INSERT INTO STAFF11 VALUES('E3','Susan',11,'Hawaii'); SELECT COUNT(*) FROM STAFF11; |