// *********
// Generated by Microsoft Access visual basic module: jsdatabase-constructor V2.2
// jsdatabase-constructor module available as freeware at: http://www.javascriptdatabase.com
//
// latest version of AccessObject-JavascriptDatabase http://www.javascriptdatabase.com
// *********
timmerStart = new Date()
var DB = new Database('DB')
DB.CreateRecordset('tCOUNTRIES')
DB.CreateRecordset('tPERSONS')
DB.CreateRecordset('tRANKS')
DB.CreateRecordset('tSERVICES')
DB.CreateRecordset('tSTATES')
DB.CreateRecordset('tSTATUSES')
DB.CreateRecordset('tVEHICLES')
DB.tCOUNTRIES.CreateField('COUNTRY_ID',dbPrimaryKey)
DB.tCOUNTRIES.CreateField('COUNTRY_NAME')
DB.tCOUNTRIES.CreateField('COUNTRY_CODE')
DB.tPERSONS.CreateField('PERSON_ID')
DB.tPERSONS.CreateField('LASTNAME')
DB.tPERSONS.CreateField('FIRSTNAME')
DB.tPERSONS.CreateField('DATE_INCIDENT')
DB.tPERSONS.CreateField('DATE_RELEASE')
DB.tPERSONS.CreateField('DATE_REMAINS')
DB.tPERSONS.CreateField('CITY')
DB.tPERSONS.CreateField('FK_SERVICE_ID')
DB.tPERSONS.CreateField('FK_RANK_ID')
DB.tPERSONS.CreateField('FK_STATUS_ID')
DB.tPERSONS.CreateField('FK_STATE_ID')
DB.tPERSONS.CreateField('FK_COUNTRY_ID')
DB.tPERSONS.CreateField('FK_VEHICLE_ID')
DB.tRANKS.CreateField('RANK_ID',dbPrimaryKey)
DB.tRANKS.CreateField('RANK_NAME')
DB.tSERVICES.CreateField('SERVICE_ID',dbPrimaryKey)
DB.tSERVICES.CreateField('SERVICE_NAME')
DB.tSTATES.CreateField('STATE_ID',dbPrimaryKey)
DB.tSTATES.CreateField('STATE_NAME')
DB.tSTATUSES.CreateField('STATUS_ID',dbPrimaryKey)
DB.tSTATUSES.CreateField('STATUS_NAME')
DB.tVEHICLES.CreateField('VEHICLE_ID',dbPrimaryKey)
DB.tVEHICLES.CreateField('VEHICLE_NAME')
with (DB.tCOUNTRIES) {
A([1,"Cambodia","CB"])
A([2,"China","CH"])
A([3,"Laos","LA"])
A([4,"Vietnam North","VN"])
A([5,"Vietnam South","VS"])
}
with (DB.tPERSONS) {
A([2,"ABBOTT","JOHN","4/20/1966","3/13/1974","4/17/1974","",6,15,6,1,4,10])
A([3,"ABBOTT","JOSEPH","4/30/1967","2/18/1973","","",3,13,10,1,4,85])
A([4,"ABBOTT","ROBERT","4/30/1967","3/4/1973","","",3,12,10,1,4,85])
|