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

Fixed a couple odd issues with base.sql, and synced veekun's database to match it.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • veekun/trunk/script/base.sql

    r289 r290  
    5353  threadct int(10) unsigned NOT NULL default '0', 
    5454  postct int(10) unsigned NOT NULL default '0', 
    55   flags set('header') default NULL, 
     55  flags set('header') NOT NULL, 
    5656  accessibility enum('normal','locked','archive','hidden') NOT NULL default 'normal', 
    5757  blurb varchar(255) NOT NULL default '', 
    … …  
    157157  `subject` varchar(48) NOT NULL default 'Untitled Thread', 
    158158  blurb varchar(96) NOT NULL default '', 
    159   firstpostid int(10) unsigned NOT NULL default '0', 
    160   lastpostid int(10) unsigned NOT NULL default '0', 
     159  firstpostid int(10) unsigned NOT NULL, 
     160  lastpostid int(10) unsigned NOT NULL, 
    161161  lasttime int(10) unsigned NOT NULL default '0', 
    162162  postct int(10) unsigned NOT NULL default '0', 
    … …  
    214214  id int(10) unsigned NOT NULL auto_increment, 
    215215  `name` varchar(20) NOT NULL default '', 
    216   `password` varchar(40) NOT NULL default '', 
     216  `password` varchar(40) NOT NULL, 
    217217  joindate int(10) unsigned NOT NULL default '0', 
    218218  lastactive int(10) unsigned NOT NULL default '0',