install/mysql.sql

   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;