File: mysql.testschema.sql

package info (click to toggle)
ora2pg 21.0-2
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 2,088 kB
  • sloc: perl: 20,598; sh: 139; makefile: 11; sql: 7
file content (10 lines) | stat: -rw-r--r-- 410 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
 
CREATE DATABASE foo;
USE foo;

CREATE USER 'foo'@'127.0.0.1' IDENTIFIED BY 'bar';
GRANT ALL PRIVILEGES ON *.* TO 'foo'@'127.0.0.1';

-- 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));