Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.73 KB | None | 0 0
  1. /* wiadomosc wlasciwa */
  2. CREATE TABLE IF NOT EXISTS `msg` (
  3.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  4.   `senderId` int(11) unsigned NOT NULL,
  5.   `title` varchar(256) COLLATE utf8_bin NOT NULL,
  6.   `text` text COLLATE utf8_bin NOT NULL,
  7.   `date` date NOT NULL,
  8.   PRIMARY KEY (`id`)
  9. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
  10.  
  11. /* pointer na msg */
  12. CREATE TABLE IF NOT EXISTS `msg_p` (
  13.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  14.   `msgId` int(11) unsigned NOT NULL,
  15.   `objectId` int(11) unsigned NOT NULL,
  16.   `externals` text COLLATE utf8_bin NULL, /*zalaczniki*/
  17.   `type` tinyint(3) unsigned NOT NULL,
  18.   PRIMARY KEY (`id`)
  19. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement