diff options
| author | Alexander Sulfrian <alex@spline.inf.fu-berlin.de> | 2015-01-21 05:08:23 +0100 |
|---|---|---|
| committer | Alexander Sulfrian <alex@spline.inf.fu-berlin.de> | 2015-01-22 02:20:40 +0100 |
| commit | 2b1e9e6e95fc1e5a5a7052deca7217d192a8af06 (patch) | |
| tree | 8e96f6fdcca8090940597ff23a6485613eacc848 /DefaultTo.sopm | |
| parent | e904525e9dc0429f83ad0bfb93371076b01e7324 (diff) | |
| download | DefaultRecipient-2b1e9e6e95fc1e5a5a7052deca7217d192a8af06.tar.gz DefaultRecipient-2b1e9e6e95fc1e5a5a7052deca7217d192a8af06.tar.bz2 DefaultRecipient-2b1e9e6e95fc1e5a5a7052deca7217d192a8af06.zip | |
DefaultTo: Add comments, create_* and change_* fields
Add some more database fields to be more like the default otrs interface
and track the creation time and user and the last change time and user.
Also now we have a comments field to add an additional description.
Diffstat (limited to 'DefaultTo.sopm')
| -rw-r--r-- | DefaultTo.sopm | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/DefaultTo.sopm b/DefaultTo.sopm index 64f0282..ea6abc8 100644 --- a/DefaultTo.sopm +++ b/DefaultTo.sopm @@ -24,6 +24,11 @@ <Column Name="remove_default" Required="true" Type="SMALLINT"/> <Column Name="add_new" Required="true" Type="SMALLINT"/> <Column Name="new_address" Required="false" Size="255" Type="VARCHAR"/> + <Column Name="comments" Required="false" Size="250" Type="VARCHAR"/> + <Column Name="create_time" Required="true" Type="DATE"/> + <Column Name="create_by" Required="true" Type="INTEGER"/> + <Column Name="change_time" Required="true" Type="DATE"/> + <Column Name="change_by" Required="true" Type="INTEGER"/> <Index Name="default_to_title"> <IndexColumn Name="title"/> </Index> |