# File: createdb.sql
# Script Name: vAuthenticate 3.0.1
# Author: Vincent Ryan Ong
# Email: support@beanbug.net
#
# Description:
# vAuthenticate is a revolutionary authentication script which uses
# PHP and MySQL for lightning fast processing. vAuthenticate comes 
# with an admin interface where webmasters and administrators can
# create new user accounts, new user groups, activate/inactivate 
# groups or individual accounts, set user level, etc. This may be
# used to protect files for member-only areas. vAuthenticate 
# uses a custom class to handle the bulk of insertion, updates, and
# deletion of data. This class can also be used for other applications
# which needs user authentication.
#
# This script is a freeware but if you want to give donations,
# please send your checks (coz cash will probably be stolen in the
# post office) them to:
#
# Vincent Ryan Ong
# Rm. 440 Wellington Bldg.
# 655 Condesa St. Binondo, Manila
# Philippines, 1006


#
# Table structure for table `authteam`
#

CREATE TABLE authteam (
  id int(4) NOT NULL auto_increment,
  teamname varchar(25) NOT NULL default '',
  teamlead varchar(25) NOT NULL default '',
  status varchar(10) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY teamname (teamname,teamlead)
) TYPE=MyISAM;

#
# Dumping data for table `authteam`
#

INSERT INTO authteam VALUES (1, 'Ungrouped', 'sa', 'active');
INSERT INTO authteam VALUES (2, 'Admin', 'sa', 'active');
INSERT INTO authteam VALUES (3, 'Temporary', 'sa', 'active');
INSERT INTO authteam VALUES (7, 'Group 1', 'sa', 'active');
INSERT INTO authteam VALUES (8, 'Group 2', 'test', 'active');
INSERT INTO authteam VALUES (9, 'Group 3', 'admin', 'active');