X-Git-Url: https://git.sven.stormbind.net/?p=sven%2Fmysqltcl.git;a=blobdiff_plain;f=tests%2Ftest.sql;fp=tests%2Ftest.sql;h=7012332e9356689a40b376b1ffc06a426fb126c4;hp=0000000000000000000000000000000000000000;hb=8b83892bf9d924349d5e09c88f16790a8086a950;hpb=b47a140e1d8fa10b34c244d077b2a3a7f36c7ff8

diff --git a/tests/test.sql b/tests/test.sql
new file mode 100755
index 0000000..7012332
--- /dev/null
+++ b/tests/test.sql
@@ -0,0 +1,23 @@
+CREATE TABLE Student (
+  MatrNr int(11) DEFAULT '0' NOT NULL auto_increment,
+  Name varchar(20),
+  Semester int(11),
+  PRIMARY KEY (MatrNr)
+);
+
+INSERT INTO Student VALUES (1,'Sojka',4);
+INSERT INTO Student VALUES (2,'Preisner',2);
+INSERT INTO Student VALUES (3,'Killar',2);
+INSERT INTO Student VALUES (4,'Penderecki',10);
+INSERT INTO Student VALUES (5,'Turnau',2);
+INSERT INTO Student VALUES (6,'Grechuta',3);
+INSERT INTO Student VALUES (7,'Gorniak',1);
+INSERT INTO Student VALUES (8,'Niemen',3);
+INSERT INTO Student VALUES (9,'Bem',5);
+
+CREATE TABLE Binarytest (
+  id int(11) DEFAULT '0' NOT NULL auto_increment,
+  data longblob,
+  PRIMARY KEY (id)
+);
+