Citation:
CREATE TABLE spider (
spider_id mediumint(9) NOT NULL auto_increment,
file varchar(127) NOT NULL,
first_words mediumtext NOT NULL,
upddate timestamp(14),
md5 varchar(50),
site_id mediumint(9) DEFAULT '0' NOT NULL,
path varchar(127) NOT NULL,
num_words int(11) DEFAULT '1' NOT NULL,
last_modified timestamp(14),
filesize int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (spider_id),
KEY site_id (site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
Citation:
if exists (select 1
from sysobjects
where id = object_id('spider')
and type = 'U')
drop table spider
go
/*==============================================================*/
/* Table: spider */
/*==============================================================*/
create table spider (
spider_id int identity,
"file" varchar(127) not null,
first_words text not null,
upddate timestamp null,
md5 varchar(50) null,
site_id int not null default 0,
path varchar(127) not null,
num_words int not null default 1,
last_modified timestamp null,
filesize int not null default 0,
constraint PK_SPIDER primary key (spider_id),
constraint site_id unique (site_id)
)
go