tables.sql

CREATE SCHEMA if NOT EXISTS `db`;
USE `db`;

# System
CREATE TABLE `sys_users` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `email` varchar(254) NOT NULL,
 `password` varchar(255) NOT NULL,
 `dion_ppp_id` varchar(10) NOT NULL,
 `dion_email_local` varchar(8) NOT NULL,
 `log_in_password` varchar(8) NOT NULL,
 `money_spent` int(11) NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE `sys_email_change` (
 `user_id` int(11) unsigned NOT NULL,
 `new_email` varchar(254) NOT NULL,
 `secret` varchar(48) NOT NULL,
 `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`user_id`)
);
CREATE TABLE `sys_password_reset` (
 `user_id` int(11) unsigned NOT NULL,
 `secret` varchar(48) NOT NULL,
 `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`user_id`)
);
CREATE TABLE `sys_signup` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `email` varchar(254) NOT NULL,
 `secret` varchar(48) NOT NULL,
 `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `sys_inbox` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `sender` varchar(254) NOT NULL,
 `recipient` int(11) unsigned NOT NULL,
 `date` timestamp NOT NULL DEFAULT current_timestamp(),
 `message` blob NOT NULL,
 PRIMARY KEY (`id`)
);

# Pokemon Crystal (BXTJ)
CREATE TABLE `bxtj_exchange` (
 `entry_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Current time at entry.',
 `email` VARCHAR(30) NOT NULL COMMENT 'DION email',
 `account_id` INT(11) UNSIGNED NOT NULL,
 `trainer_id` SMALLINT(5) UNSIGNED NOT NULL COMMENT 'Trainer ID',
 `secret_id` SMALLINT(5) UNSIGNED NOT NULL COMMENT 'Secret ID',
 `offer_gender` TINYINT(1) UNSIGNED NOT NULL COMMENT 'Gender of Pokémon',
 `offer_species` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Decimal Pokémon ID.',
 `request_gender` TINYINT(1) UNSIGNED NOT NULL,
 `request_species` TINYINT(3) UNSIGNED NOT NULL,
 `trainer_name` BINARY(5) NOT NULL COMMENT 'Name of player',
 `pokemon` BINARY(58) NOT NULL COMMENT 'Pokémon',
 `mail` BINARY(42) NOT NULL COMMENT 'Held mail of Pokémon',
 UNIQUE INDEX `UNIQUE` (`account_id`, `trainer_id`, `secret_id`)
)
COMMENT='Pokémon Trade Corner information'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `bxtj_battle_tower_records` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `room` int(10) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 `email` varchar(30) NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `name` binary(5) NOT NULL,
 `class` tinyint(1) NOT NULL,
 `pokemon1` binary(54) NOT NULL,
 `pokemon2` binary(54) NOT NULL,
 `pokemon3` binary(54) NOT NULL,
 `message_start` binary(12) NOT NULL,
 `message_win` binary(12) NOT NULL,
 `message_lose` binary(12) NOT NULL,
 `num_trainers_defeated` tinyint(3) unsigned NOT NULL,
 `num_turns_required` smallint(5) unsigned NOT NULL,
 `damage_taken` smallint(5) unsigned NOT NULL,
 `num_fainted_pokemon` tinyint(3) unsigned NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `bxtj_battle_tower_trainers` (
 `no` tinyint(1) unsigned NOT NULL,
 `room` int(10) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 `name` binary(5) NOT NULL,
 `class` tinyint(1) NOT NULL,
 `pokemon1` binary(54) NOT NULL,
 `pokemon2` binary(54) NOT NULL,
 `pokemon3` binary(54) NOT NULL,
 `message_start` binary(12) NOT NULL,
 `message_win` binary(12) NOT NULL,
 `message_lose` binary(12) NOT NULL,
 PRIMARY KEY (`no`,`room`,`level`)
);
CREATE TABLE IF NOT EXISTS `bxtj_battle_tower_leaders` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `name` binary(5) NOT NULL,
 `room` int(11) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `bxtj_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(5) NOT NULL,
 `player_gender` tinyint(1) unsigned  NOT NULL,
 `player_age` tinyint(3) unsigned  NOT NULL,
 `player_region` tinyint(3) unsigned  NOT NULL,
 `player_zip` smallint(3) NOT NULL,
 `player_message` binary(12) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTE)
CREATE TABLE IF NOT EXISTS `bxte_battle_tower_records` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `room` int(10) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 `email` varchar(30) NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `name` binary(7) NOT NULL,
 `class` tinyint(1) NOT NULL,
 `pokemon1` binary(59) NOT NULL,
 `pokemon2` binary(59) NOT NULL,
 `pokemon3` binary(59) NOT NULL,
 `message_start` binary(8) NOT NULL,
 `message_win` binary(8) NOT NULL,
 `message_lose` binary(8) NOT NULL,
 `num_trainers_defeated` tinyint(3) unsigned NOT NULL,
 `num_turns_required` smallint(5) unsigned NOT NULL,
 `damage_taken` smallint(5) unsigned NOT NULL,
 `num_fainted_pokemon` tinyint(3) unsigned NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `bxte_battle_tower_trainers` (
 `no` tinyint(1) unsigned NOT NULL,
 `room` int(10) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 `name` binary(7) NOT NULL,
 `class` tinyint(1) NOT NULL,
 `pokemon1` binary(59) NOT NULL,
 `pokemon2` binary(59) NOT NULL,
 `pokemon3` binary(59) NOT NULL,
 `message_start` binary(8) NOT NULL,
 `message_win` binary(8) NOT NULL,
 `message_lose` binary(8) NOT NULL,
 PRIMARY KEY (`no`,`room`,`level`)
);
CREATE TABLE IF NOT EXISTS `bxte_battle_tower_leaders` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `name` binary(7) NOT NULL,
 `room` int(11) unsigned NOT NULL,
 `level` tinyint(1) unsigned NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `bxte_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTD)
