rtYJW1ZN

1CREATE TABLE IF NOT EXISTS `ps` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
4  `proc` int(11) NOT NULL DEFAULT '1' COMMENT 'Cik procentus dod klāt spējas ppaildpunkti',
5  PRIMARY KEY (`id`)
6) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
7
8CREATE TABLE IF NOT EXISTS `user` (
9  `id` int(32) NOT NULL,
10  `name` varchar(32) NOT NULL,
11  `surname` varchar(32) NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15CREATE TABLE IF NOT EXISTS `user_ps` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `user_id` int(11) NOT NULL,
18  `ps_id` int(11) NOT NULL,
19  `pts` int(11) NOT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;