Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hi I'm having a problem in regards to index of a table. I just found out that a specific project object (id =90, 128, 126, 97) in my system and query it this error always occurs. I check the data inside the mysql database and it seem has the right index number.

I check the database and here's the result:
mysql> select project_scheme_id, name_code, fk_client_id, project_scheme_index from project_scheme where fk_client_id=1;
+-------------------+------------+--------------+----------------------+
| project_scheme_id | name_code | fk_client_id | project_scheme_index |
+-------------------+------------+--------------+----------------------+
| 28 | AIM | 1 | 0 |
| 29 | AIT | 1 | 1 |
| 30 | AKINMKT | 1 | 2 |
| 31 | ALSONS | 1 | 3 |
| 32 | AMA | 1 | 4 |
| 33 | AYALA | 1 | 5 |
| 34 | BETHLHM | 1 | 6 |
| 35 | BNTB | 1 | 7 |
| 36 | BOEHRINGER | 1 | 8 |
| 37 | BPI | 1 | 9 |
| 38 | BRIGHTPT | 1 | 10 |
| 39 | CALLCENTER | 1 | 11 |
| 40 | CARE | 1 | 12 |
| 41 | CAROUSEL | 1 | 13 |
| 42 | CAROUSELME | 1 | 14 |
| 43 | CAROUSELMP | 1 | 15 |
| 45 | CENTURY | 1 | 16 |
| 46 | COFFEL | 1 | 17 |
| 48 | CYKRIS | 1 | 18 |
| 49 | CYKRISWS | 1 | 19 |
| 50 | DELTACDDBE | 1 | 20 |
| 51 | DeltaEncod | 1 | 21 |
| 52 | DFA | 1 | 22 |
| 53 | DIGA | 1 | 23 |
| 54 | DISCOVERY | 1 | 24 |
| 55 | EARTHSTYLE | 1 | 25 |
| 56 | ePLDT | 1 | 26 |
| 57 | ETELECARE | 1 | 27 |
| 59 | Experian | 1 | 28 |
| 60 | FFCRUZ | 1 | 29 |
| 61 | FRMBLDRS | 1 | 30 |
| 62 | GSIS | 1 | 31 |
| 63 | HONDA | 1 | 32 |
| 65 | JOLLIBEE | 1 | 33 |
| 66 | KFC | 1 | 34 |
| 67 | LANDBANK | 1 | 35 |
| 68 | MAKATI | 1 | 36 |
| 69 | MARAJO | 1 | 37 |
| 70 | MARAJOCARE | 1 | 38 |
| 71 | MIASCOR | 1 | 39 |
| 72 | MILEXP | 1 | 40 |
| 73 | MJS | 1 | 41 |
| 74 | MMDA | 1 | 42 |
| 75 | NATION | 1 | 43 |
| 76 | NETCITI | 1 | 44 |
| 77 | NMC | 1 | 45 |
| 78 | NOKIA | 1 | 46 |
| 79 | NOKIACB | 1 | 47 |
| 80 | NOKIACM | 1 | 48 |
| 81 | NOKIACR261 | 1 | 49 |
| 82 | NOKIACR629 | 1 | 50 |
| 83 | NOKIACR630 | 1 | 51 |
| 84 | NOKIAE | 1 | 52 |
| 85 | NOKIAEER | 1 | 53 |
| 86 | NOKIAGEMS | 1 | 54 |
| 87 | NOKIAIIP | 1 | 55 |
| 88 | NOKIAIIP6 | 1 | 56 |
| 89 | NOKIAPCR | 1 | 57 |
| 90 | None | 1 | 58 |
| 91 | PAG-IBIG | 1 | 59 |
| 92 | PCI | 1 | 60 |
| 93 | PE | 1 | 61 |
| 94 | PETRON | 1 | 62 |
| 95 | PHILIPS | 1 | 63 |
| 96 | PHINMA | 1 | 64 |
| 97 | PHLPSTA | 1 | 65 |
| 98 | PNGOC | 1 | 66 |
| 99 | POEA | 1 | 67 |
| 100 | PQA | 1 | 68 |
| 101 | PSQ | 1 | 69 |
| 102 | RAPID AIR | 1 | 70 |
| 103 | RMGA | 1 | 71 |
| 104 | RMGC5 | 1 | 72 |
| 105 | RMGFB | 1 | 73 |
| 106 | SAFECENTER | 1 | 74 |
| 107 | San Jose | 1 | 75 |
| 108 | SAP | 1 | 76 |
| 109 | SAP4.7 | 1 | 77 |
| 110 | SHAKEYS | 1 | 78 |
| 111 | SHAKEYSB2B | 1 | 79 |
| 112 | SHELL A | 1 | 80 |
| 113 | SHELL N | 1 | 81 |
| 114 | SHELL S | 1 | 82 |
| 115 | SOUTHFIELD | 1 | 83 |
| 116 | SSIP | 1 | 84 |
| 117 | SSIPIDM | 1 | 85 |
| 118 | SSIPITS | 1 | 86 |
| 119 | SSIP-USA | 1 | 87 |
| 120 | SSIPWC | 1 | 88 |
| 121 | SSIPWS | 1 | 89 |
| 122 | ST.LUKES | 1 | 90 |
| 123 | SYNEX | 1 | 91 |
| 124 | TOGI | 1 | 92 |
| 125 | UAP | 1 | 93 |
| 126 | UCC24 | 1 | 94 |
| 127 | UCCEP | 1 | 95 |
| 128 | UCCES | 1 | 96 |
| 129 | UCCHDESK | 1 | 97 |
| 130 | UCCITS | 1 | 98 |
| 131 | UCCK | 1 | 99 |
| 132 | UCCPDA | 1 | 100 |
| 133 | UCCPRCW | 1 | 101 |
| 134 | UCCTC | 1 | 102 |
| 135 | UCCTS | 1 | 103 |
| 136 | UCCWS | 1 | 104 |
| 137 | UCCWT | 1 | 105 |
| 138 | UNIOIL | 1 | 106 |
| 139 | UNION | 1 | 107 |
| 140 | VGOLF | 1 | 108 |
| 141 | WFP | 1 | 109 |
| 142 | ZCMA | 1 | 110 |
+-------------------+------------+--------------+----------------------+
111 rows in set (0.00 sec)

Please help.

Hibernate version:
2.1.6
Mapping documents:
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping
>
<class
name="com.ssip.onlinewar.common.valueobject.CommonPartVO"
table="common_part"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version"
>

<id
name="documentId"
column="document_id"
type="long"
unsaved-value="-1"
>
<generator class="increment">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-CommonPartVO.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="name"
type="string"
update="true"
insert="true"
access="property"
column="name"
/>

<property
name="lastModified"
type="timestamp"
update="true"
insert="true"
access="property"
column="last_modified"
/>

<property
name="documentType"
type="int"
update="true"
insert="true"
access="property"
column="document_type"
/>

<list
name="userAccess"
table="user_access"
lazy="false"
inverse="false"
cascade="save-update"
>

<key
column="fk_document_id"
>
</key>

<index
column="user_access_index"
/>

<one-to-many
class="com.ssip.onlinewar.common.valueobject.UserAccessVO"
/>

</list>

<list
name="userGroupAccess"
lazy="false"
inverse="false"
cascade="save-update"
>

<key
column="fk_document_id"
>
</key>

<index
column="usergroup_access_index"
/>

<one-to-many
class="com.ssip.onlinewar.common.valueobject.UserGroupAccessVO"
/>

</list>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-CommonPartVO.xml
containing the additional properties and place it in your merge dir.
-->

<joined-subclass
name="com.ssip.onlinewar.common.valueobject.LeaveRequestVO"
table="leave_request"
dynamic-update="false"
dynamic-insert="false"
>
<key
column="leave_request_id"
/>

<property
name="startDate"
type="date"
update="true"
insert="true"
access="property"
column="start_date"
/>

<property
name="endDate"
type="date"
update="true"
insert="true"
access="property"
column="end_date"
/>

<property
name="actualNumberDays"
type="short"
update="true"
insert="true"
access="property"
column="actual_num_days"
/>

<property
name="dateOfHalfDay"
type="date"
update="true"
insert="true"
access="property"
column="date_of_halfday"
/>

<property
name="reason"
type="string"
update="true"
insert="true"
access="property"
column="reason"
/>

<property
name="approved"
type="boolean"
update="true"
insert="true"
access="property"
column="is_approved"
/>

<property
name="rejected"
type="boolean"
update="true"
insert="true"
access="property"
column="is_rejected"
/>

<property
name="dateApprovedOrRejected"
type="date"
update="true"
insert="true"
access="property"
column="date_approved_rejected"
/>

<property
name="status"
type="int"
update="true"
insert="true"
access="property"
column="status"
/>

<property
name="typeOfLeave"
type="int"
update="true"
insert="true"
access="property"
column="type_of_leave"
/>

<many-to-one
name="owner"
class="com.ssip.onlinewar.common.valueobject.UserVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_employee_id"
/>

<many-to-one
name="approver"
class="com.ssip.onlinewar.common.valueobject.UserVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_approver_id"
/>

</joined-subclass>
<joined-subclass
name="com.ssip.onlinewar.common.valueobject.ProjectSchemeVO"
table="project_scheme"
dynamic-update="false"
dynamic-insert="false"
>
<key
column="project_scheme_id"
/>

<property
name="code"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="name_code"
/>

<property
name="description"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="description"
/>

<property
name="startDate"
type="date"
update="true"
insert="true"
access="property"
column="start_date"
/>

<property
name="endDate"
type="date"
update="true"
insert="true"
access="property"
column="end_date"
/>

<many-to-one
name="customer"
class="com.ssip.onlinewar.common.valueobject.ClientVO"
cascade="delete"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_client_id"
not-null="true"
/>

