diff options
| -rw-r--r-- | FS/FS/Schema.pm | 2 | ||||
| -rw-r--r-- | FS/FS/dsl_note.pm | 4 | ||||
| -rw-r--r-- | FS/FS/part_export/ikano.pm | 2 | ||||
| -rw-r--r-- | etc/sql-reserved-words.txt | 6 |
4 files changed, 10 insertions, 4 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 5f78b51..7cccc7f 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1871,7 +1871,7 @@ sub tables_hashref { 'columns' => [ 'notenum', 'serial', '', '', '', '', 'svcnum', 'int', '', '', '', '', - 'user', 'varchar', 'NULL', $char_d, '', '', + 'author', 'varchar', 'NULL', $char_d, '', '', 'priority', 'char', 'NULL', 1, '', '', '_date', 'int', 'NULL', '', '', '', 'note', 'text', '', '', '', '', diff --git a/FS/FS/dsl_note.pm b/FS/FS/dsl_note.pm index 0155cbd..832fced 100644 --- a/FS/FS/dsl_note.pm +++ b/FS/FS/dsl_note.pm @@ -34,7 +34,7 @@ FS::Record. The following fields are currently supported: =item svcnum - the DSL for this note, see L<FS::svc_dsl> -=item user - export-specific, e.g. note's author or ISP vs. telco/vendor +=item author - export-specific, e.g. note's author or ISP vs. telco/vendor =item priority - export-specific, e.g. high priority or not; not used by most @@ -105,7 +105,7 @@ sub check { my $error = $self->ut_numbern('notenum') || $self->ut_foreign_key('svcnum', 'svc_dsl', 'svcnum') - || $self->ut_textn('user') + || $self->ut_textn('author') || $self->ut_alphasn('priority') || $self->ut_numbern('_date') || $self->ut_text('note') diff --git a/FS/FS/part_export/ikano.pm b/FS/FS/part_export/ikano.pm index 6316b29..bae683a 100644 --- a/FS/FS/part_export/ikano.pm +++ b/FS/FS/part_export/ikano.pm @@ -250,7 +250,7 @@ sub ikano2fsnote { new FS::dsl_note( { 'svcnum' => $svcnum, - 'user' => $by, + 'author' => $by, 'priority' => $n->{'HighPriority'} eq 'false' ? 'N' : 'H', '_date' => int(str2time($n->{'Date'})), 'note' => $n->{'Text'}, diff --git a/etc/sql-reserved-words.txt b/etc/sql-reserved-words.txt index 89dea74..553eda2 100644 --- a/etc/sql-reserved-words.txt +++ b/etc/sql-reserved-words.txt @@ -1,3 +1,9 @@ +The data below is wrong/incomplete, see: +PG8.3 - http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html +MySQL5.6 - http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html +------------------------------------------------------------------------------- + + From http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html by Jean Anderson (jta@postgres.berkeley.edu) |