CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` int(11) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `force_reset` tinyint(1) DEFAULT NULL,
  `permissions` longtext NOT NULL,
  `super` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `activity` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `contact_name` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(15) DEFAULT NULL,
  `contact_fax` varchar(15) DEFAULT NULL,
  `contact_mobile` varchar(15) DEFAULT NULL,
  `contact_position` varchar(255) DEFAULT NULL,
  `address_to` varchar(255) DEFAULT NULL,
  `address_line_1` varchar(255) DEFAULT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `address_line_3` varchar(255) DEFAULT NULL,
  `address_suburb` varchar(255) DEFAULT NULL,
  `address_post_code` int(4) unsigned zerofill DEFAULT NULL,
  `address_state` varchar(20) DEFAULT NULL,
  `address_country` varchar(255) DEFAULT 'Australia',
  PRIMARY KEY (`id`),
  UNIQUE KEY `contact_email` (`contact_email`),
  KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;