CREATE TABLE 'creator' (
'file_id' int(11) NOT NULL auto_increment,
'project_id' int(11) NOT NULL default '0',
'file_name' tinytext NOT NULL,
'file_data' longtext NOT NULL,
'file_comment' text NOT NULL,
'change_date' datetime NOT NULL default '0000-00-00 00:00:00',
'user' tinytext,
'pumpkin_id' tinytext,
PRIMARY KEY ('file_id'),
UNIQUE KEY 'project_id' ('project_id','file_name'(255))
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--
-- Дамп данных таблицы 'creator'
--
INSERT INTO 'creator' VALUES (1, 1, 'test', 'test', 'test', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO 'creator' VALUES (2, 1, 'тест1', 'тест1', 'тест1', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO 'creator' VALUES (3, 1, 'тест2', 'тест1', '', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO 'creator' VALUES (4, 1, 'тест3', 'тест1', 'тест1', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO 'creator' VALUES (5, 1, 'тест4', 'тест1', '', '0000-00-00 00:00:00', NULL, NULL);
|