-----------------------java -cp hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb

-----------java -cp hsqldb.jar org.hsqldb.util.DatabaseManager

CREATE TABLE ControlType(CONTROL_CODE varchar(30),CONTROL_DESCRIPTION varchar(30));

INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Text Box','Text Box');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Drop Down','Drop Down');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Radio Button','Radio Button');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Check Box','Check Box');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Text Area','Text Area');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Password Field','Password Field');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('File Browser','File Browser');
INSERT INTO ControlType(CONTROL_CODE,CONTROL_DESCRIPTION)values('Button','Button');
*********************************************************************************************


CREATE TABLE LabelType(LABEL_CODE varchar(30),LABEL_DESCRIPTION varchar(30));

INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('First Name','First Name');



INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Last Name','Last Name');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('User Id','User Id');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Password','Password');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Age','Age');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Sex','Sex');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Address','Address');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('City','City');



INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('State','State');

INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Country','Country');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Landline','Landline');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Login','Login');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Submit','Submit');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Reset','Reset');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Save','Save');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Delete','Delete');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Remove','Remove');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Search','Search');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Enter','Enter');


INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('Email Id','Email Id');

INSERT INTO LabelType(LABEL_CODE ,LABEL_DESCRIPTION)values('ZipCode','ZipCode');