⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 data.sql

📁 售票网站系统
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 


/* - data.sql for hbpc_shop
**
**  Creates sql code to generate sample data for the hbpc_shop store
*/

/* truncate tables: */
DELETE hbpc_shop_promo_cross GO
DELETE hbpc_shop_promo_price GO
DELETE hbpc_shop_dept_prod GO
DELETE hbpc_shop_dept GO
DELETE hbpc_shop_single_val_attr GO
DELETE hbpc_shop_multi_val_attr GO
DELETE hbpc_shop_variant GO
DELETE hbpc_shop_product GO
DELETE hbpc_shop_receipt GO
DELETE hbpc_shop_receipt_item GO
DELETE hbpc_shop_basket GO
DELETE hbpc_shop_shopper GO



INSERT INTO hbpc_shop_dept VALUES (
	1,
	'dept name 1',
	'dept description 1'
) GO

INSERT INTO hbpc_shop_dept VALUES (
	2,
	'dept name 2',
	'dept description 2'
) GO

INSERT INTO hbpc_shop_dept VALUES (
	3,
	'dept name 3',
	'dept description 3'
) GO

INSERT INTO hbpc_shop_dept VALUES (
	4,
	'dept name 4',
	'dept description 4'
) GO

INSERT INTO hbpc_shop_product VALUES (
	'001',
	'product name 1',
	'product description 1',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    'label 1',
    'label 2',
    'label 3',
    'label 4',
    'label 5'
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	1,
	'001'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'002',
	'product name 2',
	'product description 2',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    'label 1',
    'label 2',
    'label 3',
    'label 4',
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	1,
	'002'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'003',
	'product name 3',
	'product description 3',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    'label 1',
    'label 2',
    'label 3',
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	1,
	'003'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'004',
	'product name 4',
	'product description 4',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    'label 1',
    'label 2',
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	1,
	'004'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'005',
	'product name 5',
	'product description 5',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    'label 1',
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	2,
	'005'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'006',
	'product name 6',
	'product description 6',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	2,
	'006'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'007',
	'product name 7',
	'product description 7',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	2,
	'007'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'008',
	'product name 8',
	'product description 8',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	2,
	'008'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'009',
	'product name 9',
	'product description 9',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	3,
	'009'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'010',
	'product name 10',
	'product description 10',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	3,
	'010'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'011',
	'product name 11',
	'product description 11',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	3,
	'011'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'012',
	'product name 12',
	'product description 12',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	3,
	'012'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'013',
	'product name 13',
	'product description 13',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	4,
	'013'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'014',
	'product name 14',
	'product description 14',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	4,
	'014'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'015',
	'product name 15',
	'product description 15',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	4,
	'015'
)  GO

INSERT INTO hbpc_shop_product VALUES (
	'016',
	'product name 16',
	'product description 16',
	1099,
	'product.gif',
	128,
	128,
	999,
	'19970411',
	'19980411',
    1,
    0,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
)GO

INSERT INTO hbpc_shop_dept_prod VALUES (
	4,
	'016'
)  GO

INSERT INTO hbpc_shop_promo_cross VALUES (
	'001',
	'009'
) GO

INSERT INTO hbpc_shop_promo_cross VALUES (
	'002',
	'010'
) GO

INSERT INTO hbpc_shop_promo_cross VALUES (
	'003',
	'011'
) GO

INSERT INTO hbpc_shop_promo_cross VALUES (
	'004',
	'012'
) GO

INSERT INTO hbpc_shop_promo_cross VALUES (
	'005',
	'013'
) GO

INSERT INTO hbpc_shop_promo_price VALUES (
    'Sample', 3, 'Buy 2 ''001'' for the price of 1!', 10, 1, '19970411', '19980411',
    1, null, null, null,
    0, '_product_pf_id', '=', '001', 'Q', 2,
    0, '_product_pf_id', '=', '001', 1, 0,
    '%', 100
) GO

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-014',
	'001',
    'value 2', 'value 2', 'value 2', 'value 1', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-015',
	'001',
    'value 3', 'value 2', 'value 2', 'value 1', 'value 1'
) GO

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-017',
	'001',
    'value 2', 'value 3', 'value 2', 'value 1', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-018',
	'001',
    'value 3', 'value 3', 'value 2', 'value 1', 'value 1'
) GO

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

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

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

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-023',
	'001',
    'value 2', 'value 2', 'value 3', 'value 1', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-024',
	'001',
    'value 3', 'value 2', 'value 3', 'value 1', 'value 1'
) GO

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-026',
	'001',
    'value 2', 'value 3', 'value 3', 'value 1', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-027',
	'001',
    'value 3', 'value 3', 'value 3', 'value 1', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-028',
	'001',
    'value 1', 'value 1', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-029',
	'001',
    'value 2', 'value 1', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-030',
	'001',
    'value 3', 'value 1', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-031',
	'001',
    'value 1', 'value 2', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-032',
	'001',
    'value 2', 'value 2', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-033',
	'001',
    'value 3', 'value 2', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-034',
	'001',
    'value 1', 'value 3', 'value 1', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-035',
	'001',
    'value 2', 'value 3', 'value 1', 'value 2', 'value 1'
) GO

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

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

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

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

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-041',
	'001',
    'value 2', 'value 2', 'value 2', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-042',
	'001',
    'value 3', 'value 2', 'value 2', 'value 2', 'value 1'
) GO

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

INSERT INTO hbpc_shop_variant VALUES (
	'001-044',
	'001',
    'value 2', 'value 3', 'value 2', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-045',
	'001',
    'value 3', 'value 3', 'value 2', 'value 2', 'value 1'
) GO

INSERT INTO hbpc_shop_variant VALUES (
	'001-046',
	'001',
    'value 1', 'value 1', 'value 3', 'value 2', 'value 1'
) GO
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -