[one-users] Description of one.db tables and columns

[Jaime Melis]

Hi Stefan,

I suggest two documents:

http://www.reservoir-fp7.eu/fileadmin/reservoir/delivarables/md.3.x.2.pdf
section 3.2.2 (especially the history table)

and

http://dev.opennebula.org/projects/opennebula/repository/entry/branches/one-1.2/src/client/ruby/onevm(the
ShowTableHistory hash)

note that both resources are for opennebula 1.2, but the history table
didn't change from one-1.2 to one-1.4.

regards,
Jaime


2009/12/5 Stefan Freitag <stefan.freitag at udo.edu>

> Hi all,
>
> could you please point me to some documentation for the one.db?
>
> I am interested in creating an accounting application and need a
> description
> of the columns (at least of the history table) in one.db.
> Here is what I am guessing for the columns of the history table:
>
> vid INTEGER,                 vm id
> seq INTEGER,
> host_name TEXT,          physical host
> vm_dir TEXT,                 image directory
> hid INTEGER,                host id
> vm_mad TEXT,              xen, kvm, etc
> tm_mad TEXT,              transfer mechanism
> stime INTEGER,
> etime INTEGER,
> pstime INTEGER,
> petime INTEGER,
> rstime INTEGER,
> retime INTEGER,
> estime INTEGER,
> eetime INTEGER,
> reason INTEGER,
>
> Anyway: is somebody out there doing somethine similar? ;-)
>
> Kind regards
> Stefan
>
>
>
>
> --
> Dipl.-Inform. Stefan Freitag
> Institut für Roboterforschung   - Abteilung Informationstechnik
> Technische Universität Dortmund | phone:  +49 (0)231-755-7009
> Otto-Hahn-Str. 8                | mobile: +49 (0)176-23900074
> 44221 Dortmund, Germany         | fax:    +49 (0)231-755-3251
> www.irf.uni-dortmund.de         | email:  stefan.freitag at udo.edu
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20091214/16d8cde8/attachment-0003.htm>