DIR : /home/kozerus/public_html/ko_center/js/jqgrid_demo35/grid1.sql

/home/kozerus/public_html/ko_center/js/jqgrid_demo35

-- grid.sql:	jqgrid demo table
--
-- s|CREATE TABLE|CREATE TABLE IF NOT EXISTS|g
-- s|autoincrement|AUTOINCREMENT|g

CREATE TABLE IF NOT EXISTS  `clients` (
  `client_id` int(11) NOT NULL ,
  `name` char(120) default NULL,
  PRIMARY KEY  (`client_id`)
) ;


-- insert  into `clients` (`client_id`,`name`) values (1,'Client 1'),(2,'Client 2'),(3,'Client 3');
-- (`client_id`, `name`) values 
insert  into `clients` (`client_id`, `name`) values (1,'Client 1');
insert  into `clients` (`client_id`, `name`) values (2,'Client 2');
insert  into `clients` (`client_id`, `name`) values (3,'Client 3');