[WF-General] libCirce

Oliver White ojw at iinet.net.au
Thu Oct 5 08:39:10 PDT 2000


Tess Snider wrote:

> Sure.  I'd like to keep the player table, for starters, just for stuff
> that will be used by all types of games.  I should probably show you what
> we've got so far:
>
> CREATE TABLE PLAYER (
>   PLAYER_ID         INTEGER PRIMARY KEY AUTO_INCREMENT,
>   LOGIN_NAME        VARCHAR(50) NOT NULL,
>   PASSWORD          CHAR(13) NOT NULL,
>   EMAIL             VARCHAR(255),
>   IS_ADMIN          TINYINT DEFAULT '0', -- that's a boolean to you
>   STATUS            VARCHAR(16),
>   ADMIN_MEMO        VARCHAR(255),
>   LAST_LOGIN        DATETIME,
>   LAST_IP           VARCHAR(16)
> )

What does 'STATUS' signify?





More information about the General mailing list