[Xoops-svn] SF.net SVN: xoops-svn:[12857] XoopsModules/vide/branches/mamba/vide/sql/ mysql.sql

[<be...@us...>]

Revision: 12857
          http://sourceforge.net/p/xoops/svn/12857
Author:   beckmi
Date:     2014-11-18 08:08:15 +0000 (Tue, 18 Nov 2014)
Log Message:
-----------
fixing table names (missing underscore)

Modified Paths:
--------------
    XoopsModules/vide/branches/mamba/vide/sql/mysql.sql

Modified: XoopsModules/vide/branches/mamba/vide/sql/mysql.sql
===================================================================
--- XoopsModules/vide/branches/mamba/vide/sql/mysql.sql	2014-11-18 08:06:02 UTC (rev 12856)
+++ XoopsModules/vide/branches/mamba/vide/sql/mysql.sql	2014-11-18 08:08:15 UTC (rev 12857)
@@ -1,39 +1,50 @@
-CREATE TABLE `videlog` (
-  `id`            int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `titre`         varchar(25)   NOT NULL DEFAULT '',
-  `created`       datetime      NOT NULL,
-  `description`   varchar (100) NOT NULL DEFAULT '',
-  `userid`        int(11) unsigned  NOT NULL DEFAULT '0',
-  `ip`            varchar(50)   NOT NULL DEFAULT '',
-  `url`           varchar(150)  NOT NULL DEFAULT '',
-  `provenance`    varchar(150)  NOT NULL DEFAULT '',
+CREATE TABLE `vide_log` (
+  `id`          INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `titre`       VARCHAR(25)      NOT NULL DEFAULT '',
+  `created`     DATETIME         NOT NULL,
+  `description` VARCHAR(100)     NOT NULL DEFAULT '',
+  `userid`      INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `ip`          VARCHAR(50)      NOT NULL DEFAULT '',
+  `url`         VARCHAR(150)     NOT NULL DEFAULT '',
+  `provenance`  VARCHAR(150)     NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
-)ENGINE=MyISAM DEFAULT CHARSET=utf8;
-CREATE TABLE `videdivers` (
-  `id`            int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `nom`           varchar (25)  NOT NULL DEFAULT '',
-  `valeur`        varchar (150) NOT NULL DEFAULT '',
+)
+  ENGINE =MyISAM
+  DEFAULT CHARSET =utf8;
+
+CREATE TABLE `vide_divers` (
+  `id`     INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `nom`    VARCHAR(25)      NOT NULL DEFAULT '',
+  `valeur` VARCHAR(150)     NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
-)ENGINE=MyISAM DEFAULT CHARSET=utf8;
-CREATE TABLE `videcategorie` (
-  `id`            int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `pid`           int(11) unsigned NOT NULL DEFAULT '0',
-  `nom`           varchar(100) NOT NULL DEFAULT'',
-  `created`       datetime,
-  `descriptif`    text NOT NULL DEFAULT '',
-  `keywords`      text NOT NULL DEFAULT '',
-  `image`         varchar(200) NOT NULL DEFAULT '',
-  `actif`         tinyint(1) unsigned NOT NULL DEFAULT '0',
+)
+  ENGINE =MyISAM
+  DEFAULT CHARSET =utf8;
+
+CREATE TABLE `vide_categorie` (
+  `id`         INT(11) UNSIGNED    NOT NULL AUTO_INCREMENT,
+  `pid`        INT(11) UNSIGNED    NOT NULL DEFAULT '0',
+  `nom`        VARCHAR(100)        NOT NULL DEFAULT '',
+  `created`    DATETIME,
+  `descriptif` TEXT                NOT NULL DEFAULT '',
+  `keywords`   TEXT                NOT NULL DEFAULT '',
+  `image`      VARCHAR(200)        NOT NULL DEFAULT '',
+  `actif`      TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-)ENGINE=MyISAM DEFAULT CHARSET=utf8;
-CREATE TABLE `videitem` (
-  `id`            int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `cid`           int(11) unsigned NOT NULL DEFAULT '0',
-  `nom`           varchar(100) NOT NULL DEFAULT'',
-  `created`       datetime,
-  `descriptif`    text NOT NULL DEFAULT '',
-  `keywords`      text NOT NULL DEFAULT '',
-  `fichier`         varchar(200) NOT NULL DEFAULT '',
-  `actif`         tinyint(1) unsigned NOT NULL DEFAULT '0',
+)
+  ENGINE =MyISAM
+  DEFAULT CHARSET =utf8;
+
+CREATE TABLE `vide_item` (
+  `id`         INT(11) UNSIGNED    NOT NULL AUTO_INCREMENT,
+  `cid`        INT(11) UNSIGNED    NOT NULL DEFAULT '0',
+  `nom`        VARCHAR(100)        NOT NULL DEFAULT '',
+  `created`    DATETIME,
+  `descriptif` TEXT                NOT NULL DEFAULT '',
+  `keywords`   TEXT                NOT NULL DEFAULT '',
+  `fichier`    VARCHAR(200)        NOT NULL DEFAULT '',
+  `actif`      TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-)ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file
+)
+  ENGINE =MyISAM
+  DEFAULT CHARSET =utf8;