wdBc1gJB

1SQL1
2
3CREATE TABLE IF NOT EXISTS `sellchar_history` (
4`id` int(11) NOT NULL,
5  `name` varchar(50) NOT NULL,
6  `seller` int(11) NOT NULL,
7  `buyer` int(11) NOT NULL,
8  `price` int(11) NOT NULL
9) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
10
11
12ALTER TABLE `sellchar_history`
13ADD PRIMARY KEY (`id`);
14
15
16ALTER TABLE `sellchar_history`
17MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
18
19
20
21
22______________________________________________
23
24SQL2
25
26
27CREATE TABLE IF NOT EXISTS `sellchar` (
28`id` int(11) NOT NULL,
29  `name` varchar(40) NOT NULL,
30  `vocation` int(11) NOT NULL,
31  `price` int(11) NOT NULL,
32  `status` varchar(40) NOT NULL,
33  `oldid` varchar(40) NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
35
36
37ALTER TABLE `sellchar`
38ADD PRIMARY KEY (`id`);
39
40
41ALTER TABLE `sellchar`
42MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;