Файл: www/mpit/sql.sql
Строк: 23
CREATE TABLE `pitom` (
`open` varchar(2) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
CREATE TABLE `pitomka` (
`id` int(11) NOT
NULL auto_increment,
`name` varchar(50) NOT NULL,
`kto` varchar(250)
default NULL,
`lasttake` bigint(20) NOT NULL,
`golod` int(11) NOT
NULL,
`skuka` int(11) NOT NULL,
`user` varchar(32) NOT NULL,
`date` bigint(20) NOT NULL,
`update` bigint(20) NOT NULL,
`reiting`
bigint(20) NOT NULL,
`korm` bigint(20) NOT NULL,
`pritok` int(11) NOT
NULL,
`birga` varchar(3) NOT NULL,
`reiting_osx` bigint(20) NOT
NULL,
`reiting_brel` bigint(20) NOT NULL,
`reiting_zdorov` bigint(20)
NOT NULL,
`bolen` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19
;
-- --------------------------------------------------------
--
-- Структура таблицы `pitomka`
--
ALTER
TABLE `user` ADD `pit` TEXT NOT NULL ;