[opencms-dev] OpenCms content storing in the database

[Antonio Cordeddu]

Hi Thejani,

check the tables "CMS_OFFLINECONTENTS" and "CMS_CONTENTS". It could be 
also useful to check the tables: "CMS_OFFLINE_STRUCTURE" and 
"CMS_ONLINE_STRUCTURE"

I hope this helps you.

Kind regards
Antonio Cordeddu


On 31/05/2016 07:32, Thejani Warunika wrote:
> Hi,
>
> I'm using OpenCms 10, I have gone through this diagram earlier and try 
> to find the JSP file I have created and published, using it's resource 
> ID. But I could not find it in the cms_online_resources or 
> cms_online_structure tables. Is there any other table that a resource 
> can store in OpenCms environment after publish. Please explain.
>
> Thanks in advance,
> Thejani.
>
> On Mon, May 30, 2016 at 4:21 PM, Antonio Cordeddu 
> <antoniocordeddu at coranto.it <mailto:antoniocordeddu at coranto.it>> wrote:
>
>     Hi Thejani,
>
>     you can find a database overview at this link
>     <http://www.opencms.org/en/modules/downloads/dl_docapi_7.0.html>.
>     It's about version 7, but yet useful. You can also compare that
>     with the tables on your MySQL database OpenCms installation.
>
>     Kind regards
>     Antonio Cordeddu
>
>     _______________________________________________
>     Coranto informatica di Antonio Cordeddu
>     Via Torricelli, 9 09047 Selargius (CA) - Italy
>     antoniocordeddu at coranto.it <mailto:antoniocordeddu at coranto.it>
>     Skype: antonio.cordeddu
>     http://www.coranto.it
>     _______________________________________________
>
>
>
>
>     On 30/05/2016 11:35, Thejani Warunika wrote:
>>     Hi there,
>>
>>     Can anyone please update me on this?
>>
>>     Thanks
>>
>>     On Sat, May 28, 2016 at 2:18 PM, Thejani Warunika
>>     <sanda.warunika12 at gmail.com <mailto:sanda.warunika12 at gmail.com>>
>>     wrote:
>>
>>         Hi all,
>>
>>         I am very new for OpenCms environment. I have gone through
>>         many articles about Opencms and opencms documentations. But I
>>         cound not find a proper answer for my question.Question is,
>>         If I create a template in opencms VFS as a JSP file and add
>>         some contents like an image, text, link text some number etc,
>>         where will that content stored in the mySQL database? Does
>>         all these contents stored in a same  same table or in
>>         different tables? Any idea appreciated.
>>
>>         -- 
>>         */Thanking You,
>>         /
>>         */*With Best Regard,
>>
>>         **Thejani Warunika*.
>>         /
>>
>>
>>
>>
>>     -- 
>>     */Thanking You,
>>     /
>>     */*With Best Regard,
>>
>>     **Thejani Warunika*.
>>     /
>>
>>
>>     _______________________________________________
>>     This mail is sent to you from the opencms-dev mailing list
>>     To change your list options, or to unsubscribe from the list, please visit
>>     http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>>
>>
>>
>
>
>
>     _______________________________________________
>     This mail is sent to you from the opencms-dev mailing list
>     To change your list options, or to unsubscribe from the list,
>     please visit
>     http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
>
>
>
> -- 
> */Thanking You,
> /
> */*With Best Regard,
>
> **Thejani Warunika*.
> /
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>


-- 
_______________________________________________
Coranto informatica di Antonio Cordeddu
Via Torricelli, 9 09047 Selargius (CA) - Italy
Phone: +39 070 8607521
Fax: +39 070 8607521
Mobile: +39 328 7552662
antoniocordeddu at coranto.it
Skype: antonio.cordeddu
http://www.coranto.it
_______________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20160531/bdab7150/attachment.htm>