db_tjzcd-20040112133039.sql

来自「集成了投票调查、流量统计、文件上传、留言版、论坛、软件下载、文章赏析、通讯录、网」· SQL 代码 · 共 349 行 · 第 1/5 页

# chinaifc, Open Source E-Commerce Solutions
# http://www.chinaifc.com
#
# Database Backup For 星星安利世界
# Copyright (c) 2004 陈琢
#
# Database: tjzcd
# Database Server: localhost
#
# Backup Date: 2004/01/12 13:30:36

drop table if exists address_book;
create table address_book (
  customers_id int(11) default '0' not null ,
  address_book_id int(11) default '1' not null ,
  entry_gender char(1) not null ,
  entry_company varchar(32) ,
  entry_firstname varchar(32) not null ,
  entry_lastname varchar(32) not null ,
  entry_street_address varchar(64) not null ,
  entry_suburb varchar(32) ,
  entry_postcode varchar(10) not null ,
  entry_city varchar(32) not null ,
  entry_state varchar(32) ,
  entry_country_id int(11) default '0' not null ,
  entry_zone_id int(11) default '0' not null ,
  PRIMARY KEY (address_book_id, customers_id)
);


drop table if exists address_format;
create table address_format (
  address_format_id int(11) not null auto_increment,
  address_format varchar(128) not null ,
  address_summary varchar(48) not null ,
  PRIMARY KEY (address_format_id)
);

insert into address_format (address_format_id, address_format, address_summary) values ('1', '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('2', '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('3', '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('4', '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('5', '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');

drop table if exists administrators;
create table administrators (
  admin_id int(2) not null auto_increment,
  admin_name varchar(20) not null ,
  admin_pass varchar(40) not null ,
  admin_date_added datetime default '0000-00-00 00:00:00' not null ,
  admin_last_modified datetime default '0000-00-00 00:00:00' not null ,
  allowed_pages varchar(255) not null ,
  PRIMARY KEY (admin_id)
);

insert into administrators (admin_id, admin_name, admin_pass, admin_date_added, admin_last_modified, allowed_pages) values ('1', 'chenzhuo_29', '31035c56a4da2e4fd4892dd5da92b911:13', '0000-00-00 00:00:00', '2004-01-11 23:52:59', '*');
insert into administrators (admin_id, admin_name, admin_pass, admin_date_added, admin_last_modified, allowed_pages) values ('2', 'root', 'fc0fcc8f894898cd7cad233a503c88b6:8d', '2004-01-12 00:00:00', '2004-01-12 09:35:51', '*');

drop table if exists banners;
create table banners (
  banners_id int(11) not null auto_increment,
  banners_title varchar(64) not null ,
  banners_url varchar(64) not null ,
  banners_image varchar(64) not null ,
  banners_group varchar(10) not null ,
  banners_html_text text ,
  expires_impressions int(7) default '0' ,
  expires_date datetime ,
  date_scheduled datetime ,
  date_added datetime default '0000-00-00 00:00:00' not null ,