FriendsStore.migrations 399 B

1234567891011121314151617181920
  1. :VERSION 1
  2. BEGIN TRANSACTION
  3. CREATE TABLE [Friends] (
  4. [PrincipalID] uniqueidentifier NOT NULL,
  5. [Friend] varchar(255) NOT NULL,
  6. [Flags] char(16) NOT NULL DEFAULT '0',
  7. [Offered] varchar(32) NOT NULL DEFAULT 0)
  8. ON [PRIMARY]
  9. COMMIT
  10. :VERSION 2
  11. BEGIN TRANSACTION
  12. INSERT INTO Friends (PrincipalID, Friend, Flags, Offered) SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends;
  13. COMMIT