markovchains のテーブル

| user  | CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) 

| word  | CREATE TABLE `word` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) 

| chain | CREATE TABLE `chain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `word0_id` int(11) NOT NULL DEFAULT '0',
  `word1_id` int(11) NOT NULL DEFAULT '0',
  `word2_id` int(11) NOT NULL DEFAULT '0',
  `isstart` tinyint(1) NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `word1_id` (`word1_id`),
  KEY `word2_id` (`word2_id`),
  KEY `word0_id` (`word0_id`,`word1_id`)
) 

| userchain | CREATE TABLE `userchain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `chain_id` int(11) NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `chain_id` (`chain_id`)
)