Location: PHPKode > scripts > Create Your Own Directory > cms/admin/tables.php
<?php
$result1 = @mysql_query("create table comments(id BIGINT NOT NULL UNIQUE AUTO_INCREMENT, uid varchar(6), review text, 
url varchar(150), ip varchar(25), name varchar(50), email varchar(50), dat date, status varchar(10))"); 
$result2 = @mysql_query("create table colors(border varchar(8), bmessage varchar(8), bgcolor varchar(8), 
messagebg varchar(8), message varchar(8), infobg varchar(8), info varchar(8), others varchar(8))"); 
$result3 = @mysql_query("insert into colors values('green','white','#ccffcc','#dddddd','#333333','#ddffee','#0000dd','#343434')"); 
$result4 = @mysql_query("create table rating(id BIGINT NOT NULL UNIQUE AUTO_INCREMENT,ip varchar(25),url varchar(250),dat date,rateval int,rid int)");
$result5=@mysql_query("create table type(id int auto_increment primary key, name varchar(50),parentid int,des varchar(200))");
$result6=@mysql_query("create table views(id int auto_increment primary key, vdate date, who varchar(50),vip varchar(50),cvid int,url varchar(100))");
$result7=@mysql_query("create table referral(id int auto_increment primary key, referral int,refdate date, who varchar(50),refip varchar(50),crid int)");
$result8 =@mysql_query("create table favourite(id BIGINT NOT NULL UNIQUE AUTO_INCREMENT,addeddate date, favid int, usrid int)",$link);
$result9 =@mysql_query("create table temptable (name varchar(25) UNIQUE)",$link);
$result10 =@mysql_query("create table filter (id int auto_increment primary key,word varchar(50),ip varchar(17))",$link);
$result11=@mysql_query("create table user(UserId INT NOT NULL AUTO_INCREMENT,UserName varchar(30) UNIQUE,PassWrd varchar(30),passcode varchar(50),email varchar(75) unique,ContactNo varchar(20),Address varchar(100),ActivateON DATE,status varchar(15) , ip varchar(15),primary key(UserId))",$link);
$result12=@mysql_query("create table cnt(cntid  int auto_increment primary key, tid int, contents text,usrid int ,status varchar(5),ip varchar(20), upddate date, adddate date, view int)",$link);
$result13=@mysql_query("create table cntfields(catid int,fname varchar(100),ftype varchar(100),inputtype varchar(50),defaultval text, contentpg int,mandatory int )",$link);
$result14=@mysql_query("create table images(field varchar(100),image varchar(100),width int, height int, imgid int, img blob, typ varchar(20),id int, link text, uwidth int, uheight int)",$link);
$result15=@mysql_query("insert into images values('home','img1.gif',8,43,1,null,'default',1,'http://www.freephpcms.com/demo/cms/index.php',0,0)",$link);
$result16=@mysql_query("insert into images values('search','img2.gif',8,43,2,null,'default',2,'http://www.freephpcms.com/demo/cms/functions/search.php',0,0)",$link);
$result17=@mysql_query("insert into images values('latest','img3.gif',8,43,3,null,'default',3,'http://www.freephpcms.com/demo/cms/functions/newlyadded.php?sub=new',0,0)",$link);
$result18=@mysql_query("insert into images values('visited','img4.gif',8,43,4,null,'default',4,'http://www.freephpcms.com/demo/cms/functions/newlyadded.php?sub=visited',0,0)",$link);
$result19=@mysql_query("insert into images values('rated','img5.gif',8,43,5,null,'default',5,'http://www.freephpcms.com/demo/cms/functions/newlyadded.php?sub=rated',0,0)",$link);
$result20=@mysql_query("insert into images values('signup','img6.gif',8,43,6,null,'default',6,'http://www.freephpcms.com/demo/cms/HRAS/login/useradd.php',0,0)",$link);
$result21=@mysql_query("insert into images values('folder','img7.gif',25,27,7,null,'default',7,'',0,0)",$link);
$result22=@mysql_query("insert into images values('uparrow','img8.gif',12,13,8,null,'default',8,'',0,0)",$link);
$result23=@mysql_query("insert into images values('downarrow','img9.gif',12,13,9,null,'default',9,'',0,0)",$link);
$result24=@mysql_query("insert into images values('sitename','img10.gif',800,120,10,null,'default',10,'',0,0)",$link);
$result25=@mysql_query("insert into images values('background','img11.gif',8,43,11,null,'default',11,'',0,0)",$link);
$result26=@mysql_query("insert into images values('late','img12.gif',79,69,12,null,'default',12,'',0,0)",$link);
$result27=@mysql_query("insert into images values('menu-seperator','img13.gif',2,43,13,null,'default',13,'',0,0)",$link);
$result28=@mysql_query("insert into images values('tree-bg','img14.gif',160,9,14,null,'default',14,'',0,0)",$link);
$result29=@mysql_query("insert into images values('foot1','img15.gif',368,113,15,null,'default',15,'',0,0)",$link);
$result30=@mysql_query("insert into images values('foot2','img16.gif',368,113,16,null,'default',16,'',0,0)",$link);
$result31=@mysql_query("insert into images values('foot3','img17.gif',2,22,17,null,'default',17,'',0,0)",$link);
$result32=@mysql_query("insert into images values('tablebk','img18.gif',2,22,18,null,'default',18,'',0,0)",$link);
$result33=@mysql_query("insert into images values('login-button','img19.gif',75,30,19,null,'default',19,'',0,0)",$link);
$result34=@mysql_query("insert into images values('next-button','img20.gif',67,20,20,null,'default',20,'',0,0)",$link);
$result35=@mysql_query("insert into images values('prev-button','img21.gif',67,20,21,null,'default',21,'',0,0)",$link);
$result36 =@mysql_query("create table defaulttab(layout int ,mailid varchar(200),userdomain varchar(500))",$link);
$result37=@mysql_query("create table visitor(id int auto_increment primary key, vcid int,gvisitor int, views int,usertype varchar(100),vip int)");
?>
Return current item: Create Your Own Directory