nzTZTPsX

1CREATE TABLE IF NOT EXISTS `ranking` (
2  `id`         INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
3  `pid`        INT(11)          NOT NULL,
4  `nickname`   VARCHAR(255)     NOT NULL,
5  `kingdom`    INT(11)          NOT NULL,
6  `profession`    INT(1)          NOT NULL,
7  `level`      INT(11)          NOT NULL,
8  `guild_name` VARCHAR(25)           DEFAULT NULL,
9  `playtime` INT(50)           DEFAULT NULL,
10  `last_play` DATETIME          DEFAULT NULL,
11  PRIMARY KEY (`id`)
12);
13
14CREATE TABLE IF NOT EXISTS `news` (
15  `id`         INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
16  `title`      VARCHAR(40)      NOT NULL,
17  `content`    TEXT             NOT NULL,
18  `created_at` DATETIME         NOT NULL,
19  `updated_at` DATETIME         NOT NULL,
20  PRIMARY KEY (`id`)
21);
22
23CREATE TABLE IF NOT EXISTS `itemshop_category` (
24  `id`     INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
25  `name`   VARCHAR(25)      NOT NULL,
26  `status` INT(1)           NOT NULL DEFAULT 0,
27  PRIMARY KEY (`id`)
28);
29
30CREATE TABLE IF NOT EXISTS `itemshop_products` (
31  `id`          INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
32  `item_vnum`   INT(11) UNSIGNED NOT NULL,
33  `item_name`   VARCHAR(25)      NOT NULL,
34  `price`       INT(5)           NOT NULL,
35  `description` TEXT                      DEFAULT NULL,
36  `category_id` INT(11) UNSIGNED NOT NULL,
37  PRIMARY KEY (`id`),
38  FOREIGN KEY (`category_id`) REFERENCES itemshop_category (`id`)
39);
40
41CREATE TABLE IF NOT EXISTS `itemshop_log` (
42  `id`          INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
43  `account_id`          INT(11) NOT NULL,
44  `product_id`   INT(11) UNSIGNED NOT NULL,
45  `item_name`   VARCHAR(25)      NOT NULL,
46  `price`       INT(5)           NOT NULL,
47  `cash_before` INT(20)          NOT NULL,
48  `cash_current` INT(20)  NOT NULL,
49  PRIMARY KEY (`id`)
50);
51
52CREATE TABLE IF NOT EXISTS `paypal` (
53  `id`     INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
54  `price`         DECIMAL(5, 2)    NOT NULL,
55  `value`         INT(11)          NOT NULL,
56  PRIMARY KEY (`id`)
57);
58
59CREATE TABLE IF NOT EXISTS `paypal_transactions` (
60  `id` INT(50) UNSIGNED NOT NULL AUTO_INCREMENT,
61  `user_id` INT(25) NOT NULL,
62  `transaction_id` VARCHAR(28) NOT NULL,
63  `packet_id` INT(11) UNSIGNED NOT NULL,
64  `success` INT(1) DEFAULT NULL,
65  `realisedDate` DATETIME NOT NULL,
66  PRIMARY KEY (`id`),
67  FOREIGN KEY (`packet_id`) REFERENCES paypal (`id`)
68);
69
70CREATE TABLE IF NOT EXISTS `homepay_sms` (
71  `id` INT(15) UNSIGNED NOT NULL AUTO_INCREMENT,
72  `service` INT(10) NOT NULL,
73  `content` VARCHAR(15) NOT NULL,
74  `number` INT(7) NOT NULL,
75  `price` INT(3) NOT NULL,
76  `value` INT(10) NOT NULL,
77  PRIMARY KEY (`id`)
78);