function prepare()
   db_query("CREATE TABLE emp7 (EMPNO integer not null,ENAME VARCHAR(10),DEPTNO integer,SAL float)")
   db_query("ALTER TABLE emp7 ADD PRIMARY KEY(EMPNO)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7369, 'SMITH', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7499, 'ALLEN', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7521, 'WARD',  10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7566, 'JONES', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7654, 'MARTIN',10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7698, 'BLAKE', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7782, 'CLARK', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7788, 'SCOTT', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7839, 'KING',  10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7844, 'TURNER',10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7876, 'ADAMS', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7900, 'JAMES', 10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7902, 'FORD',  10, 100)")
   db_query("insert into emp7(empno, ename, deptno, sal) values(7934, 'MILLER',10, 100)")
end

function event()
   db_query("select count(*) from emp7 emp1, emp7 emp2, emp7 emp3, emp7 emp4, emp7 emp5, emp7 emp6, emp7 emp_7 where emp_7.deptno=10")
end

function event_upd()
   db_query("UPDATE t SET sal = sal + " .. sb_rand(1, 100))
end

function cleanup()
   db_query("DROP TABLE emp7")
end


sysbench.cmdline.options = {
   table_size =
      {"Number of rows per table", 14}
   }

sysbench.cmdline.commands = {
   update_test = {event_upd}
}