Radicore Forum: Transaction Patterns » Virtual Private Database and List 2 pattern

Home » RADICORE development » Transaction Patterns » Virtual Private Database and List 2 pattern (Entries from child table not visible)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Virtual Private Database and List 2 pattern [message #4198 is a reply to message #4197]

Tue, 03 June 2014 08:33

htManager
Messages: 439
Registered: May 2014

Senior Member

Sorry, do you mean the table structure? I sometimes do not know the exact meaning in german.

I also had some problems with difficult character sets, so I changed all character sets to utf8_unicode_ci.

Here is the SQL statement:

CREATE TABLE IF NOT EXISTS `htm_db_saisons` (
`rdcaccount_id` int(10) unsigned NOT NULL DEFAULT '1',
`verbaende_art_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`verbaende_kuerzel` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`vereine_kuerzel` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`saison_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`saison_start` date NOT NULL DEFAULT '2014-07-01',
`saison_ende` date NOT NULL DEFAULT '2015-06-30',
`created_date` datetime NOT NULL DEFAULT '2014-01-01 00:00:00',
`created_user` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`revised_date` datetime DEFAULT NULL,
`revised_user` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`rdcaccount_id`,`verbaende_art_id`,`verbaende_kuerzel`,`ver eine_kuerzel`,`saison_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `htm_db_vereine`
--

CREATE TABLE IF NOT EXISTS `htm_db_vereine` (
`rdcaccount_id` int(10) unsigned NOT NULL DEFAULT '1',
`verbaende_art_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'LV',
`verbaende_kuerzel` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`vereine_kuerzel` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`node_id` int(5) unsigned DEFAULT '0',
`vereine_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`vereine_name_zusatz` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_strasse` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_lkz` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_plz` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_ort` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_telefon` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_fax` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`vereine_website` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`created_date` datetime NOT NULL DEFAULT '2014-01-01 00:00:00',
`created_user` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`revised_date` datetime DEFAULT NULL,
`revised_user` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`rdcaccount_id`,`verbaende_art_id`,`verbaende_kuerzel`,`ver eine_kuerzel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Report message to a moderator

[Message index]

		Virtual Private Database and List 2 pattern By: htManager on Mon, 02 June 2014 10:48
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 04:45
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 05:42
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 06:56
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 08:33
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 09:58
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 10:37
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 10:54
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 10:57
		Re: Virtual Private Database and List 2 pattern By: htManager on Tue, 03 June 2014 11:12
		Re: Virtual Private Database and List 2 pattern By: AJM on Tue, 03 June 2014 11:32
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 04:03
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 04:30
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 05:06
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 05:35
		Re: Virtual Private Database and List 2 pattern By: htManager on Wed, 04 June 2014 10:44
		Re: Virtual Private Database and List 2 pattern By: AJM on Wed, 04 June 2014 13:01
		Re: Virtual Private Database and List 2 pattern By: htManager on Thu, 05 June 2014 03:44
		Re: Virtual Private Database and List 2 pattern By: AJM on Thu, 05 June 2014 04:06
		Re: Virtual Private Database and List 2 pattern By: AJM on Thu, 05 June 2014 09:54

Previous Topic:	MULTI5
Next Topic:	PopUpForm

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 04 21:36:22 EST 2024

Total time taken to generate the page: 0.01420 seconds