Structure SQL
Table _user
| Champ | Type | Interclassement | Attributs | Null | Défaut | Extra | Notes |
| id | int(11) | | UNSIGNED | Non | | auto_increment | |
| nick | varchar(20) | utf8_general_ci | | Non | | | |
| mdp | varchar(35) | utf8_general_ci | | Non | | | |
| email1 | varchar(50) | utf8_general_ci | | Non | | | |
| email2 | varchar(50) | utf8_general_ci | | Non | | | |
| date_insc | varchar(15) | utf8_general_ci | | Non | | | |
| date_der | varchar(15) | utf8_general_ci | | Non | | | |
| ip | varchar(15) | utf8_general_ci | | Non | | | |
| rang | tinyint(3) | | UNSIGNED | Non | | | |
| valide | tinyint(1) | | UNSIGNED | Non | | | |
Nom de la clé Type Champ
PRIMARY PRIMARY id
nick INDEX nick
CREATE TABLE `iscms_user` (
`id` int(11) unsigned NOT NULL auto_increment,
`nick` varchar(20) NOT NULL,
`mdp` varchar(35) NOT NULL,
`email1` varchar(50) NOT NULL,
`email2` varchar(50) NOT NULL,
`date_insc` varchar(15) NOT NULL,
`date_der` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`rang` tinyint(3) unsigned NOT NULL,
`valide` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `nick` (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
table _referer
| Champ | Type | Interclassement | Attributs | Null | Défaut | Extra |
| id | int(11) | | UNSIGNED | Non | | auto_increment |
| dateu | varchar(15) | utf8_general_ci | | Non | | |
| ip | varchar(15) | utf8_general_ci | | Non | | |
| host | varchar(255) | utf8_general_ci | | Non | | |
| referer | varchar(255) | utf8_general_ci | | Non | | |
| site | varchar(255) | utf8_general_ci | | Non | | |
| agent | varchar(255) | utf8_general_ci | | Non | | |
| user_id | int(11) | | UNSIGNED | Non | | |
| position | tinyint(3) | | UNSIGNED | Non | | |
Nom de la clé Type Champ
PRIMARY PRIMARY id
dateu INDEX dateu
position INDEX position
CREATE TABLE `iscms_referer` (
`id` int(11) unsigned NOT NULL auto_increment,
`dateu` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`host` varchar(255) NOT NULL,
`referer` varchar(255) NOT NULL,
`site` varchar(255) NOT NULL,
`agent` varchar(255) NOT NULL,
`user_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `dateu` (`dateu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Table _module
| Champ | Type | Interclassement | Attributs | Null | Défaut | Extra |
| id | int(11) | | UNSIGNED | Non | | auto_increment |
| nom | varchar(255) | utf8_general_ci | | Non | | |
| version | varchar(255) | utf8_general_ci | | Non | | |
| rep | varchar(255) | utf8_general_ci | | Non | | |
| desc | varchar(255) | utf8_general_ci | | Non | | |
| infos | varchar(255) | utf8_general_ci | | Non | | |
| statut | tinyint(1) | | UNSIGNED | Non | | |
Nom de la clé Type Champ
PRIMARY PRIMARY id
dateu INDEX dateu
Table _article
| Champ | Type | Interclassement | Attributs | Null | Défaut | Extra | Note |
| id | int(11) | | UNSIGNED | Non | | auto_increment | |
| auteur | int(11) | | UNSIGNED | Non | | | |
| groupe | tinyint(3) | | UNSIGNED | Non | | | |
| date_crea | varchar(15) | utf8_general_ci | | Non | | | |
| date_modif | varchar(15) | utf8_general_ci | | Non | | | |
| titre | varchar(255) | utf8_general_ci | | Non | | | |
| texte | text | utf8_general_ci | | Non | | | |
| valide | tinyint(1) | | UNSIGNED | Non | | | |
Nom de la clé Type Champ
PRIMARY PRIMARY id
auteur INDEX auteur
rub INDEX rub
CREATE TABLE `iscms_article` (
`id` int(11) unsigned NOT NULL auto_increment,
`auteur` int(11) unsigned NOT NULL,
`groupe` tinyint(3) unsigned NOT NULL,
`rub` int(11) unsigned NOT NULL,
`date_crea` varchar(15) character set utf8 NOT NULL,
`date_modif` varchar(15) character set utf8 NOT NULL,
`titre` varchar(255) character set utf8 NOT NULL,
`texte` text character set utf8 NOT NULL,
`valide` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `auteur` (`auteur`),
KEY `rub` (`rub`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
(visiteur ad7)
