Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/phpmyadmin/phpmyadmin.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarc Delisle <marc@infomarc.info>2014-05-26 23:15:31 +0400
committerMarc Delisle <marc@infomarc.info>2014-05-26 23:15:31 +0400
commit1fb3ae27cffb7549efd12b3c07e985611516192e (patch)
tree319c07034c11f2916cdbd01fe7cf3bad7af33e56 /examples
parent93ce1a69de3e170f2f902566876e2880e58f7592 (diff)
A TEXT column cannot have a default value
Signed-off-by: Marc Delisle <marc@infomarc.info>
Diffstat (limited to 'examples')
-rw-r--r--examples/create_tables.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/examples/create_tables.sql b/examples/create_tables.sql
index f0a3e39a7d..5668a460c6 100644
--- a/examples/create_tables.sql
+++ b/examples/create_tables.sql
@@ -331,8 +331,8 @@ CREATE TABLE IF NOT EXISTS `pma__central_columns` (
`col_collation` varchar(64) NOT NULL,
`col_isNull` boolean NOT NULL,
`col_extra` varchar(255) default '',
- `col_default` text default '',
+ `col_default` text,
PRIMARY KEY (`db_name`,`col_name`)
)
COMMENT='Central list of columns'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; \ No newline at end of file
+ DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;