<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
    Microsoft ResX Schema 
    
    Version 2.0
    
    The primary goals of this format is to allow a simple XML format 
    that is mostly human readable. The generation and parsing of the 
    various data types are done through the TypeConverter classes 
    associated with the data types.
    
    Example:
    
    ... ado.net/XML headers & schema ...
    <resheader name="resmimetype">text/microsoft-resx</resheader>
    <resheader name="version">2.0</resheader>
    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
        <value>[base64 mime encoded serialized .NET Framework object]</value>
    </data>
    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
        <comment>This is a comment</comment>
    </data>
                
    There are any number of "resheader" rows that contain simple 
    name/value pairs.
    
    Each data row contains a name, and value. The row also contains a 
    type or mimetype. Type corresponds to a .NET class that support 
    text/value conversion through the TypeConverter architecture. 
    Classes that don't support this are serialized and stored with the 
    mimetype set.
    
    The mimetype is used for serialized objects, and tells the 
    ResXResourceReader how to depersist the object. This is currently not 
    extensible. For a given mimetype the value must be set accordingly:
    
    Note - application/x-microsoft.net.object.binary.base64 is the format 
    that the ResXResourceWriter will generate, however the reader can 
    read any of the formats listed below.
    
    mimetype: application/x-microsoft.net.object.binary.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
            : and then encoded with base64 encoding.
    
    mimetype: application/x-microsoft.net.object.soap.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64
    value   : The object must be serialized into a byte array 
            : using a System.ComponentModel.TypeConverter
            : and then encoded with base64 encoding.
    -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="metadata">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" />
              </xsd:sequence>
              <xsd:attribute name="name" use="required" type="xsd:string" />
              <xsd:attribute name="type" type="xsd:string" />
              <xsd:attribute name="mimetype" type="xsd:string" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="assembly">
            <xsd:complexType>
              <xsd:attribute name="alias" type="xsd:string" />
              <xsd:attribute name="name" type="xsd:string" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <data name="MSG_QTN_001" xml:space="preserve">
    <value>Input content registered?</value>
  </data>
  <data name="MSG_WAR_063" xml:space="preserve">
    <value>line has not been selected. </value>
  </data>
  <data name="MSG_WAR_062" xml:space="preserve">
    <value>Things except the cell to which the number of customers is displayed have been selected. </value>
  </data>
  <data name="MSG_WAR_045" xml:space="preserve">
    <value>{0} Please input it by the em-size katakana the peel. </value>
  </data>
  <data name="MSG_WAR_019" xml:space="preserve">
    <value>Product that has been selected exceeds three products. </value>
  </data>
  <data name="MSG_WAR_053" xml:space="preserve">
    <value>It is not possible to input it to "{0}" excluding the value from 0 to {1}. </value>
  </data>
  <data name="MSG_WAR_070" xml:space="preserve">
    <value>Sales history is not registered. </value>
  </data>
  <data name="MSG_WAR_055" xml:space="preserve">
    <value>Input cereal key is not correct. </value>
  </data>
  <data name="MSG_WAR_059" xml:space="preserve">
    <value>CSV file should be {0} row. </value>
  </data>
  <data name="MSG_WAR_023" xml:space="preserve">
    <value>{0} Because it drinks and the mistake is found in the content of the input, registration cannot be completed. 
Please confirm the content of the input. </value>
  </data>
  <data name="MSG_WAR_042" xml:space="preserve">
    <value>The value that exceeds {0} year cannot be input at the sales date. </value>
  </data>
  <data name="TTIP_002" xml:space="preserve">
    <value>Recommendation product list of each RFM rank. </value>
  </data>
  <data name="MSG_WAR_021" xml:space="preserve">
    <value>It failed in the automatic ticketing of the threshold because the data number registered in the sales history and the customer list was too little. </value>
  </data>
  <data name="MSG_WAR_033" xml:space="preserve">
    <value>Only the value from 0 to 999999999 can be input to {0}. </value>
  </data>
  <data name="MSG_INF_007" xml:space="preserve">
    <value>{0} was completed. </value>
  </data>
  <data name="MSG_INF_002" xml:space="preserve">
    <value>The file output was completed. </value>
  </data>
  <data name="MSG_WAR_003" xml:space="preserve">
    <value>The input authority name has already been registered. </value>
  </data>
  <data name="MSG_WAR_066" xml:space="preserve">
    <value>The {0}th line cannot check "Change" and "Deletion" because of the new registration. </value>
  </data>
  <data name="MSG_WAR_034" xml:space="preserve">
    <value>Only the alphanumeric character can be input to {0}. </value>
  </data>
  <data name="MSG_WAR_052" xml:space="preserve">
    <value>Because the calculation is not completed, the analysis result cannot be displayed. </value>
  </data>
  <data name="MSG_WAR_004" xml:space="preserve">
    <value>The screen cannot be displayed because there is no authority. </value>
  </data>
  <data name="MSG_WAR_043" xml:space="preserve">
    <value>Number of cases is exceeded in the maximum.
	Max Number {0}</value>
  </data>
  <data name="MSG_QTN_004" xml:space="preserve">
    <value>Is {0} begun?</value>
  </data>
  <data name="MSG_WAR_032" xml:space="preserve">
    <value>The password is not corresponding. </value>
  </data>
  <data name="MSG_ERR_003" xml:space="preserve">
    <value>Because the system file is not found, it is not possible to start. 
Please reinstall the application so that there is a possibility that the environment is broken. </value>
  </data>
  <data name="MSG_WAR_056" xml:space="preserve">
    <value>Because the values of {0} line eyes and {1} row eyes were illegal, the file input was interrupted. </value>
  </data>
  <data name="MSG_WAR_048" xml:space="preserve">
    <value>{0} failed. </value>
  </data>
  <data name="MSG_WAR_039" xml:space="preserve">
    <value>The value in which the unit price and the sales number are put exceeds {0}. </value>
  </data>
  <data name="MSG_WAR_012" xml:space="preserve">
    <value>"{0}" is not input. </value>
  </data>
  <data name="MSG_WAR_049" xml:space="preserve">
    <value>The number of lines in which either "New", "Change" or "Deletion" is checked exceed the maximum number({0}). </value>
  </data>
  <data name="MSG_WAR_018" xml:space="preserve">
    <value>{0} has not been selected. </value>
  </data>
  <data name="MSG_WAR_036" xml:space="preserve">
    <value>Because {0} exceeds {1} digits, it is not possible to register. </value>
  </data>
  <data name="MSG_WAR_035" xml:space="preserve">
    <value>{1} cannot be used for {0} . </value>
  </data>
  <data name="MSG_WAR_047" xml:space="preserve">
    <value>Values other than {2} years from {1} year cannot be input to "{0}". </value>
  </data>
  <data name="MSG_QTN_003" xml:space="preserve">
    <value>Is the line that has been selected deleted?</value>
  </data>
  <data name="MSG_QTN_002" xml:space="preserve">
    <value>Is the retrieval result cleared?</value>
  </data>
  <data name="MSG_WAR_058" xml:space="preserve">
    <value>{0} should be {1}.</value>
  </data>
  <data name="MSG_WAR_057" xml:space="preserve">
    <value>{0}：{1} has already been registered. </value>
  </data>
  <data name="MSG_INF_001" xml:space="preserve">
    <value>Registration was completed.</value>
  </data>
  <data name="MSG_WAR_072" xml:space="preserve">
    <value>Customer list is not input. </value>
  </data>
  <data name="MSG_ERR_004" xml:space="preserve">
    <value>Application cannot be started because it failed in the initialization of the data base. </value>
  </data>
  <data name="MSG_WAR_017" xml:space="preserve">
    <value>Cell has not been selected. </value>
  </data>
  <data name="MSG_WAR_031" xml:space="preserve">
    <value>Customer ID of the {0} line overlaps with other customers ID. </value>
  </data>
  <data name="MSG_ERR_002" xml:space="preserve">
    <value>Because the data folder of SQL Server had not been found, the data base was not able to be initialized. 
