This is a Next.js project bootstrapped with create-next-app.
create database if not exists kiguapp character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create database if not exists kiguapp_shadow character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create user if not exists kiguapp@'%' identified by 'password';
grant all privileges on kiguapp.* to kiguapp@'%';
grant all privileges on kiguapp_shadow.* to kiguapp@'%';create database if not exists kiguapp_dev character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create database if not exists kiguapp_dev_shadow character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create user if not exists kiguapp_dev@'%' identified by 'password';
grant all privileges on kiguapp_dev.* to kiguapp_dev@'%';
grant all privileges on kiguapp_dev_shadow.* to kiguapp_dev@'%';create database if not exists kiguapp_release character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create database if not exists kiguapp_release_shadow character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create user if not exists kiguapp_release@'%' identified by 'password';
grant all privileges on kiguapp_release.* to kiguapp_release@'%';
grant all privileges on kiguapp_release_shadow.* to kiguapp_release@'%';create database if not exists kiguapp_release_test character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create database if not exists kiguapp_release_test_shadow character set utf8mb4 collate utf8mb4_ja_0900_as_cs_ks;
create user if not exists kiguapp_release_test@'%' identified by 'password';
grant all privileges on kiguapp_release_test.* to kiguapp_release_test@'%';
grant all privileges on kiguapp_release_test_shadow.* to kiguapp_release_test@'%';yarn prisma studioyarn prisma migrate dev --create-onlyでマイグレーションファイルだけを生成させる%s/COLLATE utf8mb4_ /COLLATE utf8mb4_ja_0900_as_cs_ks/gで置き換えするyarn prisma migrate devを実行する
mkcertを入れる
Ubuntu環境の場合は以下の通り
sudo apt install libnss3-tools
curl -JLO "https://dl.filippo.io/mkcert/latest?for=linux/amd64"
chmod +x mkcert-v*-linux-amd64
sudo cp mkcert-v*-linux-amd64 /usr/local/bin/mkcertその後、認証局を生成する
cd kigurumi-app
mkcert -installlocalhostの証明書を発行する
mkcert localhostイベント内イベントなどを管理する。
原則論理削除
First, run the development server:
npm run dev
# or
yarn devOpen http://localhost:3000 with your browser to see the result.
You can start editing the page by modifying pages/index.tsx. The page auto-updates as you edit the file.
yarn prisma studioyarn prisma migrate dev --create-onlyでマイグレーションファイルだけを生成させる%s/COLLATE utf8mb4_ /COLLATE utf8mb4_ja_0900_as_cs_ks/gで置き換えするyarn prisma migrate devを実行する
mkcertを入れる
Ubuntu環境の場合は以下の通り
sudo apt install libnss3-tools
curl -JLO "https://dl.filippo.io/mkcert/latest?for=linux/amd64"
chmod +x mkcert-v*-linux-amd64
sudo cp mkcert-v*-linux-amd64 /usr/local/bin/mkcertその後、認証局を生成する
cd kigurumi-app
mkcert -installlocalhostの証明書を発行する
mkcert localhostFirst, run the development server:
npm run dev
# or
yarn devOpen http://localhost:3000 with your browser to see the result.
You can start editing the page by modifying pages/index.tsx. The page auto-updates as you edit the file.
API routes can be accessed on http://localhost:3000/api/hello. This endpoint can be edited in pages/api/hello.ts.
The pages/api directory is mapped to /api/*. Files in this directory are treated as API routes instead of React pages.
To learn more about Next.js, take a look at the following resources:
- Next.js Documentation - learn about Next.js features and API.
- Learn Next.js - an interactive Next.js tutorial.
You can check out the Next.js GitHub repository - your feedback and contributions are welcome!
The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.
Check out our Next.js deployment documentation for more details.