Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 6 Support
  4. Official Core Support - 6
  5. MySQL Data Tables

MySQL Data Tables

Asked Modified Viewed 1,062 times
Back to Forum Index Previous Topic Next Topic
Print
J
jdes
J
jdes 10
  • Junior Member, joined since
  • Contributed 40 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
asked
Junior Member

Hi,

Anyone know what data tables i need to restore to get my
original Data from a previously saved/backup database to my new
database & site for the following...
1. FAQ Data Entries
2. Photo Gallery Entries

Thanks
0 replies

2 posts

J
jdes
J
jdes 10
  • Junior Member, joined since
  • Contributed 40 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
answered
Junior Member

photo_albums

album_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_title VARCHAR(100) NOT NULL DEFAULT '',
album_info VARCHAR(200) DEFAULT '',
album_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (album_id)


photos

photo_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_title VARCHAR(100) NOT NULL DEFAULT '',
photo_date INT(10) UNSIGNED NOT NULL DEFAULT '0',
user_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_views SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (photo_id)
0 replies
J
jdes
J
jdes 10
  • Junior Member, joined since
  • Contributed 40 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
answered
Junior Member

faq_cats

faq_cat_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
faq_cat_name VARCHAR(200) NOT NULL DEFAULT '',
faq_cat_description VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY ((faq_cat_id)

faqs

faq_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
faq_cat_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
faq_question VARCHAR(200) NOT NULL DEFAULT '',
faq_answer TEXT NOT NULL,
PRIMARY KEY ((faq_id)
0 replies

Category Forum

Official Core Support - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 2 posts
  • Votes 0 votes
  • Topic users 1 member

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet