Re: [Bacula-users] getting rid of the base64 encoded lstat field - table size testing

[Martin S. <ma...@li...>]

>>>>> 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