· 9 years ago · Nov 17, 2016, 10:36 AM
1CREATE TABLE IF NOT EXISTS `setting` (
2`id` int(5) NOT NULL,
3 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
4 `value` mediumtext CHARACTER SET utf8 NOT NULL
5) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;
6
7--
8-- Indexes for dumped tables
9--
10
11--
12-- Indexes for table `setting`
13--
14ALTER TABLE `setting`
15 ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`);
16
17--
18-- AUTO_INCREMENT for dumped tables
19--
20
21--
22-- AUTO_INCREMENT for table `setting`
23--
24ALTER TABLE `setting`
25MODIFY `id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=103;