<property
name="index"
type="int"
update="true"
insert="true"
access="property"
column="project_scheme_index"
/>

<many-to-one
name="owner"
class="com.ssip.onlinewar.common.valueobject.UserVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_owner_id"
/>

<list
name="projectItems"
lazy="false"
inverse="false"
cascade="all"
>

<key
column="fk_project_scheme_id"
>
</key>

<index
column="project_item_index"
/>

<one-to-many
class="com.ssip.onlinewar.common.valueobject.ProjectItemVO"
/>

</list>

</joined-subclass>
<joined-subclass
name="com.ssip.onlinewar.common.valueobject.HolidayVO"
table="holiday"
dynamic-update="false"
dynamic-insert="false"
>
<key
column="holiday_id"
/>

<property
name="effectiveDate"
type="date"
update="true"
insert="true"
access="property"
column="effective_date"
/>

<property
name="type"
type="int"
update="true"
insert="true"
access="property"
column="holiday_type"
/>

<property
name="description"
type="string"
update="true"
insert="true"
access="property"
column="description"
/>

<property
name="accessType"
type="int"
update="true"
insert="true"
access="property"
column="access_type"
/>

<property
name="countryCode"
type="int"
update="true"
insert="true"
access="property"
column="country_code"
/>

</joined-subclass>

</class>

</hibernate-mapping>


<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping
>
<class
name="com.ssip.onlinewar.common.valueobject.ClientVO"
table="client"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version"
>

<id
name="clientId"
column="client_id"
type="long"
unsaved-value="-1"
>
<generator class="increment">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-ClientVO.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="clientName"
type="string"
update="true"
insert="true"
access="property"
column="client_name"
/>

<property
name="abbreviation"
type="string"
update="true"
insert="true"
access="property"
column="abbreviation"
/>

<list
name="projectPlan"
lazy="true"
inverse="true"
cascade="all"
>

<key
column="fk_client_id"
>
</key>

<index
column="project_scheme_index"
/>

<one-to-many
class="com.ssip.onlinewar.common.valueobject.ProjectSchemeVO"
/>

</list>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-ClientVO.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>


<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping
>
<class
name="com.ssip.onlinewar.common.valueobject.ActivityVO"
table="activity"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version"
>

<id
name="activityId"
column="activity_id"
type="long"
unsaved-value="-1"
>
<generator class="increment">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-ActivityVO.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="description"
type="string"
update="true"
insert="true"
access="property"
column="description"
/>

<property
name="startDateTime"
type="timestamp"
update="true"
insert="true"
access="property"
column="start_date_time"
/>

<property
name="endDateTime"
type="timestamp"
update="true"
insert="true"
access="property"
column="end_date_time"
/>

<property
name="remarks"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="remarks"
/>

<many-to-one
name="activityType"
class="com.ssip.onlinewar.common.valueobject.ActivityTypeVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_activity_type_id"
/>

<many-to-one
name="subActivityType"
class="com.ssip.onlinewar.common.valueobject.SubActivityTypeVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_subactivity_type_id"
/>

<many-to-one
name="overTimeWork"
class="com.ssip.onlinewar.common.valueobject.OverTimeVO"
cascade="all"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_overtime_id"
/>

<many-to-one
name="projectScheme"
class="com.ssip.onlinewar.common.valueobject.ProjectSchemeVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_project_scheme_id"
/>

<many-to-one
name="projectItem"
class="com.ssip.onlinewar.common.valueobject.ProjectItemVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_project_item_id"
/>

<many-to-one
name="userActivity"
class="com.ssip.onlinewar.common.valueobject.UserActivityVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="FK_USER_ACTIVITY_ID"
not-null="true"
/>

<property
name="index"
type="int"
update="true"
insert="true"
access="property"
column="ACTIVITY_INDEX"
/>

<many-to-one
name="associatedHoliday"
class="com.ssip.onlinewar.common.valueobject.HolidayVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_holiday_id"
/>

<many-to-one
name="associatedLeaveRequest"
class="com.ssip.onlinewar.common.valueobject.LeaveRequestVO"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="fk_leave_request_id"
/>

<property
name="perDiem"
type="boolean"
update="true"
insert="true"
access="property"
column="has_per_diem"
/>

<property
name="overTime"
type="boolean"
update="true"
insert="true"
access="property"
column="has_over_time"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-ActivityVO.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
java.lang.NullPointerException
In this.getProjectSchemeId()=24
In this.getDocumentId()=24
java.lang.NullPointerException
at net.sf.hibernate.collection.List.indexOf(List.java:249)
at com.ssip.onlinewar.common.valueobject.ProjectSchemeVO.getIndex(Projec
tSchemeVO.java:136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(Basic
PropertyAccessor.java:96)
at net.sf.hibernate.persister.AbstractEntityPersister.getPropertyValues(
AbstractEntityPersister.java:246)
at net.sf.hibernate.impl.SessionImpl.flushEntity(SessionImpl.java:2474)
at net.sf.hibernate.impl.SessionImpl.flushEntities(SessionImpl.java:2458
)
at net.sf.hibernate.impl.SessionImpl.flushEverything(SessionImpl.java:22
60)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2239)
at org.springframework.orm.hibernate.HibernateAccessor.flushIfNecessary(
HibernateAccessor.java:214)
at org.springframework.orm.hibernate.HibernateInterceptor.invoke(Hiberna
teInterceptor.java:164)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:174)
at $Proxy78.query(Unknown Source)
at com.ssip.onlinewar.web.action.QueryAction.execute(QueryAction.java:76
)
at org.springframework.web.struts.DelegatingActionProxy.execute(Delegati
ngActionProxy.java:105)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:116
4)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilte
r.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.appfuse.web.MessageFilter.doFilter(MessageFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doF
ilterInternal(OpenSessionInViewFilter.java:171)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:644)
at java.lang.Thread.run(Thread.java:534)
ERROR - QueryAction.execute(83) | Error: org.springframework.orm.hibernate.Hiber
nateSystemException: Exception occurred inside getter of com.ssip.onlinewar.comm
on.valueobject.ProjectSchemeVO.index; nested exception is net.sf.hibernate.Prope
rtyAccessException: Exception occurred inside getter of com.ssip.onlinewar.commo
n.valueobject.ProjectSchemeVO.index
Name and version of the database you are using:
Mysql 4.1
The generated SQL (show_sql=true):
This HSQL that generates error in my database:
select a from ActivityVO as a where a.projectScheme.documentId=97

Debug level Hibernate log excerpt:

Hibernate people please help me on this one. I don't know exactly why it is behaving like this. I have check the index number but it seems perfectly fine.

even with this kind of hsql:
String query = " select activity from ActivityVO as activity " +
" where activity.startDateTime >= '"+startDate+"' and activity.endDateTime <= '"+endDate+"' AND " +
" (activity.activityType.code='C1' or activity.activityType.code='C2' or activity.activityType.code='C3')" +
" order by activity.projectScheme.documentId, activity.activityType.activityTypeId, " +
" activity.subActivityType.subActivityTypeId ";

im encountering this problem with the use of activity.projectScheme.documentId....

my complete sql script is here:

-- MySQL dump 10.9
--
-- Host: localhost Database: wardb
-- ------------------------------------------------------
-- Server version 4.1.8-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;

