Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* wiadomosc wlasciwa */
- CREATE TABLE IF NOT EXISTS `msg` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `senderId` int(11) unsigned NOT NULL,
- `title` varchar(256) COLLATE utf8_bin NOT NULL,
- `text` text COLLATE utf8_bin NOT NULL,
- `date` date NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
- /* pointer na msg */
- CREATE TABLE IF NOT EXISTS `msg_p` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `msgId` int(11) unsigned NOT NULL,
- `objectId` int(11) unsigned NOT NULL,
- `externals` text COLLATE utf8_bin NULL, /*zalaczniki*/
- `type` tinyint(3) unsigned NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement