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

Changeset 11742


Ignore:
Timestamp:
May 25, 2009, 12:24:24 PM (11 years ago)
Author:
kiwa
Message:

#3945:2.14beta1のセットアップSQL作成(PostgreSQL7.4)

Location:
OpenPNE/trunk/setup/sql/postgres74/install
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/postgres74/install/install-2.14beta1-create_tables.sql

    r11735 r11742  
    257257  c_member_id_admin int4 NOT NULL default '0',
    258258  c_member_id_sub_admin int4 NOT NULL default '0',
    259   topic_authority varchar(20) NOT NULL default 'public',
    260259  info text NOT NULL,
    261260  c_commu_category_id int4 NOT NULL default '0',
     
    263262  r_date date NOT NULL default '0000-01-01',
    264263  image_filename text NOT NULL,
    265   public_flag varchar(20) NOT NULL default 'public',
    266264  is_send_join_mail smallint NOT NULL default '1',
    267265  is_regist_join smallint NOT NULL default '0',
    268266  u_datetime timestamp NOT NULL default '0000-01-01 00:00:00',
     267  is_admit varchar(20) NOT NULL default 'public',
     268  is_open varchar(20) NOT NULL default 'public',
     269  is_topic varchar(20) NOT NULL default 'member',
     270  is_comment varchar(20) NOT NULL default 'member',
    269271  PRIMARY KEY (c_commu_id)
    270272);
     
    295297);
    296298
    297 CREATE INDEX c_commu_id_c_memer_id_to ON c_commu_admin_invite(c_commu_id,c_member_id_to);
     299CREATE INDEX c_commu_id_c_member_id_to ON c_commu_admin_invite(c_commu_id,c_member_id_to);
    298300
    299301CREATE TABLE c_commu_category (
     
    764766  schedule_start_day int4 NOT NULL default '0',
    765767  u_datetime timestamp NOT NULL default '0000-01-01 00:00:00',
     768  is_search_result int4 NOT NULL default '1',
    766769  PRIMARY KEY  (c_member_id)
    767770);
  • OpenPNE/trunk/setup/sql/postgres74/install/install-2.14beta1-insert_data.sql

    r11735 r11742  
    3737INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'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=',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
    3838INSERT INTO c_image VALUES (nextval('c_image_c_image_id_seq'),'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==',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'gif');
    39 INSERT INTO c_member VALUES (nextval('c_member_c_member_id_seq'),'OpenPNE君',0,0,0,'private','public','','','','','0000-01-01 00:00:00',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'',0,1,1,1,0,1,'public',0,0,0,0,TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'));
     39INSERT INTO c_member VALUES (nextval('c_member_c_member_id_seq'),'OpenPNE君',0,0,0,'private','public','','','','','0000-01-01 00:00:00',TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),'',0,1,1,1,0,1,'public',0,0,0,0,TO_TIMESTAMP(NOW()::text, 'YYYY-MM-DD HH24:MI:SS'),1);
    4040INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'母または父の旧姓は?');
    4141INSERT INTO c_password_query VALUES (nextval('c_password_query_c_password_query_id_seq'),'運転免許証番号の下 5 桁は?');
Note: See TracChangeset for help on using the changeset viewer.