View file gogi/tables.txt

-- --------------------------------------------------------

-- 
-- Структура таблицы `adminzzz`
-- 

CREATE TABLE `adminzzz` (
  `id` int(3) NOT NULL auto_increment,
  `uname` text NOT NULL,
  `upass` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Дамп данных таблицы `adminzzz`
-- 

INSERT DELAYED IGNORE INTO `adminzzz` (`id`, `uname`, `upass`) VALUES (1, '111', '111');

-- --------------------------------------------------------

-- 
-- Структура таблицы `pet_tamagochi`
-- 

CREATE TABLE `pet_tamagochi` (
  `id` int(9) NOT NULL auto_increment,
  `t_name` text NOT NULL,
  `t_login` text NOT NULL,
  `t_password` text NOT NULL,
  `kind` text NOT NULL,
  `temper` text NOT NULL,
  `birthday` text NOT NULL,
  `birth_lx` int(18) NOT NULL default '0',
  `eda` int(9) NOT NULL default '0',
  `nastr` int(9) NOT NULL default '0',
  `um` int(9) NOT NULL default '0',
  `health` int(9) NOT NULL default '0',
  `toilet` int(9) NOT NULL default '0',
  `vanna` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Структура таблицы `pet_users`
-- 

CREATE TABLE `pet_users` (
  `id` int(9) NOT NULL auto_increment,
  `login` text NOT NULL,
  `password` text NOT NULL,
  `tamagochi` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;