DROP TABLE IF EXISTS `StandSetting`;
CREATE TABLE `StandSetting` (
OpenTime datetime DEFAULT NULL,
CloseTime datetime DEFAULT NULL,
TaxRate int(11) DEFAULT NULL,
Fraction int(11) DEFAULT NULL,
ShopName varchar(40) DEFAULT NULL,
ShopAddress varchar(40) DEFAULT NULL,
ShopTel varchar(15) DEFAULT NULL,
BasicTime int(11) DEFAULT NULL,
ExtensionTime int(11) DEFAULT NULL,
In_Delay int(11) DEFAULT NULL,
GoOut_Delay int(11) DEFAULT NULL,
CustKigen int(11) DEFAULT NULL,
CustNyuukai int(11) DEFAULT NULL,
CustKousin int(11) DEFAULT NULL,
CustSaihakkou int(11) DEFAULT NULL,
Syubetu1 varchar(10) DEFAULT NULL,
Syubetu2 varchar(10) DEFAULT NULL,
Syubetu3 varchar(10) DEFAULT NULL,
Syubetu4 varchar(10) DEFAULT NULL,
Syubetu5 varchar(10) DEFAULT NULL,
Syubetu6 varchar(10) DEFAULT NULL,
Syubetu7 varchar(10) DEFAULT NULL,
Syubetu8 varchar(10) DEFAULT NULL,
Syubetu9 varchar(10) DEFAULT NULL,
Syubetu10 varchar(10) DEFAULT NULL,
Syubetu11 varchar(10) DEFAULT NULL,
Syubetu12 varchar(10) DEFAULT NULL,
Syubetu13 varchar(10) DEFAULT NULL,
Syubetu14 varchar(10) DEFAULT NULL,
Syubetu15 varchar(10) DEFAULT NULL,
Person1 varchar(10) DEFAULT NULL,
Person2 varchar(10) DEFAULT NULL,
Person3 varchar(10) DEFAULT NULL,
Person4 varchar(10) DEFAULT NULL,
Sunday int(11) DEFAULT NULL,
Monday int(11) DEFAULT NULL,
Tuesday int(11) DEFAULT NULL,
Wednesday int(11) DEFAULT NULL,
Thursday int(11) DEFAULT NULL,
Friday int(11) DEFAULT NULL,
Saturday int(11) DEFAULT NULL,
Holiday int(11) DEFAULT NULL,
BrforeHoliday int(11) DEFAULT NULL,
Special1 int(11) DEFAULT NULL,
Special2 int(11) DEFAULT NULL,
Special3 int(11) DEFAULT NULL,
Special4 int(11) DEFAULT NULL,
Special5 int(11) DEFAULT NULL,
FocusForeColor int(11) DEFAULT NULL,
FocusBackColor int(11) DEFAULT NULL,
OrderButtonCols int(11) DEFAULT NULL,
OrderButtonRows int(11) DEFAULT NULL,
OrderSectionRows int(11) DEFAULT NULL,
SelectRoomCols int(11) DEFAULT NULL,
SelectRoomRows int(11) DEFAULT NULL,
ComString varchar(30) DEFAULT NULL,
AgeDisp varchar(50) DEFAULT NULL,
CheckInOrder tinyint(4) DEFAULT NULL,
CheckInTimeChange tinyint(4) DEFAULT NULL,
FirstOrder tinyint(4) DEFAULT NULL,
Person5 varchar(10) DEFAULT NULL,
Person6 varchar(10) DEFAULT NULL,
Person7 varchar(10) DEFAULT NULL,
Person8 varchar(10) DEFAULT NULL,
Person9 varchar(10) DEFAULT NULL,
Person10 varchar(10) DEFAULT NULL,
GroupCode varchar(8) DEFAULT NULL,
ShopID int(11) DEFAULT NULL,
Comment0 varchar(20) DEFAULT NULL,
Comment1 varchar(20) DEFAULT NULL,
Comment2 varchar(20) DEFAULT NULL,
BitFlag varchar(4) DEFAULT NULL,
RewriteBitFlag varchar(4) DEFAULT NULL,
ResultSumTime varchar(256) DEFAULT NULL,) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


INSERT INTO `StandSetting` (`OpenTime`,`CloseTime`,`TaxRate`,`Fraction`,`ShopName`,`ShopAddress`,`ShopTel`,`BasicTime`,`ExtensionTime`,`In_Delay`,`GoOut_Delay`,`CustKigen`,`CustNyuukai`,`CustKousin`,`CustSaihakkou`,`Syubetu1`,`Syubetu2`,`Syubetu3`,`Syubetu4`,`Syubetu5`,`Syubetu6`,`Syubetu7`,`Syubetu8`,`Syubetu9`,`Syubetu10`,`Syubetu11`,`Syubetu12`,`Syubetu13`,`Syubetu14`,`Syubetu15`,`Person1`,`Person2`,`Person3`,`Person4`,`Sunday`,`Monday`,`Tuesday`,`Wednesday`,`Thursday`,`Friday`,`Saturday`,`Holiday`,`BrforeHoliday`,`Special1`,`Special2`,`Special3`,`Special4`,`Special5`,`FocusForeColor`,`FocusBackColor`,`OrderButtonCols`,`OrderButtonRows`,`OrderSectionRows`,`SelectRoomCols`,`SelectRoomRows`,`ComString`,`AgeDisp`,`CheckInOrder`,`CheckInTimeChange`,`FirstOrder`,`Person5`,`Person6`,`Person7`,`Person8`,`Person9`,`Person10`,`GroupCode`,`ShopID`,`Comment0`,`Comment1`,`Comment2`,`BitFlag`,`RewriteBitFlag`,`ResultSumTime`,``) VALUES 
('1900-01-01 16:00:00','1900-01-01 15:00:00',10,0,'カラオケチカラ　豊田駅前店','愛知県豊田市西町6-7-1　ｷｭｰﾌﾞ豊田ﾋﾞﾙ4F','0565-63-5541',60,30,10,15,0,0,0,0,'一般','子供','学生','Ｄ','特割','昼　お一人','','','','','','','','','','','','','',1,1,1,1,1,2,2,1,2,2,3,4,5,6,0,0,2,3,0,5,4,'KtMIRcSpTQ4=','16',18,20,0,'1','0','','','','','',0,'','0','','','','000000000000021430000');