[sysfink] r194 committed - fix scan...

[sys...@googlecode.com]

Revision: 194
Author: mj41.cz
Date: Wed Jan 13 13:47:18 2010
Log: fix scan
* change mtime type: DATETIME -> INT
*
http://code.google.com/p/sysfink/source/detail?r=194

Modified:
/trunk/server/lib/SysFink/DB/Schema.pm
/trunk/server/lib/SysFink/Server.pm
/trunk/server/sql/schema.wiki
/trunk/server/sysfink-empty.db

=======================================
--- /trunk/server/lib/SysFink/DB/Schema.pm Tue Jan 12 14:24:03 2010
+++ /trunk/server/lib/SysFink/DB/Schema.pm Wed Jan 13 13:47:18 2010
@@ -407,13 +407,13 @@
'size' => 0
},
'mtime' => {
- 'data_type' => 'DATETIME',
+ 'data_type' => 'int',
'is_auto_increment' => 0,
'default_value' => 'NULL',
'is_foreign_key' => 0,
'name' => 'mtime',
'is_nullable' => 1,
- 'size' => 0
+ 'size' => '11'
},
'mode' => {
'data_type' => 'int',
@@ -609,13 +609,13 @@
'size' => '11'
},
'mtime' => {
- 'data_type' => 'DATETIME',
+ 'data_type' => 'int',
'is_auto_increment' => 0,
'default_value' => 'NULL',
'is_foreign_key' => 0,
'name' => 'mtime',
'is_nullable' => 1,
- 'size' => 0
+ 'size' => '11'
},
'mode' => {
'data_type' => 'int',
=======================================
--- /trunk/server/lib/SysFink/Server.pm Wed Jan 13 12:57:18 2010
+++ /trunk/server/lib/SysFink/Server.pm Wed Jan 13 13:47:18 2010
@@ -656,6 +656,7 @@
return 0 if defined $ra->{$attr_name} && ( (not defined
$rb->{$attr_name}) || $rb->{$attr_name} ne $ra->{$attr_name} );
return 0 if defined $rb->{$attr_name} && ( (not defined
$ra->{$attr_name}) || $ra->{$attr_name} ne $rb->{$attr_name} );
}
+ #print " -> are same\n";
}

return 1;
@@ -1128,6 +1129,7 @@
sd.sc_idata_id
psd.sc_idata_id
sd.found
+ si.sc_mitem_id
psd.found
machine.name
/ ];
@@ -1206,7 +1208,11 @@
}

# path
- my $path_str = " " . $row->[ $name_to_pos->{path_path} ] . ":";
+ my $path_str = " " . $row->[ $name_to_pos->{path_path} ];
+ $path_str .= " (sc_mitem=" . $row->[
$name_to_pos->{si_sc_mitem_id} ] . ")" if $self->{ver} >= 4;
+ $path_str .=":";
+
+ # diff init
my $diff_str = '';

if ( ! $row->[ $name_to_pos->{'psd_found'} ] ) {
=======================================
--- /trunk/server/sql/schema.wiki Tue Jan 12 14:24:03 2010
+++ /trunk/server/sql/schema.wiki Wed Jan 13 13:47:18 2010
@@ -151,7 +151,7 @@
scan_id INT UNSIGNED NOT NULL,
newer_id INT UNSIGNED DEFAULT NULL,
found BOOLEAN NOT NULL,
- mtime DATETIME DEFAULT NULL,
+ mtime INT UNSIGNED DEFAULT NULL,
mode INT UNSIGNED DEFAULT NULL,
size INT UNSIGNED DEFAULT NULL,
uid INT UNSIGNED DEFAULT NULL,
@@ -273,7 +273,7 @@
pkg_item_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
pkg_ver_id INT UNSIGNED NOT NULL,
path_id INT UNSIGNED NOT NULL,
- mtime DATETIME DEFAULT NULL,
+ mtime INT UNSIGNED DEFAULT NULL,
mode INT UNSIGNED DEFAULT NULL,
size INT UNSIGNED DEFAULT NULL,
uid INT UNSIGNED DEFAULT NULL,
=======================================
--- /trunk/server/sysfink-empty.db Tue Jan 12 14:24:03 2010
+++ /trunk/server/sysfink-empty.db Wed Jan 13 13:47:18 2010
Binary file, no diff available.