[wpdev-commits] xmlscripts accounts.sql,1.1,1.2

[<dr...@us...>]

Update of /cvsroot/wpdev/xmlscripts
In directory sc8-pr-cvs1:/tmp/cvs-serv22939

Modified Files:
	accounts.sql 
Log Message:
Hmm unique logins might be useful...

Index: accounts.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/accounts.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** accounts.sql	9 Sep 2003 23:20:33 -0000	1.1
--- accounts.sql	10 Sep 2003 18:00:18 -0000	1.2
***************
*** 1,9 ****
! CREATE TABLE accounts (
! 	login varchar(255) NOT NULL default '',
! 	password varchar(255) NOT NULL default '',
! 	flags int NOT NULL default '0',
! 	acl varchar(255) NOT NULL default 'player',
! 	lastlogin int NOT NULL default '',
! 	blockuntil int NOT NULL default '',
! 	PRIMARY KEY (login)
! );
--- 1,10 ----
! CREATE TABLE `accounts` (
!   `login` varchar(255) NOT NULL default '',
!   `PASSWORD` varchar(255) NOT NULL default '',
!   `flags` int(11) NOT NULL default '0',
!   `acl` varchar(255) NOT NULL default 'player',
!   `lastlogin` int(11) NOT NULL default '0',
!   `blockuntil` int(11) NOT NULL default '0',
!   PRIMARY KEY  (`login`),
!   UNIQUE KEY `login` (`login`)
! ) TYPE=MyISAM;