git-svn-id: svn+ssh://svn.sourceforge.jp/svnroot/hirameki-note/trunk@9 a9a2e140-effa...

[hirameki-note/repo.git] / hirameki-note / src / main / php / install / create_database.mysql.php

diff --git a/hirameki-note/src/main/php/install/create_database.mysql.php b/hirameki-note/src/main/php/install/create_database.mysql.php
index 768548a..da10ebc 100644 (file)
--- a/hirameki-note/src/main/php/install/create_database.mysql.php
+++ b/hirameki-note/src/main/php/install/create_database.mysql.php
@@ -40,7 +40,7 @@
        \r
        $results = array();\r
        if (!$do_drop) {\r
-               $now = date("YmdHis");\r
+               $now = dt_now();\r
                \r
                // ユーザを作成します。\r
                $sql = "grant all privileges on *.* to '$user_name'@localhost identified by '$user_password'";\r
@@ -60,7 +60,7 @@
                $sql = <<< SQL_END\r
 create table article (\r
        id bigint not null,\r
-       create_time char(14) not null,\r
+       create_time bigint not null,\r
        enable tinyint not null,\r
        create_account_id bigint not null,\r
        title varchar(255),\r
@@ -75,7 +75,7 @@ SQL_END;
                $sql = <<< SQL_END\r
 create table account (\r
        id bigint not null,\r
-       create_time char(14) not null,\r
+       create_time bigint not null,\r
        enable tinyint not null,\r
        create_account_id bigint not null,\r
        name varchar(255) not null,\r
@@ -92,7 +92,7 @@ SQL_END;
                $sql = <<< SQL_END\r
 create table authority_group (\r
        id bigint not null,\r
-       create_time char(14) not null,\r
+       create_time bigint not null,\r
        enable tinyint not null,\r
        name varchar(255) not null,\r
        need_login tinyint not null,\r
@@ -114,26 +114,26 @@ SQL_END;
                $auth_group_anony_id = next_id($con, "authority_group_id", "next id authority group anonymous", &$results);\r
                $auth_group_user_id = next_id($con, "authority_group_id", "next id authority group user", &$results);\r
                \r
-               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_admin_id, '$now', 1, 'administrator', 1, 1, 1, 1, 1, 1, 1, 1)";\r
+               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_admin_id, $now, 1, 'administrator', 1, 1, 1, 1, 1, 1, 1, 1)";\r
                $sql_name = "insert authority_group administrator";\r
                execute_sql($con, $sql, $sql_name, &$results);\r
                \r
-               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_anony_id, '$now', 1, 'anonymous', 0, 1, 1, 1, 0, 0, 0, 1)";\r
+               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_anony_id, $now, 1, 'anonymous', 0, 1, 1, 1, 0, 0, 0, 1)";\r
                $sql_name = "insert authority_group anonymous";\r
                execute_sql($con, $sql, $sql_name, &$results);\r
                \r
-               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_user_id, '$now', 1, 'user', 1, 1, 1, 1, 1, 1, 1, 1)";\r
+               $sql = "insert into authority_group (id, create_time, enable, name, need_login, can_show_article_list, can_show_article_detail, can_search_article, can_create_article, can_update_article, can_delete_article, can_create_comment) values ($auth_group_user_id, $now, 1, 'user', 1, 1, 1, 1, 1, 1, 1, 1)";\r
                $sql_name = "insert authority_group user";\r
                execute_sql($con, $sql, $sql_name, &$results);\r
                \r
                $account_admin_id = next_id($con, "account_id", "next id account administrator", &$results);\r
                $account_anony_id = next_id($con, "account_id", "next id account anonymous", &$results);\r
                \r
-               $sql = "insert into account (id, create_time, enable, create_account_id, name, real_name, password, email, authority_group_id) values ($account_admin_id, '$now', 1, $account_admin_id, 'administrator', null, md5('administrator'), null, $auth_group_admin_id)";\r
+               $sql = "insert into account (id, create_time, enable, create_account_id, name, real_name, password, email, authority_group_id) values ($account_admin_id, $now, 1, $account_admin_id, 'administrator', null, md5('administrator'), null, $auth_group_admin_id)";\r
                $sql_name = "insert account administrator";\r
                execute_sql($con, $sql, $sql_name, &$results);\r
                \r
-               $sql = "insert into account (id, create_time, enable, create_account_id, name, real_name, password, email, authority_group_id) values ($account_anony_id, '$now', 1, $account_admin_id, 'anonymous', 'ゲスト', md5('anonymous'), null, $auth_group_anony_id)";\r
+               $sql = "insert into account (id, create_time, enable, create_account_id, name, real_name, password, email, authority_group_id) values ($account_anony_id, $now, 1, $account_admin_id, 'anonymous', 'ゲスト', md5('anonymous'), null, $auth_group_anony_id)";\r
                $sql_name = "insert account anonymous";\r
                execute_sql($con, $sql, $sql_name, &$results);\r
        } else {\r