| |
|
|
| | Подскажите пожалуйста как организовать таблици для Городской афиши.
Должна быть выборка по дате по тематике и по конкретному заведению.
Вот мой вариант:
-----------------------------------------------------------------------------------
CREATE TABLE 'content' (
'id' int(10) NOT NULL auto_increment,
'time' tinytext collate cp1251_general_cs NOT NULL,
'day' tinytext collate cp1251_general_cs NOT NULL,
'mounth' tinytext collate cp1251_general_cs NOT NULL,
'year' tinytext collate cp1251_general_cs NOT NULL,
'theme' tinytext collate cp1251_general_cs NOT NULL,
'author' tinytext collate cp1251_general_cs NOT NULL,
'kat' tinytext collate cp1251_general_cs NOT NULL,
'title' tinytext collate cp1251_general_cs NOT NULL,
'content' text collate cp1251_general_cs NOT NULL,
PRIMARY KEY ('id')
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs AUTO_INCREMENT=1 ;
-----------------------------------------------------------------------------------
CREATE TABLE 'users' (
'cid' int(10) NOT NULL auto_increment,
'login' tinytext collate cp1251_general_cs NOT NULL,
'pass' tinytext collate cp1251_general_cs NOT NULL,
'e_mail' tinytext collate cp1251_general_cs NOT NULL,
PRIMARY KEY ('cid')
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs AUTO_INCREMENT=1 ;
-----------------------------------------------------------------------------------
|
Поправьте если че не так! | |
| |
|
