Просмотр архива Симс + инсталл

DROP TABLE IF EXISTS `sims_chat`;

CREATE TABLE `sims_chat` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_u` int(11) NOT NULL,
  `name`
varchar(164) NOT NULL,
  `msg` text NOT NULL,
  `time` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `sims_city`;

CREATE TABLE `sims_city` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(164) NOT NULL,
  `description` text NOT
NULL,
  `image` varchar(164) NOT NULL,
  `max_house` int(2) NOT NULL,
 
`ex_house` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO sims_city
VALUES("2","Новосельск","За 25 лет
здесь изменилось многое. В городок
прибыли новые жители, и они никому не
дают покою: плетут интриги, соперничают и
вообще не ладят с соседями. Как вернуть
тишь и длагодать в пастральный
Новосельск?","city_1.png","40","1");
INSERT
INTO sims_city
VALUES("3","Китежград","Одиноки
ли мы во Вселенной? Почему люди исчезают
при загадочных обстоятельствах? Что на
самом деле представляют собой НЛО? Если
вы ищите ответы на эти вопросы - добро
пожаловать в
Китежград!","city_2.png","40","2");



DROP
TABLE IF EXISTS `sims_i`;

CREATE TABLE `sims_i` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(164) NOT NULL,
  `place` varchar(164) NOT
NULL,
  `id_u` int(11) NOT NULL,
  `id_i` int(11) NOT NULL,
  `plus`
varchar(164) NOT NULL,
  `exp` varchar(164) NOT NULL,
  `money` int(11) NOT
NULL,
  `iznos` float NOT NULL,
  `time` int(11) NOT NULL,
  `sell`
smallint(1) NOT NULL,
  `req_id` int(11) NOT NULL,
  `place_n` int(3) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `sims_item`;

CREATE TABLE
`sims_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(164)
NOT NULL,
  `type` varchar(164) NOT NULL,
  `cost` int(11) NOT NULL,
 
`plus` varchar(164) NOT NULL,
  `req_id` int(11) NOT NULL,
  `exp`
varchar(164) NOT NULL,
  `money` int(11) NOT NULL,
  `time` int(11) NOT
NULL,
  `sell` smallint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

