[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [10087] Added created by and created date on all tabk
|
From: |
Erik Holm-Larsen |
|
Subject: |
[Fmsystem-commits] [10087] Added created by and created date on all tabkes. |
|
Date: |
Tue, 02 Oct 2012 11:30:39 +0000 |
Revision: 10087
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10087
Author: erikhl
Date: 2012-10-02 11:30:38 +0000 (Tue, 02 Oct 2012)
Log Message:
-----------
Added created by and created date on all tabkes.
Requires reinstall of module
Modified Paths:
--------------
trunk/logistic/setup/tables_current.inc.php
Modified: trunk/logistic/setup/tables_current.inc.php
===================================================================
--- trunk/logistic/setup/tables_current.inc.php 2012-10-02 08:40:35 UTC (rev
10086)
+++ trunk/logistic/setup/tables_current.inc.php 2012-10-02 11:30:38 UTC (rev
10087)
@@ -4,7 +4,9 @@
'lg_project_type' => array(
'fd' => array(
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
- 'name' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => false)
+ 'name' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => false),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array(),
@@ -16,7 +18,9 @@
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
'name' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => false),
'project_type_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => false),
- 'description' => array('type'
=> 'text', 'nullable' => false)
+ 'description' => array('type'
=> 'text', 'nullable' => false),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array('lg_project_type' =>
array('project_type_id' => 'id')),
@@ -33,6 +37,8 @@
'start_date' => array('type' =>
'int', 'precision' => 4, 'nullable' => true),
'end_date' => array('type' =>
'int', 'precision' => 4, 'nullable' => true),
'responsible_user_id' =>
array('type' => 'int', 'precision' => 4, 'nullable'=> false),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
'update_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
'update_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false)
),
@@ -49,7 +55,9 @@
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
'activity_id' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
'date_from' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
- 'date_to' => array('type' =>
'int', 'precision' => 4, 'nullable' => false)
+ 'date_to' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array('lg_activity' =>
array('activity_id' => 'id')),
@@ -61,7 +69,9 @@
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
'requirement_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => false),
'resource_type_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => false),
- 'no_of_elements' =>
array('type' => 'int', 'precision' => 4, 'nullable' => true)
+ 'no_of_elements' =>
array('type' => 'int', 'precision' => 4, 'nullable' => true),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array(
@@ -76,7 +86,9 @@
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
'requirement_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => false),
'article_id' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
- 'type' => array('type' =>
'int', 'precision' => 4, 'nullable' => false)
+ 'type' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array(
@@ -92,7 +104,9 @@
'location_id' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
'attribute_name' =>
array('type' => 'varchar', 'precision' => 255, 'nullable' => false),
'attribute_type' =>
array('type' => 'varchar', 'precision' => 255, 'nullable' => false),
- 'project_type_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => true)
+ 'project_type_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => true),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array(
@@ -106,7 +120,9 @@
'fd' => array(
'id' => array('type' => 'auto',
'precision' => 4, 'nullable' => false),
'type_requirement_id' =>
array('type' => 'int', 'precision' => 4, 'nullable' => false),
- 'value' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => true)
+ 'value' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => true),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array('lg_bim_item_type_requirement' =>
array('type_requirement_id' => 'id')),
@@ -119,7 +135,9 @@
'location_id' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
'item_id' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
'type' => array('type' =>
'int', 'precision' => 4, 'nullable' => false),
- 'tracking' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => true)
+ 'tracking' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => true),
+ 'create_user' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
+ 'create_date' => array('type'
=> 'int', 'precision' => 4, 'nullable' => false),
),
'pk' => array('id'),
'fk' => array('fm_bim_item' => array('item_id'
=> 'id', 'type' => 'type')),
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [10087] Added created by and created date on all tabkes.,
Erik Holm-Larsen <=