nijivzth

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    ON DELETE ON UPDATE CASCADE
40);
41
42CREATE TABLE IF NOT EXISTS `itemshop_log` (
43  `id`          INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
44  `account_id`          INT(11) NOT NULL,
45  `product_id`   INT(11) UNSIGNED NOT NULL,
46  `item_name`   VARCHAR(25)      NOT NULL,
47  `price`       INT(5)           NOT NULL,
48  `cash_before` INT(20)          NOT NULL,
49  `cash_current` INT(20)  NOT NULL,
50  PRIMARY KEY (`id`)
51);
52
53CREATE TABLE IF NOT EXISTS `paypal` (
54  `id`     INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
55  `price`         DECIMAL(5, 2)    NOT NULL,
56  `value`         INT(11)          NOT NULL,
57  PRIMARY KEY (`id`)
58);
59
60CREATE TABLE IF NOT EXISTS `paypal_transactions` (
61  `id` INT(50) UNSIGNED NOT NULL AUTO_INCREMENT,
62  `user_id` INT(25) NOT NULL,
63  `transaction_id` VARCHAR(28) NOT NULL,
64  `packet_id` INT(11) UNSIGNED NOT NULL,
65  `success` INT(1) DEFAULT NULL,
66  `realisedDate` DATETIME NOT NULL,
67  PRIMARY KEY (`id`),
68  FOREIGN KEY (`packet_id`) REFERENCES paypal (`id`)
69);
70
71CREATE TABLE IF NOT EXISTS `homepay_sms` (
72  `id` INT(15) UNSIGNED NOT NULL AUTO_INCREMENT,
73  `service` INT(10) NOT NULL,
74  `content` VARCHAR(15) NOT NULL,
75  `number` INT(7) NOT NULL,
76  `price` INT(3) NOT NULL,
77  `value` INT(10) NOT NULL,
78  PRIMARY KEY (`id`)
79);