diff options
-rwxr-xr-x | util/sqleditfunc.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sqleditfunc.pl b/util/sqleditfunc.pl index 67aef6cf..e18adde4 100755 --- a/util/sqleditfunc.pl +++ b/util/sqleditfunc.pl @@ -25,7 +25,7 @@ sub gensql { my %replace = ( item => $item, itemtype => $schema->{$item}{dbentry_type} ); $replace{createtemptables} = join "\n", map sprintf( - " CREATE TEMPORARY TABLE edit_%s (LIKE %s INCLUDING DEFAULTS INCLUDING CONSTRAINTS);\n". + " CREATE TEMPORARY TABLE edit_%s (LIKE %s INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING GENERATED);\n". " ALTER TABLE edit_%1\$s DROP COLUMN %s;", $_, $_ eq 'staff_alias' ? ($_, 'id') : ("${_}_hist", 'chid') # staff_alias copies from the non-_hist table, because it needs the sequence ), sort keys %ts; |