sudheerj / primefaces-blueprints Goto Github PK

please from the file
https://github.com/sudheerj/primefaces-blueprints/blob/master/chapter05/src/main/webapp/query/mysqlquery.txt

after line 152 is missing part of creation of table servicecenter.
From line 153 to line155 is missing statment for creation of table.
the line 156 init with ; city VARCHAR(20),
the line 156 : contactnumber VARCHAR(30) NOT NULL,
the line 157 postalcode VARCHAR(10),
the line 158 PRIMARY KEY (id))ENGINE=InnoDB DEFAULT CHARSET=utf8;
into line 160: init the insert data into the table servicecenter
into line 169 : ende insert into the table servicecenter

So please you can make a update to this file please?
tank you-
or a complete dump of the complete DB