Файл: soc-set/moduls/fermer/FERMA_BAZA.txt
Строк: 155
--
-- Структура таблицы `2news`
--
CREATE TABLE IF NOT
EXISTS `2news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg`
varchar(10000) DEFAULT NULL,
`time` int(11) NOT NULL,
`title`
varchar(32) DEFAULT NULL,
`main_time` int(11) NOT NULL DEFAULT '0',
`link` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
KEY `time`
(`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `2news_komm`
--
CREATE TABLE IF NOT
EXISTS `2news_komm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT
NULL,
`id_2news` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `2news_read`
--
CREATE TABLE IF NOT
EXISTS `2news_read` (
`id_2news` int(11) NOT NULL,
`id_user` int(11)
NOT NULL,
KEY `id_2news` (`id_2news`,`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COMMENT='Сведения о прочтении
новости';
--
--------------------------------------------------------
--
--
Структура таблицы `fermer_dog`
--
CREATE TABLE IF NOT
EXISTS `fermer_dog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL,
`time` varchar(1024) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `fermer_gr`
--
CREATE TABLE IF NOT
EXISTS `fermer_gr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL,
`semen` int(11) NOT NULL,
`woter` int(11) NOT NULL
DEFAULT '0',
`kol` varchar(1024) DEFAULT NULL,
`time` varchar(1024)
DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`fermer_name`
--
CREATE TABLE IF NOT EXISTS `fermer_name` (
`id`
int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(1024) NOT
NULL,
`cena` varchar(1024) NOT NULL,
`dohod` varchar(1024) NOT
NULL,
`rand1` varchar(1024) NOT NULL,
`rand2` varchar(1024) NOT
NULL,
`oput` varchar(1024) NOT NULL,
`time` varchar(1024) DEFAULT
NULL,
`level` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
INSERT INTO
`fermer_name` VALUES
(1,'Белая
репа','150','10','15','18','20','18000',0),
(2,'Морковь','200','15','14','16','35','21600',0),
(3,'Кукуруза','500','5','100','120','50','36000',0),
(4,'Картофель','650','13','50','55','60','72000',0),
(5,'Баклажан','700','35','20','25','65','129600',0),
(6,'Помидор','800','40','20','25','70','172800',5),
(7,'Горох','850','50','17','22','75','172800',5),
(8,'Перец
чили','900','60','15','19','80','216000',6),
(9,'Тыква','1000','100','10','15','100','216000',6),
(10,'Яблоко','1500','20','75','90','120','259200',7),
(11,'Клубника','3000','100','300','330','200','259200',10),
(12,'Арбуз','5000','1000','5','10','400','302400',11),
(13,'Банан','6000','50','300','325','800','302400',13),
(14,'Персик','8000','60','133','160','1100','345600',15),
(15,'Апельсин','10000','100','100','140','1500','345600',18),
(16,'Виноград','13000','50','260','300','2000','388800',20),
(17,'Лимон','15000','150','100','140','2500','345600',20),
(18,'Ананас','18000','200','90','110','3000','388800',21),
(19,'Глаз
дракона','20000','200','200','230','3500','345600',22),
(20,'Вишня','22000','20','1100','1200','4000','388800',35),
(21,'Манго','23000','100','230','260','4500','388800',28),
(22,'Киви','26000','200','130','150','5000','432000',30),
(23,'Пшеница','28000','30','933','1000','5500','432000',32),
(24,'Груша','30000','100','300','350','6000','432000',35),
(25,'Арахис','33000','50','660','710','6500','432000',38),
(26,'Сахарная
трость','38000','200','190','230','7000','518400',40),
(27,'Какао','45000','50','900','950','7500','518400',45) ;
--
--
Структура таблицы `fermer_sclad`
--
CREATE TABLE IF NOT
EXISTS `fermer_sclad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`semen` int(11) NOT NULL,
`kol` int(11)
NOT NULL,
`time` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `fermer_semen`
--
CREATE TABLE IF NOT
EXISTS `fermer_semen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`semen` int(11) NOT NULL,
`kol` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `fermer_udobr`
--
CREATE TABLE IF NOT
EXISTS `fermer_udobr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`udobr` int(11) NOT NULL,
`kol` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `fermer_udobr_name`
--
CREATE TABLE
IF NOT EXISTS `fermer_udobr_name` (
`id` int(10) unsigned NOT NULL
AUTO_INCREMENT,
`name` varchar(1024) NOT NULL,
`cena` varchar(1024)
NOT NULL,
`time` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
INSERT INTO
`fermer_udobr_name` VALUES
(1,'Удобрение
Простое','50','3600'),
(2,'Удобрение','200','14400'),
(3,'Супер
Удобрение','500','18000'),
(4,'Секретное
Удобрение','1000','36000') ;
--
-- Структура
таблицы `fermer_vor`
--
CREATE TABLE IF NOT EXISTS `fermer_vor`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`gr` int(11) DEFAULT NULL,
`time` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `fin_in`
--
CREATE TABLE IF NOT
EXISTS `fin_in` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`oper` varchar(255) NOT
NULL,
`cena` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `fin_oper`
--
CREATE TABLE IF NOT
EXISTS `fin_oper` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`oper` varchar(255) NOT
NULL,
`cena` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `islam_club`
--
CREATE TABLE IF NOT
EXISTS `islam_club` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`msg`
varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_closet`
--
CREATE TABLE IF NOT
EXISTS `k_closet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid`
int(11) NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT
NULL,
`opis` varchar(512) NOT NULL,
`path` varchar(15) NOT NULL,
`type` varchar(15) NOT NULL,
`cena` int(11) NOT NULL,
`pol` int(11)
NOT NULL,
`sex` int(11) NOT NULL,
`shik` int(11) NOT NULL,
`del`
int(11) NOT NULL,
`sport` int(11) NOT NULL,
`epat` int(11) NOT
NULL,
`glam` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_reeltor`
--
CREATE TABLE IF NOT
EXISTS `k_reeltor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(50) NOT NULL,
`opis` varchar(512) NOT NULL,
`path`
varchar(15) NOT NULL,
`type` varchar(15) NOT NULL,
`cena` int(11) NOT
NULL,
`shik` int(11) NOT NULL,
`del` int(11) NOT NULL,
`glam`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_shop`
--
CREATE TABLE IF NOT
EXISTS `k_shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(50) NOT NULL,
`opis` varchar(512) NOT NULL,
`path`
varchar(15) NOT NULL,
`type` varchar(15) NOT NULL,
`cena` int(11) NOT
NULL,
`pol` int(11) NOT NULL,
`sex` int(11) NOT NULL,
`shik`
int(11) NOT NULL,
`del` int(11) NOT NULL,
`sport` int(11) NOT NULL,
`epat` int(11) NOT NULL,
`glam` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_storage`
--
CREATE TABLE IF NOT
EXISTS `k_storage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid`
int(11) NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT
NULL,
`opis` varchar(512) NOT NULL,
`path` varchar(15) NOT NULL,
`type` varchar(15) NOT NULL,
`cena` int(11) NOT NULL,
`shik` int(11)
NOT NULL,
`del` int(11) NOT NULL,
`glam` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_user`
--
CREATE TABLE IF NOT
EXISTS `k_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid` int(11)
NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`opis` varchar(512) NOT NULL,
`path` varchar(15) NOT NULL,
`type`
varchar(15) NOT NULL,
`cena` int(11) NOT NULL,
`pol` int(11) NOT
NULL,
`sex` int(11) NOT NULL,
`shik` int(11) NOT NULL,
`del`
int(11) NOT NULL,
`sport` int(11) NOT NULL,
`epat` int(11) NOT
NULL,
`glam` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `k_user_house`
--
CREATE TABLE IF NOT
EXISTS `k_user_house` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid`
int(11) NOT NULL,
`uid` int(11) NOT NULL,
`name` varchar(50) NOT
NULL,
`opis` varchar(512) NOT NULL,
`path` varchar(15) NOT NULL,
`type` varchar(15) NOT NULL,
`cena` int(11) NOT NULL,
`shik` int(11)
NOT NULL,
`del` int(11) NOT NULL,
`glam` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
ALTER TABLE `user` ADD `fermer_money` int(11) NOT NULL DEFAULT
'1000';
ALTER TABLE `user` ADD `fermer_doggy` varchar(122) COLLATE
utf8_unicode_ci DEFAULT '0'NOT NULL;
ALTER TABLE `user` ADD
`fermer_oput` int(11) NOT NULL DEFAULT '0';