// *********
// Generated by Microsoft Access visual basic module: =jsdatabase-constructor V2.2
// jsdatabase-constructor module available as freeware at: =www.javascriptdatabase.com
//
// latest version of Access-Object JavaScript Database =www.javascriptdatabase.com
// *********

var db = new Database('db')
db.CreateRecordset('existing')
db.CreateRecordset('cfl')

db.existing.CreateField('product_code',dbIndex)
db.existing.CreateField('web_description')
db.existing.CreateField('tech_description')
db.existing.CreateField('base')
db.existing.CreateField('watts')
db.existing.CreateField('volts')
db.existing.CreateField('lumens')
db.existing.CreateField('lumen_maintenance')
db.existing.CreateField('rated_life')
db.existing.CreateField('colour_temp')
db.existing.CreateField('image')
db.existing.CreateField('finish')

db.cfl.CreateField('cfl_product_code',dbIndex)
db.cfl.CreateField('cfl_replacem_code')
db.cfl.CreateField('cfl_web_description')
db.cfl.CreateField('cfl_base')
db.cfl.CreateField('cfl_watts')
db.cfl.CreateField('cfl_volts')
db.cfl.CreateField('cfl_tech_description')
db.cfl.CreateField('cfl_lumens')
db.cfl.CreateField('cfl_lumen_maintenance')
db.cfl.CreateField('cfl_rated_life')
db.cfl.CreateField('cfl_colour_temp')
db.cfl.CreateField('cfl_image')

