Файл: gorod/sql.txt
Строк: 44
CREATE TABLE `phpbb_gorod_conf` (
`open` VARCHAR( 2 ) NOT NULL,
`kopi`
INT NOT NULL ,
`kopi_v` VARCHAR( 32 ) NOT NULL ,
`kopi_k` VARCHAR( 32 )
NOT NULL ,
`kopi_time` INT NOT NULL ,
`luna` INT NOT NULL
);
CREATE
TABLE `phpbb_gorod_bazar` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name`
VARCHAR( 150 ) NOT NULL ,
`price` INT NOT NULL ,
`life` INT NOT NULL
,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_band` (
`id` INT
NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`glava`
VARCHAR( 32 ) NOT NULL ,
`zarplata` INT NOT NULL ,
`bal` INT NOT NULL
,
`kill` INT NOT NULL ,
`balans` INT NOT NULL ,
`opis` VARCHAR( 250 )
NOT NULL ,
`open` VARCHAR( 3 ) NOT NULL ,
`needbal` INT NOT NULL
,
`krishaopen` VARCHAR( 3 ) NOT NULL ,
`price` INT NOT NULL
,
`krishaprice` INT NOT NULL ,
`strana` VARCHAR( 5 ) NOT NULL ,
PRIMARY
KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_bar` (
`id` INT NOT NULL
AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`price` INT NOT NULL
,
`life` SMALLINT NOT NULL ,
PRIMARY KEY ( `id` )
);
CREATE TABLE
`phpbb_gorod_mobi` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(
50 ) NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
`price` INT NOT NULL
,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_firm` (
`id` INT
NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`opis` VARCHAR(
250 ) NOT NULL ,
`lasttake` BIGINT NOT NULL ,
`dohod` INT NOT NULL
,
`balans` INT NOT NULL ,
`user` VARCHAR( 32 ) NOT NULL ,
`date` BIGINT
NOT NULL ,
`update` BIGINT NOT NULL ,
`pritok` INT NOT NULL,
`birga`
VARCHAR( 3 ) NOT NULL,
PRIMARY KEY ( `id` )
);
CREATE TABLE
`phpbb_gorod_tur` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50
) NOT NULL ,
`opis` VARCHAR( 250 ) NOT NULL ,
`price` INT NOT NULL
,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` )
);
CREATE
TABLE `phpbb_gorod_dom` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name`
VARCHAR( 50 ) NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
`price` INT NOT
NULL ,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_avto`
(
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL
,
`path` VARCHAR( 15 ) NOT NULL ,
`price` INT NOT NULL ,
PRIMARY KEY (
`id` )
);
CREATE TABLE `phpbb_gorod_weapon` (
`id` INT NOT NULL
AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`dameg` INT NOT NULL
,
`price` INT NOT NULL ,
PRIMARY KEY ( `id` )
);
CREATE TABLE
`phpbb_gorod_security` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name`
VARCHAR( 50 ) NOT NULL ,
`price` INT NOT NULL ,
`uron` INT NOT NULL
,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_para` (
`id` INT
NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`price` INT NOT
NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_invent` (
`id` INT NOT NULL
AUTO_INCREMENT ,
`uid` INT NOT NULL ,
`name` VARCHAR( 150 ) NOT NULL
,
`life` SMALLINT NOT NULL ,
`type` VARCHAR( 50 ) NOT NULL ,
`price`
BIGINT NOT NULL ,
`uron` INT NOT NULL,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_zoo` (
`id` INT NOT NULL AUTO_INCREMENT
,
`user` VARCHAR( 32 ) NOT NULL ,
`path` VARCHAR( 15 ) NOT NULL ,
`name`
VARCHAR( 32 ) NOT NULL ,
`where` VARCHAR( 32 ) NOT NULL ,
`opis` VARCHAR(
150 ) NOT NULL ,
`fam` VARCHAR( 50 ) NOT NULL ,
`poroda` VARCHAR( 50 )
NOT NULL ,
PRIMARY KEY ( `id` )
);
CREATE TABLE `phpbb_gorod_tbega`
(
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 32 ) NOT NULL
,
`bet` SMALLINT NOT NULL ,
`last` VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY
( `id` )
);
CREATE TABLE `phpbb_gorod_zaks` (
`id` INT NOT NULL
AUTO_INCREMENT ,
`date` BIGINT NOT NULL ,
`on` VARCHAR( 32 ) NOT NULL
,
`ona` VARCHAR( 32 ) NOT NULL ,
`avtor` VARCHAR( 32 ) NOT NULL
,
`onyes` text NOT NULL,
`onayes` text NOT NULL,
PRIMARY KEY ( `id` )
);
INSERT INTO `phpbb_gorod_conf` (`open`, `kopi`, `kopi_v`, `kopi_k`,
`kopi_time`, `luna`) VALUES ('0', 10, '10', 'apwa.ru', 14400, 10);
ALTER
TABLE `phpbb_users` ADD `gorod_life` SMALLINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_eda_time` BIGINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_money` BIGINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_ohota_time` BIGINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_brak` VARCHAR( 32 ) NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_tamag` VARCHAR( 32 ) NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_tamag_life` SMALLINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_tamag_time` BIGINT NOT NULL ;
ALTER TABLE
`phpbb_users` ADD `gorod_voodoo` INT NOT NULL ,
ADD `gorod_voodoo_name`
VARCHAR( 32 ) NOT NULL ;
ALTER TABLE `phpbb_users` ADD `gorod_kopi` BIGINT
NOT NULL ;
ALTER TABLE `phpbb_users` ADD `gorod_kriminal` INT NOT NULL
,
ADD `gorod_kriminal_time` BIGINT NOT NULL ;
ALTER TABLE `phpbb_users`
ADD `gorod_security` VARCHAR( 32 ) NOT NULL ,
ADD `gorod_security_uron`
INT NOT NULL ;
ALTER TABLE `phpbb_users` ADD `gorod_para` VARCHAR( 50 )
NOT NULL ;
ALTER TABLE `phpbb_users` ADD `gorod_tur` VARCHAR( 50 ) NOT
NULL ;
ALTER TABLE `phpbb_users` ADD `gorod_firm` VARCHAR( 50 ) NOT NULL
;
ALTER TABLE `phpbb_users` ADD `gorod_band` VARCHAR( 50 ) NOT NULL
;
ALTER TABLE `phpbb_users` ADD `gorod_band_time` BIGINT NOT NULL ;