Вход Регистрация
Файл: 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 ;
Онлайн: 1
Реклама