?? db_zh_cn_utf8.sql

?? 學校管理網(wǎng)站源碼,功能較好的源碼.下載試用下
?? SQL
?? 第 1 頁 / 共 5 頁
字號:
12 3 4 5 下一頁
# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# 主機: localhost
# 建立日期: Dec 04, 2006 at 02:15 AM
# 伺服機版本: 4.01.14
# PHP 版本: 4.3.8
# 數(shù)據(jù)庫 : `eshool`
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構 `sho_admin`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_admin`
#

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

#
# 數(shù)據(jù)表的結(jié)構 `sho_admin_auth`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_admin_auth`
#

INSERT INTO sho_admin_auth VALUES (1, '1', '系統(tǒng)參數(shù)設置', '', 1, 0, '系統(tǒng)設置');
INSERT INTO sho_admin_auth VALUES (2, '2', '修改管理密碼', '', 2, 0, '系統(tǒng)設置');
INSERT INTO sho_admin_auth VALUES (3, '3', '管理帳戶設置', '', 3, 0, '系統(tǒng)設置');
INSERT INTO sho_admin_auth VALUES (4, '4', '會員類型設置', '', 4, 0, '系統(tǒng)設置');
INSERT INTO sho_admin_auth VALUES (5, '5', '其他系統(tǒng)設置', '', 5, 0, '系統(tǒng)設置');
INSERT INTO sho_admin_auth VALUES (6, '11', '網(wǎng)站欄目設置', '', 1, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (7, '12', '網(wǎng)站欄目刪除', '', 2, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (8, '13', '網(wǎng)站頁面設置', '', 3, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (9, '14', '界面風格設置', '', 4, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (10, '15', '自定表單設置', '', 5, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (11, '16', '社區(qū)分類設置', '', 6, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (12, '17', '網(wǎng)站專題設置', '', 7, 1, '網(wǎng)站設置');
INSERT INTO sho_admin_auth VALUES (13, '21', '文章頻道管理', '', 1, 2, '內(nèi)容管理');
INSERT INTO sho_admin_auth VALUES (14, '22', '圖文頻道管理', '', 2, 2, '內(nèi)容管理');
INSERT INTO sho_admin_auth VALUES (15, '23', '下載頻道管理', '', 3, 2, '內(nèi)容管理');
INSERT INTO sho_admin_auth VALUES (16, '24', '網(wǎng)站標志管理', '', 4, 2, '內(nèi)容管理');
INSERT INTO sho_admin_auth VALUES (17, '25', '網(wǎng)站廣告管理', '', 5, 2, '內(nèi)容管理');
INSERT INTO sho_admin_auth VALUES (18, '51', '會員審核管理', '', 1, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (19, '52', '會員查詢管理', '', 2, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (20, '53', '會員資料查詢', '', 3, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (21, '54', '會員資料修改', '', 4, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (22, '55', '會員郵件發(fā)送', '', 5, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (23, '56', '會員權限管理', '', 6, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (24, '57', '會員公告管理', '', 7, 5, '會員管理');
INSERT INTO sho_admin_auth VALUES (25, '61', '反饋信息管理', '', 1, 6, '信息管理');
INSERT INTO sho_admin_auth VALUES (26, '62', '社區(qū)評論管理', '', 2, 6, '信息管理');
INSERT INTO sho_admin_auth VALUES (27, '71', '訪問統(tǒng)計系統(tǒng)', '', 1, 7, '輔助工具');
INSERT INTO sho_admin_auth VALUES (28, '72', '網(wǎng)站數(shù)據(jù)備份', '', 2, 7, '輔助工具');
INSERT INTO sho_admin_auth VALUES (29, '73', '投票調(diào)查系統(tǒng)', '', 3, 7, '輔助工具');
INSERT INTO sho_admin_auth VALUES (30, '74', '友情鏈接系統(tǒng)', '', 4, 7, '輔助工具');
INSERT INTO sho_admin_auth VALUES (31, '75', '軟件升級更新', '', 5, 7, '輔助工具');
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構 `sho_admin_rights`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_admin_rights`
#

INSERT INTO sho_admin_rights VALUES (176, '74', 'admin');
INSERT INTO sho_admin_rights VALUES (175, '73', 'admin');
INSERT INTO sho_admin_rights VALUES (174, '72', 'admin');
INSERT INTO sho_admin_rights VALUES (173, '71', 'admin');
INSERT INTO sho_admin_rights VALUES (172, '62', 'admin');
INSERT INTO sho_admin_rights VALUES (171, '61', 'admin');
INSERT INTO sho_admin_rights VALUES (170, '57', 'admin');
INSERT INTO sho_admin_rights VALUES (169, '56', 'admin');
INSERT INTO sho_admin_rights VALUES (168, '55', 'admin');
INSERT INTO sho_admin_rights VALUES (167, '54', 'admin');
INSERT INTO sho_admin_rights VALUES (166, '53', 'admin');
INSERT INTO sho_admin_rights VALUES (165, '52', 'admin');
INSERT INTO sho_admin_rights VALUES (164, '51', 'admin');
INSERT INTO sho_admin_rights VALUES (163, '25', 'admin');
INSERT INTO sho_admin_rights VALUES (162, '24', 'admin');
INSERT INTO sho_admin_rights VALUES (161, '23', 'admin');
INSERT INTO sho_admin_rights VALUES (160, '22', 'admin');
INSERT INTO sho_admin_rights VALUES (159, '21', 'admin');
INSERT INTO sho_admin_rights VALUES (158, '17', 'admin');
INSERT INTO sho_admin_rights VALUES (157, '16', 'admin');
INSERT INTO sho_admin_rights VALUES (156, '15', 'admin');
INSERT INTO sho_admin_rights VALUES (155, '14', 'admin');
INSERT INTO sho_admin_rights VALUES (154, '13', 'admin');
INSERT INTO sho_admin_rights VALUES (153, '12', 'admin');
INSERT INTO sho_admin_rights VALUES (152, '11', 'admin');
INSERT INTO sho_admin_rights VALUES (151, '5', 'admin');
INSERT INTO sho_admin_rights VALUES (150, '4', 'admin');
INSERT INTO sho_admin_rights VALUES (149, '3', 'admin');
INSERT INTO sho_admin_rights VALUES (148, '2', 'admin');
INSERT INTO sho_admin_rights VALUES (147, '1', 'admin');
INSERT INTO sho_admin_rights VALUES (177, '75', 'admin');
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_dl`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_advs_dl`
#

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

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_float`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_advs_float`
#

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

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_lb`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_advs_lb`
#

INSERT INTO sho_advs_lb VALUES (1, '2006年第一學期開學典禮', 'advs/1164663474.jpg', 'http://', 1);
INSERT INTO sho_advs_lb VALUES (2, '學校食堂整修一新', 'advs/1164663610.jpg', 'http://', 2);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_left`
#

CREATE TABLE sho_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;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_advs_left`
#

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

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_page`
#

CREATE TABLE sho_advs_page (
  id int(4) NOT NULL auto_increment,
  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,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數(shù)據(jù)庫內(nèi)容 `sho_advs_page`
#

INSERT INTO sho_advs_page VALUES (1, '寬屏橫幅廣告[990*100]', 990, 100, 'gif', 'advs/1156181602.jpg', 'http://', '_self', 0, 0);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構 `sho_advs_pop`
#

CREATE TABLE sho_advs_pop (
  id int(12) NOT NULL auto_increment,
  title text,
  body text,
  ifpop int(1) default NULL,
  popwidth int(10) default NULL,
  popheight int(10) default NULL,
  popleft int(10) default NULL,
12 3 4 5 下一頁
?? 文件大小 3010 K
?? 上傳用戶 a6810121
?? 所屬分類 Internet/網(wǎng)絡編程
??? 相關標簽

#源碼 #管理網(wǎng)
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? db_zh_cn_utf8.sql

?? 快捷鍵說明
