jQuery Grid Plugin - jqGrid

Hi,

Have you the sql commands to create and populate the table "accounts" ?

This table is needed to run the treeview sample, but the sql is not in the zip jqGrid-3.5.beta-demo.

Thanks,

Thank cristib for your quick reply

It seems miss some columns like "level", "rgt" and "lft" to select sub-tree in the table. These columns are a bit tricky to calculate. Do you have the insert commands or could you point me where I can find them ?

Thanks cristib for your help

Finally to run the treeview demo I have added 3 columns in the create command  above

  `level` int(11) NOT NULL,
  `lft` int(11) NOT NULL,
  `rgt` int(11) NOT NULL, 

and inserted the following data test:

INSERT INTO accounts VALUES(1,NULL,'A1'   ,100001,11,12,13,0,1,14);
INSERT INTO accounts VALUES(2,1,   'A11'  ,100011,111,112,113,1,2,3);
INSERT INTO accounts VALUES(3,1,   'A12'  ,100012,121,122,123,1,4,11);
INSERT INTO accounts VALUES(4,1,   'A13'  ,100013,131,132,133,1,12,13);
INSERT INTO accounts VALUES(5,3,   'A121' ,100121,1211,1212,1213,2,5,8);
INSERT INTO accounts VALUES(6,3,   'A122' ,100122,1221,1222,1223,2,9,10);
INSERT INTO accounts VALUES(7,5,   'A1211',101211,12111,12112,12113,3,6,7);