SQL dump of CodeIgniter ion-auth extension for SQLITE database

ion_auth.sqlite.sql

DROP TABLE IF EXISTS `groups`;

--
-- Table structure for table 'groups'
--

CREATE TABLE `groups` (
  `id` integer NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
);

--
-- Dumping data for table 'groups'
--

INSERT INTO `groups` (`id`, `name`, `description`) VALUES(1,'admin','Administrator');
INSERT INTO `groups` (`id`, `name`, `description`) VALUES(2,'members','General User');



DROP TABLE IF EXISTS `users`;

--
-- Table structure for table 'users'
--

CREATE TABLE `users` (
  `id` integer NOT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(80) NOT NULL,
  `salt` varchar(40) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` integer DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` integer NOT NULL,
  `last_login` integer DEFAULT NULL,
  `active` integer DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
);


--
-- Dumping data for table 'users'
--

INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES     ('1','0x7f000001','administrator','59beecdf7fc966e2f17fd8f65a4a9aeb09d4a3d4','9462e8eee0','admin@admin.com','',NULL,'1268889823','1268889823','1', 'Admin','istrator','ADMIN','0');


DROP TABLE IF EXISTS `users_groups`;

--
-- Table structure for table 'users_groups'
--

CREATE TABLE `users_groups` (
  `id` integer NOT NULL,
  `user_id` integer NOT NULL,
  `group_id` integer NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE INDEX `fk_users_groups_users1_idx`  ON `users_groups`(`user_id`);
CREATE INDEX `fk_users_groups_groups1_idx` ON `users_groups`(`group_id`);

INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES (1,1,1);
INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES (2,1,2);


DROP TABLE IF EXISTS `login_attempts`;

--
-- Table structure for table 'login_attempts'
--

CREATE TABLE `login_attempts` (
  `id` integer NOT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` integer DEFAULT NULL,
  PRIMARY KEY (`id`)
);