-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.53-community


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema starrlidb
--

CREATE DATABASE IF NOT EXISTS starrlidb;
USE starrlidb;

--
-- Definition of table `printerprev`
--

DROP TABLE IF EXISTS `printerprev`;
CREATE TABLE `printerprev` (
  `id` int(10) unsigned NOT NULL,
  `pagename` varchar(45) NOT NULL,
  `linename` varchar(45) NOT NULL,
  `content` varchar(100) DEFAULT NULL,
  `fontname` varchar(45) DEFAULT NULL,
  `fontstyle` varchar(2) DEFAULT NULL,
  `fontsize` varchar(3) DEFAULT NULL,
  `isenable` tinyint(1) unsigned DEFAULT NULL,
  `iscenter` tinyint(1) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `printerprev`
--

/*!40000 ALTER TABLE `printerprev` DISABLE KEYS */;
INSERT INTO `printerprev` (`id`,`pagename`,`linename`,`content`,`fontname`,`fontstyle`,`fontsize`,`isenable`,`iscenter`) VALUES 
 (0,'package','paid','Paid','GulimChe','1','18',1,1),
 (1,'package','resname','','Tw Cen MT','1','12',1,1),
 (2,'package','resname2','','GulimChe','0','10',1,1),
 (3,'package','AddressAndTelInfo','','GulimChe','0','10',1,1),
 (4,'package','faxinfo','','GulimChe','0','10',1,1),
 (5,'package','email','','GulimChe','0','10',0,1),
 (6,'package','blankline1','','GulimChe','0','10',1,1),
 (7,'package','printtime','','GulimChe','0','10',1,1),
 (8,'package','ordertype','外送   #8','Microsoft Sans Serif','1','18',1,1),
 (9,'package','line1','-----------------------------------','GulimChe','0','10',1,1),
 (10,'package','DeliverAddress','86-31 62nd Avenue','GulimChe','0','14',1,0),
 (11,'package','CityZip','Rego Park, 11374','GulimChe','0','10',1,0),
 (12,'package','CustName','Customer:Customer Name','GulimChe','0','10',1,0),
 (13,'package','phone','2123740111','GulimChe','0','12',1,0),
 (14,'package','printnote','Back Door','GulimChe','0','10',1,0),
 (15,'package','line2','-----------------------------------','GulimChe','0','10',1,1),
 (16,'package','waiter','Waiter: Waiter Name','GulimChe','0','10',1,0),
 (17,'package','table','Table: T08','Tw Cen MT','0','13',1,0),
 (18,'package','person','Number of Person(s):3','GulimChe','0','10',1,0),
 (19,'package','buffet','Time Left: 60 minute(s)','GulimChe','0','10',1,0),
 (20,'package','line3','-----------------------------------','GulimChe','0','10',1,1),
 (21,'package','voidedcn','---- Voided 取消 ----','GulimChe','0','10',1,1),
 (22,'package','voideden','---- Voided ----','GulimChe','1','10',1,1),
 (23,'package','dishcn1','中文菜名1','GulimChe','0','16',1,0),
 (24,'package','specialcn1','跟 白饭','GulimChe','0','14',1,0),
 (25,'package','dishen1','English dish name1','GulimChe','0','14',1,0),
 (26,'package','specialen1','With White Rice','GulimChe','0','14',1,0),
 (27,'package','reprintcn','--- Reprinting 重打 ---','GulimChe','0','10',1,1),
 (28,'package','reprinten','------ Reprinting ------','GulimChe','0','10',1,1),
 (29,'package','dishcn2','中文菜名2','GulimChe','0','10',1,0),
 (30,'package','specialcn2','加 白饭','GulimChe','0','10',1,0),
 (31,'package','dishen2','English dish name2','GulimChe','0','10',1,0),
 (32,'package','specialen2','Add White Rice','GulimChe','0','10',1,0),
 (33,'package','line4','-----------------------------------','GulimChe','0','10',1,1),
 (34,'package','PrintTotalNo','Total #','GulimChe','0','10',1,0),
 (35,'package','SubTotal','Sub Total','GulimChe','0','10',1,0),
 (36,'package','dCharge','Delivery Charge','GulimChe','0','10',1,0),
 (37,'package','GSTTAX','GST TAX','GulimChe','0','10',1,0),
 (38,'package','PSTTAX','PST TAX','GulimChe','0','10',1,0),
 (39,'package','TAX','TAX','GulimChe','0','10',1,0),
 (40,'package','Discount','Discount','GulimChe','0','10',1,0),
 (41,'package','Tip','Tip','GulimChe','0','10',1,0),
 (42,'package','Total','Total','Tw Cen MT','1','13',1,0),
 (43,'package','line5','-----------------------------------','GulimChe','0','10',1,1),
 (44,'package','message1','Gratuity Include For Parties','GulimChe','0','10',1,1),
 (45,'package','message2','of 5 or More,auto-gratuity added','GulimChe','0','10',1,1),
 (46,'package','message3','','GulimChe','0','10',1,1),
 (47,'package','linecut','. . . . . . . .','GulimChe','0','10',1,1),
 (48,'common','PackagePrintLanguage','2','GulimChe','0','10',0,0),
 (49,'common','PrintVoidInformationToPackage','1','GulimChe','0','10',0,0),
 (50,'common','PrintTagForReprint','1','GulimChe','0','10',0,0),
 (51,'common','PrintTotalNo','0','GulimChe','0','10',0,0),
 (52,'common','XAfterNumber','1','GulimChe','0','10',0,0),
 (53,'common','ShowPaidInPackager','1','GulimChe','0','10',0,0),
 (54,'common','TodaysIDinPackage','1','GulimChe','0','10',1,0),
 (55,'common','DineInTypeOrderNo','1','GulimChe','0','10',1,0),
 (56,'common','DeliveryCostPrint','1','GulimChe','0','10',1,0),
 (57,'common','PackageNoDetailFee','0','GulimChe','0','10',1,0),
 (58,'common','PrintCustomerForTogoWait','1','GulimChe','0','10',1,0),
 (59,'common','PrintTelAddrInPack','1','GulimChe','0','10',1,0),
 (60,'common','printnote','1','GulimChe','0','10',1,0),
 (70,'kitchen','printtime','','GulimChe','0','10',1,1),
 (71,'kitchen','ordertype','外送   #8','Microsoft Sans Serif','1','18',1,1),
 (72,'kitchen','line1','-----------------------------------','GulimChe','0','10',1,1),
 (73,'kitchen','waiter','Waiter: Waiter Name','GulimChe','0','10',1,0),
 (74,'kitchen','table','Table: T08','Tw Cen MT','0','13',1,0),
 (75,'kitchen','person','Number of Person(s):3','GulimChe','0','10',1,0),
 (76,'kitchen','buffet','Time Left: 60 minute(s)','GulimChe','0','10',0,0),
 (77,'kitchen','line2','-----------------------------------','GulimChe','0','10',1,1),
 (80,'kitchen','DeliverAddress','86-31 62nd Avenue','GulimChe','0','14',1,0),
 (81,'kitchen','CityZip','Rego Park, 11374','GulimChe','0','10',1,0),
 (82,'kitchen','CustName','Customer:Customer Name','GulimChe','0','10',1,0),
 (83,'kitchen','phone','2123740111','GulimChe','0','12',1,0),
 (84,'kitchen','printnote','Back Door','GulimChe','0','10',0,0),
 (85,'kitchen','line3','-----------------------------------','GulimChe','0','10',1,1),
 (91,'kitchen','voidedcn','---- Voided 取消 ----','GulimChe','0','10',1,1),
 (92,'kitchen','voideden','---- Voided ----','GulimChe','1','10',1,1),
 (93,'kitchen','dishcn1','中文菜名1','GulimChe','0','16',1,0),
 (94,'kitchen','specialcn1','跟 白饭','GulimChe','0','14',1,0),
 (95,'kitchen','dishen1','English dish name1','GulimChe','0','10',1,0),
 (96,'kitchen','specialen1','With White Rice','GulimChe','0','10',1,0),
 (97,'kitchen','reprintcn','--- Reprinting 重打 ---','GulimChe','0','10',1,1),
 (98,'kitchen','reprinten','------ Reprinting ------','GulimChe','0','10',1,1),
 (99,'kitchen','dishcn2','中文菜名2','GulimChe','0','10',1,0),
 (100,'kitchen','specialcn2','加 白饭','GulimChe','0','10',1,0),
 (101,'kitchen','dishen2','English dish name2','GulimChe','0','10',1,0),
 (102,'kitchen','specialen2','Add White Rice','GulimChe','0','10',1,0),
 (103,'kitchen','line4','-----------------------------------','GulimChe','0','10',0,1),
 (116,'kitchen','message3','','GulimChe','0','10',1,1),
 (117,'kitchen','linecut','. . . . . . . .','GulimChe','0','10',1,1),
 (118,'common','kitchenPrintLang','1','GulimChe','0','10',0,0),
 (119,'common','PrintCustomerInformationToKitchen','0','GulimChe','0','10',0,0),
 (121,'common','DineInkitchenNumberOfPeople','0','GulimChe','0','10',0,0),
 (124,'common','TodaysIDinKitchen','1','GulimChe','0','10',1,0),
 (126,'common','KitchenPrice','0','GulimChe','0','10',1,0),
 (127,'common',' PrintVoidInformationToKitchen','1','GulimChe','0','10',1,0),
 (141,'check','resname','','Tw Cen MT','1','12',1,1),
 (142,'check','resname2','','GulimChe','0','10',1,1),
 (143,'check','AddressAndTelInfo','','GulimChe','0','10',1,1),
 (144,'check','faxinfo','','GulimChe','0','10',1,1),
 (145,'check','email','','GulimChe','0','10',0,1),
 (146,'check','blankline1','','GulimChe','0','10',1,1),
 (147,'check','printtime','','GulimChe','0','10',1,1),
 (148,'check','ordertype','外送   #8','Microsoft Sans Serif','1','18',1,1),
 (149,'check','line1','-----------------------------------','GulimChe','0','10',1,1),
 (150,'check','DeliverAddress','86-31 62nd Avenue','GulimChe','0','10',1,0),
 (151,'check','CityZip','Rego Park, 11374','GulimChe','0','10',1,0),
 (152,'check','CustName','Customer:Customer Name','GulimChe','0','10',1,0),
 (153,'check','phone','2123740111','GulimChe','0','10',1,0),
 (154,'check','printnote','Back Door','GulimChe','0','10',1,0),
 (155,'check','line2','-----------------------------------','GulimChe','0','10',1,1),
 (156,'check','waiter','Waiter: Waiter Name','GulimChe','0','10',1,0),
 (157,'check','table','Table: T08','Tw Cen MT','0','13',1,0),
 (158,'check','person','Number of Person(s):3','GulimChe','0','10',1,0),
 (159,'check','buffet','Time Left: 60 minute(s)','GulimChe','0','10',1,0),
 (160,'check','line3','-----------------------------------','GulimChe','0','10',1,1),
 (161,'check','dishcn1','中文菜名1','GulimChe','0','10',1,0),
 (162,'check','specialcn1','跟 白饭','GulimChe','0','10',1,0),
 (163,'check','dishen1','English dish name1','GulimChe','0','10',1,0),
 (164,'check','specialen1','With White Rice','GulimChe','0','10',1,0),
 (165,'check','dishcn2','中文菜名2','GulimChe','0','10',1,0),
 (170,'check','specialcn2','加 白饭','GulimChe','0','10',1,0),
 (171,'check','dishen2','English dish name2','GulimChe','0','10',1,0),
 (172,'check','specialen2','Add White Rice','GulimChe','0','10',1,0),
 (173,'check','line4','-----------------------------------','GulimChe','0','10',1,1),
 (174,'check','PrintTotalNo','Total #','GulimChe','0','10',1,0),
 (175,'check','SubTotal','Sub Total','GulimChe','0','10',1,0),
 (176,'check','dCharge','Delivery Charge','GulimChe','0','10',1,0),
 (177,'check','GSTTAX','GST TAX','GulimChe','0','10',1,0),
 (178,'check','PSTTAX','PST TAX','GulimChe','0','10',1,0),
 (179,'check','TAX','TAX','GulimChe','0','10',1,0),
 (180,'check','Discount','Discount','GulimChe','0','10',1,0),
 (181,'check','Tip','Tip','GulimChe','0','10',1,0),
 (182,'check','Total','Total','Tw Cen MT','1','13',1,0),
 (183,'check','Payment','Payment','GulimChe','0','10',1,0),
 (184,'check','Change','Change','GulimChe','0','10',1,0),
 (185,'check','Paidby','Paid by','GulimChe','0','10',1,0),
 (186,'check','Unpaid','Unpaid Balance','GulimChe','0','10',1,0),
 (187,'check','line5','-----------------------------------','GulimChe','0','10',1,1),
 (188,'check','message1','Gratuity Include For Parties','GulimChe','0','10',1,1),
 (195,'check','message2','of 5 or More,auto-gratuity added','GulimChe','0','10',1,1),
 (196,'check','message4','Tip Guide:','GulimChe','0','10',1,0),
 (197,'check','message5','  15%=5.42;  18%=6.50;  20%=7.23','GulimChe','0','10',1,0),
 (198,'check','blankline','','GulimChe','0','10',1,1),
 (199,'check','message6','Signature: _________________','GulimChe','0','10',1,1),
 (200,'check','blankline','','GulimChe','0','10',1,1),
 (201,'check','message3','','GulimChe','0','10',1,1),
 (202,'check','linecut','. . . . . . . .','GulimChe','0','10',1,1),
 (203,'common','PrintCheckLanguage','2','GulimChe','0','10',0,0),
 (204,'common','CheckNotPrtRestNameAddr','1','GulimChe','0','10',0,0),
 (205,'common','PrintTipsInCheck','1','GulimChe','0','10',0,0),
 (206,'common','TodaysIDincheck','1','GulimChe','0','10',1,0),
 (241,'credit','resname','','Tw Cen MT','1','12',1,1),
 (242,'credit','resname2','','GulimChe','0','10',1,1),
 (243,'credit','AddressAndTelInfo','','GulimChe','0','10',1,1),
 (244,'credit','faxinfo','','GulimChe','0','10',1,1),
 (245,'credit','email','','GulimChe','0','10',0,1),
 (246,'credit','blankline1','','GulimChe','0','10',1,1),
 (247,'credit','printtime','','GulimChe','0','10',1,1),
 (248,'credit','ordertype','外送   #8','Microsoft Sans Serif','1','18',1,1),
 (249,'credit','line1','-----------------------------------','GulimChe','0','10',1,1),
 (256,'credit','waiter','Waiter: Waiter Name','GulimChe','0','10',1,0),
 (262,'credit','authcode','Auth Code:OK1234','GulimChe','0','10',1,0),
 (263,'credit','account','Account:XXXXXXXXXXXX9876','GulimChe','0','10',1,0),
 (264,'credit','exp','EXP:1219      VISA','GulimChe','0','10',1,0),
 (265,'credit','blankline','','GulimChe','0','10',1,1),
 (266,'credit','amount','Amount:','GulimChe','1','14',1,0),
 (267,'credit','blankline','','GulimChe','0','10',1,1),
 (268,'credit','creditTip','Tip:','GulimChe','0','10',1,0),
 (269,'credit','blankline','','GulimChe','0','10',1,1),
 (270,'credit','creditTotal','Total:','GulimChe','0','10',1,0),
 (271,'credit','blankline','','GulimChe','0','10',1,1),
 (287,'credit','line5','-----------------------------------','GulimChe','0','10',1,1),
 (296,'credit','message4','Tip Guide:','GulimChe','0','10',1,0),
 (297,'credit','message5','  15%=5.42;  18%=6.50;  20%=7.23','GulimChe','0','10',1,0),
 (298,'credit','blankline','','GulimChe','0','10',1,1),
 (299,'credit','message6','Signature: _________________','GulimChe','0','10',1,1),
 (300,'credit','blankline','','GulimChe','0','10',1,1),
 (301,'credit','message3','','GulimChe','0','10',1,1),
 (302,'credit','linecut','. . . . . . . .','GulimChe','0','10',1,1);
/*!40000 ALTER TABLE `printerprev` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
