Changeset 69

Show
Ignore:
Timestamp:
2007-11-30 17:55:12 (4 years ago)
Author:
hannes
Message:

a few minor clarifications in the database definition

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/db/spamboard.sql

    r60 r69  
    4848  poster VARCHAR(255) NOT NULL, 
    4949  post TEXT NOT NULL, 
    50   ip VARCHAR(255) NOT NULL, 
     50  ip VARCHAR(16) NOT NULL, 
    5151  attachment VARCHAR(255) NOT NULL, 
    5252  postedbymember INTEGER NOT NULL, 
    53   edited datetime DEFAULT NULL, 
     53  edited DATETIME DEFAULT NULL, 
    5454  editedby VARCHAR(255) DEFAULT NULL, 
    55   posttime datetime NOT NULL, 
     55  posttime DATETIME NOT NULL, 
    5656  PRIMARY KEY  (postid) 
    5757); 
    …… 
    8787  memberhomepage VARCHAR(255) NULL, 
    8888  memberavatar VARCHAR(255) NOT NULL DEFAULT 'images/spacer.gif', 
    89   memberpassword TEXT NOT NULL, 
     89  memberpassword VARCHAR(255) NOT NULL, 
    9090  memberstatus VARCHAR(255) NOT NULL, 
    9191  memberposts INTEGER NOT NULL DEFAULT 0,