-- === DIALECT: postgresql | SCHEMA: default ===

-- === TABLES ===


CREATE TABLE deposit (
	dividendsdepositid VARCHAR(18) NOT NULL,
	dealernumber VARCHAR(1300) NOT NULL,
	performdeposittype VARCHAR(19),
	deposittype VARCHAR(21),
	depositamount NUMERIC(19, 2) DEFAULT 0.0,
	performanceymckey VARCHAR(200),
	performanceymc NUMERIC(7, 0) DEFAULT 0.0,
	currentbalance INTEGER DEFAULT 0 NOT NULL,
	depositdate DATE,
	expirationdate DATE,
	dealerexpirationymckey VARCHAR(200),
	expirationmonth NUMERIC(7, 0) DEFAULT 0.0,
	notes VARCHAR(255),
	recordinserttimestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL,
	CONSTRAINT pk_deposit PRIMARY KEY (dividendsdepositid)
);


CREATE TABLE dividendpayout (
	id SERIAL NOT NULL,
	earningslevel VARCHAR(20) NOT NULL,
	a1payout NUMERIC(19, 2) NOT NULL,
	a2b3payout NUMERIC(19, 2) NOT NULL,
	recordinserttimestamp DATE NOT NULL,
	CONSTRAINT pk_dividendpayout PRIMARY KEY (id)
);


CREATE TABLE incentivebenchmark (
	dealerid VARCHAR(8),
	dealername VARCHAR(50),
	protectedppnew INTEGER DEFAULT 0,
	yearmonthcode NUMERIC(7, 0) DEFAULT 0.0,
	earningstatus VARCHAR(15),
	ddpopearningflag INTEGER DEFAULT 0,
	popearningstatus VARCHAR(11),
	benchmark INTEGER DEFAULT 0,
	protectedppusedbm INTEGER DEFAULT 0,
	popprogramindicator VARCHAR(9),
	fpcode VARCHAR(6),
	initialppusedbm INTEGER DEFAULT 0,
	hasppindicator INTEGER DEFAULT 0,
	protectedusedplatinumbm INTEGER DEFAULT 0,
	protectedusedgoldbm INTEGER DEFAULT 0,
	protectedusedsilverbm INTEGER DEFAULT 0,
	initialusedplatinumbm INTEGER DEFAULT 0,
	initialusedgoldbm INTEGER DEFAULT 0,
	initialusedsilverbm INTEGER DEFAULT 0,
	ppindicator INTEGER DEFAULT 0,
	initialnewbm INTEGER DEFAULT 0,
	initialppnewbm INTEGER DEFAULT 0,
	protectednewbm INTEGER DEFAULT 0,
	recordinserttimestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL
);



CREATE TABLE suggestions (
	id UUID NOT NULL,
	content JSON NOT NULL,
	createddate TIMESTAMP WITHOUT TIME ZONE NOT NULL,
	updateddate TIMESTAMP WITHOUT TIME ZONE,
	CONSTRAINT pk_suggestions PRIMARY KEY (id)
);


CREATE TABLE __efmigrationshistory (
	migrationid VARCHAR(150) NOT NULL,
	productversion VARCHAR(32) NOT NULL,
	CONSTRAINT pk___efmigrationshistory PRIMARY KEY (migrationid)
);

-- DML BEGIN
-- BASE TABLE: deposit (target >= 20 rows)
-- BASE TABLE: dividendPayout (target >= 20 rows)
-- BASE TABLE: incentiveBenchmark (target >= 20 rows)
-- BASE TABLE: suggestions (target >= 20 rows)
-- BASE TABLE: __eFMigrationsHistory (target >= 20 rows)
-- INSERT ORDER: dividendPayout, incentiveBenchmark, deposit, suggestions, __eFMigrationsHistory
-- TABLE dividendPayout START (>= 20 rows)
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level1', 1500.00, 1200.00, DATE '2023-01-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level2', 2500.50, 2300.75, DATE '2023-02-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level3', 3500.00, 3200.00, DATE '2023-03-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level4', 4500.25, 4200.50, DATE '2023-04-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level5', 5500.00, 5200.00, DATE '2023-05-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level6', 6500.75, 6200.25, DATE '2023-06-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level7', 7500.00, 7200.00, DATE '2023-07-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level8', 8500.50, 8200.75, DATE '2023-08-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level9', 9500.00, 9200.00, DATE '2023-09-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level10', 10500.25, 10200.50, DATE '2023-10-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level11', 11500.00, 11200.00, DATE '2023-11-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level12', 12500.75, 12200.25, DATE '2023-12-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level13', 13500.00, 13200.00, DATE '2024-01-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level14', 14500.50, 14200.75, DATE '2024-02-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level15', 15500.00, 15200.00, DATE '2024-03-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level16', 16500.25, 16200.50, DATE '2024-04-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level17', 17500.00, 17200.00, DATE '2024-05-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level18', 18500.75, 18200.25, DATE '2024-06-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level19', 19500.00, 19200.00, DATE '2024-07-15');
INSERT INTO dividendpayout (earningslevel, a1payout, a2b3payout, recordinserttimestamp) VALUES ('Level20', 20500.50, 20200.75, DATE '2024-08-15');

