/web/test/chat/shoutitout/mysql.txt |
---|
0,0 → 1,22 |
CREATE TABLE badwords ( |
id int(11) NOT NULL auto_increment, |
words text NOT NULL, |
PRIMARY KEY (id), |
UNIQUE KEY id (id), |
KEY id_2 (id) |
) TYPE=MyISAM; |
INSERT INTO badwords VALUES (1, 'fuck,shit,piss,cunt,asshole,motherfucker,dick,fuk,blow,sex,tit,pussy,slut,whore,cum,horny,oral,anal,bitch,nigger,crap,bastard,clit,felacio,pik,kusse,fisse,røv,sperm,spasser,cock,kusse,skede,patter,idiot,perker,neger,blowjob,pis,bøsse,numse,lort,sexy,bitch,bitches,blowjobbers,Bitch,Blowjob,Ass'); |
# -------------------------------------------- |
CREATE TABLE shout ( |
id int(11) NOT NULL auto_increment, |
ip varchar(20) NOT NULL default '', |
link varchar(30) NOT NULL default '', |
name_id varchar(30) NOT NULL default '', |
text text NOT NULL, |
time varchar(40) NOT NULL default '', |
PRIMARY KEY (id), |
KEY id (id) |
) TYPE=MyISAM; |