IP : 3.133.131.32Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
./
./
var/
softaculous/
tangobb/
../
odm/
../
omeka/
../
spip/
spip.sql/
/
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 */;
-- -- Table structure for table `[[dbprefix]]_groupes_mots` --
CREATE TABLE `[[dbprefix]]_groupes_mots` ( `id_groupe` bigint(21) NOT NULL AUTO_INCREMENT, `titre` text NOT NULL, `descriptif` text NOT NULL, `texte` longtext NOT NULL, `unseul` varchar(3) NOT NULL DEFAULT '', `obligatoire` varchar(3) NOT NULL DEFAULT '', `tables_liees` text NOT NULL, `minirezo` varchar(3) NOT NULL DEFAULT '', `comite` varchar(3) NOT NULL DEFAULT '', `forum` varchar(3) NOT NULL DEFAULT '', `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id_groupe`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]_mots` --
CREATE TABLE `[[dbprefix]]_mots` ( `id_mot` bigint(21) NOT NULL AUTO_INCREMENT, `titre` text NOT NULL, `descriptif` text NOT NULL, `texte` longtext NOT NULL, `id_groupe` bigint(21) NOT NULL DEFAULT '0', `type` text NOT NULL, `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id_mot`), KEY `id_groupe` (`id_groupe`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]_paquets` --
CREATE TABLE `[[dbprefix]]_paquets` ( `id_paquet` bigint(21) NOT NULL AUTO_INCREMENT, `id_plugin` bigint(21) NOT NULL, `prefixe` varchar(48) NOT NULL DEFAULT '', `logo` varchar(255) NOT NULL DEFAULT '', `version` varchar(24) NOT NULL DEFAULT '', `version_base` varchar(24) NOT NULL DEFAULT '', `compatibilite_spip` varchar(24) NOT NULL DEFAULT '', `branches_spip` varchar(255) NOT NULL DEFAULT '', `description` text NOT NULL, `auteur` text NOT NULL, `credit` text NOT NULL, `licence` text NOT NULL, `copyright` text NOT NULL, `lien_doc` text NOT NULL, `lien_demo` text NOT NULL, `lien_dev` text NOT NULL, `etat` varchar(16) NOT NULL DEFAULT '', `etatnum` int(1) NOT NULL DEFAULT '0', `dependances` text NOT NULL, `procure` text NOT NULL, `date_crea` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `id_depot` bigint(21) NOT NULL DEFAULT '0', `nom_archive` varchar(255) NOT NULL DEFAULT '', `nbo_archive` int(11) NOT NULL DEFAULT '0', `maj_archive` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `src_archive` varchar(255) NOT NULL DEFAULT '', `traductions` text NOT NULL, `actif` varchar(3) NOT NULL DEFAULT 'non', `installe` varchar(3) NOT NULL DEFAULT 'non', `recent` int(2) NOT NULL DEFAULT '0', `maj_version` varchar(255) NOT NULL DEFAULT '', `superieur` varchar(3) NOT NULL DEFAULT 'non', `obsolete` varchar(3) NOT NULL DEFAULT 'non', `attente` varchar(3) NOT NULL DEFAULT 'non', `constante` varchar(30) NOT NULL DEFAULT '', `signature` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`id_paquet`), KEY `id_plugin` (`id_plugin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]_syndic_articles` --
CREATE TABLE `[[dbprefix]]_syndic_articles` ( `id_syndic_article` bigint(21) NOT NULL AUTO_INCREMENT, `id_syndic` bigint(21) NOT NULL DEFAULT '0', `titre` text NOT NULL, `url` text NOT NULL, `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lesauteurs` text NOT NULL, `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `statut` varchar(10) NOT NULL DEFAULT '0', `descriptif` text NOT NULL, `lang` varchar(10) NOT NULL DEFAULT '', `url_source` tinytext NOT NULL, `source` tinytext NOT NULL, `tags` text NOT NULL, `raw_data` text NOT NULL, `raw_format` tinytext NOT NULL, `raw_methode` tinytext NOT NULL, PRIMARY KEY (`id_syndic_article`), KEY `id_syndic` (`id_syndic`), KEY `statut` (`statut`), KEY `url` (`url`(255)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]_visites_articles` --
CREATE TABLE `[[dbprefix]]_visites_articles` ( `date` date NOT NULL, `id_article` int(10) unsigned NOT NULL, `visites` int(10) unsigned NOT NULL DEFAULT '0', `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`date`,`id_article`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!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 */;