#!/bin/sh

exec <email.list

while read Line; do
	IFS=":"
	set $Line
	echo insert into users \(username\,firstname\,lastname\,email\) values \(\"${3}\"\,\"${1}\"\,\"${2}\"\,\"${3}\"\)\;


done