-- phpMyAdmin SQL Dump -- version 2.11.9.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 19, 2009 at 11:53 AM -- Server version: 5.0.67 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `information_schema` -- -- -------------------------------------------------------- -- -- Table structure for table `CHARACTER_SETS` -- CREATE TEMPORARY TABLE `CHARACTER_SETS` ( `CHARACTER_SET_NAME` varchar(64) NOT NULL default '', `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL default '', `DESCRIPTION` varchar(60) NOT NULL default '', `MAXLEN` bigint(3) NOT NULL default '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `CHARACTER_SETS` -- INSERT INTO `CHARACTER_SETS` (`CHARACTER_SET_NAME`, `DEFAULT_COLLATE_NAME`, `DESCRIPTION`, `MAXLEN`) VALUES ('big5', 'big5_chinese_ci', 'Big5 Traditional Chinese', 2), ('dec8', 'dec8_swedish_ci', 'DEC West European', 1), ('cp850', 'cp850_general_ci', 'DOS West European', 1), ('hp8', 'hp8_english_ci', 'HP West European', 1), ('koi8r', 'koi8r_general_ci', 'KOI8-R Relcom Russian', 1), ('latin1', 'latin1_swedish_ci', 'cp1252 West European', 1), ('latin2', 'latin2_general_ci', 'ISO 8859-2 Central European', 1), ('swe7', 'swe7_swedish_ci', '7bit Swedish', 1), ('ascii', 'ascii_general_ci', 'US ASCII', 1), ('ujis', 'ujis_japanese_ci', 'EUC-JP Japanese', 3), ('sjis', 'sjis_japanese_ci', 'Shift-JIS Japanese', 2), ('hebrew', 'hebrew_general_ci', 'ISO 8859-8 Hebrew', 1), ('tis620', 'tis620_thai_ci', 'TIS620 Thai', 1), ('euckr', 'euckr_korean_ci', 'EUC-KR Korean', 2), ('koi8u', 'koi8u_general_ci', 'KOI8-U Ukrainian', 1), ('gb2312', 'gb2312_chinese_ci', 'GB2312 Simplified Chinese', 2), ('greek', 'greek_general_ci', 'ISO 8859-7 Greek', 1), ('cp1250', 'cp1250_general_ci', 'Windows Central European', 1), ('gbk', 'gbk_chinese_ci', 'GBK Simplified Chinese', 2), ('latin5', 'latin5_turkish_ci', 'ISO 8859-9 Turkish', 1), ('armscii8', 'armscii8_general_ci', 'ARMSCII-8 Armenian', 1), ('utf8', 'utf8_general_ci', 'UTF-8 Unicode', 3), ('ucs2', 'ucs2_general_ci', 'UCS-2 Unicode', 2), ('cp866', 'cp866_general_ci', 'DOS Russian', 1), ('keybcs2', 'keybcs2_general_ci', 'DOS Kamenicky Czech-Slovak', 1), ('macce', 'macce_general_ci', 'Mac Central European', 1), ('macroman', 'macroman_general_ci', 'Mac West European', 1), ('cp852', 'cp852_general_ci', 'DOS Central European', 1), ('latin7', 'latin7_general_ci', 'ISO 8859-13 Baltic', 1), ('cp1251', 'cp1251_general_ci', 'Windows Cyrillic', 1), ('cp1256', 'cp1256_general_ci', 'Windows Arabic', 1), ('cp1257', 'cp1257_general_ci', 'Windows Baltic', 1), ('binary', 'binary', 'Binary pseudo charset', 1), ('geostd8', 'geostd8_general_ci', 'GEOSTD8 Georgian', 1), ('cp932', 'cp932_japanese_ci', 'SJIS for Windows Japanese', 2), ('eucjpms', 'eucjpms_japanese_ci', 'UJIS for Windows Japanese', 3); -- -------------------------------------------------------- -- -- Table structure for table `COLLATIONS` -- CREATE TEMPORARY TABLE `COLLATIONS` ( `COLLATION_NAME` varchar(64) NOT NULL default '', `CHARACTER_SET_NAME` varchar(64) NOT NULL default '', `ID` bigint(11) NOT NULL default '0', `IS_DEFAULT` varchar(3) NOT NULL default '', `IS_COMPILED` varchar(3) NOT NULL default '', `SORTLEN` bigint(3) NOT NULL default '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `COLLATIONS` -- INSERT INTO `COLLATIONS` (`COLLATION_NAME`, `CHARACTER_SET_NAME`, `ID`, `IS_DEFAULT`, `IS_COMPILED`, `SORTLEN`) VALUES ('big5_chinese_ci', 'big5', 1, 'Yes', 'Yes', 1), ('big5_bin', 'big5', 84, '', 'Yes', 1), ('dec8_swedish_ci', 'dec8', 3, 'Yes', '', 0), ('dec8_bin', 'dec8', 69, '', '', 0), ('cp850_general_ci', 'cp850', 4, 'Yes', '', 0), ('cp850_bin', 'cp850', 80, '', '', 0), ('hp8_english_ci', 'hp8', 6, 'Yes', '', 0), ('hp8_bin', 'hp8', 72, '', '', 0), ('koi8r_general_ci', 'koi8r', 7, 'Yes', '', 0), ('koi8r_bin', 'koi8r', 74, '', '', 0), ('latin1_german1_ci', 'latin1', 5, '', 'Yes', 1), ('latin1_swedish_ci', 'latin1', 8, 'Yes', 'Yes', 1), ('latin1_danish_ci', 'latin1', 15, '', 'Yes', 1), ('latin1_german2_ci', 'latin1', 31, '', 'Yes', 2), ('latin1_bin', 'latin1', 47, '', 'Yes', 1), ('latin1_general_ci', 'latin1', 48, '', 'Yes', 1), ('latin1_general_cs', 'latin1', 49, '', 'Yes', 1), ('latin1_spanish_ci', 'latin1', 94, '', 'Yes', 1), ('latin2_czech_cs', 'latin2', 2, '', 'Yes', 4), ('latin2_general_ci', 'latin2', 9, 'Yes', 'Yes', 1), ('latin2_hungarian_ci', 'latin2', 21, '', 'Yes', 1), ('latin2_croatian_ci', 'latin2', 27, '', 'Yes', 1), ('latin2_bin', 'latin2', 77, '', 'Yes', 1), ('swe7_swedish_ci', 'swe7', 10, 'Yes', '', 0), ('swe7_bin', 'swe7', 82, '', '', 0), ('ascii_general_ci', 'ascii', 11, 'Yes', '', 0), ('ascii_bin', 'ascii', 65, '', '', 0), ('ujis_japanese_ci', 'ujis', 12, 'Yes', 'Yes', 1), ('ujis_bin', 'ujis', 91, '', 'Yes', 1), ('sjis_japanese_ci', 'sjis', 13, 'Yes', 'Yes', 1), ('sjis_bin', 'sjis', 88, '', 'Yes', 1), ('hebrew_general_ci', 'hebrew', 16, 'Yes', '', 0), ('hebrew_bin', 'hebrew', 71, '', '', 0), ('tis620_thai_ci', 'tis620', 18, 'Yes', 'Yes', 4), ('tis620_bin', 'tis620', 89, '', 'Yes', 1), ('euckr_korean_ci', 'euckr', 19, 'Yes', 'Yes', 1), ('euckr_bin', 'euckr', 85, '', 'Yes', 1), ('koi8u_general_ci', 'koi8u', 22, 'Yes', '', 0), ('koi8u_bin', 'koi8u', 75, '', '', 0), ('gb2312_chinese_ci', 'gb2312', 24, 'Yes', 'Yes', 1), ('gb2312_bin', 'gb2312', 86, '', 'Yes', 1), ('greek_general_ci', 'greek', 25, 'Yes', '', 0), ('greek_bin', 'greek', 70, '', '', 0), ('cp1250_general_ci', 'cp1250', 26, 'Yes', 'Yes', 1), ('cp1250_czech_cs', 'cp1250', 34, '', 'Yes', 2), ('cp1250_croatian_ci', 'cp1250', 44, '', 'Yes', 1), ('cp1250_bin', 'cp1250', 66, '', 'Yes', 1), ('gbk_chinese_ci', 'gbk', 28, 'Yes', 'Yes', 1), ('gbk_bin', 'gbk', 87, '', 'Yes', 1), ('latin5_turkish_ci', 'latin5', 30, 'Yes', '', 0), ('latin5_bin', 'latin5', 78, '', '', 0), ('armscii8_general_ci', 'armscii8', 32, 'Yes', '', 0), ('armscii8_bin', 'armscii8', 64, '', '', 0), ('utf8_general_ci', 'utf8', 33, 'Yes', 'Yes', 1), ('utf8_bin', 'utf8', 83, '', 'Yes', 1), ('utf8_unicode_ci', 'utf8', 192, '', 'Yes', 8), ('utf8_icelandic_ci', 'utf8', 193, '', 'Yes', 8), ('utf8_latvian_ci', 'utf8', 194, '', 'Yes', 8), ('utf8_romanian_ci', 'utf8', 195, '', 'Yes', 8), ('utf8_slovenian_ci', 'utf8', 196, '', 'Yes', 8), ('utf8_polish_ci', 'utf8', 197, '', 'Yes', 8), ('utf8_estonian_ci', 'utf8', 198, '', 'Yes', 8), ('utf8_spanish_ci', 'utf8', 199, '', 'Yes', 8), ('utf8_swedish_ci', 'utf8', 200, '', 'Yes', 8), ('utf8_turkish_ci', 'utf8', 201, '', 'Yes', 8), ('utf8_czech_ci', 'utf8', 202, '', 'Yes', 8), ('utf8_danish_ci', 'utf8', 203, '', 'Yes', 8), ('utf8_lithuanian_ci', 'utf8', 204, '', 'Yes', 8), ('utf8_slovak_ci', 'utf8', 205, '', 'Yes', 8), ('utf8_spanish2_ci', 'utf8', 206, '', 'Yes', 8), ('utf8_roman_ci', 'utf8', 207, '', 'Yes', 8), ('utf8_persian_ci', 'utf8', 208, '', 'Yes', 8), ('utf8_esperanto_ci', 'utf8', 209, '', 'Yes', 8), ('utf8_hungarian_ci', 'utf8', 210, '', 'Yes', 8), ('ucs2_general_ci', 'ucs2', 35, 'Yes', 'Yes', 1), ('ucs2_bin', 'ucs2', 90, '', 'Yes', 1), ('ucs2_unicode_ci', 'ucs2', 128, '', 'Yes', 8), ('ucs2_icelandic_ci', 'ucs2', 129, '', 'Yes', 8), ('ucs2_latvian_ci', 'ucs2', 130, '', 'Yes', 8), ('ucs2_romanian_ci', 'ucs2', 131, '', 'Yes', 8), ('ucs2_slovenian_ci', 'ucs2', 132, '', 'Yes', 8), ('ucs2_polish_ci', 'ucs2', 133, '', 'Yes', 8), ('ucs2_estonian_ci', 'ucs2', 134, '', 'Yes', 8), ('ucs2_spanish_ci', 'ucs2', 135, '', 'Yes', 8), ('ucs2_swedish_ci', 'ucs2', 136, '', 'Yes', 8), ('ucs2_turkish_ci', 'ucs2', 137, '', 'Yes', 8), ('ucs2_czech_ci', 'ucs2', 138, '', 'Yes', 8), ('ucs2_danish_ci', 'ucs2', 139, '', 'Yes', 8), ('ucs2_lithuanian_ci', 'ucs2', 140, '', 'Yes', 8), ('ucs2_slovak_ci', 'ucs2', 141, '', 'Yes', 8), ('ucs2_spanish2_ci', 'ucs2', 142, '', 'Yes', 8), ('ucs2_roman_ci', 'ucs2', 143, '', 'Yes', 8), ('ucs2_persian_ci', 'ucs2', 144, '', 'Yes', 8), ('ucs2_esperanto_ci', 'ucs2', 145, '', 'Yes', 8), ('ucs2_hungarian_ci', 'ucs2', 146, '', 'Yes', 8), ('cp866_general_ci', 'cp866', 36, 'Yes', '', 0), ('cp866_bin', 'cp866', 68, '', '', 0), ('keybcs2_general_ci', 'keybcs2', 37, 'Yes', '', 0), ('keybcs2_bin', 'keybcs2', 73, '', '', 0), ('macce_general_ci', 'macce', 38, 'Yes', '', 0), ('macce_bin', 'macce', 43, '', '', 0), ('macroman_general_ci', 'macroman', 39, 'Yes', '', 0), ('macroman_bin', 'macroman', 53, '', '', 0), ('cp852_general_ci', 'cp852', 40, 'Yes', '', 0), ('cp852_bin', 'cp852', 81, '', '', 0), ('latin7_estonian_cs', 'latin7', 20, '', '', 0), ('latin7_general_ci', 'latin7', 41, 'Yes', '', 0), ('latin7_general_cs', 'latin7', 42, '', '', 0), ('latin7_bin', 'latin7', 79, '', '', 0), ('cp1251_bulgarian_ci', 'cp1251', 14, '', '', 0), ('cp1251_ukrainian_ci', 'cp1251', 23, '', '', 0), ('cp1251_bin', 'cp1251', 50, '', '', 0), ('cp1251_general_ci', 'cp1251', 51, 'Yes', '', 0), ('cp1251_general_cs', 'cp1251', 52, '', '', 0), ('cp1256_general_ci', 'cp1256', 57, 'Yes', '', 0), ('cp1256_bin', 'cp1256', 67, '', '', 0), ('cp1257_lithuanian_ci', 'cp1257', 29, '', '', 0), ('cp1257_bin', 'cp1257', 58, '', '', 0), ('cp1257_general_ci', 'cp1257', 59, 'Yes', '', 0), ('binary', 'binary', 63, 'Yes', 'Yes', 1), ('geostd8_general_ci', 'geostd8', 92, 'Yes', '', 0), ('geostd8_bin', 'geostd8', 93, '', '', 0), ('cp932_japanese_ci', 'cp932', 95, 'Yes', 'Yes', 1), ('cp932_bin', 'cp932', 96, '', 'Yes', 1), ('eucjpms_japanese_ci', 'eucjpms', 97, 'Yes', 'Yes', 1), ('eucjpms_bin', 'eucjpms', 98, '', 'Yes', 1); -- -------------------------------------------------------- -- -- Table structure for table `COLLATION_CHARACTER_SET_APPLICABILITY` -- CREATE TEMPORARY TABLE `COLLATION_CHARACTER_SET_APPLICABILITY` ( `COLLATION_NAME` varchar(64) NOT NULL default '', `CHARACTER_SET_NAME` varchar(64) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `COLLATION_CHARACTER_SET_APPLICABILITY` -- INSERT INTO `COLLATION_CHARACTER_SET_APPLICABILITY` (`COLLATION_NAME`, `CHARACTER_SET_NAME`) VALUES ('big5_chinese_ci', 'big5'), ('big5_bin', 'big5'), ('dec8_swedish_ci', 'dec8'), ('dec8_bin', 'dec8'), ('cp850_general_ci', 'cp850'), ('cp850_bin', 'cp850'), ('hp8_english_ci', 'hp8'), ('hp8_bin', 'hp8'), ('koi8r_general_ci', 'koi8r'), ('koi8r_bin', 'koi8r'), ('latin1_german1_ci', 'latin1'), ('latin1_swedish_ci', 'latin1'), ('latin1_danish_ci', 'latin1'), ('latin1_german2_ci', 'latin1'), ('latin1_bin', 'latin1'), ('latin1_general_ci', 'latin1'), ('latin1_general_cs', 'latin1'), ('latin1_spanish_ci', 'latin1'), ('latin2_czech_cs', 'latin2'), ('latin2_general_ci', 'latin2'), ('latin2_hungarian_ci', 'latin2'), ('latin2_croatian_ci', 'latin2'), ('latin2_bin', 'latin2'), ('swe7_swedish_ci', 'swe7'), ('swe7_bin', 'swe7'), ('ascii_general_ci', 'ascii'), ('ascii_bin', 'ascii'), ('ujis_japanese_ci', 'ujis'), ('ujis_bin', 'ujis'), ('sjis_japanese_ci', 'sjis'), ('sjis_bin', 'sjis'), ('hebrew_general_ci', 'hebrew'), ('hebrew_bin', 'hebrew'), ('tis620_thai_ci', 'tis620'), ('tis620_bin', 'tis620'), ('euckr_korean_ci', 'euckr'), ('euckr_bin', 'euckr'), ('koi8u_general_ci', 'koi8u'), ('koi8u_bin', 'koi8u'), ('gb2312_chinese_ci', 'gb2312'), ('gb2312_bin', 'gb2312'), ('greek_general_ci', 'greek'), ('greek_bin', 'greek'), ('cp1250_general_ci', 'cp1250'), ('cp1250_czech_cs', 'cp1250'), ('cp1250_croatian_ci', 'cp1250'), ('cp1250_bin', 'cp1250'), ('gbk_chinese_ci', 'gbk'), ('gbk_bin', 'gbk'), ('latin5_turkish_ci', 'latin5'), ('latin5_bin', 'latin5'), ('armscii8_general_ci', 'armscii8'), ('armscii8_bin', 'armscii8'), ('utf8_general_ci', 'utf8'), ('utf8_bin', 'utf8'), ('utf8_unicode_ci', 'utf8'), ('utf8_icelandic_ci', 'utf8'), ('utf8_latvian_ci', 'utf8'), ('utf8_romanian_ci', 'utf8'), ('utf8_slovenian_ci', 'utf8'), ('utf8_polish_ci', 'utf8'), ('utf8_estonian_ci', 'utf8'), ('utf8_spanish_ci', 'utf8'), ('utf8_swedish_ci', 'utf8'), ('utf8_turkish_ci', 'utf8'), ('utf8_czech_ci', 'utf8'), ('utf8_danish_ci', 'utf8'), ('utf8_lithuanian_ci', 'utf8'), ('utf8_slovak_ci', 'utf8'), ('utf8_spanish2_ci', 'utf8'), ('utf8_roman_ci', 'utf8'), ('utf8_persian_ci', 'utf8'), ('utf8_esperanto_ci', 'utf8'), ('utf8_hungarian_ci', 'utf8'), ('ucs2_general_ci', 'ucs2'), ('ucs2_bin', 'ucs2'), ('ucs2_unicode_ci', 'ucs2'), ('ucs2_icelandic_ci', 'ucs2'), ('ucs2_latvian_ci', 'ucs2'), ('ucs2_romanian_ci', 'ucs2'), ('ucs2_slovenian_ci', 'ucs2'), ('ucs2_polish_ci', 'ucs2'), ('ucs2_estonian_ci', 'ucs2'), ('ucs2_spanish_ci', 'ucs2'), ('ucs2_swedish_ci', 'ucs2'), ('ucs2_turkish_ci', 'ucs2'), ('ucs2_czech_ci', 'ucs2'), ('ucs2_danish_ci', 'ucs2'), ('ucs2_lithuanian_ci', 'ucs2'), ('ucs2_slovak_ci', 'ucs2'), ('ucs2_spanish2_ci', 'ucs2'), ('ucs2_roman_ci', 'ucs2'), ('ucs2_persian_ci', 'ucs2'), ('ucs2_esperanto_ci', 'ucs2'), ('ucs2_hungarian_ci', 'ucs2'), ('cp866_general_ci', 'cp866'), ('cp866_bin', 'cp866'), ('keybcs2_general_ci', 'keybcs2'), ('keybcs2_bin', 'keybcs2'), ('macce_general_ci', 'macce'), ('macce_bin', 'macce'), ('macroman_general_ci', 'macroman'), ('macroman_bin', 'macroman'), ('cp852_general_ci', 'cp852'), ('cp852_bin', 'cp852'), ('latin7_estonian_cs', 'latin7'), ('latin7_general_ci', 'latin7'), ('latin7_general_cs', 'latin7'), ('latin7_bin', 'latin7'), ('cp1251_bulgarian_ci', 'cp1251'), ('cp1251_ukrainian_ci', 'cp1251'), ('cp1251_bin', 'cp1251'), ('cp1251_general_ci', 'cp1251'), ('cp1251_general_cs', 'cp1251'), ('cp1256_general_ci', 'cp1256'), ('cp1256_bin', 'cp1256'), ('cp1257_lithuanian_ci', 'cp1257'), ('cp1257_bin', 'cp1257'), ('cp1257_general_ci', 'cp1257'), ('binary', 'binary'), ('geostd8_general_ci', 'geostd8'), ('geostd8_bin', 'geostd8'), ('cp932_japanese_ci', 'cp932'), ('cp932_bin', 'cp932'), ('eucjpms_japanese_ci', 'eucjpms'), ('eucjpms_bin', 'eucjpms'); -- -------------------------------------------------------- -- -- Table structure for table `COLUMNS` -- CREATE TEMPORARY TABLE `COLUMNS` ( `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `COLUMN_NAME` varchar(64) NOT NULL default '', `ORDINAL_POSITION` bigint(21) NOT NULL default '0', `COLUMN_DEFAULT` longtext, `IS_NULLABLE` varchar(3) NOT NULL default '', `DATA_TYPE` varchar(64) NOT NULL default '', `CHARACTER_MAXIMUM_LENGTH` bigint(21) default NULL, `CHARACTER_OCTET_LENGTH` bigint(21) default NULL, `NUMERIC_PRECISION` bigint(21) default NULL, `NUMERIC_SCALE` bigint(21) default NULL, `CHARACTER_SET_NAME` varchar(64) default NULL, `COLLATION_NAME` varchar(64) default NULL, `COLUMN_TYPE` longtext NOT NULL, `COLUMN_KEY` varchar(3) NOT NULL default '', `EXTRA` varchar(20) NOT NULL default '', `PRIVILEGES` varchar(80) NOT NULL default '', `COLUMN_COMMENT` varchar(255) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `COLUMNS` -- INSERT INTO `COLUMNS` (`TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `COLUMN_NAME`, `ORDINAL_POSITION`, `COLUMN_DEFAULT`, `IS_NULLABLE`, `DATA_TYPE`, `CHARACTER_MAXIMUM_LENGTH`, `CHARACTER_OCTET_LENGTH`, `NUMERIC_PRECISION`, `NUMERIC_SCALE`, `CHARACTER_SET_NAME`, `COLLATION_NAME`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `PRIVILEGES`, `COLUMN_COMMENT`) VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'CHARACTER_SET_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'CHARACTER_SETS', 'DEFAULT_COLLATE_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'CHARACTER_SETS', 'DESCRIPTION', 3, '', 'NO', 'varchar', 60, 180, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(60)', '', '', 'select', ''), (NULL, 'information_schema', 'CHARACTER_SETS', 'MAXLEN', 4, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'COLLATION_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'CHARACTER_SET_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'ID', 3, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(11)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'IS_DEFAULT', 4, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'IS_COMPILED', 5, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATIONS', 'SORTLEN', 6, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATION_CHARACTER_SET_APPLICABILITY', 'COLLATION_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLLATION_CHARACTER_SET_APPLICABILITY', 'CHARACTER_SET_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'TABLE_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'TABLE_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'TABLE_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLUMN_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'ORDINAL_POSITION', 5, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLUMN_DEFAULT', 6, NULL, 'YES', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'IS_NULLABLE', 7, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'DATA_TYPE', 8, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_MAXIMUM_LENGTH', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_OCTET_LENGTH', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'NUMERIC_PRECISION', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'NUMERIC_SCALE', 12, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_SET_NAME', 13, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLLATION_NAME', 14, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLUMN_TYPE', 15, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLUMN_KEY', 16, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'EXTRA', 17, '', 'NO', 'varchar', 20, 60, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(20)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'PRIVILEGES', 18, '', 'NO', 'varchar', 80, 240, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(80)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMNS', 'COLUMN_COMMENT', 19, '', 'NO', 'varchar', 255, 765, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(255)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'GRANTEE', 1, '', 'NO', 'varchar', 81, 243, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(81)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_SCHEMA', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'COLUMN_NAME', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'PRIVILEGE_TYPE', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'IS_GRANTABLE', 7, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_CATALOG', 4, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_SCHEMA', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_NAME', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'COLUMN_NAME', 7, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'ORDINAL_POSITION', 8, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(10)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'POSITION_IN_UNIQUE_CONSTRAINT', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(10)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_TABLE_SCHEMA', 10, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_TABLE_NAME', 11, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_COLUMN_NAME', 12, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'QUERY_ID', 1, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'SEQ', 2, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'STATE', 3, '', 'NO', 'varchar', 30, 90, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(30)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'DURATION', 4, '0.000000', 'NO', 'decimal', NULL, NULL, 9, 6, NULL, NULL, 'decimal(9,6)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'CPU_USER', 5, NULL, 'YES', 'decimal', NULL, NULL, 9, 6, NULL, NULL, 'decimal(9,6)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'CPU_SYSTEM', 6, NULL, 'YES', 'decimal', NULL, NULL, 9, 6, NULL, NULL, 'decimal(9,6)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'CONTEXT_VOLUNTARY', 7, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'CONTEXT_INVOLUNTARY', 8, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'BLOCK_OPS_IN', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'BLOCK_OPS_OUT', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'MESSAGES_SENT', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'MESSAGES_RECEIVED', 12, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'PAGE_FAULTS_MAJOR', 13, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'PAGE_FAULTS_MINOR', 14, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'SWAPS', 15, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'SOURCE_FUNCTION', 16, NULL, 'YES', 'varchar', 30, 90, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(30)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'SOURCE_FILE', 17, NULL, 'YES', 'varchar', 20, 60, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(20)', '', '', 'select', ''), (NULL, 'information_schema', 'PROFILING', 'SOURCE_LINE', 18, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'SPECIFIC_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_SCHEMA', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_TYPE', 5, '', 'NO', 'varchar', 9, 27, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(9)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'DTD_IDENTIFIER', 6, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_BODY', 7, '', 'NO', 'varchar', 8, 24, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(8)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_DEFINITION', 8, NULL, 'YES', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'EXTERNAL_NAME', 9, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'EXTERNAL_LANGUAGE', 10, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'PARAMETER_STYLE', 11, '', 'NO', 'varchar', 8, 24, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(8)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'IS_DETERMINISTIC', 12, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'SQL_DATA_ACCESS', 13, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'SQL_PATH', 14, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'SECURITY_TYPE', 15, '', 'NO', 'varchar', 7, 21, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(7)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'CREATED', 16, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'LAST_ALTERED', 17, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'SQL_MODE', 18, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'ROUTINE_COMMENT', 19, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'ROUTINES', 'DEFINER', 20, '', 'NO', 'varchar', 77, 231, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(77)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMATA', 'CATALOG_NAME', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMATA', 'SCHEMA_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMATA', 'DEFAULT_CHARACTER_SET_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMATA', 'DEFAULT_COLLATION_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMATA', 'SQL_PATH', 5, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'GRANTEE', 1, '', 'NO', 'varchar', 81, 243, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(81)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'TABLE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'TABLE_SCHEMA', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'PRIVILEGE_TYPE', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'IS_GRANTABLE', 5, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'TABLE_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'TABLE_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'TABLE_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'NON_UNIQUE', 4, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(1)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'INDEX_SCHEMA', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'INDEX_NAME', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'SEQ_IN_INDEX', 7, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(2)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'COLUMN_NAME', 8, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'COLLATION', 9, NULL, 'YES', 'varchar', 1, 3, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(1)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'CARDINALITY', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'SUB_PART', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(3)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'PACKED', 12, NULL, 'YES', 'varchar', 10, 30, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(10)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'NULLABLE', 13, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'INDEX_TYPE', 14, '', 'NO', 'varchar', 16, 48, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(16)', '', '', 'select', ''), (NULL, 'information_schema', 'STATISTICS', 'COMMENT', 15, NULL, 'YES', 'varchar', 16, 48, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(16)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_TYPE', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'ENGINE', 5, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'VERSION', 6, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'ROW_FORMAT', 7, NULL, 'YES', 'varchar', 10, 30, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(10)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_ROWS', 8, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'AVG_ROW_LENGTH', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'DATA_LENGTH', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'MAX_DATA_LENGTH', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'INDEX_LENGTH', 12, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'DATA_FREE', 13, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'AUTO_INCREMENT', 14, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'CREATE_TIME', 15, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'UPDATE_TIME', 16, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'CHECK_TIME', 17, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_COLLATION', 18, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'CHECKSUM', 19, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'CREATE_OPTIONS', 20, NULL, 'YES', 'varchar', 255, 765, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(255)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLES', 'TABLE_COMMENT', 21, '', 'NO', 'varchar', 80, 240, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(80)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'CONSTRAINT_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'CONSTRAINT_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'CONSTRAINT_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'TABLE_SCHEMA', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'TABLE_NAME', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'CONSTRAINT_TYPE', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'GRANTEE', 1, '', 'NO', 'varchar', 81, 243, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(81)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'TABLE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'TABLE_SCHEMA', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'TABLE_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'PRIVILEGE_TYPE', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'IS_GRANTABLE', 6, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'TRIGGER_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'TRIGGER_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'TRIGGER_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'EVENT_MANIPULATION', 4, '', 'NO', 'varchar', 6, 18, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(6)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'EVENT_OBJECT_CATALOG', 5, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'EVENT_OBJECT_SCHEMA', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'EVENT_OBJECT_TABLE', 7, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_ORDER', 8, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(4)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_CONDITION', 9, NULL, 'YES', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_STATEMENT', 10, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_ORIENTATION', 11, '', 'NO', 'varchar', 9, 27, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(9)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_TIMING', 12, '', 'NO', 'varchar', 6, 18, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(6)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_REFERENCE_OLD_TABLE', 13, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_REFERENCE_NEW_TABLE', 14, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_REFERENCE_OLD_ROW', 15, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'ACTION_REFERENCE_NEW_ROW', 16, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'CREATED', 17, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'SQL_MODE', 18, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'TRIGGERS', 'DEFINER', 19, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'USER_PRIVILEGES', 'GRANTEE', 1, '', 'NO', 'varchar', 81, 243, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(81)', '', '', 'select', ''), (NULL, 'information_schema', 'USER_PRIVILEGES', 'TABLE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'USER_PRIVILEGES', 'PRIVILEGE_TYPE', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'USER_PRIVILEGES', 'IS_GRANTABLE', 4, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'TABLE_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'TABLE_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'TABLE_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'VIEW_DEFINITION', 4, NULL, 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'CHECK_OPTION', 5, '', 'NO', 'varchar', 8, 24, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(8)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'IS_UPDATABLE', 6, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'DEFINER', 7, '', 'NO', 'varchar', 77, 231, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(77)', '', '', 'select', ''), (NULL, 'information_schema', 'VIEWS', 'SECURITY_TYPE', 8, '', 'NO', 'varchar', 7, 21, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(7)', '', '', 'select', ''), (NULL, 'submissi_osc1', 'address_book', 'address_book_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_gender', 3, '', 'NO', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_company', 4, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_firstname', 5, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_lastname', 6, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_street_address', 7, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_suburb', 8, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_postcode', 9, '', 'NO', 'varchar', 10, 10, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(10)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_city', 10, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_state', 11, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_country_id', 12, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_book', 'entry_zone_id', 13, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_format', 'address_format_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_format', 'address_format', 2, '', 'NO', 'varchar', 128, 128, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(128)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'address_format', 'address_summary', 3, '', 'NO', 'varchar', 48, 48, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(48)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_title', 2, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_url', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_image', 4, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_group', 5, '', 'NO', 'varchar', 10, 10, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(10)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'banners_html_text', 6, NULL, 'YES', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'expires_impressions', 7, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(7)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'expires_date', 8, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'date_scheduled', 9, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'date_added', 10, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'date_status_change', 11, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners', 'status', 12, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners_history', 'banners_history_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners_history', 'banners_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners_history', 'banners_shown', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners_history', 'banners_clicked', 4, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'banners_history', 'banners_history_date', 5, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'categories_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'categories_image', 2, NULL, 'YES', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'parent_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'sort_order', 4, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(3)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'date_added', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories', 'last_modified', 6, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories_description', 'categories_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories_description', 'language_id', 2, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'categories_description', 'categories_name', 3, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_title', 2, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_key', 3, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_value', 4, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_description', 5, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'configuration_group_id', 6, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'sort_order', 7, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'last_modified', 8, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'date_added', 9, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'use_function', 10, NULL, 'YES', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration', 'set_function', 11, NULL, 'YES', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration_group', 'configuration_group_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration_group', 'configuration_group_title', 2, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration_group', 'configuration_group_description', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration_group', 'sort_order', 4, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'configuration_group', 'visible', 5, '1', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'counter', 'startdate', 1, NULL, 'YES', 'char', 8, 8, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(8)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'counter', 'counter', 2, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'counter_history', 'month', 1, NULL, 'YES', 'char', 8, 8, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(8)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'counter_history', 'counter', 2, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'countries', 'countries_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'countries', 'countries_name', 2, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'countries', 'countries_iso_code_2', 3, '', 'NO', 'char', 2, 2, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'countries', 'countries_iso_code_3', 4, '', 'NO', 'char', 3, 3, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(3)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'countries', 'address_format_id', 5, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'currencies_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'title', 2, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'code', 3, '', 'NO', 'char', 3, 3, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(3)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'symbol_left', 4, NULL, 'YES', 'varchar', 12, 12, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'symbol_right', 5, NULL, 'YES', 'varchar', 12, 12, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'decimal_point', 6, NULL, 'YES', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'thousands_point', 7, NULL, 'YES', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'decimal_places', 8, NULL, 'YES', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'value', 9, NULL, 'YES', 'float', NULL, NULL, 13, 8, NULL, NULL, 'float(13,8)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'currencies', 'last_updated', 10, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_gender', 2, '', 'NO', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_firstname', 3, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_lastname', 4, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_dob', 5, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_email_address', 6, '', 'NO', 'varchar', 96, 96, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(96)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_default_address_id', 7, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_telephone', 8, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_fax', 9, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_password', 10, '', 'NO', 'varchar', 40, 40, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(40)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers', 'customers_newsletter', 11, NULL, 'YES', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'customers_basket_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'products_id', 3, NULL, 'NO', 'tinytext', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'tinytext', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'customers_basket_quantity', 4, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'final_price', 5, NULL, 'YES', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket', 'customers_basket_date_added', 6, NULL, 'YES', 'varchar', 8, 8, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(8)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'customers_basket_attributes_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'products_id', 3, NULL, 'NO', 'tinytext', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'tinytext', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'products_options_id', 4, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'products_options_value_id', 5, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'customers_info_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'customers_info_date_of_last_logon', 2, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'customers_info_number_of_logons', 3, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'customers_info_date_account_created', 4, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'customers_info_date_account_last_modified', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'customers_info', 'global_product_notifications', 6, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'geo_zones', 'geo_zone_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'geo_zones', 'geo_zone_name', 2, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'geo_zones', 'geo_zone_description', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''); INSERT INTO `COLUMNS` (`TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `COLUMN_NAME`, `ORDINAL_POSITION`, `COLUMN_DEFAULT`, `IS_NULLABLE`, `DATA_TYPE`, `CHARACTER_MAXIMUM_LENGTH`, `CHARACTER_OCTET_LENGTH`, `NUMERIC_PRECISION`, `NUMERIC_SCALE`, `CHARACTER_SET_NAME`, `COLLATION_NAME`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `PRIVILEGES`, `COLUMN_COMMENT`) VALUES (NULL, 'submissi_osc1', 'geo_zones', 'last_modified', 4, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'geo_zones', 'date_added', 5, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'languages_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'name', 2, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'code', 3, '', 'NO', 'char', 2, 2, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'image', 4, NULL, 'YES', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'directory', 5, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'languages', 'sort_order', 6, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(3)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers', 'manufacturers_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers', 'manufacturers_name', 2, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers', 'manufacturers_image', 3, NULL, 'YES', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers', 'date_added', 4, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers', 'last_modified', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'manufacturers_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'languages_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'manufacturers_url', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'url_clicked', 4, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'date_last_click', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'newsletters_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'title', 2, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'content', 3, NULL, 'NO', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'module', 4, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'date_added', 5, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'date_sent', 6, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'status', 7, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'newsletters', 'locked', 8, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'orders_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_name', 3, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_company', 4, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_street_address', 5, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_suburb', 6, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_city', 7, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_postcode', 8, '', 'NO', 'varchar', 10, 10, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(10)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_state', 9, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_country', 10, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_telephone', 11, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_email_address', 12, '', 'NO', 'varchar', 96, 96, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(96)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'customers_address_format_id', 13, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_name', 14, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_company', 15, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_street_address', 16, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_suburb', 17, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_city', 18, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_postcode', 19, '', 'NO', 'varchar', 10, 10, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(10)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_state', 20, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_country', 21, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'delivery_address_format_id', 22, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_name', 23, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_company', 24, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_street_address', 25, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_suburb', 26, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_city', 27, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_postcode', 28, '', 'NO', 'varchar', 10, 10, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(10)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_state', 29, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_country', 30, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'billing_address_format_id', 31, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'payment_method', 32, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'cc_type', 33, NULL, 'YES', 'varchar', 20, 20, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(20)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'cc_owner', 34, NULL, 'YES', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'cc_number', 35, NULL, 'YES', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'cc_expires', 36, NULL, 'YES', 'varchar', 4, 4, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'last_modified', 37, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'date_purchased', 38, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'orders_status', 39, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'orders_date_finished', 40, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'currency', 41, NULL, 'YES', 'char', 3, 3, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(3)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'currency_value', 42, NULL, 'YES', 'decimal', NULL, NULL, 14, 6, NULL, NULL, 'decimal(14,6)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'buysafe_cart_id', 43, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'buysafe_client_ip', 44, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders', 'buysafe_session_id', 45, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'orders_products_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'orders_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_model', 4, NULL, 'YES', 'varchar', 12, 12, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_name', 5, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_price', 6, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'final_price', 7, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_tax', 8, '0.0000', 'NO', 'decimal', NULL, NULL, 7, 4, NULL, NULL, 'decimal(7,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products', 'products_quantity', 9, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'orders_products_attributes_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'orders_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'orders_products_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'products_options', 4, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'products_options_values', 5, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'options_values_price', 6, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'price_prefix', 7, '', 'NO', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'orders_products_download_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'orders_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'orders_products_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'orders_products_filename', 4, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'download_maxdays', 5, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'download_count', 6, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status', 'orders_status_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status', 'language_id', 2, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status', 'orders_status_name', 3, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'orders_status_history_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'orders_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'orders_status_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'date_added', 4, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'customer_notified', 5, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'comments', 6, NULL, 'YES', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'orders_total_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(10) unsigned', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'orders_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'title', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'text', 4, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'value', 5, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'class', 6, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'orders_total', 'sort_order', 7, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_quantity', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_model', 3, NULL, 'YES', 'varchar', 12, 12, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(12)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_image', 4, NULL, 'YES', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_price', 5, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_date_added', 6, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_last_modified', 7, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_date_available', 8, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_weight', 9, '0.00', 'NO', 'decimal', NULL, NULL, 5, 2, NULL, NULL, 'decimal(5,2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_status', 10, '0', 'NO', 'tinyint', NULL, NULL, 3, 0, NULL, NULL, 'tinyint(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_tax_class_id', 11, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'manufacturers_id', 12, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products', 'products_ordered', 13, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'products_attributes_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'products_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'options_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'options_values_id', 4, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'options_values_price', 5, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes', 'price_prefix', 6, '', 'NO', 'char', 1, 1, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'char(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 'products_attributes_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 'products_attributes_filename', 2, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 'products_attributes_maxdays', 3, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 'products_attributes_maxcount', 4, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(2)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'products_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'language_id', 2, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'products_name', 3, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', 'MUL', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'products_description', 4, NULL, 'YES', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'products_url', 5, NULL, 'YES', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_description', 'products_viewed', 6, '0', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_notifications', 'products_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_notifications', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_notifications', 'date_added', 3, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options', 'products_options_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options', 'language_id', 2, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options', 'products_options_name', 3, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values', 'products_options_values_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values', 'language_id', 2, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values', 'products_options_values_name', 3, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values_to_products_options', 'products_options_values_to_products_options_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values_to_products_options', 'products_options_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_options_values_to_products_options', 'products_options_values_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_to_categories', 'products_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'products_to_categories', 'categories_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'reviews_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'products_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'customers_id', 3, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'customers_name', 4, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'reviews_rating', 5, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'date_added', 6, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'last_modified', 7, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews', 'reviews_read', 8, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews_description', 'reviews_id', 1, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews_description', 'languages_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'reviews_description', 'reviews_text', 3, NULL, 'NO', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'sessions', 'sesskey', 1, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', 'PRI', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'sessions', 'expiry', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11) unsigned', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'sessions', 'value', 3, NULL, 'NO', 'text', 65535, 65535, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'text', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'specials_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'products_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'specials_new_products_price', 3, '0.0000', 'NO', 'decimal', NULL, NULL, 15, 4, NULL, NULL, 'decimal(15,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'specials_date_added', 4, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'specials_last_modified', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'expires_date', 6, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'date_status_change', 7, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'specials', 'status', 8, '1', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(1)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_class', 'tax_class_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_class', 'tax_class_title', 2, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_class', 'tax_class_description', 3, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_class', 'last_modified', 4, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_class', 'date_added', 5, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_rates_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_zone_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_class_id', 3, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_priority', 4, '1', 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(5)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_rate', 5, '0.0000', 'NO', 'decimal', NULL, NULL, 7, 4, NULL, NULL, 'decimal(7,4)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'tax_description', 6, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'last_modified', 7, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'tax_rates', 'date_added', 8, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'customer_id', 1, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'full_name', 2, '', 'NO', 'varchar', 64, 64, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(64)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'session_id', 3, '', 'NO', 'varchar', 128, 128, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(128)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'ip_address', 4, '', 'NO', 'varchar', 15, 15, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(15)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'time_entry', 5, '', 'NO', 'varchar', 14, 14, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(14)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'time_last_click', 6, '', 'NO', 'varchar', 14, 14, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(14)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'whos_online', 'last_page_url', 7, '', 'NO', 'varchar', 255, 255, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(255)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones', 'zone_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones', 'zone_country_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones', 'zone_code', 3, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones', 'zone_name', 4, '', 'NO', 'varchar', 32, 32, NULL, NULL, 'latin1', 'latin1_swedish_ci', 'varchar(32)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'association_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'zone_country_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'zone_id', 3, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'geo_zone_id', 4, NULL, 'YES', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'last_modified', 5, NULL, 'YES', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'date_added', 6, '0000-00-00 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update,references', ''); -- -------------------------------------------------------- -- -- Table structure for table `COLUMN_PRIVILEGES` -- CREATE TEMPORARY TABLE `COLUMN_PRIVILEGES` ( `GRANTEE` varchar(81) NOT NULL default '', `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `COLUMN_NAME` varchar(64) NOT NULL default '', `PRIVILEGE_TYPE` varchar(64) NOT NULL default '', `IS_GRANTABLE` varchar(3) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `COLUMN_PRIVILEGES` -- -- -------------------------------------------------------- -- -- Table structure for table `KEY_COLUMN_USAGE` -- CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( `CONSTRAINT_CATALOG` varchar(512) default NULL, `CONSTRAINT_SCHEMA` varchar(64) NOT NULL default '', `CONSTRAINT_NAME` varchar(64) NOT NULL default '', `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `COLUMN_NAME` varchar(64) NOT NULL default '', `ORDINAL_POSITION` bigint(10) NOT NULL default '0', `POSITION_IN_UNIQUE_CONSTRAINT` bigint(10) default NULL, `REFERENCED_TABLE_SCHEMA` varchar(64) default NULL, `REFERENCED_TABLE_NAME` varchar(64) default NULL, `REFERENCED_COLUMN_NAME` varchar(64) default NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `KEY_COLUMN_USAGE` -- INSERT INTO `KEY_COLUMN_USAGE` (`CONSTRAINT_CATALOG`, `CONSTRAINT_SCHEMA`, `CONSTRAINT_NAME`, `TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `COLUMN_NAME`, `ORDINAL_POSITION`, `POSITION_IN_UNIQUE_CONSTRAINT`, `REFERENCED_TABLE_SCHEMA`, `REFERENCED_TABLE_NAME`, `REFERENCED_COLUMN_NAME`) VALUES (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'address_book', 'address_book_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'address_format', 'address_format_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'banners', 'banners_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'banners_history', 'banners_history_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'categories', 'categories_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'categories_description', 'categories_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'categories_description', 'language_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'configuration', 'configuration_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'configuration_group', 'configuration_group_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'countries', 'countries_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'currencies', 'currencies_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'customers', 'customers_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'customers_basket', 'customers_basket_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'customers_basket_attributes', 'customers_basket_attributes_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'customers_info', 'customers_info_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'geo_zones', 'geo_zone_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'languages', 'languages_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'manufacturers', 'manufacturers_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'manufacturers_info', 'manufacturers_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'manufacturers_info', 'languages_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'newsletters', 'newsletters_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders', 'orders_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_products', 'orders_products_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_products_attributes', 'orders_products_attributes_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_products_download', 'orders_products_download_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_status', 'orders_status_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_status', 'language_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_status_history', 'orders_status_history_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'orders_total', 'orders_total_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products', 'products_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_attributes', 'products_attributes_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_attributes_download', 'products_attributes_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_description', 'products_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_description', 'language_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_notifications', 'products_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_notifications', 'customers_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_options', 'products_options_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_options', 'language_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_options_values', 'products_options_values_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_options_values', 'language_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_options_values_to_products_options', 'products_options_values_to_products_options_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_to_categories', 'products_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'products_to_categories', 'categories_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'reviews', 'reviews_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'reviews_description', 'reviews_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'reviews_description', 'languages_id', 2, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'sessions', 'sesskey', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'specials', 'specials_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'tax_class', 'tax_class_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'tax_rates', 'tax_rates_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'zones', 'zone_id', 1, NULL, NULL, NULL, NULL), (NULL, 'submissi_osc1', 'PRIMARY', NULL, 'submissi_osc1', 'zones_to_geo_zones', 'association_id', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `PROFILING` -- CREATE TEMPORARY TABLE `PROFILING` ( `QUERY_ID` bigint(20) NOT NULL default '0', `SEQ` bigint(20) NOT NULL default '0', `STATE` varchar(30) NOT NULL default '', `DURATION` decimal(9,6) NOT NULL default '0.000000', `CPU_USER` decimal(9,6) default NULL, `CPU_SYSTEM` decimal(9,6) default NULL, `CONTEXT_VOLUNTARY` bigint(20) default NULL, `CONTEXT_INVOLUNTARY` bigint(20) default NULL, `BLOCK_OPS_IN` bigint(20) default NULL, `BLOCK_OPS_OUT` bigint(20) default NULL, `MESSAGES_SENT` bigint(20) default NULL, `MESSAGES_RECEIVED` bigint(20) default NULL, `PAGE_FAULTS_MAJOR` bigint(20) default NULL, `PAGE_FAULTS_MINOR` bigint(20) default NULL, `SWAPS` bigint(20) default NULL, `SOURCE_FUNCTION` varchar(30) default NULL, `SOURCE_FILE` varchar(20) default NULL, `SOURCE_LINE` bigint(20) default NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `PROFILING` -- -- -------------------------------------------------------- -- -- Table structure for table `ROUTINES` -- CREATE TEMPORARY TABLE `ROUTINES` ( `SPECIFIC_NAME` varchar(64) NOT NULL default '', `ROUTINE_CATALOG` varchar(512) default NULL, `ROUTINE_SCHEMA` varchar(64) NOT NULL default '', `ROUTINE_NAME` varchar(64) NOT NULL default '', `ROUTINE_TYPE` varchar(9) NOT NULL default '', `DTD_IDENTIFIER` varchar(64) default NULL, `ROUTINE_BODY` varchar(8) NOT NULL default '', `ROUTINE_DEFINITION` longtext, `EXTERNAL_NAME` varchar(64) default NULL, `EXTERNAL_LANGUAGE` varchar(64) default NULL, `PARAMETER_STYLE` varchar(8) NOT NULL default '', `IS_DETERMINISTIC` varchar(3) NOT NULL default '', `SQL_DATA_ACCESS` varchar(64) NOT NULL default '', `SQL_PATH` varchar(64) default NULL, `SECURITY_TYPE` varchar(7) NOT NULL default '', `CREATED` datetime NOT NULL default '0000-00-00 00:00:00', `LAST_ALTERED` datetime NOT NULL default '0000-00-00 00:00:00', `SQL_MODE` longtext NOT NULL, `ROUTINE_COMMENT` varchar(64) NOT NULL default '', `DEFINER` varchar(77) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ROUTINES` -- -- -------------------------------------------------------- -- -- Table structure for table `SCHEMATA` -- CREATE TEMPORARY TABLE `SCHEMATA` ( `CATALOG_NAME` varchar(512) default NULL, `SCHEMA_NAME` varchar(64) NOT NULL default '', `DEFAULT_CHARACTER_SET_NAME` varchar(64) NOT NULL default '', `DEFAULT_COLLATION_NAME` varchar(64) NOT NULL default '', `SQL_PATH` varchar(512) default NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `SCHEMATA` -- INSERT INTO `SCHEMATA` (`CATALOG_NAME`, `SCHEMA_NAME`, `DEFAULT_CHARACTER_SET_NAME`, `DEFAULT_COLLATION_NAME`, `SQL_PATH`) VALUES (NULL, 'information_schema', 'utf8', 'utf8_general_ci', NULL), (NULL, 'submissi_osc1', 'latin1', 'latin1_swedish_ci', NULL); -- -------------------------------------------------------- -- -- Table structure for table `SCHEMA_PRIVILEGES` -- CREATE TEMPORARY TABLE `SCHEMA_PRIVILEGES` ( `GRANTEE` varchar(81) NOT NULL default '', `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `PRIVILEGE_TYPE` varchar(64) NOT NULL default '', `IS_GRANTABLE` varchar(3) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `SCHEMA_PRIVILEGES` -- INSERT INTO `SCHEMA_PRIVILEGES` (`GRANTEE`, `TABLE_CATALOG`, `TABLE_SCHEMA`, `PRIVILEGE_TYPE`, `IS_GRANTABLE`) VALUES ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'SELECT', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'INSERT', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'UPDATE', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'DELETE', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'CREATE', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'DROP', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'REFERENCES', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'INDEX', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'ALTER', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'CREATE TEMPORARY TABLES', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'LOCK TABLES', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'EXECUTE', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'CREATE VIEW', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'SHOW VIEW', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'CREATE ROUTINE', 'NO'), ('''submissi''@''localhost''', NULL, 'submissi\\_osc1', 'ALTER ROUTINE', 'NO'); -- -------------------------------------------------------- -- -- Table structure for table `STATISTICS` -- CREATE TEMPORARY TABLE `STATISTICS` ( `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `NON_UNIQUE` bigint(1) NOT NULL default '0', `INDEX_SCHEMA` varchar(64) NOT NULL default '', `INDEX_NAME` varchar(64) NOT NULL default '', `SEQ_IN_INDEX` bigint(2) NOT NULL default '0', `COLUMN_NAME` varchar(64) NOT NULL default '', `COLLATION` varchar(1) default NULL, `CARDINALITY` bigint(21) default NULL, `SUB_PART` bigint(3) default NULL, `PACKED` varchar(10) default NULL, `NULLABLE` varchar(3) NOT NULL default '', `INDEX_TYPE` varchar(16) NOT NULL default '', `COMMENT` varchar(16) default NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `STATISTICS` -- INSERT INTO `STATISTICS` (`TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `NON_UNIQUE`, `INDEX_SCHEMA`, `INDEX_NAME`, `SEQ_IN_INDEX`, `COLUMN_NAME`, `COLLATION`, `CARDINALITY`, `SUB_PART`, `PACKED`, `NULLABLE`, `INDEX_TYPE`, `COMMENT`) VALUES (NULL, 'submissi_osc1', 'address_book', 0, 'submissi_osc1', 'PRIMARY', 1, 'address_book_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'address_book', 1, 'submissi_osc1', 'idx_address_book_customers_id', 1, 'customers_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'address_format', 0, 'submissi_osc1', 'PRIMARY', 1, 'address_format_id', 'A', 5, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'banners', 0, 'submissi_osc1', 'PRIMARY', 1, 'banners_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'banners_history', 0, 'submissi_osc1', 'PRIMARY', 1, 'banners_history_id', 'A', 4, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'categories', 0, 'submissi_osc1', 'PRIMARY', 1, 'categories_id', 'A', 5, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'categories', 1, 'submissi_osc1', 'idx_categories_parent_id', 1, 'parent_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'categories_description', 0, 'submissi_osc1', 'PRIMARY', 1, 'categories_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'categories_description', 0, 'submissi_osc1', 'PRIMARY', 2, 'language_id', 'A', 5, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'categories_description', 1, 'submissi_osc1', 'idx_categories_name', 1, 'categories_name', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'configuration', 0, 'submissi_osc1', 'PRIMARY', 1, 'configuration_id', 'A', 143, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'configuration_group', 0, 'submissi_osc1', 'PRIMARY', 1, 'configuration_group_id', 'A', 15, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'countries', 0, 'submissi_osc1', 'PRIMARY', 1, 'countries_id', 'A', 239, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'countries', 1, 'submissi_osc1', 'IDX_COUNTRIES_NAME', 1, 'countries_name', 'A', 239, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'currencies', 0, 'submissi_osc1', 'PRIMARY', 1, 'currencies_id', 'A', 2, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'customers', 0, 'submissi_osc1', 'PRIMARY', 1, 'customers_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'customers_basket', 0, 'submissi_osc1', 'PRIMARY', 1, 'customers_basket_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 0, 'submissi_osc1', 'PRIMARY', 1, 'customers_basket_attributes_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'customers_info', 0, 'submissi_osc1', 'PRIMARY', 1, 'customers_info_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'geo_zones', 0, 'submissi_osc1', 'PRIMARY', 1, 'geo_zone_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'languages', 0, 'submissi_osc1', 'PRIMARY', 1, 'languages_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'languages', 1, 'submissi_osc1', 'IDX_LANGUAGES_NAME', 1, 'name', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'manufacturers', 0, 'submissi_osc1', 'PRIMARY', 1, 'manufacturers_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'manufacturers', 1, 'submissi_osc1', 'IDX_MANUFACTURERS_NAME', 1, 'manufacturers_name', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 0, 'submissi_osc1', 'PRIMARY', 1, 'manufacturers_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 0, 'submissi_osc1', 'PRIMARY', 2, 'languages_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'newsletters', 0, 'submissi_osc1', 'PRIMARY', 1, 'newsletters_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_products', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_products_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_products_attributes_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_products_download', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_products_download_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_status', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_status_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_status', 0, 'submissi_osc1', 'PRIMARY', 2, 'language_id', 'A', 4, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_status', 1, 'submissi_osc1', 'idx_orders_status_name', 1, 'orders_status_name', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_status_history', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_status_history_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_total', 0, 'submissi_osc1', 'PRIMARY', 1, 'orders_total_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'orders_total', 1, 'submissi_osc1', 'idx_orders_total_orders_id', 1, 'orders_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_id', 'A', 2, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products', 1, 'submissi_osc1', 'idx_products_date_added', 1, 'products_date_added', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_attributes', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_attributes_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_attributes_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_description', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_description', 0, 'submissi_osc1', 'PRIMARY', 2, 'language_id', 'A', 2, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_description', 1, 'submissi_osc1', 'products_name', 1, 'products_name', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_notifications', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_notifications', 0, 'submissi_osc1', 'PRIMARY', 2, 'customers_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_options', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_options_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_options', 0, 'submissi_osc1', 'PRIMARY', 2, 'language_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_options_values', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_options_values_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_options_values', 0, 'submissi_osc1', 'PRIMARY', 2, 'language_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_options_values_to_products_options', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_options_values_to_products_options_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_to_categories', 0, 'submissi_osc1', 'PRIMARY', 1, 'products_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'products_to_categories', 0, 'submissi_osc1', 'PRIMARY', 2, 'categories_id', 'A', 2, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'reviews', 0, 'submissi_osc1', 'PRIMARY', 1, 'reviews_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'reviews_description', 0, 'submissi_osc1', 'PRIMARY', 1, 'reviews_id', 'A', NULL, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'reviews_description', 0, 'submissi_osc1', 'PRIMARY', 2, 'languages_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'sessions', 0, 'submissi_osc1', 'PRIMARY', 1, 'sesskey', 'A', 6, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'specials', 0, 'submissi_osc1', 'PRIMARY', 1, 'specials_id', 'A', 0, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'tax_class', 0, 'submissi_osc1', 'PRIMARY', 1, 'tax_class_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'tax_rates', 0, 'submissi_osc1', 'PRIMARY', 1, 'tax_rates_id', 'A', 1, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'zones', 0, 'submissi_osc1', 'PRIMARY', 1, 'zone_id', 'A', 181, NULL, NULL, '', 'BTREE', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 0, 'submissi_osc1', 'PRIMARY', 1, 'association_id', 'A', 1, NULL, NULL, '', 'BTREE', ''); -- -------------------------------------------------------- -- -- Table structure for table `TABLES` -- CREATE TEMPORARY TABLE `TABLES` ( `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `TABLE_TYPE` varchar(64) NOT NULL default '', `ENGINE` varchar(64) default NULL, `VERSION` bigint(21) default NULL, `ROW_FORMAT` varchar(10) default NULL, `TABLE_ROWS` bigint(21) default NULL, `AVG_ROW_LENGTH` bigint(21) default NULL, `DATA_LENGTH` bigint(21) default NULL, `MAX_DATA_LENGTH` bigint(21) default NULL, `INDEX_LENGTH` bigint(21) default NULL, `DATA_FREE` bigint(21) default NULL, `AUTO_INCREMENT` bigint(21) default NULL, `CREATE_TIME` datetime default NULL, `UPDATE_TIME` datetime default NULL, `CHECK_TIME` datetime default NULL, `TABLE_COLLATION` varchar(64) default NULL, `CHECKSUM` bigint(21) default NULL, `CREATE_OPTIONS` varchar(255) default NULL, `TABLE_COMMENT` varchar(80) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `TABLES` -- INSERT INTO `TABLES` (`TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `TABLE_TYPE`, `ENGINE`, `VERSION`, `ROW_FORMAT`, `TABLE_ROWS`, `AVG_ROW_LENGTH`, `DATA_LENGTH`, `MAX_DATA_LENGTH`, `INDEX_LENGTH`, `DATA_FREE`, `AUTO_INCREMENT`, `CREATE_TIME`, `UPDATE_TIME`, `CHECK_TIME`, `TABLE_COLLATION`, `CHECKSUM`, `CREATE_OPTIONS`, `TABLE_COMMENT`) VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 576, 0, 133291584, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=233016', ''), (NULL, 'information_schema', 'COLLATIONS', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 423, 0, 133901073, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=317299', ''), (NULL, 'information_schema', 'COLLATION_CHARACTER_SET_APPLICABILITY', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 387, 0, 133871427, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=346815', ''), (NULL, 'information_schema', 'COLUMNS', 'SYSTEM VIEW', 'MyISAM', 0, 'Dynamic', NULL, 0, 0, 281474976710655, 1024, 0, NULL, '2009-01-19 11:53:48', '2009-01-19 11:53:48', NULL, 'utf8_general_ci', NULL, 'max_rows=34861', ''), (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 2565, 0, 134059725, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=52326', ''), (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 4637, 0, 134129862, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=28944', ''), (NULL, 'information_schema', 'PROFILING', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 356, 0, 132726412, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=377016', ''), (NULL, 'information_schema', 'ROUTINES', 'SYSTEM VIEW', 'MyISAM', 0, 'Dynamic', NULL, 0, 0, 281474976710655, 1024, 0, NULL, '2009-01-19 11:53:48', '2009-01-19 11:53:48', NULL, 'utf8_general_ci', NULL, 'max_rows=36691', ''), (NULL, 'information_schema', 'SCHEMATA', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 3656, 0, 134069176, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=36711', ''), (NULL, 'information_schema', 'SCHEMA_PRIVILEGES', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 2179, 0, 134154493, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=61596', ''), (NULL, 'information_schema', 'STATISTICS', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 2679, 0, 134166999, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=50099', ''), (NULL, 'information_schema', 'TABLES', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 3641, 0, 134105312, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=36862', ''), (NULL, 'information_schema', 'TABLE_CONSTRAINTS', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 2504, 0, 134001560, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=53601', ''), (NULL, 'information_schema', 'TABLE_PRIVILEGES', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 2372, 0, 133989536, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=56584', ''), (NULL, 'information_schema', 'TRIGGERS', 'SYSTEM VIEW', 'MyISAM', 0, 'Dynamic', NULL, 0, 0, 281474976710655, 1024, 0, NULL, '2009-01-19 11:53:48', '2009-01-19 11:53:48', NULL, 'utf8_general_ci', NULL, 'max_rows=30608', ''), (NULL, 'information_schema', 'USER_PRIVILEGES', 'SYSTEM VIEW', 'MEMORY', 0, 'Fixed', NULL, 1986, 0, 134080818, 0, 0, NULL, NULL, NULL, NULL, 'utf8_general_ci', NULL, 'max_rows=67581', ''), (NULL, 'information_schema', 'VIEWS', 'SYSTEM VIEW', 'MyISAM', 0, 'Dynamic', NULL, 0, 0, 281474976710655, 1024, 0, NULL, '2009-01-19 11:53:48', '2009-01-19 11:53:48', NULL, 'utf8_general_ci', NULL, 'max_rows=60295', ''), (NULL, 'submissi_osc1', 'address_book', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 76, 76, 281474976710655, 3072, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'address_format', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 5, 97, 488, 281474976710655, 2048, 0, 6, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'banners', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 88, 88, 281474976710655, 2048, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'banners_history', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 4, 25, 100, 107374182399, 2048, 0, 5, '2008-02-13 10:40:21', '2008-02-19 14:50:58', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'categories', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 5, 20, 104, 281474976710655, 3072, 0, 26, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'categories_description', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 5, 25, 128, 281474976710655, 3072, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'configuration', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 143, 150, 21492, 281474976710655, 4096, 0, 144, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'configuration_group', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 15, 62, 940, 281474976710655, 2048, 0, 16, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'counter', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 1, 13, 13, 55834574847, 1024, 0, NULL, '2008-02-13 10:40:21', '2009-01-19 11:27:38', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'counter_history', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 0, 0, 0, 55834574847, 1024, 0, NULL, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'countries', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 239, 30, 7252, 281474976710655, 11264, 0, 240, '2008-07-17 00:31:36', '2008-07-17 00:31:36', '2008-07-17 00:31:36', 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'currencies', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 2, 40, 80, 281474976710655, 2048, 0, 3, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'customers', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 92, 92, 281474976710655, 2048, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'customers_basket', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'customers_basket_attributes', 'BASE TABLE', 'MyISAM', 9, 'Dynamic', 0, 0, 0, 4294967295, 1024, 0, 1, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'customers_info', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 1, 37, 37, 158913789951, 2048, 0, NULL, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'geo_zones', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 56, 56, 281474976710655, 2048, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'languages', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 40, 40, 281474976710655, 3072, 0, 4, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'manufacturers', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 10, '2008-07-17 00:31:36', '2008-07-17 00:31:36', '2008-07-17 00:31:36', 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'manufacturers_info', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'newsletters', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_products', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_products_attributes', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_products_download', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_status', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 4, 23, 92, 281474976710655, 3072, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_status_history', 'BASE TABLE', 'MyISAM', 9, 'Dynamic', 0, 0, 0, 4294967295, 1024, 0, 1, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'orders_total', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 1, '2008-07-17 00:31:36', '2008-07-17 00:31:36', '2008-07-17 00:31:36', 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 2, 44, 88, 281474976710655, 3072, 0, 30, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_attributes', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 0, 0, 455, 150323855359, 2048, 455, 28, '2008-02-13 10:40:21', '2008-02-19 16:00:54', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_attributes_download', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 28, 28, 281474976710655, 2048, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_description', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 2, 1282, 2564, 281474976710655, 3072, 0, 30, '2008-07-17 00:31:36', '2009-01-19 00:18:46', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_notifications', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 0, 0, 0, 73014444031, 1024, 0, NULL, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_options', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 20, 20, 281474976710655, 2048, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_options_values', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, NULL, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_options_values_to_products_options', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 0, 0, 143, 55834574847, 2048, 143, 14, '2008-02-13 10:40:21', '2008-02-19 16:02:51', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'products_to_categories', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 2, 9, 243, 38654705663, 2048, 225, NULL, '2008-02-13 10:40:21', '2008-03-11 07:19:58', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'reviews', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 0, 0, 0, 281474976710655, 1024, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'reviews_description', 'BASE TABLE', 'MyISAM', 9, 'Dynamic', 0, 0, 76, 4294967295, 2048, 76, NULL, '2008-02-13 10:40:21', '2008-02-19 16:01:02', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'sessions', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 6, 438, 120812, 281474976710655, 12288, 118180, NULL, '2008-07-17 00:31:36', '2009-01-19 11:27:38', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'specials', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 0, 0, 248, 266287972351, 2048, 248, 5, '2008-02-13 10:40:21', '2008-02-19 16:01:02', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'tax_class', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 108, 108, 281474976710655, 2048, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'tax_rates', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 56, 56, 281474976710655, 2048, 0, 2, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'whos_online', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 1, 104, 4420, 281474976710655, 1024, 4316, NULL, '2008-07-17 00:31:36', '2009-01-19 11:27:38', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'zones', 'BASE TABLE', 'MyISAM', 10, 'Dynamic', 181, 28, 5120, 281474976710655, 4096, 0, 182, '2008-07-17 00:31:36', '2008-07-17 00:31:36', NULL, 'latin1_swedish_ci', NULL, '', ''), (NULL, 'submissi_osc1', 'zones_to_geo_zones', 'BASE TABLE', 'MyISAM', 9, 'Fixed', 1, 33, 33, 141733920767, 2048, 0, 2, '2008-02-13 10:40:21', '2008-02-13 10:40:21', NULL, 'latin1_swedish_ci', NULL, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `TABLE_CONSTRAINTS` -- CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( `CONSTRAINT_CATALOG` varchar(512) default NULL, `CONSTRAINT_SCHEMA` varchar(64) NOT NULL default '', `CONSTRAINT_NAME` varchar(64) NOT NULL default '', `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `CONSTRAINT_TYPE` varchar(64) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `TABLE_CONSTRAINTS` -- INSERT INTO `TABLE_CONSTRAINTS` (`CONSTRAINT_CATALOG`, `CONSTRAINT_SCHEMA`, `CONSTRAINT_NAME`, `TABLE_SCHEMA`, `TABLE_NAME`, `CONSTRAINT_TYPE`) VALUES (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'address_book', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'address_format', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'banners', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'banners_history', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'categories', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'categories_description', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'configuration', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'configuration_group', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'countries', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'currencies', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'customers', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'customers_basket', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'customers_basket_attributes', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'customers_info', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'geo_zones', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'languages', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'manufacturers', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'manufacturers_info', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'newsletters', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_products', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_products_attributes', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_products_download', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_status', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_status_history', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'orders_total', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_attributes', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_attributes_download', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_description', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_notifications', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_options', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_options_values', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_options_values_to_products_options', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'products_to_categories', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'reviews', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'reviews_description', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'sessions', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'specials', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'tax_class', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'tax_rates', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'zones', 'PRIMARY KEY'), (NULL, 'submissi_osc1', 'PRIMARY', 'submissi_osc1', 'zones_to_geo_zones', 'PRIMARY KEY'); -- -------------------------------------------------------- -- -- Table structure for table `TABLE_PRIVILEGES` -- CREATE TEMPORARY TABLE `TABLE_PRIVILEGES` ( `GRANTEE` varchar(81) NOT NULL default '', `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `PRIVILEGE_TYPE` varchar(64) NOT NULL default '', `IS_GRANTABLE` varchar(3) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `TABLE_PRIVILEGES` -- -- -------------------------------------------------------- -- -- Table structure for table `TRIGGERS` -- CREATE TEMPORARY TABLE `TRIGGERS` ( `TRIGGER_CATALOG` varchar(512) default NULL, `TRIGGER_SCHEMA` varchar(64) NOT NULL default '', `TRIGGER_NAME` varchar(64) NOT NULL default '', `EVENT_MANIPULATION` varchar(6) NOT NULL default '', `EVENT_OBJECT_CATALOG` varchar(512) default NULL, `EVENT_OBJECT_SCHEMA` varchar(64) NOT NULL default '', `EVENT_OBJECT_TABLE` varchar(64) NOT NULL default '', `ACTION_ORDER` bigint(4) NOT NULL default '0', `ACTION_CONDITION` longtext, `ACTION_STATEMENT` longtext NOT NULL, `ACTION_ORIENTATION` varchar(9) NOT NULL default '', `ACTION_TIMING` varchar(6) NOT NULL default '', `ACTION_REFERENCE_OLD_TABLE` varchar(64) default NULL, `ACTION_REFERENCE_NEW_TABLE` varchar(64) default NULL, `ACTION_REFERENCE_OLD_ROW` varchar(3) NOT NULL default '', `ACTION_REFERENCE_NEW_ROW` varchar(3) NOT NULL default '', `CREATED` datetime default NULL, `SQL_MODE` longtext NOT NULL, `DEFINER` longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `TRIGGERS` -- -- -------------------------------------------------------- -- -- Table structure for table `USER_PRIVILEGES` -- CREATE TEMPORARY TABLE `USER_PRIVILEGES` ( `GRANTEE` varchar(81) NOT NULL default '', `TABLE_CATALOG` varchar(512) default NULL, `PRIVILEGE_TYPE` varchar(64) NOT NULL default '', `IS_GRANTABLE` varchar(3) NOT NULL default '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- Dumping data for table `USER_PRIVILEGES` -- INSERT INTO `USER_PRIVILEGES` (`GRANTEE`, `TABLE_CATALOG`, `PRIVILEGE_TYPE`, `IS_GRANTABLE`) VALUES ('''submissi''@''localhost''', NULL, 'USAGE', 'NO'); -- -------------------------------------------------------- -- -- Table structure for table `VIEWS` -- CREATE TEMPORARY TABLE `VIEWS` ( `TABLE_CATALOG` varchar(512) default NULL, `TABLE_SCHEMA` varchar(64) NOT NULL default '', `TABLE_NAME` varchar(64) NOT NULL default '', `VIEW_DEFINITION` longtext NOT NULL, `CHECK_OPTION` varchar(8) NOT NULL default '', `IS_UPDATABLE` varchar(3) NOT NULL default '', `DEFINER` varchar(77) NOT NULL default '', `SECURITY_TYPE` varchar(7) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `VIEWS` --