[go: up one dir, main page]

Skip to content

Latest commit

 

History

History
 
 

sql

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 

Test Database

sakila

  • Download MySQL sakila database from http://downloads.mysql.com/docs/sakila-db.tar.gz .
  • InnoDB added FULLTEXT support in 5.6.10, you should add version comment /*!50610 xxx */ for film_text table and it's triggers.
  • Merge schema and data into one file sakila.sql

world_x

world_x contain JSON datatype, SOAR use this database for JSON testing.

  • Download MySQL world_x database from http://downloads.mysql.com/docs/world_x-db.tar.gz .
  • MySQL support JSON datatype since 5.7.8, you should add version comment /*!50708 xxx */ for city, countryinfo.
  • Merge sakila.sql, world_x.sql into init.sql.
gzip init.sql