[github/wallabag/wallabag.git] / install / mysql.sql

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `is_read` tinyint(1) NOT NULL,
  `is_fav` tinyint(1) NOT NULL,
  `content` blob NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `name` int(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `users_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
Commit	Line	Data
580d60b9 NL	1	CREATE TABLE IF NOT EXISTS `config` (
	2	`id` int(11) NOT NULL AUTO_INCREMENT,
	3	`name` varchar(255) NOT NULL,
	4	`value` varchar(255) NOT NULL,
	5	PRIMARY KEY (`id`)
	6	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
	7
	8	CREATE TABLE IF NOT EXISTS `entries` (
	9	`id` int(11) NOT NULL AUTO_INCREMENT,
	10	`title` varchar(255) NOT NULL,
	11	`url` varchar(255) NOT NULL,
	12	`is_read` tinyint(1) NOT NULL,
	13	`is_fav` tinyint(1) NOT NULL,
	14	`content` blob NOT NULL,
	15	`user_id` int(11) NOT NULL,
	16	PRIMARY KEY (`id`)
	17	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
	18
	19	CREATE TABLE IF NOT EXISTS `users` (
	20	`id` int(11) NOT NULL AUTO_INCREMENT,
	21	`username` varchar(255) NOT NULL,
	22	`password` varchar(255) NOT NULL,
	23	`name` int(255) NOT NULL,
	24	`email` varchar(255) NOT NULL,
	25	PRIMARY KEY (`id`)
	26	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
	27
	28	CREATE TABLE IF NOT EXISTS `users_config` (
	29	`id` int(11) NOT NULL AUTO_INCREMENT,
	30	`user_id` int(11) NOT NULL,
	31	`name` varchar(255) NOT NULL,
	32	`value` varchar(255) NOT NULL,
	33	PRIMARY KEY (`id`)
	34	) ENGINE=InnoDB DEFAULT CHARSET=latin1;