# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : fashionshop
# --------------------------------------------------------

#
# Table structure for table 'adv'
#

CREATE TABLE adv (
   id int(11) NOT NULL auto_increment,
   alt varchar(150) NOT NULL,
   media varchar(150) NOT NULL,
   ftype char(1) NOT NULL,
   height int(5) DEFAULT '0' NOT NULL,
   width int(5) DEFAULT '0' NOT NULL,
   url varchar(200) NOT NULL,
   onpage tinyint(4) DEFAULT '0' NOT NULL,
   adgroup char(1) NOT NULL,
   position tinyint(4) DEFAULT '0' NOT NULL,
   homepage char(1) NOT NULL,
   homeshop char(1) NOT NULL,
   productpage char(1) NOT NULL,
   beauty char(1) NOT NULL,
   news char(1) NOT NULL,
   sort tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);