dwz + zend framework 商品展示网站

-- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2014 年 08 月 06 日 05:40 -- 服务器版本: 5.1.40 -- PHP 版本: 5.3.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `zf_wwy_shop` -- -- -------------------------------------------------------- -- -- 表的结构 `acategory` -- CREATE TABLE IF NOT EXISTS `acategory` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '分类类型，1为系统保留类型，不能删除', `name` varchar(50) NOT NULL, `description` varchar(255) NOT NULL, `order` smallint(6) unsigned NOT NULL DEFAULT '50', `status` tinyint(1) unsigned NOT NULL DEFAULT '1', `create_time` int(11) unsigned NOT NULL, `update_time` int(11) unsigned NOT NULL, `pid` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`), KEY `order` (`order`), KEY `status` (`status`,`update_time`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `acategory` -- INSERT INTO `acategory` (`id`, `type`, `name`, `description`, `order`, `status`, `create_time`, `update_time`, `pid`) VALUES (1, 1, '帮助信息', '帮助信息', 1, 1, 1406973477, 1406973477, 0), (2, 0, '关于我们', '关于我们', 2, 1, 1406973898, 1406989153, 1); -- -------------------------------------------------------- -- -- 表的结构 `admin_acl_node` -- CREATE TABLE IF NOT EXISTS `admin_acl_node` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `title` varchar(50) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `remark` varchar(255) DEFAULT NULL, `sort` smallint(6) unsigned NOT NULL DEFAULT '0', `pid` smallint(6) unsigned NOT NULL, `level` tinyint(1) unsigned NOT NULL, `type` enum('group','controller','action') NOT NULL DEFAULT 'action', `is_show` tinyint(1) unsigned DEFAULT '0' COMMENT '菜单是否显示，按级判断，父级不显示，则子级不显示。特定分组、特定控制器、特定操作是否显示', PRIMARY KEY (`id`), KEY `level` (`level`), KEY `pid` (`pid`), KEY `status` (`status`), KEY `name` (`name`), KEY `type` (`type`), KEY `show` (`is_show`), KEY `show_2` (`is_show`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=139 ; -- -- 转存表中的数据 `admin_acl_node` -- INSERT INTO `admin_acl_node` (`id`, `name`, `title`, `status`, `remark`, `sort`, `pid`, `level`, `type`, `is_show`) VALUES (49, 'read', '查看', 1, '', 10, 2, 3, 'action', 0), (40, 'index', '默认控制器', 1, '默认控制器', 1, 97, 2, 'controller', 0), (39, 'index', '列表', 1, '', 3, 2, 3, 'action', 0), (37, 'resume', '恢复', 1, '', 10, 2, 3, 'action', 0), (36, 'forbid', '禁用', 1, '', 10, 2, 3, 'action', 0), (35, 'foreverdelete', '删除', 1, '', 4, 2, 3, 'action', 0), (34, 'update', '更新', 1, '', 10, 2, 3, 'action', 0), (33, 'edit', '编辑', 1, '编辑', 2, 2, 3, 'action', 0), (32, 'insert', '写入', 1, '', 10, 2, 3, 'action', 0), (31, 'add', '新增', 1, '新增节点', 1, 2, 3, 'action', 1), (86, 'index', '首页', 1, '', 0, 40, 3, 'action', 0), (7, 'user', '后台用户', 1, '', 4, 1, 2, 'controller', 1), (6, 'role', '角色管理', 1, '', 3, 1, 2, 'controller', 1), (2, 'node', '节点管理', 1, '', 2, 1, 2, 'controller', 1), (50, 'main', '我的主页', 1, '', 3, 40, 3, 'action', 0), (1, 'system', '系统分组', 1, '系统管理', 0, 0, 1, 'group', 1), (96, 'add', '新增', 1, '新增角色', 1, 6, 3, 'action', 1), (90, 'type', '类型列表', 1, '类型列表', 8, 2, 3, 'action', 0), (97, 'default', '默认分组', 0, '默认分组', 9, 0, 1, 'group', 1), (98, 'index', '列表', 1, '列表', 3, 6, 3, 'action', 0), (107, 'add', '新增', 1, '新增商品', 1, 106, 3, 'action', 1), (99, 'edit', '编辑', 1, '编辑角色', 2, 6, 3, 'action', 0), (105, 'goods', '商品分组', 1, '商品管理', 1, 0, 1, 'group', 1), (106, 'goods', '商品管理', 1, '商品管理', 1, 105, 2, 'controller', 1), (108, 'gcategory', '分类管理', 1, '分类管理', 2, 105, 2, 'controller', 1), (109, 'add', '新增', 1, '新增分类', 1, 108, 3, 'action', 1), (110, 'edit', '编辑', 1, '编辑', 2, 106, 3, 'action', 0), (111, 'edit', '编辑', 1, '编辑分类', 2, 108, 3, 'action', 0), (112, 'index', '列表', 1, '商品列表', 3, 106, 3, 'action', 0), (113, 'article', '文章分组', 1, '文章分组', 2, 0, 1, 'group', 1), (118, 'add', '新增', 1, '新增', 1, 116, 3, 'action', 1), (116, 'article', '文章管理', 1, '文章管理', 1, 113, 2, 'controller', 1), (119, 'acategory', '文章分类管理', 1, '文章分类管理', 2, 113, 2, 'controller', 1), (120, 'add', '新增', 1, '新增文章分类', 1, 119, 3, 'action', 1), (121, 'top', '首页顶部', 1, '首页顶部', 1, 40, 3, 'action', 1), (122, 'menu', '主菜单', 1, '主菜单', 2, 40, 3, 'action', 1), (123, 'login', '登录', 1, '登录页面', 4, 40, 3, 'action', 1), (124, 'login-dialog', '登录对话框', 1, '登录对话框', 5, 40, 3, 'action', 1), (125, 'logout', '退出', 1, '退出', 6, 40, 3, 'action', 1), (126, 'captcha', '验证码', 1, '验证码', 7, 40, 3, 'action', 1), (127, 'refresh-acl', '刷新', 1, '强制刷新节点，所有角色ACL', 5, 2, 3, 'action', 0), (129, 'add', '新增', 1, '新增后台用户', 1, 7, 3, 'action', 1), (130, 'edit', '编辑', 1, '编辑后台用户', 2, 7, 3, 'action', 0), (131, 'foreverdelete', '删除', 1, '删除角色', 4, 6, 3, 'action', 0), (132, 'index', '列表', 1, '后台用户列表', 3, 7, 3, 'action', 0), (133, 'foreverdelete', '删除', 1, '删除后台用户', 4, 7, 3, 'action', 0), (138, 'index', '列表', 1, '分类列表', 3, 108, 3, 'action', 0); -- -------------------------------------------------------- -- -- 表的结构 `admin_acl_role` -- CREATE TABLE IF NOT EXISTS `admin_acl_role` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `title` varchar(50) NOT NULL, `acl` text NOT NULL, `status` tinyint(1) unsigned DEFAULT NULL, `remark` varchar(255) DEFAULT NULL, `create_time` int(11) unsigned NOT NULL, `update_time` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `title` (`title`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- 转存表中的数据 `admin_acl_role` -- INSERT INTO `admin_acl_role` (`id`, `name`, `title`, `acl`, `status`, `remark`, `create_time`, `update_time`) VALUES (1, 'manager', '内容管理组', 'O:8:"Zend_Acl":6:{s:16:"\0*\0_roleRegistry";O:22:"Zend_Acl_Role_Registry":1:{s:9:"\0*\0_roles";a:1:{s:7:"manager";a:3:{s:8:"instance";O:13:"Zend_Acl_Role":1:{s:10:"\0*\0_roleId";s:7:"manager";}s:7:"parents";a:0:{}s:8:"children";a:0:{}}}}s:13:"\0*\0_resources";a:10:{s:4:"node";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:4:"node";}s:6:"parent";N;s:8:"children";a:0:{}}s:4:"role";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:4:"role";}s:6:"parent";N;s:8:"children";a:0:{}}s:4:"user";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:4:"user";}s:6:"parent";N;s:8:"children";a:0:{}}s:5:"goods";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:5:"goods";}s:6:"parent";N;s:8:"children";a:0:{}}s:9:"gcategory";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:9:"gcategory";}s:6:"parent";N;s:8:"children";a:0:{}}s:6:"gbrand";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:6:"gbrand";}s:6:"parent";N;s:8:"children";a:0:{}}s:7:"article";a:3:{s:8:"instance";O:17:"Zend_Acl_Resource":1:{s:14:"\0*\0_resourceId";s:7:"article";}s:6:"