-- TABLE dividendPayout END
-- TABLE incentiveBenchmark START (>= 20 rows)
INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000001', 'Alpha Motors', 10, 202301, 'Active', 1, 'Qualified', 100, 5, 'Pop1', 'FP001', 3, 1, 2, 1, 0, 1, 0, 0, 1, 4, 2, 3, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000002', 'Beta Autos', 15, 202302, 'Inactive', 0, 'Pending', 200, 10, 'Pop2', 'FP002', 5, 0, 3, 2, 1, 2, 1, 1, 0, 6, 3, 5, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000003', 'Gamma Cars', 20, 202303, 'Active', 1, 'Qualified', 300, 15, 'Pop3', 'FP003', 7, 1, 4, 3, 2, 3, 2, 1, 1, 8, 4, 7, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000004', 'Delta Vehicles', 25, 202304, 'Inactive', 0, 'Pending', 400, 20, 'Pop4', 'FP004', 9, 0, 5, 4, 3, 4, 3, 2, 0, 10, 5, 9, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000005', 'Epsilon Autos', 30, 202305, 'Active', 1, 'Qualified', 500, 25, 'Pop5', 'FP005', 11, 1, 6, 5, 4, 5, 4, 3, 1, 12, 6, 11, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000006', 'Zeta Motors', 35, 202306, 'Inactive', 0, 'Pending', 600, 30, 'Pop6', 'FP006', 13, 0, 7, 6, 5, 6, 5, 4, 0, 14, 7, 13, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000007', 'Eta Autos', 40, 202307, 'Active', 1, 'Qualified', 700, 35, 'Pop7', 'FP007', 15, 1, 8, 7, 6, 7, 6, 5, 1, 16, 8, 15, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000008', 'Theta Vehicles', 45, 202308, 'Inactive', 0, 'Pending', 800, 40, 'Pop8', 'FP008', 17, 0, 9, 8, 7, 8, 7, 6, 0, 18, 9, 17, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000009', 'Iota Motors', 50, 202309, 'Active', 1, 'Qualified', 900, 45, 'Pop9', 'FP009', 19, 1, 10, 9, 8, 9, 8, 7, 1, 20, 10, 19, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000010', 'Kappa Autos', 55, 202310, 'Inactive', 0, 'Pending', 1000, 50, 'Pop10', 'FP010', 21, 0, 11, 10, 9, 10, 9, 8, 0, 22, 11, 21, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000011', 'Lambda Vehicles', 60, 202311, 'Active', 1, 'Qualified', 1100, 55, 'Pop11', 'FP011', 23, 1, 12, 11, 10, 11, 10, 9, 1, 24, 12, 23, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000012', 'Mu Autos', 65, 202312, 'Inactive', 0, 'Pending', 1200, 60, 'Pop12', 'FP012', 25, 0, 13, 12, 11, 12, 11, 10, 0, 26, 13, 25, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000013', 'Nu Motors', 70, 202401, 'Active', 1, 'Qualified', 1300, 65, 'Pop13', 'FP013', 27, 1, 14, 13, 12, 13, 12, 11, 1, 28, 14, 27, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000014', 'Xi Autos', 75, 202402, 'Inactive', 0, 'Pending', 1400, 70, 'Pop14', 'FP014', 29, 0, 15, 14, 13, 14, 13, 12, 0, 30, 15, 29, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000015', 'Omicron Vehicles', 80, 202403, 'Active', 1, 'Qualified', 1500, 75, 'Pop15', 'FP015', 31, 1, 16, 15, 14, 15, 14, 13, 1, 32, 16, 31, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000016', 'Pi Autos', 85, 202404, 'Inactive', 0, 'Pending', 1600, 80, 'Pop16', 'FP016', 33, 0, 17, 16, 15, 16, 15, 14, 0, 34, 17, 33, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000017', 'Rho Motors', 90, 202405, 'Active', 1, 'Qualified', 1700, 85, 'Pop17', 'FP017', 35, 1, 18, 17, 16, 17, 16, 15, 1, 36, 18, 35, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000018', 'Sigma Autos', 95, 202406, 'Inactive', 0, 'Pending', 1800, 90, 'Pop18', 'FP018', 37, 0, 19, 18, 17, 18, 17, 16, 0, 38, 19, 37, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000019', 'Tau Vehicles', 100, 202407, 'Active', 1, 'Qualified', 1900, 95, 'Pop19', 'FP019', 39, 1, 20, 19, 18, 19, 18, 17, 1, 40, 20, 39, NOW());

