-- テーブル初期化スクリプト
--
-- データクリア
DELETE FROM NYUKINTABLE;
DELETE FROM ZANDAKATABLE;
DELETE FROM UNYOHIDUKETABLE;
DELETE FROM ZANDAKARIREKITABLE;

-- データ初期化
-- 入金テーブル
INSERT INTO NYUKINTABLE VALUES(1,'東京','001',77500,'2007-01-01')
INSERT INTO NYUKINTABLE VALUES(2,'大阪','002',56200,'2007-01-02')
INSERT INTO NYUKINTABLE VALUES(3,'福岡','003',17900,'2007-01-03')
INSERT INTO NYUKINTABLE VALUES(4,'東京','004',27000,'2007-01-04')
INSERT INTO NYUKINTABLE VALUES(5,'大阪','005',71000,'2007-01-05')
INSERT INTO NYUKINTABLE VALUES(6,'福岡','006',13100,'2007-01-06')
INSERT INTO NYUKINTABLE VALUES(7,'東京','007',680,'2007-01-07')
INSERT INTO NYUKINTABLE VALUES(8,'大阪','008',7600,'2007-01-08')
INSERT INTO NYUKINTABLE VALUES(9,'福岡','009',61600,'2007-01-09')
INSERT INTO NYUKINTABLE VALUES(10,'東京','010',28400,'2007-01-10')
INSERT INTO NYUKINTABLE VALUES(11,'大阪','011',32700,'2007-01-11')
INSERT INTO NYUKINTABLE VALUES(12,'福岡','012',46500,'2007-01-12')
INSERT INTO NYUKINTABLE VALUES(13,'東京','013',10200,'2007-01-13')
INSERT INTO NYUKINTABLE VALUES(14,'大阪','014',43000,'2007-01-14')
INSERT INTO NYUKINTABLE VALUES(15,'福岡','015',48200,'2007-01-15')
INSERT INTO NYUKINTABLE VALUES(16,'東京','016',83700,'2007-01-16')
INSERT INTO NYUKINTABLE VALUES(17,'大阪','017',92400,'2007-01-17')
INSERT INTO NYUKINTABLE VALUES(18,'福岡','018',17800,'2007-01-18')
INSERT INTO NYUKINTABLE VALUES(19,'東京','019',91400,'2007-01-19')
INSERT INTO NYUKINTABLE VALUES(20,'大阪','020',70300,'2007-01-20')
INSERT INTO NYUKINTABLE VALUES(21,'福岡','021',37900,'2007-01-21')
INSERT INTO NYUKINTABLE VALUES(22,'東京','022',3700,'2007-01-22')
INSERT INTO NYUKINTABLE VALUES(23,'大阪','023',1900,'2007-01-23')
INSERT INTO NYUKINTABLE VALUES(24,'福岡','024',91700,'2007-01-24')
INSERT INTO NYUKINTABLE VALUES(25,'東京','025',6800,'2007-01-25')
INSERT INTO NYUKINTABLE VALUES(26,'大阪','026',96600,'2007-01-26')
INSERT INTO NYUKINTABLE VALUES(27,'福岡','027',55900,'2007-01-27')
INSERT INTO NYUKINTABLE VALUES(28,'東京','028',65800,'2007-01-28')
INSERT INTO NYUKINTABLE VALUES(29,'大阪','029',74400,'2007-01-29')
INSERT INTO NYUKINTABLE VALUES(30,'福岡','030',76400,'2007-01-30')
INSERT INTO NYUKINTABLE VALUES(31,'東京','031',90400,'2007-01-31')
INSERT INTO NYUKINTABLE VALUES(32,'大阪','032',4300,'2007-01-01')
INSERT INTO NYUKINTABLE VALUES(33,'福岡','033',16100,'2007-01-02')
INSERT INTO NYUKINTABLE VALUES(34,'東京','034',63700,'2007-02-01')
INSERT INTO NYUKINTABLE VALUES(35,'大阪','035',64000,'2007-01-04')
INSERT INTO NYUKINTABLE VALUES(36,'福岡','036',83600,'2007-01-05')
INSERT INTO NYUKINTABLE VALUES(37,'東京','037',19900,'2007-01-06')
INSERT INTO NYUKINTABLE VALUES(38,'大阪','038',84900,'2007-01-07')
INSERT INTO NYUKINTABLE VALUES(39,'福岡','039',3400,'2007-01-08')
INSERT INTO NYUKINTABLE VALUES(40,'東京','040',16100,'2007-01-09')
INSERT INTO NYUKINTABLE VALUES(41,'大阪','041',97400,'2007-01-10')
INSERT INTO NYUKINTABLE VALUES(42,'福岡','042',1800,'2007-01-11')
INSERT INTO NYUKINTABLE VALUES(43,'東京','043',1500,'2007-01-12')
INSERT INTO NYUKINTABLE VALUES(44,'大阪','044',94100,'2007-01-13')
INSERT INTO NYUKINTABLE VALUES(45,'福岡','045',62500,'2007-01-14')
INSERT INTO NYUKINTABLE VALUES(46,'東京','046',4100,'2007-01-15')
INSERT INTO NYUKINTABLE VALUES(47,'大阪','047',46200,'2007-01-16')
INSERT INTO NYUKINTABLE VALUES(48,'福岡','048',51900,'2007-01-17')
INSERT INTO NYUKINTABLE VALUES(49,'東京','049',7800,'2007-01-18')
INSERT INTO NYUKINTABLE VALUES(50,'大阪','050',41200,'2007-01-19')

