diff options
| author | Mark Newnham <mark@newnhams.com> | 2021-04-06 20:05:00 -0600 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2021-08-22 11:17:48 +0200 |
| commit | 26f4bb9b1bb94d46f374d2362a2311bd49fab72a (patch) | |
| tree | 23f18961e96de72a4bca62b7f3bd85a54d595139 /datadict | |
| parent | 941b10472e3307661415420f8a6cf2085a0d6c71 (diff) | |
| download | adodb-26f4bb9b1bb94d46f374d2362a2311bd49fab72a.tar.gz adodb-26f4bb9b1bb94d46f374d2362a2311bd49fab72a.tar.bz2 adodb-26f4bb9b1bb94d46f374d2362a2311bd49fab72a.zip | |
update sequence to use recommended syntax
replace keyword GENERATOR with SEQUENCE in sequence manipulation methods
Diffstat (limited to 'datadict')
| -rw-r--r-- | datadict/datadict-firebird.inc.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/datadict/datadict-firebird.inc.php b/datadict/datadict-firebird.inc.php index 05332f7b..af72e176 100644 --- a/datadict/datadict-firebird.inc.php +++ b/datadict/datadict-firebird.inc.php @@ -116,9 +116,9 @@ class ADODB2_firebird extends ADODB_DataDict { { if (strpos($t,'.') !== false) { $tarr = explode('.',$t); - return 'DROP GENERATOR '.$tarr[0].'."s_'.$tarr[1].'"'; + return 'DROP SEQUENCE '.$tarr[0].'."s_'.$tarr[1].'"'; } - return 'DROP GENERATOR s_'.$t; + return 'DROP SEQUENCE s_'.$t; } @@ -192,15 +192,15 @@ end; } if (isset($tableoptions['DROP'])) - { $sql[] = "DROP GENERATOR $seqname"; + { $sql[] = "DROP SEQUENCE $seqname"; } elseif (isset($tableoptions['REPLACE'])) - { $sql[] = "DROP GENERATOR \"$seqname\""; - $sql[] = "CREATE GENERATOR \"$seqname\""; + { $sql[] = "DROP SEQUENCE \"$seqname\""; + $sql[] = "CREATE SEQUENCE \"$seqname\""; $sql[] = "ALTER TRIGGER \"$trigname\" BEFORE INSERT OR UPDATE AS BEGIN IF ( NEW.$seqField IS NULL OR NEW.$seqField = 0 ) THEN NEW.$seqField = GEN_ID(\"$seqname\", 1); END"; } else - { $sql[] = "CREATE GENERATOR $seqname"; + { $sql[] = "CREATE SEQUENCE $seqname"; $sql[] = "CREATE TRIGGER $trigname FOR $tabname BEFORE INSERT OR UPDATE AS BEGIN IF ( NEW.$seqField IS NULL OR NEW.$seqField = 0 ) THEN NEW.$seqField = GEN_ID($seqname, 1); END"; } |