CREATE TABLE IF NOT EXISTS `bxtd_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTF)
CREATE TABLE IF NOT EXISTS `bxtf_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTI)
CREATE TABLE IF NOT EXISTS `bxti_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTP)
CREATE TABLE IF NOT EXISTS `bxtp_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTS)
CREATE TABLE IF NOT EXISTS `bxts_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal (BXTU)
CREATE TABLE IF NOT EXISTS `bxtu_ranking` (
 `news_id` int(11) unsigned NOT NULL,
 `category_id` tinyint(2) unsigned NOT NULL,
 `account_id` int(11) unsigned NOT NULL,
 `trainer_id` smallint(5) unsigned NOT NULL,
 `secret_id` smallint(5) unsigned NOT NULL,
 `player_name` binary(7) NOT NULL,
 `player_gender` tinyint(1) unsigned NOT NULL,
 `player_age` tinyint(3) unsigned NOT NULL,
 `player_region` tinyint(3) unsigned NOT NULL,
 `player_zip` binary(3) NOT NULL,
 `player_message` binary(8) NOT NULL,
 `score` int(11) unsigned NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`news_id`, `category_id`, `account_id`, `trainer_id`, `secret_id`)
);

# Pokemon Crystal general
CREATE TABLE `bxt_exchange` (
 `entry_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Current time at entry.',
 `email` VARCHAR(30) NOT NULL COMMENT 'DION email',
 `account_id` INT(11) UNSIGNED NOT NULL,
 `game_region` CHAR(1) NOT NULL,
 `trainer_id` SMALLINT(5) UNSIGNED NOT NULL COMMENT 'Trainer ID',
 `secret_id` SMALLINT(5) UNSIGNED NOT NULL COMMENT 'Secret ID',
 `offer_gender` TINYINT(1) UNSIGNED NOT NULL COMMENT 'Gender of Pokémon',
 `offer_species` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Decimal Pokémon ID.',
 `request_gender` TINYINT(1) UNSIGNED NOT NULL,
 `request_species` TINYINT(3) UNSIGNED NOT NULL,
 `trainer_name` BINARY(7) NOT NULL COMMENT 'Name of player',
 `pokemon` BINARY(65) NOT NULL COMMENT 'Pokémon',
 `mail` BINARY(47) NOT NULL COMMENT 'Held mail of Pokémon',
 UNIQUE INDEX `UNIQUE` (`account_id`, `trainer_id`, `secret_id`)
)
COMMENT='Pokémon Trade Corner information'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `bxt_ranking_categories` (
 `id` tinyint(2) unsigned NOT NULL,
 `name` varchar(80) NOT NULL,
 `ram_address` binary(2) NOT NULL,
 `size` tinyint(1) unsigned NOT NULL,
 PRIMARY KEY (`id`)
);
# values by hacky
INSERT IGNORE INTO `bxt_ranking_categories`
(`id`, `name`, `ram_address`, `size`)
VALUES
(0, "Play time when last entered the Hall of Fame", 0x01A0, 4),
(1, "Step count when last entered the Hall of Fame", 0x05A0, 4),
(2, "Number of times the party was healed when last entered the Hall of Fame", 0x09A0, 3),
(3, "Number of battles when last entered the Hall of Fame", 0x0DA0, 3),
(4, "Step count", 0x10A0, 4),
(5, "Number of Battle Tower wins", 0x14A0, 2),
(6, "Number of times TMs and HMs have been taught", 0x18A0, 3),
(7, "Number of battles", 0x1BA0, 3),
(8, "Number of wild Pokémon battles", 0x1EA0, 3),
(9, "Number of Trainer battles", 0x21A0, 3),
(10, "Unused", 0x24A0, 3),
(11, "Number of Hall of Fame inductions", 0x27A0, 3),
(12, "Number of wild Pokémon caught", 0x2AA0, 3),
(13, "Number of hooked Pokémon encounters", 0x2DA0, 3),
(14, "Number of Eggs hatched", 0x30A0, 3),
(15, "Number of Pokémon evolved", 0x33A0, 3),
(16, "Number of Berries and Apricorns picked", 0x36A0, 3),
(17, "Number of times the party is healed", 0x39A0, 3),
(18, "Number of times Mystery Gift is used", 0x3CA0, 3),
(19, "Number of trades", 0x3FA0, 3),
(20, "Number of uses of field move Fly", 0x42A0, 3),
(21, "Number of uses of field move Surf", 0x45A0, 3),
(22, "Number of uses of field move Waterfall", 0x48A0, 3),
(23, "Number of times the player whited out", 0x4BA0, 3),
(24, "Number of Lucky Number Show prizes won", 0x4EA0, 3),
(25, "Number of Phone calls made and received", 0x51A0, 3),
(26, "Unused", 0x54A0, 3),
(27, "Number of Colosseum battles", 0x57A0, 3),
(28, "Number of times players Pokémon used Splash", 0x5AA0, 3),
(29, "Number of tree Pokémon encounters", 0x5DA0, 3),
(30, "Unused", 0x60A0, 3),
(31, "Number of Colosseum wins", 0x63A0, 3),
(32, "Number of Colosseum losses", 0x66A0, 3),
(33, "Number of Colosseum ties", 0x69A0, 3),
(34, "Number of times players Pokémon used SelfDestruct or Explosion", 0x6CA0, 3),
(35, "Current streak of consecutive slot machine wins", 0x6FA0, 2),
(36, "Longest streak of consecutive slot machine wins", 0x71A0, 2),
(37, "Total coins won from slot machines", 0x73A0, 4),
(38, "Total money earned from battles (including Pay Day)", 0x77A0, 4),
(39, "Largest Magikarp measured", 0x7BA0, 2),
(40, "Smallest Magikarp measured", 0x7DA0, 2),
(41, "Bug-Catching Contest high score", 0x7FA0, 2);
CREATE TABLE IF NOT EXISTS `bxt_news` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `ranking_category_1` tinyint(2) unsigned,
 `ranking_category_2` tinyint(2) unsigned,
 `ranking_category_3` tinyint(2) unsigned,
 `message_j` varbinary(100) NOT NULL,
 `message_e` varbinary(100) NOT NULL,
 `message_d` varbinary(100) NOT NULL,
 `message_f` varbinary(100) NOT NULL,
 `message_i` varbinary(100) NOT NULL,
 `message_s` varbinary(100) NOT NULL,
 `news_binary_j` blob NOT NULL,
 `news_binary_e` blob NOT NULL,
 `news_binary_d` blob NOT NULL,
 `news_binary_f` blob NOT NULL,
 `news_binary_i` blob NOT NULL,
 `news_binary_s` blob NOT NULL,
 PRIMARY KEY (`id`)
);

