|
From: <be...@us...> - 2014-01-26 11:40:53
|
Revision: 12278
http://sourceforge.net/p/xoops/svn/12278
Author: beckmi
Date: 2014-01-26 11:40:49 +0000 (Sun, 26 Jan 2014)
Log Message:
-----------
Fixing MySQL tables installation errors
Modified Paths:
--------------
XoopsModules/pedigree/trunk/pedigree/sql/mysql.sql
Modified: XoopsModules/pedigree/trunk/pedigree/sql/mysql.sql
===================================================================
--- XoopsModules/pedigree/trunk/pedigree/sql/mysql.sql 2014-01-26 01:21:57 UTC (rev 12277)
+++ XoopsModules/pedigree/trunk/pedigree/sql/mysql.sql 2014-01-26 11:40:49 UTC (rev 12278)
@@ -1,21 +1,6 @@
--- phpMyAdmin SQL Dump
--- version 2.8.2.4
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generatie Tijd: 03 Feb 2008 om 10:42
--- Server versie: 5.0.24
--- PHP Versie: 5.1.6
---
--- Database: `pedigree_candb`
---
+# Table structure for table `mod_pedigree_owner`
--- --------------------------------------------------------
---
--- Tabel structuur voor tabel `xovdk_owner`
---
-
CREATE TABLE `mod_pedigree_owner` (
`ID` int(11) NOT NULL auto_increment,
`firstname` varchar(30) NOT NULL default '',
@@ -32,12 +17,12 @@
KEY `lastname` (`lastname`(5))
) ENGINE=MyISAM AUTO_INCREMENT=1 COMMENT='owner information tree';
--- --------------------------------------------------------
+# --------------------------------------------------------
---
--- Tabel structuur voor tabel `xovdk_pedigree`
---
+# Table structure for table `mod_pedigree_tree`
+
+
CREATE TABLE `mod_pedigree_tree` (
`ID` mediumint(7) unsigned NOT NULL auto_increment,
`NAAM` text NOT NULL,
@@ -54,12 +39,12 @@
KEY `father` (`father`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--- --------------------------------------------------------
+# --------------------------------------------------------
---
--- Tabel structuur voor tabel `xovdk_pedigree_config`
---
+# Table structure for table `mod_pedigree_fields`
+
+
CREATE TABLE `mod_pedigree_fields` (
`ID` tinyint(2) NOT NULL auto_increment,
`isActive` tinyint(1) NOT NULL default '0',
@@ -82,12 +67,12 @@
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
--- --------------------------------------------------------
+# --------------------------------------------------------
---
--- Tabel structuur voor tabel `xovdk_pedigree_temp`
---
+# Table structure for table `mod_pedigree_temp`
+
+
CREATE TABLE `mod_pedigree_temp` (
`ID` int(11) NOT NULL default '0',
`NAAM` text NOT NULL,
@@ -104,12 +89,12 @@
KEY `father` (`father`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='temporary pedigree table to create detailed extracts';
--- --------------------------------------------------------
+# --------------------------------------------------------
---
--- Tabel structuur voor tabel `xovdk_pedigree_trash`
---
+# Table structure for table `mod_pedigree_trash`
+
+
CREATE TABLE `mod_pedigree_trash` (
`ID` int(11) NOT NULL auto_increment,
`NAAM` text NOT NULL,
|