INSERT INTO incentivebenchmark (dealerid, dealername, protectedppnew, yearmonthcode, earningstatus, ddpopearningflag, popearningstatus, benchmark, protectedppusedbm, popprogramindicator, fpcode, initialppusedbm, hasppindicator, protectedusedplatinumbm, protectedusedgoldbm, protectedusedsilverbm, initialusedplatinumbm, initialusedgoldbm, initialusedsilverbm, ppindicator, initialnewbm, initialppnewbm, protectednewbm, recordinserttimestamp)
VALUES ('D0000020', 'Upsilon Autos', 105, 202408, 'Inactive', 0, 'Pending', 2000, 100, 'Pop20', 'FP020', 41, 0, 21, 20, 19, 20, 19, 18, 0, 42, 21, 41, NOW());

-- TABLE incentiveBenchmark END
-- TABLE deposit START (>= 20 rows)
INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000001', 'D0000001', 'TypeA', 'Standard', 10000.00, 'PYK001', 202301, 100, DATE '2023-01-10', DATE '2024-01-10', 'DEYK001', 202401, 'First deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000002', 'D0000002', 'TypeB', 'Premium', 20000.00, 'PYK002', 202302, 200, DATE '2023-02-10', DATE '2024-02-10', 'DEYK002', 202402, 'Second deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000003', 'D0000003', 'TypeC', 'Standard', 15000.00, 'PYK003', 202303, 150, DATE '2023-03-10', DATE '2024-03-10', 'DEYK003', 202403, 'Third deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000004', 'D0000004', 'TypeA', 'Premium', 25000.00, 'PYK004', 202304, 250, DATE '2023-04-10', DATE '2024-04-10', 'DEYK004', 202404, 'Fourth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000005', 'D0000005', 'TypeB', 'Standard', 12000.00, 'PYK005', 202305, 120, DATE '2023-05-10', DATE '2024-05-10', 'DEYK005', 202405, 'Fifth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000006', 'D0000006', 'TypeC', 'Premium', 22000.00, 'PYK006', 202306, 220, DATE '2023-06-10', DATE '2024-06-10', 'DEYK006', 202406, 'Sixth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000007', 'D0000007', 'TypeA', 'Standard', 13000.00, 'PYK007', 202307, 130, DATE '2023-07-10', DATE '2024-07-10', 'DEYK007', 202407, 'Seventh deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000008', 'D0000008', 'TypeB', 'Premium', 23000.00, 'PYK008', 202308, 230, DATE '2023-08-10', DATE '2024-08-10', 'DEYK008', 202408, 'Eighth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000009', 'D0000009', 'TypeC', 'Standard', 14000.00, 'PYK009', 202309, 140, DATE '2023-09-10', DATE '2024-09-10', 'DEYK009', 202409, 'Ninth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000010', 'D0000010', 'TypeA', 'Premium', 24000.00, 'PYK010', 202310, 240, DATE '2023-10-10', DATE '2024-10-10', 'DEYK010', 202410, 'Tenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000011', 'D0000011', 'TypeB', 'Standard', 11000.00, 'PYK011', 202311, 110, DATE '2023-11-10', DATE '2024-11-10', 'DEYK011', 202411, 'Eleventh deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000012', 'D0000012', 'TypeC', 'Premium', 21000.00, 'PYK012', 202312, 210, DATE '2023-12-10', DATE '2024-12-10', 'DEYK012', 202412, 'Twelfth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000013', 'D0000013', 'TypeA', 'Standard', 16000.00, 'PYK013', 202401, 160, DATE '2024-01-10', DATE '2025-01-10', 'DEYK013', 202501, 'Thirteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000014', 'D0000014', 'TypeB', 'Premium', 26000.00, 'PYK014', 202402, 260, DATE '2024-02-10', DATE '2025-02-10', 'DEYK014', 202502, 'Fourteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000015', 'D0000015', 'TypeC', 'Standard', 17000.00, 'PYK015', 202403, 170, DATE '2024-03-10', DATE '2025-03-10', 'DEYK015', 202503, 'Fifteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000016', 'D0000016', 'TypeA', 'Premium', 27000.00, 'PYK016', 202404, 270, DATE '2024-04-10', DATE '2025-04-10', 'DEYK016', 202504, 'Sixteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000017', 'D0000017', 'TypeB', 'Standard', 18000.00, 'PYK017', 202405, 180, DATE '2024-05-10', DATE '2025-05-10', 'DEYK017', 202505, 'Seventeenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000018', 'D0000018', 'TypeC', 'Premium', 28000.00, 'PYK018', 202406, 280, DATE '2024-06-10', DATE '2025-06-10', 'DEYK018', 202506, 'Eighteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000019', 'D0000019', 'TypeA', 'Standard', 19000.00, 'PYK019', 202407, 190, DATE '2024-07-10', DATE '2025-07-10', 'DEYK019', 202507, 'Nineteenth deposit', NOW());

