|
Post by meerkat on Mar 25, 2020 14:09:21 GMT -5
BTW.. Here is the DB export.
# -------------------------------------------------------- # SQLite Dump # Generation Time:Mar 25, 2020 12:07:28 # --------------------------------------------------------
# -------------------------------------------------------- # Table structure for: face 16 fields # -------------------------------------------------------- CREATE TABLE face ( facet CHAR(2), descr VARCHAR(22), short VARCHAR(10), caption CHAR(1), label CHAR(1), color CHAR(1), array CHAR(1), row CHAR(1), col CHAR(1), wide CHAR(1), defWide INT(3), high CHAR(1), defHigh INT(3), branch1 CHAR(1), branch2 CHAR(1), notes TEXT NULL ); CREATE UNIQUE INDEX face_facet ON face ( facet );
# -------------------------------------------------------- # Dumping 10 records for table: face # -------------------------------------------------------- INSERT INTO face VALUES ('ST','statictext','statictext','Y','N','','N','O','O','O',0,'O',20,'N','N','STATICTEXT #handle.ext, "string", xpos, ypos, wide, high'); INSERT INTO face VALUES ('GB','groupbox','groupbox','Y','Y','','N','Y','Y','Y',100,'Y',100,'N','N','GROUPBOX #handle.ext, "label", x, y, wide, high'); INSERT INTO face VALUES ('CB','combobox','combobox','N','N','','Y','O','O','O',60,'O',20,'Y','N','COMBOBOX #handle.ext, array$(), eventHandler, xPos, yPos, wide, high'); INSERT INTO face VALUES ('LB','listbox','listbox','N','N','','Y','O','O','O',60,'O',20,'Y','N','LISTBOX #handle.ext, array$(), eventHandler, x, y, wide, high'); INSERT INTO face VALUES ('TB','textbox','textbox','N','N','','N','O','O','O',40,'O',20,'N','N','TEXTBOX #handle.ext, xpos, ypos, wide, high'); INSERT INTO face VALUES ('BT','button','button','Y','Y','','N','O','O','O',40,'O',20,'Y','N','BUTTON #handle.ext, "label", returnVar, corner, x, y {, width, height}'); INSERT INTO face VALUES ('TE','texteditor','texteditor','N','N','','N','O','O','Y',200,'Y',100,'N','N','TEXTEDITOR #handle.ext, xpos, ypos, wide, high'); INSERT INTO face VALUES ('GD','grid','grid','Y','N','','Y','O','O','Y',200,'Y',100,'Y','N',''); INSERT INTO face VALUES ('XB','checkbox','checkbox','Y','Y','','N','O','O','O',5,'O',20,'Y','Y','CHECKBOX #handle.ext, "label", setHandler, resetHandler, x, y, wide, high'); INSERT INTO face VALUES ('RB','radiobutton','radiobutton','Y','Y','','N','O','O','O',5,'O',20,'Y','Y','RADIOBUTTON #handle.ext, "label", setHandler, resetHandler, x, y, wide, high');
# -------------------------------------------------------- # Table structure for: facet 9 fields # -------------------------------------------------------- CREATE TABLE facet ( facetCd CHAR(2), facetCmd VARCHAR(22), caption CHAR(1), array CHAR(1), defWide INT(3), defHigh INT(3), branch1 CHAR(1), branch2 CHAR(1), notes TEXT NULL ); CREATE UNIQUE INDEX facet_Cmd ON facet ( facetCmd ) ;
# -------------------------------------------------------- # Dumping 17 records for table: facet # -------------------------------------------------------- INSERT INTO facet VALUES ('ST','statictext','Y','N',5,20,'N','N','STATICTEXT #handle.ext, string, xpos, ypos, wide, high'); INSERT INTO facet VALUES ('GB','groupbox','Y','N',100,100,'N','N','GROUPBOX #handle.ext, label, x, y, wide, high'); INSERT INTO facet VALUES ('CB','combobox','N','Y',60,20,'Y','N','COMBOBOX #handle.ext, array$(), eventHandler, xPos, yPos, wide, high'); INSERT INTO facet VALUES ('LB','listbox','N','Y',60,20,'Y','N','LISTBOX #handle.ext, array$(), eventHandler, x, y, wide, high'); INSERT INTO facet VALUES ('TB','textbox','N','N',40,20,'N','N','TEXTBOX #handle.ext, xpos, ypos, wide, high'); INSERT INTO facet VALUES ('BT','button','Y','N',40,20,'Y','N','BUTTON #handle.ext, label, returnVar, corner, x, y {, width, height}'); INSERT INTO facet VALUES ('TE','texteditor','N','N',200,100,'N','N','TEXTEDITOR #handle.ext, xpos, ypos, wide, high'); INSERT INTO facet VALUES ('GD','grid','Y','Y',200,100,'Y','N',''); INSERT INTO facet VALUES ('XB','checkbox','Y','N',5,20,'Y','Y','CHECKBOX #handle.ext, label, setHandler, resetHandler, x, y, wide, high'); INSERT INTO facet VALUES ('RB','radiobutton','Y','N',5,20,'Y','Y','RADIOBUTTON #handle.ext, label, setHandler, resetHandler, x, y, wide, high'); INSERT INTO facet VALUES ('-','across','','',0,0,'','','layout goes across. can enter where to loc'); INSERT INTO facet VALUES ('-','down','','',0,0,'','','cancle across and go down. can specify pixels down'); INSERT INTO facet VALUES ('-','style','','',0,0,'','','user specified style'); INSERT INTO facet VALUES ('-','return','','',0,0,'','','Set current location to LM'); INSERT INTO facet VALUES ('-','lm','','',0,0,'','','Specify Left Margin'); INSERT INTO facet VALUES ('-','rm','','',0,0,'','','Specify Right Margin'); INSERT INTO facet VALUES ('-','window','','',800,600,'','','Specify window width and height');
# -------------------------------------------------------- # Table structure for: formDtl 13 fields # -------------------------------------------------------- CREATE TABLE formDtl ( formId VARCHAR(12), seq DECIMAL(5,1), move CHAR(2), chain INT(4), facet CHAR(2), caption VARCHAR(40), array VARCHAR(12), row INT(4), col INT(4), wide INT(4), high INT(4), branch1 VARCHAR(12), branch2 VARCHAR(12) ); CREATE INDEX formDtl_formId ON formDtl ( formId ) ;
# -------------------------------------------------------- # Dumping 84 records for table: formDtl # -------------------------------------------------------- INSERT INTO formDtl VALUES ('client',10,'LU',10,'BT','Num','',30,10,0,20,'',''); INSERT INTO formDtl VALUES ('client',20,'',10,'TB','First Name','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',30,'',10,'TB','Middle Name','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',40,'',10,'TB','Last Name','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',50,'',10,'TB','City','',0,0,120,20,'',''); INSERT INTO formDtl VALUES ('client',60,'',10,'CB','StateID','stateId$()',0,0,110,20,'[stateId]',''); INSERT INTO formDtl VALUES ('client',70,'',10,'TB','Zip','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',80,'',10,'TB','Phone','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',90,'',10,'TB','eMail','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('client',100,'',10,'TE','Notes','',0,0,160,80,'',''); INSERT INTO formDtl VALUES ('client',110,'AC',110,'ST','Page','',10,400,0,20,'',''); INSERT INTO formDtl VALUES ('client',120,'',110,'BT','<','',0,0,0,20,'[prePage]',''); INSERT INTO formDtl VALUES ('client',130,'',110,'TB','','',0,0,40,20,'',''); INSERT INTO formDtl VALUES ('client',140,'',110,'BT','>','',0,0,0,20,'[nxtPage]',''); INSERT INTO formDtl VALUES ('form',10,'',0,'ST','This is a statitext caption','',0,0,270,20,'',''); INSERT INTO formDtl VALUES ('form',20,'DN',20,'ST','Static Caption one','',0,0,180,20,'',''); INSERT INTO formDtl VALUES ('form',30,'DN',30,'CB','combo caption','cmbo$()',0,0,130,20,'[combo1]',''); INSERT INTO formDtl VALUES ('form',40,'DN',40,'ST','static wit row col wide high','',200,300,280,500,'',''); INSERT INTO formDtl VALUES ('form',80,'',50,'TE','text editor','',0,0,110,500,'',''); INSERT INTO formDtl VALUES ('form',80,'AC',50,'LB','List Box','array$()',0,0,80,20,'lbranch1',''); INSERT INTO formDtl VALUES ('person',10,'LU',10,'TB','Num','',0,10,110,20,'',''); INSERT INTO formDtl VALUES ('person',100,'',10,'BT','Add','',0,0,30,20,'[add]',''); INSERT INTO formDtl VALUES ('person',110,'AC',110,'BT','Chg','',0,0,30,20,'[chg]',''); INSERT INTO formDtl VALUES ('person',120,'',110,'BT','Del','',0,0,30,20,'[del]',''); INSERT INTO formDtl VALUES ('person',130,'',110,'BT','Exit','',0,0,40,20,'[exit]',''); INSERT INTO formDtl VALUES ('person',140,'',110,'BT','<','',20,350,5,20,'[prePage]',''); INSERT INTO formDtl VALUES ('person',150,'',110,'TB','','',0,0,40,20,'',''); INSERT INTO formDtl VALUES ('person',160,'',110,'BT','>','',0,0,5,20,'[nxtPage]',''); INSERT INTO formDtl VALUES ('person',170,'DN',170,'GD','Num,Name/150,Sddr/110,City/110,St,Phone/100,eMail/100','perGrid$()',30,300,300,200,'[goGrid]',''); INSERT INTO formDtl VALUES ('person',20,'AC',10,'TB','First Name','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('person',30,'',10,'TB','Middle Name','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('person',40,'',10,'TB','Last Name','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('person',50,'',10,'TB','Address','',0,0,70,20,'',''); INSERT INTO formDtl VALUES ('person',60,'',10,'TB','City','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('person',70,'',10,'CB','State','stateId$()',0,0,80,20,'[goStateId]',''); INSERT INTO formDtl VALUES ('person',80,'',10,'TB','Phone','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('person',90,'',10,'TB','eMail','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('rolidex',10,'DN',10,'BT','Add','',10,100,40,20,'[add]',''); INSERT INTO formDtl VALUES ('rolidex',100,'',80,'TB','Middle Name','',0,0,200,20,'',''); INSERT INTO formDtl VALUES ('rolidex',110,'',80,'TB','Last Name','',0,0,200,20,'',''); INSERT INTO formDtl VALUES ('rolidex',120,'',80,'TB','Address','',0,0,200,20,'',''); INSERT INTO formDtl VALUES ('rolidex',130,'',80,'TB','City','',0,0,130,20,'',''); INSERT INTO formDtl VALUES ('rolidex',140,'',80,'CB','StateId','sstateId$()',0,0,130,20,'[stateId]',''); INSERT INTO formDtl VALUES ('rolidex',150,'',80,'TB','Zip','',0,0,110,20,'',''); INSERT INTO formDtl VALUES ('rolidex',160,'',80,'TB','Phone 1','',0,0,170,20,'',''); INSERT INTO formDtl VALUES ('rolidex',170,'',80,'TB','Phone 2','',0,0,170,20,'',''); INSERT INTO formDtl VALUES ('rolidex',180,'',80,'TB','eMail','',0,0,300,20,'',''); INSERT INTO formDtl VALUES ('rolidex',190,'',80,'TE','Notes','',0,0,300,200,'',''); INSERT INTO formDtl VALUES ('rolidex',20,'AC',20,'BT','Chg','',0,0,40,20,'[chg]',''); INSERT INTO formDtl VALUES ('rolidex',200,'DN',200,'ST','Page','',10,600,0,20,'',''); INSERT INTO formDtl VALUES ('rolidex',210,'AC',210,'BT','<','',0,0,15,20,'[prePage]',''); INSERT INTO formDtl VALUES ('rolidex',220,'',210,'TB','','',0,0,40,20,'',''); INSERT INTO formDtl VALUES ('rolidex',230,'',210,'BT','>','',0,0,15,20,'[nxtPage]',''); INSERT INTO formDtl VALUES ('rolidex',240,'DN',240,'GD','Comp/120,First/120,Mi/30,Last/120,Addr/120,City/100,St/30,,Zip/70,Phone/120,eMail/120,Url/3,Notes/100','kinfo$()',40,460,800,500,'[info]',''); INSERT INTO formDtl VALUES ('rolidex',250,'DN',250,'TB','','',40,440,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',260,'DN',260,'TB','','',60,440,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',270,'',260,'TB','','',80,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',280,'',260,'TB','','',100,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',290,'',260,'TB','','',120,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',30,'',20,'BT','Del','',0,0,40,20,'[del]',''); INSERT INTO formDtl VALUES ('rolidex',300,'',260,'TB','','',140,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',310,'',260,'TB','','',180,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',320,'',260,'TB','','',200,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',330,'',260,'TB','','',220,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',340,'',260,'TB','','',30,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',350,'',260,'TB','','',30,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',360,'',260,'TB','','',30,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',370,'',260,'TB','','',30,400,20,20,'',''); INSERT INTO formDtl VALUES ('rolidex',40,'',20,'BT','Clr','',0,0,40,20,'[clr]',''); INSERT INTO formDtl VALUES ('rolidex',50,'',20,'BT','Srch','',0,0,40,20,'[srch]',''); INSERT INTO formDtl VALUES ('rolidex',60,'',20,'BT','Sort','',0,0,40,20,'[sort]',''); INSERT INTO formDtl VALUES ('rolidex',70,'',20,'BT','Exit','',0,0,40,20,'[exit]',''); INSERT INTO formDtl VALUES ('rolidex',80,'LU',80,'TB','Company','',40,10,110,20,'',''); INSERT INTO formDtl VALUES ('rolidex',90,'',80,'TB','First Name','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('test1',10,'LU',10,'ST','This is statitext caption','',40,0,250,20,'branch11',''); INSERT INTO formDtl VALUES ('test1',30,'',10,'ST','This is Static Test','',0,0,100,20,'',''); INSERT INTO formDtl VALUES ('test1',20,'',10,'XB','This is CheckBox','',0,0,5,20,'xbranch','xxxx'); INSERT INTO formDtl VALUES ('test1',40,'AC',40,'BT','Add','',0,0,40,20,'[doAdd]',''); INSERT INTO formDtl VALUES ('test1',70,'LU',70,'CB','This is Combo Box','',0,0,170,20,'[combo]',''); INSERT INTO formDtl VALUES ('test1',80,'',70,'GB','This is GroupBox','',20,30,200,100,'',''); INSERT INTO formDtl VALUES ('test1',90,'LU',90,'GD','This is a grid','g$()',0,0,140,100,'[combo]',''); INSERT INTO formDtl VALUES ('test1',100,'',90,'XB','A CheckBox','',0,0,5,20,'[chk]','[chkOff]'); INSERT INTO formDtl VALUES ('test1',50,'',40,'BT','Chg','',0,0,0,20,'[doChg]',''); INSERT INTO formDtl VALUES ('test1',60,'',40,'BT','Del','',0,0,40,20,'[doDel]','');
# -------------------------------------------------------- # Table structure for: formHdr 10 fields # -------------------------------------------------------- CREATE TABLE formHdr ( formId VARCHAR(12), title VARCHAR(25), wide INT(4), high INT(4), leftMargin INT(4), rightMargin INT(4), topMargin INT(4), rowSize INT(4), spacer INT(2), notes TEXT ); CREATE UNIQUE INDEX formHdr_formId ON formHdr( formId);
# -------------------------------------------------------- # Dumping 6 records for table: formHdr # -------------------------------------------------------- INSERT INTO formHdr VALUES ('form','Test From Layout',800,400,12,13,11,20,8,'Notes'); INSERT INTO formHdr VALUES ('xxx','test xxx',500,600,8,9,7,30,10,'xxx notes'); INSERT INTO formHdr VALUES ('test1','Test one',600,400,9,8,10,40,4,'test one notes '); INSERT INTO formHdr VALUES ('person','Person file wide = 800, high = 600',800,600,5,10,10,20,5,'This is a layout of the person table '); INSERT INTO formHdr VALUES ('rolidex','Test From Layout',1400,800,0,0,0,20,2,'Notes '); INSERT INTO formHdr VALUES ('client','Test From Layout',800,400,5,13,0,20,8,'Notes ');
# -------------------------------------------------------- # Table structure for: loc 4 fields # -------------------------------------------------------- CREATE TABLE loc ( formId CHAR(12), seq SMALLINT(3) NULL, row INT(4) NULL, col INT(4) NULL ); CREATE UNIQUE INDEX loc_ ON loc( formId, seq);
# -------------------------------------------------------- # Dumping 10 records for table: loc # -------------------------------------------------------- INSERT INTO loc VALUES ('test1',10,40,12); INSERT INTO loc VALUES ('test1',20,64,12); INSERT INTO loc VALUES ('test1',30,88,12); INSERT INTO loc VALUES ('test1',40,88,340); INSERT INTO loc VALUES ('test1',50,88,416); INSERT INTO loc VALUES ('test1',60,88,452); INSERT INTO loc VALUES ('test1',70,88,12); INSERT INTO loc VALUES ('test1',80,20,30); INSERT INTO loc VALUES ('test1',90,124,12); INSERT INTO loc VALUES ('test1',100,228,12);
# -------------------------------------------------------- # Table structure for: styles 8 fields # -------------------------------------------------------- CREATE TABLE styles ( style VARCHAR(10) NULL, descr TEXT NULL, lbCode VARCHAR(10) NULL, color VARCHAR(10) NULL, fontsize SMALLINT(2) NULL, col SMALLINT(2) NULL, row SMALLINT(2) NULL, lbDoc TEXT NULL );
# -------------------------------------------------------- # Dumping 40 records for table: styles # -------------------------------------------------------- INSERT INTO styles VALUES ('title','Document title heading.','statictext','',18,0,0,'STATICTEXT #handle.ext, "string", xpos, ypos, wide, high'); INSERT INTO styles VALUES ('h1','Top level heading used for documents.','statictext','',16,0,0,''); INSERT INTO styles VALUES ('h2','Heading use for document sections.','statictext','',14,0,0,''); INSERT INTO styles VALUES ('h3','Heading used for subsections.','statictext','',12,0,0,''); INSERT INTO styles VALUES ('h4','Heading used below subsections.','statictext','',10,0,0,''); INSERT INTO styles VALUES ('h5','Heading used below subsections.','statictext','',8,0,0,''); INSERT INTO styles VALUES ('banner','Title heading with video style.','statictext','gold',18,0,0,''); INSERT INTO styles VALUES ('vh1','Section heading used for video style.','statictext','gold',16,0,0,''); INSERT INTO styles VALUES ('vh2','Section heading used for video style.','statictext','gold',14,0,0,''); INSERT INTO styles VALUES ('vh3','Section heading used for video style.','statictext','gold',12,0,0,''); INSERT INTO styles VALUES ('text','Document body text.','statictext','',10,0,0,''); INSERT INTO styles VALUES ('txt','An alias for TEXT style above.','statictext','',10,0,0,''); INSERT INTO styles VALUES ('vtext','Inverse video body text.','','',0,0,0,''); INSERT INTO styles VALUES ('tt','The teletype font for fixed width text.','','',0,0,0,''); INSERT INTO styles VALUES ('code','Same as TT except defaults to bold.','','',0,0,0,''); INSERT INTO styles VALUES ('label','Used for specifying GUI text labels.','','',0,0,0,''); INSERT INTO styles VALUES ('field','Text entry field.','textbox','',0,0,0,'TEXTBOX #handle.ext, xpos, ypos, wide, high'); INSERT INTO styles VALUES ('info','Same as FIELD style, but read-only.','','',0,0,0,''); INSERT INTO styles VALUES ('area','Text editing area for paragraph entry.','texteditor','',0,0,0,'TEXTEDITOR #handle.ext, xpos, ypos, wide, high'); INSERT INTO styles VALUES ('sensor','An invisible face that senses mouse events.','','',0,0,0,''); INSERT INTO styles VALUES ('image','Display a JPEG, BMP, PNG, or GIF image.','','',0,0,0,''); INSERT INTO styles VALUES ('box','A shortcut for drawing a rectangular box.','groupbox','',0,0,0,'GROUPBOX #handle.ext, "label", x, y, wide, high'); INSERT INTO styles VALUES ('backdrop','Scale an image over the entire layout window.','','',0,0,0,''); INSERT INTO styles VALUES ('backtile','Tile an image over the entire layout window.','','',0,0,0,''); INSERT INTO styles VALUES ('icon','Display a thumbnail sized image with text caption.','','',0,0,0,''); INSERT INTO styles VALUES ('led','An indicator light.','','',0,0,0,''); INSERT INTO styles VALUES ('anim','Display an animated image.','','',0,0,0,''); INSERT INTO styles VALUES ('button','A button that goes down on a click.','','',0,0,0,''); INSERT INTO styles VALUES ('toggle','Similar to BUTTON but has a dual state.','','',0,0,0,''); INSERT INTO styles VALUES ('rotary','Similar to BUTTON but allows multiple states.','','',0,0,0,''); INSERT INTO styles VALUES ('choice','A pop-up button that displays multiple choices.','','',0,0,0,''); INSERT INTO styles VALUES ('check','A check box.','checkbox','',0,0,0,'CHECKBOX #handle.ext, "label", setHandler, resetHandler, x, y, wide, high'); INSERT INTO styles VALUES ('radio','A rounded radio button.','radiobutton','',0,0,0,'RADIOBUTTON #handle.ext, "label", setHandler, resetHandler, x, y, wide, high'); INSERT INTO styles VALUES ('arrow','An arrow button with a beveled edge.','','',0,0,0,''); INSERT INTO styles VALUES ('progress','A sliding progress bar.','','',0,0,0,''); INSERT INTO styles VALUES ('slider','A slider bar.','','',0,0,0,''); INSERT INTO styles VALUES ('panel','A sub-layout.','','',0,0,0,''); INSERT INTO styles VALUES ('list','An iterated sub-layout.','','',0,0,0,''); INSERT INTO styles VALUES ('text-list','A simple form of the LIST style.','','',0,0,0,''); INSERT INTO styles VALUES ('key','Keyboard shortcut.','','',0,0,0,'');
|
|