diff options
| author | friendica <info@friendica.com> | 2012-07-05 17:59:56 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-07-05 17:59:56 -0700 |
| commit | d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5 (patch) | |
| tree | a14580efdd1a1d7a664eb97da3b2695727eb767f /database.sql | |
| parent | 8af78079cbabe530554950ac241b24bbdcaf2cb7 (diff) | |
| download | volse-hubzilla-d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5.tar.gz volse-hubzilla-d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5.tar.bz2 volse-hubzilla-d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5.zip | |
term (tag, mention, category, file, etc.) table
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/database.sql b/database.sql index bd57d9fdd..1d0a32176 100644 --- a/database.sql +++ b/database.sql @@ -1001,6 +1001,26 @@ CREATE TABLE IF NOT EXISTS `spam` ( -- -------------------------------------------------------- -- +-- Table structure for table `term` +-- + +CREATE TABLE IF NOT EXISTS `term` ( + `tid` INT UNSIGNED NOT NULL AUTO_INCREMENT, + `oid` INT UNSIGNED NOT NULL , + `otype` TINYINT( 3 ) UNSIGNED NOT NULL , + `type` TINYINT( 3 ) UNSIGNED NOT NULL , + `term` CHAR( 255 ) NOT NULL , + `url` CHAR( 255 ) NOT NULL, + PRIMARY KEY (`tid`), + KEY `oid` ( `oid` ), + KEY `otype` ( `otype` ), + KEY `type` ( `type` ), + KEY `term` ( `term` ) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- -- Table structure for table `tokens` -- |