· 7 years ago · Nov 26, 2018, 11:28 AM
1
2CREATE TABLE IF NOT EXISTS `media` (
3`id` int(11) NOT NULL,
4 `module` varchar(255) NOT NULL,
5 `module_id` int(11) NOT NULL,
6 `field` varchar(255) NOT NULL,
7 `filename` varchar(255) NOT NULL
8) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4;
9
10--
11-- Indexes for dumped tables
12--
13
14--
15-- Indexes for table `media`
16--
17ALTER TABLE `media`
18 ADD PRIMARY KEY (`id`);
19
20--
21-- AUTO_INCREMENT for dumped tables
22--
23
24--
25-- AUTO_INCREMENT for table `media`
26--
27ALTER TABLE `media`
28MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;