INSERT INTO sims_item
VALUES("1","Гриль
Pеактор","bit","299","culinar:2:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","n","0","60","0");
INSERT
INTO sims_item
VALUES("2","Цельнометаллическая
плита Будь
Готов","bit","400","culinar:4:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("3","Газовая плита
Крематориус","bit","650","culinar:6:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("4","Газовая плита
Факел","bit","900","culinar:8:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","90","0");
INSERT
INTO sims_item VALUES("5","Гриллиус
Грандиозус","bit","1100","culinar:8:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","culinaria","0","90","0");
INSERT
INTO sims_item VALUES("6","Кресло Старое
доброе
время","chair","80","culinar:0:comfort:4:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:-2","0","","0","60","0");
INSERT
INTO sims_item VALUES("7","Диванчик
Сатинизм","divan","150","culinar:0:comfort:2:nujda:0:bodrost:5:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("8","Кресло
Неваляшка","chair","155","culinar:0:comfort:5:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","50","0");
INSERT
INTO sims_item VALUES("9","Диванчик
Мегаполис","divan","400","culinar:0:comfort:7:nujda:0:bodrost:2:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("10","Синий
Бархат","chair","611","culinar:0:comfort:7:nujda:0:bodrost:3:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","70","0");
INSERT
INTO sims_item
VALUES("11","Луксор","divan","900","culinar:0:comfort:8:nujda:0:bodrost:2:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","75","0");
INSERT
INTO sims_item VALUES("12","Кресло
Бокал","chair","920","culinar:0:comfort:9:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:2","0","","0","70","0");
INSERT
INTO sims_item VALUES("13","Оле
Лукойе","bed","300","culinar:0:comfort:1:nujda:0:bodrost:2:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","500","0");
INSERT
INTO sims_item VALUES("14","Кровать
Бюджетная","bed","450","culinar:0:comfort:1:nujda:0:bodrost:2:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","400","0");
INSERT
INTO sims_item VALUES("15","Кровать
Медитация","bed","950","culinar:0:comfort:4:nujda:10:bodrost:4:dosug:0:obshenie:0:gigiena:0:yut:2","0","","0","400","0");
INSERT
INTO sims_item VALUES("16","Кровать Номер
4234","bed","2200","culinar:0:comfort:5:nujda:0:bodrost:6:dosug:0:obshenie:0:gigiena:0:yut:4","0","","0","400","0");
INSERT
INTO sims_item VALUES("17","Кровать
Железного
Дерева","bed","3000","culinar:0:comfort:7:nujda:0:bodrost:6:dosug:0:obshenie:0:gigiena:0:yut:5","0","","0","400","0");
INSERT
INTO sims_item VALUES("18","Гардероб
Нео-Антик","cabinet","250","culinar:0:comfort:2:nujda:0:bodrost:0:dosug:4:obshenie:0:gigiena:0:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("19","Гардероб Арт
Нуво","cabinet","1000","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:3","0","","0","60","0");
INSERT
INTO sims_item VALUES("20","Комод из
вишнегого
дерева","cabinet","2125","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:6","0","","0","60","0");
INSERT
INTO sims_item VALUES("21","Формула
2","enter","149","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:5:obshenie:0:gigiena:0:yut:0","0","","0","120","0");
INSERT
INTO sims_item VALUES("22","Игровая
приставка
MaXiS","enter","560","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:9:obshenie:0:gigiena:0:yut:0","0","","0","120","0");
INSERT
INTO sims_item VALUES("25","Джакузи Бурлящая
Зона","jac","6500","culinar:0:comfort:6:nujda:0:bodrost:0:dosug:7:obshenie:0:gigiena:0:yut:9","0","","0","120","0");
INSERT
INTO sims_item VALUES("24","Ретро
Пинбол","enter","1750","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:10:obshenie:0:gigiena:0:yut:2","0","","0","180","0");
INSERT
INTO sims_item VALUES("26","Раковина
Обыкновеная","bit","275","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:5:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("27","Раковина от
Виторио
Виториани","bit","700","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:2","0","","0","60","0");
INSERT
INTO sims_item
VALUES("28","Душ","dush","625","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:8:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("29","Ванна
Турбочисто","dush","900","culinar:0:comfort:6:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:6:yut:2","0","","0","60","0");
INSERT
INTO sims_item VALUES("30","Ванна Силы
Империи","dush","1800","culinar:0:comfort:8:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:8:yut:3","0","","0","60","0");
INSERT
INTO sims_item VALUES("31","Унитаз
Кескесе","toilet","300","culinar:0:comfort:0:nujda:10:bodrost:0:dosug:0:obshenie:0:gigiena:-5:yut:0","0","","0","60","0");
INSERT
INTO sims_item VALUES("32","Унитаз Белый
Друг","toilet","950","culinar:0:comfort:0:nujda:10:bodrost:0:dosug:0:obshenie:0:gigiena:-3:yut:10","0","","0","60","0");
INSERT
INTO sims_item VALUES("33","Холодильник
Отморозко","bit","600","culinar:10:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:0","0","","0","120","0");
INSERT
INTO sims_item VALUES("34","Холодильник
Колотун-Бабай","bit","1500","culinar:10:comfort:0:nujda:0:bodrost:0:dosug:0:obshenie:0:gigiena:0:yut:2","0","","0","60","0");
INSERT
INTO sims_item VALUES("35","Телевизор
Рубин","teh","500","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:6:obshenie:0:gigiena:0:yut:0","0","culture:culinaria","0","120","0");
INSERT
INTO sims_item VALUES("36","Компьютер
Скуперфильд","teh","1000","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:7:obshenie:0:gigiena:0:yut:0","0","tvorchesto","0","120","0");
INSERT
INTO sims_item VALUES("37","Плоский
телевизор","teh","8000","culinar:0:comfort:0:nujda:0:bodrost:0:dosug:10:obshenie:0:gigiena:0:yut:7","0","culinaria:culture","0","120","0");



DROP
TABLE IF EXISTS `sims_present`;

CREATE TABLE `sims_present` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

INSERT INTO sims_present
VALUES("1");
INSERT INTO sims_present
VALUES("2");
INSERT INTO sims_present
VALUES("3");
INSERT INTO sims_present
VALUES("4");
INSERT INTO sims_present
VALUES("5");
INSERT INTO sims_present
VALUES("6");
INSERT INTO sims_present
VALUES("7");
INSERT INTO sims_present
VALUES("8");
INSERT INTO sims_present
VALUES("9");
INSERT INTO sims_present
VALUES("10");
INSERT INTO sims_present
VALUES("11");
INSERT INTO sims_present
VALUES("12");
INSERT INTO sims_present
VALUES("13");
INSERT INTO sims_present
VALUES("14");
INSERT INTO sims_present
VALUES("15");



DROP TABLE IF EXISTS `sims_presents`;

CREATE
TABLE `sims_presents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_u`
int(11) NOT NULL,
  `id_ank` int(11) NOT NULL,
  `id_p` int(11) NOT NULL,
 
`msg` varchar(512) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `sims_setting`;

CREATE TABLE
`sims_setting` (
  `id` int(11) NOT NULL,
  `open_bank` enum('0','1') NOT
NULL DEFAULT '0',
  `wmr` varchar(164) NOT NULL DEFAULT '123456789123',
 
`wmz` varchar(164) NOT NULL DEFAULT '123456789123',
  `wmu` varchar(164)
NOT NULL DEFAULT '123456789123',
  `wmr_c` float NOT NULL DEFAULT '3.98',
 
`wmz_c` float NOT NULL DEFAULT '0.12',
  `wmu_c` float NOT NULL DEFAULT
'1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT
INTO sims_setting
VALUES("1","0","123456789123","123456789123","123456789123","3.98","0.12","1");



DROP
TABLE IF EXISTS `sims_user`;

CREATE TABLE `sims_user` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_u` int(11) NOT NULL,
  `name` varchar(164) NOT
NULL,
  `fam` varchar(164) NOT NULL,
  `pol` varchar(32) NOT NULL,
 
`gor_time` int(11) NOT NULL,
  `ybor_time` int(11) NOT NULL,
  `dvor_time`
int(11) NOT NULL,
  `gor_update` int(11) NOT NULL,
  `ybor_update` int(11)
NOT NULL,
  `dvor_update` int(11) NOT NULL,
  `face` varchar(164) NOT
NULL,
  `body` varchar(164) NOT NULL,
  `nogi` varchar(164) NOT NULL,
 
`last_visit` int(11) NOT NULL,
  `work_id` int(11) NOT NULL,
  `work_time`
int(11) NOT NULL,
  `room_1` int(2) NOT NULL DEFAULT '3',
  `room_2` int(2)
NOT NULL DEFAULT '3',
  `room_3` int(2) NOT NULL DEFAULT '3',
  `room_4`
int(2) NOT NULL DEFAULT '3',
  `in_game` int(11) NOT NULL,
  `last` int(11)
NOT NULL,
  `cel` varchar(164) NOT NULL,
  `zod` varchar(164) NOT NULL,
 
`place` varchar(164) NOT NULL DEFAULT 'guest',
  `house_id` int(11) NOT
NULL,
  `city_id` int(11) NOT NULL,
  `last_update` int(11) NOT NULL,
 
`last_id` int(11) NOT NULL,
  `last_type` varchar(3) NOT NULL,
  `money`
int(11) NOT NULL DEFAULT '1000',
  `setting_diz` enum('0','1') DEFAULT
'0',
  `culinar` int(3) NOT NULL DEFAULT '90',
  `comfort` int(3) NOT NULL
DEFAULT '90',
  `nujda` int(3) NOT NULL DEFAULT '90',
  `bodrost` int(3)
NOT NULL DEFAULT '90',
  `dosug` int(3) NOT NULL DEFAULT '90',
  `obshenie`
int(3) NOT NULL DEFAULT '90',
  `gigiena` int(3) NOT NULL DEFAULT '90',
 
`yut` int(3) NOT NULL DEFAULT '90',
  `culinaria` int(7) NOT NULL,
 
`tehnika` int(7) NOT NULL,
  `obayanie` int(7) NOT NULL,
  `culture` int(7)
NOT NULL,
  `logika` int(7) NOT NULL,
  `medicina` int(7) NOT NULL,
 
`tvorchesto` int(7) NOT NULL,
  `uborka` int(7) NOT NULL,
 
`culinaria_level` int(7) NOT NULL,
  `tehnika_level` int(7) NOT NULL,
 
`obayanie_level` int(7) NOT NULL,
  `medicina_level` int(7) NOT NULL,
 
`culture_level` int(7) NOT NULL,
  `logika_level` int(7) NOT NULL,
 
`tvorchesto_level` int(7) NOT NULL,
  `uborka_level` int(7) NOT NULL,
 
`credits` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`sims_wall`;

CREATE TABLE `sims_wall` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_u` int(11) NOT NULL,
  `id_ank` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `sims_work`;

CREATE TABLE `sims_work` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(164) NOT NULL,
  `zp` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `skill` varchar(164) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO
sims_work
VALUES("1","Повар","40","600","culinaria");
INSERT
INTO sims_work VALUES("2","Донор
органов","40","600","medicina");
INSERT
INTO sims_work
VALUES("3","Подопытный","40","600","logika");
INSERT
INTO sims_work
VALUES("4","Болельщик","40","600","culture");
INSERT
INTO sims_work
VALUES("5","Художник","40","600","tvorchesto");
INSERT
INTO sims_work VALUES("6","Сервисный
центр","40","600","tehnika");
INSERT
INTO sims_work
VALUES("7","Уборщик","40","600","uborka");
INSERT
INTO sims_work
VALUES("8","Актер","40","600","obayanie");