diff options
author | Jörg Frings-Fürst <debian@jff-webhosting.net> | 2022-12-07 13:17:14 +0100 |
---|---|---|
committer | Jörg Frings-Fürst <debian@jff-webhosting.net> | 2022-12-07 13:17:14 +0100 |
commit | 4875a3dd9b183dcd2256e2abfc4ccf7484c233b4 (patch) | |
tree | 0abbea881ded030851014ffdd60fbf71fead8f65 /sql | |
parent | daf17154bf13139d9375f48525d19d6aaba08155 (diff) |
New upstream version 4.0.2upstream/4.0.2
Diffstat (limited to 'sql')
-rwxr-xr-x | sql/del.sql | 9 | ||||
-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 |
9 files changed, 112 insertions, 0 deletions
diff --git a/sql/del.sql b/sql/del.sql new file mode 100755 index 0000000..d8699cc --- /dev/null +++ b/sql/del.sql @@ -0,0 +1,9 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TestSqlM.DBF; + + + + diff --git a/sql/oneNdxTag.sql b/sql/oneNdxTag.sql new file mode 100755 index 0000000..71ff217 --- /dev/null +++ b/sql/oneNdxTag.sql @@ -0,0 +1,18 @@ +# 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 new file mode 100755 index 0000000..85d9f18 --- /dev/null +++ b/sql/testc.sql @@ -0,0 +1,13 @@ +# 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 new file mode 100755 index 0000000..3bac01c --- /dev/null +++ b/sql/testd.sql @@ -0,0 +1,12 @@ +# 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 new file mode 100755 index 0000000..85c8000 --- /dev/null +++ b/sql/testdd.sql @@ -0,0 +1,14 @@ +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 new file mode 100755 index 0000000..2d00290 --- /dev/null +++ b/sql/testflg.sql @@ -0,0 +1,12 @@ +# 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 new file mode 100755 index 0000000..859334b --- /dev/null +++ b/sql/testmdx.sql @@ -0,0 +1,12 @@ +# 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 new file mode 100755 index 0000000..040dddd --- /dev/null +++ b/sql/testmdx2.sql @@ -0,0 +1,12 @@ +# 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 new file mode 100755 index 0000000..6840709 --- /dev/null +++ b/sql/twotags.sql @@ -0,0 +1,10 @@ +# 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 ); + + + |