· 7 years ago · Oct 17, 2018, 10:44 AM
1CREATE TABLE IF NOT EXISTS `modx_ms_modAddress` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `uid` int(11) NOT NULL,
4 `receiver` varchar(255) NOT NULL,
5 `phone` varchar(20) NOT NULL,
6 `index` int(11) NOT NULL,
7 `region` varchar(100) NOT NULL,
8 `city` varchar(100) NOT NULL,
9 `metro` varchar(255) NOT NULL,
10 `street` varchar(255) NOT NULL,
11 `building` varchar(10) NOT NULL,
12 `room` varchar(10) NOT NULL,
13 `comment` text NOT NULL,
14 PRIMARY KEY (`id`),
15 KEY `uid` (`uid`)
16) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
17
18CREATE TABLE IF NOT EXISTS `modx_ms_modCategories` (
19 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
20 `gid` int(11) NOT NULL,
21 `cid` int(11) NOT NULL,
22 PRIMARY KEY (`id`),
23 KEY `gid` (`gid`,`cid`)
24) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
25
26CREATE TABLE IF NOT EXISTS `modx_ms_modDelivery` (
27 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
28 `wid` int(11) NOT NULL,
29 `name` varchar(255) NOT NULL,
30 `description` text NOT NULL,
31 `price` float(10,2) NOT NULL DEFAULT '0.00',
32 `add_price` float(10,2) NOT NULL DEFAULT '0.00',
33 `enabled` tinyint(1) NOT NULL DEFAULT '1',
34 `payments` varchar(255) NOT NULL DEFAULT '[]',
35 PRIMARY KEY (`id`),
36 KEY `wid` (`wid`),
37 KEY `payments` (`payments`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
39
40
41CREATE TABLE IF NOT EXISTS `modx_ms_modGallery` (
42 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
43 `wid` int(11) NOT NULL,
44 `gid` int(11) NOT NULL,
45 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
46 `description` text COLLATE utf8_unicode_ci NOT NULL,
47 `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
48 PRIMARY KEY (`id`),
49 UNIQUE KEY `wid` (`wid`,`gid`,`file`)
50) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
51
52
53CREATE TABLE IF NOT EXISTS `modx_ms_modGoods` (
54 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
55 `wid` int(11) NOT NULL DEFAULT '0',
56 `gid` int(11) NOT NULL DEFAULT '0',
57 `article` varchar(50) NOT NULL DEFAULT '0',
58 `price` float(10,2) NOT NULL DEFAULT '0.00',
59 `weight` float(10,3) NOT NULL DEFAULT '0.000',
60 `img` text NOT NULL,
61 `remains` int(11) NOT NULL DEFAULT '0',
62 `reserved` int(11) NOT NULL DEFAULT '0',
63 `add1` varchar(255) NOT NULL,
64 `add2` varchar(255) NOT NULL,
65 `add3` text NOT NULL,
66 PRIMARY KEY (`id`),
67 UNIQUE KEY `wid` (`wid`,`gid`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
69
70
71CREATE TABLE IF NOT EXISTS `modx_ms_modLog` (
72 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
73 `type` varchar(50) NOT NULL,
74 `oid` int(11) NOT NULL,
75 `iid` int(11) NOT NULL,
76 `operation` varchar(255) NOT NULL,
77 `old` text NOT NULL,
78 `new` text NOT NULL,
79 `uid` int(11) NOT NULL,
80 `ip` varchar(15) NOT NULL,
81 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
82 `comment` text,
83 PRIMARY KEY (`id`),
84 KEY `timestamp` (`timestamp`),
85 KEY `type` (`type`,`oid`)
86) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
87
88
89CREATE TABLE IF NOT EXISTS `modx_ms_modOrderedGoods` (
90 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
91 `gid` int(11) NOT NULL,
92 `oid` int(11) NOT NULL,
93 `num` int(11) NOT NULL DEFAULT '1',
94 `price` float(10,2) NOT NULL,
95 `weight` float(10,3) NOT NULL DEFAULT '0.000',
96 `sum` float(10,2) NOT NULL,
97 `data` text NOT NULL,
98 PRIMARY KEY (`id`),
99 KEY `gid` (`gid`,`oid`)
100) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
101
102
103CREATE TABLE IF NOT EXISTS `modx_ms_modOrders` (
104 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
105 `uid` int(11) NOT NULL,
106 `num` varchar(20) NOT NULL,
107 `wid` int(11) NOT NULL,
108 `status` tinyint(2) NOT NULL DEFAULT '1',
109 `sum` float(10,2) NOT NULL,
110 `weight` float(10,3) NOT NULL DEFAULT '0.000',
111 `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
112 `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
113 `comment` text NOT NULL,
114 `delivery` int(11) NOT NULL DEFAULT '0',
115 `payment` int(11) NOT NULL DEFAULT '0',
116 `address` int(11) NOT NULL DEFAULT '0',
117 PRIMARY KEY (`id`),
118 KEY `status` (`status`),
119 KEY `uid` (`uid`),
120 KEY `warehouse` (`wid`)
121) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
122
123
124CREATE TABLE IF NOT EXISTS `modx_ms_modPayment` (
125 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
126 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
127 `description` text COLLATE utf8_unicode_ci,
128 `snippet` int(11) NOT NULL DEFAULT '0',
129 PRIMARY KEY (`id`)
130) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
131
132
133CREATE TABLE IF NOT EXISTS `modx_ms_modStatus` (
134 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
135 `name` varchar(255) NOT NULL,
136 `color` char(6) NOT NULL DEFAULT '000000',
137 `email2user` tinyint(1) NOT NULL DEFAULT '0',
138 `email2manager` tinyint(1) NOT NULL DEFAULT '0',
139 `subject2user` varchar(255) NOT NULL,
140 `subject2manager` varchar(255) NOT NULL,
141 `body2user` int(10) DEFAULT '0',
142 `body2manager` int(10) DEFAULT '0',
143 PRIMARY KEY (`id`),
144 KEY `name` (`name`)
145) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
146
147
148CREATE TABLE IF NOT EXISTS `modx_ms_modTags` (
149 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
150 `rid` int(10) NOT NULL,
151 `gid` int(10) NOT NULL,
152 `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
153 PRIMARY KEY (`id`),
154 UNIQUE KEY `gid` (`gid`,`tag`)
155) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
156
157
158CREATE TABLE IF NOT EXISTS `modx_ms_modWarehouse` (
159 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
160 `name` varchar(255) NOT NULL,
161 `currency` varchar(20) NOT NULL,
162 `address` text NOT NULL,
163 `phone` varchar(20) NOT NULL,
164 `email` varchar(100) NOT NULL,
165 `description` text NOT NULL,
166 `permission` varchar(100) NOT NULL,
167 PRIMARY KEY (`id`),
168 KEY `name` (`name`)
169) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;