diff options
author | Jörg Frings-Fürst <debian@jff-webhosting.net> | 2023-08-14 19:45:36 +0200 |
---|---|---|
committer | Jörg Frings-Fürst <debian@jff-webhosting.net> | 2023-08-14 19:45:36 +0200 |
commit | bfa452a375ea0a0a3f95304a69186936567e5263 (patch) | |
tree | aade062a143c1afcc4ea06ee27905ffc34a9217b /sql | |
parent | dd70ff8bf32c2d7ed365004b1770058265db1978 (diff) |
New upstream version 4.1.4
Diffstat (limited to 'sql')
-rwxr-xr-x | sql/droptbl.sql | 9 | ||||
-rwxr-xr-x | sql/jointest.sql | 43 | ||||
-rwxr-xr-x | sql/oneNdxTag.sql | 18 | ||||
-rwxr-xr-x | sql/testc.sql | 13 | ||||
-rwxr-xr-x | sql/testd.sql | 12 | ||||
-rwxr-xr-x | sql/testdd.sql | 14 | ||||
-rwxr-xr-x | sql/testflg.sql | 12 | ||||
-rwxr-xr-x | sql/testmdx.sql | 12 | ||||
-rwxr-xr-x | sql/testmdx2.sql | 12 | ||||
-rwxr-xr-x | sql/twotags.sql | 10 |
10 files changed, 0 insertions, 155 deletions
diff --git a/sql/droptbl.sql b/sql/droptbl.sql deleted file mode 100755 index d8699cc..0000000 --- a/sql/droptbl.sql +++ /dev/null @@ -1,9 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -DROP TABLE IF EXISTS TestSqlM.DBF; - - - - diff --git a/sql/jointest.sql b/sql/jointest.sql deleted file mode 100755 index de167b5..0000000 --- a/sql/jointest.sql +++ /dev/null @@ -1,43 +0,0 @@ -# HELP; - -USE /mnt/1Tdata/xbase/xbase64-4.1.1/data; - -DROP TABLE IF EXISTS MAIN0.DBF; -DROP TABLE IF EXISTS LEFT0.DBF; -DROP TABLE IF EXISTS LEFT1.DBF; -DROP TABLE IF EXISTS LEFT2.DBF; -DROP TABLE IF EXISTS LEFT3.DBF; -DROP TABLE IF EXISTS INNER0.DBF; - - -CREATE TABLE MAIN0 ( ID NUMERIC(6,0), LEFTFK0 CHAR(3), LEFTFK1 CHAR(3), LEFTFK2 CHAR(3), LEFTFK3 CHAR(3), RIGHTFK0 CHAR(3), RIGHTFK1 CHAR(3), RIGHTFK2 CHAR(3), INNERFK0 CHAR(3) ); - -CREATE TABLE LEFT0.DBF ( ID NUMERIC(6,0), LEFTFK0 CHAR(3), CFLD CHAR(10) ); -CREATE TABLE LEFT1.DBF ( ID NUMERIC(6,0), LEFTFK1 CHAR(3), CFLD CHAR(10) ); -CREATE TABLE LEFT2.DBF ( ID NUMERIC(6,0), LEFTFK2 CHAR(3), CFLD CHAR(10) ); -CREATE TABLE LEFT3.DBF ( ID NUMERIC(6,0), LEFTFK3 CHAR(3), CFLD CHAR(10) ); -CREATE TABLE INNER0.DBF( ID NUMERIC(6,0), INNERFK0 CHAR(3), CFLD CHAR(10) ); - - -INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 1, 'L01', 'L11', 'L21', 'L31', 'R01', 'R11', 'R21', 'I01' ); -INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 2, 'L02', 'L12', 'L22', 'L32', 'R02', 'R12', 'R22', 'I02' ); -INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 3, 'L03', 'L13', 'L23', 'L33', 'R03', 'R13', 'R23', 'I03' ); - -INSERT INTO LEFT0.DBF ( ID, LEFTFK0, CFLD ) VALUES ( 1, 'L01', 'REC 1 data' ); -INSERT INTO LEFT0.DBF ( ID, LEFTFK0, CFLD ) VALUES ( 2, 'L02', 'REC 2 data' ); - -INSERT INTO INNER0.DBF ( ID, INNERFK0, CFLD ) VALUES ( 1, 'I01', 'REC 1 data' ); -INSERT INTO INNER0.DBF ( ID, INNERFK0, CFLD ) VALUES ( 2, 'I03', 'REC 2 data' ); - - - -#INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); -#CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; -#DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; - - - -#SELECT M.ID, M.LEFTFK0, L0.CFLD, L1.CFLD AS L1cfld -#FROM MAIN0 M -#LEFT JOIN LEFT0 L0 ON M.LEFTFK0 = L0.LEFTFK0 -#LEFT JOIN LEFT1 L1 ON M.LEFTFK1 = L1.LEFTFK1 AND L1.ID = L0.ID
\ No newline at end of file diff --git a/sql/oneNdxTag.sql b/sql/oneNdxTag.sql deleted file mode 100755 index 71ff217..0000000 --- a/sql/oneNdxTag.sql +++ /dev/null @@ -1,18 +0,0 @@ -# HELP; - -# where the tables live -USE /mnt/1Tdata/xbase/xbase.35/data; - - -DROP TABLE IF EXISTS OneNdxTg.DBF; - -CREATE TABLE OneNdxTg.DBF( CHRFLD CHAR(50), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); - -CREATE INDEX OneNdxTg.NDX ON OneNdxTg.DBF( CHRFLD ) ASSOCIATE; - -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('AAA' ); -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('BBB' ); -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('CCC' ); -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('aaa' ); -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('bbb' ); -INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('ccc' );
\ No newline at end of file diff --git a/sql/testc.sql b/sql/testc.sql deleted file mode 100755 index 85d9f18..0000000 --- a/sql/testc.sql +++ /dev/null @@ -1,13 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); - -DROP TABLE IF EXISTS TestSql.DBF; -CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL); -CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; - -# DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; - - diff --git a/sql/testd.sql b/sql/testd.sql deleted file mode 100755 index 3bac01c..0000000 --- a/sql/testd.sql +++ /dev/null @@ -1,12 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); - -# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); -# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; - -DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; - - diff --git a/sql/testdd.sql b/sql/testdd.sql deleted file mode 100755 index 85c8000..0000000 --- a/sql/testdd.sql +++ /dev/null @@ -1,14 +0,0 @@ -HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); - -# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); -# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; - -#DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; - -DROP TABLE IF EXISTS TestSql.DBF; - - diff --git a/sql/testflg.sql b/sql/testflg.sql deleted file mode 100755 index 2d00290..0000000 --- a/sql/testflg.sql +++ /dev/null @@ -1,12 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -DROP TABLE IF EXISTS TestFlag.DBF; - -CREATE TABLE TestFlag.DBF( C1 CHAR(1), C2 CHAR(2), C3 CHAR(3), D1 DATE, D2 DATE, D3 DATE, I1 INTEGER, I2 INTEGER, I3 INTEGER, N1 NUMERIC(9,1), N2 NUMERIC(9,2), N3 NUMERIC(9,3)); - -# CREATE INDEX TestSql2 ON TestSql2.DBF( CHRFLD ); - - - diff --git a/sql/testmdx.sql b/sql/testmdx.sql deleted file mode 100755 index 859334b..0000000 --- a/sql/testmdx.sql +++ /dev/null @@ -1,12 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -DROP TABLE IF EXISTS TestSqlM.DBF; - -CREATE TABLE TestSqlM.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); - -# CREATE INDEX TestSqlM ON TestSqlM.DBF( CHRFLD ); - - - diff --git a/sql/testmdx2.sql b/sql/testmdx2.sql deleted file mode 100755 index 040dddd..0000000 --- a/sql/testmdx2.sql +++ /dev/null @@ -1,12 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -DROP TABLE IF EXISTS TestSql2.DBF; - -CREATE TABLE TestSql2.DBF( CHRFLD CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); - -CREATE INDEX Ctag1 ON TestSql2.DBF( CHRFLD ); - - - diff --git a/sql/twotags.sql b/sql/twotags.sql deleted file mode 100755 index 6840709..0000000 --- a/sql/twotags.sql +++ /dev/null @@ -1,10 +0,0 @@ -# HELP; - -USE /opt/1Tdata/xbase/xbase.30/data; - -DROP TABLE IF EXISTS TwoTags.DBF; - -CREATE TABLE TwoTags.DBF( CHRFLD1 CHAR(100), CHRFLD2 CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); - - - |