[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Debian-sf-devel] Database Model and components

From: James Michael DuPont
Subject: [Debian-sf-devel] Database Model and components
Date: Fri, 15 Nov 2002 03:28:56 -0800 (PST)

Dear all,
I have taken my lunch break to do a reverse engineering of the
sf database model. 

Based on

I have taken the file : sourceforge/db/SourceForge_2_5.sql
(Does anyone have a fully patched model, I will updated)

and read it into sybase powerdesigner 8.

The reports are located here :
The main index is

you can get an xml version of the model here:

I have also tried to separate out separate components,
here is a list  :
groups                - the main project and all tables 
                      - directly connected to it,
                      - I need to move out some of those into the other

                      - packages                       
frs                   - file release system
frs_dlstats           - the download states
Skills                - peoples skills
survey                - project surveys
intel_agreement       - the main user settings and preferences
                        (stupid name)
Bugs                  - project bugs
snippet               - code snippets
doc                   - documents
support               - support
patch                 - patches
trove_treesums        - the trove
singletons            - all the tables floating around
foundry               - foundry
forum                 - the forum

I also have a perl script somewhere for extracting all types of data
from the PDM model, and producing a clean xml.
from there we can generate all types of nice code...

Hope you like this, More to come. 


James Michael DuPont

Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

reply via email to

[Prev in Thread] Current Thread [Next in Thread]