Update:Archive/2.0/Developers: Difference between revisions

Line 387: Line 387:


== Database Structure ==
== Database Structure ==
=== v1.0 Schema ===
'''v2.0 will be rewritten using [https://update-staging.mozilla.org/~colin/dev/ the existing database structure].'''
Thanks to Colin for helping make the [https://update-staging.mozilla.org/~colin/dev/ v1.0 diagram].


==== Problems ====
Thanks to [Colin] for drawing up the diagram. 
 
==== Known Issues ====
* Lacks proper normalization
* Lacks proper normalization
* Incorrect typing
* Incorrect typing
Line 398: Line 399:
These issues will be worked on over time.  They are not, however, so serious that a complete restructuring is required for v2.0.
These issues will be worked on over time.  They are not, however, so serious that a complete restructuring is required for v2.0.


=== v2.0 Schema ===
==== Garbage ====
'''v2.0 will be rewritten using the existing data structure.'''  Future improvements will be considered as needed.
 
For fun, here is the [http://oregonstate.edu/~morgamic/umo/umo.png now-obselete  v2.0 db diagram] (05/18).  It was made with [http://www.graphviz.org/ GraphViz]; [http://oregonstate.edu/~morgamic/umo/umo.txt view the source file].
For fun, here is the [http://oregonstate.edu/~morgamic/umo/umo.png now-obselete  v2.0 db diagram] (05/18).  It was made with [http://www.graphviz.org/ GraphViz]; [http://oregonstate.edu/~morgamic/umo/umo.txt view the source file].


3,035

edits