>On Mon, Jul 29, 2002 at 07:45:10PM +0200, Axel Gebauer wrote: >> Hello, >> I have some wishes, too. The object article should get some new >> entities others should be changed. I am thinking of: >> - subtitle >Use parameters to store whatever you need and is absent from 'standard' >fields.
IMHO it would be more useful, to store subtitles in the article db and to avoid to build several work arounds. > > - calstart: datetime instead of date only >no, use appropriate PHP functions to format dates because many people want >to have dates formated according locale information and MySQL can't do it >for us in any case. If You are right the calstart-field would need the form INT for UNIX-timestamp, would'nt it? > > - author: varchar instead of int (?) >No, author is a link to person table's entry with the same id. > >> - extra1: varchar(64000) instead of varchar(255) >Don't see any sense, use parameters for that. At least one bigger field would be useful when You need to store sth. bigger. E.g. I had to store several links according to an article. I had to build a work around. Axel Gebauer >-- >/ Alexander Bokovoy >--- >jogger, n.: > An odd sort of person with a thing for pain. > +-----------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | up | int(11) | | | 0 | | | topic | int(11) | | MUL | 0 | | | title | varchar(255) | | | | | | abstract | longtext | | | | | | content | longtext | | | | | | author | int(11) | | | 0 | | | created | datetime | | | 0000-00-00 00:00:00 | | | url | varchar(255) | | | | | | calstart | date | YES | | NULL | | | caldays | int(11) | | | 0 | | | icon | int(11) | | | 0 | | | view | int(11) | | | 0 | | | print | int(11) | | | 0 | | | extra1 | varchar(255) | | | | | | extra2 | varchar(255) | | | | | | extra3 | varchar(255) | | | | | | name | varchar(255) | | MUL | | | | creator | int(11) | | | 0 | | | revisor | int(11) | | | 0 | | | revision | int(11) | | | 0 | | | approver | int(11) | | | 0 | | | revised | datetime | | | 0000-00-00 00:00:00 | | | approved | datetime | | | 0000-00-00 00:00:00 | | | score | int(11) | | | 0 | | | type | int(11) | | | 0 | | | locked | datetime | | | 0000-00-00 00:00:00 | | | locker | int(11) | | | 0 | | | sitegroup | int(11) | | MUL | 0 | | +-----------+--------------+------+-----+---------------------+----------------+ 29 rows in set (0.00 sec) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