-- 残高テーブル
INSERT INTO ZANDAKATABLE VALUES('001',100000,'2006-01-01')
INSERT INTO ZANDAKATABLE VALUES('002',100000,'2006-01-02')
INSERT INTO ZANDAKATABLE VALUES('005',100000,'2006-01-03')
INSERT INTO ZANDAKATABLE VALUES('006',100000,'2006-01-04')
INSERT INTO ZANDAKATABLE VALUES('009',100000,'2006-01-05')
INSERT INTO ZANDAKATABLE VALUES('011',100000,'2006-01-06')
INSERT INTO ZANDAKATABLE VALUES('012',100000,'2006-01-07')
INSERT INTO ZANDAKATABLE VALUES('014',100000,'2006-01-08')
INSERT INTO ZANDAKATABLE VALUES('016',100000,'2006-01-09')
INSERT INTO ZANDAKATABLE VALUES('017',100000,'2006-01-10')
INSERT INTO ZANDAKATABLE VALUES('019',100000,'2006-01-11')
INSERT INTO ZANDAKATABLE VALUES('020',100000,'2006-01-12')
INSERT INTO ZANDAKATABLE VALUES('022',100000,'2006-01-13')
INSERT INTO ZANDAKATABLE VALUES('023',100000,'2006-01-14')
INSERT INTO ZANDAKATABLE VALUES('025',100000,'2006-01-15')
INSERT INTO ZANDAKATABLE VALUES('027',100000,'2006-01-16')
INSERT INTO ZANDAKATABLE VALUES('028',100000,'2006-01-17')
INSERT INTO ZANDAKATABLE VALUES('031',100000,'2006-01-18')
INSERT INTO ZANDAKATABLE VALUES('032',100000,'2006-01-19')
INSERT INTO ZANDAKATABLE VALUES('035',100000,'2006-01-20')
INSERT INTO ZANDAKATABLE VALUES('037',100000,'2006-01-21')
INSERT INTO ZANDAKATABLE VALUES('039',100000,'2006-01-22')
INSERT INTO ZANDAKATABLE VALUES('040',100000,'2006-01-23')
INSERT INTO ZANDAKATABLE VALUES('042',100000,'2006-01-24')
INSERT INTO ZANDAKATABLE VALUES('043',100000,'2006-01-25')
INSERT INTO ZANDAKATABLE VALUES('044',100000,'2006-01-26')
INSERT INTO ZANDAKATABLE VALUES('045',100000,'2006-01-27')
INSERT INTO ZANDAKATABLE VALUES('047',100000,'2006-01-28')
INSERT INTO ZANDAKATABLE VALUES('048',100000,'2006-01-29')
INSERT INTO ZANDAKATABLE VALUES('049',100000,'2006-01-30')

-- 運用日付テーブル
INSERT INTO UNYOHIDUKETABLE VALUES('2007-02-01')