X-Git-Url: http://git.rot13.org/?p=git-sql-sphinx.git;a=blobdiff_plain;f=test.sql;fp=test.sql;h=1007e9259972e5847f40fdc66ac42dc1ab2b0b13;hp=0000000000000000000000000000000000000000;hb=6d1790eaaf7552efd8a89116c0149c1a000dd8e2;hpb=2fe5946320b1213b3967f34d6f1107c9728ec1e8

diff --git a/test.sql b/test.sql
new file mode 100644
index 0000000..1007e92
--- /dev/null
+++ b/test.sql
@@ -0,0 +1,33 @@
+-- create database test ;
+-- grant all on test.* to test ;
+
+DROP TABLE IF EXISTS test.documents;
+CREATE TABLE test.documents
+(
+	id			INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
+	group_id	INTEGER NOT NULL,
+	group_id2	INTEGER NOT NULL,
+	date_added	DATETIME NOT NULL,
+	title		VARCHAR(255) NOT NULL,
+	content		TEXT NOT NULL
+);
+
+REPLACE INTO test.documents ( id, group_id, group_id2, date_added, title, content ) VALUES
+	( 1, 1, 5, NOW(), 'test one', 'this is my test document number one. also checking search within phrases.' ),
+	( 2, 1, 6, NOW(), 'test two', 'this is my test document number two' ),
+	( 3, 2, 7, NOW(), 'another doc', 'this is another group' ),
+	( 4, 2, 8, NOW(), 'doc number four', 'this is to test groups' );
+
+DROP TABLE IF EXISTS test.tags;
+CREATE TABLE test.tags
+(
+	docid INTEGER NOT NULL,
+	tagid INTEGER NOT NULL,
+	UNIQUE(docid,tagid)
+);
+
+INSERT INTO test.tags VALUES
+	(1,1), (1,3), (1,5), (1,7),
+	(2,6), (2,4), (2,2),
+	(3,15),
+	(4,7), (4,40);