ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 11853


Ignore:
Timestamp:
Jun 5, 2009, 5:37:06 PM (11 years ago)
Author:
imamura623
Message:

#3978:mysql40のセットアップSQLの変更

Location:
OpenPNE/branches/stable-2.14.x/setup/sql/mysql40/install
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.14.x/setup/sql/mysql40/install/install-2.14-create_tables.sql

    r11744 r11853  
     1
     2/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     3/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
     4/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
     5/*!40101 SET NAMES utf8 */;
     6/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
     7/*!40103 SET TIME_ZONE='+00:00' */;
     8/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
     9/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
     10/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
     11/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
     12
    113CREATE TABLE `biz_admin_config` (
    214  `biz_admin_config_id` int(11) NOT NULL auto_increment,
     
    737749  `schedule_start_day` int(11) NOT NULL default '0',
    738750  `u_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    739   `is_search_result` tinyint(1) NOT NULL default '1',
    740751  PRIMARY KEY  (`c_member_id`),
    741752  KEY `birth_year_c_member_id` (`birth_year`,`c_member_id`)
     
    12301241  PRIMARY KEY  (`portal_rss_id`)
    12311242) TYPE=MyISAM;
     1243/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
     1244
     1245/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
     1246/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
     1247/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
     1248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
     1249/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
     1250/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
     1251/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
     1252
     1253
  • OpenPNE/branches/stable-2.14.x/setup/sql/mysql40/install/install-2.14-insert_data.sql

    r11744 r11853  
     1
     2/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     3/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
     4/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
     5/*!40101 SET NAMES utf8 */;
     6/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
     7/*!40103 SET TIME_ZONE='+00:00' */;
     8/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
     9/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
     10/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
     11/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    112INSERT INTO `biz_admin_config` VALUES (NULL,'IS_CLOSED_SHISETSU','0');
    213INSERT INTO `c_action` VALUES (NULL,'入会する',0);
     
    3748INSERT INTO `c_image` VALUES (NULL,'r_3_gold.gif','R0lGODlheAAUAPcAAObdi+rimc7ASsi4Lcm5Nh8PAIxVD2oxAEIxDfDpsT4dAKqgdXY3AHA0AO7mqMvAUsi2HqSNAevim8GkV5iCE/DqsmMuAEojAOfekOHXf/PtueXZeubbh7agDKKWV9PCMcq+U7KbAMaxErykANLFV7afAOnhl+rhlffzy8ayNs3BW4FRF10rALWcANDAQtXIVqyNANfKVqmLAKqNANnNZ+fek+Lbl828LN/SbOHXhMCqHubejMCqALKeGPDqtM/BR+nhmeXah+LVbqmMGKuYUqyaV/LtuMm5N/jzzZ1wHqmWTe3lo8q6OdLAJtnJRenfk4dqENrPfc26QpdnGd/Vd8q6NdnKTs7BS8u4GePZhNbLZ8/CUcKuBc7BTfLrtc7ASbekJ9nOc/PtvFkwAsu8OdXFRricNuXaiOLalNnLbO3jm+bdie/nqtfLbt7VgMWxD4pPEbCcHMi4NdLFS6aPA+LZj4dMCsq6LtLCQci4LtbLa8i2Ke7mpqV+He3mpKacZuLVdMq4Ise0Hcu9R7mjAMq8PrSYAO/nreHXft3SfPj0zrWZAOXenc/ANq6dXcW0HrGYAJmCGfLqrbylAMi0GNXGS7OPRvbwxZl5NubekbmfAL2oANTFS55uKu7nrevjncu8PrCVALmjAXxLBtXJX+vinXxLB72kEpZkElAyBvDrtH9nMbOTMX1MC0cnA35vPbyjENXGYsCoAbuqI31MCcCoAFQoAGQ9ELivgYNTHKuXTaiVNrmYSlxJI3BjPYuAUt/WgZFdD6CBG9XIZKyEPaSYXX5xR8vCeJuFJJttFopzOYdUGYJTGsGuKjYmBqiBJ2FULp6STcOuQCoaA9/VgWpPI8/GhdzUjzgaAMGwLLqZT1o8CVVHJ+LapJqEHoJUCHJLF3hoFIJSGW1JF+LXgWNVM9LAazAdA4FDBb+iUisUAItTCyUSAJl1FIhdCpJqHuPZg8a1JcW0Hd7TdOHWe/DpsPfyytbKauHak9LAJaGAAPTuvs7EZK6UANvOYHw6ACH5BAAAAAAALAAAAAB4ABQAAAj/AP0JHEiwoMGDCBMqXMiwocOHMfZJnEixosWLGDNq3Mixo8eOMSr5gACB0yEhTprkW8mypcuXMGPKnEmzpk2aTZwIOcSJpI9KeBwIcsDhwwZJipCgsMe0qdOnUKNKnUq1qtWrUVEgUSRpwwcOQh3gaVTKBSArJy6J8VIhQYJ6cOPKnUu3brcFC3DVhYt3wd6/gAMLhuu2ghcxl05YAeSiVKMbT9ZgUaOBzZJPEiQE2My5s+fPn61xY6dAAbYCvzwbK1BaQQFfnRGwK/Dn858CuHOXuwa6t+/OmT8tYaNBDZY1T24EAlAGhxE/JjDsAEC9uvXr2LMfU2fhn3fvF4pV/4dm67t3W9wA7MCQy7sj7I7Me2eBIEr2+/ivrzfhxwiOMgAEQgk8IiTARw1nZAHPggw26OCDEMLTi3dwaDNBJ95Vs6AHLHhHzASWeGeBBwsy410RDxZBIYjeNfBKhDDGyGAWZ9TARwIiwEPJG/TUogoQQSBCz5BEFmnkkUgO2d0/5hCZTpHKeNcJkRj+s8qQ4nhHxJFEeLfMkLx4d0uSZJZZJCJBAFGBLPS8wcU8I3iSSQbz1GnnnXjmqWed0XxXJ26uFVDnON5hYicm3oFT5wreKZGnEt6tUKcuLe5p6aV4ZpCJJyPMwwUP8mhCxRx3PCLPqaimquqqrMozxHenyv93qjveQYEqFN59c+oo3lGwKgXejXIqsN61auyxqT5yxxxUaCIPD5vEswg5L5CxRzzYZqvtttx2i+134cQzxKveYduOd2PMgu0Y3rWDrSneRcJtJN6Zgi2u/wTj7b78arsHGS+Qs0g8m0wygCE50PBDFXkM4PDDEEcs8cQDnPvPBQhs48p3DoPhHQPnIDANA96B4TAt3qWCwMoIOOyNdwcg4MwF3glD8c04P5xHFT/QkIMhA0xCCAGiSAEMKV+AwsQRBDTt9NNQRy31OjAfQPI/yTjdx8dWe9eH0620eMDYBzSNzHcHNOAdKlK37TbURzAByhekUCOFKAQQUkIhcsDzkIYbWpCwRRdXCGD44YgnrvjizwSDzj8GJCFN4mZMYcc/dkxhBuLvGOD55wYYvgvokbOy+OmoJ35FF1uQoIUbacAgRyEltDBIDzrAEksdiYTRhh73BC/88MQXb/zxyCev/PLMG69HG2EkUscwp+jQwyAthPAAHQ9kI0MKUTBiAxr4lG/++einr/767Lfv/vvwq4+GDYxEkYIMzWz/QAiQqBBBBHEAQQdmoI8CGvCACEygAhfIwAY68IEQhOAMOgCCOPxPBZAIBT82yMEOevCDIAyhCEdIwhKa8IQmDEU/VsjCFrrwhTCMoQxnSMMa2vCGOAwIADs=',NOW(),'gif');
    3849INSERT INTO `c_image` VALUES (NULL,'r_4_platinum.gif','R0lGODlheAAUAPcAACUrNUpVZT5GUkZRYmp5jGJvgX2auDI5RB0hJ1lmeUBKW8TR4nWRrMLO3Pr//2+OpP///52zzMjT4uDo8vL4/8/b6NPe65muxd7n8pOow5+yytni76W3zLPC1eXt9xATF1diczY/TfP5/2Nvf3N+jWFtfrfE1XyDj3mBjVtoeufv+XN5gH6FkHeAjF5re56krDs/RC0zOz1GVp+msau7z3aTr3GMp5ujr+70/bzK21hhbnqXtZWrxOjv+eDo85WeqoeRoElUZW18kXeVsNvl8VVebJegrFVfbVdgbUtWZkxXZmhzgzA3RIyYqC00QKCzysrW5HKRqpGowL3L3XN9jOHo8rHB1Jiux560zeft9tbg66S2y/f8/+Ts9rTD1bPE2dvl8tnj79Hb6cfS4XGAk5OrxZSqw4Gcu4mft6W4zTpDUqe4zuLq9OLq809aa3eUsYKHjqC0y/D2/neUsHWDlnuXtnmVs6e5z6/A1Nbg7LXE1qS3y6Czy3KQqpywyJGow9zl8sfT4lJecLDA0/n+/7LB1M3a6Ki5z7jJ23SPqImiv/7//+Lr9pKapO/2/tfi7tni7nqWs+30/dPe6rjF18rV43STrKa4zXWTruvz/L3K2YGbtcvZ583Z5Yqgt4ylwLbF2dDc6vH3/1pibLbH2fT6//X7/yowO6W40NTg7dXg7HmWs67A0q/A0/b8/+vy/JSrxLPE1+Pr9tfg7NHb6HyZuLXE12ZyhHmGl8HO3pyvxU9ZZU9WYF9tfoyXpn+FjoaZs2l3iUlQW4ehu1Zjd8DJ1XWGm6SyxXuNoiAlLktXaaavvsTQ4Iydsqm4yjxBSdfe6Gd1h8PQ4IaVqJCkuaOrtY2arHyFkoWSpG9/lHyImmFwhX2HlmZxgYmcsXaClIqeuJylsp2ms5uvxI+gtjM7STY+S3mImnuKnWJob32LnIGIk/T5/6euuFtkdFpjcmNqdWVqcWZtd4miu213hXWDlIeUpVlld52vw1pndlZic42Wo77G0mRxhHiFln6EjCH5BAAAAAAALAAAAAB4ABQAQAj/ABcIHEiwoMGDCBMqXMiwocOHiizUYueBiCoLGDNmRKFAwTUL4ToqwMhRAQqNGuWJVCCjEUoL7jqK01jypIWSHZ8Z6XgE404FPS38HInxyMpGwlYaealRFREPIgxYUFTDRCITuqLsoZWlTZUJYMOKHUu2rNmzaNOqXVu2SpsstPZEGWfVRI07PVqFQiRrESFTIgJTGEy4sOHDiBMrXsy4sWPDgUWYIrRIFqJQrXrc2aFhCKRAVtI80UC6NOkSHaOZLo1awYEYsGOc09AsxEqR5lYn6UjHdOsSpzsCTyAySekBHRHEANDxXundCsiJ7Ne69+rST9JYCQRpiIYdpErx/+ABSpShL1giqF/Pvr379/Djy59Pv/58LF8MiQI1vhSpKxjEwokrr3ThAwYIJoggC7cp4EQ6C3bEgoIUPiPSLwrq0GBHM2DAoAITethRCP9gMENHOiB4ogIpmihSghp2BA8G7cggUocUJuhDF6+4wkksGFxRSwariGELH2ZkoOSSS6bQoDLAKOmkAikwuaQ+HQ1AnAJMgGNlEB0JweSUVWYw5TYdldNREEoKsWabIi0JpgLEcNnRlmJayaQZfNgixioZ1PIGDVtYAoUWY+RAiR5edOCooySAAAIJj1YaqaSYgtBEB+9Ias+j30hKT6VLSLrpo5dS2kGqjmIj6RKVWv9zixsKuHHLMaRK2oE2kjpz6amVeqEHJTmMoQUUlmxBwxuYNODss9BGK+201FZr7bXYZqtttphM4cC34IYr7rjklmvuueimq+666k6BBw6w4AAGKqlQAMG9+Oar77789uvvvwAHLLDAFKSCChjw4oBHHIwAUoYKXDiSSQ8qqODBxRev8MHGHMeDscYfrIDxyBfDwTE0I8PA8cofvOAByCK/vDEMF78wc803e2DzxhirvDEcFyPAscskV9xDJo5woUIZgDASxx8bfCKCJGwQEcYGWGeN9QkdUbEMNx05sXVHJ2itdTVqiMSE1vsAAUQAXbtdzAZcK1A23SKdws8NHSH/gTXfCvi9AeAKZI2E2huss9INZmsdBhFsSCLCJxv8cUYFO8jhQx4VdO755y10dMoHyXTUTeehK9DC55870ZEvHY3CegVFdPQD6B2tXkHqI/LSURGd//B78CJ5XrtIo9g25+2zf56HD3LsUMEZdVwwxCM5HOLHBdx3370LHQlCQDbIeA++Ai54370AHclwikj5qA+3AmSY31H6F5zfizErBcC9NyOixgWCEb7uzY+AWSpAR+qnPu/54RA5eMQQLlAHO3AgEqyYRS4KQYM1XIIDIAzhCDoyghCacIQsCYEKQ+APDuyiIwUIYUfUoA4TKqEjuDghCUGIwhLiQyRKCCE6jtpnm45MI4Q3VAAH5lQPFObQhCC8xBpoUIhczIIVkeCAHeYwCDRIYRjSwMAkOlEJCZjxjGhMoxrXyMY2uvGNcIxjGyvRiUlggBnzkAIaBjGHGmjCBjbwhAk20YcHGPKQiEykIhfJyEY68pGQjGQk+7AJE3gCkJqoAQM2yclOevKToAylKEdJylKa8pSoDAgAOw==',NOW(),'gif');
    39 INSERT INTO `c_member` VALUES (NULL,'OpenPNE君',0,0,0,'private','public','','','','','0000-00-00 00:00:00',NOW(),'',0,1,1,1,0,1,'public',0,0,0,0,NOW(),1);
     50INSERT INTO `c_member` VALUES (NULL,'OpenPNE君',0,0,0,'private','public','','','','','0000-00-00 00:00:00',NOW(),'',0,1,1,1,0,1,'public',0,0,0,0,NOW());
    4051INSERT INTO `c_module` VALUES (NULL,'portal',1);
    4152INSERT INTO `c_password_query` VALUES (NULL,'母または父の旧姓は?');
     
    234245INSERT INTO `portal_config` VALUES (NULL,'COLOR_TYPE','005_openpne_blue');
    235246
     247
     248
     249
     250
     251
     252
     253
     254
     255
     256
     257
     258
     259
     260/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
     261
     262/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
     263/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
     264/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
     265/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
     266/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
     267/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
     268/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
     269
     270
Note: See TracChangeset for help on using the changeset viewer.