Changeset 6498
- Timestamp:
- Apr 10, 2008, 12:07:42 AM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.6-create_tables.sql
r6497 r6498 500 500 CREATE TABLE `c_diary_category` ( 501 501 `c_diary_category_id` int(11) NOT NULL auto_increment, 502 `category_name` text character set utf8 collate utf8_unicode_ciNOT NULL,502 `category_name` text NOT NULL, 503 503 `c_member_id` int(11) NOT NULL default '0', 504 504 `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', … … 594 594 CREATE TABLE `c_holiday` ( 595 595 `c_holiday_id` int(11) NOT NULL auto_increment, 596 `name` text character set utf8 collate utf8_unicode_ciNOT NULL,596 `name` text NOT NULL, 597 597 `month` int(11) NOT NULL default '0', 598 598 `day` int(11) NOT NULL default '0', … … 608 608 PRIMARY KEY (`c_image_id`), 609 609 KEY `filename` (`filename`(100)) 610 ) TYPE=MyISAM DEFAULT CHARSET=utf8MAX_ROWS=190000;610 ) TYPE=MyISAM MAX_ROWS=190000; 611 611 612 612 CREATE TABLE `c_ktai_address_pre` (
Note: See TracChangeset
for help on using the changeset viewer.