data.sql

售票网站系统

GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-036',
	'002',
    'value 3', 'value 3', 'value 1', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-037',
	'002',
    'value 1', 'value 1', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-038',
	'002',
    'value 2', 'value 1', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-039',
	'002',
    'value 3', 'value 1', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-040',
	'002',
    'value 1', 'value 2', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-041',
	'002',
    'value 2', 'value 2', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-042',
	'002',
    'value 3', 'value 2', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-043',
	'002',
    'value 1', 'value 3', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-044',
	'002',
    'value 2', 'value 3', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-045',
	'002',
    'value 3', 'value 3', 'value 2', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-046',
	'002',
    'value 1', 'value 1', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-047',
	'002',
    'value 2', 'value 1', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-048',
	'002',
    'value 3', 'value 1', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-049',
	'002',
    'value 1', 'value 2', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-050',
	'002',
    'value 2', 'value 2', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-051',
	'002',
    'value 3', 'value 2', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-052',
	'002',
    'value 1', 'value 3', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-053',
	'002',
    'value 2', 'value 3', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-054',
	'002',
    'value 3', 'value 3', 'value 3', 'value 2', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-055',
	'002',
    'value 1', 'value 1', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-056',
	'002',
    'value 2', 'value 1', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-057',
	'002',
    'value 3', 'value 1', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-058',
	'002',
    'value 1', 'value 2', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-059',
	'002',
    'value 2', 'value 2', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-060',
	'002',
    'value 3', 'value 2', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-061',
	'002',
    'value 1', 'value 3', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-062',
	'002',
    'value 2', 'value 3', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-063',
	'002',
    'value 3', 'value 3', 'value 1', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-064',
	'002',
    'value 1', 'value 1', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-065',
	'002',
    'value 2', 'value 1', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-066',
	'002',
    'value 3', 'value 1', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-067',
	'002',
    'value 1', 'value 2', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-068',
	'002',
    'value 2', 'value 2', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-069',
	'002',
    'value 3', 'value 2', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-070',
	'002',
    'value 1', 'value 3', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-071',
	'002',
    'value 2', 'value 3', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-072',
	'002',
    'value 3', 'value 3', 'value 2', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-073',
	'002',
    'value 1', 'value 1', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-074',
	'002',
    'value 2', 'value 1', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-075',
	'002',
    'value 3', 'value 1', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-076',
	'002',
    'value 1', 'value 2', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-077',
	'002',
    'value 2', 'value 2', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-078',
	'002',
    'value 3', 'value 2', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-079',
	'002',
    'value 1', 'value 3', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-080',
	'002',
    'value 2', 'value 3', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'002-081',
	'002',
    'value 3', 'value 3', 'value 3', 'value 3', NULL
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 1', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 1', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 1', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 2', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 2', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 2', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 3', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 3', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 3', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 4', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 4', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'002',
    'label 4', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-001',
	'003',
    'value 1', 'value 1', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-002',
	'003',
    'value 2', 'value 1', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-003',
	'003',
    'value 3', 'value 1', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-004',
	'003',
    'value 1', 'value 2', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-005',
	'003',
    'value 2', 'value 2', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-006',
	'003',
    'value 3', 'value 2', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-007',
	'003',
    'value 1', 'value 3', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-008',
	'003',
    'value 2', 'value 3', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-009',
	'003',
    'value 3', 'value 3', 'value 1', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-010',
	'003',
    'value 1', 'value 1', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-011',
	'003',
    'value 2', 'value 1', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-012',
	'003',
    'value 3', 'value 1', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-013',
	'003',
    'value 1', 'value 2', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-014',
	'003',
    'value 2', 'value 2', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-015',
	'003',
    'value 3', 'value 2', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-016',
	'003',
    'value 1', 'value 3', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-017',
	'003',
    'value 2', 'value 3', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-018',
	'003',
    'value 3', 'value 3', 'value 2', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-019',
	'003',
    'value 1', 'value 1', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-020',
	'003',
    'value 2', 'value 1', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-021',
	'003',
    'value 3', 'value 1', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-022',
	'003',
    'value 1', 'value 2', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-023',
	'003',
    'value 2', 'value 2', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-024',
	'003',
    'value 3', 'value 2', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-025',
	'003',
    'value 1', 'value 3', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-026',
	'003',
    'value 2', 'value 3', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'003-027',
	'003',
    'value 3', 'value 3', 'value 3', NULL, NULL
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 1', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 1', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 1', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 2', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 2', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 2', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 3', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 3', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'003',
    'label 3', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-001',
	'004',
    'value 1', 'value 1', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-002',
	'004',
    'value 2', 'value 1', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-003',
	'004',
    'value 3', 'value 1', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-004',
	'004',
    'value 1', 'value 2', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-005',
	'004',
    'value 2', 'value 2', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-006',
	'004',
    'value 3', 'value 2', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-007',
	'004',
    'value 1', 'value 3', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-008',
	'004',
    'value 2', 'value 3', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'004-009',
	'004',
    'value 3', 'value 3', NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 1', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 1', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 1', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 2', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 2', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'004',
    'label 2', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'005-001',
	'005',
    'value 1', NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'005-002',
	'005',
    'value 2', NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'005-003',
	'005',
    'value 3', NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'005',
    'label 1', 'value 1', 1
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'005',
    'label 1', 'value 2', 2
) 
GO

INSERT INTO hbpc_shop_multi_val_attr VALUES (
	'005',
    'label 1', 'value 3', 3
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'006-001',
	'006',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'007-001',
	'007',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'008-001',
	'008',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'009-001',
	'009',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'010-001',
	'010',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'011-001',
	'011',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'012-001',
	'012',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'013-001',
	'013',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'014-001',
	'014',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'015-001',
	'015',
    NULL, NULL, NULL, NULL, NULL
) 
GO

INSERT INTO hbpc_shop_variant VALUES (
	'016-001',
	'016',
    NULL, NULL, NULL, NULL, NULL
) 
GO