File: p4aex_db.sql

create database p4aex_db;

grant select, insert, update, delete on
p4aex_db.* to p4aex_us@localhost;

use mysql;

use p4aex_db;

create table tableexample
(
	field1 char(10) not null primary key,
	field2 char(30),
	field3 char(15),
	field4 text
);

create table tablereferenced
(
	field3 char(15) not null primary key,
	description char(40)
);

create table tableexample2
(
	field1 char(10) not null primary key,
	field2 char(30),
	field3 char(15),
	field4 text
);

create table tablereferenced2
(
	field3 char(15) not null primary key,
	description char(40)
);

insert into tablereferenced (field3, description) values
( "thing 1", "descripcion for thing 1"),
( "thing 2", "descripcion for thing 2"),
( "thing 3", "descripcion for thing 3"),
( "thing 4", "descripcion for thing 4"),
( "thing 5", "descripcion for thing 5");

insert into tableexample (field1, field2, field3, field4) values
( "enitity 1", "value for field two en1", "thing 2", "large comment for en1 in textarea"),
( "enitity 2", "value for field two en2", "thing 5", "large comment for en2 in textarea"),
( "enitity 3", "value for field two en3", "thing 4", "large comment for en3 in textarea"),
( "enitity 4", "value for field two en4", "thing 5", "large comment for en4 in textarea"),
( "enitity 5", "value for field two en5", "thing 3", "large comment for en5 in textarea"),
( "enitity 6", "value for field two en6", "thing 1", "large comment for en6 in textarea");

insert into tablereferenced2 (field3, description) values
( "thing 12", "descripcion for thing 12"),
( "thing 22", "descripcion for thing 22"),
( "thing 32", "descripcion for thing 32"),
( "thing 42", "descripcion for thing 42"),
( "thing 52", "descripcion for thing 52");

insert into tableexample2 (field1, field2, field3, field4) values
( "enitity 12", "value for field two en12", "thing 22", "large comment for en12 in textarea"),
( "enitity 22", "value for field two en22", "thing 52", "large comment for en12 in textarea"),
( "enitity 32", "value for field two en32", "thing 42", "large comment for en12 in textarea"),
( "enitity 42", "value for field two en42", "thing 52", "large comment for en12 in textarea"),
( "enitity 52", "value for field two en52", "thing 32", "large comment for en12 in textarea"),
( "enitity 62", "value for field two en62", "thing 12", "large comment for en12 in textarea");