Update of /cvsroot/struts/struts-resume/metadata/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv27889
Added Files:
mysql-create.sql sample-data.xml
Log Message:
--- NEW FILE: mysql-create.sql ---
CREATE DATABASE IF NOT EXISTS resume;
--- NEW FILE: sample-data.xml ---
<dataset>
<table name='user_role'>
<column>id</column>
<column>username</column>
<column>role_name</column>
<row>
<value><![CDATA[1]]></value>
<value><![CDATA[tomcat]]></value>
<value><![CDATA[tomcat]]></value>
</row>
</table>
<table name='skill_group'>
<column>id</column>
<column>name</column>
</table>
<table name='skill'>
<column>id</column>
<column>name</column>
</table>
<table name='app_user'>
<column>id</column>
<column>address</column>
<column>city</column>
<column>country</column>
<column>email</column>
<column>firstName</column>
<column>lastName</column>
<column>password</column>
<column>phoneNumber</column>
<column>postalCode</column>
<column>province</column>
<column>username</column>
<column>website</column>
<row>
<value><![CDATA[1]]></value>
<value><![CDATA[new address]]></value>
<value><![CDATA[]]></value>
<value><![CDATA[]]></value>
<null/>
<value><![CDATA[Tomcat]]></value>
<value><![CDATA[User]]></value>
<value><![CDATA[536c0b339345616c1b33caf454454d8b8a190d6c]]></value>
<null/>
<value><![CDATA[]]></value>
<value><![CDATA[]]></value>
<value><![CDATA[tomcat]]></value>
<null/>
</row>
</table>
<table name='resume'>
<column>id</column>
<column>description</column>
<column>name</column>
<column>objective</column>
<column>user_id</column>
<row>
<value><![CDATA[1]]></value>
<value><![CDATA[description]]></value>
<value><![CDATA[technical]]></value>
<value><![CDATA[to write java]]></value>
<value><![CDATA[1]]></value>
</row>
<row>
<value><![CDATA[2]]></value>
<value><![CDATA[consulting resume]]></value>
<value><![CDATA[consulting]]></value>
<value><![CDATA[to tell people how to write java]]></value>
<value><![CDATA[1]]></value>
</row>
</table>
<table name='education'>
<column>id</column>
<column>degree</column>
<column>gpa</column>
<column>location</column>
<column>name</column>
<column>resumeId</column>
</table>
<table name='skill_category'>
<column>id</column>
<column>name</column>
</table>
</dataset>
|
