7ebfwCCS

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9
10CREATE TABLE IF NOT EXISTS `month` (
11`num` int(20) NOT NULL,
12  `name` varchar(50) NOT NULL
13) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
14
15INSERT INTO `month` (`num`, `name`) VALUES
16(1, 'محرم'),
17(2, 'صفر'),
18(3, 'ربيع أول'),
19(4, 'ربيع ثاني'),
20(5, 'جمادي أول'),
21(6, 'جمادي ثاني'),
22(7, 'رجب'),
23(8, 'شعبان'),
24(9, 'رمضان'),
25(10, 'شوال'),
26(11, 'ذو القعدة'),
27(12, 'ذو الحجة');
28
29CREATE TABLE IF NOT EXISTS `test` (
30`autonum` int(50) NOT NULL,
31  `id` int(50) NOT NULL,
32  `year` int(50) NOT NULL
33) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
34
35INSERT INTO `test` (`autonum`, `id`, `year`) VALUES
36(1, 1, 1990),
37(2, 2, 1440),
38(3, 1, 1991),
39(4, 2, 1441);
40
41
42ALTER TABLE `month`
43 ADD PRIMARY KEY (`num`);
44
45ALTER TABLE `test`
46 ADD PRIMARY KEY (`autonum`);
47
48
49ALTER TABLE `month`
50MODIFY `num` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
51ALTER TABLE `test`
52MODIFY `autonum` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
53/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
54/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
55/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;