{"id":71,"date":"2007-01-17T16:55:55","date_gmt":"2007-01-17T16:55:55","guid":{"rendered":"http:\/\/www.dereckson.be\/blog\/2007\/01\/17\/structure-sql-de-sycorax\/"},"modified":"2022-02-23T23:44:29","modified_gmt":"2022-02-23T22:44:29","slug":"structure-sql-de-sycorax","status":"publish","type":"post","link":"https:\/\/www.dereckson.be\/blog\/2007\/01\/17\/structure-sql-de-sycorax\/","title":{"rendered":"Structure SQL de Sycorax"},"content":{"rendered":"<p>Voici la structure SQL actuelle minimale de <a href=\"http:\/\/www.espace-win.org\/EWOSP\/Sycorax\" hreflang=\"fr\">Sycorax<\/a> :<\/p>\n<style type=\"text\/css\"> \/* GeSHi (c) Nigel McNie 2004 (http:\/\/qbnz.com\/highlighter) *\/ .sql .de1, .sql .de2 {color: #000060; font-weight: normal;} .sql  {font-family: monospace;border: 1px dotted #a0a0a0; font-family: 'Courier New', Courier, monospace; font-size: 110%; background-color: #f0f0f0; margin: 0; line-height: 110%; padding: 0;color: #0000bb;} .sql a:link {color: #006;} .sql a:hover {background-color: #d6d6e6;} .sql .head {font-family: Verdana, Arial, sans-serif; color: #808080; font-size: 70%; font-weight: bold; background-color: #f0f0ff; border-bottom: 1px solid #d0d0d0; padding: 2px;} .sql .foot {font-family: Verdana, Arial, sans-serif; color: #808080; font-size: 70%; font-weight: bold; background-color: #f0f0ff; border-top: 1px solid #d0d0d0; padding: 2px;} .sql .imp {font-weight: bold; color: red;} .sql li {font-family: 'Courier New', Courier, monospace; color: #000060; background-color: #e0e0e0; padding-bottom: 2px;} .sql li.li2 {font-weight: bold; color: #000090; line-height: 90%} .sql .kw1 {color: #993333; font-weight: bold;} .sql .co1 {color: #808080; font-style: italic;font-style: normal;} .sql .co2 {color: #808080; font-style: italic;} .sql .coMULTI {color: #808080; font-style: italic;font-style: normal;} .sql .es0 {color: #000099; font-weight: bold;font-weight: normal;} .sql .br0 {color: #66cc66;} .sql .st0 {color: #ff0000;} .sql .nu0 {color: #cc66cc;} .sql .me {1}<\/style>\n<div class=\"sql\" style=\"font-family: 'Courier New', Courier, monospace; border: 1px dotted #a0a0a0; font-size: 110%; background-color: #f0f0f0; margin: 0; line-height: 110%; padding: 0; color: #0000bb;\">\n<div class=\"head\">Structures des tables SQL de Sycorax<\/div>\n<ol>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"kw1\">CREATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`Files`<\/span> <span class=\"br0\">(<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`file_id`<\/span> mediumint<span class=\"br0\">(<\/span><span class=\"nu0\">8<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"kw1\">AUTO_INCREMENT<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`file_path`<\/span> mediumtext <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`tune_id`<\/span> mediumint<span class=\"br0\">(<\/span><span class=\"nu0\">8<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span>,<\/div>\n<\/li>\n<li class=\"li2\">\n<div class=\"de2\">\u00a0 <span class=\"kw1\">PRIMARY<\/span> <span class=\"kw1\">KEY<\/span>\u00a0 <span class=\"br0\">(<\/span><span class=\"st0\">`file_id`<\/span><span class=\"br0\">)<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"kw1\">KEY<\/span> <span class=\"st0\">`tune_id`<\/span> <span class=\"br0\">(<\/span><span class=\"st0\">`tune_id`<\/span><span class=\"br0\">)<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"kw1\">KEY<\/span> <span class=\"st0\">`file_path`<\/span> <span class=\"br0\">(<\/span><span class=\"st0\">`file_path`<\/span><span class=\"br0\">(<\/span><span class=\"nu0\">255<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"br0\">)<\/span> ENGINE=MyISAM <span class=\"kw1\">DEFAULT<\/span> CHARSET=utf8;<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><\/div>\n<\/li>\n<li class=\"li2\">\n<div class=\"de2\"><span class=\"kw1\">CREATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`Tunes`<\/span> <span class=\"br0\">(<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`tune_id`<\/span> mediumint<span class=\"br0\">(<\/span><span class=\"nu0\">8<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"kw1\">AUTO_INCREMENT<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`tune_by`<\/span> varchar<span class=\"br0\">(<\/span><span class=\"nu0\">255<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`tune_title`<\/span> varchar<span class=\"br0\">(<\/span><span class=\"nu0\">255<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span>,<\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\">\u00a0 <span class=\"st0\">`tune_comment`<\/span> varchar<span class=\"br0\">(<\/span><span class=\"nu0\">255<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span>,<\/div>\n<\/li>\n<li class=\"li2\">\n<div class=\"de2\">\u00a0 <span class=\"kw1\">PRIMARY<\/span> <span class=\"kw1\">KEY<\/span>\u00a0 <span class=\"br0\">(<\/span><span class=\"st0\">`tune_id`<\/span><span class=\"br0\">)<\/span><\/div>\n<\/li>\n<li class=\"li1\">\n<div class=\"de1\"><span class=\"br0\">)<\/span> ENGINE=MyISAM <span class=\"kw1\">DEFAULT<\/span> CHARSET=utf8;<\/div>\n<\/li>\n<\/ol>\n<div class=\"foot\">Sycorax est distribu\u00e9 sous license BSD.<\/div>\n<\/div>\n<p>Si vous souhaitez modifier quelque chose, c&#8217;est dans <a href=\"https:\/\/github.com\/ewosp\/sycorax\/blob\/master\/Sycorax%20Library\/DatabaseUpdate.cs\" hreflang=\"en\">DatabaseUpdate.cs<\/a> (Sycorax Library) que cela se passe.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Voici la structure SQL actuelle minimale de Sycorax : Structures des tables SQL de Sycorax CREATE TABLE `Files` ( \u00a0 `file_id` mediumint(8) NOT NULL AUTO_INCREMENT, \u00a0 `file_path` mediumtext NOT NULL, \u00a0 `tune_id` mediumint(8) NOT NULL, \u00a0 PRIMARY KEY\u00a0 (`file_id`), \u00a0 KEY `tune_id` (`tune_id`), \u00a0 KEY `file_path` (`file_path`(255)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `Tunes` ( [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-misc"],"_links":{"self":[{"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":1,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":841,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/posts\/71\/revisions\/841"}],"wp:attachment":[{"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/categories?post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dereckson.be\/blog\/wp-json\/wp\/v2\/tags?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}