Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt November 11, 2024
JavaGenius Posted February 19, 2007 Posted February 19, 2007 Dear IPSAs a licensed user of the IPB. Will I have an access to the source code of the product so that I can enhance it?And will you give me the EER for its database, so I can use it?Best Regards
stobbo Posted February 19, 2007 Posted February 19, 2007 If you purchase the Standard or Business License you will have the source code, however if you use the free license which comes with IPS Hosting you do not get the source code.
JavaGenius Posted February 19, 2007 Posted February 19, 2007 Enhanced Entity Relationship... which is the design that shows you the tables (entities) of the database and the relationships between them.
C_ind Posted February 19, 2007 Posted February 19, 2007 I haven't seen an EER made available for the IPB database anywhere.
JavaGenius Posted February 20, 2007 Posted February 20, 2007 Why they don not provide it? at least the database scheme!!
Strange_Will Posted February 20, 2007 Posted February 20, 2007 Why they don not provide it? at least the database scheme!!Get it, install it, evaluate the database.It's not that many tables, nor that complicated to figure out, just time consuming :P
bfarber Posted February 20, 2007 Posted February 20, 2007 The database scheme can be seen under install/sql/mysql_tables.phpMySQL doesn't have much relationship support between tables (at least prior to version 5), and we don't use Foreign Keys at all, so I'm not really sure what you are looking for. If you're just looking for an understanding of what each table is for and what is stored in each table, I'm afraid that is beyond the scope of our support - but if you're skilled at programming/database usage (which it sounds like you are) it shouldn't take much effort to either (1) look through the database and get an idea of what is stored where, or (2) Ask on IPS Beyond for some specifics to what you are trying to understand.
C_ind Posted February 20, 2007 Posted February 20, 2007 Even though there are no foreign keys, there are still columns that refer to the same thing in several tables, for instance topic id is referenced in 5-10 different tables. If you need to convert your board to IPB, and there's no direct route, then an ER could be useful. It could also be useful for those wanting to import posts or members from another board, the expiremental stuff in other words. But I agree it's a bit outside of your area of responsibility.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.