Please contact the manufacturer when not improving it even if SQL Server is reinstalled. </value>
  </data>
  <data name="MSG_WAR_064" xml:space="preserve">
    <value>Only either of one can be checked though "New", "Change", and "Deletion" of the {0} line have been two or more selected. </value>
  </data>
  <data name="MSG_WAR_050" xml:space="preserve">
    <value>Because customer ID({0}) is exceeding the amount of money({1}) of the maximum purchase, it is not possible to calculate. </value>
  </data>
  <data name="MSG_WAR_046" xml:space="preserve">
    <value>{0} is not correct as the date. </value>
  </data>
  <data name="MSG_WAR_051" xml:space="preserve">
    <value>Failed in reading the file.
Please confirm the thing with a correct format of the CSV file. </value>
  </data>
  <data name="MSG_WAR_037" xml:space="preserve">
    <value>Because the layout of the CSV file was different, the file input was interrupted. </value>
  </data>
  <data name="MSG_WAR_061" xml:space="preserve">
    <value>"New" or neither "Change" nor "Deletion" is checked. </value>
  </data>
  <data name="MSG_WAR_069" xml:space="preserve">
    <value>Sales history is not input. </value>
  </data>
  <data name="MSG_WAR_065" xml:space="preserve">
    <value>Because the {0} line is not a registration new line, "New" cannot be checked. </value>
  </data>
  <data name="MSG_WAR_030" xml:space="preserve">
    <value>Staff ID overlaps. </value>
  </data>
  <data name="MSG_WAR_029" xml:space="preserve">
    <value>Sales history included in "Calculation period covered" of "FM analysis" tab is not registered. </value>
  </data>
  <data name="MSG_WAR_038" xml:space="preserve">
    <value>A detailed screen cannot be displayed by the line where fixation doesn't end. </value>
  </data>
  <assembly alias="System.Windows.Forms" name="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  <data name="logo" type="System.Resources.ResXFileRef, System.Windows.Forms">
    <value>..\Resources\logo.bmp;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>
  </data>
  <data name="MSG_WAR_068" xml:space="preserve">
    <value>"{0}" is a compulsory input. </value>
  </data>
  <data name="MSG_WAR_071" xml:space="preserve">
    <value>Customer is not registered. </value>
  </data>
  <data name="MSG_WAR_002" xml:space="preserve">
    <value>"Staff ID" is not input. </value>
  </data>
  <data name="MSG_WAR_060" xml:space="preserve">
    <value>There is no data that can be displayed. 
Please data is registered in the sales history and the customer list, and confirm the thing that has been calculated. </value>
  </data>
  <data name="MSG_WAR_054" xml:space="preserve">
    <value>Because the maximum registration number({0}) is exceeded, it is not possible to fix it. </value>
  </data>
  <data name="MSG_WAR_020" xml:space="preserve">
    <value>Number of customers cannot select the cell of 0. </value>
  </data>
  <data name="MSG_ERR_001" xml:space="preserve">
    <value>Because SQLServer is not executed, the application cannot be started. </value>
  </data>
  <data name="MSG_INF_006" xml:space="preserve">
    <value>Reading was completed. </value>
  </data>
  <data name="MSG_WAR_001" xml:space="preserve">
    <value>Password is not input. </value>
  </data>
  <data name="MSG_WAR_016" xml:space="preserve">
    <value>It has already started. 
Impossible to multiple start. </value>
  </data>
  <data name="MSG_WAR_041" xml:space="preserve">
    <value>"{1}" of the "{0}" tab doesn't exceed the value of "{2}". </value>
  </data>
  <data name="MSG_WAR_073" xml:space="preserve">
    <value>Line has not been selected. </value>
  </data>
  <data name="MSG_WAR_044" xml:space="preserve">
    <value>Values other than 150 cannot be input from 0 to "{0}". </value>
  </data>
  <data name="MSG_WAR_022" xml:space="preserve">
    <value>Staff to whom input "Staff ID" and "Password" are corresponding is not registered. </value>
  </data>
  <data name="MSG_WAR_015" xml:space="preserve">
    <value>Data was not found. 
Please expand and retrieve the condition. </value>
  </data>
  <data name="TTIP_003" xml:space="preserve">
    <value>Hot selling product list of each RFM rank</value>
  </data>
  <data name="logo1" type="System.Resources.ResXFileRef, System.Windows.Forms">
    <value>..\Resources\logo1.bmp;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>
  </data>
  <data name="MSG_WAR_005" xml:space="preserve">
    <value>DB size exceeds 3GB. 
DB size that SQL Server 2005 Express corresponds is up to 4GB. 
Please examine the shift to a high-ranking edition. 

Present DB size：{0}GB</value>
  </data>
  <data name="MSG_WAR_006" xml:space="preserve">
    <value>Staff who registers first should make the authority "Manager". </value>
  </data>
  <data name="MSG_WAR_007" xml:space="preserve">
    <value>Authority has not been selected. </value>
  </data>
  <data name="MSG_WAR_008" xml:space="preserve">
    <value>Name is not input. </value>
  </data>
  <data name="MSG_WAR_009" xml:space="preserve">
    <value>Manager cannot be adjusted to 0 people. </value>
  </data>
  <data name="MSG_WAR_010" xml:space="preserve">
    <value>Staff who deletes it cannot delete it because of the log in inside. </value>
  </data>
  <data name="MSG_WAR_011" xml:space="preserve">
    <value>Name overlaps. </value>
  </data>
  <data name="SP_DROP_TABLE" xml:space="preserve">
    <value>CREATE PROCEDURE SP_DROP_TABLE
