'columns' => [
'notenum', 'serial', '', '', '', '',
'svcnum', 'int', '', '', '', '',
- 'user', 'varchar', 'NULL', $char_d, '', '',
+ 'author', 'varchar', 'NULL', $char_d, '', '',
'priority', 'char', 'NULL', 1, '', '',
'_date', 'int', 'NULL', '', '', '',
'note', 'text', '', '', '', '',
=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
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')
+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)