INSERT INTO deposit (dividendsdepositid, dealernumber, performdeposittype, deposittype, depositamount, performanceymckey, performanceymc, currentbalance, depositdate, expirationdate, dealerexpirationymckey, expirationmonth, notes, recordinserttimestamp)
VALUES ('DD000000000000020', 'D0000020', 'TypeB', 'Premium', 29000.00, 'PYK020', 202408, 290, DATE '2024-08-10', DATE '2025-08-10', 'DEYK020', 202508, 'Twentieth deposit', NOW());

-- TABLE deposit END
-- TABLE suggestions START (>= 20 rows)
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('11111111-1111-1111-1111-111111111111', '{"suggestion": "Increase deposit limits"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('22222222-2222-2222-2222-222222222222', '{"suggestion": "Add new payout levels"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('33333333-3333-3333-3333-333333333333', '{"suggestion": "Improve benchmark accuracy"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('44444444-4444-4444-4444-444444444444', '{"suggestion": "Enhance reporting features"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('55555555-5555-5555-5555-555555555555', '{"suggestion": "Add dealer notifications"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('66666666-6666-6666-6666-666666666666', '{"suggestion": "Optimize database queries"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('77777777-7777-7777-7777-777777777777', '{"suggestion": "Improve UI responsiveness"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('88888888-8888-8888-8888-888888888888', '{"suggestion": "Add multi-language support"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('99999999-9999-9999-9999-999999999999', '{"suggestion": "Implement audit logs"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '{"suggestion": "Add export to CSV"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', '{"suggestion": "Add user roles"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('cccccccc-cccc-cccc-cccc-cccccccccccc', '{"suggestion": "Improve security"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('dddddddd-dddd-dddd-dddd-dddddddddddd', '{"suggestion": "Add mobile app"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('eeeeeeee-eeee-eeee-eeee-eeeeeeeeeeee', '{"suggestion": "Add API access"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('ffffffff-ffff-ffff-ffff-ffffffffffff', '{"suggestion": "Improve data import"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('00000000-0000-0000-0000-000000000001', '{"suggestion": "Add dark mode"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('00000000-0000-0000-0000-000000000002', '{"suggestion": "Add help documentation"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('00000000-0000-0000-0000-000000000003', '{"suggestion": "Add chat support"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('00000000-0000-0000-0000-000000000004', '{"suggestion": "Add performance metrics"}', NOW(), NULL);
INSERT INTO suggestions (id, content, createddate, updateddate) VALUES ('00000000-0000-0000-0000-000000000005', '{"suggestion": "Add backup options"}', NOW(), NULL);
-- TABLE suggestions END
-- TABLE __eFMigrationsHistory START (>= 20 rows)
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230101010101_InitialCreate', '6.0.0');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230202020202_AddDepositTable', '6.0.1');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230303030303_AddDividendPayout', '6.0.2');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230404040404_AddIncentiveBenchmark', '6.0.3');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230505050505_AddSuggestions', '6.0.4');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230606060606_UpdateDepositSchema', '6.0.5');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230707070707_UpdateDividendPayoutSchema', '6.0.6');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230808080808_UpdateIncentiveBenchmarkSchema', '6.0.7');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20230909090909_UpdateSuggestionsSchema', '6.0.8');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20231010101010_AddIndexes', '6.0.9');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20231111111111_AddConstraints', '6.1.0');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20231212121212_OptimizeQueries', '6.1.1');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240113131313_AddNewColumns', '6.1.2');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240214141414_RemoveDeprecated', '6.1.3');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240315151515_UpdateDataTypes', '6.1.4');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240416161616_AddForeignKeys', '6.1.5');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240517171717_UpdateIndexes', '6.1.6');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240618181818_AddTriggers', '6.1.7');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240719191919_UpdateViews', '6.1.8');
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES ('20240820202020_FinalizeSchema', '6.1.9');
-- TABLE __eFMigrationsHistory END
-- DML END