with (db.existing) {
A([17967,"100 Watt Standard GLS B22 Base","100A1/F/B22","B22",100,240,1300,95,1000,2700,"<img src='imgs/gls.jpg'>","Frosted"])
A([19949,"100 Watt Standard GLS E27 Base","100A1/CL/E27","E27",100,240,1300,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([22542,"150 Watt Standard GLS B22 Base","150A1/CL/B22","B22",150,240,2160,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([517751,"150 Watt Standard GLS E27 Base","150A1/CL/E27","E27",150,240,2160,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([34979,"200 Watt Standard GLS B22 Base","200A1/CL/B22","B22",200,240,3000,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([91127,"200 Watt Standard GLS E27 Base","200A1/CL/E27","E27",200,240,3000,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19957,"25 Watt Standard GLS B22 Base","25A1/CL/B22","B22",25,240,225,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19944,"25 Watt Standard GLS E27 Base","25A1/CL/E27","E27",25,240,225,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19958,"40 Watt Standard GLS B22 Base","40A1/CL/B22","B22",40,240,410,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19946,"40 Watt Standard GLS E27 Base","40A1/CL/E27","E27",40,240,410,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19962,"60 Watt Standard GLS B22 Base","60A1/CL/B22","B22",60,240,700,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19947,"60 Watt Standard GLS E27 Base","60A1/CL/E27","E27",60,240,700,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19965,"75 Watt Standard GLS B22 Base","75A1/CL/B22","B22",75,240,930,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19948,"75 Watt Standard GLS E27 Base","75A1/CL/E27","E27",75,240,930,95,1000,2700,"<img src='imgs/gls.jpg'>","Clear"])
A([19777,"25 Watt Decorative Round E14 Base","25D1/F/E14","E14",25,240,200,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Frosted"])
A([91978,"25 Watt Decorative Round B15 Base","25D1/F/B15","B15",25,240,200,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Frosted"])
A([91967,"40 Watt Decorative Round B22 Base","40D1/CL/B22","B22",40,240,400,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Clear"])
A([91996,"40 Watt Decorative Round E27 Base","40D1/CL/E27","E27",40,240,400,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Clear"])
A([91983,"60 Watt Decorative Round B15 Base","60D1/CL/B15","B15",60,240,660,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Clear"])
A([19784,"60 Watt Decorative Round E14 Base","60D1/CL/E14","E14",60,240,660,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Clear"])
A([91999,"60 Watt Decorative Round E27 Base","60D1/F/E27","E27",60,240,660,95,1000,2700,"<img src='imgs/fancy_round.jpg'>","Frosted"])
A([10881,"40 Watt Candle Lamps E27 Base","40C1/F/E27","E27",40,240,400,95,1000,2700,"<img src='imgs/candle.jpg'>","Frosted"])
A([91651,"40 Watt Candle Lamps B22 Base","40C1/F/B22","B22",40,240,400,95,1000,2700,"<img src='imgs/candle.jpg'>","Frosted"])
A([31883,"60 Watt Sphericals B22 Base","60G95/OP/B22","B22",60,240,490,95,1000,2700,"<img src='imgs/globe_shape.jpg'>","Opaque"])
A([31888,"60 Watt Sphericals E27 Base","60G95/OP/E27","E27",60,240,490,95,1000,2700,"<img src='imgs/globe_shape.jpg'>","Opaque"])
A([328760,"40 Watt Reflector (Diffuse) E27 Base","40/R63/E27","E27",40,240,350,95,1000,2700,"<img src='imgs/reflector.jpg'>","R63"])
A([328795,"75 Watt Reflector (Diffuse) E27 Base","75/R80/E27","E27",75,240,320,95,1000,2700,"<img src='imgs/reflector.jpg'>","R80"])
}

with (db.cfl) {
A([89517,19962,"GE eXite Super Long Life","B22",10,240,"FLE10HLX/827/B22/XL",520,80,8000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([89514,19947,"GE eXite Super Long Life","E27",10,240,"FLE10HLX/827/E27/XL",520,80,8000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([30490,19962,"Electronic Biax T2 Spiral","B22",12,240,"FLE12HLX/827/B22 T2",700,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47399,19784,"Electronic Biax T2 Spiral","E14",12,240,"FLE12HLX/827/E14/T2",700,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([30472,19947,"Electronic Biax T2 Spiral","E27",12,240,"FLE12HLX/827/E27/T2",700,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47394,19962,"Electronic Biax T2 Spiral","B15",12,240,"FLE12HLX/840/B15/T2",700,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47393,19962,"Electronic Biax T2 Spiral","B22",12,240,"FLE12HLX/840/B22/T2",700,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47392,19784,"Electronic Biax T2 Spiral","E14",12,240,"FLE12HLX/840/E14/T2",700,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47389,19947,"Electronic Biax T2 Spiral","E27",12,240,"FLE12HLX/840/E27/T2",700,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([30492,19962,"Electronic Biax T2 Spiral","B22",12,240,"FLE12HLX/865/B22/T2",660,80,8000,6500,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([30474,19947,"Electronic Biax T2 Spiral","E27",12,240,"FLE12HLX/865/E27/T2",660,80,8000,6500,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([48190,19962,"Electronic Biax T3","B22",12,240,"FLE12TBX/827/B22/T3/",700,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([48189,19947,"Electronic Biax T3","E27",12,240,"FLE12TBX/827/E27/T3",700,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([48192,19962,"Electronic Biax T3","B22",12,240,"FLE12TBX/840/B22/T3",700,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([48191,19947,"Electronic Biax T3","E27",12,240,"FLE12TBX/840/E27/T3",700,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([85940,19965,"Electronic Biax T3 Spiral - Entice","B22",14,240,"FLE14HLX/827/B22/T3",950,80,8000,2700,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([85942,19948,"Electronic Biax T3 Spiral - Entice","E27",14,240,"FLE14HLX/827/E27/T3",950,80,8000,2700,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([90148,19965,"Electronic Biax T3 Spiral - Entice","B22",14,240,"FLE14HLX/840/B22/T3",950,80,8000,4000,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([90147,19948,"Electronic Biax T3 Spiral - Entice","E27",14,240,"FLE14HLX/840/E27/T3",950,80,8000,4000,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([71307,19965,"Electronic Biax T2 Spiral","B22",15,240,"FLE15HLX/827/B22/T2",900,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([89523,19965,"GE eXite Super Long Life","B22",15,240,"FLE15HLX/827/B22/XL T3",900,80,15000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([71039,19948,"Electronic Biax T2 Spiral","E27",15,240,"FLE15HLX/827/E27/T2",900,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([89520,19948,"GE eXite Super Long Life","E27",15,240,"FLE15HLX/827/E27/XL T3",900,80,15000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([71308,91967,"Electronic Biax T2 Spiral","B22",15,240,"FLE15HLX/840/B22/T2",900,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([71040,91996,"Electronic Biax T2 Spiral","E27",15,240,"FLE15HLX/840/E27/T2",900,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([71327,19962,"GE eXite Super Long Life","B22",15,240,"FLE15HLX/865/B22/Xl",860,80,15000,6500,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([71328,19448,"GE eXite Super Long Life","E27",15,240,"FLE15HLX/865/E27/IXL",860,80,15000,6500,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([95754,31833,"GE Electronic Biax T3 Ultra","E27",15,240,"FLE15T/827/E27/EC",800,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([89694,31833,"GE Electronic Biax T3 Ultra","E27",15,240,"FLE15T/827/E27/T3",800,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95610,19947,"GE Electronic Biax T3 Ultra","E27",15,240,"FLE15T/827/E27/T3",800,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95760,19947,"GE Electronic Biax T3 Ultra","E27",15,240,"FLE15T/827/E27/T3",800,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95790,19962,"GE Electronic Biax T3 Economiser","B22",15,240,"FLE15T/840/B22/EC",900,80,6000,4000,"<img src='imgs/economiser.jpg' width='75' height='150'>"])
A([89603,19962,"GE Electronic Biax T3 Ultra","B22",15,240,"FLE15T/840/B22/T3",800,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95800,19962,"GE Electronic Biax T3 Ultra","B22",15,240,"FLE15T/840/B22/T3",800,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95791,19947,"GE Electronic Biax T3 Economiser","E27",15,240,"FLE15T/840/E27/EC",900,80,8000,4000,"<img src='imgs/economiser.jpg' width='75' height='150'>"])
A([95804,19947,"GE Electronic Biax T3 Ultra","E27",15,240,"FLE15T/840/E27/T3",800,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95763,19965,"GE Electronic Biax T3 Ultra","B22",18,240,"FLE18T/827/B22/T3",1096,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95762,19948,"GE Electronic Biax T3 Ultra","E27",18,240,"FLE18T/827/E27/T3",1096,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95802,19965,"GE Electronic Biax T3 Ultra","B22",18,240,"FLE18T/840/B22/T3",1010,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95805,19948,"GE Electronic Biax T3 Ultra","E27",18,240,"FLE18T/840/E27/T3",1010,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([37726,31888,"Electronic Biax Decore GLS","E27",20,240,"FLE20GLS/O/E27",1050,80,6000,2700,"<img src='imgs/globe.jpg' width='75' height='150'>"])
A([85956,17967,"Electronic Biax T3 Spiral - Entice","B22",20,240,"FLE20HLX/827/B22/T3",1200,80,8000,2700,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([89529,17967,"GE eXite Super Long Life","B22",20,240,"FLE20HLX/827/B22/XL T3",1200,80,15000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([85966,19949,"Electronic Biax T3 Spiral - Entice","E27",20,240,"FLE20HLX/827/E27/T3",1200,80,8000,2700,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([89526,517751,"GE eXite Super Long Life","E27",20,240,"FLE20HLX/827/E27/XL T3",1200,80,15000,2700,"<img src='imgs/15000_spiral.jpg' width='75' height='150'>"])
A([90146,22542,"Electronic Biax T3 Spiral - Entice","B22",20,240,"FLE20HLX/840/B22/T3",1200,80,8000,4000,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([71043,91651,"Electronic Biax T2 Spiral","E27",20,240,"FLE20HLX/840/E27/T2",1100,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([90145,17967,"Electronic Biax T3 Spiral - Entice","E27",20,240,"FLE20HLX/840/E27/T3",1200,80,8000,4000,"<img src='imgs/spiral.jpg' width='75' height='150'>"])
A([95757,34979,"Electronic Biax T3 Spiral - Entice","B22",20,240,"FLE20T/827/B22/EC",1200,80,6000,2700,"<img src='imgs/tbx_lamps.jpg' width='75' height='150'>"])
A([80268,328760,"Electronic Biax Reflector","E27",5,240,"FLE5R63/827/E27",52,80,6000,2700,"<img src='imgs/reflector.jpg' width='75' height='150'>"])
A([81029,91651,"Electronic Biax Decore Candle","B22",7,240,"FLE7CDL/O/827/B22",311,80,6000,2700,"<img src='imgs/candle_cfl.jpg' width='75' height='150'>"])
A([81030,10881,"Electronic Biax Decore Candle","E27",7,240,"FLE7CDL/O/827/E27",311,80,6000,2700,"<img src='imgs/candle_cfl.jpg' width='75' height='150'>"])
A([80270,328795,"Electronic Biax Reflector","E27",7,240,"FLE7R80/827/E27 BP",99,80,8000,2700,"<img src='imgs/reflector_ee.jpg' width='75' height='150'>"])
A([30549,19944,"Electronic Biax T2 Spiral","E27",8,240,"FLE8HLX/827/E27/T2",460,80,8000,2700,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47386,91978,"Electronic Biax T2 Spiral","B15",8,240,"FLE8HLX/840/B15/T2",430,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47385,19958,"Electronic Biax T2 Spiral","B22",8,240,"FLE8HLX/840/B22/T2",430,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47382,19777,"Electronic Biax T2 Spiral","E14",8,240,"FLE8HLX/840/E14/T2",430,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([47375,91996,"Electronic Biax T2 Spiral","E27",8,240,"FLE8HLX/840/E27/T2",430,80,8000,4000,"<img src='imgs/tiny.jpg' width='75' height='150'>"])
A([11241,19958,"Electronic Biax T3","B22",9,240,"FLE9T/827/B22/T3",497,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([11243,19946,"Electronic Biax T3","E27",9,240,"FLE9T/827/E27/T3",497,80,8000,2700,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95836,19965,"Electronic Biax T3","B22",9,240,"FLE9T/840/B22/T3",440,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
A([95837,19948,"Electronic Biax T3","E27",9,240,"FLE9T/840/E27/T3",440,80,8000,4000,"<img src='imgs/ultra.jpg' width='75' height='150'>"])
}