alumni.sql

来自「alumini based system」· SQL 代码 · 共 24 行

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;