

DROP TABLE IF EXISTS `ZIGCONNECT_TABLENAME_ZC_LISTITEMS`;


CREATE TABLE `ZIGCONNECT_TABLENAME_ZC_LISTITEMS` (
	`zc_listitem_id` 			BIGINT(20) 		UNSIGNED 	NOT NULL AUTO_INCREMENT,
	`zc_post_id` 				BIGINT(20) 		UNSIGNED 	NOT NULL DEFAULT '0', /* mandatory so we have a product even if they don't specify a shop */
	`zc_link_id` 				BIGINT(20) 		UNSIGNED	NOT NULL DEFAULT '0', /* optional - specifies a shop and price via the link */
	`zc_user_id` 				BIGINT(20) 		UNSIGNED	NOT NULL DEFAULT '0',
	`zc_listitem_qty` 			BIGINT(20) 		UNSIGNED 	NOT NULL DEFAULT '1', /* just a note for the user */
	`zc_listitem_comment` 		VARCHAR(255) 			 	NOT NULL DEFAULT '', /* just a note for the user */
	PRIMARY KEY 				(`zc_listitem_id`),
	KEY `zc_post_id` 			(`zc_post_id`),
	KEY `zc_link_id` 			(`zc_link_id`),
	KEY `zc_user_id` 			(`zc_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

