The avatar for @jipexu
jipexu
Published
lib
Edited
Dec 21, 2019
Importers
Insert cell
Insert cell
Insert cell
datadb = eval(
{name: "NPDS", children: [
{name:"access", desc:"Contient les types d’accès au portail (user, modérateur….)", children:[
{name:"access_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"access_title", type:"varchar(20) DEFAULT NULL", k:""}
]},
{name:"adminblock", desc:"Contient le contenu html du bloc Admin", children:[
{name:"title", type:"varchar(250) DEFAULT NULL", k:""},
{name:"content", type:"text", k:""}
]},
{name:"appli_log", desc:"Contient en autre les votes des sondages", children:[
{name:"al_id", type:"int(11) NOT NULL DEFAULT '0'", k:"KEY"},
{name:"al_name", type:"varchar(255) DEFAULT NULL", k:""},
{name:"al_subid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"al_date", type:"datetime NOT NULL DEFAULT '1000-01-01 00:00:00'", k:""},
{name:"al_uid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"al_data", type:"text", k:""},
{name:"al_ip", type:"varchar(19) NOT NULL DEFAULT ''", k:""},
{name:"al_hostname", type:"varchar(255) DEFAULT NULL", k:""}
]},
{name:"authors", desc:"Contient la liste des auteurs (administrateurs)", children:[
{name:"aid", type:"varchar(30) NOT NULL DEFAULT ''", k:"PRIMARY KEY"},
{name:"name", type:"varchar(50) DEFAULT NULL", k:""},
{name:"url", type:"varchar(60) DEFAULT NULL", k:""},
{name:"email", type:"varchar(60) DEFAULT NULL", k:""},
{name:"pwd", type:"varchar(40) DEFAULT NULL", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"radminfilem", type:"tinyint(2) NOT NULL DEFAULT '0'", k:""},
{name:"radminsuper", type:"tinyint(2) NOT NULL DEFAULT '1'", k:""}
]},
{name:"autonews", desc:"Contient la liste des articles dont l'ajout est pré-programmé", children:[
{name:"anid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"catid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"aid", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"time", type:"varchar(19) NOT NULL DEFAULT ''", k:""},
{name:"hometext", type:"text NOT NULL", k:""},
{name:"bodytext", type:"mediumtext", k:""},
{name:"topic", type:"int(3) NOT NULL DEFAULT '1'", k:""},
{name:"informant", type:"varchar(20) NOT NULL DEFAULT ''", k:""},
{name:"notes", type:"text NOT NULL", k:""},
{name:"ihome", type:"int(1) NOT NULL DEFAULT '0'", k:""},
{name:"date_debval", type:"datetime DEFAULT NULL", k:""},
{name:"date_finval", type:"datetime DEFAULT NULL", k:""},
{name:"auto_epur", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"banner", desc:"Contient la liste des bannières affichables sur le portail", children:[
{name:"bid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"imptotal", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"impmade", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"clicks", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"imageurl", type:"varchar(200) NOT NULL DEFAULT ''", k:""},
{name:"clickurl", type:"varchar(200) NOT NULL DEFAULT ''", k:""},
{name:"userlevel", type:"int(1) NOT NULL DEFAULT '0'", k:""},
{name:"date", type:"datetime DEFAULT NULL", k:""}
]},
{name:"bannerclient", desc:"Contient la liste des clients liés aux bannières (pour l'administration de celles-ci)", children:[
{name:"cid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"name", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"contact", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"login", type:"varchar(10) NOT NULL DEFAULT ''", k:""},
{name:"passwd", type:"varchar(10) NOT NULL DEFAULT ''", k:""},
{name:"extrainfo", type:"text NOT NULL", k:""}
]},
{name:"bannerfinish", desc:"Contient les infos sur les bannières (nombre de clics, date de début et de fin d’affichage…)", children:[
{name:"bid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"impressions", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"clicks", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"datestart", type:"datetime DEFAULT NULL", k:""},
{name:"dateend", type:"datetime DEFAULT NULL", k:""}
]},
{name:"catagories", desc:"Contient la liste des catégories des forums du portail", children:[
{name:"cat_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cat_title", type:"text", k:""}
]},
{name:"chatbox", desc:"Contient les données présentes dans la Chat Box", children:[
{name:"username", type:"text", k:""},
{name:"ip", type:"varchar(20) NOT NULL DEFAULT ''", k:""},
{name:"message", type:"text", k:""},
{name:"date", type:"int(15) NOT NULL DEFAULT '0'", k:"PRIMARY KEY"},
{name:"id", type:"int(10) DEFAULT '0'", k:""},
{name:"dbname", type:"tinyint(4) DEFAULT '0'", k:""}
]},
{name:"compatsujet", desc:"Contient les liens aux publications connexes des rubriques", children:[
{name:"id1", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"id2", type:"int(30) NOT NULL DEFAULT '0'", k:""}
]},
{name:"config", desc:"Contient la configuration des forums (html, bbcode, nombre de topic, …)", children:[
{name:"allow_html", type:"int(2) DEFAULT NULL", k:""},
{name:"allow_bbcode", type:"int(2) DEFAULT NULL", k:""},
{name:"allow_sig", type:"int(2) DEFAULT NULL", k:""},
{name:"posts_per_page", type:"int(10) DEFAULT NULL", k:""},
{name:"hot_threshold", type:"int(10) DEFAULT NULL", k:""},
{name:"topics_per_page", type:"int(10) DEFAULT NULL", k:""},
{name:"allow_upload_forum", type:"int(2) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"allow_forum_hide", type:"int(2) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"upload_table", type:"varchar(50) NOT NULL DEFAULT 'forum_attachments'", k:""},
{name:"rank1", type:"varchar(255) DEFAULT NULL", k:""},
{name:"rank2", type:"varchar(255) DEFAULT NULL", k:""},
{name:"rank3", type:"varchar(255) DEFAULT NULL", k:""},
{name:"rank4", type:"varchar(255) DEFAULT NULL", k:""},
{name:"rank5", type:"varchar(255) DEFAULT NULL", k:""},
{name:"anti_flood", type:"char(3) DEFAULT NULL", k:""},
{name:"solved", type:"int(2) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"counter", desc:"Contient les compteurs relatifs aux statistiques du site (nombre de hits, type de navigateur, de système d'exploitation, …)", children:[
{name:"id_stat", type:"int(10) unsigned NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"type", type:"varchar(80) NOT NULL DEFAULT ''", k:""},
{name:"var", type:"varchar(80) NOT NULL DEFAULT ''", k:""},
{name:"count", type:"int(10) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"downloads", desc:"Contient les informations des téléchargements (compteur, taille du fichier, catégorie, …)", children:[
{name:"did", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"dcounter", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"durl", type:"varchar(255) DEFAULT NULL", k:""},
{name:"dfilename", type:"varchar(255) DEFAULT NULL", k:""},
{name:"dfilesize", type:"bigint(15) unsigned DEFAULT NULL", k:""},
{name:"ddate", type:"date NOT NULL DEFAULT '1000-01-01'", k:""},
{name:"dweb", type:"varchar(255) DEFAULT NULL", k:""},
{name:"duser", type:"varchar(30) DEFAULT NULL", k:""},
{name:"dver", type:"varchar(6) DEFAULT NULL", k:""},
{name:"dcategory", type:"varchar(250) DEFAULT NULL", k:""},
{name:"ddescription", type:"text", k:""},
{name:"perms", type:"varchar(480) NOT NULL DEFAULT '0'", k:""}
]},
{name:"droits", desc:"Contient les droits des administrateurs relatifs aux fonctions d'administrations", children:[
{name:"d_aut_aid", type:"varchar(40) NOT NULL", k:""},
{name:"d_fon_fid", type:"tinyint(3) unsigned NOT NULL", k:""},
{name:"d_droits", type:"varchar(5) NOT NULL", k:""}
]},
{name:"ephem", desc:"Contient la liste des dates des éphémérides et leur contenu", children:[
{name:"eid", type:"NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"did", type:"NOT NULL DEFAULT '0'", k:""},
{name:"mid", type:"NOT NULL DEFAULT '0'", k:""},
{name:"yid", type:"NOT NULL DEFAULT '0'", k:""},
{name:"content", type:"text NOT NULL", k:""}
]},
{name:"faqanswer", desc:"Contient les questions réponses des FAQ", children:[
{name:"id", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"id_cat", type:"tinyint(4) DEFAULT NULL", k:""},
{name:"question", type:"varchar(255) DEFAULT NULL", k:""},
{name:"answer", type:"text", k:""}
]},
{name:"faqcategories", desc:"Contient la liste des catégories des FAQ", children:[
{name:"id_cat", type:"tinyint(3) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"categories", type:"varchar(255) DEFAULT NULL", k:""}
]},
{name:"fonctions", desc:"Contient les fonctions d'administrations", children:[
{name:"fid", type:" mediumint(8) unsigned NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"fnom", type:"varchar(40) NOT NULL", k:""},
{name:"fdroits1", type:"tinyint(3) unsigned NOT NULL", k:""},
{name:"fdroits1_descr", type:"varchar(40) NOT NULL", k:""},
{name:"finterface", type:"tinyint(1) unsigned NOT NULL", k:""},
{name:"fetat", type:"tinyint(1) NOT NULL", k:""},
{name:"fretour", type:"varchar(500) NOT NULL", k:""},
{name:"fretour_h", type:"varchar(500) NOT NULL", k:""},
{name:"fnom_affich", type:"varchar(200) NOT NULL", k:""},
{name:"ficone", type:"varchar(40) NOT NULL", k:""},
{name:"furlscript", type:"varchar(4000) NOT NULL", k:""},
{name:"fcategorie", type:"tinyint(3) unsigned NOT NULL", k:""},
{name:"fcategorie_nom", type:"varchar(200) NOT NULL", k:""},
{name:"fordre", type:"tinyint(2) unsigned NOT NULL", k:""}
]},
{name:"forums", desc:"Contient la liste des forums disponibles dans le portail", children:[
{name:"forum_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"forum_name", type:"varchar(150) DEFAULT NULL", k:""},
{name:"forum_desc", type:"text", k:""},
{name:"forum_access", type:"int(10) DEFAULT '1'", k:""},
{name:"forum_moderator", type:"text", k:""},
{name:"cat_id", type:"int(10) DEFAULT NULL", k:""},
{name:"forum_type", type:"int(10) DEFAULT '0'", k:""},
{name:"forum_pass", type:"varchar(60) DEFAULT NULL", k:""},
{name:"arbre", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"attachement", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"forum_index", type:"int(2) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"forumtopics", desc:"Contient la liste des sujets présents dans les forums", children:[
{name:"topic_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"topic_title", type:"varchar(100) DEFAULT NULL", k:""},
{name:"topic_poster", type:"int(10) DEFAULT NULL", k:""},
{name:"topic_time", type:"datetime DEFAULT NULL", k:""},
{name:"topic_views", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"forum_id", type:"int(10) DEFAULT NULL", k:""},
{name:"topic_status", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"topic_notify", type:"int(2) DEFAULT '0'", k:""},
{name:"current_poster", type:"int(10) DEFAULT NULL", k:""},
{name:"topic_first", type:"tinyint(1) NOT NULL DEFAULT '1'", k:""}
]},
{name:"forum_attachments", desc:"Contient la liste des fichiers attachés aux posts des forums", children:[
{name:"att_id", type:"int(11) NOT NULL AUTO_INCREMENT", k:""},
{name:"post_id", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"topic_id", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"forum_id", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"unixdate", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"att_name", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"att_type", type:"varchar(64) NOT NULL DEFAULT ''", k:""},
{name:"att_size", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"att_path", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"inline", type:"char(1) NOT NULL DEFAULT ''", k:""},
{name:"apli", type:"varchar(10) NOT NULL DEFAULT ''", k:""},
{name:"compteur", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"visible", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""}
]},
{name:"forum_read", desc:"Contient les marqueurs de lecture des sujets des forums", children:[
{name:"rid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"forum_id", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"topicid", type:"int(3) NOT NULL DEFAULT '0'", k:""},
{name:"uid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"last_read", type:"int(15) NOT NULL DEFAULT '0'", k:""},
{name:"status", type:"tinyint(1) NOT NULL DEFAULT '1'", k:""}
]},
{name:"groupes", desc:"Contient la liste des groupes des membres du portail", children:[
{name:"groupe_id", type:"int(3) DEFAULT NULL", k:""},
{name:"groupe_name", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"groupe_description", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"groupe_forum", type:"int(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"groupe_mns", type:"int(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"groupe_chat", type:"int(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"groupe_blocnote", type:"int(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"groupe_pad", type:"int(1) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"headlines", desc:"Contient la liste des liens des fournisseurs de canaux RSS", children:[
{name:"hid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"sitename", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"headlinesurl", type:"varchar(200) NOT NULL DEFAULT ''", k:""},
{name:"status", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""}
]},
{name:"lblocks", desc:"Contient le code (html, meta-mot, …) des blocs de gauche", children:[
{name:"id", type:"tinyint(3) unsigned NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"content", type:"text", k:""},
{name:"member", type:"varchar(60) NOT NULL DEFAULT '0'", k:""},
{name:"Lindex", type:"tinyint(4) NOT NULL DEFAULT '0'", k:""},
{name:"cache", type:"mediumint(8) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"actif", type:"smallint(5) unsigned NOT NULL DEFAULT '1'", k:""},
{name:"css", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"aide", type:"mediumtext", k:""}
]},
{name:"links_categories", desc:"Contient la liste des catégories de liens", children:[
{name:"cid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"cdescription", type:"text NOT NULL", k:""}
]},
{name:"links_editorials", desc:"Contient les descriptions des liens", children:[
{name:"linkid", type:"int(11) NOT NULL DEFAULT '0'", k:"PRIMARY KEY"},
{name:"adminid", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"editorialtimestamp", type:"datetime NOT NULL DEFAULT '1000-01-01 00:00:00'", k:""},
{name:"editorialtext", type:"text NOT NULL", k:""},
{name:"editorialtitle", type:"varchar(100) NOT NULL DEFAULT ''", k:""}
]},
{name:"links_links", desc:"Contient les liens eux-mêmes", children:[
{name:"lid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"sid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"description", type:"text NOT NULL", k:""},
{name:"date", type:"datetime DEFAULT NULL", k:""},
{name:"name", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"hits", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"submitter", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"linkratingsummary", type:"double(6,4) NOT NULL DEFAULT '0.0000'", k:""},
{name:"totalvotes", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"totalcomments", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"topicid_card", type:"tinyint(3) NOT NULL DEFAULT '0'", k:""}
]},
{name:"links_modrequest", desc:"Contient la liste des nouveaux liens soumis à modération de l’administrateur", children:[
{name:"requestid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"lid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"sid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"description", type:"text NOT NULL", k:""},
{name:"modifysubmitter", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"brokenlink", type:"int(3) NOT NULL DEFAULT '0'", k:""},
{name:"topicid_card", type:"tinyint(3) NOT NULL DEFAULT '0'", k:""}
]},
{name:"links_newlink", desc:"Contient la fiche de création de nouveaux liens", children:[
{name:"lid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"sid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"description", type:"text NOT NULL", k:""},
{name:"name", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"submitter", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"topicid_card", type:"tinyint(3) NOT NULL DEFAULT '0'", k:""}
]},
{name:"links_subcategories", desc:"Contient la liste des sous catégories de liens", children:[
{name:"sid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"cid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"varchar(250) DEFAULT NULL", k:""}
]},
{name:"lnl_body", desc:"Contient le corps des newsletters créées", children:[
{name:"ref", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"html", type:"char(1) NOT NULL DEFAULT '1'", k:""},
{name:"text", type:"text", k:""},
{name:"status", type:"char(3) NOT NULL DEFAULT 'stb'", k:""}
]},
{name:"lnl_head_foot", desc:"Contient les en-têtes et/ou pieds de page des NewsLetters créées", children:[
{name:"ref", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"type", type:"char(3) NOT NULL DEFAULT ''", k:""},
{name:"html", type:"char(1) NOT NULL DEFAULT '1'", k:""},
{name:"text", type:"text", k:""},
{name:"status", type:"char(3) NOT NULL DEFAULT 'OK'", k:""}
]},
{name:"lnl_outside_users", desc:"Contient la liste des Email des non membres enregistrée dans le portail", children:[
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:"PRIMARY KEY"},
{name:"host_name", type:"varchar(60) DEFAULT NULL", k:""},
{name:"date", type:"datetime NOT NULL DEFAULT '1000-01-01 00:00:00'", k:""},
{name:"status", type:"char(3) NOT NULL DEFAULT 'OK'", k:""}
]},
{name:"lnl_send", desc:"Contient la liste des NewsLetters envoyées", children:[
{name:"ref", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"header", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"body", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"footer", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"number_send", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"type_send", type:"char(3) NOT NULL DEFAULT 'ALL'", k:""},
{name:"date", type:"datetime NOT NULL DEFAULT '1000-01-01 00:00:00'", k:""},
{name:"status", type:"char(3) NOT NULL DEFAULT 'OK'", k:""}
]},
{name:"mainblock", desc:"Contient le code html du menu principal du portail", children:[
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"content", type:"text", k:""}
]},
{name:"metalang", desc:"Contient la liste des meta_mot", children:[
{name:"def", type:"varchar(50) NOT NULL DEFAULT ''", k:"PRIMARY KEY"},
{name:"content", type:"text NOT NULL", k:""},
{name:"type_meta", type:"varchar(4) NOT NULL DEFAULT 'mot'", k:""},
{name:"type_uri", type:"char(1) NOT NULL DEFAULT '-'", k:""},
{name:"uri", type:"varchar(255) DEFAULT NULL", k:""},
{name:"description", type:"text", k:""},
{name:"obligatoire", type:"char(3) NOT NULL DEFAULT '0'", k:""}
]},
{name:"modules", desc:"Contient la liste des modules et leur état (installé, …)", children:[
{name:"mid", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"mnom", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"minstall", type:"int(1) NOT NULL DEFAULT '0'", k:""}
]},
{name:"optimy", desc:"Contient les informations sur les optimisations de la base de données", children:[
{name:"optid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"optgain", type:"decimal(10,3) DEFAULT NULL", k:""},
{name:"optdate", type:"varchar(11) DEFAULT NULL", k:""},
{name:"opthour", type:"varchar(8) DEFAULT NULL", k:""},
{name:"optcount", type:"int(11) DEFAULT '0'", k:""}
]},
{name:"poll_data", desc:"Contient les informations sur les sondages créés (options, etc, …)", children:[
{name:"pollID", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"optionText", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"optionCount", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"voteID", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"pollType", type:"int(1) NOT NULL DEFAULT '0'", k:""}
]},
{name:"poll_desc", desc:"Contient les descriptions des sondages créés (titres, questions, …)", children:[
{name:"pollID", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"pollTitle", type:"char(100) NOT NULL DEFAULT ''", k:""},
{name:"timeStamp", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"voters", type:"mediumint(9) NOT NULL DEFAULT '0'", k:""}
]},
{name:"posts", desc:"Contient les messages présents dans les forums", children:[
{name:"post_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"post_idH", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"image", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"topic_id", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"forum_id", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"poster_id", type:"int(10) DEFAULT NULL", k:""},
{name:"post_text", type:"text", k:""},
{name:"post_time", type:"varchar(20) DEFAULT NULL", k:""},
{name:"poster_ip", type:"varchar(54) DEFAULT NULL", k:""},
{name:"poster_dns", type:"text", k:""},
{name:"post_aff", type:"tinyint(1) unsigned NOT NULL DEFAULT '1'", k:""}
]},
{name:"priv_msgs", desc:"Contient les messages privés des membres", children:[
{name:"msg_id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"msg_image", type:"varchar(100) DEFAULT NULL", k:""},
{name:"subject", type:"varchar(100) DEFAULT NULL", k:""},
{name:"from_userid", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"to_userid", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"msg_time", type:"varchar(20) DEFAULT NULL", k:""},
{name:"msg_text", type:"text", k:""},
{name:"read_msg", type:"tinyint(10) NOT NULL DEFAULT '0'", k:""},
{name:"type_msg", type:"int(1) NOT NULL DEFAULT '0'", k:""},
{name:"dossier", type:"varchar(50) NOT NULL DEFAULT '...'", k:""}
]},
{name:"publisujet", desc:"Contient les droits de publication sur les rubriques, sous rubrique et article", children:[
{name:"aid", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"secid2", type:"int(30) NOT NULL DEFAULT '0'", k:""},
{name:"type", type:"int(1) NOT NULL DEFAULT '0'", k:""}
]},
{name:"queue", desc:"Contient la file d’attente des articles soumis (en attente de validation par l’administrateur)", children:[
{name:"qid", type:"smallint(5) unsigned NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"uid", type:"mediumint(9) NOT NULL DEFAULT '0'", k:""},
{name:"uname", type:"varchar(40) NOT NULL DEFAULT ''", k:""},
{name:"subject", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"story", type:"text", k:""},
{name:"bodytext", type:"mediumtext", k:""},
{name:"timestamp", type:"datetime NOT NULL DEFAULT '1000-01-01 00:00:00'", k:""},
{name:"topic", type:"varchar(20) NOT NULL DEFAULT 'Linux'", k:""},
{name:"date_debval", type:"datetime DEFAULT NULL", k:""},
{name:"date_finval", type:"datetime DEFAULT NULL", k:""},
{name:"auto_epur", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"rblocks", desc:"Contient le code (html, meta-mot, …) des blocs de droite", children:[
{name:"id", type:"tinyint(3) unsigned NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"content", type:"text", k:""},
{name:"member", type:"varchar(60) NOT NULL DEFAULT '0'", k:""},
{name:"Rindex", type:"tinyint(4) NOT NULL DEFAULT '0'", k:""},
{name:"cache", type:"mediumint(8) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"actif", type:"smallint(5) unsigned NOT NULL DEFAULT '1'", k:""},
{name:"css", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"aide", type:"mediumtext", k:""}
]},
{name:"referer", desc:"Contient la liste des sites référants du portail", children:[
{name:"rid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""}
]},
{name:"related", desc:"Contient les liens relatifs au sujet", children:[
{name:"rid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"tid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"name", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(200) NOT NULL DEFAULT ''", k:""}
]},
{name:"reviews", desc:"Contient le contenu des critiques (texte, date, auteur…)", children:[
{name:"id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"date", type:"date NOT NULL", k:""},
{name:"title", type:"varchar(150) NOT NULL DEFAULT ''", k:""},
{name:"text", type:"text NOT NULL", k:""},
{name:"reviewer", type:"varchar(20) DEFAULT NULL", k:""},
{name:"email", type:"varchar(60) DEFAULT NULL", k:""},
{name:"score", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"cover", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url_title", type:"varchar(50) NOT NULL DEFAULT ''", k:""},
{name:"hits", type:"int(10) NOT NULL DEFAULT '0'", k:""}
]},
{name:"reviews_add", desc:"Contient les critiques en attente de modération", children:[
{name:"id", type:"int(10) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"date", type:"date DEFAULT NULL", k:""},
{name:"title", type:"varchar(150) NOT NULL DEFAULT ''", k:""},
{name:"text", type:"text NOT NULL", k:""},
{name:"reviewer", type:"varchar(20) NOT NULL DEFAULT ''", k:""},
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"score", type:"int(10) NOT NULL DEFAULT '0'", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"url_title", type:"varchar(50) NOT NULL DEFAULT ''", k:""}
]
},
{name:"reviews_main", desc:"Contient la description des critiques", children:[
{name:"title", type:"text", k:""},
{name:"description", type:"text", k:""}
]},
{name:"rubriques", desc:"Contient le premier niveau de hiérarchie des rubriques", children:[
{name:"rubid", type:"int(4) NOT NULL AUTO_INCREMENT", k:""},
{name:"rubname", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"intro", type:"text NOT NULL", k:""},
{name:"enligne", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"ordre", type:"int(2) NOT NULL DEFAULT '0'", k:""}
]},
{name:"seccont", desc:"Contient les articles des rubriques", children:[
{name:"artid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"secid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"text NOT NULL", k:""},
{name:"content", type:"longtext NOT NULL", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"author", type:"varchar(50) NOT NULL DEFAULT ''", k:""},
{name:"ordre", type:"int(2) NOT NULL DEFAULT '0'", k:""},
{name:"userlevel", type:"varchar(34) NOT NULL DEFAULT '0'", k:""},
{name:"timestamp", type:"varchar(14) NOT NULL DEFAULT '0'", k:""}
]},
{name:"seccont_tempo", desc:"Contient les articles des rubriques en attente de publication", children:[
{name:"artid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"secid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"title", type:"text NOT NULL", k:""},
{name:"content", type:"longtext NOT NULL", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"author", type:"varchar(50) NOT NULL DEFAULT ''", k:""},
{name:"ordre", type:"int(2) NOT NULL DEFAULT '0'", k:""},
{name:"userlevel", type:"varchar(34) NOT NULL DEFAULT '0'", k:""}
]},
{name:"sections", desc:"Contient les informations relatives aux sections (nom, image…)", children:[
{name:"secid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"secname", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"image", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"userlevel", type:"varchar(34) NOT NULL DEFAULT '0'", k:""},
{name:"rubid", type:"int(5) NOT NULL DEFAULT '3'", k:""},
{name:"intro", type:"text", k:""},
{name:"ordre", type:"int(2) NOT NULL DEFAULT '0'", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""}
]},
{name:"session", desc:"Contient la liste des sessions actives du portail (pseudo, date, ip…)", children:[
{name:"username", type:"varchar(54) NOT NULL DEFAULT ''", k:""},
{name:"time", type:"varchar(14) NOT NULL DEFAULT ''", k:""},
{name:"host_addr", type:"varchar(54) NOT NULL DEFAULT ''", k:""},
{name:"guest", type:"int(1) NOT NULL DEFAULT '0'", k:""},
{name:"uri", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"agent", type:"varchar(255) DEFAULT NULL", k:""}
]},
{name:"sform", desc:"Peut contenir des objets sform au format xml", children:[
{name:"cpt", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"id_form", type:"text NOT NULL", k:""},
{name:"id_key", type:"text NOT NULL", k:""},
{name:"key_value", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"passwd", type:"text", k:""},
{name:"content", type:"longtext NOT NULL", k:""}
]},
{name:"stories", desc:"Contient les articles publiés (catégorie, titre, date, contenu…)", children:[
{name:"sid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"catid", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"aid", type:"varchar(30) NOT NULL DEFAULT ''", k:""},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"time", type:"datetime DEFAULT NULL", k:""},
{name:"hometext", type:"mediumtext", k:""},
{name:"bodytext", type:"mediumtext", k:""},
{name:"comments", type:"int(11) DEFAULT '0'", k:""},
{name:"counter", type:"mediumint(8) unsigned DEFAULT NULL", k:""},
{name:"topic", type:"int(3) NOT NULL DEFAULT '1'", k:""},
{name:"informant", type:"varchar(20) NOT NULL DEFAULT ''", k:""},
{name:"notes", type:"text", k:""},
{name:"ihome", type:"int(1) NOT NULL DEFAULT '0'", k:""},
{name:"archive", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"date_finval", type:"datetime DEFAULT NULL", k:""},
{name:"auto_epur", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""}
]},
{name:"stories_cat", desc:"Contient la liste des catégories des articles", children:[
{name:"catid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"title", type:"varchar(255) DEFAULT NULL", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""}
]},
{name:"subscribe", desc:"Contient la liste des abonnements par membre", children:[
{name:"topicid", type:"tinyint(3) DEFAULT NULL", k:""},
{name:"forumid", type:"int(10) DEFAULT NULL", k:""},
{name:"lnlid", type:"text", k:""},
{name:"uid", type:"int(11) NOT NULL DEFAULT '0'", k:""}
]},
{name:"topics", desc:"Contient la liste des sujets disponibles sur le portail", children:[
{name:"topicid", type:"int(3) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"topicname", type:"varchar(20) DEFAULT NULL", k:""},
{name:"topicimage", type:"varchar(20) DEFAULT NULL", k:""},
{name:"topictext", type:"varchar(250) DEFAULT NULL", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"topicadmin", type:"text", k:""}
]},
{name:"users", desc:"Contient la liste des utilisateurs inscrits ainsi que leurs informations (nom, pseudo, mot de passe…)", children:[
{name:"uid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"name", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"uname", type:"varchar(25) NOT NULL DEFAULT ''", k:""},
{name:"email", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"femail", type:"varchar(60) NOT NULL DEFAULT ''", k:""},
{name:"url", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"user_avatar", type:"varchar(100) DEFAULT NULL", k:""},
{name:"user_regdate", type:"varchar(20) NOT NULL DEFAULT ''", k:""},
{name:"user_occ", type:"varchar(100) DEFAULT NULL", k:""},
{name:"user_from", type:"varchar(100) DEFAULT NULL", k:""},
{name:"user_intrest", type:"varchar(150) DEFAULT NULL", k:""},
{name:"user_sig", type:"varchar(255) DEFAULT NULL", k:""},
{name:"user_viewemail", type:"tinyint(2) DEFAULT NULL", k:""},
{name:"user_theme", type:"varchar(255) DEFAULT NULL", k:""},
{name:"user_journal", type:"text NOT NULL", k:""},
{name:"pass", type:"varchar(40) NOT NULL DEFAULT ''", k:""},
{name:"storynum", type:"tinyint(4) NOT NULL DEFAULT '10'", k:""},
{name:"umode", type:"varchar(10) NOT NULL DEFAULT ''", k:""},
{name:"uorder", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"thold", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"noscore", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"bio", type:"tinytext NOT NULL", k:""},
{name:"ublockon", type:"tinyint(1) NOT NULL DEFAULT '0'", k:""},
{name:"ublock", type:"tinytext NOT NULL", k:""},
{name:"theme", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"commentmax", type:"int(11) NOT NULL DEFAULT '4096'", k:""},
{name:"counter", type:"int(11) NOT NULL DEFAULT '0'", k:""},
{name:"send_email", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"is_visible", type:"tinyint(1) unsigned NOT NULL DEFAULT '1'", k:""},
{name:"mns", type:"tinyint(1) unsigned NOT NULL DEFAULT '0'", k:""},
{name:"user_langue", type:"varchar(20) DEFAULT NULL", k:""},
{name:"user_lastvisit", type:"varchar(14) DEFAULT NULL", k:""},
{name:"user_lnl", type:"tinyint(1) unsigned NOT NULL DEFAULT '1'", k:""}
]},
{name:"users_extend", desc:"Contient les informations complémentaires sur les membres", children:[
{name:"uid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"C1", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C2", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C3", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C4", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C5", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C6", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C7", type:"varchar(255) DEFAULT NULL", k:""},
{name:"C8", type:"varchar(255) DEFAULT NULL", k:""},
{name:"M1", type:"mediumtext", k:""},
{name:"M2", type:"mediumtext", k:""},
{name:"T1", type:"varchar(10) DEFAULT NULL", k:""},
{name:"T2", type:"varchar(14) DEFAULT NULL", k:""},
{name:"B1", type:"blob", k:""}
]},
{name:"users_status", desc:"Contient les informations relatives aux nombres de posts, aux permissions des utilisateurs des forums", children:[
{name:"uid", type:"int(11) NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"posts", type:"int(10) DEFAULT '0'", k:""},
{name:"attachsig", type:"int(2) DEFAULT '0'", k:""},
{name:"rank", type:"int(10) DEFAULT '0'", k:""},
{name:"level", type:"int(10) DEFAULT '1'", k:""},
{name:"open", type:"tinyint(1) NOT NULL DEFAULT '1'", k:""},
{name:"groupe", type:"varchar(34) DEFAULT NULL", k:""}
]},
{name:"wspad", desc:"Contient les publications partagées du WorkSpace", children:[
{name:"ws_id", type:"", k:"PRIMARY KEY"},
{name:"page", type:"varchar(255) NOT NULL DEFAULT ''", k:""},
{name:"content", type:"mediumtext NOT NULL", k:""},
{name:"modtime", type:"int(15) NOT NULL", k:""},
{name:"editedby", type:"varchar(40) NOT NULL DEFAULT ''", k:""},
{name:"ranq", type:"smallint(6) NOT NULL DEFAULT '1'", k:""},
{name:"member", type:"int(11) NOT NULL DEFAULT '1'", k:""},
{name:"verrou", type:"varchar(60) DEFAULT NULL", k:""}
]},
{name:"ip_loc", desc:"Contient IP des visteurs : visite, localisation ...", children:[
{name:"ip_id", type:"smallint(8) UNSIGNED NOT NULL AUTO_INCREMENT", k:"PRIMARY KEY"},
{name:"ip_long", type:"float NOT NULL DEFAULT '0'", k:""},
{name:"ip_lat", type:"float NOT NULL DEFAULT '0'", k:""},
{name:"ip_visi_pag", type:"varchar(100) NOT NULL DEFAULT ''", k:""},
{name:"ip_visite", type:"mediumint(9) UNSIGNED NOT NULL DEFAULT '0'", k:""},
{name:"ip_ip", type:"varchar(54) NOT NULL DEFAULT ''", k:""},
{name:"ip_country", type:"varchar(100) NOT NULL DEFAULT '0'", k:""},
{name:"ip_code_country", type:"varchar(4) NOT NULL", k:""},
{name:"ip_city", type:"varchar(150) NOT NULL DEFAULT '0'", k:""}
]}
]
}
)
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more