sql.txt

php 報修系統

create database fix;
use fix;
create table fix(id bigint primary key auto_increment,
		name varchar(10),
		area varchar(50),
		time1 date,
		summary varchar(250),
		content text,
		time2 date,
		reply text,
		tomail int(1),
		mail varchar(20),
		kind int(1),
		end int(1));
create table auth(name varchar(12),
		  account varchar(8) primary key,
		passwd varchar(16),
		power varchar(20));

insert auth(name,account,passwd,power) values('恨瞶