【SQL开源代码栏目提醒】:本文主要为网学会员提供dzsw_1_6.sql,希望对需要dzsw_1_6.sql网友有所帮助,学习一下!
--
-- 数据库: ``
--
-- --------------------------------------------------------
--
-- 表的结构 `dzsw_address_book`
--
DROP TABLE IF EXISTS `dzsw_address_book`;
CREATE TABLE `dzsw_address_book` (
`abid` mediumint(8) NOT NULL auto_increment,
`cid` mediumint(8) unsigned NOT NULL default '0',
`gender` tinyint(1) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`street_address` varchar(64) NOT NULL default '',
`suburb` varchar(32) default NULL,
`postcode` mediumint(6) unsigned NOT NULL default '0',
`city` varchar(32) NOT NULL default '',
`province` varchar(32) default NULL,
`country` varchar(32) NOT NULL default '0',
`tel_regular` varchar(32) NOT NULL default '',
`tel_mobile` varchar(32) NOT NULL default '',
`qq` varchar(15) NOT NULL default '',
`msn` varchar(100) NOT NULL default '',
PRIMARY KEY (`abid`),
KEY `idx_ab_cid` (`cid`)
) TYPE=MyISAM;
--
-- 导出表中的数据 `dzsw_address_book`
--
-- --------------------------------------------------------
--
-- 表的结构 `dzsw_admingroups`
--
DROP TABLE IF EXISTS `dzsw_admingroups`;
CREATE TABLE `dzsw_admingroups` (
`admingroupsid` smallint(6) unsigned NOT NULL auto_increment,
`classes` enum('admin','operator') NOT NULL default 'admin',
`grouptitle` varchar(30) NOT NULL default '',
`allow_class_see` tinyint(1) unsigned NOT NULL default '0',
`allow_class_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_class_add` tinyint(1) unsigned NOT NULL default '0',
`allow_class_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_product_see` tinyint(1) unsigned NOT NULL default '0',
`allow_product_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_product_add` tinyint(1) unsigned NOT NULL default '0',
`allow_product_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_order_see` tinyint(1) unsigned NOT NULL default '0',
`allow_customer_see` tinyint(1) unsigned NOT NULL default '0',
`allow_customer_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_customer_add` tinyint(1) unsigned NOT NULL default '0',
`allow_customer_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_news_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_news_add` tinyint(1) unsigned NOT NULL default '0',
`allow_news_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_gbook_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_gbook_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_gbook_reply` tinyint(1) unsigned NOT NULL default '0',
`allow_links_edit` tinyint(1) unsigned NOT NULL default '0',
`allow_links_add` tinyint(1) unsigned NOT NULL default '0',
`allow_links_delete` tinyint(1) unsigned NOT NULL default '0',
`allow_sendmail` tinyint(1) unsigned NOT NULL default '0',
`allow_orderstatus` varchar(200) NOT NULL default '',
`allow_orderstatus_g` varchar(200) NOT NULL default '',
PRIMARY KEY (`admingroupsid`)
) TYPE=MyISAM;
--
-- 导出表中的数据 `dzsw_admingroups`
--
INSERT INTO `dzsw_admingroups` VALUES (1, 'admin', '管理员', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'noauditing,auditing,waitforpay,partpay,allpay,makesurepay,cancel,shipping,waitforsend,partsend,allsend,sendsuccess,sendfail,over,getexchange,payback', 'noauditing,auditing,cancel,shipping,waitforsend,partsend,allsend,sendsuccess,sendfail,allpay,makesurepay,over,getexchange,payback');
INSERT INTO `dzsw_admingroups` VALUES (2, 'operator', '副管理员', 0, 1, 1, 1, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'noauditing,auditing,waitforpay,partpay,allpay,makesurepay,cancel,shipping,waitforsend,partsend,allsend,sendsuccess,sendfail,over,getexchange,payback', 'noauditing,auditing,cancel,shipping,waitforsend,partsend,allsend,sendsuccess,sendfail,allpay,makesurepay,over,getexchange,payback');
INSERT INTO `dzsw_admingroups` VALUES (3, 'operator', '会计', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'waitforpay,partpay,allpay,makesurepay,payback', 'makesurepay,payback');
INSERT INTO `dzsw_admingroups` VALUES (4, 'operator', '客服人员', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'getexchange', 'getexchange');
INSERT INTO `dzsw_admingroups` VALUES (5, 'operator', '送货人员', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'shipping,waitforsend,partsend,allsend,sendsuccess,