[Arianne-commits] marauroa/src/marauroa/server marauroa_init.sql, 1.11, 1.12

[Miguel A. B. L. <ari...@us...>]

Update of /cvsroot/arianne/marauroa/src/marauroa/server
In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv20427/server

Modified Files:
	marauroa_init.sql 
Log Message:
Improved new database.
Added test cases.
Player test cases passed. :)

Index: marauroa_init.sql
===================================================================
RCS file: /cvsroot/arianne/marauroa/src/marauroa/server/marauroa_init.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** marauroa_init.sql	1 Feb 2007 18:29:54 -0000	1.11
--- marauroa_init.sql	2 Feb 2007 19:40:56 -0000	1.12
***************
*** 1,4 ****
  create table if not exists account
!   {
    id integer auto_increment not null,
    username varchar(32) not null,
--- 1,4 ----
  create table if not exists account
!   (
    id integer auto_increment not null,
    username varchar(32) not null,
***************
*** 8,13 ****
    timedate timestamp,
    status ENUM('active','banned') not null default 'active',
!   
!   primary key(id)
    )
    TYPE=INNODB;
--- 8,14 ----
    timedate timestamp,
    status ENUM('active','banned') not null default 'active',
! 
!   primary key(username),
!   key(id)
    )
    TYPE=INNODB;