Results 1 to 2 of 2

Thread: new table for a new extension

  1. #1
    New user
    Join Date
    01-17-12.
    Posts
    17

    Default new table for a new extension

    I'm developing a new extension.
    In this extension I add some fields to existing tables and 2 new tables.
    When I upgrade the database, it tells me that the 2 new tables do not exist and try to recreate.

    This is the code:
    Code:
    -- 
    -- Table `tl_news`
    -- 
    
    CREATE TABLE `tw_message` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `pid` int(10) unsigned NOT NULL default '0',
      `tstamp` int(10) unsigned NOT NULL default '0',
      `title` varchar(255) NOT NULL default '',
      `alias` varbinary(128) NOT NULL default '',
      `author` int(10) unsigned NOT NULL default '0',
      `date` int(10) unsigned NOT NULL default '0',
      `time` int(10) unsigned NOT NULL default '0',
      `text` mediumtext NULL,
      `published` char(1) NOT NULL default '',
      `start` varchar(10) NOT NULL default '',
      `stop` varchar(10) NOT NULL default '',
      PRIMARY KEY  (`id`),
      KEY `pid` (`pid`),
      KEY `alias` (`alias`)
    ) ENGINE=MyISAM default CHARSET=utf8;
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table `tl_news_archive`
    -- 
    
    CREATE TABLE `tw_message_archive` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `tstamp` int(10) unsigned NOT NULL default '0',
      `title` varchar(255) NOT NULL default '',
      `member_group` blob NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  2. #2
    Experienced user
    Join Date
    06-20-09.
    Posts
    1,311

    Default Re: new table for a new extension

    Try DEFAULT instead of default in tw_message.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •