searchnet.sql

来自「本系统是一个跨平台的搜索引擎」· SQL 代码 · 共 21 行

DROP DATABASE IF EXISTS SearchNet;
CREATE DATABASE SearchNet DEFAULT CHARSET=utf8;
USE SearchNet;

DROP TABLE IF EXISTS `qws$_search_pre`;
CREATE TABLE `qws$_search_pre` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(250) default NULL,
  `CreateDate` datetime default '2007-04-04 00:00:00',
  `visite` char(1) default 'N',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

DROP TABLE IF EXISTS `qws$_search_local`;
CREATE TABLE `qws$_search_local` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(250) default NULL,
  `CreateDate` datetime default '2007-04-04 00:00:00',
  `visite` char(1) default 'N',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB ;