diff options
| author | ondrej.zara <none@none> | 2010-05-13 08:59:51 +0000 |
|---|---|---|
| committer | ondrej.zara <none@none> | 2010-05-13 08:59:51 +0000 |
| commit | 4ea8622c309d92d9eb4414b9877cae5a2afb4a4a (patch) | |
| tree | 2b5b014a36fdf6cbe6804eee86e30e764f10779c /backend/php-mysql | |
| parent | 93d7a568eaff34c9513a3b8e7ae06f7dc722b8ae (diff) | |
| download | wwwsqldesigner-4ea8622c309d92d9eb4414b9877cae5a2afb4a4a.zip wwwsqldesigner-4ea8622c309d92d9eb4414b9877cae5a2afb4a4a.tar.gz wwwsqldesigner-4ea8622c309d92d9eb4414b9877cae5a2afb4a4a.tar.bz2 | |
#95, changed data column size
--HG--
extra : convert_revision : svn%3Ab267cdba-c1da-11dd-874b-8bacd04a0a74/trunk%40105
Diffstat (limited to 'backend/php-mysql')
| -rw-r--r-- | backend/php-mysql/database.sql | 2 | ||||
| -rw-r--r-- | backend/php-mysql/index.php | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/backend/php-mysql/database.sql b/backend/php-mysql/database.sql index 9bdf1d6..ad05726 100644 --- a/backend/php-mysql/database.sql +++ b/backend/php-mysql/database.sql @@ -2,7 +2,7 @@ DROP TABLE IF EXISTS `wwwsqldesigner`; CREATE TABLE `wwwsqldesigner` ( `keyword` varchar(30) NOT NULL default '', - `data` text, + `data` mediumtext, `dt` timestamp, PRIMARY KEY (`keyword`) ); diff --git a/backend/php-mysql/index.php b/backend/php-mysql/index.php index 1c6859c..89cb690 100644 --- a/backend/php-mysql/index.php +++ b/backend/php-mysql/index.php @@ -39,7 +39,7 @@ $table = $row["TABLE_NAME"]; $xml .= '<table name="'.$table.'">'; $comment = (isset($row["TABLE_COMMENT"]) ? $row["TABLE_COMMENT"] : ""); - if ($comment) { $xml .= '<comment>'.$comment.'</comment>'; } + if ($comment) { $xml .= '<comment>'.htmlspecialchars($comment).'</comment>'; } $q = "SELECT * FROM COLUMNS WHERE TABLE_NAME = '".$table."' AND TABLE_SCHEMA = '".$db."'"; $result2 = mysql_query($q); @@ -54,7 +54,7 @@ $xml .= '<row name="'.$name.'" null="'.$null.'" autoincrement="'.$ai.'">'; $xml .= '<datatype>'.strtoupper($type).'</datatype>'; $xml .= '<default>'.$def.'</default>'; - if ($comment) { $xml .= '<comment>'.$comment.'</comment>'; } + if ($comment) { $xml .= '<comment>'.htmlspecialchars($comment).'</comment>'; } /* fk constraints */ $q = "SELECT |