|
From: <txm...@us...> - 2014-06-24 19:48:51
|
Revision: 12641
http://sourceforge.net/p/xoops/svn/12641
Author: txmodxoops
Date: 2014-06-24 19:48:38 +0000 (Tue, 24 Jun 2014)
Log Message:
-----------
removed prefix 'mod_' from mysql files
Modified Paths:
--------------
XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/class/files/sql/mysql.php
XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql
Modified: XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/class/files/sql/mysql.php
===================================================================
--- XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/class/files/sql/mysql.php 2014-06-24 19:22:55 UTC (rev 12640)
+++ XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/class/files/sql/mysql.php 2014-06-24 19:48:38 UTC (rev 12641)
@@ -95,10 +95,10 @@
$ret = <<<SQL
#
-# Structure table for `mod_{$module_name}_{$table_name}` {$nb_fields}
+# Structure table for `{$module_name}_{$table_name}` {$nb_fields}
#
-CREATE TABLE `mod_{$module_name}_{$table_name}` (\n
+CREATE TABLE `{$module_name}_{$table_name}` (\n
SQL;
return $ret;
}
Modified: XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql
===================================================================
--- XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql 2014-06-24 19:22:55 UTC (rev 12640)
+++ XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql 2014-06-24 19:48:38 UTC (rev 12641)
@@ -1,4 +1,17 @@
-CREATE TABLE `mod_tdmcreate_modules` (
+# SQL Dump for tdmcreate module
+# PhpMyAdmin Version: 4.0.4
+# http://www.phpmyadmin.net
+#
+# Host: localhost
+# Generated on: Thu Jen 02, 2014 to 19:12
+# Server version: 5.5.24-log
+# PHP Version: 5.3.13
+
+#
+# Table structure for table `tdmcreate_modules` 37
+#
+
+CREATE TABLE `tdmcreate_modules` (
`mod_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`mod_name` VARCHAR(255) NOT NULL DEFAULT '',
`mod_version` VARCHAR(5) NOT NULL DEFAULT '1.0',
@@ -41,7 +54,7 @@
)ENGINE =MyISAM;
-CREATE TABLE `mod_tdmcreate_tables` (
+CREATE TABLE `tdmcreate_tables` (
`table_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`table_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`table_category` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
@@ -67,10 +80,10 @@
)ENGINE =MyISAM;
#
-# Table structure for table `mod_tdmcreate_fields` 21
+# Table structure for table `tdmcreate_fields` 21
#
-CREATE TABLE `mod_tdmcreate_fields` (
+CREATE TABLE `tdmcreate_fields` (
`field_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`field_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`field_tid` INT(5) UNSIGNED NOT NULL DEFAULT '0',
@@ -98,10 +111,10 @@
)ENGINE =MyISAM;
#
-# Table structure for table `mod_tdmcreate_languages` 5
+# Table structure for table `tdmcreate_languages` 5
#
-CREATE TABLE `mod_tdmcreate_languages` (
+CREATE TABLE `tdmcreate_languages` (
`lng_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`lng_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`lng_file` VARCHAR(255) NULL DEFAULT '',
@@ -112,16 +125,16 @@
)ENGINE =MyISAM;
#
-# Table structure for table `mod_tdmcreate_fieldtype` 2
+# Table structure for table `tdmcreate_fieldtype` 2
#
-CREATE TABLE `mod_tdmcreate_fieldtype` (
+CREATE TABLE `tdmcreate_fieldtype` (
`fieldtype_name` VARCHAR(255) NOT NULL DEFAULT '',
`fieldtype_value` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`fieldtype_name`)
)ENGINE =MyISAM;
-INSERT INTO `mod_tdmcreate_fieldtype` (`fieldtype_name`, `fieldtype_value`) VALUES
+INSERT INTO `tdmcreate_fieldtype` (`fieldtype_name`, `fieldtype_value`) VALUES
('', ''),
('INT', 'INT'),
('TINYINT', 'TINYINT'),
@@ -147,16 +160,16 @@
('YEAR', 'YEAR');
#
-# Table structure for table `mod_tdmcreate_fieldattributes` 3
+# Table structure for table `tdmcreate_fieldattributes` 3
#
-CREATE TABLE `mod_tdmcreate_fieldattributes` (
+CREATE TABLE `tdmcreate_fieldattributes` (
`fieldattribute_name` VARCHAR(255) NOT NULL DEFAULT '',
`fieldattribute_value` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`fieldattribute_name`)
)ENGINE =MyISAM;
-INSERT INTO `mod_tdmcreate_fieldattributes` (`fieldattribute_name`, `fieldattribute_value`) VALUES
+INSERT INTO `tdmcreate_fieldattributes` (`fieldattribute_name`, `fieldattribute_value`) VALUES
('', ''),
('BINARY', 'BINARY'),
('UNSIGNED', 'UNSIGNED'),
@@ -164,30 +177,30 @@
('CURRENT_TIMESTAMP', 'CURRENT_TIMESTAMP');
#
-# Table structure for table `mod_tdmcreate_fieldnull` 3
+# Table structure for table `tdmcreate_fieldnull` 3
#
-CREATE TABLE `mod_tdmcreate_fieldnull` (
+CREATE TABLE `tdmcreate_fieldnull` (
`fieldnull_name` VARCHAR(255) NOT NULL DEFAULT '',
`fieldnull_value` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`fieldnull_name`)
)ENGINE =MyISAM;
-INSERT INTO `mod_tdmcreate_fieldnull` (`fieldnull_name`, `fieldnull_value`) VALUES
+INSERT INTO `tdmcreate_fieldnull` (`fieldnull_name`, `fieldnull_value`) VALUES
('NOT NULL', 'NOT NULL'),
('NULL', 'NULL');
#
-# Table structure for table `mod_tdmcreate_fieldkey` 3
+# Table structure for table `tdmcreate_fieldkey` 3
#
-CREATE TABLE `mod_tdmcreate_fieldkey` (
+CREATE TABLE `tdmcreate_fieldkey` (
`fieldkey_name` VARCHAR(255) NOT NULL DEFAULT '',
`fieldkey_value` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`fieldkey_name`)
)ENGINE =MyISAM;
-INSERT INTO `mod_tdmcreate_fieldkey` (`fieldkey_name`, `fieldkey_value`) VALUES
+INSERT INTO `tdmcreate_fieldkey` (`fieldkey_name`, `fieldkey_value`) VALUES
('', ''),
('PRIMARY', 'PRIMARY KEY'),
('UNIQUE', 'UNIQUE KEY'),
@@ -195,10 +208,10 @@
('FULLTEXT', 'FULLTEXT');
#
-# Table structure for table `mod_tdmcreate_fieldelements` 3
+# Table structure for table `tdmcreate_fieldelements` 3
#
-CREATE TABLE `mod_tdmcreate_fieldelements` (
+CREATE TABLE `tdmcreate_fieldelements` (
`fieldelement_id` INT(5) NOT NULL AUTO_INCREMENT,
`fieldelement_mid` INT(11) NOT NULL DEFAULT '0',
`fieldelement_tid` INT(11) NOT NULL DEFAULT '0',
@@ -209,7 +222,7 @@
KEY `fieldelement_tid` (`fieldelement_tid`)
)ENGINE =MyISAM;
-INSERT INTO `mod_tdmcreate_fieldelements` (`fieldelement_id`, `fieldelement_mid`, `fieldelement_tid`, `fieldelement_name`, `fieldelement_value`) VALUES
+INSERT INTO `tdmcreate_fieldelements` (`fieldelement_id`, `fieldelement_mid`, `fieldelement_tid`, `fieldelement_name`, `fieldelement_value`) VALUES
(1, 0, 0, 'Text', 'XoopsFormText'),
(2, 0, 0, 'TextArea', 'XoopsFormTextArea'),
(3, 0, 0, 'DhtmlTextArea', 'XoopsFormDhtmlTextArea'),
@@ -220,4 +233,4 @@
(8, 0, 0, 'ColorPicker', 'XoopsFormColorPicker'),
(9, 0, 0, 'UploadImage', 'XoopsFormUploadImage'),
(10, 0, 0, 'UploadFile', 'XoopsFormUploadFile'),
- (11, 0, 0, 'TextDateSelect', 'XoopsFormTextDateSelect');
+ (11, 0, 0, 'TextDateSelect', 'XoopsFormTextDateSelect');
\ No newline at end of file
|