// *********
// Created from MS-Access.  Inventory, etc data input to CraftiLori Store at craftilori.com
//
// latest version of AccessObject-JavascriptDatabase http://www.javascriptdatabase.com
// *********

var CLDB = new Database('CLDB')
CLDB.CreateRecordset('CLDefaults')
CLDB.CreateRecordset('CLPicURLs')
CLDB.CreateRecordset('CLstorecats')
CLDB.CreateRecordset('CLstoregroups')
CLDB.CreateRecordset('CLstoreitems')
CLDB.CreateRecordset('MailAddress')

CLDB.CLDefaults.CreateField('recname')
CLDB.CLDefaults.CreateField('override')
CLDB.CLDefaults.CreateField('flaguse')
CLDB.CLDefaults.CreateField('flag1')
CLDB.CLDefaults.CreateField('flag2')
CLDB.CLDefaults.CreateField('flag3')
CLDB.CLDefaults.CreateField('flag4')
CLDB.CLDefaults.CreateField('flag5')
CLDB.CLDefaults.CreateField('txtuse')
CLDB.CLDefaults.CreateField('txt1')
CLDB.CLDefaults.CreateField('txt2')
CLDB.CLDefaults.CreateField('txt3')
CLDB.CLDefaults.CreateField('txt4')
CLDB.CLDefaults.CreateField('txt5')
CLDB.CLDefaults.CreateField('comment')

CLDB.CLPicURLs.CreateField('picbase')
CLDB.CLPicURLs.CreateField('leadstring')
CLDB.CLPicURLs.CreateField('nmbrlen')
CLDB.CLPicURLs.CreateField('trailstring')

CLDB.CLstorecats.CreateField('gcseq')
CLDB.CLstorecats.CreateField('gcactv')
CLDB.CLstorecats.CreateField('grpid')
CLDB.CLstorecats.CreateField('gcdesc')
CLDB.CLstorecats.CreateField('plhf')
CLDB.CLstorecats.CreateField('gcblurb')

CLDB.CLstoregroups.CreateField('grpid')
CLDB.CLstoregroups.CreateField('grpdesc')
CLDB.CLstoregroups.CreateField('grpactv')
CLDB.CLstoregroups.CreateField('grpshowz')
CLDB.CLstoregroups.CreateField('grpblbintro')
CLDB.CLstoregroups.CreateField('grpblurb')
CLDB.CLstoregroups.CreateField('grppicurl')
CLDB.CLstoregroups.CreateField('grppreblurb')

CLDB.CLstoreitems.CreateField('clitmid',dbIndex)
CLDB.CLstoreitems.CreateField('gcseq')
CLDB.CLstoreitems.CreateField('gcaxsq')
CLDB.CLstoreitems.CreateField('gcbxsq')
CLDB.CLstoreitems.CreateField('iname')
CLDB.CLstoreitems.CreateField('desc1')
CLDB.CLstoreitems.CreateField('price')
CLDB.CLstoreitems.CreateField('rprice')
CLDB.CLstoreitems.CreateField('pic1')
CLDB.CLstoreitems.CreateField('pic2')
CLDB.CLstoreitems.CreateField('pic3')
CLDB.CLstoreitems.CreateField('pic4')
CLDB.CLstoreitems.CreateField('spec')
CLDB.CLstoreitems.CreateField('picbase')

CLDB.MailAddress.CreateField('maddno')
CLDB.MailAddress.CreateField('active')
CLDB.MailAddress.CreateField('madd1')
CLDB.MailAddress.CreateField('madd2')
CLDB.MailAddress.CreateField('madd3')

with (CLDB.CLDefaults) {
A(["Addr1",0,"",0,0,0,0,0,"mail address 1","5274 S Red Yucca Lane","Gold Canyon","Arizona  85218","","",""])
A(["Addr2",0,"",0,0,0,0,0,"mail address 2","1014 N Cloud Cliff Pass","Prescott Valley","Arizona  86314","","",""])
A(["AddrSelect",0,"select mail addr",1,0,0,0,0,"","","","","","","flag 1 specifies mail addr to use"])
A(["Options1",0,"design/dynpics/ebay",0,0,0,0,0,"","","","","","","flag 1 = 0/1 for multiwindow/uniwindow operation"])
A(["PicURLs",,"",0,0,0,0,0,"prods/thumbs","http://craftilori.com/store/prodpics/","http://craftilori.com/store/prodthumbs/","","","",""])
}

with (CLDB.CLPicURLs) {
A([1,"DCP_",4,".JPG"])
A([2,"DCP0",4,".JPG"])
A([3,"100_",4,".JPG"])
}

