Просмотр архива DCMS Special 6.1.0 beta

CREATE TABLE IF NOT EXISTS `smiles_dir` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) DEFAULT 'NULL',
  `pos` int(11)
DEFAULT '0',
  `level` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `smiles_dir` (`id`,
`name`, `pos`, `level`) VALUES
(1, 'Эмоции', 1, 0);

CREATE TABLE IF
NOT EXISTS `smiles_spis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(11) NOT NULL,
  `id_dir` int(50) NOT NULL,
  `sim` varchar(50) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


INSERT
INTO `smiles_spis` (`id`, `name`, `id_dir`, `sim`) VALUES
(1, '1', 1,
'*1'),
(2, '2', 1, '*2'),
(3, '3', 1, '*3'),
(4, '4', 1, '*4'),
(5, '5', 1,
'*5'),
(6, '6', 1, '*6'),
(7, '7', 1, '*7'),
(8, '8', 1, '*8'),
(9, '9', 1,
'*9'),
(10, '10', 1, '*10'),
(11, '11', 1, '*11'),
(12, '12', 1,
'*12'),
(13, '13', 1, '*13'),
(14, '14', 1, '*14'),
(15, '15', 1,
'*15'),
(16, '16', 1, '*16'),
(17, '17', 1, '*17'),
(18, '18', 1,
'*18'),
(19, '19', 1, '*19'),
(20, '20', 1, '*20'),
(21, '21', 1,
'*21'),
(22, '22', 1, '*22'),
(23, '23', 1, '*23'),
(24, '24', 1,
'*24'),
(25, '25', 1, '*25'),
(26, '26', 1, '*26'),
(27, '27', 1,
'*27'),
(28, '28', 1, '*28'),
(29, '29', 1, '*29'),
(30, '30', 1,
'*30'),
(31, '31', 1, '*31'),
(32, '32', 1, '*32');