diff options
| author | 2013-04-14 19:26:52 +0200 | |
|---|---|---|
| committer | 2013-04-14 19:26:52 +0200 | |
| commit | e58fb411f928f9000351e802f7e35c159735bdd7 (patch) | |
| tree | 8c231681bbb6e8760da75087d4da495274672100 /freshrss.sql | |
| parent | 8c2c5d287d5ac08aa9d0a3fb3d353ea7a18c92c3 (diff) | |
Corrections fichier install.php pour qu'il soit plus portable
Diffstat (limited to 'freshrss.sql')
| -rw-r--r-- | freshrss.sql | 101 |
1 files changed, 0 insertions, 101 deletions
diff --git a/freshrss.sql b/freshrss.sql deleted file mode 100644 index b5369a7ea..000000000 --- a/freshrss.sql +++ /dev/null @@ -1,101 +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, - `priority` int(2) NOT NULL DEFAULT '10', - `pathEntries` varchar(500) DEFAULT NULL, - `httpAuth` varchar(500) DEFAULT NULL, - `error` int(1) NOT NULL DEFAULT '0', - 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 */; |
