?? db_zh_cn_utf8.sql

?? 學校管理網站源碼,功能較好的源碼.下載試用下
?? SQL
?? 第 1 頁 / 共 5 頁
字號:
INSERT INTO sho_default_rights VALUES (113, 11, 8, 'func', 0);
INSERT INTO sho_default_rights VALUES (130, 12, 30, 'func', 0);
INSERT INTO sho_default_rights VALUES (129, 12, 10, 'func', 0);
INSERT INTO sho_default_rights VALUES (128, 12, 8, 'func', 0);
INSERT INTO sho_default_rights VALUES (127, 12, 7, 'func', 0);
INSERT INTO sho_default_rights VALUES (126, 12, 4, 'con', 0);
INSERT INTO sho_default_rights VALUES (125, 12, 3, 'menu', 0);
INSERT INTO sho_default_rights VALUES (124, 12, 2, 'func', 0);
INSERT INTO sho_default_rights VALUES (123, 12, 6, 'func', 0);
# --------------------------------------------------------

#
# 數據表的結構 `sho_down_cat`
#

CREATE TABLE sho_down_cat (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  menuid int(10) NOT NULL default '3',
  cat char(100) default NULL,
  xuhao int(12) default NULL,
  catpath char(255) default NULL,
  nums int(20) default NULL,
  secure int(1) NOT NULL default '0',
  tj int(1) NOT NULL default '0',
  PRIMARY KEY  (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數據庫內容 `sho_down_cat`
#

INSERT INTO sho_down_cat VALUES (1, 0, 5, '課件下載', 1, '0001:', 5, 0, 0);
INSERT INTO sho_down_cat VALUES (2, 0, 5, '模擬試卷', 2, '0002:', 0, 0, 0);
INSERT INTO sho_down_cat VALUES (3, 0, 5, '視頻下載', 3, '0003:', 0, 0, 0);
# --------------------------------------------------------

#
# 數據表的結構 `sho_down_con`
#

CREATE TABLE sho_down_con (
  id int(12) NOT NULL auto_increment,
  menuid int(10) NOT NULL default '3',
  catid int(12) default NULL,
  catpath varchar(255) default NULL,
  title varchar(255) default NULL,
  memo text NOT NULL,
  body text,
  dtime int(11) default '0',
  xuhao int(5) default '0',
  cl int(20) default NULL,
  tj int(1) default NULL,
  iffb int(1) default '0',
  filesize varchar(30) default NULL,
  url varchar(255) default NULL,
  `type` varchar(30) NOT NULL default '',
  src varchar(150) NOT NULL default '',
  uptime int(11) default '0',
  author varchar(100) default NULL,
  source varchar(100) default NULL,
  memberid varchar(100) default NULL,
  proj varchar(255) NOT NULL default '',
  secure int(11) NOT NULL default '0',
  prop1 varchar(255) NOT NULL default '',
  prop2 varchar(255) NOT NULL default '',
  prop3 varchar(255) NOT NULL default '',
  prop4 varchar(255) NOT NULL default '',
  prop5 varchar(255) NOT NULL default '',
  prop6 varchar(255) NOT NULL default '',
  prop7 varchar(255) NOT NULL default '',
  prop8 varchar(255) NOT NULL default '',
  prop9 varchar(255) NOT NULL default '',
  prop10 varchar(255) NOT NULL default '',
  prop11 varchar(255) NOT NULL default '',
  prop12 varchar(255) NOT NULL default '',
  prop13 varchar(255) NOT NULL default '',
  prop14 varchar(255) NOT NULL default '',
  prop15 varchar(255) NOT NULL default '',
  prop16 varchar(255) NOT NULL default '',
  prop17 varchar(255) NOT NULL default '',
  prop18 varchar(255) NOT NULL default '',
  prop19 varchar(255) NOT NULL default '',
  prop20 varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數據庫內容 `sho_down_con`
#

INSERT INTO sho_down_con VALUES (1, 5, 1, '0001:', '余弦函數圖象演示', '', '', 1164658631, 1, 0, 0, 1, '1KB', 'down/html/download/test.rar', 'rar', 'down/html/download/test.rar', 1164658631, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_down_con VALUES (2, 5, 1, '0001:', '平行四邊形教學輔助演', '', '', 1164658685, 1, 0, 0, 1, '1KB', 'down/html/download/test.rar', 'rar', 'down/html/download/test.rar', 1164658685, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_down_con VALUES (3, 5, 1, '0001:', '高一集合第一課', '', '', 1164658783, 1, 0, 0, 1, '1KB', 'down/html/download/test.rar', 'rar', 'down/html/download/test.rar', 1164658783, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_down_con VALUES (4, 5, 1, '0001:', '橢圓的幾何性質', '', '', 1164658801, 1, 0, 0, 1, '1KB', 'down/html/download/test.rar', 'rar', 'down/html/download/test.rar', 1164658801, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_down_con VALUES (5, 5, 1, '0001:', '運用幾何畫板旋轉空間', '', '', 1164658825, 1, 1, 0, 1, '1KB', 'down/html/download/test.rar', 'rar', 'down/html/download/test.rar', 1164658825, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
# --------------------------------------------------------

#
# 數據表的結構 `sho_form`
#

CREATE TABLE sho_form (
  id int(3) NOT NULL auto_increment,
  field_caption varchar(200) NOT NULL default '',
  field_type int(1) NOT NULL default '0',
  field_size int(2) NOT NULL default '0',
  field_name varchar(200) NOT NULL default '',
  field_value varchar(255) NOT NULL default '',
  field_null int(1) NOT NULL default '0',
  value_repeat int(1) NOT NULL default '0',
  field_intro varchar(255) NOT NULL default '',
  use_field int(1) NOT NULL default '0',
  moveable int(1) NOT NULL default '0',
  xuhao int(3) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數據庫內容 `sho_form`
#

INSERT INTO sho_form VALUES (1, '留言標題', 1, 35, 'title', '', 1, 1, '', 1, 1, 1);
INSERT INTO sho_form VALUES (2, '留言內容', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO sho_form VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO sho_form VALUES (5, '聯系電話', 1, 30, 'tel', '', 0, 1, '', 0, 0, 5);
INSERT INTO sho_form VALUES (6, '聯系地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 6);
INSERT INTO sho_form VALUES (7, '電子郵件', 1, 35, 'email', '', 1, 1, '', 1, 1, 7);
INSERT INTO sho_form VALUES (8, '網址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 8);
INSERT INTO sho_form VALUES (9, 'QQ號碼', 1, 16, 'qq', '', 0, 1, '', 0, 0, 9);
INSERT INTO sho_form VALUES (10, '公司名稱', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO sho_form VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO sho_form VALUES (4, '性　　別', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 4);
INSERT INTO sho_form VALUES (12, '郵政編碼', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO sho_form VALUES (13, '傳真號碼', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO sho_form VALUES (14, '產品編號', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO sho_form VALUES (15, '產品名稱', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO sho_form VALUES (16, '訂購數量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO sho_form VALUES (19, '自定義一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO sho_form VALUES (18, '自定義二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO sho_form VALUES (17, '自定義三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO sho_form VALUES (20, '自定義四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO sho_form VALUES (21, '自定義五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO sho_form VALUES (22, '自定義六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO sho_form VALUES (23, '自定義七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------

#
# 數據表的結構 `sho_form_feedback`
#

CREATE TABLE sho_form_feedback (
  id int(12) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  content text NOT NULL,
  name varchar(200) NOT NULL default '',
  sex varchar(10) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  address varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  qq varchar(20) NOT NULL default '',
  company varchar(255) NOT NULL default '',
  company_address varchar(255) NOT NULL default '',
  zip varchar(6) NOT NULL default '',
  fax varchar(20) NOT NULL default '',
  products_id varchar(100) NOT NULL default '',
  products_name varchar(200) NOT NULL default '',
  products_num varchar(9) NOT NULL default '',
  custom1 text NOT NULL,
  custom2 text NOT NULL,
  custom3 text NOT NULL,
  custom4 text NOT NULL,
  custom5 text NOT NULL,
  custom6 text NOT NULL,
  custom7 text NOT NULL,
  ip varchar(20) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  look int(1) NOT NULL default '0',
  reversion int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數據庫內容 `sho_form_feedback`
#

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

#
# 數據表的結構 `sho_link`
#

CREATE TABLE sho_link (
  id int(12) NOT NULL auto_increment,
  showtype varchar(10) default NULL,
  name varchar(200) default NULL,
  url varchar(200) default NULL,
  xuhao int(5) default NULL,
  `type` varchar(20) default NULL,
  src varchar(20) default NULL,
  cl int(10) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的數據庫內容 `sho_link`
#

INSERT INTO sho_link VALUES (1, 'img', '鏈接一', 'http://www', 0, 'gif', 'link/1165134476.gif', 0);
INSERT INTO sho_link VALUES (2, 'img', '鏈接一', 'http://www', 0, 'gif', 'link/1165134479.gif', 0);
INSERT INTO sho_link VALUES (3, 'img', '鏈接一', 'http://www', 0, 'gif', 'link/1165134481.gif', 0);
# --------------------------------------------------------

#
# 數據表的結構 `sho_logo`
#

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

#
# 導出下面的數據庫內容 `sho_logo`
#

INSERT INTO sho_logo VALUES (1, 1, 0, 0, 'gif', 'images/logo.gif', '', '', 0, 0);
# --------------------------------------------------------

#
# 數據表的結構 `sho_member`
#

CREATE TABLE sho_member (
  memberid int(12) NOT NULL auto_increment,
  membertypeid int(3) default NULL,
  `user` varchar(30) default NULL,
  `password` varchar(50) default NULL,
  company varchar(255) default NULL,
  name varchar(255) default NULL,
  sex varchar(20) default NULL,
  birthday int(8) default NULL,
  zoneid int(10) default NULL,
  catid int(10) default NULL,
  addr varchar(255) default NULL,
  tel varchar(255) default NULL,
  mov varchar(255) default NULL,
  fax varchar(255) default NULL,
  postcode varchar(255) default NULL,
  email varchar(255) default NULL,
  url varchar(255) default NULL,
  passtype varchar(255) default NULL,
  passcode varchar(255) default NULL,
  qq varchar(100) default NULL,
  msn varchar(100) default NULL,
  maillist int(1) default NULL,
  bz text,
  checked int(1) default NULL,
  regtime int(11) default NULL,
?? 文件大小 3010 K
?? 上傳用戶 a6810121
?? 所屬分類 Internet/網絡編程
??? 相關標簽

#源碼 #管理網
?? 快捷鍵說明

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

?? db_zh_cn_utf8.sql

?? 快捷鍵說明