AS 
BEGIN 
	  
	SET NOCOUNT ON;  
	  
	if exists (select * from sysobjects where id = object_id(N'C02RFM') and OBJECTPROPERTY(id, N'IsUserTable') = 1)  
		DROP TABLE C02RFM; 
	  
	if exists (select * from sysobjects where id = object_id(N'C03お勧め商品_顧客毎') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C03お勧め商品_顧客毎;  
	  
	if exists (select * from sysobjects where id = object_id(N'C04お勧め商品_RFM') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C04お勧め商品_RFM;  
	  
	if exists (select * from sysobjects where id = object_id(N'C05売れ筋商品_RFM') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C05売れ筋商品_RFM;  
	  
	if exists (select * from sysobjects where id = object_id(N'C06顧客動向表') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
		DROP TABLE C06顧客動向表;
	  
	if exists (select * from sysobjects where id = object_id(N'C07顧客動向表_顧客') and OBJECTPROPERTY(id, N'IsUserTable') = 1)  
		DROP TABLE C07顧客動向表_顧客; 
	  
	if exists (select * from sysobjects where id = object_id(N'C08購買回数') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C08購買回数;  
	  
	if exists (select * from sysobjects where id = object_id(N'C09購買回数の内積') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C09購買回数の内積;  
	  
	if exists (select * from sysobjects where id = object_id(N'C10商品間の類似度') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C10商品間の類似度;  
	  
	if exists (select * from sysobjects where id = object_id(N'C11FM') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE C11FM;  

	if exists (select * from sysobjects where id = object_id(N'H01販売履歴') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H01販売履歴;  
	  
	if exists (select * from sysobjects where id = object_id(N'H02コンタクト履歴') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H02コンタクト履歴;  
	  
	if exists (select * from sysobjects where id = object_id(N'H03操作履歴') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H03操作履歴;  
	  
	if exists (select * from sysobjects where id = object_id(N'H04家族構成') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H04家族構成;

	if exists (select * from sysobjects where id = object_id(N'H05顧客補足') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H05顧客補足;

	if exists (select * from sysobjects where id = object_id(N'H06PR履歴') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H06PR履歴;

	if exists (select * from sysobjects where id = object_id(N'H07プロモーション予定') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H07プロモーション予定;

	if exists (select * from sysobjects where id = object_id(N'H08プロモーション予定_対象広告') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H08プロモーション予定_対象広告;

	if exists (select * from sysobjects where id = object_id(N'H09プロモーション予定_対象商品') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H09プロモーション予定_対象商品;

	if exists (select * from sysobjects where id = object_id(N'H10プロモーション予定_対象顧客') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H10プロモーション予定_対象顧客;

	if exists (select * from sysobjects where id = object_id(N'H11プロモーション実績') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H11プロモーション実績;

	if exists (select * from sysobjects where id = object_id(N'H12プロモーション実績_対象広告') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE H12プロモーション実績_対象広告;

	if exists (select * from sysobjects where id = object_id(N'M02商品') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
		DROP TABLE M02商品;
	  
	if exists (select * from sysobjects where id = object_id(N'M03顧客') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
		DROP TABLE M03顧客;
	  
	if exists (select * from sysobjects where id = object_id(N'M04属性') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
		DROP TABLE M04属性;
	  
	if exists (select * from sysobjects where id = object_id(N'M05RFM計算条件') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M05RFM計算条件;  
	  
	if exists (select * from sysobjects where id = object_id(N'M06メールテンプレート') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M06メールテンプレート;  
	  
	if exists (select * from sysobjects where id = object_id(N'M07スタッフ') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M07スタッフ;  
	  
	if exists (select * from sysobjects where id = object_id(N'M08オープン可能画面') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M08オープン可能画面;  
	  
	if exists (select * from sysobjects where id = object_id(N'M09属性区分') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M09属性区分;  
	  
	if exists (select * from sysobjects where id = object_id(N'M10広告') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		DROP TABLE M10広告;

	  
END</value>
  </data>
  <data name="SP_INSERT_初期値" xml:space="preserve">
    <value>CREATE PROCEDURE SP_INSERT_初期値
AS  
BEGIN  
	
	SET NOCOUNT ON;

	DELETE FROM [M09属性区分]
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (1, 0, '性別');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (2, 0, '計算日時');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (3, 0, '計算時間');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (4, 0, 'バージョン');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (5, 0, '試用版');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (6, 0, '各種設定');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (7, 0, 'シリアルキー認証');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (8, 1, 'バウンド');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (9, 1, 'ツール');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (10, 1, '役職');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (11, 1, '権限');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (12, 1, '画面名');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (13, 0, 'メルマガ許諾');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (14, 0, '拡張MSG表示');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (15, 1, '家族続柄');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (16, 0, 'PR区分');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (17, 1, '顧客補足情報');
	INSERT INTO [M09属性区分] ([属性区分No] ,編集フラグ, [区分名]) VALUES (18, 0, '選択言語');


	SET IDENTITY_INSERT [M04属性] ON;

	DELETE FROM [M04属性]
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 1, 1, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 2, 1, '男性' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 3, 1, '女性' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 4, 2, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 5, 3, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 6, 3, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 7, 3, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 8, 3, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 9, 3, '' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 10, 3, '' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 11, 3, '' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 12, 3, '' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 13, 4, '製品版' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 14, 5, '' ,0 ,getdate() ,0 ,getdate());  
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 15, 6, '顧客分析' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 84, 6, '180' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 85, 6, '0' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 16, 7, '1' ,0 ,getdate() ,0 ,getdate()); 
	-- 8：バウンド
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 17, 8, '' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 18, 8, 'アウトバウンド' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 19, 8, 'インバウンド' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 20, 8, 'その他' ,0 ,getdate() ,0 ,getdate()); 
	-- 9：ツール
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 21, 9, '' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 22, 9, 'メール' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 23, 9, '電話' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 24, 9, 'FAX' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 25, 9, '打ち合わせ' ,0 ,getdate() ,0 ,getdate()); 
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES ( 26, 9, 'その他' ,0 ,getdate() ,0 ,getdate()); 
	-- 10：役職
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (27 ,10 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (28 ,10 ,'社長' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (29 ,10 ,'部長' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (30 ,10 ,'課長' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (31 ,10 ,'社員' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (32 ,10 ,'アルバイト' ,0 ,getdate() ,0 ,getdate());
	-- 11：権限
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (33 ,11 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,11 ,'管理者' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,11 ,'一般ユーザー' ,0 ,getdate() ,0 ,getdate());
	-- 12：画面名
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (36 ,12 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (37 ,12 ,'販売履歴' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (38 ,12 ,'顧客一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (87 ,12 ,'顧客詳細' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (39 ,12 ,'商品一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (40 ,12 ,'PR履歴' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (86 ,12 ,'PR詳細' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (41 ,12 ,'計算' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (42 ,12 ,'FM分析' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (43 ,12 ,'RFM分析' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (44 ,12 ,'売れ筋商品一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (45 ,12 ,'お勧め商品一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (46 ,12 ,'相関商品一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (47 ,12 ,'顧客動向表' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (48 ,12 ,'顧客属性別割合' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (49 ,12 ,'バックアップ' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (50 ,12 ,'復元' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (51 ,12 ,'各種設定' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (52 ,12 ,'マスタ一覧' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (88 ,12 ,'マスタ設定メニュー' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (89 ,12 ,'言語選択' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (90 ,12 ,'各種システム設定' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (91 ,12 ,'システム設定メニュー' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (53 ,12 ,'操作履歴' ,0 ,getdate() ,0 ,getdate());
	-- 13：メルマガ許諾
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (54 ,13 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (55 ,13 ,'可' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (56 ,13 ,'不可' ,0 ,getdate() ,0 ,getdate());
	-- 14：拡張MSG表示
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (57 ,14 ,'1' ,0 ,getdate() ,0 ,getdate());
	-- 15：家族続柄
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (58 ,15 ,'祖父' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (59 ,15 ,'祖母' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (60 ,15 ,'父' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (61 ,15 ,'母' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (62 ,15 ,'夫' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (63 ,15 ,'妻' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (64 ,15 ,'兄' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (65 ,15 ,'弟' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (66 ,15 ,'姉' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (67 ,15 ,'妹' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (68 ,15 ,'子' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (69 ,15 ,'同居人' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (70 ,15 ,'友人' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (75 ,15 ,'ペット' ,0 ,getdate() ,0 ,getdate());
	-- 16：PR区分
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (71 ,16 ,'プロモーション' ,0 ,getdate() ,0 ,getdate());
	--INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (72 ,16 ,'アンケート' ,0 ,getdate() ,0 ,getdate());
	--INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (73 ,16 ,'キャンペーン' ,0 ,getdate() ,0 ,getdate());

	-- 17：顧客補足情報
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (76 ,17 ,'趣味' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (77 ,17 ,'職業' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (78 ,17 ,'勤務先' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (79 ,17 ,'出身地' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (80 ,17 ,'好きなTV番組' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (81 ,17 ,'お店を知った切っ掛け' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (82 ,17 ,'来店した切っ掛け' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (83 ,17 ,'お店の気に入っている点' ,0 ,getdate() ,0 ,getdate());
	-- 18：選択言語
	INSERT INTO [M04属性] ([属性No] ,[区分] ,[値] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (92 ,18 ,'' ,0 ,getdate() ,0 ,getdate());

	-- ラスト「属性No」=92
	SET IDENTITY_INSERT [M04属性] OFF;



	DELETE FROM [M08オープン可能画面]
	-- 管理者のオープン可能画面
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,37 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,38 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,87 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,39 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,40 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,86 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,41 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,42 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,43 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,44 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,45 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,46 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,47 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,48 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,49 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,50 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,51 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,52 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,88 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,89 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,90 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,91 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (34 ,53 ,1 ,0 ,getdate() ,0 ,getdate());
	-- 一般ユーザーのオープン可能画面
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,37 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,38 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,87 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,39 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,40 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,86 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,41 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,42 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,43 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,44 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,45 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,46 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,47 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,48 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,49 ,0 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,50 ,0 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,51 ,0 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,52 ,0 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,88 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,89 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,90 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,91 ,1 ,0 ,getdate() ,0 ,getdate());
	INSERT INTO [M08オープン可能画面] ([権限No] ,[画面No] ,[可不可] ,[登録スタッフNo] ,[登録日時] ,[更新スタッフNo] ,[更新日時]) VALUES (35 ,53 ,0 ,0 ,getdate() ,0 ,getdate());

	DELETE FROM [M05RFM計算条件]
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (1 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (2 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (3 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (4 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (5 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (6 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (7 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (8 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (9 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (10 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (11 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (12 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (13 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (14 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (15 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (16 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (17 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (18 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (19 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (20 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (21 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (22 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (23 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (24 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (25 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (26 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (27 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (28 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (29 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (30 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (31 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (32 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (33 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (34 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (35 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (36 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (37 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (38 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (39 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (40 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (41 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (42 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (43 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (44 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (45 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (46 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (47 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (48 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (49 ,'' ,0 ,getdate() ,0 ,getdate());
	INSERT INTO M05RFM計算条件 ([条件No],[値],[登録スタッフNo],[登録日時],[更新スタッフNo],[更新日時]) VALUES (50 ,'' ,0 ,getdate() ,0 ,getdate());


END</value>
  </data>
  <data name="SP_CREATE_INDEX" xml:space="preserve">
    <value>CREATE PROCEDURE SP_CREATE_INDEX 
AS
BEGIN
	 
	SET NOCOUNT ON; 
	 
	CREATE STATISTICS [_dta_stat_517576882_3_2_4] ON [dbo].[C02RFM]([F], [R], [M]); 
	 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_C02RFM_7_517576882__K2_K1_K3_K4] ON [dbo].[C02RFM]  
	( 
		[R] ASC, 
		[顧客No] ASC, 
		[F] ASC, 
		[M] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_517576882_1_3] ON [dbo].[C02RFM]([顧客No], [F]); 
	 
	CREATE STATISTICS [_dta_stat_373576369_10_9] ON [dbo].[H01販売履歴]([顧客No], [商品No]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K9_10] ON [dbo].[H01販売履歴]  
	( 
		[商品No] ASC 
	) 
	INCLUDE ( [顧客No]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K9_6] ON [dbo].[H01販売履歴]  
	( 
		[商品No] ASC 
	) 
	INCLUDE ( [販売個数]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K1] ON [dbo].[H01販売履歴] 
	( 
		[販売履歴No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY];  
	 
	CREATE NONCLUSTERED INDEX [_dta_index_M03顧客_7_69575286__K5] ON [dbo].[M03顧客]  
	( 
		[性別] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K8_7] ON [dbo].[H01販売履歴]  
	( 
		[顧客ID] ASC 
	) 
	INCLUDE ( [販売金額]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K10_K1_2] ON [dbo].[H01販売履歴]  
	( 
		[顧客No] ASC, 
		[販売履歴No] ASC 
	) 
	INCLUDE ( [販売日時]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_373576369_2_10] ON [dbo].[H01販売履歴]([販売日時], [顧客No]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K10_K2] ON [dbo].[H01販売履歴]  
	( 
		[顧客No] ASC, 
		[販売日時] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K10_K1_7] ON [dbo].[H01販売履歴]  
	( 
		[顧客No] ASC, 
		[販売履歴No] ASC 
	) 
	INCLUDE ( [販売金額]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_517576882_1_3_4] ON [dbo].[C02RFM]([顧客No], [F], [M]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_C02RFM_7_517576882__K3_K4_K2_K1] ON [dbo].[C02RFM]  
	( 
		[F] ASC, 
		[M] ASC, 
		[R] ASC, 
		[顧客No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K10] ON [dbo].[H01販売履歴]  
	( 
		[顧客No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K2] ON [dbo].[H01販売履歴]  
	( 
		[販売日時] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_373576369_1_2] ON [dbo].[H01販売履歴]([販売履歴No], [販売日時]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K2_K10_K1_7] ON [dbo].[H01販売履歴] 
	( 
		[販売日時] ASC, 
		[顧客No] ASC, 
		[販売履歴No] ASC 
	) 
	INCLUDE ( [販売金額]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY];  
	 
	CREATE CLUSTERED INDEX [_dta_index_C08購買回数_c_7_1093578934__K2] ON [dbo].[C08購買回数]  
	( 
		[商品No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_1093578934_2_1] ON [dbo].[C08購買回数]([商品No], [顧客No]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_M03顧客_7_69575286__K5_1_2_3_4_6_7_8_9_10_11] ON [dbo].[M03顧客]  
	( 
		[性別] ASC 
	) 
	INCLUDE ( [顧客No], 
	[顧客ID], 
	[氏名], 
	[氏名カナ], 
	[生年月日], 
	[郵便番号], 
	[住所], 
	[TEL], 
	[メールアドレス], 
	[備考]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_373576369_9_1] ON [dbo].[H01販売履歴]([商品No], [販売履歴No]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_7_373576369__K10_K1_K9] ON [dbo].[H01販売履歴]  
	( 
		[顧客No] ASC, 
		[販売履歴No] ASC, 
		[商品No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 
	 
	CREATE STATISTICS [_dta_stat_1045578763_2_1] ON [dbo].[C07顧客動向表_顧客]([顧客No], [動向No]); 
	 
	CREATE NONCLUSTERED INDEX [_dta_index_C07顧客動向表_顧客_7_1045578763__K1_K2] ON [dbo].[C07顧客動向表_顧客]  
	( 
		[動向No] ASC, 
		[顧客No] ASC 
	)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]; 

	CREATE STATISTICS [_dta_stat_1495676376_8_9_1_10_2] ON [dbo].[H01販売履歴]([顧客ID], [商品No], [販売履歴No], [顧客No], [販売日時]);
	
	CREATE STATISTICS [_dta_stat_1495676376_9_1_10_2] ON [dbo].[H01販売履歴]([商品No], [販売履歴No], [顧客No], [販売日時]);

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K1_K10_K8] ON [dbo].[H01販売履歴] 
	(
		[販売履歴No] ASC,
		[顧客No] ASC,
		[顧客ID] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY];
	
	CREATE STATISTICS [_dta_stat_1495676376_8_1] ON [dbo].[H01販売履歴]([顧客ID], [販売履歴No]);

	CREATE STATISTICS [_dta_stat_1684201050_15_2] ON [dbo].[M03顧客]([更新スタッフNo], [顧客ID]);
	
	CREATE NONCLUSTERED INDEX [_dta_index_M03顧客_5_1684201050__K2] ON [dbo].[M03顧客] 
	(
		[顧客ID] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY];

	CREATE STATISTICS [_dta_stat_1495676376_2_9_1] ON [dbo].[H01販売履歴]([販売日時], [商品No], [販売履歴No])

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K2_1_9] ON [dbo].[H01販売履歴] 
	(
		[販売日時] ASC
	)
	INCLUDE ( [販売履歴No],
	[商品No]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_M02商品_5_1540200537__K1_2_3_4] ON [dbo].[M02商品] 
	(
		[商品No] ASC
	)
	INCLUDE ( [商品ID],
	[商品名],
	[商品単価]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_M03顧客_5_1684201050__K5_K1_2_3_4_6_7_8_9_10] ON [dbo].[M03顧客] 
	(
		[性別] ASC,
		[顧客No] ASC
	)
	INCLUDE ( [顧客ID],
	[氏名],
	[氏名カナ],
	[生年月日],
	[郵便番号],
	[住所],
	[TEL],
	[メールアドレス]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_C11FM_5_1399676034__K1] ON [dbo].[C11FM] 
	(
		[年月] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_1399676034_4_3_2] ON [dbo].[C11FM]([M], [F], [顧客No])

	CREATE NONCLUSTERED INDEX [_dta_index_C11FM_5_1399676034__K2] ON [dbo].[C11FM] 
	(
		[顧客No] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_1399676034_2_4] ON [dbo].[C11FM]([顧客No], [M])

	CREATE NONCLUSTERED INDEX [_dta_index_C11FM_5_1399676034__K3_K4_K2] ON [dbo].[C11FM] 
	(
		[F] ASC,
		[M] ASC,
		[顧客No] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_647673355_1_2_3_5_4] ON [dbo].[C04お勧め商品_RFM]([R], [F], [M], [ランク], [商品No])

	CREATE NONCLUSTERED INDEX [_dta_index_C04お勧め商品_RFM_5_647673355__K4_K1_K2_K3_K5_6] ON [dbo].[C04お勧め商品_RFM] 
	(
		[商品No] ASC,
		[R] ASC,
		[F] ASC,
		[M] ASC,
		[ランク] ASC
	)
	INCLUDE ( [類似度]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_C04お勧め商品_RFM_5_647673355__K4_1_2_3_5] ON [dbo].[C04お勧め商品_RFM] 
	(
		[商品No] ASC
	)
	INCLUDE ( [R],
	[F],
	[M],
	[ランク]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_775673811_1_2_3_5] ON [dbo].[C05売れ筋商品_RFM]([R], [F], [M], [ランク])

	CREATE NONCLUSTERED INDEX [_dta_index_C05売れ筋商品_RFM_5_775673811__K4_K1_K2_K3_K5_6] ON [dbo].[C05売れ筋商品_RFM] 
	(
		[商品No] ASC,
		[R] ASC,
		[F] ASC,
		[M] ASC,
		[ランク] ASC
	)
	INCLUDE ( [販売数]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K10_1_2] ON [dbo].[H01販売履歴] 
	(
		[顧客No] ASC
	)
	INCLUDE ( [販売履歴No],
	[販売日時]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K2_K1_8_10] ON [dbo].[H01販売履歴] 
	(
		[販売日時] ASC,
		[販売履歴No] ASC
	)
	INCLUDE ( [顧客ID],
	[顧客No]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K3] ON [dbo].[H01販売履歴] 
	(
		[商品ID] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_1540200537_7_2] ON [dbo].[M02商品]([更新スタッフNo], [商品ID])

	CREATE NONCLUSTERED INDEX [_dta_index_M02商品_5_1540200537__K2_1] ON [dbo].[M02商品] 
	(
		[商品ID] ASC
	)
	INCLUDE ( [商品No]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_471672728_4_2] ON [dbo].[C02RFM]([M], [R])

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K9_K10_6] ON [dbo].[H01販売履歴] 
	(
		[商品No] ASC,
		[顧客No] ASC
	)
	INCLUDE ( [販売個数]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE NONCLUSTERED INDEX [_dta_index_H01販売履歴_5_1495676376__K10_K9] ON [dbo].[H01販売履歴] 
	(
		[顧客No] ASC,
		[商品No] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
/*
	CREATE NONCLUSTERED INDEX [_dta_index_C10商品間の類似度_5_853578079__K1] ON [dbo].[C10商品間の類似度] 
	(
		[計算元商品No] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

	CREATE STATISTICS [_dta_stat_5575058_4_1] ON [dbo].[C02RFM]([M], [顧客No])

	CREATE STATISTICS [_dta_stat_853578079_3_2] ON [dbo].[C10商品間の類似度]([類似度], [計算先商品No])

	CREATE STATISTICS [_dta_stat_853578079_1_2_3] ON [dbo].[C10商品間の類似度]([計算元商品No], [計算先商品No], [類似度])

	CREATE NONCLUSTERED INDEX [_dta_index_C10商品間の類似度_5_853578079__K2_K1_K3] ON [dbo].[C10商品間の類似度] 
	(
		[計算先商品No] ASC,
		[計算元商品No] ASC,
		[類似度] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
*/

	CREATE CLUSTERED INDEX [_dta_index_C12TMP商品間の類似度_c_5_238623893__K1] ON [dbo].[C12TMP商品間の類似度] 
	(
		[計算先商品No] ASC
	)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
	 
END</value>
  </data>
  <data name="SP_CREATE_TABLE" xml:space="preserve">
    <value>CREATE PROCEDURE SP_CREATE_TABLE 
AS
BEGIN
	 
	SET NOCOUNT ON; 
	 
	CREATE TABLE [dbo].[C02RFM](
		[顧客No] [int] NOT NULL CONSTRAINT [DF_C02RFM_顧客No]  DEFAULT ((0)),
		[R] [tinyint] NULL CONSTRAINT [DF_C02RFM_R]  DEFAULT ((0)),
		[F] [tinyint] NULL CONSTRAINT [DF_C02RFM_F]  DEFAULT ((0)),
		[M] [tinyint] NULL CONSTRAINT [DF_C02RFM_M]  DEFAULT ((0)),
	 CONSTRAINT [PK_C02RFM] PRIMARY KEY CLUSTERED 
	(
		[顧客No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C03お勧め商品_顧客毎](
		[顧客No] [int] NOT NULL CONSTRAINT [DF_C03お勧め商品_顧客毎_顧客No]  DEFAULT ((0)),
		[商品No] [int] NOT NULL CONSTRAINT [DF_C03お勧め商品_顧客毎_商品No]  DEFAULT ((0)),
		[類似度] [float] NULL CONSTRAINT [DF_C03お勧め商品_顧客毎_類似度]  DEFAULT ((0)),
	 CONSTRAINT [PK_C03お勧め商品_顧客毎] PRIMARY KEY CLUSTERED 
	(
		[顧客No] ASC,
		[商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C04お勧め商品_RFM](
		[R] [tinyint] NOT NULL CONSTRAINT [DF_C04お勧め商品_RFM_R]  DEFAULT ((0)),
		[F] [tinyint] NOT NULL CONSTRAINT [DF_C04お勧め商品_RFM_F]  DEFAULT ((0)),
		[M] [tinyint] NOT NULL CONSTRAINT [DF_C04お勧め商品_RFM_M]  DEFAULT ((0)),
		[商品No] [int] NOT NULL CONSTRAINT [DF_C04お勧め商品_RFM_商品No]  DEFAULT ((0)),
		[ランク] [int] NULL CONSTRAINT [DF_C04お勧め商品_RFM_ランク]  DEFAULT ((0)),
		[類似度] [float] NULL CONSTRAINT [DF_C04お勧め商品_RFM_類似度]  DEFAULT ((0)),
	 CONSTRAINT [PK_C04お勧め商品_RFM] PRIMARY KEY CLUSTERED 
	(
		[R] ASC,
		[F] ASC,
		[M] ASC,
		[商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C05売れ筋商品_RFM](
		[R] [tinyint] NOT NULL CONSTRAINT [DF_C05売れ筋商品_RFM_R]  DEFAULT ((0)),
		[F] [tinyint] NOT NULL CONSTRAINT [DF_C05売れ筋商品_RFM_F]  DEFAULT ((0)),
		[M] [tinyint] NOT NULL CONSTRAINT [DF_C05売れ筋商品_RFM_M]  DEFAULT ((0)),
		[商品No] [int] NOT NULL CONSTRAINT [DF_C05売れ筋商品_RFM_商品No]  DEFAULT ((0)),
		[ランク] [int] NULL CONSTRAINT [DF_C05売れ筋商品_RFM_ランク]  DEFAULT ((0)),
		[販売数] [bigint] NULL CONSTRAINT [DF_C05売れ筋商品_RFM_販売数]  DEFAULT ((0)),
	 CONSTRAINT [PK_C05売れ筋商品_RFM] PRIMARY KEY CLUSTERED 
	(
		[R] ASC,
		[F] ASC,
		[M] ASC,
		[商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C06顧客動向表](
		[動向No] [int] NOT NULL CONSTRAINT [DF_C06顧客動向表_動向No]  DEFAULT ((0)),
		[年] [smallint] NULL CONSTRAINT [DF_C06顧客動向表_年]  DEFAULT ((0)),
		[月] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_月]  DEFAULT ((0)),
		[RFM種別] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_RFM種別]  DEFAULT ((0)),
		[RFMランク] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_RFMランク]  DEFAULT ((0)),
		[顧客数] [int] NULL CONSTRAINT [DF_C06顧客動向表_顧客数]  DEFAULT ((0)),
		[Color_R] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_Color_R]  DEFAULT ((0)),
		[Color_G] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_Color_G]  DEFAULT ((0)),
		[Color_B] [tinyint] NULL CONSTRAINT [DF_C06顧客動向表_Color_B]  DEFAULT ((0)),
	 CONSTRAINT [PK_C06顧客動向表] PRIMARY KEY CLUSTERED 
	(
		[動向No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C07顧客動向表_顧客](
		[動向No] [int] NOT NULL CONSTRAINT [DF_C07顧客動向表_顧客_動向No]  DEFAULT ((0)),
		[顧客No] [int] NOT NULL CONSTRAINT [DF_C07顧客動向表_顧客_顧客No]  DEFAULT ((0)),
	 CONSTRAINT [PK_C07顧客動向表_顧客] PRIMARY KEY CLUSTERED 
	(
		[動向No] ASC,
		[顧客No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C08購買回数](
		[顧客No] [int] NOT NULL CONSTRAINT [DF_C08購買回数_顧客No]  DEFAULT ((0)),
		[商品No] [int] NOT NULL CONSTRAINT [DF_C08購買回数_商品No]  DEFAULT ((0)),
		[購買回数] [int] NULL CONSTRAINT [DF_C08購買回数_購買回数]  DEFAULT ((0)),
	 CONSTRAINT [PK_C08購買回数] PRIMARY KEY NONCLUSTERED 
	(
		[顧客No] ASC,
		[商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C09購買回数の内積](
		[計算元商品No] [int] NOT NULL CONSTRAINT [DF_C09購買回数の内積_計算元商品No]  DEFAULT ((0)),
		[計算先商品No] [int] NOT NULL CONSTRAINT [DF_C09購買回数の内積_計算先商品No]  DEFAULT ((0)),
		[購買回数の内積] [int] NULL CONSTRAINT [DF_C09購買回数の内積_購買回数の内積]  DEFAULT ((0)),
		[内積の絶対値] [int] NULL CONSTRAINT [DF_C09購買回数の内積_内積の絶対値]  DEFAULT ((0)),
	 CONSTRAINT [PK_C09購買回数の内積] PRIMARY KEY CLUSTERED 
	(
		[計算元商品No] ASC,
		[計算先商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[C10商品間の類似度](
		[計算元商品No] [int] NOT NULL CONSTRAINT [DF_C10商品間の類似度_計算元商品No]  DEFAULT ((0)),
		[計算先商品No] [int] NOT NULL CONSTRAINT [DF_C10商品間の類似度_計算先商品No]  DEFAULT ((0)),
		[類似度] [float] NULL CONSTRAINT [DF_C10商品間の類似度_類似度]  DEFAULT ((0)),
	 CONSTRAINT [PK_C10商品間の類似度] PRIMARY KEY CLUSTERED 
	(
		[計算元商品No] ASC,
		[計算先商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[C11FM](
		[年月] [datetime] NOT NULL CONSTRAINT [DF_C11FM_年]  DEFAULT (((1900)/(1))/(1)),
		[顧客No] [int] NOT NULL CONSTRAINT [DF_C11FM_顧客No]  DEFAULT ((0)),
		[F] [tinyint] NULL CONSTRAINT [DF_C11FM_F]  DEFAULT ((0)),
		[M] [tinyint] NULL CONSTRAINT [DF_C11FM_M]  DEFAULT ((0)),
	 CONSTRAINT [PK_C11FM] PRIMARY KEY CLUSTERED 
	(
		[年月] ASC,
		[顧客No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H01販売履歴](
		[販売履歴No] [int] IDENTITY(1,1) NOT NULL,
		[販売日時] [datetime] NULL CONSTRAINT [DF_H01販売履歴_販売日時]  DEFAULT (((1900)/(1))/(1)),
		[商品ID] [varchar](50) NULL CONSTRAINT [DF_H01販売履歴_商品ID]  DEFAULT (''),
		[商品名] [varchar](200) NULL CONSTRAINT [DF_H01販売履歴_商品名]  DEFAULT (''),
		[商品単価] [bigint] NULL,
		[販売個数] [bigint] NULL CONSTRAINT [DF_H01販売履歴_販売個数]  DEFAULT ((0)),
		[販売金額] [bigint] NULL,
		[顧客ID] [varchar](50) NULL CONSTRAINT [DF_H01販売履歴_顧客ID]  DEFAULT (''),
		[商品No] [int] NULL CONSTRAINT [DF_H01販売履歴_商品No]  DEFAULT ((0)),
		[顧客No] [int] NULL CONSTRAINT [DF_H01販売履歴_顧客No]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H01販売履歴_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H01販売履歴_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H01販売履歴_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H01販売履歴_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H01販売履歴] PRIMARY KEY CLUSTERED 
	(
		[販売履歴No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[H02コンタクト履歴](
		[コンタクト履歴No] [int] IDENTITY(1,1) NOT NULL,
		[顧客No] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_顧客No]  DEFAULT ((0)),
		[コンタクト日時] [datetime] NULL CONSTRAINT [DF_H02コンタクト履歴_コンタクト日時]  DEFAULT (((1900)/(1))/(1)),
		[件名] [varchar](200) NULL CONSTRAINT [DF_H02コンタクト履歴_件名]  DEFAULT (''),
		[本文] [varchar](2000) NULL CONSTRAINT [DF_H02コンタクト履歴_本文]  DEFAULT (''),
		[バウンドNo] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_バウンド区分]  DEFAULT ((0)),
		[ツールNo] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_ツール]  DEFAULT ((0)),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_H02コンタクト履歴_備考]  DEFAULT (''),
		[コンタクトスタッフNo] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_コンタクトスタッフNo]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H02コンタクト履歴_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H02コンタクト履歴_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H02コンタクト履歴_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H02コンタクト履歴] PRIMARY KEY CLUSTERED 
	(
		[コンタクト履歴No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H03操作履歴](
		[操作日時] [datetime] NULL CONSTRAINT [DF_H03操作履歴_操作日時]  DEFAULT (((1900)/(1))/(1)),
		[操作端末名] [varchar](100) NULL CONSTRAINT [DF_H03操作履歴_操作端末名]  DEFAULT (''),
		[操作スタッフ氏名] [varchar](200) NULL CONSTRAINT [DF_H03操作履歴_操作スタッフ氏名]  DEFAULT (''),
		[操作画面] [varchar](200) NULL CONSTRAINT [DF_H03操作履歴_操作画面]  DEFAULT (''),
		[操作内容] [varchar](8000) NULL CONSTRAINT [DF_H03操作履歴_操作内容]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H03操作履歴_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H03操作履歴_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H03操作履歴_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H03操作履歴_更新日時]  DEFAULT (((1900)/(1))/(1))
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[H04家族構成](
		[家族構成No] [int] IDENTITY(1,1) NOT NULL,
		[顧客No] [int] NULL CONSTRAINT [DF_H04家族構成_顧客No]  DEFAULT ((0)),
		[家族区分] [int] NULL CONSTRAINT [DF_H04家族構成_家族区分]  DEFAULT ((0)),
		[氏名] [varchar](100) NULL CONSTRAINT [DF_H04家族構成_氏名]  DEFAULT (''),
		[氏名カナ] [varchar](100) NULL CONSTRAINT [DF_H04家族構成_氏名カナ]  DEFAULT (''),
		[性別] [int] NULL CONSTRAINT [DF_H04家族構成_性別]  DEFAULT ((0)),
		[生年月日] [datetime] NULL CONSTRAINT [DF_H04家族構成_生年月日]  DEFAULT (((1900)/(1))/(1)),
		[郵便番号] [varchar](50) NULL CONSTRAINT [DF_H04家族構成_郵便番号]  DEFAULT (''),
		[住所] [varchar](200) NULL CONSTRAINT [DF_H04家族構成_住所]  DEFAULT (''),
		[TEL] [varchar](50) NULL CONSTRAINT [DF_H04家族構成_TEL]  DEFAULT (''),
		[メールアドレス] [varchar](100) NULL CONSTRAINT [DF_H04家族構成_メールアドレス]  DEFAULT (''),
		[顧客ID] [varchar](50) NULL CONSTRAINT [DF_H04家族構成_顧客ID]  DEFAULT (''),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_H04家族構成_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H04家族構成_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H04家族構成_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H04家族構成_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H04家族構成_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H04家族構成] PRIMARY KEY CLUSTERED 
	(
		[家族構成No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H05顧客補足](
		[顧客補足No] [int] IDENTITY(1,1) NOT NULL,
		[顧客No] [int] NULL CONSTRAINT [DF_H05顧客補足_顧客No]  DEFAULT ((0)),
		[補足名No] [int] NULL CONSTRAINT [DF_H05顧客補足_補足区分No]  DEFAULT ((0)),
		[補足内容] [varchar](200) NULL CONSTRAINT [DF_H05顧客補足_補足選択肢No]  DEFAULT (''),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_H05顧客補足_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H05顧客補足_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H05顧客補足_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H05顧客補足_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H05顧客補足_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H05顧客補足] PRIMARY KEY CLUSTERED 
	(
		[顧客補足No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H06PR履歴](
		[PR履歴No] [int] IDENTITY(1,1) NOT NULL,
		[PR区分No] [int] NULL CONSTRAINT [DF_H06PR履歴_PR区分No]  DEFAULT ((0)),
		[PR名] [varchar](200) NULL CONSTRAINT [DF_H06PR履歴_PR名]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H06PR履歴_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H06PR履歴_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H06PR履歴_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H06PR履歴_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H06PR履歴] PRIMARY KEY CLUSTERED 
	(
		[PR履歴No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H07プロモーション予定](
		[プロモーション予定No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H07プロモーション予定_PR履歴No]  DEFAULT ((0)),
		[公開予定日] [datetime] NULL CONSTRAINT [DF_H07プロモーション予定_公開予定日]  DEFAULT (((1900)/(1))/(1)),
		[予定期間fr] [datetime] NULL CONSTRAINT [DF_H07プロモーション予定_有効日数]  DEFAULT (((1900)/(1))/(1)),
		[予定期間to] [datetime] NULL CONSTRAINT [DF_H07プロモーション予定_実施期間to]  DEFAULT (((1900)/(1))/(1)),
		[総費用] [int] NULL CONSTRAINT [DF_H07プロモーション予定_総費用]  DEFAULT ((0)),
		[対象商品総数] [int] NULL CONSTRAINT [DF_H07プロモーション予定_対象商品総数]  DEFAULT ((0)),
		[対象既存顧客総数] [int] NULL CONSTRAINT [DF_H07プロモーション予定_対象既存顧客総数]  DEFAULT ((0)),
		[有効日数内の総売上] [int] NULL CONSTRAINT [DF_H07プロモーション予定_有効日数内の総売上]  DEFAULT ((0)),
		[新規顧客獲得数] [int] NULL CONSTRAINT [DF_H07プロモーション予定_新規顧客獲得数]  DEFAULT ((0)),
		[見込顧客獲得数] [int] NULL CONSTRAINT [DF_H07プロモーション予定_見込顧客獲得数]  DEFAULT ((0)),
		[掘起し顧客数] [int] NULL CONSTRAINT [DF_H07プロモーション予定_掘起し顧客数]  DEFAULT ((0)),
		[内容] [varchar](1000) NULL CONSTRAINT [DF_H07プロモーション予定_内容]  DEFAULT (''),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_H07プロモーション予定_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H07プロモーション予定_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H07プロモーション予定_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H07プロモーション予定_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H07プロモーション予定_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H07プロモーション予定] PRIMARY KEY CLUSTERED 
	(
		[プロモーション予定No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H08プロモーション予定_対象広告](
		[プロモーション予定_対象広告No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_PR履歴No]  DEFAULT ((0)),
		[広告No] [int] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_広告No]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H08プロモーション予定_対象広告_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H08プロモーション予定_対象広告] PRIMARY KEY CLUSTERED 
	(
		[プロモーション予定_対象広告No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H09プロモーション予定_対象商品](
		[プロモーション予定_対象商品No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_PR履歴No]  DEFAULT ((0)),
		[商品No] [int] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_商品No]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H09プロモーション予定_対象商品_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H09プロモーション予定_対象商品] PRIMARY KEY CLUSTERED 
	(
		[プロモーション予定_対象商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H10プロモーション予定_対象顧客](
		[プロモーション予定_対象顧客No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_PR履歴No]  DEFAULT ((0)),
		[顧客No] [int] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_顧客No]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H10プロモーション予定_対象顧客_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H10プロモーション予定_対象顧客] PRIMARY KEY CLUSTERED 
	(
		[プロモーション予定_対象顧客No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H11プロモーション実績](
		[プロモーション実績No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H11プロモーション実績_PR履歴No]  DEFAULT ((0)),
		[公開実施日] [datetime] NULL CONSTRAINT [DF_H11プロモーション実績_公開予定日]  DEFAULT (((1900)/(1))/(1)),
		[実施期間fr] [datetime] NULL CONSTRAINT [DF_H11プロモーション実績_有効日数]  DEFAULT (((1900)/(1))/(1)),
		[実施期間to] [datetime] NULL CONSTRAINT [DF_H11プロモーション実績_実施期間to]  DEFAULT (((1900)/(1))/(1)),
		[総費用] [int] NULL CONSTRAINT [DF_H11プロモーション実績_総費用]  DEFAULT ((0)),
		[内容] [varchar](1000) NULL CONSTRAINT [DF_H11プロモーション実績_内容]  DEFAULT (''),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_H11プロモーション実績_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H11プロモーション実績_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H11プロモーション実績_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H11プロモーション実績_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H11プロモーション実績_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H11プロモーション実績] PRIMARY KEY CLUSTERED 
	(
		[プロモーション実績No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[H12プロモーション実績_対象広告](
		[プロモーション実績_対象広告No] [int] IDENTITY(1,1) NOT NULL,
		[PR履歴No] [int] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_PR履歴No]  DEFAULT ((0)),
		[広告No] [int] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_広告No]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_H12プロモーション実績_対象広告_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_H12プロモーション実績_対象広告] PRIMARY KEY CLUSTERED 
	(
		[プロモーション実績_対象広告No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	CREATE TABLE [dbo].[M02商品](
		[商品No] [int] IDENTITY(1,1) NOT NULL,
		[商品ID] [varchar](50) NULL CONSTRAINT [DF_M02商品1_商品ID]  DEFAULT (''),
		[商品名] [varchar](200) NULL CONSTRAINT [DF_M02商品1_商品名]  DEFAULT (''),
		[商品単価] [bigint] NULL CONSTRAINT [DF_M02商品1_商品単価]  DEFAULT ((0)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M02商品_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M02商品_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M02商品_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M02商品_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M02商品1] PRIMARY KEY CLUSTERED 
	(
		[商品No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M03顧客](
		[顧客No] [int] IDENTITY(1,1) NOT NULL,
		[顧客ID] [varchar](50) NULL CONSTRAINT [DF_M03顧客_顧客ID]  DEFAULT (''),
		[氏名] [varchar](100) NULL CONSTRAINT [DF_M03顧客_氏名]  DEFAULT (''),
		[氏名カナ] [varchar](100) NULL CONSTRAINT [DF_M03顧客_氏名カナ]  DEFAULT (''),
		[性別] [int] NULL CONSTRAINT [DF_M03顧客_性別]  DEFAULT ((0)),
		[生年月日] [datetime] NULL CONSTRAINT [DF_M03顧客_年齢]  DEFAULT (((1900)/(1))/(1)),
		[郵便番号] [varchar](10) NULL CONSTRAINT [DF_M03顧客_郵便番号]  DEFAULT (''),
		[住所] [varchar](200) NULL CONSTRAINT [DF_M03顧客_住所]  DEFAULT (''),
		[TEL] [varchar](20) NULL CONSTRAINT [DF_M03顧客_TEL]  DEFAULT (''),
		[メールアドレス] [varchar](100) NULL CONSTRAINT [DF_M03顧客_メールアドレス]  DEFAULT (''),
		[メルマガ許諾] [int] NULL CONSTRAINT [DF_M03顧客_メルマガ配信]  DEFAULT ((1)),
		[備考] [varchar](2000) NULL CONSTRAINT [DF_M03顧客_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M03顧客_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M03顧客_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M03顧客_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M03顧客_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M03顧客] PRIMARY KEY CLUSTERED 
	(
		[顧客No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M04属性](
		[属性No] [int] IDENTITY(1,1) NOT NULL,
		[区分] [tinyint] NULL CONSTRAINT [DF_M04属性_区分]  DEFAULT ((0)),
		[値] [varchar](50) NULL CONSTRAINT [DF_M04属性_値]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M04属性_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M04属性_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M04属性_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M04属性_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M04属性] PRIMARY KEY CLUSTERED 
	(
		[属性No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M05RFM計算条件](
		[条件No] [tinyint] NOT NULL CONSTRAINT [DF_M05RFM計算条件_条件No]  DEFAULT ((0)),
		[値] [varchar](50) NULL CONSTRAINT [DF_M05RFM計算条件_値]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M05RFM計算条件_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M05RFM計算条件_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M05RFM計算条件_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M05RFM計算条件_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M05RFM計算条件] PRIMARY KEY CLUSTERED 
	(
		[条件No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M07スタッフ](
		[スタッフNo] [int] IDENTITY(1,1) NOT NULL,
		[スタッフID] [varchar](20) NULL CONSTRAINT [DF_M07スタッフ_スタッフID]  DEFAULT (''),
		[パスワード] [varchar](20) NULL CONSTRAINT [DF_M07スタッフ_パスワード]  DEFAULT (''),
		[役職No] [int] NULL CONSTRAINT [DF_M07スタッフ_役職No]  DEFAULT ((0)),
		[氏名] [varchar](200) NULL CONSTRAINT [DF_M07スタッフ_氏名]  DEFAULT (''),
		[権限No] [int] NULL CONSTRAINT [DF_M07スタッフ_権限No]  DEFAULT ((0)),
		[備考] [varchar](400) NULL CONSTRAINT [DF_M07スタッフ_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M07スタッフ_登録スタッフNo]  DEFAULT ((1)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M07スタッフ_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M07スタッフ_更新スタッフNo]  DEFAULT ((1)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M07スタッフ_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M07スタッフ] PRIMARY KEY CLUSTERED 
	(
		[スタッフNo] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M08オープン可能画面](
		[権限No] [int] NOT NULL CONSTRAINT [DF_M08オープン可能画面_権限No]  DEFAULT ((1)),
		[画面No] [int] NOT NULL CONSTRAINT [DF_M08オープン可能画面_オープン対象画面No]  DEFAULT ((1)),
		[可不可] [tinyint] NULL CONSTRAINT [DF_M08オープン可能画面_可不可]  DEFAULT ((1)),
		[登録スタッフNo] [int] NULL CONSTRAINT [DF_M08オープン可能画面_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NULL CONSTRAINT [DF_M08オープン可能画面_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NULL CONSTRAINT [DF_M08オープン可能画面_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NULL CONSTRAINT [DF_M08オープン可能画面_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M08オープン可能画面] PRIMARY KEY CLUSTERED 
	(
		[権限No] ASC,
		[画面No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M09属性区分](
		[属性区分No] [int] NOT NULL CONSTRAINT [DF_M09属性区分_属性区分No]  DEFAULT ((1)),
		[編集フラグ] [tinyint] NOT NULL CONSTRAINT [DF_M09属性区分_編集フラグ]  DEFAULT ((1)),
		[区分名] [varchar](100) NOT NULL CONSTRAINT [DF_M09属性区分_区分名]  DEFAULT (''),
	 CONSTRAINT [PK_M09属性区分] PRIMARY KEY CLUSTERED 
	(
		[属性区分No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
		 
	CREATE TABLE [dbo].[M10広告](
		[広告No] [int] IDENTITY(1,1) NOT NULL,
		[広告名] [varchar](100) NOT NULL CONSTRAINT [DF_M10広告_広告名]  DEFAULT (''),
		[担当者名] [varchar](50) NOT NULL CONSTRAINT [DF_M10広告_担当者名]  DEFAULT (''),
		[TEL] [varchar](20) NOT NULL CONSTRAINT [DF_M10広告_TEL]  DEFAULT (''),
		[FAX] [varchar](20) NOT NULL CONSTRAINT [DF_M10広告_FAX]  DEFAULT (''),
		[メールアドレス] [varchar](100) NOT NULL CONSTRAINT [DF_M10広告_メールアドレス]  DEFAULT (''),
		[URL] [varchar](500) NOT NULL CONSTRAINT [DF_M10広告_URL]  DEFAULT (''),
		[備考] [varchar](2000) NOT NULL CONSTRAINT [DF_M10広告_備考]  DEFAULT (''),
		[登録スタッフNo] [int] NOT NULL CONSTRAINT [DF_M10広告_登録スタッフNo]  DEFAULT ((0)),
		[登録日時] [datetime] NOT NULL CONSTRAINT [DF_M10広告_登録日時]  DEFAULT (((1900)/(1))/(1)),
		[更新スタッフNo] [int] NOT NULL CONSTRAINT [DF_M10広告_更新スタッフNo]  DEFAULT ((0)),
		[更新日時] [datetime] NOT NULL CONSTRAINT [DF_M10広告_更新日時]  DEFAULT (((1900)/(1))/(1)),
	 CONSTRAINT [PK_M10広告] PRIMARY KEY CLUSTERED 
	(
		[広告No] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]

	 
END</value>
  </data>
  <data name="SP_DROP_SP" xml:space="preserve">
    <value>CREATE PROCEDURE SP_DROP_SP
AS  
BEGIN  

SET NOCOUNT ON;

 if exists (select * from sysobjects where id = object_id(N'SP_CREATE_INDEX') )
  DROP PROCEDURE SP_CREATE_INDEX; 
 
 if exists (select * from sysobjects where id = object_id(N'SP_CREATE_TABLE') )
  DROP PROCEDURE SP_CREATE_TABLE; 
 
 if exists (select * from sysobjects where id = object_id(N'SP_DROP_SP') ) 
  DROP PROCEDURE SP_DROP_SP;

 if exists (select * from sysobjects where id = object_id(N'SP_DROP_TABLE') )  
  DROP PROCEDURE SP_DROP_TABLE;
 
 if exists (select * from sysobjects where id = object_id(N'SP_INSERT_初期値') )  
  DROP PROCEDURE SP_INSERT_初期値;


END</value>
  </data>
  <data name="MSG_INF_003" xml:space="preserve">
    <value>Staff's registration was completed. </value>
  </data>
  <data name="MSG_INF_004" xml:space="preserve">
    <value>Staff's update was completed. </value>
  </data>
  <data name="MSG_INF_005" xml:space="preserve">
    <value>Staff's deletion was completed. </value>
  </data>
  <data name="MSG_TTL_01" xml:space="preserve">
    <value>Start error</value>
  </data>
  <data name="MSG_WAR_014" xml:space="preserve">
    <value>Impossible to start because it failed in the initialization of DB. </value>
  </data>
  <data name="MSG_WAR_024" xml:space="preserve">
    <value>Because the probation was passed, the starting thing cannot be done. </value>
  </data>
  <data name="MSG_WAR_025" xml:space="preserve">
    <value>Please input {0} in the format of "yyyy/mm/dd". </value>
  </data>
  <data name="MSG_WAR_026" xml:space="preserve">
    <value>{0} of the {1} tab is not input. </value>
  </data>
  <data name="MSG_WAR_027" xml:space="preserve">
    <value>Things except the normal-width numerical value are input to "{0}" of the "{1}" tab. </value>
  </data>
  <data name="MSG_WAR_028" xml:space="preserve">
    <value>"Calculation period covered and end date" of the "{0}" tab doesn't exceed the value of "Calculation period covered and start date". </value>
  </data>
</root>