// Catalog Database
// Begin Generated Code
DB1.CreateRecordset('CATENTDESC')
with (DB1.CATENTDESC){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('NAME',7,128,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('LONGDESCRIPTION',8,0,0,0,0)
CreateField('DETAILS',8,0,0,0,0)
CreateField('CONTENTS',8,0,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
CreateField('FULLIMAGE1',30,254,0,0,0)
CreateField('FULLIMAGE2',30,254,0,0,0)
CreateField('FULLIMAGE3',30,254,0,0,0)
CreateField('FULLIMAGE4',30,254,0,0,0)
CreateField('FULLIMAGE5',30,254,0,0,0)
CreateField('FULLIMAGE6',30,254,0,0,0)
CreateField('FULLIMAGE7',30,254,0,0,0)
CreateField('FULLIMAGE8',30,254,0,0,0)
CreateField('FULLIMAGE9',30,254,0,0,0)
CreateField('FULLIMAGE10',30,254,0,0,0)
CreateField('LARGEFULLIMAGE',30,254,0,0,0)
CreateField('XMLDETAIL',8,0,0,0,0)
CreateField('AVAILABLE',15,0,1,0,0)
CreateField('PUBLISHED',15,0,1,0,0)
CreateField('AVAILABILITYDATE',27,0,0,0,0)
CreateField('KEYWORD',30,254,0,0,0)
CreateField('FULLIMAGECOUNT',15,0,1,0,0)
CreateField('FORMAT',15,0,1,0,0)
}
DB1.CreateRecordset('CATENTRY')
with (DB1.CATENTRY){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75X50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}
DB1.CreateRecordset('MODELDESC')
with (DB1.MODELDESC){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('NAME',7,128,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('LONGDESCRIPTION',8,0,0,0,0)
CreateField('DETAILS',8,0,0,0,0)
CreateField('CONTENTS',8,0,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
CreateField('FULLIMAGE1',30,254,0,0,0)
CreateField('FULLIMAGE2',30,254,0,0,0)
CreateField('FULLIMAGE3',30,254,0,0,0)
CreateField('FULLIMAGE4',30,254,0,0,0)
CreateField('FULLIMAGE5',30,254,0,0,0)
CreateField('FULLIMAGE6',30,254,0,0,0)
CreateField('FULLIMAGE7',30,254,0,0,0)
CreateField('FULLIMAGE8',30,254,0,0,0)
CreateField('FULLIMAGE9',30,254,0,0,0)
CreateField('FULLIMAGE10',30,254,0,0,0)
CreateField('LARGEFULLIMAGE',30,254,0,0,0)
CreateField('XMLDETAIL',8,0,0,0,0)
CreateField('AVAILABLE',15,0,1,0,0)
CreateField('PUBLISHED',15,0,1,0,0)
CreateField('AVAILABILITYDATE',27,0,0,0,0)
CreateField('KEYWORD',30,254,0,0,0)
CreateField('FULLIMAGECOUNT',15,0,1,0,0)
CreateField('FORMAT',15,0,1,0,0)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ADDRBOOK_ID',2,0,1,0,0)
CreateField('LASTNAME',30,128,0,0,0)
}
DB1.CreateRecordset('MODEL')
with (DB1.MODEL){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75X50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
CreateField('GENDER',2,0,1,0,0,1)
CreateField('MODELLEVEL_ID',7,1,0,0,0)
CreateField('MODELTYPE_IDS',7,1,0,0,0)
CreateField('ADDRESS_ID',2,0,1,0,0,1)
CreateField('STATUS',7,1,0,0,0)
CreateField('ORGNAME',30,128,0,0,0)
CreateField('ISPRIMARY',15,0,0,0,0)
CreateField('FIRSTNAME',30,128,0,0,0)
CreateField('CITY',30,128,0,0,0)
CreateField('CSTATE',30,128,0,0,0)
CreateField('COUNTRY',30,128,0,0,0)
CreateField('ZIPCODE',30,40,0,0,0)
CreateField('DOB',7,1,0,0,0)
CreateField('UNIT',7,1,0,0,0)
CreateField('HEIGHT',7,1,0,0,0)
CreateField('WEIGHT',7,1,0,0,0)
CreateField('CHEST1',7,1,0,0,0)
CreateField('CHEST2',7,1,0,0,0)
CreateField('HIPS',7,1,0,0,0)
CreateField('WAIST',7,1,0,0,0)
CreateField('EYES',7,1,0,0,0)
CreateField('HAIR',7,1,0,0,0)
CreateField('HAIRLEN',7,1,0,0,0)
CreateField('SKINCOL',7,1,0,0,0)
CreateField('ANCESTRY_ID',7,1,0,0,0)
CreateField('NUDITY_ID',7,1,0,0,0)
}
DB1.CreateRecordset('MODELLEVEL')
with (DB1.MODELLEVEL){
CreateField('MODELLEVEL_ID',15,0,1,0,0,1)
CreateField('NAME',7,50,1,0,0)
}
DB1.CreateRecordset('MODELATTR')
with (DB1.MODELATTR){
CreateField('MODELATTR_ID',15,0,1,0,0,1)
CreateField('NAME',7,50,1,0,0)
}
DB1.CreateRecordset('MODELSTATUS')
with (DB1.MODELSTATUS){
CreateField('MODELSTATUS_ID',15,0,1,0,0,1)
CreateField('NAME',7,50,1,0,0)
}
DB1.CreateRecordset('CALENTRY')
with (DB1.CALENTRY){
CreateField('CALENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CALENTTYPE_ID',7,16,1,0,0)
CreateField('CALENTTYPE_IDS',30,64,0,0,0)
CreateField('CALGROUP_ID',7,16,1,0,0)
CreateField('CALENTTYPE_NAME',30,100,1,0,0)
CreateField('CALGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('LOCATION',30,254,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('STARTMONTH',27,0,0,0,0)
CreateField('ENDMONTH',27,0,0,0,0)
CreateField('STARTYEAR',27,0,0,0,0)
CreateField('ENDYEAR',27,0,0,0,0)
CreateField('STARTDAY',27,0,0,0,0)
CreateField('ENDDAY',27,0,0,0,0)
CreateField('STARTTIME',27,0,0,0,0)
CreateField('ENDTIME',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('INSTRUCTIONS',15,0,0,0,0)
CreateField('MAP',15,0,0,0,0)
CreateField('DATA',15,0,0,0,0)
}

DB1.CreateRecordset('ATTRIBUTE')
with (DB1.ATTRIBUTE){
CreateField('ATTRIBUTE_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('ATTRTYPE_ID',7,16,1,0,0)
CreateField('NAME',30,254,0,0,0)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('CATENTRY_ID',2,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('USAGE',7,1,0,1,'1')
CreateField('QTYUNIT_ID',7,16,0,0,0)
CreateField('GROUPNAME',30,64,0,0,0)
}
DB1.CreateRecordset('ATTRTYPE')
with (DB1.ATTRTYPE){
CreateField('ATTRTYPE_ID',7,16,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('ATTRVALUE')
with (DB1.ATTRVALUE){
CreateField('ATTRVALUE_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('ATTRIBUTE_ID',2,0,1,0,0)
CreateField('ATTRTYPE_ID',7,16,1,0,0)
CreateField('STRINGVALUE',7,254,0,0,0)
CreateField('STRINGVALUE2',7,254,0,0,0)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('INTVALUE',15,0,0,0,0)
CreateField('INTVALUE2',15,0,0,0,0)
CreateField('FLOATVALUE',13,0,0,0,0)
CreateField('CATENTRY_ID',2,0,1,0,0)
CreateField('NAME',30,254,0,0,0)
CreateField('IMAGE1',30,254,0,0,0)
CreateField('IMAGE1',30,254,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('QTYUNIT_ID',7,16,0,0,0)
}
DB1.CreateRecordset('CATENTATTRVAL')
with (DB1.CATENTATTRVAL){
CreateField('ATTRVALUE_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('ATTRIBUTE_ID',2,0,1,0,0,1)
CreateField('CATENTRY_ID',2,0,1,0,0,1)
}
DB1.CreateRecordset('PKGATTR')
with (DB1.PKGATTR){
CreateField('PKGATTR_ID',2,0,1,0,0,1)
CreateField('ATTRIBUTE_ID',2,0,1,0,0)
CreateField('LANGUAGE_ID',2,0,1,0,0,1)
CreateField('CATENTRY_ID',2,0,0,0,0)
CreateField('OID',7,32,0,0,0)
}
DB1.CreateRecordset('PKGATTRVAL')
with (DB1.PKGATTRVAL){
CreateField('PKGATTRVAL_ID',2,0,1,0,0,1)
CreateField('ATTRVALUE_ID',2,0,1,0,0)
CreateField('LANGUAGE_ID',15,0,1,0,0)
CreateField('CATENTRY_ID',2,0,1,0,0)
CreateField('OID',7,32,0,0,0)
}
DB1.CreateRecordset('CATENTRY_MENU')
with (DB1.CATENTRY_MENU){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
}
DB1.CreateRecordset('CATENTRY_COM')
with (DB1.CATENTRY_COM){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75X50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}
DB1.CreateRecordset('CATENTRY_MAIN')
with (DB1.CATENTRY_MAIN){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}
DB1.CreateRecordset('CATENTRY_SPOT')
with (DB1.CATENTRY_SPOT){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}

DB1.CreateRecordset('CATENTRY_TOP')
with (DB1.CATENTRY_TOP){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}

DB1.CreateRecordset('CATENTRY_POPULAR')
with (DB1.CATENTRY_POPULAR){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}
DB1.CreateRecordset('CATENTRY_AD1')
with (DB1.CATENTRY_AD1){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}
DB1.CreateRecordset('CATENTRY_AD2')
with (DB1.CATENTRY_AD2){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('CATENTTYPE_NAME',30,100,1,0,0)
CreateField('CATGROUP_NAME',30,100,1,0,0)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('MFPARTNUMBER',30,64,0,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('URL',30,254,0,0,0)
CreateField('PHOTOPRODUCTS',30,254,0,0,0)
CreateField('PHOTOSEARCH',30,254,0,0,0)
CreateField('PHOTOTOP20',30,254,0,0,0)
CreateField('PHOTOPRODUCT',30,254,0,0,0)
CreateField('PHOTORELATED',30,254,0,0,0)
CreateField('PHOTOMAIN',30,254,0,0,0)
CreateField('PHOTOMAINSPOT',30,254,0,0,0)
CreateField('PHOTOMAINPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHSPOT',30,254,0,0,0)
CreateField('PHOTOSEARCHPOP',30,254,0,0,0)
CreateField('PHOTOSEARCHTOP',30,254,0,0,0)
CreateField('PHOTO500X300',30,254,0,0,0)
CreateField('PHOTO75x50',30,254,0,0,0)
CreateField('PHOTO190X126',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('ONSPECIAL',15,0,0,0,0)
CreateField('FIELD4',30,254,0,0,0)
CreateField('FIELD5',30,254,0,0,0)
CreateField('FIELD6',11,0,0,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('BUYABLE',15,0,0,0,0)
CreateField('OID',30,64,0,0,0)
CreateField('BASEITEM_ID',2,0,0,0,0)
CreateField('STATE',7,1,0,1,'1')
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('RANK',13,0,0,0,0)
CreateField('CURRENCY',7,3,1,1,'USD')
CreateField('LISTPRICE',11,0,1,1,0.00)
CreateField('SALEPRICE',11,0,1,1,0.00)
CreateField('OFFER_ID',2,0,1,0,0)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('FORMAT',15,0,0,0,0)
CreateField('SYMBOL_IDS',30,64,0,0,0)
CreateField('DATA',15,0,0,0,0)
}

DB1.CreateRecordset('CATGRPDESC')
with (DB1.CATGRPDESC){
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('CATGROUP_ID',2,0,1,0,0,1)
CreateField('CATGROUPTYPE_ID',2,0,1,0,0,1)
CreateField('NAME',30,254,1,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('LONGDESCRIPTION',30,4000,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
CreateField('PUBLISHED',15,0,1,0,0)
CreateField('DISPLAY',30,254,0,0,0)
CreateField('KEYWORD',30,254,0,0,0)
}

DB1.CreateRecordset('CATGRPREL')
with (DB1.CATGRPREL){
CreateField('CATGROUP_ID_PARENT',2,0,1,0,0,1)
CreateField('CATGROUP_ID_CHILD',2,0,1,0,0,1)
CreateField('CATALOG_ID',2,0,1,0,0,1)
CreateField('RULE',30,254,0,0,0)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('CATALOG_ID_LINK',2,0,0,0,0)
}

DB1.CreateRecordset('MODGRPDESC')
with (DB1.MODGRPDESC){
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('CATGROUP_ID',2,0,1,0,0,1)
CreateField('CATGROUPTYPE_ID',2,0,1,0,0,1)
CreateField('NAME',30,254,1,0,0)
CreateField('SHORTDESCRIPTION',30,254,0,0,0)
CreateField('LONGDESCRIPTION',30,4000,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
CreateField('PUBLISHED',15,0,1,0,0)
CreateField('DISPLAY',30,254,0,0,0)
CreateField('KEYWORD',30,254,0,0,0)
}

DB1.CreateRecordset('MODGRPRATE')
with (DB1.MODGRPRATE){
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('MODELLEVEL_ID',2,0,1,0,0,1)
CreateField('RATE',11,0,1,1,0.00)
}

DB1.CreateRecordset('MODGRPREL')
with (DB1.MODGRPREL){
CreateField('CATGROUP_ID_PARENT',2,0,1,0,0,1)
CreateField('CATGROUP_ID_CHILD',2,0,1,0,0,1)
CreateField('CATALOG_ID',2,0,1,0,0,1)
CreateField('RULE',30,254,0,0,0)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('CATALOG_ID_LINK',2,0,0,0,0)
}


DB1.CreateRecordset('LISTPRICE')
with (DB1.LISTPRICE){
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('CURRENCY',7,3,1,0,0)
CreateField('LISTPRICE',11,0,1,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('CATENTTYPE')
with (DB1.CATENTTYPE){
CreateField('CATENTTYPE_ID',7,16,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('SYMBOL')
with (DB1.SYMBOL){
CreateField('SYMBOL_ID',7,16,1,0,0,1)
CreateField('NAME',30,254,0,0,0)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('IMAGE',30,254,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('CATENTREL')
with (DB1.CATENTREL){
CreateField('CATENTRY_ID_PARENT',2,0,1,0,0,1)
CreateField('CATRELTYPE_ID',7,32,1,0,0,1)
CreateField('CATENTRY_ID_CHILD',2,0,1,0,0,1)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('QUANTITY',13,0,0,0,0)
CreateField('GROUPNAME',30,254,0,0,0)
CreateField('FIELD1',30,254,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('FIELD3',11,0,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('CATRELTYPE')
with (DB1.CATRELTYPE){
CreateField('CATRELTYPE_ID',7,32,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',11,0,0,0,0)
CreateField('FIELD3',30,254,0,0,0)
}
DB1.CreateRecordset('ADDRESS')
with (DB1.ADDRESS){
CreateField('ADDRESS_ID',2,0,1,0,0,1)
CreateField('ADDRESSTYPE',7,5,0,0,0)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ADDRBOOK_ID',2,0,1,0,0)
CreateField('STATUS',7,1,0,0,0)
CreateField('ORGNAME',30,128,0,0,0)
CreateField('ISPRIMARY',15,0,0,0,0)
CreateField('LASTNAME',30,128,0,0,0)
CreateField('FIRSTNAME',30,128,0,0,0)
CreateField('MIDDLENAME',30,128,0,0,0)
CreateField('BUSINESSTITLE',30,128,0,0,0)
CreateField('PHONE1',30,32,0,0,0)
CreateField('FAX1',30,32,0,0,0)
CreateField('PHONE2',30,32,0,0,0)
CreateField('ADDRESS1',30,50,0,0,0)
CreateField('ADDRESS2',30,50,0,0,0)
CreateField('ADDRESS3',30,50,0,0,0)
CreateField('CITY',30,128,0,0,0)
CreateField('STATE',30,128,0,0,0)
CreateField('COUNTRY',30,128,0,0,0)
CreateField('ZIPCODE',30,40,0,0,0)
CreateField('EMAIL1',30,256,0,0,0)
CreateField('EMAIL2',30,256,0,0,0)
CreateField('PHONE1TYPE',7,3,0,0,0)
CreateField('PHONE2TYPE',7,3,0,0,0)
CreateField('BESTCALLINGTIME',7,1,0,0,0)
CreateField('PACKAGESUPPRESSION',15,0,0,0,0)
CreateField('OFFICEADDRESS',30,128,0,0,0)
CreateField('SELFADDRESS',15,0,1,1,0)
CreateField('TAXGEOCODE',30,254,0,0,0)
CreateField('SHIPPINGGEOCODE',30,254,0,0,0)
}

DB1.CreateRecordset('MANUFACTURER')
with (DB1.MANUFACTURER){
CreateField('MF_ID',15,0,1,0,0,1)
CreateField('MFNAME',7,60,0,0,0)
CreateField('URL',7,254,0,0,0)
CreateField('FULLIMAGE',7,254,0,0,0)
CreateField('THUMBNAIL',7,254,0,0,0)
CreateField('LOGO',7,254,0,0,0)
}

DB1.CreateRecordset('BANNER')
with (DB1.BANNER){
CreateField('BANNER_ID',2,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('STARTDAY',15,0,0,0,0)
CreateField('ENDDAY',15,0,0,0,0)
CreateField('STARTTIME',15,0,0,0,0)
CreateField('ENDTIME',15,0,0,0,0)
CreateField('PRECEDENCE',13,0,1,1,0)
CreateField('THUMBNAIL',30,128,0,0,0)
CreateField('FULLIMAGE',30,128,0,0,0)
CreateField('PATH',30,64,0,0,0)
CreateField('LINK',30,128,0,0,0)
CreateField('DESCRIPTION',30,256,0,0,0)
CreateField('TRACKING',15,0,1,1,0)
CreateField('OID',30,64,0,0,0)
}

DB1.CreateRecordset('SLIDESHOW')
with (DB1.SLIDESHOW){
CreateField('SLIDESHOW_ID',2,0,1,0,0,1)
CreateField('CONTEXT',30,256,0,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTTYPE_ID',7,16,1,0,0)
CreateField('CATENTTYPE_IDS',30,64,0,0,0)
CreateField('CATGROUP_ID',7,16,1,0,0)
CreateField('STARTDATE',27,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('STARTDAY',15,0,0,0,0)
CreateField('ENDDAY',15,0,0,0,0)
CreateField('STARTTIME',15,0,0,0,0)
CreateField('ENDTIME',15,0,0,0,0)
CreateField('PRECEDENCE',13,0,1,1,0)
CreateField('THUMBNAIL',30,128,0,0,0)
CreateField('FULLIMAGE',30,128,0,0,0)
CreateField('PATH',30,64,0,0,0)
CreateField('LINK',30,128,0,0,0)
CreateField('SPEED',13,0,1,1,0)
CreateField('DESCRIPTION',30,256,0,0,0)
CreateField('TRACKING',15,0,1,1,0)
CreateField('OID',30,64,0,0,0)
}

DB1.CreateRecordset('CATGROUPS')
with (DB1.CATGROUPS){
CreateField('CATGROUP_ID',2,0,1,0,0,1)
CreateField('CONTEXT',30,256,0,0,0,1)
CreateField('FULLIMAGE',30,128,0,0,0)
CreateField('PATH',30,64,0,0,0)
CreateField('MAP',30,128,0,0,0)
}
DB1.CreateRecordset('MODELGROUPS')
with (DB1.MODELGROUPS){
CreateField('CATGROUP_ID',2,0,1,0,0,1)
CreateField('CONTEXT',30,256,0,0,0,1)
CreateField('FULLIMAGE',30,128,0,0,0)
CreateField('PATH',30,64,0,0,0)
CreateField('MAP',30,128,0,0,0)
}

DB1.CreateRecordset('ORDERITEMS')
with (DB1.ORDERITEMS){
CreateField('ORDERITEMS_ID',2,0,1,0,0,1)
CreateField('STOREENT_ID',15,0,1,0,0)
CreateField('ORDERS_ID',2,0,1,0,0)
CreateField('TERMCOND_ID',2,0,0,0,0)
CreateField('TRADING_ID',2,0,0,0,0)
CreateField('ITEMSPC_ID',2,0,0,0,0)
CreateField('CATENTRY_ID',2,0,0,0,0)
CreateField('SIZE',30,0,1,0,0,1)
CreateField('COLOR',30,0,1,0,0,1)
CreateField('PARTNUM',30,64,0,0,0)
CreateField('SHIPMODE_ID',15,0,0,0,0)
CreateField('FFMCENTER_ID',15,0,0,0,0)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('ADDRESS_ID',2,0,0,0,0)
CreateField('PRICE',11,0,0,0,0)
CreateField('LINEITEMTYPE',7,4,0,0,0)
CreateField('STATUS',7,1,1,0,0)
CreateField('INVENTORYSTATUS',7,4,1,1,'NALC')
CreateField('LASTCREATE',27,0,0,0,0)
CreateField('LASTUPDATE',27,0,0,0,0)
CreateField('LASTALLOCUPDATE',27,0,0,0,0)
CreateField('OFFER_ID',2,0,0,0,0)
CreateField('TIMERELEASED',27,0,0,0,0)
CreateField('TIMESHIPPED',27,0,0,0,0)
CreateField('CURRENCY',7,3,0,1,'USD')
CreateField('COMMENTS',30,254,0,0,0)
CreateField('TOTALPRODUCT',11,0,0,1,0.00)
CreateField('QUANTITY',13,0,1,0,0)
CreateField('TAXAMOUNT',11,0,0,0,0)
CreateField('TOTALADJUSTMENT',11,0,0,1,0)
CreateField('SHIPTAXAMOUNT',11,0,0,0,0)
CreateField('ESTAVAILTIME',27,0,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('FIELD2',30,254,0,0,0)
CreateField('SHIPCHARGE',11,0,0,0,0)
CreateField('TRACKNUMBER',30,64,0,0,0)
CreateField('PREPAREFLAGS',15,0,1,1,0)
CreateField('CORRELATIONGROUP',2,0,0,0,0)
CreateField('PROMISEDAVAILTIME',27,0,0,0,0)
CreateField('SHIPPINGOFFSET',15,0,1,1,0)
CreateField('CONFIGURATIONID',30,128,0,0,0)
CreateField('SUPPLIERDATA',30,254,0,0,0)
CreateField('SUPPLIERPARTNUMBER',30,254,0,0,0)
CreateField('AVAILQUANTITY',15,0,0,0,0)
}
DB1.CreateRecordset('SEARCHES')
with (DB1.SEARCHES){
CreateField('SEARCH_ID',2,0,1,0,0,1)
CreateField('K1',30,254,0,0,0)
CreateField('SC1',30,254,0,0,0)
CreateField('SP1',30,254,0,0,0)
CreateField('SN1',30,254,0,0,0)
CreateField('SM1',30,254,0,0,0)
CreateField('STATE',7,1,0,1,'1')
}

DB1.CreateRecordset('ORDERS')
with (DB1.ORDERS){
CreateField('ORDERS_ID',2,0,1,0,0,1)
CreateField('ORMORDER',7,30,0,0,0)
CreateField('TOTALPRODUCT',11,0,0,1,0.00)
CreateField('TOTALTAX',11,0,0,1,0.00)
CreateField('TOTALSHIPPING',11,0,0,1,0.00)
CreateField('TOTALTAXSHIPPING',11,0,0,1,0.00)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('STOREENT_ID',15,0,1,0,0)
CreateField('CURRENCY',7,3,0,1,'USD')
CreateField('LOCKED',7,1,0,0,0)
CreateField('TIMEPLACED',27,0,0,0,0)
CreateField('LASTUPDATE',27,0,0,0,0)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('STATUS',7,1,0,0,0)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('BILLING_ADDRESS_ID',2,0,0,0,0)
CreateField('SHIPPING_ADDRESS_ID',2,0,0,0,0)
CreateField('FIELD2',11,0,0,0,0)
CreateField('FIELD3',30,254,0,0,0)
CreateField('TOTALADJUSTMENT',11,0,0,1,0.00)
CreateField('COMMENTS',30,254,0,0,0)
CreateField('NOTIFICATIONID',2,0,0,0,0)
CreateField('SHIPMODE_ID',2,0,0,0,0)
}

DB1.CreateRecordset('ORDERSMBR')
with (DB1.ORDERSMBR){
CreateField('ORDERS_ID',2,0,1,0,0,1)
CreateField('BECOMEAMEMBER',2,0,0,0,0)
CreateField('PASSWORD',30,254,0,0,0)
CreateField('PASSWORDCONF',30,254,0,0,0)
CreateField('BDAYDAY',30,254,0,0,0)
CreateField('BDAYMONTH',30,254,0,0,0)
CreateField('BDAYYEAR',30,254,0,0,0)
CreateField('RECEIVEINFO',2,0,0,0,0)
CreateField('RECEIVEOTHER',2,0,0,0,0)
CreateField('WATERSPORTS',2,0,0,0,0)
CreateField('GEAR',2,0,0,0,0)
CreateField('WIRELESS',2,0,0,0,0)
CreateField('ELECTRONICS',2,0,0,0,0)
CreateField('MODEL',2,0,0,0,0)
}

DB1.CreateRecordset('PROMOCODES')
with (DB1.PROMOCODES){
CreateField('PROMOCODE_ID',2,0,1,0,0)
}

DB1.CreateRecordset('ORDPAYMTHD')
with (DB1.ORDPAYMTHD){
CreateField('PAYMETHOD',7,5,1,0,0)
CreateField('ORDERS_ID',2,0,1,0,0)
CreateField('PAYDEVICE',3,0,1,0,0)
CreateField('TRADING_ID',2,0,0,0,0)
CreateField('POLICY_ID',2,0,0,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('FIELD1',30,254,0,0,0)
CreateField('FIELD2',30,254,0,0,0)
CreateField('MAXAMOUNT',11,0,0,0,0)
CreateField('ACTUALAMOUNT',11,0,0,0,0)
CreateField('CHARGEAMOUNT',11,0,0,0,0)
CreateField('CHARGETIME',27,0,0,0,0)
CreateField('CHARGEAMTCURR',7,3,0,1,'USD')
CreateField('STATUS',15,0,0,1,0)
}
// End Generated Code

DB1.CreateRecordset('MEMBER')
with (DB1.MEMBER){
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('DISPLAYNAME',30,254,0,0,0)
CreateField('PHOTOLINK',30,254,0,0,0)
CreateField('FIELD1',15,0,0,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('STATE',15,0,0,0,0)
}
DB1.CreateRecordset('MBRGRPMBR')
with (DB1.MBRGRPMBR){
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('MBRGRP_ID',2,0,1,0,0)
CreateField('CUSTOMERID',30,30,0,0,0)
CreateField('STATE',15,0,0,0,0)
}
DB1.CreateRecordset('NEWMEMBER')
with (DB1.NEWMEMBER){
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('DISPLAYNAME',30,254,0,0,0)
CreateField('PHOTOLINK',30,254,0,0,0)
}
DB1.CreateRecordset('MBRGRPNEWMBR')
with (DB1.MBRGRPNEWMBR){
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('MBRGRP_ID',2,0,1,0,0)
CreateField('CUSTOMERID',30,30,0,0,0)
}
DB1.CreateRecordset('MBRGRP')
with (DB1.MBRGRP){
CreateField('MBRGRP_ID',2,0,1,0,0,1) 
CreateField('MBRGRPNAME',30,254,1,0,0) 
CreateField('DESCRIPTION',30,254,0,0,0) 
CreateField('NAME',30,254,1,0,0) 
CreateField('LOGO',30,254,1,0,0) 
CreateField('PROPERTIES',30,254,0,0,0) 
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('CATENTRELMBR')
with (DB1.CATENTRELMBR){
CreateField('CATENTRY_ID',2,0,1,0,0)
CreateField('MEMBER_ID',2,0,1,0,0)
}
DB1.CreateRecordset('STORE')
with (DB1.STORE){
CreateField('STORE_ID',15,0,1,0,0,1)
CreateField('STOREGRP_ID',15,0,1,0,0)
CreateField('STORECGRY_ID',15,0,0,0,0)
CreateField('LANGUAGE_ID',15,0,0,0,0)
CreateField('FFMCENTER_ID',15,0,0,0,0)
CreateField('STATUS',15,0,1,1,1)
CreateField('STORE',7,10,0,0,0)
CreateField('DIRECTORY',30,254,0,0,0)
CreateField('OID',7,32,0,0,0)
CreateField('QUOTEGOODFOR',15,0,0,1,43200)
CreateField('MAXBOOFFSET',15,0,1,1,7776000)
CreateField('REJECTEDORDEXPIRY',15,0,0,1,259200)
CreateField('BOPMPADFACTOR',15,0,0,1,0)
CreateField('DEFAULTBOOFFSET',15,0,1,1,7776000)
CreateField('PRICEREFFLAGS',15,0,1,1,0)
CreateField('STORETYPE',7,3,0,1,'B2C')
CreateField('AVSACCEPTCODES',30,64,0,0,0)
CreateField('PERSISTENTSESSION',24,0,0,0,0)
}
DB1.CreateRecordset('STORECGRY')
with (DB1.STORECGRY){
CreateField('STORECGRY_ID',15,0,1,0,0,1)
CreateField('NAME',7,50,1,0,0)
}
DB1.CreateRecordset('STOREDEF')
with (DB1.STOREDEF){
CreateField('STORE_ID',15,0,1,0,0,1)
CreateField('CONTRACT_ID',2,0,0,0,0)
CreateField('SHIPMODE_ID',15,0,0,0,0)
}
DB1.CreateRecordset('STOREENT')
with (DB1.STOREENT){
CreateField('STOREENT_ID',15,0,1,0,0,1)
CreateField('MEMBER_ID',2,0,1,0,0)
CreateField('TYPE',7,1,1,0,0)
CreateField('SETCCURR',7,3,0,1,'USD')
CreateField('IDENTIFIER',30,254,1,0,0)
}
DB1.CreateRecordset('STOREENTDS')
with (DB1.STOREENTDS){
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('STOREENT_ID',15,0,1,0,0,1)
CreateField('DISPLAYNAME',7,80,0,0,0)
CreateField('DISPLAYNAME2',7,80,0,0,0)
CreateField('URL',7,80,0,0,0)
CreateField('STADDRESS_ID_LOC',15,0,0,0,0)
CreateField('DESCRIPTION',30,4000,0,0,0)
CreateField('STADDRESS_ID_CONT',15,0,0,0,0)
CreateField('FIELD1',30,256,0,0,0)
CreateField('FIELD2',30,256,0,0,0)
CreateField('FIELD3',30,256,0,0,0)
CreateField('FIELD4',30,256,0,0,0)
CreateField('FIELD5',30,256,0,0,0)
CreateField('FIELD6',30,256,0,0,0)
CreateField('FIELD7',30,256,0,0,0)
CreateField('FIELD8',30,256,0,0,0)
CreateField('FIELD9',30,256,0,0,0)
CreateField('FIELD10',30,256,0,0,0)
CreateField('FIELD11',30,256,0,0,0)
CreateField('MYSPACE',30,256,0,0,0)
}
DB1.CreateRecordset('STOREGRP')
with (DB1.STOREGRP){
CreateField('STOREGRP_ID',15,0,1,0,0,1)
CreateField('FIELD1',30,254,0,0,0)
}
DB1.CreateRecordset('STOREREL')
with (DB1.STOREREL){
CreateField('STRELTYP_ID',15,0,1,0,0,1)
CreateField('RELATEDSTORE_ID',15,0,1,0,0,1)
CreateField('STORE_ID',15,0,1,0,0,1)
CreateField('SEQUENCE',13,0,1,1,0)
CreateField('STATE',15,0,1,1,1)
}
DB1.CreateRecordset('STRELTYP')
with (DB1.STRELTYP){
CreateField('NAME',7,60,0,0,0)
CreateField('STRELTYP_ID',15,0,1,0,0,1)
}
DB1.CreateRecordset('STRELTYPDS')
with (DB1.STRELTYPDS){
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('STRELTYP_ID',15,0,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
}
DB1.CreateRecordset('OFFGROUP')
with (DB1.OFFGROUP){
CreateField('OFFGROUP_ID',2,0,1,0,0,1)
CreateField('STARTDATE',27,0,0,0,0)
CreateField('TRADEPOSCN_ID',2,0,1,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('PRECEDENCE',13,0,1,1,0)
CreateField('PUBLISHED',15,0,1,1,0)
CreateField('MINIMUMQUANTITY',13,0,0,0,0)
CreateField('QTYUNIT_ID',7,16,0,0,0)
CreateField('MAXIMUMQUANTITY',13,0,0,0,0)
CreateField('FIELD1',7,30,0,0,0)
CreateField('FIELD2',7,1,0,0,0)
CreateField('FLAGS',15,0,1,1,1)
CreateField('FLAGS2',30,64,0,0,0)
CreateField('IDENTIFIER',2,0,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('OFFER')
with (DB1.OFFER){
CreateField('OFFER_ID',2,0,1,0,0,1)
CreateField('OFFGROUP_ID',2,0,1,0,0)
CreateField('STARTDATE',27,0,0,0,0)
CreateField('TRADEPOSCN_ID',2,0,1,0,0)
CreateField('CATENTRY_ID',2,0,1,0,0)
CreateField('ENDDATE',27,0,0,0,0)
CreateField('PRECEDENCE',13,0,1,1,0)
CreateField('PUBLISHED',15,0,1,1,0)
CreateField('MINIMUMQUANTITY',13,0,0,0,0)
CreateField('QTYUNIT_ID',7,16,0,0,0)
CreateField('MAXIMUMQUANTITY',13,0,0,0,0)
CreateField('FIELD1',7,30,0,0,0)
CreateField('FIELD2',7,1,0,0,0)
CreateField('FLAGS',15,0,1,1,1)
CreateField('FLAGS2',30,64,0,0,0)
CreateField('IDENTIFIER',2,0,0,0,0)
CreateField('OID',30,64,0,0,0)
}
DB1.CreateRecordset('OFFERDESC')
with (DB1.OFFERDESC){
CreateField('OFFER_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
}
DB1.CreateRecordset('OFFGRPDESC')
with (DB1.OFFGRPDESC){
CreateField('OFFGROUP_ID',2,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
CreateField('THUMBNAIL',30,254,0,0,0)
CreateField('FULLIMAGE',30,254,0,0,0)
}
DB1.CreateRecordset('OFFERPRICE')
with (DB1.OFFERPRICE){
CreateField('OFFER_ID',2,0,1,0,0,1)
CreateField('CURRENCY',7,3,1,0,0)
CreateField('PRICE',11,0,1,0,0)
CreateField('COMPAREPRICE',11,0,0,0,0)
}
DB1.CreateRecordset('ORDIOFFER')
with (DB1.ORDIOFFER){
CreateField('OFFER_ID',2,0,1,0,0,1)
CreateField('ORDERITEMS_ID',2,0,1,0,0,1)
}
DB1.CreateRecordset('SHIPMODE')
with (DB1.SHIPMODE){
CreateField('SHIPMODE_ID',15,0,1,0,0,1)
CreateField('FIELD1',30,254,0,0,0)
CreateField('STOREENT_ID',15,0,1,0,0)
CreateField('FIELD2',15,0,0,0,0)
CreateField('CODE',7,30,0,0,0)
CreateField('CARRIER',7,30,0,0,0)
CreateField('TRACKINGURL',30,254,0,0,0)
CreateField('TRACKINGICON',30,64,0,0,0)
}
DB1.CreateRecordset('SHPMODEDSC')
with (DB1.SHPMODEDSC){
CreateField('SHIPMODE_ID',15,0,1,0,0,1)
CreateField('LANGUAGE_ID',15,0,1,0,0,1)
CreateField('DESCRIPTION',30,254,0,0,0)
}
DB1.CreateRecordset('CALCODE')
with (DB1.CALCODE){
CreateField('CALCODE_ID',15,0,1,0,0,1)
CreateField('CODE',7,128,1,0,0)
CreateField('CALUSAGE_ID',15,0,1,0,0)
CreateField('STOREENT_ID',15,0,1,0,0)
CreateField('CALMETHOD_ID',15,0,1,0,0)
}
DB1.CreateRecordset('CALMETHOD')
with (DB1.CALMETHOD){
CreateField('CALMETHOD_ID',15,0,1,0,0,1)
CreateField('STOREENT_ID',15,0,1,0,0)
CreateField('CALUSAGE_ID',15,0,1,0,0)
CreateField('TASKNAME',30,254,0,0,0)
CreateField('FIELD1',11,0,1,1,0.00)
}
DB1.CreateRecordset('SHPMODCLCD')
with (DB1.SHPMODCLCD){
CreateField('SHPMODCLCD_ID',15,0,1,0,0,1)
CreateField('STORE_ID',15,0,1,0,0)
CreateField('SHIPMODE_ID',15,0,0,0,0)
CreateField('CALCODE_ID',15,0,1,0,0)
CreateField('TRADING_ID',2,0,0,0,0)
}
DB1.CreateRecordset('PROMOCODEDESC')
with (DB1.PROMOCODEDESC){
CreateField('PROMOCODE_ID',15,0,1,0,0,1)
CreateField('CALUSAGE_ID',15,0,1,0,0)
CreateField('MINIMUM',11,0,1,1,0.00)
CreateField('CATENTRY_ID',2,0,1,0,0,1)
CreateField('PARTNUMBER',30,64,1,0,0)
CreateField('NAME',30,64,0,0,0)
CreateField('MFNAME',30,64,0,0,0)
CreateField('DISCOUNT',11,0,1,1,0.00)
}