diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-05-17 13:22:37 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-05-17 13:22:37 -0700 |
| commit | 67a2ec7e476c9a78092f451cc1d1f2e09ac39700 (patch) | |
| tree | 8e95d05f1b5d75cec36f27bf97193d1e5a1b7116 /FS | |
| parent | a1a1fbca688fda6c737bf016f6f3565b5192497b (diff) | |
history_user -> history_usernum
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Record.pm | 4 | ||||
| -rw-r--r-- | FS/FS/Schema.pm | 10 |
2 files changed, 11 insertions, 3 deletions
diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm index 3886c33..cdbcae0 100644 --- a/FS/FS/Record.pm +++ b/FS/FS/Record.pm @@ -1907,10 +1907,10 @@ sub _h_statement { my @values = map { _quote( $self->getfield($_), $self->table, $_) } @fields; "INSERT INTO h_". $self->table. " ( ". - join(', ', qw(history_date history_user history_action), @fields ). + join(', ', qw(history_date history_usernum history_action), @fields ). ") VALUES (". join(', ', $time, - dbh->quote( $FS::CurrentUser::CurrentUser->username ), + $FS::CurrentUser::CurrentUser->usernum, dbh->quote($action), @values ). diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 1da302d..5f1611c 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -267,12 +267,20 @@ sub dbdef_dist { DBIx::DBSchema::Column->new( { 'name' => 'history_user', 'type' => 'varchar', - 'null' => 'NOT NULL', + 'null' => 'NULL', 'length' => '80', 'default' => '', 'local' => '', } ), DBIx::DBSchema::Column->new( { + 'name' => 'history_usernum', + 'type' => 'int', + 'null' => 'NULL', + 'length' => '', + 'default' => '', + 'local' => '', + } ), + DBIx::DBSchema::Column->new( { 'name' => 'history_action', 'type' => 'varchar', 'null' => 'NOT NULL', |