[webteam] software taxonomies

[Alex Jones]

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, 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 --------------
An HTML attachment was scrubbed...
URL: http://mail.jabber.org/pipermail/webteam/attachments/20070905/c937b82e/attachment.htm