CREATE TABLE `arti_conf` (
`open` VARCHAR( 2 ) NOT NULL
);

CREATE TABLE `arti_genom` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 150 ) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL ,
`price2` INT NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);

CREATE TABLE `arti_odezhda` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 150 ) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL ,
`price2` INT NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);

CREATE TABLE `arti_oruzhie` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 150 ) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL ,
`price2` INT NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);

CREATE TABLE `arti_pechati` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 150 ) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL ,
`price2` INT NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);

CREATE TABLE `arti_svitki` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 150 ) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL ,
`price2` INT NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);


ALTER TABLE `user` ADD `arti_genom` VARCHAR( 150 ) NOT NULL ;
ALTER TABLE `user` ADD `arti_oruzhie` VARCHAR( 150 ) NOT NULL ;
ALTER TABLE `user` ADD `arti_odezhda` VARCHAR( 150 ) NOT NULL ;
ALTER TABLE `user` ADD `arti_pechati` VARCHAR( 150 ) NOT NULL ;
ALTER TABLE `user` ADD `arti_svitki` VARCHAR( 150 ) NOT NULL ;
ALTER TABLE `user` ADD `rie` BIGINT  NOT NULL ;
ALTER TABLE `user` ADD `ank_rang` VARCHAR( 32 ) NOT NULL ;

