   `name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
   `slug` varchar(50) COLLATE utf8_czech_ci NOT NULL,
   `logo_id` int(11) DEFAULT NULL,
-  `ordering` smallint(5) unsigned NOT NULL,
-  `visible` tinyint(1) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `slug` (`slug`)
+  `ordering` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `visible` tinyint(1) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `slug` (`slug`),
+  KEY `astrology_signdescriptiontype_logo_id` (`logo_id`),
+  CONSTRAINT `logo_id_refs_id_326537ac` FOREIGN KEY (`logo_id`) REFERENCES `photos_photo` (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 

  `content` longtext COLLATE utf8_czech_ci NOT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT '2009-05-19 12:05:39',
  PRIMARY KEY (`id`),
  KEY `galleries_gallery_slug` (`slug`),
  KEY `galleries_gallery_owner_id` (`owner_id`),

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `ordering` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
