Changes between Version 1 and Version 2 of Internal/Inventory-alternative

Timestamp:

Oct 17, 2007, 7:07:26 AM (17 years ago)

Author:

thierry

Comment:

—

Internal/Inventory-alternative

@@ -31 +31 @@
 || MAC       || varchar(17) || YES  || UNI || NULL    ||       || MAC address of the interface ||
 || ord       || int(11)     || NO   ||     || 1       ||       || Interface ordinal number within the node ||
+|| updated_on  || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_by  || varchar(64) || NO   ||     ||  ||                ||                                               ||
 
 
@@ -43 +45 @@
 || memory      || int(11)     || YES  ||     || 0                 ||                || Memory size in MB                             ||
 || HDSZ        || int(11)     || YES  ||     || 0                 ||                || Hard disk size in GB                          ||
-|| time        || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_on  || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_by  || varchar(64) || NO   ||     || ||                ||                                               ||
+
 
 (NOTE: 'node_id' is NULL when this motherboard is not installed on any node, i.e. new parts that just got in, or stored extra/spare parts)
+
+We could also move the hard-drive info in a separate table if we allow hard-drive swapping between motherboards.
 
 === nodes table ===
@@ -52 +58 @@
 || chassis_sn  || varchar(16) || NO   || UNI ||         ||                || Manufacturer serial number of the node's chassis ||
 || location_id || varchar(64) || YES  || UNI || NULL    ||                || Link to 'id' in 'locations' table ||
+|| updated_on  || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_by  || varchar(64) || NO   ||     ||  ||                ||                                               ||
 
 (NOTE: 'location_id' is NULL when this chassis is not installed at any location, i.e. new parts that just got in, or stored extra/spare parts)
@@ -64 +72 @@
 || unit        || int(11)     || NO   ||     || 0                 ||                || ||
 || testbed_id  || varchar(64) || NO   ||     || 0                 ||                || Link to 'id' in 'testbeds' table ||
+|| updated_on  || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_by  || varchar(64) || NO   ||     ||  ||                ||                                               ||
 
 
@@ -77 +87 @@
 || longitude  || int(11)     || NO   ||     || 0       ||        || ||
 || elevation  || int(11)     || NO   ||     || 0       ||        || ||
+|| updated_on  || timestamp   || NO   ||     || CURRENT_TIMESTAMP ||                ||                                               ||
+|| updated_by  || varchar(64) || NO   ||     ||  ||                ||                                               ||
 
 == DESCRIPTION ==