alumni.sql

alumini based system

drop database if exists alumni; 
create database alumni;
use alumni;

CREATE TABLE login (
user_name varchar(20) NOT NULL default '0',
user_password varchar(20) NOT NULL default '0',
primary key (user_name)
) TYPE=MyISAM;

insert into login values('admin','admin');

CREATE TABLE alumni (
user_index int(5) NOT NULL auto_increment,
name varchar(200) NOT NULL default '',
email varchar(200) NOT NULL default '',
country varchar(200) NOT NULL default '0',
address varchar(64) NOT NULL default '',
department varchar(20) NOT NULL default '',
year int(4),
PRIMARY KEY  (user_index)
) TYPE=MyISAM;