diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 22:41:00 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 22:41:00 +0100 |
| commit | b3e18a850e09afc9f8b3e26c9af80e091ca66ccb (patch) | |
| tree | f15bcc544e6d7c3735089c9b65a13864f795a4d1 /public/install.php | |
| parent | d2d26bf69c63821d0fa73f8b8b6dd78370f5d2d7 (diff) | |
SQL : Explications sur le choix de varchar(760)
varchar(760) est choisi pour pouvoir être utilisé efficacement dans un
UNIQUE() avec les limites de InnoDB de MySQL
Diffstat (limited to 'public/install.php')
| -rw-r--r-- | public/install.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/public/install.php b/public/install.php index 4471f2e95..ed7c5e3bb 100644 --- a/public/install.php +++ b/public/install.php @@ -43,7 +43,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `id` char(6) NOT NULL, - `guid` varchar(760) CHARACTER SET latin1 NOT NULL, + `guid` varchar(760) CHARACTER SET latin1 NOT NULL, -- Maximum for UNIQUE is 767B `title` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `content` text NOT NULL, |