[Lambda-cvs] lambda/database README,NONE,1.1 lambda-20040708.sql,NONE,1.1

[Ariejan de V. <ar...@us...>]

Update of /cvsroot/lambda/lambda/database
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15617/database

Added Files:
	README lambda-20040708.sql 
Log Message:
Added mysql dump for client table


--- NEW FILE: README ---
These SQL dumps are made with mysqldump. You can import them manually or by using PHPMyAdmin. 

If you create a new dump, please suffix is with the current date.

In case you receive errors during development, make sure you have the latest SQL snapshot loaded!
--- NEW FILE: lambda-20040708.sql ---
-- MySQL dump 9.10
--
-- Host: localhost    Database: lambda
-- ------------------------------------------------------
-- Server version	4.0.18

--
-- Table structure for table `client`
--

CREATE TABLE client (
  id bigint(20) unsigned NOT NULL auto_increment,
  login varchar(20) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  name varchar(200) NOT NULL default '',
  address varchar(200) default NULL,
  zipcode varchar(20) default NULL,
  city varchar(200) default NULL,
  state char(2) default NULL,
  country char(2) default NULL,
  phone varchar(20) default NULL,
  fax varchar(20) default NULL,
  email varchar(200) default NULL,
  companyname varchar(200) default NULL,
  adminflag char(1) NOT NULL default 'C',
  PRIMARY KEY  (id),
  UNIQUE KEY login (login)
) TYPE=MyISAM COMMENT='Client data';

--
-- Dumping data for table `client`
--

INSERT INTO client VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Lambda Administrator','Sondervick 35A','5505NB','Veldhoven',NULL,'NL','+31 611 316064',NULL,'web...@la...','Project Lambda','A');