Show
Ignore:
Timestamp:
08/14/07 01:45:12 (3 years ago)
Author:
eevee
Message:

Roots of an unread-post system, for testing purposes. Not done yet. (#46)

SQL to bring a table up to date: ALTER TABLE users ADD COLUMN thread_view_cutoff INT UNSIGNED NOT NULL AFTER lastactive;

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • veekun/trunk/script/base.sql

    r260 r287  
    5757  blurb varchar(255) NOT NULL default '', 
    5858  PRIMARY KEY  (id) 
    59 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     59) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
    6060 
    6161-- 
    … …  
    116116  KEY THREAD (threadid), 
    117117  KEY `USER` (userid) 
    118 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     118) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
    119119 
    120120-- 
    … …  
    165165  PRIMARY KEY  (id), 
    166166  KEY FORUMID (forumid) 
    167 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     167) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
    168168 
    169169-- 
    … …  
    205205  joindate int(10) unsigned NOT NULL default '0', 
    206206  lastactive int(10) unsigned NOT NULL default '0', 
     207  thread_view_cutoff int(10) unsigned NOT NULL, 
    207208  postct int(10) unsigned NOT NULL default '0', 
    208209  flags set('lockedsig','lockedavatar','lockedtitle') NOT NULL default '',