create database bbweb default character set 'utf8' default collate 'utf8_unicode_ci';

-- Hibernate Install User
GRANT ALL ON bbweb.* TO 'hib_install'@'localhost' IDENTIFIED BY 'S74BJWR65Q5LEVQGEEGBO1DEDQCXRT24';

-- Hibernate Web User
GRANT INSERT, DELETE, UPDATE ON bbweb.* TO 'hib_web'@'localhost' IDENTIFIED BY 'SH2W3QZZEAATMLU4X4LFNH2HJM8H2N26';




insert into Contact (id,version,roles,title,firstName,middleNames,surname,suffix,passwordHash,accountStatus,companyName,companyUrl,isPrimeContact,jobTitle,locale)
values (0,0,"ROLE_ADMIN","","admin","","admin","",md5("admin"),'a',"","",1,"","en_US");

insert into EmailAddress (id,version,address,contact_id,isVerified,security,isVerifyable) values (1,0,'admin',0,1,0,1);

insert into PhoneNumberType (id,version,text) values
	(100,0,"Home"), (101,0,"Business"); 

insert into AddressType (id,version,text) values
	(150,0,"Home"), (151,0,"Business"), (152,0,"Other"); 

insert into Country (id,version,text) values
	(300,0,"AUSTRALIA"),
	(301,0,"CANADA"),
	(302,0,"JAPAN"),
	(303,0,"NEW ZEALAND"),
	(304,0,"ZIMBABWE");

insert into EmailTemplate (id,version,fromAddress,subject,text) values
	(400,0,"verify@becabiz.com","Please verify your Email Address.",
	"To verify your email follow this link: ${url.verify_email}\n"
	"To never recieve any more verification EMails follow this link: ${url.verify_block_email}\n\n"
	"Regards,\nThe Team at Becabiz.");