CREATE TABLE admin (
  username varchar(30) NOT NULL default '',
  password varchar(30) NOT NULL default '',
  PRIMARY KEY  (username)
) TYPE=MyISAM;

INSERT INTO `admin` VALUES ('admin', 'admin');


CREATE TABLE book_cat (
  id int(10) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  image varchar(100) NOT NULL default '',
  describes varchar(255) NOT NULL default '',
  order_cat int(11) default '0',
  sub int(11) default '0',
  vis int(11) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


CREATE TABLE book_all (
  id int(10) NOT NULL auto_increment,
  name varchar(250) default NULL,
  image varchar(250) default NULL,
  writerbook varchar(250) default NULL,
 idfiles int(11) default '0',
  downloads varchar(250) default NULL,
  size varchar(250) default NULL,
  ext varchar(250) default NULL,
  example varchar(250) default NULL,
  text text,
  date varchar(255) NOT NULL default '0',
  day varchar(255) NOT NULL default '',
  tim varchar(255) NOT NULL default '',
  vis int(11) default '0',
  cat int(11) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE `ads` (
  `adsid` int(10) NOT NULL auto_increment,
  `name` varchar(250) default NULL,
  `image` varchar(250) default NULL,
  `url` varchar(250) default NULL,
  `vis` int(11) default '0',
  `cat` int(11) default '0',
  PRIMARY KEY  (`adsid`)
) TYPE=MyISAM;

CREATE TABLE `hcounter` (
  `today` int(11) NOT NULL default '0',
  `thismonth` int(11) NOT NULL default '0',
  `thisyear` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  `total` int(11) NOT NULL default '0'
) TYPE=MyISAM COMMENT='Table for daily ,monthly and yearly counter';

INSERT INTO `hcounter` VALUES (1, 1, 1, 1098580596, 0);


CREATE TABLE `hips` (
  `time_in` int(11) NOT NULL default '0',
  `userip` varchar(15) NOT NULL default '0',
  `time_out` int(11) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO `hips` VALUES (1098580596, '127.0.0.1', 1098582396);

CREATE TABLE online (
   OnlineID int(9) NOT NULL auto_increment,
   IP varchar(100) NOT NULL,
   Time varchar(100) NOT NULL,
   PRIMARY KEY (OnlineID)
);


CREATE TABLE book_files (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
namemd5 VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
vis int(11) default '0',
content MEDIUMBLOB NOT NULL,
PRIMARY KEY(id)
);