Changeset 21701 for branches/version-2_12-dev/html
- Timestamp:
- 2012/04/03 15:24:39 (12 years ago)
- Location:
- branches/version-2_12-dev/html/install/sql
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
r21653 r21701 866 866 ); 867 867 868 CREATE TABLE mtb_class (869 id smallint,870 name text,871 rank smallint NOT NULL DEFAULT 0,872 PRIMARY KEY (id)873 );874 875 868 CREATE TABLE mtb_status ( 876 869 id smallint, -
branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
r21676 r21701 868 868 ); 869 869 870 CREATE TABLE mtb_class (871 id smallint,872 name text,873 rank smallint NOT NULL DEFAULT 0,874 PRIMARY KEY (id)875 );876 877 870 CREATE TABLE mtb_status ( 878 871 id smallint, -
branches/version-2_12-dev/html/install/sql/drop_table.sql
r21502 r21701 73 73 DROP TABLE mtb_conveni_message; 74 74 DROP TABLE mtb_constants; 75 DROP TABLE mtb_class;76 75 DROP TABLE mtb_authority; 77 76 DROP TABLE mtb_allowed_tag; -
branches/version-2_12-dev/html/install/sql/insert_data.sql
r21699 r21701 766 766 INSERT INTO mtb_auth_excludes (id, name, rank) VALUES (0, 'index.php', 0); 767 767 INSERT INTO mtb_auth_excludes (id, name, rank) VALUES (1, 'logout.php', 1); 768 769 INSERT INTO mtb_class (id, name, rank) VALUES (1, '規格無し', 0);770 INSERT INTO mtb_class (id, name, rank) VALUES (2, '規格有り', 1);771 768 772 769 INSERT INTO mtb_db (id, name, rank) VALUES (1, 'PostgreSQL', 0);
Note: See TracChangeset
for help on using the changeset viewer.