|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا |
#1
| ||
| ||
OK...I've got a few MISSING items in my database. Caused by a hard drive crash and a backup that is not as good as I thought it was. I need to do some fixing...... Take the "contenttype" as an example. When I look down my list of tables in phpmyadmin it is not there. But when I look on my server it's there. So...inside of schema I see this: Quote: $schema['CREATE']['query']['contenttype'] = " CREATE TABLE " . TABLE_PREFIX . "contenttype ( contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT, class VARBINARY(50) NOT NULL, packageid INT UNSIGNED NOT NULL, canplace ENUM('0','1') NOT NULL DEFAULT '0', cansearch ENUM('0','1') NOT NULL DEFAULT '0', cantag ENUM('0','1') DEFAULT '0', canattach ENUM('0','1') DEFAULT '0', isaggregator ENUM('0', '1') NOT NULL DEFAULT '0', PRIMARY KEY (contenttypeid), UNIQUE KEY packageclass (packageid, class) ) ENGINE = $hightrafficengine "; $schema['CREATE']['explain']['contenttype'] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "contenttype"); How do I take that info...and convert it into a QUERY that I can run in PHPMYADMIN and re-make this table? I realize that this is totally an easy thing for some.....but for me...I'm learning...and I gotta ask to be able to learn....so I thank you in advance for your help. Yours, Kirk __DEFINE_LIKE_SHARE__ |
![]() |
مواقع النشر (المفضلة) |
| |
![]() | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Help understanding "Edit Moderator (name) for forum (forum name)" | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-15-2012 08:00 AM |
VB 3.8 SQL Schema/Diagram/other Documentation | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-11-2010 06:30 PM |
Forum Help with understanding database error. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-21-2010 03:04 PM |
Forum Help with understanding database error. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-21-2010 02:40 PM |
Database Schema for 3.8? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 12-02-2009 05:30 AM |