db_tjzcd-20040112133039.sql

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

  date_status_change datetime ,
  status int(1) default '1' not null ,
  PRIMARY KEY (banners_id)
);

insert into banners (banners_id, banners_title, banners_url, banners_image, banners_group, banners_html_text, expires_impressions, expires_date, date_scheduled, date_added, date_status_change, status) values ('1', '吉鑫网络', 'http://www.chinaifc.com', 'banners/chinaifc.gif', '468x50', '', '0', NULL, NULL, '2002-07-19 22:33:55', NULL, '1');

drop table if exists banners_history;
create table banners_history (
  banners_history_id int(11) not null auto_increment,
  banners_id int(11) default '0' not null ,
  banners_shown int(5) default '0' not null ,
  banners_clicked int(5) default '0' not null ,
  banners_history_date datetime default '0000-00-00 00:00:00' not null ,
  PRIMARY KEY (banners_history_id)
);

insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('1', '1', '8', '0', '2002-07-19 22:34:06');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('2', '1', '64', '0', '2002-07-20 00:45:36');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('3', '1', '85', '0', '2002-07-23 19:20:25');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('4', '1', '48', '0', '2002-08-15 18:03:53');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('5', '1', '524', '0', '2002-08-16 07:07:49');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('6', '1', '8', '0', '2002-08-19 15:44:22');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('7', '1', '5', '0', '2002-08-22 10:03:05');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('8', '1', '166', '0', '2002-09-04 11:14:46');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('9', '1', '61', '0', '2002-09-06 08:57:26');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('10', '1', '3', '0', '2002-09-22 14:22:03');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('11', '1', '5', '0', '2004-01-11 14:41:29');

drop table if exists categories;
create table categories (
  categories_id int(11) not null auto_increment,
  categories_image varchar(64) ,
  parent_id int(11) default '0' not null ,
  sort_order int(3) ,
  date_added datetime ,
  last_modified datetime ,
  PRIMARY KEY (categories_id),
  KEY idx_categories_parent_id (parent_id)
);

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('31', NULL, '0', '6', '2004-01-11 23:26:12', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('29', NULL, '0', '4', '2004-01-11 23:23:48', '2004-01-11 23:24:01');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('27', NULL, '0', '2', '2004-01-11 23:22:29', '2004-01-11 23:24:28');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('30', NULL, '0', '5', '2004-01-11 23:25:33', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('28', NULL, '0', '3', '2004-01-11 23:23:06', '2004-01-11 23:24:42');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('26', NULL, '0', '1', '2004-01-11 23:21:53', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('32', NULL, '0', '7', '2004-01-11 23:27:04', '2004-01-11 23:31:10');

drop table if exists categories_description;
create table categories_description (
  categories_id int(11) default '0' not null ,
  language_id int(11) default '1' not null ,
  categories_name varchar(32) not null ,
  PRIMARY KEY (categories_id, language_id),
  KEY idx_categories_name (categories_name)
);

insert into categories_description (categories_id, language_id, categories_name) values ('28', '1', '衣洁系列产品');
insert into categories_description (categories_id, language_id, categories_name) values ('30', '1', '雅蜜润肤沐浴系列');
insert into categories_description (categories_id, language_id, categories_name) values ('27', '1', '家洁系列产品');
insert into categories_description (categories_id, language_id, categories_name) values ('26', '1', '安利纽崔莱营养保健食品');
insert into categories_description (categories_id, language_id, categories_name) values ('29', '1', '丝婷美发系列');
insert into categories_description (categories_id, language_id, categories_name) values ('31', '1', '丽齿健口腔护理系列');
insert into categories_description (categories_id, language_id, categories_name) values ('32', '1', '雅姿美容化妆品');

drop table if exists chinanew;
create table chinanew (
  id int(10) unsigned not null auto_increment,
  title varchar(100) not null ,