>>>>> On Wed, 15 Apr 2009 11:58:08 +0800, Craig Ringer said:
> 
> Anyway, the expanded schema:
> 
> CREATE TABLE file2 (
>     fileid bigint,
>     fileindex integer,
>     jobid integer,
>     pathid integer,
>     filenameid integer,
>     markid integer,
>     st_dev integer,
>     st_ino integer,
>     st_mod integer,
>     st_nlink integer,
>     st_uid integer,
>     st_gid integer,
>     st_rdev bigint,
>     st_size integer,
>     st_blksize integer,
>     st_blocks integer,
>     st_atime integer,
>     st_mtime integer,
>     st_ctime integer,
>     linkfi integer,
>     md5 text
> );

Thanks, I was wondering what you had done about integers.  Is integer a 32-bit
quantity?  Beware that many of these stat fields are 64-bit on modern systems
(even for 32-bit operating systems).

__Martin

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users