| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `aowow_comments` (
|
|---|
| 2 | `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Comment ID',
|
|---|
| 3 | `type` int(10) unsigned NOT NULL COMMENT 'Type of Page',
|
|---|
| 4 | `typeid` int(10) unsigned NOT NULL COMMENT 'ID Of Page',
|
|---|
| 5 | `userid` bigint(20) unsigned NOT NULL COMMENT 'User ID',
|
|---|
| 6 | `post_date` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT 'Comment timestap',
|
|---|
| 7 | `commentbody` text COMMENT 'Comment text',
|
|---|
| 8 | `replyto` bigint(20) unsigned default NULL COMMENT 'Reply To, comment ID',
|
|---|
| 9 | `edit_userid` bigint(20) unsigned NOT NULL default 0 COMMENT 'Last Edit User ID',
|
|---|
| 10 | `edit_date` timestamp NOT NULL default 0 COMMENT 'Last Edit Time',
|
|---|
| 11 | `edit_count` int(10) unsigned NOT NULL default 0 COMMENT 'Count Of Edits',
|
|---|
| 12 | UNIQUE KEY `id` (`id`)
|
|---|
| 13 | ) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=utf8 COMMENT='AoWoW Comments Table';
|
|---|
| 14 |
|
|---|
| 15 | CREATE TABLE IF NOT EXISTS `aowow_comments_rates` (
|
|---|
| 16 | `commentid` bigint(20) unsigned NOT NULL default 0 COMMENT 'Comment ID',
|
|---|
| 17 | `userid` bigint(20) unsigned NOT NULL default 0 COMMENT 'User ID',
|
|---|
| 18 | `rate` tinyint(4) NOT NULL default 0 COMMENT 'Rating Set'
|
|---|
| 19 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='AoWoW Comments Rates Table';
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
