CREATE TABLE IF NOT EXISTS `shopnc_sms_conf` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'id',
  `tel` varchar(26) NOT NULL COMMENT 'ֻ',
  `opensend` text NOT NULL COMMENT '',
  `smsnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `shopnc_sms_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
  `title` varchar(80) NOT NULL COMMENT '',
  `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ʱ',
  `tomember_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'նID',
  `tomember_name` varchar(26) NOT NULL COMMENT 'ն',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;