Connect the GGCE database from GG-USDA website
GG-CE is the user interface for curators and genebank staffs, and we still need a website for seed request and data search.
Therefore, we decide to us the GG-website (2.0.5.2) connect to the GG database as the user website. But, during we were trying the way, we found that, the schema and content of the database build with the GG-CE API server might be some different between the database build with the GG updater. For example, the column “modified_date” and created_date” are not exist in the table “web_user” in GG-CE version, but is necessary for the GG website. Also some content in the tabale “sys_dataview” and relate content in other data table are not exist.
Because of these different pair with GG-CE database and GG-USDA database, I guess the database build by GG updater is more complete rather than the database build by the GGCE SPI server. Then I try the other way to build the database is to create the database by GG updater in a windows computer, and dump the database then recover it into the Linux server where we need. After that I tried to run the GGCE API server but it cannot normally run.
Is there any idea to solve this or any experience about connect the database with the GG-USDA website?