diff options
| author | M.Gergo | 2021-02-20 03:22:41 +0100 |
|---|---|---|
| committer | M.Gergo | 2021-02-20 03:22:41 +0100 |
| commit | e472633f696d7e913b36875b258f4d45167388cc (patch) | |
| tree | e91387703cbcca7835f452d162fb27a4eac8ab50 /mayor-orig/mayor-portal/install | |
| parent | cf6a58003f47139501a2907f8a4bc400b23fda66 (diff) | |
| parent | fb24a50c54d5776468e49def08aea44c4077eb47 (diff) | |
| download | mayor-e472633f696d7e913b36875b258f4d45167388cc.tar.gz mayor-e472633f696d7e913b36875b258f4d45167388cc.zip | |
Az eredeti forráskódok frissítve a http://mayor.hu -ról
Diffstat (limited to 'mayor-orig/mayor-portal/install')
| -rw-r--r-- | mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql | 20 |
1 files changed, 15 insertions, 5 deletions
diff --git a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql index 842760b7..f53e34a7 100644 --- a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql +++ b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql @@ -41,7 +41,7 @@ CREATE TABLE `hirek` ( `lang` varchar(5) default 'hu_HU', `cim` text, `txt` text, - `owner` varchar(10) default NULL, + `owner` varchar(255) default NULL, `flag` tinyint(3) unsigned NOT NULL default '0', `cid` tinyint(3) unsigned NOT NULL default '0', `pic` varchar(20) default NULL, @@ -61,13 +61,23 @@ SET character_set_client = @saved_cs_client; DROP TABLE IF EXISTS `kategoriak`; CREATE TABLE `kategoriak` ( - `id` mediumint(8) unsigned NOT NULL default '0', - `leiras` varchar(70) NOT NULL default '', + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `leiras` varchar(70) NOT NULL DEFAULT '', `precode` text, - `postcode` text + `postcode` text, + UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1; - +DROP TABLE IF EXISTS `hirKategoria`; +CREATE TABLE `hirKategoria` ( + `hirId` int(10) unsigned NOT NULL, + `kategoriaId` mediumint(8) unsigned NOT NULL, + PRIMARY KEY (`hirId`,`kategoriaId`), + KEY `hirKategoria_FKIndex1` (`hirId`), + KEY `hirKategoria_FKIndex2` (`kategoriaId`), + CONSTRAINT `hirKategoria_ibfk_1` FOREIGN KEY (`hirId`) REFERENCES `hirek` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `hirKategoria_ibfk_2` FOREIGN KEY (`kategoriaId`) REFERENCES `kategoriak` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; -- -- Table structure for table `linkek` -- |