#-----------------------------------
#-- Database
#-----------------------------------

#CREATE DATABASE IF NOT EXISTS parssclient;
#USE parssclient;

USE antville;

#------------------------------
#-- Database-User
#------------------------------

GRANT SELECT,INSERT,UPDATE,DELETE ON antville.* TO antville@localhost IDENTIFIED
 BY 'antville';

#------------------------------
# Table structure for AV_FEEDSUBSCRIPTION
#------------------------------

CREATE TABLE AV_FEEDSUBSCRIPTION (
  FEEDSUBSCRIPTION_ID mediumint(10) NOT NULL default '0',
  FEEDSUBSCRIPTION_TITLE text,
  FEEDSUBSCRIPTION_RATING tinyint(255) default NULL,
  FEEDSUBSCRIPTION_COLOR varchar(255) default NULL,
  FEEDSUBSCRIPTION_F_SITE mediumint(10) default NULL,
  FEEDSUBSCRIPTION_F_FEED mediumint(10) default NULL,
  FEEDSUBSCRIPTION_F_USER_CREATOR mediumint(10) default NULL,
  FEEDSUBSCRIPTION_F_USER_MODIFIER mediumint(10) default NULL,
  FEEDSUBSCRIPTION_CREATETIME datetime default NULL,
  FEEDSUBSCRIPTION_MODIFYTIME datetime default NULL,
  PRIMARY KEY  (FEEDSUBSCRIPTION_ID)
) TYPE=MyISAM;

