1 files changed, 29 insertions, 0 deletions
diff --git a/tests/test-collation-db.sh b/tests/test-collation-db.sh
new file mode 100755
index 0000000..d549f4d
--- /dev/null
+++ b/tests/test-collation-db.sh
@@ -0,0 +1,29 @@
+#!/bin/bash
+
+db_name=test.db
+tableName=collation
+
+sqlite3 $db_name << EOF
+DROP TABLE IF EXISTS ${tableName};
+
+CREATE TABLE IF NOT EXISTS ${tableName} (
+key CHAR not NULL,
+value CHAR );
+
+PRAGMA synchronous=OFF;
+PRAGMA count_changes=OFF;
+PRAGMA journal_mode=MEMORY;
+PRAGMA temp_store=MEMORY;
+
+BEGIN TRANSACTION;
+INSERT INTO ${tableName} ( key, value) values ( "test_01", "테스트 1");
+INSERT INTO ${tableName} ( key, value) values ( "test_04", "테스트 01");
+INSERT INTO ${tableName} ( key, value) values ( "test_07", "테스트 001");
+INSERT INTO ${tableName} ( key, value) values ( "test_02", "테스트 2");
+INSERT INTO ${tableName} ( key, value) values ( "test_08", "테스트 002");
+INSERT INTO ${tableName} ( key, value) values ( "test_05", "테스트 02");
+INSERT INTO ${tableName} ( key, value) values ( "test_09", "테스트 003");
+INSERT INTO ${tableName} ( key, value) values ( "test_03", "테스트 3");
+INSERT INTO ${tableName} ( key, value) values ( "test_06", "테스트 03");
+COMMIT TRANSACTION;
+EOF