with (CLDB.CLstorecats) {
A([100,1,1,"All HeartFelt Purses",1,""])
A([199,1,1,"HeartFelt Purses",0,""])
A([120,1,1,"Avail From Inventory",0,"Items in this category are currently available and ready to ship.  Since each is a unique handcrafted item, once sold it will be removed from the ''Avail From Inventory'' category.  Check this site frequently for new additions."])
A([130,1,1,"Special Order Designs",0,"Items shown in this category can be special ordered.  Price of special order items will depend of details such as type/color of yarn, accessories, etc.  Feel free to add special order items to your cart and proceed through checkout with them. After receiving your order we will contact you to settle details and establish pricing."])
A([200,1,2,"All Copper Art",1,""])
A([210,1,2,"Framed Art",0,""])
A([220,1,2,"Unframed Wallhangings",0,""])
A([299,1,2,"Other Copper Art",0,""])
}

with (CLDB.CLstoregroups) {
A([1,"HeartFelt Purses",1,0,"HeartFelt Purses","CraftiLori's HeartFelt Purses are hand knitted and ''felted'' from 100% wool yarn.  Accent yarns can be nylon, viscose, or polyamide.  Felting creates a cloth-like fabric which will not stretch or lose its shape with use.  The result: adorable, hand-washable purses that don't look knitted at all!   You will see some designs that can be special-ordered with your choice of colors, etc.  Feel free to add special order items to your cart and proceed through checkout with them. After receiving your order we will contact you to settle details and establish pricing.","http://craftilori.com/store/prodpics/DCP_0820.jpg",""])
A([2,"Copper Art",1,0,"Copper Art","CraftiLori's unique handcrafted copper art creations come in a variety of forms, including framed art, unframed wallhangings, and table/shelf decorations. Most have a Southwestern motif, and many of them represent elements of American Indian lore.  Each item is created with utmost care and dedication to highest quality.  These are one-of-a-kind creations that you will be proud to display in your home.","http://craftilori.com/store/prodpics/100_0396.JPG",""])
}

with (CLDB.CLstoreitems) {
A([196,120,,,"Classic Tweed","Everyday bag",62,0,"0822","","","",0,1])
A([198,120,,,"In Style","For Fun On The Go!",45,0,"0336","","","",0,3])
A([202,120,,,"Olive Delight","Olive Delight Bag",38,,"356","","","",,3])
A([203,120,,,"Blazing Color","Blazing colored tote",48,,"352","","","",,3])
A([209,120,,,"Small Everyday Bag","Classic Bag",60,0,"371","","","",,3])
A([210,120,,,"Furry Beauty","Earthtone Beauty",58,0,"370","","","",,3])
A([211,120,,,"The Market Bag","Shoppers Companion",50,0,"374","","","",,3])
A([215,210,,,"Life's Journey","11x12  Double matted, copper frame",60,,"388","","","",,3])
A([217,210,,,"Indian Pottery","9x12 Double matted, copper frame",75,,"396","","","",,3])
A([220,210,,,"Healing Hand","8x10 Double matted, copper frame",55,,"406","","","",,3])
A([221,210,,,"On Display","9x12 Double matted, copper frame",65,,"409","","","",,3])
A([224,210,,,"Old Bear","12x12 Double matted, copper frame",75,,"427","","","",,3])
A([225,210,,,"Old Goat","14x14 Double matted, copper frame",80,,"428","","","",,3])
A([226,210,,,"Red Roof Mission","11x14 Double matted, copper frame",75,,"410","","","",,3])
A([227,210,,,"Tranquil Pottery","11x14 Double matted, copper frame",78,,"411","","","",,3])
A([228,210,,,"Pottery Collection #1","11x14 Double matted, copper frame",80,,"412","","","",,3])
A([236,210,,,"Southwest Tablescape","11x14 Double matted, copper frame",75,,"420","","","",,3])
A([239,210,,,"Santa Fe Pots","12x16 Double matted, copper frame",82,,"433","","","",,3])
A([242,210,,,"Native Canteen","9x12 Double matted, copper frame",55,,"437","","","",,3])
A([243,210,,,"Tumbling Pots","8x16 Double matted, copper frame",65,,"439","","","",,3])
A([245,210,,,"Cowboy Tablescape","11x14 Double matted, copper frame",77,,"442","","","",,3])
}

with (CLDB.MailAddress) {
A([1,1,"CraftiLori Creations","5274 S Red Yucca Lane","Gold Canyon, AZ  85219"])
A([2,0,"CraftiLori Creations","1014 N Cloud Cliff Pass","Prescott Valley, AZ  86314"])
}