Datamodel

Griffin · Post by **Griffin** » 27 Oct 2005, 09:50

Does anyone have me the datamodel of Mantis 1.0.0rc1 .

I need it so i can make some status reports.

thx.

Guest · Post by **Guest** » 07 Nov 2005, 20:28

I have the same issue and opened

http://bugs.mantisbt.org/view.php?id=6363

My free ERD software doesn't give me the RI and I don't want to take a best guess at it.

TheEdge · Post by **TheEdge** » 08 Nov 2005, 21:15

G'Day,

- I looked on the CVS and could not find the data model, but:

.../admin/schema.php should get you started

or you can try using http://schemaspy.sourceforge.net/ to get the schema.

HTH's

PatPowerMan · Post by **PatPowerMan** » 16 Mar 2006, 22:06

Could anyone tell me, how to get the relationship -informations for a mantisBT-database?

On my WinXP-PC I have installed the DOT-Language (has nothing to do with .NET!!)
then downloaded MySQL-connector-Java-3.1.12 and extracted 'mysql-connector-java-3.1.12-bin.jar' to the c:\temp\mantis\mysql -Directory
After that, I have downloaded schemaspy.
If I start the schemaspy with:

Code: Select all

java -jar schemaSpy.jar -t mysql -o c:\temp\mantis\library -host 192.168.x.yyy -db mantisdb -u username -p dbpassword -cp C:\temp\mantis\mysql\mysql-connector-java-3.1.12-bin.jar

about 94 files and 4 subdirectories in c:\temp\mantis\library will be created with the following message:

Code: Select all

C:\Temp\mantis>java -jar schemaSpy.jar -t mysql -o c:\temp\mantis\library -host
192.168.x.yyy -db mantisdb -u username -p dbpassword -cp C:\temp\mantis\mysql\mysql-con
nector-java-3.1.12-bin.jar
Using database properties:
    [schemaSpy.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties
Connected to MySQL - 4.1.12a-nt

Gathering schema details...........................(0sec)
Writing/graphing summary.......(2sec)
Writing/graphing results...........................(0sec)
Wrote relationship details of 27 tables/views to directory 'c:\temp\mantis\libra
ry' in 3 seconds.
Start with c:\temp\mantis\library\index.html

But again: How do I get the relationships???

BTW: fabFORCE offers a free DBDesigner - unfortunately, the "reverse engineering"-part doesn't produce a usable relationsship-map :wink:

Some days later:
Even the MicroOLAP Database Designer for MySQL v.1.8.8 (build 238) in his 30day-trial-version doesn't create the references as it should be.

john.currier · Post by **john.currier** » 04 Apr 2006, 03:36

PatPowerMan, did you ever find the relationship information? The default MySQL storage engine, MyISAM, doesn't have real foreign key relationships, so you can't 'find the relationships information' if it doesn't exist. SchemaSpy will attempt to find the implied relationships for these types of databases, but only if the columns are named something meaningful (i.e. not ID).

John - SchemaSpy author