16.09.2016, 10:28
How the script bro?
PHP код:
CREATE TABLE `houses` (
`house_id` mediumint(4) NOT NULL,
`hname` varchar(35) NOT NULL,
`howner` varchar(21) NOT NULL,
`hlocation` varchar(30) NOT NULL DEFAULT '*',
`hpass` varchar(24) NOT NULL,
`last_visited` int(11) UNSIGNED NOT NULL DEFAULT '0',
`x` float NOT NULL DEFAULT '0',
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`a` float NOT NULL DEFAULT '0',
`cpx` float NOT NULL DEFAULT '0',
`cpy` float NOT NULL DEFAULT '0',
`cpz` float NOT NULL DEFAULT '0',
`hvalue` int(12) UNSIGNED NOT NULL DEFAULT '500',
`hforsale` int(12) UNSIGNED NOT NULL DEFAULT '0',
`hstorage` int(12) UNSIGNED NOT NULL DEFAULT '0',
`hint` tinyint(2) UNSIGNED NOT NULL DEFAULT '4',
`hprivacy` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;