[webteam] software taxonomies

[Peter Saint-Andre]

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 --------------
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/3b7abc58/attachment.bin