<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi Thejani,<br>
      <br>
      check the tables "CMS_OFFLINECONTENTS" and "CMS_CONTENTS". It
      could be also useful to check the tables: "CMS_OFFLINE_STRUCTURE"
      and "CMS_ONLINE_STRUCTURE" <br>
      <br>
      I hope this helps you.<br>
      <br>
      Kind regards<br>
      Antonio Cordeddu<br>
      <br>
      <br>
      On 31/05/2016 07:32, Thejani Warunika wrote:<br>
    </div>
    <blockquote
cite="mid:CACMdHJ19TSQNWSJRz9YtGB-+_DUjxMpbapru0aaL+CZg-UwU2g@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hi,
        <div><br>
        </div>
        <div>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. </div>
        <div><br>
        </div>
        <div>Thanks in advance,</div>
        <div>Thejani.</div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Mon, May 30, 2016 at 4:21 PM,
          Antonio Cordeddu <span dir="ltr"><<a
              moz-do-not-send="true"
              href="mailto:antoniocordeddu@coranto.it" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:antoniocordeddu@coranto.it">antoniocordeddu@coranto.it</a></a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000">
              <div>Hi Thejani,<br>
                <br>
                you can find a database overview at this <a
                  moz-do-not-send="true"
                  href="http://www.opencms.org/en/modules/downloads/dl_docapi_7.0.html"
                  target="_blank">link</a>. It's about version 7, but
                yet useful. You can also compare that with the tables on
                your MySQL database OpenCms installation.<br>
                <br>
                Kind regards<br>
                Antonio Cordeddu<br>
                <br>
                <pre cols="72">_______________________________________________
Coranto informatica di Antonio Cordeddu
Via Torricelli, 9 09047 Selargius (CA) - Italy
<a moz-do-not-send="true" href="mailto:antoniocordeddu@coranto.it" target="_blank">antoniocordeddu@coranto.it</a>
Skype: antonio.cordeddu
<a moz-do-not-send="true" href="http://www.coranto.it" target="_blank">http://www.coranto.it</a>
_______________________________________________</pre>
                <div>
                  <div class="h5"> <br>
                    <br>
                    <br>
                    On 30/05/2016 11:35, Thejani Warunika wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <div dir="ltr">Hi there,
                      <div><br>
                      </div>
                      <div>Can anyone please update me on this?</div>
                      <div><br>
                      </div>
                      <div>Thanks</div>
                    </div>
                    <div class="gmail_extra"><br>
                      <div class="gmail_quote">On Sat, May 28, 2016 at
                        2:18 PM, Thejani Warunika <span dir="ltr"><<a
                            moz-do-not-send="true"
                            href="mailto:sanda.warunika12@gmail.com"
                            target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:sanda.warunika12@gmail.com">sanda.warunika12@gmail.com</a></a>></span>
                        wrote:<br>
                        <blockquote class="gmail_quote" style="margin:0
                          0 0 .8ex;border-left:1px #ccc
                          solid;padding-left:1ex">
                          <div dir="ltr">Hi all,
                            <div><br>
                            </div>
                            <div>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. <span><font color="#888888"><br
                                    clear="all">
                                  <div><br>
                                  </div>
                                  -- <br>
                                  <div data-smartmail="gmail_signature"><font
                                      face="Courier New"><strong><em>Thanking
                                          You,<br>
                                        </em><br>
                                      </strong><em><strong>With Best
                                          Regard,<br>
                                          <br>
                                        </strong><span
                                          style="BACKGROUND-COLOR:rgb(255,255,255)"><strong>Thejani
                                            Warunika</strong>.</span><br>
                                      </em><br>
                                    </font></div>
                                </font></span></div>
                          </div>
                        </blockquote>
                      </div>
                      <br>
                      <br clear="all">
                      <div><br>
                      </div>
                      -- <br>
                      <div data-smartmail="gmail_signature"><font
                          face="Courier New"><strong><em>Thanking You,<br>
                            </em><br>
                          </strong><em><strong>With Best Regard,<br>
                              <br>
                            </strong><span
                              style="BACKGROUND-COLOR:rgb(255,255,255)"><strong>Thejani
                                Warunika</strong>.</span><br>
                          </em><br>
                        </font></div>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                  </div>
                </div>
                <pre>_______________________________________________
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
<a moz-do-not-send="true" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>



</pre>
              </blockquote>
              <br>
              <p><br>
              </p>
            </div>
            <br>
            _______________________________________________<br>
            This mail is sent to you from the opencms-dev mailing list<br>
            To change your list options, or to unsubscribe from the
            list, please visit<br>
            <a moz-do-not-send="true"
              href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev"
              rel="noreferrer" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
            <br>
            <br>
            <br>
            <br>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        <div class="gmail_signature" data-smartmail="gmail_signature"><font
            face="Courier New"><strong><em>Thanking You,<br>
              </em><br>
            </strong><em><strong>With Best Regard,<br>
                <br>
              </strong><span style="BACKGROUND-COLOR:rgb(255,255,255)"><strong>Thejani
                  Warunika</strong>.</span><br>
            </em><br>
          </font></div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>



</pre>
    </blockquote>
    <br>
    <p><br>
    </p>
    <pre class="moz-signature" cols="72">-- 
_______________________________________________
Coranto informatica di Antonio Cordeddu
Via Torricelli, 9 09047 Selargius (CA) - Italy
Phone: +39 070 8607521
Fax: +39 070 8607521
Mobile: +39 328 7552662
<a class="moz-txt-link-abbreviated" href="mailto:antoniocordeddu@coranto.it">antoniocordeddu@coranto.it</a>
Skype: antonio.cordeddu
<a class="moz-txt-link-freetext" href="http://www.coranto.it">http://www.coranto.it</a>
_______________________________________________</pre>
  </body>
</html>