Jump to content

Does anyone have a schema for the custom databases?


Go to solution Solved by Marc Stridgen,

Recommended Posts

12 hours ago, Marc Stridgen said:

Is there a reason you are not using the interface to do this?

Not sure what you mean.  I created the database and fields with the interface.  I have a log file I want to show on my forum.  My code writes the log files to the database directly. 

12 hours ago, Marc Stridgen said:

We are unable to assist with changes directly in the database unfortunately.

I will look into other methods to import the data directly then.  Thank you.

Link to comment
Share on other sites

No problem. I would suggest using a separate table for your logs, and referencing the main table. It saves you then causing issues with the main database, which will likely correct "issues" each upgrade, and could well wipe your data on columns added manually

Link to comment
Share on other sites

  • 2 weeks later...
On 4/1/2022 at 1:56 AM, Marc Stridgen said:

No problem. I would suggest using a separate table for your logs, and referencing the main table. It saves you then causing issues with the main database, which will likely correct "issues" each upgrade, and could well wipe your data on columns added manually

I create a custom database and the needed columns from the interface.   I do not modify the table or column definitions - just read and write records.    The log itself is the data for the table.  

Learning a lot... thanks.

Link to comment
Share on other sites

3 hours ago, MartinLawrence said:

Thought I would update in case anyone found this thread via a similar problem.

Under System, Site Features I discovered the API, which will allow me to add records to the database without accessing it directly.  

💫

Ah, that would have been the answer to the question of why you were needing to add things directly. You were trying to add records 🙂 Glad you have what you need there.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...