sql_scripts/cnprog_new_install.sql

   1 -- MySQL Administrator dump 1.4
   2 --
   3 -- ------------------------------------------------------
   4 -- Server version       5.0.67
   5
   6
   7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10 /*!40101 SET NAMES utf8 */;
  11
  12 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15
  16
  17 --
  18 -- Create schema cnprog
  19 --
  20
  21 CREATE DATABASE IF NOT EXISTS cnprog;
  22 USE cnprog;
  23
  24 --
  25 -- Definition of table `cnprog`.`answer`
  26 --
  27
  28 DROP TABLE IF EXISTS `cnprog`.`answer`;
  29 CREATE TABLE  `cnprog`.`answer` (
  30   `id` int(11) NOT NULL auto_increment,
  31   `question_id` int(11) NOT NULL,
  32   `author_id` int(11) NOT NULL,
  33   `added_at` datetime NOT NULL,
  34   `wiki` tinyint(1) NOT NULL,
  35   `wikified_at` datetime default NULL,
  36   `accepted` tinyint(1) NOT NULL,
  37   `deleted` tinyint(1) NOT NULL,
  38   `deleted_by_id` int(11) default NULL,
  39   `locked` tinyint(1) NOT NULL,
  40   `locked_by_id` int(11) default NULL,
  41   `locked_at` datetime default NULL,
  42   `score` int(11) NOT NULL,
  43   `vote_up_count` int(11) NOT NULL,
  44   `vote_down_count` int(11) NOT NULL,
  45   `comment_count` int(10) unsigned NOT NULL,
  46   `offensive_flag_count` smallint(6) NOT NULL,
  47   `last_edited_at` datetime default NULL,
  48   `last_edited_by_id` int(11) default NULL,
  49   `html` longtext NOT NULL,
  50   PRIMARY KEY  (`id`),
  51   KEY `answer_question_id` (`question_id`),
  52   KEY `answer_author_id` (`author_id`),
  53   KEY `answer_deleted_by_id` (`deleted_by_id`),
  54   KEY `answer_locked_by_id` (`locked_by_id`),
  55   KEY `answer_last_edited_by_id` (`last_edited_by_id`),
  56   CONSTRAINT `author_id_refs_id_192b0170` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`),
  57   CONSTRAINT `deleted_by_id_refs_id_192b0170` FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`),
  58   CONSTRAINT `last_edited_by_id_refs_id_192b0170` FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`),
  59   CONSTRAINT `locked_by_id_refs_id_192b0170` FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`),
  60   CONSTRAINT `question_id_refs_id_7d6550c9` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
  61 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  62
  63 --
  64 -- Definition of table `cnprog`.`auth_group`
  65 --
  66
  67 DROP TABLE IF EXISTS `cnprog`.`auth_group`;
  68 CREATE TABLE  `cnprog`.`auth_group` (
  69   `id` int(11) NOT NULL auto_increment,
  70   `name` varchar(80) NOT NULL,
  71   PRIMARY KEY  (`id`),
  72   UNIQUE KEY `name` (`name`)
  73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  74
  75 --
  76 -- Dumping data for table `cnprog`.`auth_group`
  77 --
  78
  79 --
  80 -- Definition of table `cnprog`.`auth_group_permissions`
  81 --
  82
  83 DROP TABLE IF EXISTS `cnprog`.`auth_group_permissions`;
  84 CREATE TABLE  `cnprog`.`auth_group_permissions` (
  85   `id` int(11) NOT NULL auto_increment,
  86   `group_id` int(11) NOT NULL,
  87   `permission_id` int(11) NOT NULL,
  88   PRIMARY KEY  (`id`),
  89   UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  90   KEY `permission_id_refs_id_5886d21f` (`permission_id`),
  91   CONSTRAINT `group_id_refs_id_3cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  92   CONSTRAINT `permission_id_refs_id_5886d21f` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
  93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  94
  95 --
  96 -- Dumping data for table `cnprog`.`auth_group_permissions`
  97 --
  98
  99 --
 100 -- Definition of table `cnprog`.`auth_message`
 101 --
 102
 103 DROP TABLE IF EXISTS `cnprog`.`auth_message`;
 104 CREATE TABLE  `cnprog`.`auth_message` (
 105   `id` int(11) NOT NULL auto_increment,
 106   `user_id` int(11) NOT NULL,
 107   `message` longtext NOT NULL,
 108   PRIMARY KEY  (`id`),
 109   KEY `auth_message_user_id` (`user_id`),
 110   CONSTRAINT `user_id_refs_id_650f49a6` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 111 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 112
 113 --
 114 -- Dumping data for table `cnprog`.`auth_message`
 115 --
 116
 117 --
 118 -- Definition of table `cnprog`.`auth_permission`
 119 --
 120
 121 DROP TABLE IF EXISTS `cnprog`.`auth_permission`;
 122 CREATE TABLE  `cnprog`.`auth_permission` (
 123   `id` int(11) NOT NULL auto_increment,
 124   `name` varchar(50) NOT NULL,
 125   `content_type_id` int(11) NOT NULL,
 126   `codename` varchar(100) NOT NULL,
 127   PRIMARY KEY  (`id`),
 128   UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
 129   KEY `auth_permission_content_type_id` (`content_type_id`),
 130   CONSTRAINT `content_type_id_refs_id_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
 131 ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
 132
 133 --
 134 -- Dumping data for table `cnprog`.`auth_permission`
 135 --
 136 INSERT INTO `cnprog`.`auth_permission` VALUES  (1,'Can add permission',1,'add_permission'),
 137  (2,'Can change permission',1,'change_permission'),
 138  (3,'Can delete permission',1,'delete_permission'),
 139  (4,'Can add group',2,'add_group'),
 140  (5,'Can change group',2,'change_group'),
 141  (6,'Can delete group',2,'delete_group'),
 142  (7,'Can add user',3,'add_user'),
 143  (8,'Can change user',3,'change_user'),
 144  (9,'Can delete user',3,'delete_user'),
 145  (10,'Can add message',4,'add_message'),
 146  (11,'Can change message',4,'change_message'),
 147  (12,'Can delete message',4,'delete_message'),
 148  (13,'Can add content type',5,'add_contenttype'),
 149  (14,'Can change content type',5,'change_contenttype'),
 150  (15,'Can delete content type',5,'delete_contenttype'),
 151  (16,'Can add session',6,'add_session'),
 152  (17,'Can change session',6,'change_session'),
 153  (18,'Can delete session',6,'delete_session'),
 154  (19,'Can add site',7,'add_site'),
 155  (20,'Can change site',7,'change_site'),
 156  (21,'Can delete site',7,'delete_site'),
 157  (25,'Can add answer',9,'add_answer'),
 158  (26,'Can change answer',9,'change_answer'),
 159  (27,'Can delete answer',9,'delete_answer'),
 160  (28,'Can add comment',10,'add_comment'),
 161  (29,'Can change comment',10,'change_comment'),
 162  (30,'Can delete comment',10,'delete_comment'),
 163  (31,'Can add tag',11,'add_tag'),
 164  (32,'Can change tag',11,'change_tag'),
 165  (33,'Can delete tag',11,'delete_tag'),
 166  (37,'Can add nonce',13,'add_nonce'),
 167  (38,'Can change nonce',13,'change_nonce'),
 168  (39,'Can delete nonce',13,'delete_nonce'),
 169  (40,'Can add association',14,'add_association'),
 170  (41,'Can change association',14,'change_association'),
 171  (42,'Can delete association',14,'delete_association'),
 172  (43,'Can add nonce',15,'add_nonce'),
 173  (44,'Can change nonce',15,'change_nonce'),
 174  (45,'Can delete nonce',15,'delete_nonce'),
 175  (46,'Can add association',16,'add_association'),
 176  (47,'Can change association',16,'change_association'),
 177  (48,'Can delete association',16,'delete_association'),
 178  (49,'Can add user association',17,'add_userassociation'),
 179  (50,'Can change user association',17,'change_userassociation'),
 180  (51,'Can delete user association',17,'delete_userassociation'),
 181  (52,'Can add user password queue',18,'add_userpasswordqueue'),
 182  (53,'Can change user password queue',18,'change_userpasswordqueue'),
 183  (54,'Can delete user password queue',18,'delete_userpasswordqueue'),
 184  (55,'Can add log entry',19,'add_logentry'),
 185  (56,'Can change log entry',19,'change_logentry'),
 186  (57,'Can delete log entry',19,'delete_logentry'),
 187  (58,'Can add question',20,'add_question'),
 188  (59,'Can change question',20,'change_question'),
 189  (60,'Can delete question',20,'delete_question'),
 190  (61,'Can add vote',21,'add_vote'),
 191  (62,'Can change vote',21,'change_vote'),
 192  (63,'Can delete vote',21,'delete_vote'),
 193  (64,'Can add flagged item',22,'add_flaggeditem'),
 194  (65,'Can change flagged item',22,'change_flaggeditem'),
 195  (66,'Can delete flagged item',22,'delete_flaggeditem'),
 196  (67,'Can add favorite question',23,'add_favoritequestion'),
 197  (68,'Can change favorite question',23,'change_favoritequestion'),
 198  (69,'Can delete favorite question',23,'delete_favoritequestion'),
 199  (70,'Can add badge',24,'add_badge'),
 200  (71,'Can change badge',24,'change_badge'),
 201  (72,'Can delete badge',24,'delete_badge'),
 202  (73,'Can add award',25,'add_award'),
 203  (74,'Can change award',25,'change_award'),
 204  (75,'Can delete award',25,'delete_award');
 205
 206 --
 207 -- Definition of table `cnprog`.`auth_user`
 208 --
 209
 210 DROP TABLE IF EXISTS `cnprog`.`auth_user`;
 211 CREATE TABLE  `cnprog`.`auth_user` (
 212   `id` int(11) NOT NULL auto_increment,
 213   `username` varchar(30) NOT NULL,
 214   `first_name` varchar(30) NOT NULL,
 215   `last_name` varchar(30) NOT NULL,
 216   `email` varchar(75) NOT NULL,
 217   `password` varchar(128) NOT NULL,
 218   `is_staff` tinyint(1) NOT NULL,
 219   `is_active` tinyint(1) NOT NULL,
 220   `is_superuser` tinyint(1) NOT NULL,
 221   `last_login` datetime NOT NULL,
 222   `date_joined` datetime NOT NULL,
 223   `gold` smallint(6) NOT NULL default '0',
 224   `silver` smallint(5) unsigned NOT NULL default '0',
 225   `bronze` smallint(5) unsigned NOT NULL default '0',
 226   `reputation` int(10) unsigned default '1',
 227   `gravatar` varchar(128) default NULL,
 228   `questions_per_page` smallint(5) unsigned default '10',
 229   `last_seen` datetime default NULL,
 230   `real_name` varchar(100) default NULL,
 231   `website` varchar(200) default NULL,
 232   `location` varchar(100) default NULL,
 233   `date_of_birth` datetime default NULL,
 234   `about` text,
 235   PRIMARY KEY  (`id`),
 236   UNIQUE KEY `username` (`username`)
 237 ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
 238
 239 --
 240 -- Dumping data for table `cnprog`.`auth_user`
 241 --
 242 INSERT INTO `cnprog`.`auth_user` VALUES  (2,'chagel','','','chagel@gmail.com','sha1$6a2fb$0d2ffe90bcba542fc962f57967a88e507799cc74',1,1,1,'2008-12-16 15:35:17','2008-12-11 20:12:53',0,0,0,1,'8c1efc4f4618aa68b18c88f2bcaa5564',10,NULL,NULL,NULL,NULL,NULL,NULL),
 243  (3,'mike','','','ichagel@yahoo.com','sha1$f7ef5$1015ae6b2c8a2774a028419d3c57e13145b83284',0,1,0,'2008-12-15 12:56:23','2008-12-15 12:56:23',0,0,0,1,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL),
 244  (4,'sailingcai','','','sailingcai@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-23 06:14:45','2008-12-20 15:19:21',1,2,3,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','',NULL,''),
 245  (5,'sailingcai1','','','1@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21',NULL,NULL,NULL,NULL,NULL),
 246  (6,'sailing2','','','2@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 247  (7,'sailing3','','','3@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 248  (8,'sailing4','','','4@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 249  (9,'sailing5','','','5@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 250  (10,'sailing6','','','6@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 251  (11,'sailing7','','','7@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 252  (12,'sailing8','','','8@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 253  (13,'sailing9','','','9@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 254  (14,'sailing10','','','10@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 255  (15,'sailing11','','','11@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 256  (16,'sailing12','','','12@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 257  (17,'sailing13','','','13@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 258  (18,'sailing14','','','14@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 259  (19,'sailing15','','','15@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 260  (20,'sailing16','','','16@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 261  (21,'sailing17','','','17@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 262  (22,'sailing18','','','18@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 263  (23,'sailing19','','','19@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 264  (24,'sailing20','','','20@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 265  (25,'sailing21','','','21@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 266  (26,'sailing22','','','22@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 267  (27,'sailing23','','','23@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 268  (28,'sailing24','','','24@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 269  (29,'sailing25','','','25@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 270  (30,'sailing26','','','26@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 271  (31,'sailing27','','','27@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 272  (32,'sailing28','','','28@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 273  (33,'sailing29','','','29@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 274  (34,'sailing30','','','30@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 275  (35,'sailing31','','','31@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 276  (36,'sailing32','','','32@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 277  (37,'sailing33','','','33@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 278  (38,'sailing34','','','34@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 279  (39,'sailing35','','','35@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 280  (40,'sailing36','','','36@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 281  (41,'sailing37','','','37@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 282  (42,'sailing38','','','38@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 283  (43,'sailing39','','','39@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 284  (44,'sailing40','','','40@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 285  (45,'sailing41','','','41@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 286  (46,'sailing42','','','42@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 287  (47,'sailing43','','','43@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 288  (48,'sailing44','','','44@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 289  (49,'sailing45','','','45@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 290  (50,'sailing46','','','46@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 291  (51,'sailing47','','','47@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 292  (52,'sailing48','','','48@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 293  (53,'sailing49','','','49@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 294  (54,'sailing50','','','50@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 295  (55,'sailing51','','','51@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 296  (56,'sailing52','','','52@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 297  (57,'sailing53','','','53@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 298  (58,'sailing54','','','54@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 299  (59,'sailing55','','','55@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 300  (60,'sailing56','','','56@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 301  (61,'sailing57','','','57@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 302  (62,'sailing58','','','58@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 303  (63,'sailing59','','','59@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 304  (64,'sailing60','','','60@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 305  (65,'sailing61','','','61@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 306  (66,'sailing62','','','62@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 307  (67,'sailing63','','','63@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 308  (68,'sailing64','','','64@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 309  (69,'sailing65','','','65@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 310  (70,'sailing66','','','66@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 311  (71,'sailing67','','','67@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 312  (72,'sailing68','','','68@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 313  (73,'sailing69','','','69@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 314  (74,'sailing70','','','70@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 315  (75,'sailing71','','','71@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 316  (76,'sailing72','','','72@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 317  (77,'sailing73','','','73@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 318  (78,'sailing74','','','74@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 319  (79,'sailing75','','','75@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 320  (80,'sailing76','','','76@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 321  (81,'sailing77','','','77@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 322  (82,'sailing78','','','78@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 323  (83,'sailing79','','','79@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 324  (84,'sailing80','','','80@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 325  (85,'sailing81','','','81@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 326  (86,'sailing82','','','82@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 327  (87,'sailing83','','','83@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 328  (88,'sailing84','','','84@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 329  (89,'sailing85','','','85@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 330  (90,'sailing86','','','86@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 331  (91,'sailing87','','','87@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 332  (92,'sailing88','','','88@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 333  (93,'sailing89','','','89@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 334  (94,'sailing90','','','90@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 335  (95,'sailing91','','','91@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 336  (96,'sailing92','','','92@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 337  (97,'sailing93','','','93@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 338  (98,'sailing94','','','94@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 339  (99,'sailing95','','','95@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 340  (100,'sailing96','','','96@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 341  (101,'sailing97','','','97@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 342  (102,'sailing98','','','98@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00',''),
 343  (103,'sailing99','','','99@gmail.com','sha1$a417c$ca7d9f2ad55666bf98068cc392b6f62450b216e0',0,1,0,'2008-12-20 15:19:21','2008-12-20 15:19:21',0,0,0,1,'a1cb9864605a32760518b90a4f9a0e73',10,'2008-12-20 15:19:21','','','','0000-00-00 00:00:00','');
 344
 345 --
 346 -- Definition of table `cnprog`.`auth_user_groups`
 347 --
 348
 349 DROP TABLE IF EXISTS `cnprog`.`auth_user_groups`;
 350 CREATE TABLE  `cnprog`.`auth_user_groups` (
 351   `id` int(11) NOT NULL auto_increment,
 352   `user_id` int(11) NOT NULL,
 353   `group_id` int(11) NOT NULL,
 354   PRIMARY KEY  (`id`),
 355   UNIQUE KEY `user_id` (`user_id`,`group_id`),
 356   KEY `group_id_refs_id_f116770` (`group_id`),
 357   CONSTRAINT `group_id_refs_id_f116770` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
 358   CONSTRAINT `user_id_refs_id_7ceef80f` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 359 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 360
 361 --
 362 -- Dumping data for table `cnprog`.`auth_user_groups`
 363 --
 364
 365 --
 366 -- Definition of table `cnprog`.`auth_user_user_permissions`
 367 --
 368
 369 DROP TABLE IF EXISTS `cnprog`.`auth_user_user_permissions`;
 370 CREATE TABLE  `cnprog`.`auth_user_user_permissions` (
 371   `id` int(11) NOT NULL auto_increment,
 372   `user_id` int(11) NOT NULL,
 373   `permission_id` int(11) NOT NULL,
 374   PRIMARY KEY  (`id`),
 375   UNIQUE KEY `user_id` (`user_id`,`permission_id`),
 376   KEY `permission_id_refs_id_67e79cb` (`permission_id`),
 377   CONSTRAINT `permission_id_refs_id_67e79cb` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
 378   CONSTRAINT `user_id_refs_id_dfbab7d` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 379 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 380
 381 --
 382 -- Dumping data for table `cnprog`.`auth_user_user_permissions`
 383 --
 384
 385 --
 386 -- Definition of table `cnprog`.`award`
 387 --
 388
 389 DROP TABLE IF EXISTS `cnprog`.`award`;
 390 CREATE TABLE  `cnprog`.`award` (
 391   `id` int(11) NOT NULL auto_increment,
 392   `user_id` int(11) NOT NULL,
 393   `badge_id` int(11) NOT NULL,
 394   `awarded_at` datetime NOT NULL,
 395   `notified` tinyint(1) NOT NULL,
 396   PRIMARY KEY  (`id`),
 397   KEY `award_user_id` (`user_id`),
 398   KEY `award_badge_id` (`badge_id`),
 399   CONSTRAINT `badge_id_refs_id_651af0e1` FOREIGN KEY (`badge_id`) REFERENCES `badge` (`id`),
 400   CONSTRAINT `user_id_refs_id_2d83e9b6` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 401 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 402
 403 --
 404 -- Dumping data for table `cnprog`.`award`
 405 --
 406
 407 --
 408 -- Definition of table `cnprog`.`badge`
 409 --
 410
 411 DROP TABLE IF EXISTS `cnprog`.`badge`;
 412 CREATE TABLE  `cnprog`.`badge` (
 413   `id` int(11) NOT NULL auto_increment,
 414   `name` varchar(50) NOT NULL,
 415   `type` smallint(6) NOT NULL,
 416   `slug` varchar(50) NOT NULL,
 417   `description` varchar(300) NOT NULL,
 418   `multiple` tinyint(1) NOT NULL,
 419   `awarded_count` int(10) unsigned NOT NULL,
 420   PRIMARY KEY  (`id`),
 421   UNIQUE KEY `name` (`name`,`type`),
 422   KEY `badge_slug` (`slug`)
 423 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 424
 425 --
 426 -- Dumping data for table `cnprog`.`badge`
 427 --
 428
 429 --
 430 -- Definition of table `cnprog`.`comment`
 431 --
 432
 433 DROP TABLE IF EXISTS `cnprog`.`comment`;
 434 CREATE TABLE  `cnprog`.`comment` (
 435   `id` int(11) NOT NULL auto_increment,
 436   `content_type_id` int(11) NOT NULL,
 437   `object_id` int(10) unsigned NOT NULL,
 438   `user_id` int(11) NOT NULL,
 439   `comment` varchar(300) NOT NULL,
 440   `added_at` datetime NOT NULL,
 441   PRIMARY KEY  (`id`),
 442   KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
 443   KEY `comment_content_type_id` (`content_type_id`),
 444   KEY `comment_user_id` (`user_id`),
 445   CONSTRAINT `content_type_id_refs_id_13a5866c` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
 446   CONSTRAINT `user_id_refs_id_6be725e8` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 447 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 448
 449 --
 450 -- Dumping data for table `cnprog`.`comment`
 451 --
 452
 453 --
 454 -- Definition of table `cnprog`.`django_admin_log`
 455 --
 456
 457 DROP TABLE IF EXISTS `cnprog`.`django_admin_log`;
 458 CREATE TABLE  `cnprog`.`django_admin_log` (
 459   `id` int(11) NOT NULL auto_increment,
 460   `action_time` datetime NOT NULL,
 461   `user_id` int(11) NOT NULL,
 462   `content_type_id` int(11) default NULL,
 463   `object_id` longtext,
 464   `object_repr` varchar(200) NOT NULL,
 465   `action_flag` smallint(5) unsigned NOT NULL,
 466   `change_message` longtext NOT NULL,
 467   PRIMARY KEY  (`id`),
 468   KEY `django_admin_log_user_id` (`user_id`),
 469   KEY `django_admin_log_content_type_id` (`content_type_id`),
 470   CONSTRAINT `content_type_id_refs_id_288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
 471   CONSTRAINT `user_id_refs_id_c8665aa` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 472 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 473
 474 --
 475 -- Dumping data for table `cnprog`.`django_admin_log`
 476 --
 477 INSERT INTO `cnprog`.`django_admin_log` VALUES  (1,'2008-12-18 23:41:41',2,7,'1','cnprog.com',2,'已修改 domain 和 name 。');
 478
 479 --
 480 -- Definition of table `cnprog`.`django_authopenid_association`
 481 --
 482
 483 DROP TABLE IF EXISTS `cnprog`.`django_authopenid_association`;
 484 CREATE TABLE  `cnprog`.`django_authopenid_association` (
 485   `id` int(11) NOT NULL auto_increment,
 486   `server_url` longtext NOT NULL,
 487   `handle` varchar(255) NOT NULL,
 488   `secret` longtext NOT NULL,
 489   `issued` int(11) NOT NULL,
 490   `lifetime` int(11) NOT NULL,
 491   `assoc_type` longtext NOT NULL,
 492   PRIMARY KEY  (`id`)
 493 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
 494
 495 --
 496 -- Dumping data for table `cnprog`.`django_authopenid_association`
 497 --
 498 INSERT INTO `cnprog`.`django_authopenid_association` VALUES  (2,'https://www.google.com/accounts/o8/ud','AOQobUfcCH4sgjsBGGscrzxIa5UM4clofAB6nixx8Qq_NWco4ynn_Kc4','u5cva43abzdwF8CJOFZfkzfk7x8=\n',1229022261,1229022261,'HMAC-SHA1'),
 499  (3,'https://api.screenname.aol.com/auth/openidServer','diAyLjAgayAwIGJhT2VvYkdDZ21RSHJ4QldzQnhTdjIxV3BVbz0%3D-j5HRXRB1VbPyg48jGKE1Q70dfv76lGHEPwd9071%2FJ7f6SSw5YhakrwWpsVXtr34T6iHwPDdo6RU%3D','EmQL3+5oR6mFKIaeBNy6hXyUJ/w=\n',1229282202,1229282202,'HMAC-SHA1'),
 500  (4,'https://open.login.yahooapis.com/openid/op/auth','JcBeY.uWXu2YjzbuCQiqFzAb0MIc7ATeKiPO4eAp3vluPMqZp_NCxepvMLGrJjxxDKTaNnr06wepMos8ap6SQYZiTi51tZ05lMWnpZAiOA1hsq_WMlEL7G9YE66GEA9A','QXiuN6B7E8nP5QhyHI3IB26t4SA=\n',1229282256,1229282256,'HMAC-SHA1'),
 501  (5,'http://openid.claimid.com/server','{HMAC-SHA1}{494575fd}{uLEbxQ==}','GvPbkgMHh0QVPH7mStCGuWb2AKY=\n',1229288957,1229288957,'HMAC-SHA1'),
 502  (6,'http://www.blogger.com/openid-server.g','oida-1229424484019-158830626','8gaU4aKnIFCLKIkHdxZQp7ZGNck=\n',1229424478,1229424478,'HMAC-SHA1');
 503
 504 --
 505 -- Definition of table `cnprog`.`django_authopenid_nonce`
 506 --
 507
 508 DROP TABLE IF EXISTS `cnprog`.`django_authopenid_nonce`;
 509 CREATE TABLE  `cnprog`.`django_authopenid_nonce` (
 510   `id` int(11) NOT NULL auto_increment,
 511   `server_url` varchar(255) NOT NULL,
 512   `timestamp` int(11) NOT NULL,
 513   `salt` varchar(40) NOT NULL,
 514   PRIMARY KEY  (`id`)
 515 ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
 516
 517 --
 518 -- Definition of table `cnprog`.`django_authopenid_userassociation`
 519 --
 520
 521 DROP TABLE IF EXISTS `cnprog`.`django_authopenid_userassociation`;
 522 CREATE TABLE  `cnprog`.`django_authopenid_userassociation` (
 523   `id` int(11) NOT NULL auto_increment,
 524   `openid_url` varchar(255) NOT NULL,
 525   `user_id` int(11) NOT NULL,
 526   PRIMARY KEY  (`id`),
 527   UNIQUE KEY `user_id` (`user_id`),
 528   CONSTRAINT `user_id_refs_id_163d208d` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 529 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
 530
 531 --
 532 -- Dumping data for table `cnprog`.`django_authopenid_userassociation`
 533 --
 534 INSERT INTO `cnprog`.`django_authopenid_userassociation` VALUES  (2,'https://www.google.com/accounts/o8/id?id=AItOawl7CVVHl4DWtteqj4dd_A23zKRwPZgOOjw',2),
 535  (3,'https://me.yahoo.com/a/f8f2zXF91okYL4iN2Zh4P542a5s-#f4af2',3),
 536  (4,'https://me.yahoo.com/sailingcai#6fa4e',4);
 537
 538 --
 539 -- Definition of table `cnprog`.`django_authopenid_userpasswordqueue`
 540 --
 541
 542 DROP TABLE IF EXISTS `cnprog`.`django_authopenid_userpasswordqueue`;
 543 CREATE TABLE  `cnprog`.`django_authopenid_userpasswordqueue` (
 544   `id` int(11) NOT NULL auto_increment,
 545   `user_id` int(11) NOT NULL,
 546   `new_password` varchar(30) NOT NULL,
 547   `confirm_key` varchar(40) NOT NULL,
 548   PRIMARY KEY  (`id`),
 549   UNIQUE KEY `user_id` (`user_id`),
 550   CONSTRAINT `user_id_refs_id_76bcaaa4` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 551 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 552
 553 --
 554 -- Dumping data for table `cnprog`.`django_authopenid_userpasswordqueue`
 555 --
 556
 557 --
 558 -- Definition of table `cnprog`.`django_content_type`
 559 --
 560
 561 DROP TABLE IF EXISTS `cnprog`.`django_content_type`;
 562 CREATE TABLE  `cnprog`.`django_content_type` (
 563   `id` int(11) NOT NULL auto_increment,
 564   `name` varchar(100) NOT NULL,
 565   `app_label` varchar(100) NOT NULL,
 566   `model` varchar(100) NOT NULL,
 567   PRIMARY KEY  (`id`),
 568   UNIQUE KEY `app_label` (`app_label`,`model`)
 569 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
 570
 571 --
 572 -- Dumping data for table `cnprog`.`django_content_type`
 573 --
 574 INSERT INTO `cnprog`.`django_content_type` VALUES  (1,'permission','auth','permission'),
 575  (2,'group','auth','group'),
 576  (3,'user','auth','user'),
 577  (4,'message','auth','message'),
 578  (5,'content type','contenttypes','contenttype'),
 579  (6,'session','sessions','session'),
 580  (7,'site','sites','site'),
 581  (9,'answer','forum','answer'),
 582  (10,'comment','forum','comment'),
 583  (11,'tag','forum','tag'),
 584  (13,'nonce','django_openidconsumer','nonce'),
 585  (14,'association','django_openidconsumer','association'),
 586  (15,'nonce','django_authopenid','nonce'),
 587  (16,'association','django_authopenid','association'),
 588  (17,'user association','django_authopenid','userassociation'),
 589  (18,'user password queue','django_authopenid','userpasswordqueue'),
 590  (19,'log entry','admin','logentry'),
 591  (20,'question','forum','question'),
 592  (21,'vote','forum','vote'),
 593  (22,'flagged item','forum','flaggeditem'),
 594  (23,'favorite question','forum','favoritequestion'),
 595  (24,'badge','forum','badge'),
 596  (25,'award','forum','award');
 597
 598 --
 599 -- Definition of table `cnprog`.`django_session`
 600 --
 601
 602 DROP TABLE IF EXISTS `cnprog`.`django_session`;
 603 CREATE TABLE  `cnprog`.`django_session` (
 604   `session_key` varchar(40) NOT NULL,
 605   `session_data` longtext NOT NULL,
 606   `expire_date` datetime NOT NULL,
 607   PRIMARY KEY  (`session_key`)
 608 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 609
 610 --
 611 -- Definition of table `cnprog`.`django_site`
 612 --
 613
 614 DROP TABLE IF EXISTS `cnprog`.`django_site`;
 615 CREATE TABLE  `cnprog`.`django_site` (
 616   `id` int(11) NOT NULL auto_increment,
 617   `domain` varchar(100) NOT NULL,
 618   `name` varchar(50) NOT NULL,
 619   PRIMARY KEY  (`id`)
 620 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 621
 622 --
 623 -- Dumping data for table `cnprog`.`django_site`
 624 --
 625 INSERT INTO `cnprog`.`django_site` VALUES  (1,'cnprog.com','CNProg.com');
 626
 627 --
 628 -- Definition of table `cnprog`.`favorite_question`
 629 --
 630
 631 DROP TABLE IF EXISTS `cnprog`.`favorite_question`;
 632 CREATE TABLE  `cnprog`.`favorite_question` (
 633   `id` int(11) NOT NULL auto_increment,
 634   `question_id` int(11) NOT NULL,
 635   `user_id` int(11) NOT NULL,
 636   `added_at` datetime NOT NULL,
 637   PRIMARY KEY  (`id`),
 638   KEY `favorite_question_question_id` (`question_id`),
 639   KEY `favorite_question_user_id` (`user_id`),
 640   CONSTRAINT `question_id_refs_id_1ebe1cc3` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`),
 641   CONSTRAINT `user_id_refs_id_52853822` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 642 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 643
 644 --
 645 -- Dumping data for table `cnprog`.`favorite_question`
 646 --
 647
 648 --
 649 -- Definition of table `cnprog`.`flagged_item`
 650 --
 651
 652 DROP TABLE IF EXISTS `cnprog`.`flagged_item`;
 653 CREATE TABLE  `cnprog`.`flagged_item` (
 654   `id` int(11) NOT NULL auto_increment,
 655   `content_type_id` int(11) NOT NULL,
 656   `object_id` int(10) unsigned NOT NULL,
 657   `user_id` int(11) NOT NULL,
 658   `flagged_at` datetime NOT NULL,
 659   PRIMARY KEY  (`id`),
 660   UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
 661   KEY `flagged_item_content_type_id` (`content_type_id`),
 662   KEY `flagged_item_user_id` (`user_id`),
 663   CONSTRAINT `content_type_id_refs_id_76e44d74` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
 664   CONSTRAINT `user_id_refs_id_35e3c608` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 665 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 666
 667 --
 668 -- Dumping data for table `cnprog`.`flagged_item`
 669 --
 670
 671 --
 672 -- Definition of table `cnprog`.`question`
 673 --
 674
 675 DROP TABLE IF EXISTS `cnprog`.`question`;
 676 CREATE TABLE  `cnprog`.`question` (
 677   `id` int(11) NOT NULL auto_increment,
 678   `title` varchar(300) NOT NULL,
 679   `author_id` int(11) NOT NULL,
 680   `added_at` datetime NOT NULL,
 681   `wiki` tinyint(1) NOT NULL,
 682   `wikified_at` datetime default NULL,
 683   `answer_accepted` tinyint(1) NOT NULL,
 684   `closed` tinyint(1) NOT NULL,
 685   `closed_by_id` int(11) default NULL,
 686   `closed_at` datetime default NULL,
 687   `close_reason` smallint(6) default NULL,
 688   `deleted` tinyint(1) NOT NULL,
 689   `deleted_at` datetime default NULL,
 690   `deleted_by_id` int(11) default NULL,
 691   `locked` tinyint(1) NOT NULL,
 692   `locked_by_id` int(11) default NULL,
 693   `locked_at` datetime default NULL,
 694   `vote_up_count` int(11) NOT NULL,
 695   `vote_down_count` int(11) NOT NULL,
 696   `score` int(11) NOT NULL,
 697   `answer_count` int(10) unsigned NOT NULL,
 698   `comment_count` int(10) unsigned NOT NULL,
 699   `view_count` int(10) unsigned NOT NULL,
 700   `offensive_flag_count` smallint(6) NOT NULL,
 701   `favourite_count` int(10) unsigned NOT NULL,
 702   `last_edited_at` datetime default NULL,
 703   `last_edited_by_id` int(11) default NULL,
 704   `last_activity_at` datetime NOT NULL,
 705   `last_activity_by_id` int(11) NOT NULL,
 706   `tagnames` varchar(125) NOT NULL,
 707   `summary` varchar(180) NOT NULL,
 708   `html` longtext NOT NULL,
 709   PRIMARY KEY  (`id`),
 710   KEY `question_author_id` (`author_id`),
 711   KEY `question_closed_by_id` (`closed_by_id`),
 712   KEY `question_deleted_by_id` (`deleted_by_id`),
 713   KEY `question_locked_by_id` (`locked_by_id`),
 714   KEY `question_last_edited_by_id` (`last_edited_by_id`),
 715   KEY `question_last_activity_by_id` (`last_activity_by_id`),
 716   CONSTRAINT `author_id_refs_id_56e9d00c` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`),
 717   CONSTRAINT `closed_by_id_refs_id_56e9d00c` FOREIGN KEY (`closed_by_id`) REFERENCES `auth_user` (`id`),
 718   CONSTRAINT `deleted_by_id_refs_id_56e9d00c` FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`),
 719   CONSTRAINT `last_activity_by_id_refs_id_56e9d00c` FOREIGN KEY (`last_activity_by_id`) REFERENCES `auth_user` (`id`),
 720   CONSTRAINT `last_edited_by_id_refs_id_56e9d00c` FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`),
 721   CONSTRAINT `locked_by_id_refs_id_56e9d00c` FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`)
 722 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
 723
 724 --
 725 -- Definition of table `cnprog`.`question_tags`
 726 --
 727
 728 DROP TABLE IF EXISTS `cnprog`.`question_tags`;
 729 CREATE TABLE  `cnprog`.`question_tags` (
 730   `id` int(11) NOT NULL auto_increment,
 731   `question_id` int(11) NOT NULL,
 732   `tag_id` int(11) NOT NULL,
 733   PRIMARY KEY  (`id`),
 734   UNIQUE KEY `question_id` (`question_id`,`tag_id`),
 735   KEY `tag_id_refs_id_43fcb953` (`tag_id`),
 736   CONSTRAINT `question_id_refs_id_266147c6` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`),
 737   CONSTRAINT `tag_id_refs_id_43fcb953` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
 738 ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
 739
 740 --
 741 -- Definition of table `cnprog`.`tag`
 742 --
 743
 744 DROP TABLE IF EXISTS `cnprog`.`tag`;
 745 CREATE TABLE  `cnprog`.`tag` (
 746   `id` int(11) NOT NULL auto_increment,
 747   `name` varchar(255) NOT NULL,
 748   `created_by_id` int(11) NOT NULL,
 749   `used_count` int(10) unsigned NOT NULL,
 750   PRIMARY KEY  (`id`),
 751   UNIQUE KEY `name` (`name`),
 752   KEY `tag_created_by_id` (`created_by_id`),
 753   CONSTRAINT `created_by_id_refs_id_47205d6d` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
 754 ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
 755
 756 --
 757 -- Definition of table `cnprog`.`user_badge`
 758 --
 759
 760 DROP TABLE IF EXISTS `cnprog`.`user_badge`;
 761 CREATE TABLE  `cnprog`.`user_badge` (
 762   `id` int(10) unsigned NOT NULL auto_increment,
 763   `user_id` int(10) unsigned NOT NULL,
 764   `badge_id` int(10) unsigned NOT NULL,
 765   PRIMARY KEY  (`id`)
 766 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 767
 768 --
 769 -- Definition of table `cnprog`.`user_favorite_questions`
 770 --
 771
 772 DROP TABLE IF EXISTS `cnprog`.`user_favorite_questions`;
 773 CREATE TABLE  `cnprog`.`user_favorite_questions` (
 774   `id` int(10) unsigned NOT NULL auto_increment,
 775   `user_id` int(10) unsigned NOT NULL,
 776   `question_id` int(10) unsigned NOT NULL,
 777   PRIMARY KEY  (`id`)
 778 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 779
 780 --
 781 -- Dumping data for table `cnprog`.`user_favorite_questions`
 782 --
 783
 784 DROP TABLE IF EXISTS `cnprog`.`vote`;
 785 CREATE TABLE  `cnprog`.`vote` (
 786   `id` int(11) NOT NULL auto_increment,
 787   `content_type_id` int(11) NOT NULL,
 788   `object_id` int(10) unsigned NOT NULL,
 789   `user_id` int(11) NOT NULL,
 790   `vote` smallint(6) NOT NULL,
 791   PRIMARY KEY  (`id`),
 792   UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
 793   KEY `vote_content_type_id` (`content_type_id`),
 794   KEY `vote_user_id` (`user_id`),
 795   CONSTRAINT `content_type_id_refs_id_50124414` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
 796   CONSTRAINT `user_id_refs_id_760a4df0` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
 797 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 798
 799 --
 800 -- Dumping data for table `cnprog`.`vote`
 801 --
 802
 803
 804
 805 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 806 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 807 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 808 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 809 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 810 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 811 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;