search

Viima / jquery-comments

The Javascript library of choice for implementing commenting in your web app
http://viima.github.io/jquery-comments/
MIT License
294 stars 118 forks source link

where can i find db structure for comment box #100

Closed prasadraja07 closed 7 years ago

prasadraja07 commented 7 years ago

Can you share the db structure for the comment plugin....so it wil be clear to implement

bluesun3k1 commented 7 years ago

I just started using this plugin a few days ago and you can't really find the db structure on here. The reason could be because the plugin allows you to customize it depending on your needs.

I for one did the following.

A table with the basic comment data such as, comment Id, parent id, page id, user Id, date created, date modified, comment content.

A table for upvotes that stores, post id, comment id, user id, vote date.

A table for downvotes (I had to implement this myself as downvoting doesn't come with the plugin).

And just joined tables as needed.

Hope those little details help.

prasadraja07 commented 7 years ago

Even i also implement same as you explained..... just i would like to compare with my db structure & @Viima ..... to ensure that i am in right path..

jessenieminen commented 7 years ago

Hi guys, sorry for the delayed answer! Here's what our comments API looks like for reference purposes. I'll add it to the documentation too.

comment api example

jessenieminen commented 7 years ago

http://viima.github.io/jquery-comments/#link-4