db_tjzcd-20040112133039.sql

集成了投票调查、流量统计、文件上传、留言版、论坛、软件下载、文章赏析、通讯录、网上购物 等板块 管理账户为peilei 密码为800901

  url varchar(100) ,
  img varchar(100) ,
  text mediumtext ,
  author varchar(20) ,
  date varchar(20) not null ,
  shownews smallint(6) ,
  useurl smallint(6) default '0' not null ,
  html smallint(6) default '0' not null ,
  PRIMARY KEY (id)
);

insert into chinanew (id, title, url, img, text, author, date, shownews, useurl, html) values ('2', 'F60在线商店试开业！！', '', '', '商品正在完善中...', '', '2004.01.11', '1', '1', '0');

drop table if exists configuration;
create table configuration (
  configuration_id int(11) not null auto_increment,
  configuration_title varchar(64) not null ,
  configuration_key varchar(64) not null ,
  configuration_value varchar(255) not null ,
  configuration_description varchar(255) not null ,
  configuration_group_id int(11) default '0' not null ,
  sort_order int(5) ,
  last_modified datetime ,
  date_added datetime default '0000-00-00 00:00:00' not null ,
  use_function varchar(255) ,
  set_function varchar(255) ,
  PRIMARY KEY (configuration_id)
);

insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('1', '商店名称', 'STORE_NAME', '星星安利世界', '你商店的名称', '1', '1', '2004-01-11 22:41:40', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('2', '商店管理员姓名', 'STORE_OWNER', '陈琢', '站长名称', '1', '2', '2004-01-11 22:41:15', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('3', 'E-Mail地址', 'STORE_OWNER_EMAIL_ADDRESS', '[e-mail]', '网站邮件地址', '1', '3', '2004-01-11 22:42:20', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('4', '发E-Mail地址', 'EMAIL_FROM', '[e-mail]', '为客户发送邮件显示地址', '1', '4', '2004-01-11 22:42:31', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('5', '省份', 'STORE_COUNTRY', '222', '本店省份查找', '1', '6', '2002-07-23 21:05:30', '2002-07-19 22:33:55', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('6', '地市', 'STORE_ZONE', '88', '本店地市查找', '1', '7', '2002-08-19 11:14:39', '2002-07-19 22:33:55', 'tep_get_zone_name', 'tep_cfg_pull_down_zone_list(');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('7', 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', NULL, '2002-07-19 22:33:55', NULL, 'tep_cfg_select_option(array(\'asc\', \'desc\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('8', 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', NULL, '2002-07-19 22:33:55', NULL, 'tep_cfg_select_option(array(\'products_name\', \'date_expected\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('9', '默认的流通语言', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', '切换默认语言', '1', '10', '2002-08-19 11:15:26', '2002-07-19 22:33:55', '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('10', '发送额外电子邮件到', 'SEND_EXTRA_ORDER_EMAILS_TO', '', '发送额外电子邮件到下面格式：名字1<email@address1>, 名字2 <email@address2>', '1', '11', '2002-08-19 11:17:08', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('11', '使用搜索引', 'SEARCH_ENGINE_FRIENDLY_URLS', 'true', '安全使用搜索引', '1', '12', '2004-01-12 00:47:17', '2002-07-19 22:33:55', '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('12', '加入商品以后', 'DISPLAY_CART', 'true', '加入商品以后回到商店', '1', '14', '2002-08-19 11:21:31', '2002-07-19 22:33:55', '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('13', '允许客户告诉朋友', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'true', '允许客户告诉朋友本店信息', '1', '15', '2004-01-12 00:47:40', '2002-07-19 22:33:55', '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('14', '默认搜索', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', '默认搜索', '1', '17', '2002-08-19 11:23:16', '2002-07-19 22:33:55', '', 'tep_cfg_select_option(array(\'and\', \'or\'),');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('15', '显示地址和电话', 'STORE_NAME_ADDRESS', '北京市', '在登录本店后可以显示你地址电话，但不对外', '1', '18', '2004-01-11 22:45:48', '2002-07-19 22:33:55', '', 'tep_cfg_textarea(');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('16', '姓名', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', '最少字符', '2', '1', '2002-08-19 11:25:12', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('17', '称呼', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', '最少字符', '2', '2', '2004-01-11 22:46:28', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('18', '出生年月', 'ENTRY_DOB_MIN_LENGTH', '10', '最少字符', '2', '3', '2002-08-19 11:26:03', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('19', 'E-Mail地址', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', '最少字符', '2', '4', '2002-08-19 11:26:36', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('20', '联系地址', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', '最少字符', '2', '5', '2002-08-19 11:26:56', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('21', '公司', 'ENTRY_COMPANY_LENGTH', '2', '最少字符', '2', '6', '2002-08-19 11:27:10', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('22', '邮政编码', 'ENTRY_POSTCODE_MIN_LENGTH', '6', '最少字符', '2', '7', '2002-08-17 19:47:52', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('23', '城市', 'ENTRY_CITY_MIN_LENGTH', '3', '最少字符', '2', '8', '2002-08-19 11:27:30', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('24', '身份证号码码', 'ENTRY_STATE_MIN_LENGTH', '15', '最少字符', '2', '9', '2002-08-17 19:47:59', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('25', '省份', 'ENTRY_TELEPHONE_MIN_LENGTH', '11', '最少字符', '2', '10', '2002-08-17 19:48:06', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('26', '密码', 'ENTRY_PASSWORD_MIN_LENGTH', '6', '最少字符', '2', '11', '2002-08-17 19:48:12', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('27', '信用卡者姓名', 'CC_OWNER_MIN_LENGTH', '3', '最少字符', '2', '12', '2002-08-19 11:29:34', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('28', '信用卡数', 'CC_NUMBER_MIN_LENGTH', '10', '最少字符', '2', '13', '2002-08-19 11:30:01', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('29', '调查', 'REVIEW_TEXT_MIN_LENGTH', '15', '最少字符', '2', '14', '2002-08-17 19:48:20', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('30', '畅销商品', 'MIN_DISPLAY_BESTSELLERS', '1', '最少字符', '2', '15', '2002-08-19 11:30:30', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('31', '购买', 'MIN_DISPLAY_ALSO_PURCHASED', '1', '最少字符陈列', '2', '16', '2002-08-19 11:31:04', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('32', '地址薄', 'MAX_ADDRESS_BOOK_ENTRIES', '5', '最大允许数', '3', '1', '2002-08-19 11:31:53', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('33', '搜索结果', 'MAX_DISPLAY_SEARCH_RESULTS', '20', '商品的陈列数', '3', '2', '2002-08-19 11:32:24', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('34', '每页显示数', 'MAX_DISPLAY_PAGE_LINKS', '10', '最大允许数', '3', '3', '2004-01-11 22:48:08', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('35', '特价商品', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '3', '允许最大陈列数', '3', '4', '2004-01-11 22:49:05', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('36', '新的商品模块', 'MAX_DISPLAY_NEW_PRODUCTS', '5', '新的商品陈列数', '3', '5', '2004-01-11 22:49:38', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('37', '期待商品', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', '最大允许商品陈列数', '3', '6', '2002-08-19 11:34:45', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('38', '厂商列表', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', '最大允许数', '3', '7', '2002-08-19 11:35:41', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('39', '厂商商品数', 'MAX_MANUFACTURERS_LIST', '10', '最大允许数陈列数', '3', '7', '2004-01-11 22:50:01', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('40', '厂商名字长度', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '50', '最大允许数', '3', '8', '2004-01-11 22:50:24', '2002-07-19 22:33:55', '', '');
insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('41', '新的调查数', 'MAX_DISPLAY_NEW_REVIEWS', '6', '最大允许数陈列数', '3', '9', '2002-08-19 11:37:52', '2002-07-19 22:33:55', '', '');