# Mario Kart Advance (AMKJ)
CREATE TABLE `amkj_user_map` (
 `player_id` binary(16) NOT NULL,
 `user_id` int(11),
 PRIMARY KEY (`player_id`)
);
CREATE TABLE IF NOT EXISTS `amkj_rule` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `file_name` text NOT NULL,
 `start_date` date NOT NULL,
 `end_date` date NOT NULL,
 `next_start_date` date NOT NULL,
 `next_end_date` date NOT NULL,
 `entry_start_date` date NOT NULL,
 `entry_end_date` date NOT NULL,
 `ranking_start_date` date NOT NULL,
 `ranking_end_date` date NOT NULL,
 `coins_enabled` tinyint(1) NOT NULL,
 `items_enabled` tinyint(1) NOT NULL,
 `start_item_triple_shroom_enabled` tinyint(1) NOT NULL,
 `shrooms_only_enabled` tinyint(1) NOT NULL,
 `cpu_enabled` tinyint(1) NOT NULL,
 `character` tinyint(1) NOT NULL,
 `start_coins` tinyint(1) NOT NULL,
 `five_laps_enabled` tinyint(1) NOT NULL,
 `course` tinyint(2) NOT NULL,
 `num_attempts` tinyint(2) NOT NULL,
 `message` text DEFAULT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE `amkj_ghosts` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `player_id` binary(16) NOT NULL,
 `course_no` tinyint(3) unsigned NOT NULL,
 `driver` tinyint(3) unsigned NOT NULL,
 `name` binary(5) NOT NULL,
 `state` tinyint(3) unsigned NOT NULL,
 `unk18` smallint(5) unsigned NOT NULL,
 `course` tinyint(3) unsigned NOT NULL,
 `time` smallint(5) unsigned NOT NULL,
 `input_data` blob NOT NULL,
 `full_name` binary(16) NOT NULL,
 `phone_number` binary(12) NOT NULL,
 `postal_code` binary(8) NOT NULL,
 `address` binary(128) NOT NULL,
 PRIMARY KEY (`id`)
);
CREATE TABLE `amkj_ghosts_mobilegp` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `gp_id` int(11) unsigned NOT NULL,
 `player_id` binary(16) NOT NULL,
 `course_no` tinyint(3) unsigned NOT NULL,
 `driver` tinyint(3) unsigned NOT NULL,
 `name` binary(5) NOT NULL,
 `state` tinyint(3) unsigned NOT NULL,
 `unk18` smallint(5) unsigned NOT NULL,
 `course` tinyint(3) unsigned NOT NULL,
 `time` smallint(5) unsigned NOT NULL,
 `input_data` blob NOT NULL,
 `full_name` binary(16) NOT NULL,
 `phone_number` binary(12) NOT NULL,
 `postal_code` binary(8) NOT NULL,
 `address` binary(128) NOT NULL,
 PRIMARY KEY (`id`)
);

# EX Monopoly (AMOJ)
CREATE TABLE `amoj_ranking` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `name` binary(4) NOT NULL,
 `email` varchar(32) NOT NULL,
 `today` tinyint(3) unsigned NOT NULL DEFAULT 0,
 `points` int(11) unsigned NOT NULL,
 `money` int(11) unsigned NOT NULL,
 `gender` tinyint(3) unsigned NOT NULL,
 `age` tinyint(3) unsigned NOT NULL,
 `state` tinyint(3) unsigned NOT NULL,
 `today2` tinyint(3) unsigned NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
);
CREATE TABLE `amoj_news` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `text` text(65535) NOT NULL,
 PRIMARY KEY (`id`)
);