diff options
author | m2nlight <wingingbob@gmail.com> | 2018-03-10 04:44:07 +0800 |
---|---|---|
committer | jc <u@gogs.io> | 2018-03-09 15:44:07 -0500 |
commit | aa53d0978c85818c954bb87990b389f8acd11c5e (patch) | |
tree | 3d97aa731af99e9613f705c29952e36e55fdc8dc | |
parent | ffdd8b3afac9343bdd119368310190375682ff7a (diff) |
models: add ROW_FORMAT=DYNAMIC when creating table for supports mysql 5.6 (#4913)
* Add ROW_FORMAT=DYNAMIC when creating table for supports mysql 5.6 (fix #4894)
* Update models.go
Rename NewEngine2 to NewEngineWithParams
* Rename NewEngine2 to NewEngineWithParams
Please update vendor when https://github.com/go-xorm/xorm/pull/798 closed.
* Update dialect_mysql.go
* Update dialect_mysql.go
* Update models.go
-rw-r--r-- | models/models.go | 2 | ||||
-rw-r--r-- | scripts/mysql.sql | 3 |
2 files changed, 5 insertions, 0 deletions
diff --git a/models/models.go b/models/models.go index 10a3d58a..6fcd2619 100644 --- a/models/models.go +++ b/models/models.go @@ -140,6 +140,8 @@ func getEngine() (*xorm.Engine, error) { connStr = fmt.Sprintf("%s:%s@tcp(%s)/%s%scharset=utf8mb4&parseTime=true", DbCfg.User, DbCfg.Passwd, DbCfg.Host, DbCfg.Name, Param) } + var engineParams = map[string]string{"rowFormat": "DYNAMIC"} + return xorm.NewEngineWithParams(DbCfg.Type, connStr, engineParams) case "postgres": host, port := parsePostgreSQLHostPort(DbCfg.Host) if host[0] == '/' { // looks like a unix socket diff --git a/scripts/mysql.sql b/scripts/mysql.sql index 98e7bc39..e3f23ce0 100644 --- a/scripts/mysql.sql +++ b/scripts/mysql.sql @@ -1,2 +1,5 @@ +SET GLOBAL innodb_file_per_table = ON, + innodb_file_format = Barracuda, + innodb_large_prefix = ON; DROP DATABASE IF EXISTS gogs; CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; |