aboutsummaryrefslogtreecommitdiff
path: root/freshrss.sql
diff options
context:
space:
mode:
authorGravatar Marien Fressinaud <dev@marienfressinaud.fr> 2013-04-17 19:45:16 +0200
committerGravatar Marien Fressinaud <dev@marienfressinaud.fr> 2013-04-17 19:45:16 +0200
commitae7c9787cd8afd4313d356c6525e40d4ce79f99b (patch)
treedbac8b756486c5266e914026ef5a679002d0eb85 /freshrss.sql
parent044908439bdd7280f7539e12441d7dfa6c4d4c63 (diff)
parent23dd73ddeec2473c3e8a3c517317e074ac53a1d8 (diff)
Merge branch 'releases'0.2.0
Diffstat (limited to 'freshrss.sql')
-rw-r--r--freshrss.sql99
1 files changed, 0 insertions, 99 deletions
diff --git a/freshrss.sql b/freshrss.sql
deleted file mode 100644
index 3bd680a18..000000000
--- a/freshrss.sql
+++ /dev/null
@@ -1,99 +0,0 @@
--- phpMyAdmin SQL Dump
--- version 3.5.7
--- http://www.phpmyadmin.net
---
--- Client: localhost
--- Généré le: Dim 17 Mars 2013 à 15:21
--- Version du serveur: 5.5.30
--- Version de PHP: 5.4.12
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-SET time_zone = "+00:00";
-
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-
---
--- Base de données: `freshrss`
---
-
--- --------------------------------------------------------
-
---
--- Structure de la table `category`
---
-
-CREATE TABLE IF NOT EXISTS `category` (
- `id` varchar(6) NOT NULL,
- `name` varchar(255) NOT NULL,
- `color` varchar(7) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `entry`
---
-
-CREATE TABLE IF NOT EXISTS `entry` (
- `id` varchar(6) NOT NULL,
- `guid` text NOT NULL,
- `title` varchar(255) NOT NULL,
- `author` varchar(255) NOT NULL,
- `content` text NOT NULL,
- `link` text NOT NULL,
- `date` int(11) NOT NULL,
- `is_read` int(11) NOT NULL,
- `is_favorite` int(11) NOT NULL,
- `is_public` int(1) NOT NULL,
- `id_feed` varchar(6) NOT NULL,
- `annotation` text NOT NULL,
- `tags` text NOT NULL,
- `lastUpdate` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `id_feed` (`id_feed`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `feed`
---
-
-CREATE TABLE IF NOT EXISTS `feed` (
- `id` varchar(6) NOT NULL,
- `url` text NOT NULL,
- `category` varchar(6) DEFAULT '000000',
- `name` varchar(255) NOT NULL,
- `website` text NOT NULL,
- `description` text NOT NULL,
- `lastUpdate` int(11) NOT NULL,
- `pathEntries` varchar(500) DEFAULT NULL,
- `httpAuth` varchar(500) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `category` (`category`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Contraintes pour les tables exportées
---
-
---
--- Contraintes pour la table `entry`
---
-ALTER TABLE `entry`
- ADD CONSTRAINT `entry_ibfk_1` FOREIGN KEY (`id_feed`) REFERENCES `feed` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Contraintes pour la table `feed`
---
-ALTER TABLE `feed`
- ADD CONSTRAINT `feed_ibfk_4` FOREIGN KEY (`category`) REFERENCES `category` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
-
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;