Simple database question: tags

Stephen Barncard stephenREVOLUTION at barncard.com
Fri Jun 8 17:13:19 EDT 2007


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






More information about the use-livecode mailing list