From 54df2afaa61c6a03cbb4a33c9b90fa572b6d07b8 Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
Date: Sat, 17 Dec 2016 21:28:53 -0800
Subject: Berkeley DB 4.8 with rust build script for linux.

---
 db-4.8.30/test/scr038/data/sample.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 db-4.8.30/test/scr038/data/sample.sql

(limited to 'db-4.8.30/test/scr038/data/sample.sql')

diff --git a/db-4.8.30/test/scr038/data/sample.sql b/db-4.8.30/test/scr038/data/sample.sql
new file mode 100644
index 0000000..62689c6
--- /dev/null
+++ b/db-4.8.30/test/scr038/data/sample.sql
@@ -0,0 +1,20 @@
+CREATE DATABASE numismatics;  /*+ CACHESIZE = 16m */
+
+CREATE TABLE coin (cid INT(8) PRIMARY KEY,
+                       unit VARCHAR2(20),
+                       value NUMERIC(8,2), -- just a comment here;
+                       mintage_year INT(8),
+                       mint_id INT(8),
+                       CONSTRAINT mint_id_fk FOREIGN KEY(mint_id)
+                           REFERENCES mint(mid));
+
+CREATE TABLE mint (mid INT(8) PRIMARY KEY,
+       country VARCHAR2(20),
+       city VARCHAR2(20));   --+ DBTYPE = HASH
+
+CREATE INDEX unit_index ON coin(unit);
+
+CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY,
+       chunk bin(127));
+
+/* SELECT * from mint;*/  
-- 
cgit v1.2.3