Changeset 199

Timestamp:

06/18/06 12:41:12 (2 years ago)

Author:

eadiaz

Message:

Add permalink support, and more statistics fields

Files:

• trunk/create.sql (modified) (5 diffs)

trunk/create.sql

@@ -8 +8 @@
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-latin1
+utf8
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
@@ -98 +98 @@
-  `lang` varchar(2) default 'es',
-  `clicks` int(11) default '0',
-  `social_clicks` int(11) default '0',
-  `rank` int(11) default '0',
-  `votes` int(11) NOT NULL default '0',
@@ -109 +108 @@
-  `allows_debates` int(11) NOT NULL default '0',
-  `promoted` int(11) NOT NULL default '0',
+  `disabled` tinyint(1) default '0',
+  `social_clicks` int(11) default '0',
+  `views` int(11) NOT NULL default '0',
+  `shares` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`ID`),
-  KEY `idx_post_dates` (`date_posted`),
@@ -119 +122 @@
-  KEY `idx_post_votes` (`votes`),
-  KEY `idx_prooted` (`promoted`)
-latin1
+utf8
-
---
@@ -175 +178 @@
-  `gravatar` varchar(32) default NULL,
-  `strong_pass` blob,
+  `send_newsletter` tinyint(1) default '1',
+  `track_comments` tinyint(1) default '1',
-  PRIMARY KEY  (`ID`),
-  KEY `idx_username` (`username`),