set names utf8;

CREATE DATABASE cody DEFAULT CHARSET=utf8;
USE cody;
grant all privileges on cody.* to 'cody'@'localhost';
grant all privileges on cody.* to 'cody'@'%';



--
-- Databank: `cody`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `websites`
--

CREATE TABLE IF NOT EXISTS `websites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `version` char(100) NOT NULL,
  `defaultlanguage` varchar(2) NOT NULL,
  `dbuser` varchar(100) NOT NULL,
  `dbpassword` varchar(100) NOT NULL,
  `dbhost` varchar(100) NOT NULL,
  `datapath` varchar(200) NOT NULL,
  `db` varchar(100) NOT NULL,
   `active` char(1) NOT NULL,
   `ownerconfirmed` char(1) NOT NULL,
   `hostname` varchar(100) NOT NULL
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

create unique index nameIndex on cody.websites(name);
