[Demi-devel] The much awaited database schema...

[Andrew Pollock]

--hNrqBtd35jzZL4Yk
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

...and there's not a lot to it...

User
	id
	username
	password
	access_level

Host
	id
	hostname
	description
	group_id
	package
	version

Group
	id
	groupname
	description

I thought about having a separate table for packags and versions, but I
didn't think the extra joining involved was worth it to reduce the data
redundancy.

With user access levels, I was really only envisaging two, maybe three at
the most, a read-only level that could essentially just run reports and
monitor the situation, a read-write level, that could add hosts, and
possibly a read-write-update level, that was allowed to trigger updates on
remote hosts (or just roll this level into the read-write level).

Comments?

regards

Andrew

--hNrqBtd35jzZL4Yk
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAWN8EIblXXKfZFgIRAr3qAJ9X8Zr00e8MAw1jwYPewovkpXAnigCgpfqk
wfYd84gzBZKu1hC7notrGTQ=
=8p8J
-----END PGP SIGNATURE-----

--hNrqBtd35jzZL4Yk--