David, it's not that hard to figure out...
Why don't you get an install of Gallery2, install it, and then see
how they do the MySQL ? It comes with schema and starting data for a
server. You may have to install it first, but then you can dump the
schema with CocoaMySQL to look at it.
Most of the time you'll be using 10-50 varchar fields, a numeric
index field (choose the bit width needed) and date fields. Figure
out which ones can and cannot have NULLs. Since everything in rev can
be text, it's the easiest way to deal with the data in most cases.
And at least 1 field must be an index.
Thanks all - its a pity there are no existing sources for classic schema you
can copy and modify?
--
stephen barncard
s a n f r a n c i s c o
- - - - - - - - - - - -
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