--
-- Current Database: `wardb`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wardb` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `wardb`;

--
-- Table structure for table `account`
--

DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`account_id` bigint(20) NOT NULL default '0',
`username` varchar(255) default NULL,
`password` varchar(255) default NULL,
`is_lock` tinyint(1) default NULL,
`role` int(11) default NULL,
`status` int(11) default NULL,
`fk_ssip_group_id` bigint(20) default NULL,
PRIMARY KEY (`account_id`),
UNIQUE KEY `username` (`username`),
KEY `FKB9D38A2DEF4D4E99` (`fk_ssip_group_id`),
CONSTRAINT `FKB9D38A2DEF4D4E99` FOREIGN KEY (`fk_ssip_group_id`) REFERENCES `ssip_group` (`ssip_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account`
--


/*!40000 ALTER TABLE `account` DISABLE KEYS */;
LOCK TABLES `account` WRITE;
INSERT INTO `account` VALUES (1,'jgodinez','ssip',0,2,1,NULL),(2,'rpunzalan','ssip',0,2,1,NULL),(3,'kdy','ssip',0,2,2,NULL),(4,'rbinuya','ssip',0,1,1,NULL),(5,'fyanga','ssip',0,1,1,NULL),(6,'kkyamko','ssip',0,1,1,NULL),(7,'ldeguzman','ssip',0,1,1,NULL),(8,'jvillanueva','ssip',0,2,1,NULL),(9,'rlumabi','ssip',0,1,1,NULL),(10,'lbondoc','ssip',0,1,2,NULL),(11,'maquino','ssip',0,1,1,NULL),(12,'rbarcelon','ssip',0,1,1,NULL),(13,'mdelrosario','ssip',0,1,1,NULL),(14,'shernandez','ssip',0,1,1,NULL),(15,'suy','ssip',0,1,1,NULL),(16,'rorea','ssip',0,1,1,NULL),(17,'mruiz','ssip',0,1,1,NULL),(18,'rchua','ssip',0,1,1,NULL),(19,'gbuterbaugh','ssip',0,1,1,NULL),(20,'asuero','ssip',0,1,1,NULL),(21,'canonuevo','ssip',0,1,1,NULL),(22,'amicua','ssip',0,1,1,NULL),(23,'apeciller','ssip',0,1,1,NULL),(24,'ahao','ssip',0,1,1,NULL),(25,'mpilapil','ssip',0,1,1,NULL),(26,'rhalili','ssip',0,1,1,NULL),(27,'terminator','ssip',0,1,0,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;

--
-- Table structure for table `activity`
--

DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
`activity_id` bigint(20) NOT NULL default '0',
`description` varchar(255) default NULL,
`start_date_time` datetime default NULL,
`end_date_time` datetime default NULL,
`remarks` varchar(255) default NULL,
`fk_activity_type_id` bigint(20) default NULL,
`fk_subactivity_type_id` bigint(20) default NULL,
`fk_overtime_id` bigint(20) default NULL,
`fk_project_scheme_id` bigint(20) default NULL,
`fk_project_item_id` bigint(20) default NULL,
`FK_USER_ACTIVITY_ID` bigint(20) NOT NULL default '0',
`ACTIVITY_INDEX` int(11) default NULL,
`fk_holiday_id` bigint(20) default NULL,
`fk_leave_request_id` bigint(20) default NULL,
`has_per_diem` tinyint(1) default NULL,
`has_over_time` tinyint(1) default NULL,
PRIMARY KEY (`activity_id`),
KEY `FK9D4BF30F3D76561C` (`fk_holiday_id`),
KEY `FK9D4BF30F953D4755` (`fk_project_scheme_id`),
KEY `FK9D4BF30F2B47D34A` (`fk_activity_type_id`),
KEY `FK9D4BF30F7899978D` (`fk_leave_request_id`),
KEY `FK9D4BF30FEE4BED6` (`fk_subactivity_type_id`),
KEY `FK9D4BF30F2606E7FF` (`fk_overtime_id`),
KEY `FK9D4BF30F3542C211` (`FK_USER_ACTIVITY_ID`),
KEY `FK9D4BF30FADB7BB27` (`fk_project_item_id`),
CONSTRAINT `FK9D4BF30F2606E7FF` FOREIGN KEY (`fk_overtime_id`) REFERENCES `overtime` (`overtime_id`),
CONSTRAINT `FK9D4BF30F2B47D34A` FOREIGN KEY (`fk_activity_type_id`) REFERENCES `activity_type` (`activity_type_id`),
CONSTRAINT `FK9D4BF30F3542C211` FOREIGN KEY (`FK_USER_ACTIVITY_ID`) REFERENCES `user_activity` (`user_activity_id`),
CONSTRAINT `FK9D4BF30F3D76561C` FOREIGN KEY (`fk_holiday_id`) REFERENCES `holiday` (`holiday_id`),
CONSTRAINT `FK9D4BF30F7899978D` FOREIGN KEY (`fk_leave_request_id`) REFERENCES `leave_request` (`leave_request_id`),
CONSTRAINT `FK9D4BF30F953D4755` FOREIGN KEY (`fk_project_scheme_id`) REFERENCES `project_scheme` (`project_scheme_id`),
CONSTRAINT `FK9D4BF30FADB7BB27` FOREIGN KEY (`fk_project_item_id`) REFERENCES `project_item` (`project_item_id`),
CONSTRAINT `FK9D4BF30FEE4BED6` FOREIGN KEY (`fk_subactivity_type_id`) REFERENCES `sub_activity_type` (`sub_activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activity`
--


/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
LOCK TABLES `activity` WRITE;
INSERT INTO `activity` VALUES (3,'k','2005-03-15 03:00:46','2005-03-15 04:00:46',NULL,1,NULL,NULL,90,NULL,2,0,NULL,NULL,1,0),(4,'Online WAR; Send email to Kirt','2005-03-15 09:20:26','2005-03-15 11:00:26','',2,12,NULL,116,NULL,1,0,NULL,NULL,0,0),(5,'eWAR cutoff','2005-03-15 11:00:26','2005-03-15 12:00:26','',6,NULL,NULL,90,NULL,1,1,NULL,NULL,0,0),(6,'Lunch','2005-03-15 12:20:26','2005-03-15 14:00:26','',1,NULL,NULL,90,NULL,1,2,NULL,NULL,0,0),(7,'OnlineWAR','2005-03-15 14:00:26','2005-03-15 15:00:26','',2,12,NULL,116,NULL,1,3,NULL,NULL,0,0),(8,'ITS setup of Online WAR','2005-03-15 15:00:26','2005-03-15 15:45:26','',2,14,NULL,116,NULL,1,4,NULL,NULL,0,0),(9,'OnlineWAR','2005-03-15 15:45:26','2005-03-15 19:00:26','',2,12,NULL,116,NULL,1,5,NULL,NULL,0,0),(10,'Email','2005-03-16 09:45:26','2005-03-16 10:10:26','',10,NULL,NULL,90,NULL,1,6,NULL,NULL,0,0),(11,'OnlineWAR','2005-03-16 10:10:26','2005-03-16 11:10:26','',2,12,NULL,116,NULL,1,7,NULL,NULL,0,0),(12,'SSIP website content; send email','2005-03-16 11:10:26','2005-03-16 12:10:26','',2,14,NULL,116,NULL,1,8,NULL,NULL,0,0),(13,'Lunch','2005-03-16 12:10:26','2005-03-16 13:10:26','',1,NULL,NULL,90,NULL,1,9,NULL,NULL,0,0),(14,'Update sample SLA','2005-03-16 13:10:26','2005-03-16 14:10:26','',7,NULL,NULL,90,NULL,1,10,NULL,NULL,0,0),(15,'OnlineWAR; Send email','2005-03-16 14:10:26','2005-03-16 17:30:26','',2,12,NULL,107,NULL,1,11,NULL,NULL,0,0),(16,'Check AG&P SLA','2005-03-16 17:30:26','2005-03-16 17:52:26','',2,14,NULL,27,NULL,1,12,NULL,NULL,0,0),(17,'eWAR','2005-03-16 17:52:26','2005-03-16 18:10:26','',6,NULL,NULL,90,NULL,1,13,NULL,NULL,0,0),(18,'OnlineWAR ITS Guidelines','2005-03-16 18:10:26','2005-03-16 19:00:26','',2,14,NULL,116,NULL,1,14,NULL,NULL,0,0),(19,'Check onlineWAR in ITS; Generate SQL','2005-03-17 09:30:26','2005-03-17 10:00:26','',2,14,NULL,116,NULL,1,15,NULL,NULL,0,0),(20,'Revise workflow for ITS Onlines WAR','2005-03-17 10:00:26','2005-03-17 12:30:26','',2,14,NULL,116,NULL,1,16,NULL,NULL,0,0),(21,'Lunch','2005-03-17 12:30:26','2005-03-17 13:30:26','',1,NULL,NULL,90,NULL,1,17,NULL,NULL,0,0),(22,'Check SSIP website changes; Send email','2005-03-17 13:30:26','2005-03-17 14:30:26','',2,14,NULL,116,NULL,1,18,NULL,NULL,0,0),(23,'Update Style Guide','2005-03-17 14:30:26','2005-03-17 15:10:26','',7,NULL,NULL,90,NULL,1,19,NULL,NULL,0,0),(24,'Personal','2005-03-17 15:10:26','2005-03-17 18:10:26','',10,NULL,NULL,90,NULL,1,20,NULL,NULL,0,0),(25,'Send email for changes in website','2005-03-18 09:05:26','2005-03-18 09:45:26','',2,8,NULL,116,NULL,1,21,NULL,NULL,0,0),(26,'Email','2005-03-18 09:45:26','2005-03-18 10:00:26','',10,NULL,NULL,90,NULL,1,22,NULL,NULL,0,0),(27,'Create ITS SSIPWEB guidelines','2005-03-18 10:00:26','2005-03-18 12:00:26','',2,14,NULL,116,NULL,1,23,NULL,NULL,0,0),(28,'Lunch','2005-03-18 12:00:26','2005-03-18 13:00:26','',1,NULL,NULL,90,NULL,1,24,NULL,NULL,0,0),(29,'eWAR','2005-03-18 13:00:26','2005-03-18 14:00:26','',6,NULL,NULL,90,NULL,1,25,NULL,NULL,0,0),(30,'Individual WAR printout; with Kirt','2005-03-18 14:00:26','2005-03-18 15:00:26','',2,8,NULL,125,NULL,1,26,NULL,NULL,0,0),(32,'dff','2005-03-15 09:00:43','2005-03-15 12:00:43',NULL,2,2,NULL,91,NULL,3,0,NULL,NULL,1,0),(34,'fff','2005-03-15 12:00:43','2005-03-15 13:00:43',NULL,2,2,NULL,24,NULL,3,1,NULL,NULL,0,0),(35,'ssss','2005-03-17 13:00:43','2005-03-17 14:00:43',NULL,3,NULL,NULL,24,NULL,3,2,NULL,NULL,0,0),(36,'blah blah','2005-03-01 08:00:55','2005-03-01 17:00:55',NULL,2,1,NULL,24,NULL,4,0,NULL,NULL,0,0),(37,'fsdfd','2005-03-15 00:00:48','2005-03-15 01:00:48',NULL,1,NULL,NULL,90,NULL,5,0,NULL,NULL,0,0),(38,'fsdf','2005-03-15 01:00:48','2005-03-15 03:00:48',NULL,1,NULL,NULL,90,NULL,5,1,NULL,NULL,0,0),(39,'dghdghdgh','2005-03-15 03:00:48','2005-03-15 03:25:48',NULL,1,NULL,NULL,90,NULL,5,2,NULL,NULL,0,0),(40,'Sick','2005-03-19 08:00:26','2005-03-19 16:00:26','',9,22,NULL,90,NULL,1,27,NULL,NULL,0,0),(41,'Research','2005-03-22 08:00:26','2005-03-22 17:00:26','',5,NULL,NULL,90,NULL,1,28,NULL,NULL,0,0),(42,'Storm','2005-03-23 08:00:26','2005-03-23 17:00:26','',9,16,NULL,90,NULL,1,29,NULL,NULL,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;

--
-- Table structure for table `activity_period`
--

DROP TABLE IF EXISTS `activity_period`;
CREATE TABLE `activity_period` (
`activity_period_id` bigint(20) NOT NULL default '0',
`start_date` date default NULL,
`end_date` date default NULL,
`freezing_date_time` datetime default NULL,
PRIMARY KEY (`activity_period_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activity_period`
--


/*!40000 ALTER TABLE `activity_period` DISABLE KEYS */;
LOCK TABLES `activity_period` WRITE;
INSERT INTO `activity_period` VALUES (1,'2005-01-04','2005-01-14','2005-01-17 13:00:00'),(2,'2005-01-15','2005-01-31','2005-02-01 13:00:00'),(3,'2005-02-01','2005-02-14','2005-04-23 13:00:00'),(4,'2005-02-15','2005-02-28','2005-03-01 13:00:00'),(5,'2005-03-01','2005-03-14','2005-03-15 13:00:00'),(6,'2005-03-15','2005-03-31','2005-04-01 13:00:00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `activity_period` ENABLE KEYS */;

--
-- Table structure for table `activity_type`
--

DROP TABLE IF EXISTS `activity_type`;
CREATE TABLE `activity_type` (
`activity_type_id` bigint(20) NOT NULL default '0',
`activity_name` varchar(255) default NULL,
`code` varchar(255) default NULL,
PRIMARY KEY (`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activity_type`
--


/*!40000 ALTER TABLE `activity_type` DISABLE KEYS */;
LOCK TABLES `activity_type` WRITE;
INSERT INTO `activity_type` VALUES (1,'Break','B1'),(2,'Project Impl Activities','C1'),(3,'Post Live Support','C2'),(4,'Mktg Activities','C3'),(5,'Training/Research','I1'),(6,'HR/Admin Activities','I2'),(7,'Internal Meetings/ Reports','I3'),(8,'Tech Support','I4'),(9,'Leaves','I5'),(10,'Personal','I6');
UNLOCK TABLES;
/*!40000 ALTER TABLE `activity_type` ENABLE KEYS */;

--
-- Table structure for table `app_user`
--

DROP TABLE IF EXISTS `app_user`;
CREATE TABLE `app_user` (
`id` bigint(20) NOT NULL default '0',
`firstName` varchar(255) default NULL,
`lastName` varchar(255) default NULL,
`birthday` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_user`
--


