DIR : /home/kozerus/public_html/ko_center/js/jqgrid_demo35/grid.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||g

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


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


CREATE TABLE IF NOT EXISTS  `invheader` (
  `id` int(11) NOT NULL ,
  `invdate` date NOT NULL,
  `client_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL default '0.00',
  `tax` decimal(10,2) NOT NULL default '0.00',
  `total` decimal(10,2) NOT NULL default '0.00',
  `note` char(100) default NULL,
  PRIMARY KEY  (`id`)
) ;

insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (1,'2007-10-01',1,'100.00','20.00','120.00','note 1');
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (2,'2007-10-03',1,'200.00','40.00','240.00','note 2');
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (3,'2007-10-02',2,'300.00','60.00','360.00','note for invoice 3');
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (4,'2007-10-04',3,'150.00','0.00','150.00','no tax');
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (5,'2007-10-05',3,'100.00','0.00','100.00','no tax');
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (6,'2007-10-05',1,'50.00','10.00','60.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (7,'2007-10-05',2,'120.00','12.00','134.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (8,'2007-10-06',3,'200.00','0.00','200.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (9,'2007-10-06',1,'200.00','40.00','240.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (10,'2007-10-06',2,'100.00','20.00','120.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (11,'2007-10-06',1,'600.00','120.00','720.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (12,'2007-10-06',2,'700.00','140.00','840.00',NULL);
insert or replace  into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (13,'2007-10-06',3,'1000.00','0.00','1000.00',NULL);

CREATE TABLE IF NOT EXISTS  `invlines` (
  `id` int(11) NOT NULL,
  `num` int(11) NOT NULL ,
  `item` char(20) default NULL,
  `qty` decimal(8,2) NOT NULL default '0.00',
  `unit` decimal(10,2) NOT NULL,
  PRIMARY KEY  (`id`,`num`)
	);
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (1,1,'item 1','1.00','20.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (1,2,'item 2','2.00','40.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (2,1,'item 1','2.00','20.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (2,2,'item 2','4.00','40.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (3,1,'item 3','1.00','100.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (3,2,'item 4','1.00','200.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (4,1,'item 1','1.00','100.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (4,2,'item 2','1.00','50.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (5,1,'item 3','1.00','100.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (6,1,'item 4','1.00','50.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (7,1,'item 5','2.00','10.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (7,2,'item 1','1.00','100.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (8,1,'item 3','1.00','50.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (8,2,'item 2','1.00','120.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (8,3,'item 3','1.00','30.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (9,1,'item 6','1.00','140.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (9,2,'item 3','1.00','60.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (10,1,'item 5','3.00','10.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (10,2,'item 4','1.00','70.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (11,1,'item 1','2.00','100.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (11,2,'item 2','3.00','50.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (11,3,'item 3','1.00','50.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (11,4,'item 4','1.00','200.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (12,1,'item 4','1.00','300.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (12,2,'item 2','1.00','400.00');
insert or replace  into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (13,1,'item 13','1.00','1000.00');


CREATE TABLE IF NOT EXISTS items (
	item_id INT UNSIGNED not null,
	item VARCHAR (200),
	item_cd VARCHAR (15),
	PRIMARY KEY ( item_id )
	);

alter table `invheader` add column `closed` char (3) DEFAULT 'No' NULL;
alter table `invheader` add column `ship_via` char (3)  NULL ;