| | |
|---|
| | | CREATE TABLE `cache` ( |
|---|
| | | `cache_id` int(10) unsigned NOT NULL auto_increment, |
|---|
| | | `user_id` int(10) unsigned NOT NULL default '0', |
|---|
| | | `session_id` varchar(40) default NULL, |
|---|
| | | `cache_key` varchar(128) NOT NULL default '', |
|---|
| | | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| | | `data` longtext NOT NULL, |
|---|
| | | PRIMARY KEY (`cache_id`), |
|---|
| | | INDEX `created_index` (`created`), |
|---|
| | | INDEX `user_cache_index` (`user_id`,`cache_key`) |
|---|
| | | ); |
|---|
| | | |
|---|
| | |
|---|
| | | `alias` varchar(128) NOT NULL default '', |
|---|
| | | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| | | `last_login` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| | | `language` varchar(5) NOT NULL default 'en', |
|---|
| | | `language` varchar(5), |
|---|
| | | `preferences` text, |
|---|
| | | PRIMARY KEY (`user_id`), |
|---|
| | | INDEX `username_index` (`username`), |
|---|