/*!40000 ALTER TABLE `app_user` DISABLE KEYS */;
LOCK TABLES `app_user` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `app_user` ENABLE KEYS */;

--
-- Table structure for table `client`
--

DROP TABLE IF EXISTS `client`;
CREATE TABLE `client` (
`client_id` bigint(20) NOT NULL default '0',
`client_name` varchar(255) default NULL,
`abbreviation` varchar(255) default NULL,
PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client`
--


/*!40000 ALTER TABLE `client` DISABLE KEYS */;
LOCK TABLES `client` WRITE;
INSERT INTO `client` VALUES (1,'None','NONE'),(2,'SSIP Asia Inc.','SSIP'),(3,'Nokia Finland','NOKIA'),(4,'Holcim Phils','HOLCIM'),(5,'Centre Solutions','CENTRE'),(6,'Cooper Industries','COOPER'),(7,'Atlantic Gulf and the Pacific','AGP'),(8,'Manila Metropolitan Development Authority','MMDA'),(9,'Asian Institute of Management','AIM'),(10,'Asian Institute of Technology','AIT'),(11,'Makati City Hall','MAKATI'),(12,'AMA Computer College','AMA'),(13,'Ayala','AYALA'),(14,'Bethlehem Solutions','BETHLHM'),(15,'Bank of Butterfield','BNTB'),(16,'Boehringer Engelheim Corporation','BOEHRINGER'),(17,'Bank of the Philippine Islands','BPI'),(18,'Bright Point','BRIGHTPT'),(19,'Marajo','MARAJO'),(20,'Carousel Philippines','CAROUSEL'),(21,'Century','CENTURY'),(22,'Coffel','COFFEL'),(23,'Cykris','CYKRIS'),(24,'Delta Vista','DELTA'),(25,'Department of Foreign Affairs','DFA'),(26,'DIGA Golf','DIGA'),(27,'Discovery Suites','DISCOVERY'),(28,'Earth Style','EARTHSTYLE'),(29,'Philippine Long Distance and Telecommunications','PLDT'),(30,'eTeleCare','ETELECARE'),(31,'Experian Business Information and Solution','EXPERIAN'),(32,'FFCruz','FFCRUZ'),(33,'Farm Builders','FRMBLDRS'),(34,'Government Security and Insurance System','GSIS'),(35,'Honda','HONDA'),(36,'Jollibee','JOLLIBEE'),(37,'Kentucky Fried Chicken','KFC'),(38,'Landbank','LANDBANK'),(39,'Miascor','MIASCOR'),(40,'Mil Export','MILEXP'),(41,'MJS','MJS'),(42,'Nation Gas','NATION'),(43,'NetCiti','NETCITI'),(44,'National Marine Corporation','NMC'),(45,'Pag-ibig Fund','PAG-IBIG'),(46,'PCI Bank','PCI'),(47,'Perkin Elmer','PE'),(48,'Petron Corporation','PETRON'),(49,'Philips','PHILIPS'),(50,'PhilPesta','PHLPSTA'),(51,'Philippine Non Government Organization Council','PNGOC'),(52,'Philippine Overseas Employment and Administration','POEA'),(53,'Philippine Quality Awards','PQA'),(54,'Philippine Society for Quality','PSQ'),(55,'Rapid Air Freight','RAPID AIR'),(56,'RMGA','RMGA'),(57,'RMGC5','RMGC5'),(58,'RMGFB','RMGFB'),(59,'Safety Center','SAFECENTER'),(60,'San Jose Realty Development Corporation','SANJOSE'),(61,'Systems Applications and Processes','SAP'),(62,'Shakey\'s','SHAKEYS'),(63,'Shell Corporation','SHELL'),(64,'South Field','SOUTHFIELD'),(65,'St. Luke\'s Hospital','STLUKES'),(66,'Synex Technologies','SYNEX'),(67,'Togi','TOGI'),(68,'University of Asia and the Pacific','UAP'),(69,'UniOil','UNIOIL'),(70,'Valley Golf and Country Club','VGOLF'),(71,'World Food Program','WFP'),(72,'Zurich Capital Markets','ZCMA');
UNLOCK TABLES;
/*!40000 ALTER TABLE `client` ENABLE KEYS */;

--
-- Table structure for table `common_part`
--

DROP TABLE IF EXISTS `common_part`;
CREATE TABLE `common_part` (
`document_id` bigint(20) NOT NULL default '0',
`name` varchar(255) default NULL,
`last_modified` datetime default NULL,
`document_type` int(11) default NULL,
PRIMARY KEY (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `common_part`
--


/*!40000 ALTER TABLE `common_part` DISABLE KEYS */;
LOCK TABLES `common_part` WRITE;
INSERT INTO `common_part` VALUES (1,'New Year\'s Day','2005-03-10 00:00:00',1),(2,'President\'s Day','2005-03-10 00:00:00',1),(3,'EDSA Anniv','2005-03-10 00:00:00',1),(4,'Maundy Thursday','2005-03-10 00:00:00',1),(5,'Good Friday','2005-03-10 00:00:00',1),(6,'Black Saturday','2005-03-10 00:00:00',1),(7,'Araw ng Kagitingan','2005-03-10 00:00:00',1),(8,'PHLabor Day','2005-03-10 00:00:00',1),(9,'USMemorial Day','2005-03-10 00:00:00',1),(10,'PHIndependence Day','2005-03-10 00:00:00',1),(11,'USIndependence Day','2005-03-10 00:00:00',1),(12,'Martyrdom of NA','2005-03-10 00:00:00',1),(13,'National Heroes Day','2005-03-10 00:00:00',1),(14,'USLabor Day','2005-03-10 00:00:00',1),(15,'All Saint\'s Day','2005-03-10 00:00:00',1),(16,'Eid Ul Fitre','2005-03-10 00:00:00',1),(17,'Veteran\'s Day','2005-03-10 00:00:00',1),(18,'Thanksgiving Day','2005-03-10 00:00:00',1),(19,'Bonifacio Day','2005-03-10 00:00:00',1),(20,'Christmas Observed','2005-03-10 00:00:00',1),(21,'Christmas Day','2005-03-10 00:00:00',1),(22,'Rizal Day','2005-03-10 00:00:00',1),(23,'Last Day of the Year','2005-03-10 00:00:00',1),(24,'AG&P-Email','2005-03-11 00:00:00',0),(25,'AG&P-LAN','2005-03-11 00:00:00',0),(26,'AG&P-OMD','2005-03-11 00:00:00',0),(27,'AGP','2005-03-11 00:00:00',0),(28,'AIM','2005-03-11 00:00:00',0),(29,'AIT','2005-03-11 00:00:00',0),(30,'AKINMKT','2005-03-11 00:00:00',0),(31,'ALSONS','2005-03-11 00:00:00',0),(32,'AMA','2005-03-11 00:00:00',0),(33,'AYALA','2005-03-11 00:00:00',0),(34,'BETHLHM','2005-03-11 00:00:00',0),(35,'BNTB','2005-03-11 00:00:00',0),(36,'BOEHRINGER','2005-03-11 00:00:00',0),(37,'BPI','2005-03-11 00:00:00',0),(38,'BRIGHTPT','2005-03-11 00:00:00',0),(39,'CALLCENTER','2005-03-11 00:00:00',0),(40,'CARE','2005-03-11 00:00:00',0),(41,'CAROUSEL','2005-03-11 00:00:00',0),(42,'CAROUSELME','2005-03-11 00:00:00',0),(43,'CAROUSELMP','2005-03-11 00:00:00',0),(44,'CENSOL','2005-03-11 00:00:00',0),(45,'CENTURY','2005-03-11 00:00:00',0),(46,'COFFEL','2005-03-11 00:00:00',0),(47,'COOPER','2005-03-11 00:00:00',0),(48,'CYKRIS','2005-03-11 00:00:00',0),(49,'CYKRISWS','2005-03-11 00:00:00',0),(50,'DELTACDDBE','2005-03-11 00:00:00',0),(51,'DeltaEncod','2005-03-11 00:00:00',0),(52,'DFA','2005-03-11 00:00:00',0),(53,'DIGA','2005-03-11 00:00:00',0),(54,'DISCOVERY','2005-03-11 00:00:00',0),(55,'EARTHSTYLE','2005-03-11 00:00:00',0),(56,'ePLDT','2005-03-11 00:00:00',0),(57,'ETELECARE','2005-03-11 00:00:00',0),(58,'EWAR2','2005-03-11 00:00:00',0),(59,'Experian','2005-03-11 00:00:00',0),(60,'FFCRUZ','2005-03-11 00:00:00',0),(61,'FRMBLDRS','2005-03-11 00:00:00',0),(62,'GSIS','2005-03-11 00:00:00',0),(63,'HONDA','2005-03-11 00:00:00',0),(64,'IDM','2005-03-11 00:00:00',0),(65,'JOLLIBEE','2005-03-11 00:00:00',0),(66,'KFC','2005-03-11 00:00:00',0),(67,'LANDBANK','2005-03-11 00:00:00',0),(68,'MAKATI','2005-03-11 00:00:00',0),(69,'MARAJO','2005-03-11 00:00:00',0),(70,'MARAJOCARE','2005-03-11 00:00:00',0),(71,'MIASCOR','2005-03-11 00:00:00',0),(72,'MILEXP','2005-03-11 00:00:00',0),(73,'MJS','2005-03-11 00:00:00',0),(74,'MMDA','2005-03-11 00:00:00',0),(75,'NATION','2005-03-11 00:00:00',0),(76,'NETCITI','2005-03-11 00:00:00',0),(77,'NMC','2005-03-11 00:00:00',0),(78,'NOKIA','2005-03-11 00:00:00',0),(79,'NOKIACB','2005-03-11 00:00:00',0),(80,'NOKIACM','2005-03-11 00:00:00',0),(81,'NOKIACR261','2005-03-11 00:00:00',0),(82,'NOKIACR629','2005-03-11 00:00:00',0),(83,'NOKIACR630','2005-03-11 00:00:00',0),(84,'NOKIAE','2005-03-11 00:00:00',0),(85,'NOKIAEER','2005-03-11 00:00:00',0),(86,'NOKIAGEMS','2005-03-11 00:00:00',0),(87,'NOKIAIIP','2005-03-11 00:00:00',0),(88,'NOKIAIIP6','2005-03-11 00:00:00',0),(89,'NOKIAPCR','2005-03-11 00:00:00',0),(90,'None','2005-03-11 00:00:00',0),(91,'PAG-IBIG','2005-03-11 00:00:00',0),(92,'PCI','2005-03-11 00:00:00',0),(93,'PE','2005-03-11 00:00:00',0),(94,'PETRON','2005-03-11 00:00:00',0),(95,'PHILIPS','2005-03-11 00:00:00',0),(96,'PHINMA','2005-03-11 00:00:00',0),(97,'PHLPSTA','2005-03-11 00:00:00',0),(98,'PNGOC','2005-03-11 00:00:00',0),(99,'POEA','2005-03-11 00:00:00',0),(100,'PQA','2005-03-11 00:00:00',0),(101,'PSQ','2005-03-11 00:00:00',0),(102,'RAPID AIR','2005-03-11 00:00:00',0),(103,'RMGA','2005-03-11 00:00:00',0),(104,'RMGC5','2005-03-11 00:00:00',0),(105,'RMGFB','2005-03-11 00:00:00',0),(106,'SAFECENTER','2005-03-11 00:00:00',0),(107,'San Jose','2005-03-11 00:00:00',0),(108,'SAP','2005-03-11 00:00:00',0),(109,'SAP4.7','2005-03-11 00:00:00',0),(110,'SHAKEYS','2005-03-11 00:00:00',0),(111,'SHAKEYSB2B','2005-03-11 00:00:00',0),(112,'SHELL A','2005-03-11 00:00:00',0),(113,'SHELL N','2005-03-11 00:00:00',0),(114,'SHELL S','2005-03-11 00:00:00',0),(115,'SOUTHFIELD','2005-03-11 00:00:00',0),(116,'SSIP','2005-03-11 00:00:00',0),(117,'SSIPIDM','2005-03-11 00:00:00',0),(118,'SSIPITS','2005-03-11 00:00:00',0),(119,'SSIP-USA','2005-03-11 00:00:00',0),(120,'SSIPWC','2005-03-11 00:00:00',0),(121,'SSIPWS','2005-03-11 00:00:00',0),(122,'ST.LUKES','2005-03-11 00:00:00',0),(123,'SYNEX','2005-03-11 00:00:00',0),(124,'TOGI','2005-03-11 00:00:00',0),(125,'UAP','2005-03-11 00:00:00',0),(126,'UCC24','2005-03-11 00:00:00',0),(127,'UCCEP','2005-03-11 00:00:00',0),(128,'UCCES','2005-03-11 00:00:00',0),(129,'UCCHDESK','2005-03-11 00:00:00',0),(130,'UCCITS','2005-03-11 00:00:00',0),(131,'UCCK','2005-03-11 00:00:00',0),(132,'UCCPDA','2005-03-11 00:00:00',0),(133,'UCCPRCW','2005-03-11 00:00:00',0),(134,'UCCTC','2005-03-11 00:00:00',0),(135,'UCCTS','2005-03-11 00:00:00',0),(136,'UCCWS','2005-03-11 00:00:00',0),(137,'UCCWT','2005-03-11 00:00:00',0),(138,'UNIOIL','2005-03-11 00:00:00',0),(139,'UNION','2005-03-11 00:00:00',0),(140,'VGOLF','2005-03-11 00:00:00',0),(141,'WFP','2005-03-11 00:00:00',0),(142,'ZCMA','2005-03-11 00:00:00',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `common_part` ENABLE KEYS */;

--
-- Table structure for table `group_member`
--

DROP TABLE IF EXISTS `group_member`;
CREATE TABLE `group_member` (
`group_member_id` bigint(20) NOT NULL default '0',
`fk_user_id` bigint(20) default NULL,
`fk_user_group_id` bigint(20) default NULL,
`group_member_index` int(11) default NULL,
PRIMARY KEY (`group_member_id`),
UNIQUE KEY `fk_user_id` (`fk_user_id`),
KEY `FKE926145A615372D5` (`fk_user_group_id`),
KEY `FKE926145AD1A80C95` (`fk_user_id`),
CONSTRAINT `FKE926145A615372D5` FOREIGN KEY (`fk_user_group_id`) REFERENCES `user_group` (`user_group_id`),
CONSTRAINT `FKE926145AD1A80C95` FOREIGN KEY (`fk_user_id`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_member`
--


/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
LOCK TABLES `group_member` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;

--
-- Table structure for table `holiday`
--

DROP TABLE IF EXISTS `holiday`;
CREATE TABLE `holiday` (
`holiday_id` bigint(20) NOT NULL default '0',
`effective_date` date default NULL,
`holiday_type` int(11) default NULL,
`description` varchar(255) default NULL,
`access_type` int(11) default NULL,
`country_code` int(11) default NULL,
PRIMARY KEY (`holiday_id`),
KEY `FK41152858BD234A62` (`holiday_id`),
CONSTRAINT `FK41152858BD234A62` FOREIGN KEY (`holiday_id`) REFERENCES `common_part` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `holiday`
--


/*!40000 ALTER TABLE `holiday` DISABLE KEYS */;
LOCK TABLES `holiday` WRITE;
INSERT INTO `holiday` VALUES (1,'2005-01-01',1,'New Year\'s Day',0,1),(2,'2005-02-21',1,'President\'s Day',1,2),(3,'2005-02-25',1,'EDSA Anniversary',0,1),(4,'2005-03-24',1,'Maundy Thursday',0,1),(5,'2005-03-25',1,'Good Friday',0,1),(6,'2005-03-26',1,'Black Saturday',0,1),(7,'2005-04-09',1,'Araw ng Kagitingan',0,1),(8,'2005-05-01',1,'Labor Day',0,1),(9,'2005-05-30',1,'Memorial Day',1,2),(10,'2005-06-12',1,'Independence Day',0,1),(11,'2005-07-04',1,'Independence Day',1,2),(12,'2005-08-21',1,'Martyrdom of Ninoy',0,1),(13,'2005-08-28',1,'National Heroes Day',0,1),(14,'2005-09-05',1,'Labor Day',1,2),(15,'2005-11-01',1,'All Saint\'s Day',0,1),(16,'2005-11-03',1,'Eid Ul Fitre',0,1),(17,'2005-11-11',1,'Veteran\'s Day',1,2),(18,'2005-11-24',1,'Thanksgiving Day',1,2),(19,'2005-11-30',1,'Bonifacio Day',0,1),(20,'2005-12-26',1,'Christmas Observed',1,2),(21,'2005-12-25',1,'Christmas Day',0,1),(22,'2005-12-30',1,'Rizal Day',0,1),(23,'2005-12-31',1,'Last Day of the Year',0,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `holiday` ENABLE KEYS */;

--
-- Table structure for table `leave_account`
--

DROP TABLE IF EXISTS `leave_account`;
CREATE TABLE `leave_account` (
`leave_account_id` bigint(20) NOT NULL default '0',
`year_effectivity` int(11) default NULL,
`leave_type` int(11) default NULL,
`due_date` date default NULL,
`max_allowed` smallint(6) default NULL,
`consumed` smallint(6) default NULL,
`creator_id` bigint(20) default NULL,
`is_hr_acknowledged` tinyint(1) default NULL,
`fk_employee_id` bigint(20) default NULL,
`leave_account_index` int(11) default NULL,
PRIMARY KEY (`leave_account_id`),
KEY `FK7241D8A5C08A4FD2` (`fk_employee_id`),
CONSTRAINT `FK7241D8A5C08A4FD2` FOREIGN KEY (`fk_employee_id`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leave_account`
--


/*!40000 ALTER TABLE `leave_account` DISABLE KEYS */;
LOCK TABLES `leave_account` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `leave_account` ENABLE KEYS */;

--
-- Table structure for table `leave_request`
--

DROP TABLE IF EXISTS `leave_request`;
CREATE TABLE `leave_request` (
`leave_request_id` bigint(20) NOT NULL default '0',
`start_date` date default NULL,
`end_date` date default NULL,
`actual_num_days` smallint(6) default NULL,
`date_of_halfday` date default NULL,
`reason` varchar(255) default NULL,
`is_approved` tinyint(1) default NULL,
`is_rejected` tinyint(1) default NULL,
`date_approved_rejected` date default NULL,
`status` int(11) default NULL,
`type_of_leave` int(11) default NULL,
`fk_employee_id` bigint(20) default NULL,
`fk_approver_id` bigint(20) default NULL,
`leave_request_index` int(11) default NULL,
PRIMARY KEY (`leave_request_id`),
KEY `FKF9BD4107C08A4FD2` (`fk_employee_id`),
KEY `FKF9BD4107B402445B` (`fk_approver_id`),
KEY `FKF9BD41076EB3BF53` (`leave_request_id`),
CONSTRAINT `FKF9BD41076EB3BF53` FOREIGN KEY (`leave_request_id`) REFERENCES `common_part` (`document_id`),
CONSTRAINT `FKF9BD4107B402445B` FOREIGN KEY (`fk_approver_id`) REFERENCES `war_user` (`war_user_id`),
CONSTRAINT `FKF9BD4107C08A4FD2` FOREIGN KEY (`fk_employee_id`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leave_request`
--


/*!40000 ALTER TABLE `leave_request` DISABLE KEYS */;
LOCK TABLES `leave_request` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `leave_request` ENABLE KEYS */;

--
-- Table structure for table `overtime`
--

DROP TABLE IF EXISTS `overtime`;
CREATE TABLE `overtime` (
`overtime_id` bigint(20) NOT NULL default '0',
`reason` varchar(255) default NULL,
`is_approved` tinyint(1) default NULL,
`date_approved` date default NULL,
`date_filed` date default NULL,
PRIMARY KEY (`overtime_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `overtime`
--


/*!40000 ALTER TABLE `overtime` DISABLE KEYS */;
LOCK TABLES `overtime` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `overtime` ENABLE KEYS */;

--
-- Table structure for table `project_item`
--

DROP TABLE IF EXISTS `project_item`;
CREATE TABLE `project_item` (
`project_item_id` bigint(20) NOT NULL default '0',
`item_name` varchar(255) default NULL,
`description` varchar(255) default NULL,
`fk_project_scheme_id` bigint(20) default NULL,
`project_item_index` int(11) default NULL,
PRIMARY KEY (`project_item_id`),
KEY `FK37FBF079953D4755` (`fk_project_scheme_id`),
CONSTRAINT `FK37FBF079953D4755` FOREIGN KEY (`fk_project_scheme_id`) REFERENCES `project_scheme` (`project_scheme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_item`
--


/*!40000 ALTER TABLE `project_item` DISABLE KEYS */;
LOCK TABLES `project_item` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `project_item` ENABLE KEYS */;

--
-- Table structure for table `project_scheme`
--

DROP TABLE IF EXISTS `project_scheme`;
CREATE TABLE `project_scheme` (
`project_scheme_id` bigint(20) NOT NULL default '0',
`name_code` varchar(255) default NULL,
`description` varchar(255) default NULL,
`start_date` date default NULL,
`end_date` date default NULL,
`is_active` tinyint(1) default NULL,
`fk_client_id` bigint(20) NOT NULL default '0',
`project_scheme_index` int(11) default NULL,
`fk_owner_id` bigint(20) default NULL,
PRIMARY KEY (`project_scheme_id`),
KEY `FK38E3E98BD6585061` (`fk_owner_id`),
KEY `FK38E3E98B82217B15` (`fk_client_id`),
KEY `FK38E3E98B6268184F` (`project_scheme_id`),
CONSTRAINT `FK38E3E98B6268184F` FOREIGN KEY (`project_scheme_id`) REFERENCES `common_part` (`document_id`),
CONSTRAINT `FK38E3E98B82217B15` FOREIGN KEY (`fk_client_id`) REFERENCES `client` (`client_id`),
CONSTRAINT `FK38E3E98BD6585061` FOREIGN KEY (`fk_owner_id`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_scheme`
--


/*!40000 ALTER TABLE `project_scheme` DISABLE KEYS */;
LOCK TABLES `project_scheme` WRITE;
INSERT INTO `project_scheme` VALUES (24,'AG&P-Email','AG&P-Email','2004-01-01','2006-01-01',1,7,0,1),(25,'AG&P-LAN','AG&P - LAN','2004-01-01','2006-01-01',1,7,1,1),(26,'AG&P-OMD','AG&P - OMD','2004-01-01','2006-01-01',1,7,2,1),(27,'AGP','AGP - Atlantic Gulf & Pacific','2004-01-01','2006-01-01',1,7,3,1),(28,'AIM','AIM','2004-01-01','2006-01-01',1,9,0,1),(29,'AIT','AIT','2004-01-01','2006-01-01',1,10,0,1),(30,'AKINMKT','AKING MAKATI','2004-01-01','2006-01-01',1,11,0,1),(31,'ALSONS','ALSONS CEMENT','2004-01-01','2006-01-01',1,4,0,1),(32,'AMA','AMA COMPUTER COLLEGE','2004-01-01','2006-01-01',1,12,0,1),(33,'AYALA','AYALA','2004-01-01','2006-01-01',1,13,0,1),(34,'BETHLHM','BETHLEHEM','2004-01-01','2006-01-01',1,14,0,1),(35,'BNTB','Bank of Butterfield','2004-01-01','2006-01-01',1,15,0,1),(36,'BOEHRINGER','BOEHRINGER INGLEHEIM','2004-01-01','2006-01-01',1,16,0,1),(37,'BPI','BPI','2004-01-01','2006-01-01',1,17,0,1),(38,'BRIGHTPT','BRIGHT POINT','2004-01-01','2006-01-01',1,18,0,1),(39,'CALLCENTER','CALL CENTER','2004-01-01','2006-01-01',1,19,0,1),(40,'CARE','CARE','2004-01-01','2006-01-01',1,19,1,1),(41,'CAROUSEL','CAROUSEL','2004-01-01','2006-01-01',1,20,0,1),(42,'CAROUSELME','Carousel - Miss Earth','2004-01-01','2006-01-01',1,20,1,1),(43,'CAROUSELMP','Carousel - Miss Earth Philippines','2004-01-01','2006-01-01',1,20,2,1),(44,'CENSOL','Centre Solutions','2004-01-01','2006-01-01',1,5,0,1),(45,'CENTURY','CENTURY CANNING CORP.','2004-01-01','2006-01-01',1,21,0,1),(46,'COFFEL','COFFEL','2004-01-01','2006-01-01',1,22,0,1),(47,'COOPER','COOPER INDUSTRIES','2004-01-01','2006-01-01',1,6,0,1),(48,'CYKRIS','CYKRIS','2004-01-01','2006-01-01',1,23,0,1),(49,'CYKRISWS','CYKRIS - Web site','2004-01-01','2006-01-01',1,23,1,1),(50,'DELTACDDBE','DeltaVista CD DB Conversion','2004-01-01','2006-01-01',1,24,0,1),(51,'DeltaEncod','Delta Vista Encoding','2004-01-01','2006-01-01',1,24,1,1),(52,'DFA','DFA','2004-01-01','2006-01-01',1,25,0,1),(53,'DIGA','DIGA GOLF','2004-01-01','2006-01-01',1,26,0,1),(54,'DISCOVERY','DISCOVERY SUITES','2004-01-01','2006-01-01',1,27,0,1),(55,'EARTHSTYLE','EARTH AND STYLE','2004-01-01','2006-01-01',1,28,0,1),(56,'ePLDT','EPLDT','2004-01-01','2006-01-01',1,29,0,1),(57,'ETELECARE','E TELECARE','2004-01-01','2006-01-01',1,30,0,1),(58,'EWAR2','EWAR 2.0','2004-01-01','2006-01-01',1,2,0,1),(59,'Experian','Experian','2004-01-01','2006-01-01',1,31,0,1),(60,'FFCRUZ','F. F. CRUZ','2004-01-01','2006-01-01',1,32,0,1),(61,'FRMBLDRS','FIRM BUILDERS','2004-01-01','2006-01-01',1,33,0,1),(62,'GSIS','GSIS','2004-01-01','2006-01-01',1,34,0,1),(63,'HONDA','HONDA','2004-01-01','2006-01-01',1,35,0,1),(64,'IDM','Identity Management Systems','2004-01-01','2006-01-01',1,2,1,1),(65,'JOLLIBEE','JOLLIBEE','2004-01-01','2006-01-01',1,36,0,1),(66,'KFC','KFC','2004-01-01','2006-01-01',1,37,0,1),(67,'LANDBANK','LANDBANK','2004-01-01','2006-01-01',1,38,0,1),(68,'MAKATI','MAKATI','2004-01-01','2006-01-01',1,11,1,1),(69,'MARAJO','MARAJO','2004-01-01','2006-01-01',1,19,2,1),(70,'MARAJOCARE','MARAJO CARE','2004-01-01','2006-01-01',1,19,3,1),(71,'MIASCOR','MIASCOR','2004-01-01','2006-01-01',1,39,0,1),(72,'MILEXP','MIL EXPORT PHILIPPINES','2004-01-01','2006-01-01',1,40,0,1),(73,'MJS','MJS','2004-01-01','2006-01-01',1,41,0,1),(74,'MMDA','MMDA','2004-01-01','2006-01-01',1,8,0,1),(75,'NATION','NATION','2004-01-01','2006-01-01',1,42,0,1),(76,'NETCITI','NETCITI','2004-01-01','2006-01-01',1,43,0,1),(77,'NMC','NMC','2004-01-01','2006-01-01',1,44,0,1),(78,'NOKIA','NOKIA','2004-01-01','2006-01-01',1,3,0,1),(79,'NOKIACB','Nokia C&B Transparency','2004-01-01','2006-01-01',1,3,1,1),(80,'NOKIACM','Nokia - Career Map-NJC','2004-01-01','2006-01-01',1,3,2,1),(81,'NOKIACR261','Nokia CR 261 (ESS/MSS)','2004-01-01','2006-01-01',1,3,3,1),(82,'NOKIACR629','Nokia eWise CR629','2004-01-01','2006-01-01',1,3,4,1),(83,'NOKIACR630','Nokia eWise CR630','2004-01-01','2006-01-01',1,3,5,1),(84,'NOKIAE','NOKIA - eWise','2004-01-01','2006-01-01',1,3,6,1),(85,'NOKIAEER','Nokia Extended Enterprise Resourcing','2004-01-01','2006-01-01',1,3,7,1),(86,'NOKIAGEMS','NOKIA - GEMS','2004-01-01','2006-01-01',1,3,8,1),(87,'NOKIAIIP','NOKIA-IIP','2004-01-01','2006-01-01',1,3,9,1),(88,'NOKIAIIP6','NOKIA IIP 6.0','2004-01-01','2006-01-01',1,3,10,1),(89,'NOKIAPCR','Nokia PCR','2004-01-01','2006-01-01',1,3,11,1),(90,'None','None','2004-01-01','2006-01-01',1,1,0,1),(91,'PAG-IBIG','PAG-IBIG','2004-01-01','2006-01-01',1,45,0,1),(92,'PCI','PCI','2004-01-01','2006-01-01',1,46,0,1),(93,'PE','PERKIN ELMER','2004-01-01','2006-01-01',1,47,0,1),(94,'PETRON','PETRON','2004-01-01','2006-01-01',1,48,0,1),(95,'PHILIPS','PHILIPS','2004-01-01','2006-01-01',1,49,0,1),(96,'PHINMA','PHINMA','2004-01-01','2006-01-01',1,4,1,1),(97,'PHLPSTA','PHILPESTA','2004-01-01','2006-01-01',1,50,0,1),(98,'PNGOC','PNGOC','2004-01-01','2006-01-01',1,51,0,1),(99,'POEA','POEA','2004-01-01','2006-01-01',1,52,0,1),(100,'PQA','PQA','2004-01-01','2006-01-01',1,53,0,1),(101,'PSQ','PHIL. SOCIETY FOR QUALITY','2004-01-01','2006-01-01',1,54,0,1),(102,'RAPID AIR','RAPID AIR','2004-01-01','2006-01-01',1,55,0,1),(103,'RMGA','RMG - ALABANG','2004-01-01','2006-01-01',1,56,0,1),(104,'RMGC5','RMG - C5','2004-01-01','2006-01-01',1,57,0,1),(105,'RMGFB','RMG - FORT BONIFACIO','2004-01-01','2006-01-01',1,58,0,1),(106,'SAFECENTER','SAFETY CENTER','2004-01-01','2006-01-01',1,59,0,1),(107,'San Jose','SAN JOSE REALTY DEV CORP.','2004-01-01','2006-01-01',1,60,0,1),(108,'SAP','SAP','2004-01-01','2006-01-01',1,61,0,1),(109,'SAP4.7','SAP 4.7 Installation','2004-01-01','2006-01-01',1,61,1,1),(110,'SHAKEYS','SHAKEY\'S','2004-01-01','2006-01-01',1,62,0,1),(111,'SHAKEYSB2B','Shakey\'s - B2B','2004-01-01','2006-01-01',1,62,1,1),(112,'SHELL A','SHELL AUSTRALIA','2004-01-01','2006-01-01',1,63,0,1),(113,'SHELL N','SHELL NAGA','2004-01-01','2006-01-01',1,63,1,1),(114,'SHELL S','SHELL SOCOR','2004-01-01','2006-01-01',1,63,2,1),(115,'SOUTHFIELD','SOUTHFIELD','2004-01-01','2006-01-01',1,64,0,1),(116,'SSIP','SSIP','2004-01-01','2006-01-01',1,2,2,1),(117,'SSIPIDM','SSIP-IDM','2004-01-01','2006-01-01',1,2,3,1),(118,'SSIPITS','SSIP - ITS','2004-01-01','2006-01-01',1,2,4,1),(119,'SSIP-USA','SSIP - USA','2004-01-01','2006-01-01',1,2,5,1),(120,'SSIPWC','SSIP - WebCrawler','2004-01-01','2006-01-01',1,2,6,1),(121,'SSIPWS','SSIP - SSIP.com Website','2004-01-01','2006-01-01',1,2,7,1),(122,'ST.LUKES','ST.LUKES','2004-01-01','2006-01-01',1,65,0,1),(123,'SYNEX','SYNEX','2004-01-01','2006-01-01',1,66,0,1),(124,'TOGI','TOGI','2004-01-01','2006-01-01',1,67,0,1),(125,'UAP','UNIVERSITY OF ASIA AND THE PACIFIC','2004-01-01','2006-01-01',1,68,0,1),(126,'UCC24','UCC - 24 Hour Loading','2004-01-01','2006-01-01',1,4,2,1),(127,'UCCEP','UCC - ePayment','2004-01-01','2006-01-01',1,4,3,1),(128,'UCCES','UCC - eSales','2004-01-01','2006-01-01',1,4,4,1),(129,'UCCHDESK','UCC - Help Desk','2004-01-01','2006-01-01',1,4,5,1),(130,'UCCITS','UCC ITS','2004-01-01','2006-01-01',1,4,6,1),(131,'UCCK','UCC - Kiosk','2004-01-01','2006-01-01',1,4,7,1),(132,'UCCPDA','UCC-PDA','2004-01-01','2006-01-01',1,4,8,1),(133,'UCCPRCW','UCC - PR and Check Warehousing','2004-01-01','2006-01-01',1,4,9,1),(134,'UCCTC','UCC - Test Certificate','2004-01-01','2006-01-01',1,4,10,1),(135,'UCCTS','UCC - Truckscale','2004-01-01','2006-01-01',1,4,11,1),(136,'UCCWS','UCC - webSAP','2004-01-01','2006-01-01',1,4,12,1),(137,'UCCWT','UCC - Web Site','2004-01-01','2006-01-01',1,4,13,1),(138,'UNIOIL','UNIOIL','2004-01-01','2006-01-01',1,69,0,1),(139,'UNION','UNION CEMENT','2004-01-01','2006-01-01',1,4,14,1),(140,'VGOLF','Valley Golf Antipolo','2004-01-01','2006-01-01',1,70,0,1),(141,'WFP','WFP','2004-01-01','2006-01-01',1,71,0,1),(142,'ZCMA','ZURICH CAPITAL MARKETS','2004-01-01','2006-01-01',1,72,0,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `project_scheme` ENABLE KEYS */;

--
-- Table structure for table `ssip_group`
--

DROP TABLE IF EXISTS `ssip_group`;
CREATE TABLE `ssip_group` (
`ssip_group_id` bigint(20) NOT NULL default '0',
`group_name` varchar(255) default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY (`ssip_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ssip_group`
--


/*!40000 ALTER TABLE `ssip_group` DISABLE KEYS */;
LOCK TABLES `ssip_group` WRITE;
INSERT INTO `ssip_group` VALUES (1,'IAG','Internet and Application Group'),(2,'ABAP','SAP and ABAP Group'),(3,'Design','Artistic Design Group');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ssip_group` ENABLE KEYS */;

--
-- Table structure for table `sub_activity_type`
--

DROP TABLE IF EXISTS `sub_activity_type`;
CREATE TABLE `sub_activity_type` (
`sub_activity_type_id` bigint(20) NOT NULL default '0',
`subactivity_name` varchar(255) default NULL,
`code` varchar(255) default NULL,
`FK_ACTIVITY_TYPE_ID` bigint(20) default NULL,
`SUBACTIVITY_INDEX` int(11) default NULL,
PRIMARY KEY (`sub_activity_type_id`),
KEY `FK4D8386ABF0414B4A` (`FK_ACTIVITY_TYPE_ID`),
CONSTRAINT `FK4D8386ABF0414B4A` FOREIGN KEY (`FK_ACTIVITY_TYPE_ID`) REFERENCES `activity_type` (`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_activity_type`
--


/*!40000 ALTER TABLE `sub_activity_type` DISABLE KEYS */;
LOCK TABLES `sub_activity_type` WRITE;
INSERT INTO `sub_activity_type` VALUES (1,'Analysis/Design','A1',2,0),(2,'Development','D1',2,1),(3,'Deployment/Delivery Note','D2',2,2),(4,'Rework','D3',2,3),(5,'Environment Setup/Support','D4',2,4),(6,'General Documentation','G1',2,5),(7,'Project Management Tasks','M1',2,6),(8,'Team/Client Meetings and Correspondence','M2',2,7),(9,'Project Related Training/Research','M3',2,8),(10,'Miscellaneous(Travel Arrangements)','M4',2,9),(11,'Dev/Unit Testing','Q1',2,10),(12,'QA/System Level Testing','Q2',2,11),(13,'Regression Testing','Q3',2,12),(14,'Other QA-related tasks','Q4',2,13),(15,'Birthday Leave','BL',9,0),(16,'Emergency Leave','EL',9,1),(17,'Time-off','TL',9,2),(18,'Leave without pay','LWOP',9,3),(19,'Marriage Leave','ML',9,4),(20,'Marriage and Paternity Leave','MPL',9,5),(21,'Sick Leave','SL',9,6),(22,'Vacation Leave','VL',9,7);
UNLOCK TABLES;
/*!40000 ALTER TABLE `sub_activity_type` ENABLE KEYS */;

--
-- Table structure for table `user_access`
--

DROP TABLE IF EXISTS `user_access`;
CREATE TABLE `user_access` (
`user_access_id` bigint(20) NOT NULL default '0',
`role` smallint(6) default NULL,
`fk_user_id` bigint(20) default NULL,
`fk_document_id` bigint(20) default NULL,
`user_access_index` int(11) default NULL,
PRIMARY KEY (`user_access_id`),
UNIQUE KEY `fk_user_id` (`fk_user_id`),
KEY `FKD760FC58A841B245` (`fk_document_id`),
KEY `FKD760FC58D1A80C95` (`fk_user_id`),
CONSTRAINT `FKD760FC58A841B245` FOREIGN KEY (`fk_document_id`) REFERENCES `common_part` (`document_id`),
CONSTRAINT `FKD760FC58D1A80C95` FOREIGN KEY (`fk_user_id`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_access`
--


/*!40000 ALTER TABLE `user_access` DISABLE KEYS */;
LOCK TABLES `user_access` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `user_access` ENABLE KEYS */;

--
-- Table structure for table `user_activity`
--

DROP TABLE IF EXISTS `user_activity`;
CREATE TABLE `user_activity` (
`user_activity_id` bigint(20) NOT NULL default '0',
`is_approved` tinyint(1) default NULL,
`approved_date` date default NULL,
`is_accepted` tinyint(1) default NULL,
`accepted_date` date default NULL,
`last_modified` datetime default NULL,
`is_finalized` tinyint(1) default NULL,
`final_date` date default NULL,
`is_frozen` tinyint(1) default NULL,
`FK_USER_ID` bigint(20) NOT NULL default '0',
`USER_ACTIVITY_INDEX` int(11) default NULL,
`fk_activity_period_id` bigint(20) default NULL,
PRIMARY KEY (`user_activity_id`),
KEY `FKA04F4D037B75F0E3` (`fk_activity_period_id`),
KEY `FKA04F4D03EAB80C95` (`FK_USER_ID`),
CONSTRAINT `FKA04F4D037B75F0E3` FOREIGN KEY (`fk_activity_period_id`) REFERENCES `activity_period` (`activity_period_id`),
CONSTRAINT `FKA04F4D03EAB80C95` FOREIGN KEY (`FK_USER_ID`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_activity`
--


/*!40000 ALTER TABLE `user_activity` DISABLE KEYS */;
LOCK TABLES `user_activity` WRITE;
INSERT INTO `user_activity` VALUES (1,0,NULL,1,'2005-04-05','2005-04-05 18:03:26',0,NULL,0,9,0,6),(2,0,NULL,0,NULL,'2005-03-17 14:45:46',0,NULL,0,2,0,6),(3,0,NULL,0,NULL,'2005-03-28 16:35:43',0,NULL,0,4,0,6),(4,0,NULL,0,NULL,'2005-04-04 09:53:55',0,NULL,0,9,1,5),(5,0,NULL,0,NULL,'2005-04-04 10:44:48',0,NULL,0,8,0,6);
UNLOCK TABLES;
/*!40000 ALTER TABLE `user_activity` ENABLE KEYS */;

--
-- Table structure for table `user_group`
--

DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
`user_group_id` bigint(20) NOT NULL default '0',
`group_name` varchar(255) default NULL,
`FK_OWNER_ID` bigint(20) default NULL,
`USER_GROUP_INDEX` int(11) default NULL,
PRIMARY KEY (`user_group_id`),
KEY `FK72A9010BDF3A3C81` (`FK_OWNER_ID`),
CONSTRAINT `FK72A9010BDF3A3C81` FOREIGN KEY (`FK_OWNER_ID`) REFERENCES `war_user` (`war_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group`
--


/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
LOCK TABLES `user_group` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;

--
-- Table structure for table `user_group_access`
--

DROP TABLE IF EXISTS `user_group_access`;
CREATE TABLE `user_group_access` (
`usergroup_access_id` bigint(20) NOT NULL default '0',
`fk_user_group_id` bigint(20) default NULL,
`fk_document_id` bigint(20) default NULL,
`usergroup_access_index` int(11) default NULL,
PRIMARY KEY (`usergroup_access_id`),
KEY `FK91A87F18A841B245` (`fk_document_id`),
KEY `FK91A87F18615372D5` (`fk_user_group_id`),
CONSTRAINT `FK91A87F18615372D5` FOREIGN KEY (`fk_user_group_id`) REFERENCES `user_group` (`user_group_id`),
CONSTRAINT `FK91A87F18A841B245` FOREIGN KEY (`fk_document_id`) REFERENCES `common_part` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_access`
--


/*!40000 ALTER TABLE `user_group_access` DISABLE KEYS */;
LOCK TABLES `user_group_access` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `user_group_access` ENABLE KEYS */;

--
-- Table structure for table `war_user`
--

DROP TABLE IF EXISTS `war_user`;
CREATE TABLE `war_user` (
`war_user_id` bigint(20) NOT NULL default '0',
`employee_id` varchar(255) default NULL,
`last_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`middle_initial` char(1) default NULL,
`known_as` varchar(255) default NULL,
`hire_date` date default NULL,
`job_grade` int(11) default NULL,
`birth_date` date default NULL,
`fk_account_id` bigint(20) default NULL,
`fk_manager_id` bigint(20) default NULL,
PRIMARY KEY (`war_user_id`),
UNIQUE KEY `employee_id` (`employee_id`),
UNIQUE KEY `fk_account_id` (`fk_account_id`),
KEY `FK1CE26AC2150BB2A7` (`fk_manager_id`),
KEY `FK1CE26AC250712827` (`fk_account_id`),
CONSTRAINT `FK1CE26AC2150BB2A7` FOREIGN KEY (`fk_manager_id`) REFERENCES `war_user` (`war_user_id`),
CONSTRAINT `FK1CE26AC250712827` FOREIGN KEY (`fk_account_id`) REFERENCES `account` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `war_user`
--


/*!40000 ALTER TABLE `war_user` DISABLE KEYS */;
LOCK TABLES `war_user` WRITE;
INSERT INTO `war_user` VALUES (1,'P00001','Godinez','Jaime','Y','Jaime','2000-05-08',4,'1976-11-27',1,NULL),(2,'P00048','Punzalan','Rommel','R','Punzi','2000-11-08',4,'1979-05-16',2,1),(3,'P00049','Dy','Ky','S','Kv','2000-12-06',4,'1980-02-15',3,1),(4,'P00056','Binuya','Roldan','C','Roldz','2001-03-12',4,'1977-11-13',4,1),(5,'P03099','Yanga','Francis','P','Fray',NULL,4,'1980-02-07',5,2),(6,'P03104','Kyamko','Kirt Arthur','S','Kirt','2003-05-23',4,'1975-09-05',6,8),(7,'P03097','De Guzman','Lisa','D','Lisa','2003-05-12',4,'1980-11-24',7,NULL),(8,'P03105','Villanueva','Julliefer','S','Pheng','2003-05-26',4,'1978-07-08',8,1),(9,'P04121','Lumabi','Roselyn','S','Roselyn','2004-05-11',4,'1981-03-31',9,2),(10,'P00064','Bondoc','Leo','S','Leo','2001-08-22',4,'1974-09-29',10,3),(11,'P03115','Aquino','Marc','A','Marc','2003-11-10',4,'1980-03-12',11,NULL),(12,'P03116','Barcelon','Ricardo','G','JR','2003-11-13',4,'1980-12-27',12,8),(13,'P04127','Del Rosario','Maynard','R','Maynard','2004-06-14',4,'1984-05-20',13,2),(14,'P04125','Hernandez','Sherry Ann','S','She-Ann','2004-05-31',4,'1981-01-03',14,2),(15,'P04123','Uy','Shirleen','A','Shirleen','2004-05-24',4,'1982-06-28',15,3),(16,'P04131','Orea','Ricky','D','Ricky','2004-09-20',4,'1968-09-07',16,NULL),(17,'P05439','Ruiz','Modesto Carlo','M','Marlowe','2005-03-01',4,NULL,17,NULL),(18,'P97002','Chua','Rose','A','Rose','1997-12-15',4,'1959-06-26',18,NULL),(19,'P03108','Buterbaugh','Geil','A','Geil','2003-07-02',4,'1980-03-02',19,NULL),(20,'P04118','Suero','Angel','B','Angel','2004-03-22',4,'1978-07-14',20,NULL),(21,'P04133','Anonuevo','Cielo','F','Cielo','2004-10-25',4,'1979-03-06',21,NULL),(22,'P04134','Micua','Arlyn','D','Arlene','2004-12-14',4,'1982-05-27',22,NULL),(23,'P05440','Peciller','Alvin','T','Alvin','2005-03-07',4,'1975-04-06',23,NULL),(24,'P03113','Hao','Abraham Lincoln','M','Ham','2003-09-04',4,'1978-02-03',24,NULL),(25,'P05441','Pilapil','Maria Lourdes','F','Veejay','2005-03-07',4,'1980-03-05',25,NULL),(26,'P03117','Halili','Reginald','V','Reggie','2003-12-01',4,'1968-03-31',26,NULL),(27,'terminated','Schwarzenegger','Arnold','I','Terminator','2000-04-11',4,'1972-02-14',27,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `war_user` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;