[webteam] software taxonomies

[Peter Saint-Andre]

That's a straight dump from mysql. I don't have time to format it in
HTML right now. Maybe
http://mail.jabber.org/pipermail/webteam/2007-September/000406.html
helps (copy to text file or somesuch).

Alex Jones wrote:
> Plain text formatting ate your email and spat it back out.
> 
> Can you resend preformatted in HTML?
> 
> Thanks
> 
> On Wed, 2007-09-05 at 14:37 -0600, Peter Saint-Andre wrote:
>> We're chatting in the webteam room right now and folks thought it would
>> be helpful for me to send the current (www.jabber.org <http://www.jabber.org>, not stage)
>> database structure. This may be helpful as input to the new taxonomies
>> for stage.jabber.org. Here goes:
>>
>> +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
>> | Field           | Type
>>
>>
>>    | Null | Key | Default | Extra          |
>> +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
>> | id              | int(10) unsigned
>>
>>
>>    | NO   | PRI | NULL    | auto_increment |
>> | productName     | varchar(50)
>>
>>
>>    | NO   |     |         |                |
>> | productUrl      | varchar(100)
>>
>>
>>    | NO   |     |         |                |
>> | developerName   | varchar(50)
>>
>>
>>    | NO   |     |         |                |
>> | developerUrl    | varchar(100)
>>
>>
>>    | NO   |     |         |                |
>> | owner_id        | int(11)
>>
>>
>>    | NO   |     | 0       |                |
>> | category        |
>> enum('client','component','library','server','utility')
>>
>>                                                        | NO   |     |
>> client  |                |
>> | platform        |
>> set('aix','amiga','beos','browser','bsd','flash','hpux','java','j2me','linux','macos9','macosx','mozilla','newton','palmos','pocketpc','rim','smartphone','solaris','symbian','wap','wince','windows')
>> | NO   |     |         |                |
>> | license         |
>> enum('pd','gpl','lgpl','josl','apache','bsd','mit','sharedsource','freeware','shareware','payware','gplpay','gplartistic','other')
>>                                                                     | NO
>>   |     | gpl     |                |
>> | codelang        |
>> enum('actionscript','c','c++','c#','com','delphi','erlang','flash','java','javascript','lisp','lpc','mono','.net','objective-c','perl','php','python','ruby','tcl','vb','xpcom','other')
>>               | NO   |     | c       |                |
>> | version         | varchar(25)
>>
>>
>>    | NO   |     |         |                |
>> | last_modified   | int(11) unsigned
>>
>>
>>    | NO   |     | 0       |                |
>> | devlevel        | enum('active','semiactive','quiet','dormant')
>>
>>
>>    | NO   |     | active  |                |
>> | discocat        |
>> enum('client','collaboration','conference','directory','gateway','headline','none','proxy','pubsub','server')
>>
>>                  | NO   |     | client  |                |
>> | discotype       | varchar(20)
>>
>>
>>    | NO   |     |         |                |
>> | description     | varchar(255)
>>
>>
>>    | NO   |     |         |                |
>> | screenbase      | varchar(120)
>>
>>
>>    | NO   |     |         |                |
>> | screenroster    | varchar(120)
>>
>>
>>    | NO   |     |         |                |
>> | screenchat      | varchar(120)
>>
>>
>>    | NO   |     |         |                |
>> | screengroupchat | varchar(120)
>>
>>
>>    | NO   |     |         |                |
>> | screenother     | varchar(120)
>>
>>
>>    | NO   |     |         |                |
>> | hidden          | tinyint(1)
>>
>>
>>    | NO   |     | 0       |                |
>> +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
>>
>>
>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 7338 bytes
Desc: S/MIME Cryptographic Signature
Url : http://mail.jabber.org/pipermail/webteam/attachments/20070905/03f6f961/attachment-0001.bin