# Put this in your MySQL database by running 
# mysql -u<user> -p<password> -h<host> <database> < samba.sql

create table winsam (
	logon_time int(9),
	logoff_time int(9),
	kickoff_time int(9),
	pass_last_set_time int(9),
	pass_can_change_time int(9),
	pass_must_change_time int(9),
	username varchar(255) binary not null,
	domain varchar(255),
	nt_username varchar(255),
	nt_fullname varchar(255),
	home_dir varchar(255),
	dir_drive varchar(4),
	logon_script varchar(255),
	profile_path varchar(255),
	acct_desc varchar(255),
	workstations varchar(255),
	unknown_str varchar(255),
	munged_dial varchar(255),
	uid int(9),
	gid int(9),
	user_sid varchar(255) not null,
	group_sid varchar(255),
	lm_pw varchar(255),
	nt_pw varchar(255),
	acct_ctrl int(9),
	unknown_3 int(9),
	logon_divs int(9),
	hours_len int(9),
	unknown_5 int(9),
	unknown_6 int(9) default "1260",
	bad_password_count int(9),
	logon_count int(9),
	logon_hours int(9),
	unique (username), unique (user_sid)
);