db_zh_tw_utf8.sql

网上鲜花管理系统

# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# 主機: localhost
# 建立日期: Mar 28, 2007 at 08:28 PM
# 伺服機版本: 4.01.14
# PHP 版本: 4.3.8
# 資料庫 : `dbeflower`
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_admin`
#

CREATE TABLE mpshop_admin (
  id int(6) NOT NULL auto_increment,
  `user` varchar(30) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  moveable int(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_admin`
#

INSERT INTO mpshop_admin VALUES (3, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'SystemMaster', 0);
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_admin_auth`
#

CREATE TABLE mpshop_admin_auth (
  id int(6) NOT NULL auto_increment,
  auth char(20) default NULL,
  name char(50) default NULL,
  intro char(255) default NULL,
  xuhao int(10) default NULL,
  pid int(10) default NULL,
  pname char(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_admin_auth`
#

INSERT INTO mpshop_admin_auth VALUES (1, '1', '系統參數設置', '', 1, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (2, '2', '修改管理密碼', '', 2, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (3, '3', '管理帳戶設置', '', 3, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (4, '4', '會員類型設置', '', 4, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (5, '5', '地區行業設置', '', 5, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (6, '6', '貨幣類型設置', '', 6, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (7, '7', '支付方式設置', '', 7, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (8, '8', '配送方法設置', '', 8, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (9, '9', '積分演算法設置', '', 9, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (10, '11', '網站欄目設置', '', 1, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (11, '12', '網站欄目刪除', '', 2, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (12, '13', '網站頁面設置', '', 3, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (13, '14', '介面風格設置', '', 4, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (14, '15', '自定表單設置', '', 5, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (15, '16', '社區分類設置', '', 6, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (16, '17', '網站專題設置', '', 7, 1, '網站設置');
INSERT INTO mpshop_admin_auth VALUES (17, '21', '文章頻道管理', '', 1, 2, '內容管理');
INSERT INTO mpshop_admin_auth VALUES (18, '22', '圖文頻道管理', '', 2, 2, '內容管理');
INSERT INTO mpshop_admin_auth VALUES (19, '23', '下載頻道管理', '', 3, 2, '內容管理');
INSERT INTO mpshop_admin_auth VALUES (20, '24', '網站標誌管理', '', 4, 2, '內容管理');
INSERT INTO mpshop_admin_auth VALUES (21, '25', '網站廣告管理', '', 5, 2, '內容管理');
INSERT INTO mpshop_admin_auth VALUES (22, '31', '商品類別管理', '', 1, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (23, '32', '商品查詢管理', '', 2, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (24, '33', '商品發佈修改', '', 3, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (25, '34', '商品刪除許可權', '', 4, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (26, '41', '未完訂單查詢', '', 1, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (27, '42', '存檔訂單查詢', '', 2, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (28, '43', '訂單審核確認', '', 3, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (29, '44', '訂單發貨確認', '', 4, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (30, '45', '訂單退貨確認', '', 5, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (31, '46', '修改訂單金額', '', 6, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (32, '47', '訂單存檔退檔', '', 7, 4, '訂單管理');
INSERT INTO mpshop_admin_auth VALUES (33, '51', '會員審核管理', '', 1, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (34, '52', '會員查詢管理', '', 2, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (35, '53', '會員資料查詢', '', 3, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (36, '54', '會員資料修改', '', 4, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (37, '55', '會員郵件發送', '', 5, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (38, '56', '會員許可權管理', '', 6, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (39, '57', '會員公告管理', '', 7, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (40, '58', '模擬會員登錄', '', 8, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (41, '59', '會員帳務查詢', '', 9, 5, '會員管理');
INSERT INTO mpshop_admin_auth VALUES (42, '61', '回饋資訊管理', '', 1, 6, '資訊管理');
INSERT INTO mpshop_admin_auth VALUES (43, '62', '社區評論管理', '', 2, 6, '資訊管理');
INSERT INTO mpshop_admin_auth VALUES (44, '71', '訪問統計系統', '', 1, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (45, '72', '網站資料備份', '', 2, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (46, '73', '投票調查系統', '', 3, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (47, '74', '友情鏈結系統', '', 4, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (48, '75', '軟體升級更新', '', 5, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (49, '76', '郵件群發許可權', '', 6, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (50, '77', '系統日誌查詢', '', 7, 7, '輔助工具');
INSERT INTO mpshop_admin_auth VALUES (51, '81', '預付帳戶入帳', '', 1, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (52, '82', '訂單收款確認', '', 2, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (53, '83', '訂單退款確認', '', 3, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (54, '84', '鏈盟提成結算', '', 4, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (55, '85', '賬務查詢統計', '', 5, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (56, '86', '訂單查詢統計', '', 6, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (57, '87', '商品銷售統計', '', 7, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (58, '88', '特殊定價查詢', '', 8, 8, '帳務管理');
INSERT INTO mpshop_admin_auth VALUES (59, '10', '商品類型設置', '', 10, 0, '系統設置');
INSERT INTO mpshop_admin_auth VALUES (60, '91', '商品促銷管理', '', 1, 9, '促銷管理');
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_admin_log`
#

CREATE TABLE mpshop_admin_log (
  id int(20) NOT NULL auto_increment,
  `user` char(20) NOT NULL default '',
  eventtype char(50) NOT NULL default '',
  stat int(1) NOT NULL default '0',
  securetype int(1) NOT NULL default '0',
  daytime int(11) NOT NULL default '0',
  ip char(20) NOT NULL default '',
  msg char(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_admin_log`
#

# --------------------------------------------------------

#
# 資料表的結構 `mpshop_admin_rights`
#

CREATE TABLE mpshop_admin_rights (
  id int(50) NOT NULL auto_increment,
  auth char(20) default NULL,
  `user` char(50) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_admin_rights`
#

INSERT INTO mpshop_admin_rights VALUES (588, '10', 'admin');
INSERT INTO mpshop_admin_rights VALUES (587, '88', 'admin');
INSERT INTO mpshop_admin_rights VALUES (586, '87', 'admin');
INSERT INTO mpshop_admin_rights VALUES (585, '86', 'admin');
INSERT INTO mpshop_admin_rights VALUES (584, '85', 'admin');
INSERT INTO mpshop_admin_rights VALUES (583, '84', 'admin');
INSERT INTO mpshop_admin_rights VALUES (582, '83', 'admin');
INSERT INTO mpshop_admin_rights VALUES (581, '82', 'admin');
INSERT INTO mpshop_admin_rights VALUES (580, '81', 'admin');
INSERT INTO mpshop_admin_rights VALUES (579, '77', 'admin');
INSERT INTO mpshop_admin_rights VALUES (578, '76', 'admin');
INSERT INTO mpshop_admin_rights VALUES (577, '75', 'admin');
INSERT INTO mpshop_admin_rights VALUES (576, '74', 'admin');
INSERT INTO mpshop_admin_rights VALUES (575, '73', 'admin');
INSERT INTO mpshop_admin_rights VALUES (574, '72', 'admin');
INSERT INTO mpshop_admin_rights VALUES (573, '71', 'admin');
INSERT INTO mpshop_admin_rights VALUES (572, '62', 'admin');
INSERT INTO mpshop_admin_rights VALUES (571, '61', 'admin');
INSERT INTO mpshop_admin_rights VALUES (570, '59', 'admin');
INSERT INTO mpshop_admin_rights VALUES (569, '58', 'admin');
INSERT INTO mpshop_admin_rights VALUES (568, '57', 'admin');
INSERT INTO mpshop_admin_rights VALUES (567, '56', 'admin');
INSERT INTO mpshop_admin_rights VALUES (566, '55', 'admin');
INSERT INTO mpshop_admin_rights VALUES (565, '54', 'admin');
INSERT INTO mpshop_admin_rights VALUES (564, '53', 'admin');
INSERT INTO mpshop_admin_rights VALUES (563, '52', 'admin');
INSERT INTO mpshop_admin_rights VALUES (562, '51', 'admin');
INSERT INTO mpshop_admin_rights VALUES (561, '47', 'admin');
INSERT INTO mpshop_admin_rights VALUES (560, '46', 'admin');
INSERT INTO mpshop_admin_rights VALUES (559, '45', 'admin');
INSERT INTO mpshop_admin_rights VALUES (558, '44', 'admin');
INSERT INTO mpshop_admin_rights VALUES (557, '43', 'admin');
INSERT INTO mpshop_admin_rights VALUES (556, '42', 'admin');
INSERT INTO mpshop_admin_rights VALUES (555, '41', 'admin');
INSERT INTO mpshop_admin_rights VALUES (554, '34', 'admin');
INSERT INTO mpshop_admin_rights VALUES (553, '33', 'admin');
INSERT INTO mpshop_admin_rights VALUES (552, '32', 'admin');
INSERT INTO mpshop_admin_rights VALUES (551, '31', 'admin');
INSERT INTO mpshop_admin_rights VALUES (550, '25', 'admin');
INSERT INTO mpshop_admin_rights VALUES (549, '24', 'admin');
INSERT INTO mpshop_admin_rights VALUES (548, '23', 'admin');
INSERT INTO mpshop_admin_rights VALUES (547, '22', 'admin');
INSERT INTO mpshop_admin_rights VALUES (546, '21', 'admin');
INSERT INTO mpshop_admin_rights VALUES (545, '17', 'admin');
INSERT INTO mpshop_admin_rights VALUES (544, '16', 'admin');
INSERT INTO mpshop_admin_rights VALUES (543, '15', 'admin');
INSERT INTO mpshop_admin_rights VALUES (542, '14', 'admin');
INSERT INTO mpshop_admin_rights VALUES (541, '13', 'admin');
INSERT INTO mpshop_admin_rights VALUES (540, '12', 'admin');
INSERT INTO mpshop_admin_rights VALUES (539, '11', 'admin');
INSERT INTO mpshop_admin_rights VALUES (538, '9', 'admin');
INSERT INTO mpshop_admin_rights VALUES (537, '8', 'admin');
INSERT INTO mpshop_admin_rights VALUES (536, '7', 'admin');
INSERT INTO mpshop_admin_rights VALUES (535, '6', 'admin');
INSERT INTO mpshop_admin_rights VALUES (534, '5', 'admin');
INSERT INTO mpshop_admin_rights VALUES (533, '4', 'admin');
INSERT INTO mpshop_admin_rights VALUES (532, '3', 'admin');
INSERT INTO mpshop_admin_rights VALUES (531, '2', 'admin');
INSERT INTO mpshop_admin_rights VALUES (530, '1', 'admin');
INSERT INTO mpshop_admin_rights VALUES (589, '91', 'admin');
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_advs_dl`
#

CREATE TABLE mpshop_advs_dl (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  `type` char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  toppadding int(20) default NULL,
  sidepadding int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_advs_dl`
#

INSERT INTO mpshop_advs_dl VALUES (1, 1, '', 75, 180, 'gif', 'images/duilian.gif', 'http://', '_self', 0, 1, 5, 5);
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_advs_float`
#

CREATE TABLE mpshop_advs_float (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title varchar(200) default NULL,
  float_advs_type varchar(10) NOT NULL default '',
  hidden int(1) NOT NULL default '0',
  float_width int(3) NOT NULL default '0',
  float_height int(3) NOT NULL default '0',
  float_url varchar(255) NOT NULL default '',
  float_target varchar(40) NOT NULL default '',
  src varchar(255) NOT NULL default '',
  float_speed int(4) NOT NULL default '0',
  border int(3) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_advs_float`
#

INSERT INTO mpshop_advs_float VALUES (1, 1, '', 'gif', 1, 100, 100, 'http://', '_self', 'images/float.gif', 100, 0);
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_advs_lb`
#

CREATE TABLE mpshop_advs_lb (
  id int(20) NOT NULL auto_increment,
  title char(100) NOT NULL default '',
  src char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  xuhao int(5) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `mpshop_advs_lb`
#

INSERT INTO mpshop_advs_lb VALUES (4, '廣告標題2', 'advs/1173593585.jpg', 'http://www', 2);
INSERT INTO mpshop_advs_lb VALUES (3, '廣告標題1', 'advs/1173593554.jpg', 'http://www', 1);
INSERT INTO mpshop_advs_lb VALUES (5, '廣告標題3', 'advs/1173593609.jpg', 'http://www', 3);
# --------------------------------------------------------

#
# 資料表的結構 `mpshop_advs_left`
#

CREATE TABLE mpshop_advs_left (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  `type` char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  toppadding int(5) default NULL,
  sidepadding int(5) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;