File: mysql.testschema.sql

package info (click to toggle)
ora2pg 25.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 2,696 kB
  • sloc: perl: 31,346; sh: 143; makefile: 11; sql: 5
file content (7 lines) | stat: -rw-r--r-- 308 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
 
CREATE DATABASE foo;
USE foo;

-- from mysql_init.sh
CREATE TABLE department(department_id int, department_name text, PRIMARY KEY (department_id));
CREATE TABLE employee(emp_id int, emp_name text, emp_dept_id int, PRIMARY KEY (emp_id));
CREATE TABLE empdata (emp_id int, emp_dat blob, PRIMARY KEY (emp_id));