Announcement

Collapse
No announcement yet.

I have deleted pmtext table by fault

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • I have deleted pmtext table by fault

    Dear friends,

    I have deleted pmtext table from the database.

    How can I create again?

    I know, I have to run query but I dont know what I will write.

  • #2
    I suggest running this in phpmyadmin...
    Code:
    CREATE TABLE IF NOT EXISTS `pmtext` (
      `pmtextid` int(10) unsigned NOT NULL auto_increment,
      `fromuserid` int(10) unsigned NOT NULL default '0',
      `fromusername` varchar(100) collate latin1_general_ci NOT NULL default '',
      `title` varchar(250) collate latin1_general_ci NOT NULL default '',
      `message` mediumtext collate latin1_general_ci,
      `touserarray` mediumtext collate latin1_general_ci,
      `iconid` smallint(5) unsigned NOT NULL default '0',
      `dateline` int(10) unsigned NOT NULL default '0',
      `showsignature` smallint(5) unsigned NOT NULL default '0',
      `allowsmilie` smallint(5) unsigned NOT NULL default '1',
      PRIMARY KEY  (`pmtextid`),
      KEY `fromuserid` (`fromuserid`,`dateline`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
    Lats...

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X